Budgeting: Cash Collections, Finished Goods, and Direct Materials Budget (Discussion Notes)

Price/Demand Concept: Consumer Surplus

• The speaker mentions a term for when demand exceeds supply, leading to a price mark-up scenario: consumer surplus.
• Quick interpretation from the dialogue: if demand is higher than supply, prices tend to be higher, and consumers are willing to pay more than the current price.
• This ties into basic microeconomics of pricing and competition: prices adjust to balance demand and supply; higher demand relative to supply implies potential for higher prices and consumer surplus.

Cash Collections Schedule (30% in the month of sale; 65% in the following month)

• Core idea: cash collection follows a pattern where a portion of current month’s sales is collected this month, and a larger portion is collected in the next month.
• Sales dollars per month:
  $\text{SalesDollars}<em>M = \text{UnitsSold}</em>M \times \text{SellingPrice}.$
• Cash collected in month M (assuming 30% in the current month and 65% in the following month):
  $\text{CashCollected}<em>M = 0.30 \cdot \text{SalesDollars}</em>M + 0.65 \cdot \text{SalesDollars}_{M-1}.$
• If uncollectible accounts are considered (5% uncollectible):
  • CollectibleSales for month M: $\text{CollectibleSales}<em>M = (1-0.05) \cdot \text{SalesDollars}</em>M = 0.95 \cdot \text{SalesDollars}_M.$
  • Then cash collected in month M would be:
    $\text{CashCollected}<em>M = 0.30 \cdot \text{CollectibleSales}</em>M + 0.65 \cdot \text{CollectibleSales}_{M-1}.$
• The transcript’s interpretation (per problem discussion): treat the 5% uncollectible as not reflected in the monthly collection amounts. In that approach, cash collections come from the 30% current month and 65% of the prior month’s collectible sales; effectively:
  $\text{CashCollected}<em>M = 0.30 \cdot \text{SalesDollars}</em>M + 0.65 \cdot \text{SalesDollars}_{M-1}.$
• Practical month-by-month application (as discussed):
  • July cash collected depends on July sales and June sales: $\text{CashCollected}<em>{July} = 0.30 \cdot \text{SalesDollars}</em>{July} + 0.65 \cdot \text{SalesDollars}_{June}.$
  • August cash collected depends on August sales and July sales: $\text{CashCollected}<em>{Aug} = 0.30 \cdot \text{SalesDollars}</em>{Aug} + 0.65 \cdot \text{SalesDollars}_{July}.$
  • September cash collected depends on September sales and August sales: $\text{CashCollected}<em>{Sept} = 0.30 \cdot \text{SalesDollars}</em>{Sept} + 0.65 \cdot \text{SalesDollars}_{Aug}.$
• Summary of the approach used in the session:
  • Top line: cash collections depend on current month and prior month sales dollars.
  • Treat uncollectible as not reducing the cash collection amounts in the schedule (i.e., ignore the 5% in the calculation of monthly receipts for the purpose of the schedule).
  • Units, selling prices, and resulting sales dollars are the basis for the cash collection calculation.

How to compute Sales Dollars and the Monthly Schedule

• The schedule uses three rows in the budgeting template:
  • Row 1: Sales units per month (e.g., July, August, September).
  • Row 2: Selling price per unit (assumed constant unless stated otherwise).
  • Row 3: Sales dollars per month, computed as the product of units and price:
    $\text{SalesDollars}<em>M = \text{UnitsSold}</em>M \times \text{SellingPrice}.$
• Cash collections are then computed with the formulas above, using the prior month’s SalesDollars as the source for the 65% collection in the current month.
• Practical note from the discussion:
  • It helps to read the selling prices to accurately compute SalesDollars.
  • If you simply multiply all numbers by 12 to convert unit-period figures into annual dollars, you’ll still reach the same cash-collection totals once you have the per-month sales dollars, provided you keep the same per-month structure.

Finished Goods Budget: Beginning/Ending Inventories and Production

• Concept: Determine the number of finished goods units needed to meet next month’s sales and to maintain the desired ending inventory.
• The 15% rule (as discussed in the dialogue):
  • Ending finished goods inventory for a month is 15% of the next month's budgeted sales (in units).
  • Beginning finished goods inventory for a month is 15% of the current month’s budgeted sales (in units).
  • In the discussion, July beginning FG was calculated as 15% of July sales, and July ending FG as 15% of August sales; resulting values given as 10,500 units in the example (assuming August sales = 70,000 units, since 15% of 70,000 = 10,500).
• Production (budgeted production) for a month:
  $\text{BudgetedProduction}<em>M = \text{BudgetedSales}</em>M + \text{EndingFG}<em>M - \text{BeginningFG}</em>M.$
• Example results discussed:
  • July ending FG ≈ 10,500 units (assuming August budgeted sales = 70,000 units).
  • July beginning FG ≈ 10,500 units (computed as 15% of July sales).
  • September ending FG mentioned as 3,000 units in the dialogue.
  • October and further months follow the same logic with their respective budgeted sales.
• Note on interpretation:
  • Some problems present the ending inventory as 15% of the next month’s sales; others may present the beginning inventory as 15% of the current month’s sales. The dialogue reflects a teacher-student discussion about using 15% of each month’s sales to determine beginning and 15% of the next month’s sales for ending.

Direct Materials Budget (DM Budget)

• Context: Direct materials budget is built from the finished goods/production plan.
• Key data mentioned in the transcript:
  • Four feet of material required per unit produced: $\text{FeetPerUnit} = 4.$
  • Material cost: $\text{CostPerFoot} = 0.80.$
  • Therefore, DM cost per unit: $\text{CostPerUnitDM} = \text{FeetPerUnit} \times \text{CostPerFoot} = 4 \times 0.80 = 3.20.$
