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

Answer:

Yipuum207

The expected cash collections for Yipuum207 in December is:

$318,000.

Explanation:

a) Data and Calculations:

                                   November     December

Budgeted sales          $305,000     $325,000

65% month of sale        198,250         211,250

35% month following     78,000         106,750

Total collections        $276,250       $318,000

b) The expected cash collection for December is made up of the 65% cash collected from December sales and the 35% of November sales.  Other months' sales will not affect the cash collection in December under the given scenario.  Therefore, the total cash collection for the month of December is $318,000.