(h) Equipment purchases during the quarter will be as follows: October $23 000 and November $6 000. Dividends totalling $6 000 will be paid in December. Required: Prepare the Cash budget along with the supporting schedules necessary for the quarter ending December 31, 2005 I 25C 100AM RA Chad Associates, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in the preparation of the master budget for the final quarter (a) As of September 30, 2005, the company's balance sheet showed the following account balances Cash Accounts receivables Inventory Building & equipment (net) Accounts payable Capital Retained earnings $18 000 96 000 25 200 428 200 $36 600 380 000 150 800 $567 400 $567 400 (1) Actual sales for September and budgeted sales for the final quarter are as follows: September (actual) October November December January S120 000 140 000 170 000 180 000 1000 c) Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at September 30 are as a result of September credit sales. (d) The company's gross profit rate : 40% of sales. The cost of goods sold is 60% of sales. e) Monthly expenses are budgeted as follows salaries and wages, 515 000 per month shipping of sales advertising S12 000 per month other expenses of sales, depreciation of equipment will be 512 000 for the quarter At the end of each month www.mory is to be und qua10 of the following month's od of goods sold the math of purchase and half in 25C (h) Equipment purchases during the quarter will be as follows: October $23 000 and November $6 000. Dividends totalling $6 000 will be paid in December. Required: Prepare the Cash budget along with the supporting schedules necessary for the quarter ending December 31, 2005 I 25C 100AM RA Chad Associates, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in the preparation of the master budget for the final quarter (a) As of September 30, 2005, the company's balance sheet showed the following account balances Cash Accounts receivables Inventory Building & equipment (net) Accounts payable Capital Retained earnings $18 000 96 000 25 200 428 200 $36 600 380 000 150 800 $567 400 $567 400 (1) Actual sales for September and budgeted sales for the final quarter are as follows: September (actual) October November December January S120 000 140 000 170 000 180 000 1000 c) Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at September 30 are as a result of September credit sales. (d) The company's gross profit rate : 40% of sales. The cost of goods sold is 60% of sales. e) Monthly expenses are budgeted as follows salaries and wages, 515 000 per month shipping of sales advertising S12 000 per month other expenses of sales, depreciation of equipment will be 512 000 for the quarter At the end of each month www.mory is to be und qua10 of the following month's od of goods sold the math of purchase and half in 25C