• DM budget steps:
  1) Determine the budgeted production for the month (units).
  2) Compute the total feet of materials needed for production:
  $\text{MaterialsNeededFeet}<em>M = \text{BudgetedProduction}</em>M \times \text{FeetPerUnit}.$
  3) Compute raw materials to be purchased, using beginning and ending DM inventory assumptions (not fully specified in the transcript, but the standard approach is):
  $\text{MaterialsToPurchase}<em>M = \text{MaterialsNeededFeet}</em>M + \text{EndingMaterialsFeet}<em>M - \text{BeginningMaterialsFeet}</em>M.$
  4) Cash disbursements for DM in month M:
  $\text{DMDisbursements}<em>M = \text{MaterialsToPurchase}</em>M \times \text{CostPerFoot}.$
• The transcript refers to two related schedules:
  • A DM budget schedule by month (based on production and materials required).
  • A cash disbursements schedule for direct materials (timing of payments).
• Totals mentioned in the discussion: 360,000 and 840,000 (likely DM totals for the three-month period or similar figures); the exact units/currency are not fully explicit in the transcript, but the structure is clear: multiply feet by cost to obtain dollars, and track purchases across months.

Worked Example Reflections and Key Pitfalls Discussed

• Common confusion points touched in the transcript:
  • How to treat the 5% uncollectible in the cash collections schedule: either include it as a separate line or ignore it if the schedule specifies 30% and 65% of the 100% collectible portion. The consensus in the discussion was to use only the 30% and 65% when the problem states those percentages add up to 100% of collectible receipts.
  • Whether to base beginning/ending finished goods inventories on current/next month’s sales: the discussion shows two plausible interpretations (beginning = 15% of current month’s sales; ending = 15% of next month’s sales). The practical outcome is to stay consistent with the interpretation the assignment requires.
  • Ambiguities in the numeric values for July/August/September cash collections: the dialogue includes specific numbers, but several digits appear unclear or mistyped. The key takeaway is to apply the formulas consistently and verify with the given budgeted sales and prices.
• Practical checklists from the session:
  • Always compute SalesDollarsM = UnitsSoldM × SellingPrice.
  • Use the cash collection formula with the chosen treatment of uncollectibles (either ignore 5% as in the classroom approach, or explicitly reduce collectible sales by 5%).
  • For finished goods and production budgeting, ensure BeginningFG and EndingFG are defined consistently (commonly BeginningFGM = 0.15 × BudgetedSalesM, EndingFGM = 0.15 × BudgetedSales{M+1}).
  • When calculating DM budgets, convert production needs into feet, then into dollar disbursements using the cost per foot, while tracking beginning/ending raw materials inventories.

Connections to Broader Topics and Real-World Relevance

• This transcript covers core components of an integrated master budget: sales budget, cash collections, finished goods inventory, production budget, and direct materials budget. The interdependencies among these schedules illustrate how changes in sales or prices propagate through cash flows, inventory levels, and materials purchases.
• Ethical and practical implications:
  • Accurately reflecting uncollectible accounts and timing of cash receipts affects reported liquidity and may influence operating decisions and financing needs.
  • Misinterpreting inventory assumptions (beginning vs ending) can lead to incorrect production planning and working capital estimates.
• Foundational principles:
  • Matching principle: align production and DM purchases with expected sales and inventory policies.
  • Liquidity planning: cash collections timing directly affects monthly cash availability.
  • Cost behavior: DM cost per unit is a fixed per-unit measure given feet-per-unit and cost per foot, which drives the total material budget.

Quick Reference Formulas (LaTeX-ready)

• Sales dollars per month:
  $\text{SalesDollars}<em>M = \text{UnitsSold}</em>M \times \text{SellingPrice}.$\
• Cash collections (no uncollectible adjustment):
  $\text{CashCollected}<em>M = 0.30 \cdot \text{SalesDollars}</em>M + 0.65 \cdot \text{SalesDollars}_{M-1}.$\
• Cash collections (with uncollectible adjustment):
  $\text{CollectibleSales}<em>M = (1-0.05)\cdot \text{SalesDollars}</em>M = 0.95 \cdot \text{SalesDollars}<em>M,$$\text{CashCollected}</em>M = 0.30 \cdot \text{CollectibleSales}<em>M + 0.65 \cdot \text{CollectibleSales}</em>{M-1}.$
• Finished goods budget (production):
  $\text{BudgetedProduction}<em>M = \text{BudgetedSales}</em>M + \text{EndingFG}<em>M - \text{BeginningFG}</em>M.$\
• Ending/Beginning FG inventories (typical convention):
  $\text{EndingFG}<em>M = 0.15 \times \text{BudgetedSales}</em>{M+1},\qquad \text{BeginningFG}<em>M = 0.15 \times \text{BudgetedSales}</em>M.$\
• Materials required for production (feet):
  $\text{MaterialsNeededFeet}<em>M = \text{BudgetedProduction}</em>M \times \text{FeetPerUnit}.$\
• Materials to purchase (feet):
  $\text{MaterialsToPurchase}<em>M = \text{MaterialsNeededFeet}</em>M + \text{EndingMaterialsFeet}<em>M - \text{BeginningMaterialsFeet}</em>M.$\
• Direct materials cost for purchases (dollars):
  $\text{DMDisbursements}<em>M = \text{MaterialsToPurchase}</em>M \times \text{CostPerFoot}.$\
• Direct materials per unit cost (if given FeetPerUnit and CostPerFoot):
  $\text{CostPerUnitDM} = \text{FeetPerUnit} \times \text{CostPerFoot}.$