contestada

Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are budgeted at $280,000 for November, $290,000 for December, and $270,000 for January. Collections are expected to be 60% in the month of sale and 40% in the month following the sale. The cost of goods sold is 80% of sales. The company desires an ending merchandise inventory equal to 40% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. The November beginning balance in the accounts receivable account is $63,000. The November beginning balance in the accounts payable account is $250,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December.

Respuesta :

Answer and Explanation:

a. The preparation of Schedule of Expected Cash Collections for November and December is shown below:-

Schedule of Expected Cash Collections

for the month of November and December

Particulars                      November              December

Accounts receivable     $63,000

Sales                               $280,000             $290,000

Expected cash collection

in the month of sale 60%

collection                        $168,000                $112,000

                                      ($280,000 × 60%) ($280,000 × 40%)

Next month 40%

cash collection                                                $174,000

                                                                  ($290,000 × 60%)

Total cash collection    $231,000                 $286,000

b. The Preparation of Merchandise Purchases Budget for November and December is shown below:-

Particulars                 November      December    January

Cost of goods sold a

(80% of sale)               $224,000    $232,000       $216,000

                           ($280,000 × 80%) ($290,000 × 80%) ($270,000 × 80%)

Add: Ending

inventory b                    $92,800           $86,400

                                  ($232,000 × 40%) ($216,000 × 40%)

Total inventory             $316,800          $318,400

(c = a + b)

Less: Opening inventory d $89,600          $92,800

                                  ($224,000 × 40%)

Material to be

purchased                          $227,200         $225,600

(e = c - d)

anthougo

1. The preparation of the Schedule of Expected Cash Collections is as follows:

                                          November      December     January

Budgeted Sales                $280,000      $290,000    $270,000

Cash collections:

60% month of sale            $168,000       $174,000     $162,000

40% month following           63,000          112,000        116,000

Total cash collections     $231,000     $286,000

2. The preparation of the Merchandise Purchases Budget for November and December is as follows:

                                           November      December

Cost of goods sold             $168,000       $174,000     $162,000

Ending inventory                 $69,600        $64,800

Cost of goods available  $237,600      $238,800    

Beginning inventory           $67,200         $69,600

Purchases                         $170,400       $169,200

Learn more about preparing cash collections and purchases budgets here: https://brainly.com/question/16346203

Otras preguntas