Question

Data for Yipuum207, a large merchandiser, is below:

a. Sales are budgeted at $305,000 for November, $325,000 for December, and $225,000 for January.
b. Collections are expected to be 65% in the month of sale and 35% in the month following the sale.

The cost of goods sold is 80% of sales.
Yipuum207 desires to have an ending merchandise inventory at the end of each month equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase.

Other monthly expenses to be paid in cash are $22,600.
Monthly depreciation is $28,500.
Ignore taxes.
(ID#80825)


Assets
Cash $29,000
Accounts receivable 78,000
Merchandise inventory 182,400
Property, plant and equipment, net of $624,000 accumulated depreciation 1,006,000
Total assets $1,295,400

Liabilities and Stockholders' Equity
Accounts payable $241,000
Common stock 742,000
Retained earnings 312,400
Total liabilities and stockholders' equity $1,295,400

Required:
What are the expected cash collections for Yipuum207 in December?

Answer 1

$318,000

Step-by-step explanation

Calculation of expected cash collections in December

Expected cash collections in December = ($305,000*35%) + ($325,000*65%)

Expected cash collections in December = $106,750 + $211,250

Expected cash collections in December = $318,000

So, the expected cash collections for Yipuum207 in December is $318,000