Question

Company is in the process of preparing its budget for next year. Cost of goods sold has been estimated at 60 percent of sales. Merchandise purchases are to be made during the month preceding the month of the sales. Button pays 60 percent in the month of purchase and 40 percent in the month following. Wages are estimated at 20 percent of sales and are paid during the month of sale. Other operating costs amounting to 10 percent of sales are to be paid in the month following the sale.

Month Sales Revenue

December $170,000

January 250,000

February 120,000

March 200,000

April 160,000

Prepare a schedule of cash disbursements for January, February, and March

Answer 1

Schedule of cash disbursements for January through March
	January	February	March
Sales	2,50,000	1,20,000	2,00,000
Cost of goods Sold (60% of Sales)	1,50,000	72,000	1,20,000
Budgeted purchases	72,000	1,20,000	96,000
			(160000*60%)
Cash disbursements in the month of Purchase	43,200	72,000	57,600
	(72000*60%)	(120000*60%)	(96000*60%)
Cash disbursements in the month of Purchase	60,000	28,800	48,000
	(150000*40%)	(72000*40%)	(120000*40%)
Cash disbusements for wages (20% on Sales)	50,000	24,000	40,000
	(250000*20%)	(120000*20%)	(200000*20%)
Cash disbusements for other operating costs (10% on Sales) - Following month of sale	17,000	25,000	12,000
	(170000*10%)	(250000*10%)	(120000*10%)
Total Cash Disbursements	1,70,200	1,49,800	1,57,600