The beginning cash balance for April, is the cash from March 31 in the Asset section of the balance sheet. In the merchandise purchases budget, in April, we need 50% of March purchases (that amount is also given to us 3/31 Accounts payable of $100,000 on page 415). Therefore, Total cash disbursements for April is (50% x $316,000 April purchases) + ($100,000 remaining March purchases to be paid) = $258,000.
Class, Here are some hints. Lets start from the beginning:
First, take budgeted sales in units for each month of April, May, and June, and multiply by the selling price of $10/unit. You will get TOTAL SALES which you will also need to plug into the Income Statement later. For example, April should be 65,000 units times $10 = $650,000 Total Sales.
For your Schedule of Expected Cash Collections, each months units must be multiplied by the $10 selling price to yield the months sales. Per page 414, we know 10% of a given months sales is collected in the 2nd month following the sale, 70% in the month following the sale, and 20% in the month of sale. Therefore, for example Total Cash Collection for April will consist of the last 10% of February sales and 70% of March sales and 20% of April sales: (26,000 Feb units x $10 x 0.10) +(40,000 March units x $10 x 0.70) + (65,000 April units x $10 x 0.20) = $436,000. You have to repeat the same process for May and June that I just did for April, and then add up all three months to get the quarter.
Next, we have the Merchandise Purchases Budget. Total Needs are Budgeted sales in units plus Budgeted ending inventory (budgeted ending inventory =40% of the next months sales in units according to the terms of the problem). Once we have Total Needs, we subtract the Beginning Inventory (which of course is the previous months ending inventory) to get Required Unit Purchases. So for April, that is 65,000 April budgeted units + (0.40 x 100,000 May budgeted units) = 105,000 units Total Needs less ending March inventory which is the same as April beginning inventory (which is 0.40 x 65,000 April units = 26,000 units) = 79,000 units required purchases. [Be careful with the inventory: you cant just pull the $104,000 inventory off of the balance sheet on page 415 because the balance sheet is in dollars not units, so if you want to use that balance sheet inventory figure, you have to say $104,000 divided by $4 cost = 26,000 units.] Getting back to our 79,000 units required purchases, now multiply direct materials cost of $4 times the Required Unit Purchases to get Required Dollar purchases, which would be 79,000 Required April Unit Purchases x $4 = $316,000 as Required dollar purchases for April. [Again, be careful, on page 414 the problem states that only 50% of any given months purchases are paid for during the month of purchase, with the remaining 50% paid for in the following month, that fact will come in handy for the next step: the Budgeted Cash Disbursements for merchandise purchases. For April, we need to therefore know what 50% of March purchases are (that is also given to us 3/31 Accounts payable of $100,000 on page 415). Therefore, Total cash disbursements for April is (50% x $316,000 April purchases )+($100,000 remaining March purchases to be paid)= $258,000 which we will need in the next step for the Cash Budget.
Remember that the beginning Cash balance of the month is the previous months ending cash balance. For April, we can use the 3/31 Cash ending balance of $74,000 as stated on the page 415 Balance Sheet for 3/31. Next we add receipts from Customers (which we calculated in the Schedule of Expected Cash Collections as $436,000 for April, giving us Total Cash Available for April as $510,000.
For the Disbursements, we already know what the Purchase of Inventory figure is that we calculated in the Budgeted Cash Disbursements (recall it was $258,000). Advertising is $200,000 per month per page 414; Rent is...