Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: Sales are budgeted at $290,000 for November, $310,000 for December, and $210,000 for January. 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. The company 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 $21,100. Monthly depreciation is $21,000. Ignore taxes. Balance Sheet October 31 Assets Cash $ 25,000 Accounts receivable 77,000 Merchandise inventory 162,400 Property, plant and equipment, net of $624,000 accumulated depreciation 1,026,000 Total assets $ 1,290,400 Liabilities and Stockholders' Equity Accounts payable $ 239,000 Common stock 740,000 Retained earnings 311,400 Total liabilities and stockholders' equity $ 1,290,400 The difference between cash receipts and cash disbursements for December would be:

Respuesta :

Answer:

Dilly Farm Supply

The difference between cash receipts and cash disbursements for December would be -$123,000 ($303,000 - $426,700).

Explanation:

a) Data and Calculations:

Sales Projections:     November      December     January

Sales                         $290,000       $310,000      $210,000

Cash receipts 65%      188,500         201,500        136,500

Cash receipts 35%                             101,500        108,500

Total receipts            $188,500      $303,000     $245,000

Cost of goods sold  $232,000     $248,000      $168,000

Ending Inventory      $173,600        $117,600

Beginning Inventory                       $173,600       $117,600

Purchases =            $405,600       $192,000       $50,400

Payment for purchases                $405,600      $192,000

Other monthly exp.    $21,100          $21,100         $21,100

Cash Disbursement   $21,100      $426,700      $213,100

Balance Sheet as of October 31

Assets

Cash                                                                 $ 25,000

Accounts receivable                                           77,000

Merchandise inventory                                     162,400

Property, plant and equipment, net of

$624,000 accumulated depreciation         1,026,000

Total assets                                                $ 1,290,400

Liabilities and Stockholders' Equity

Accounts payable                                        $ 239,000

Common stock                                                740,000

Retained earnings                                            311,400

Total liabilities and stockholders' equity $ 1,290,400

Cash Budget for December:

Cash receipts from customers            $303,000

Other cash receipts (calculated)             148,700

Cash Disbursement                            ($426,700)

Cash Balance                                         $25,000