Sunday, July 11, 2021

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:

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:

  1. Inventories are maintained at 30% of the following month’s sales.
  2. 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.
  3. 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