Fact Pattern: Tidwell Corporation sells a single product for $20 per unit. All sales are on account, with 60% collected in the month of sale and 40% collected in the following month. A partial schedule of cash collections for January through March of the coming year reveals the following receipts for the period:
Cash Receipts | |||
January | February | March | |
December receivables | $32,000 | ||
From January sales | 54,000 | $36,000 | |
From February sales | 66,000 | $44,000 | |
Other information includes the following:
- Inventories are maintained at 30% of the following month’s sales.
- Tidwell desires to keep a minimum cash balance of $15,000. Total payments in January are expected to be $106,500, which excludes $12,000 of depreciation expense. Any required borrowings are in multiples of $1,000.
- The December 31 balance sheet for the preceding year revealed a cash balance of $24,900.
March sales total $150,000. The number of units Tidwell must purchase in February is: 6,100 units
Projected sales for February total $110,000 ($66,000 + $44,000). Unit sales are thus expected to be 5,500 ($110,000 ÷ $20). March unit sales are projected at 7,500 ($150,000 ÷ $20). February purchases can thus be calculated as follows:
Needed for February sales | 5,500 |
Add: 30% of March sales | 2,250 |
Total units needed | 7,750 |
Less: Beginning inventory | (1,650) |
February purchases | 6,100 |
No comments:
Post a Comment