Below are AHM Company forecasted sales for 2013 (in RM) 2013 January February March 100,000 110,000...

Transcribed Image Text:

Below are AHM Company forecasted sales for 2013 (in RM) 2013 January February March 100,000 110,000 90,000 April May June July 95,000 105,000 108,000 112,000 The sales are 40percent on cash basis. 35percent of sales will be collected from previous month sales and the balance is collected two month after sales. AHM Company purchases raw materials one month prior to sales and equal to 70percent of the total sales. The supplier is paid equally in two months after purchase. V. yi. iii. The monthly rental fees for AHM Company are fixed at RM2,500. iv. Wages and salaries are 12percent of monthly sales and will be paid in the same month of sales. Depreciation expense for AHM Company is RM10,000 annually. Administration cost for March is RM2,000 and it will increase by 10percent each month. v. Dividend of RM2,100 will be received twice a year in April and September. viii. Interest payment of RM1,200 will be paid at the end of each quarter. ix Taxes of RM4,000 is payable in May. AHM Company decides to repay RM10,000 of their loan in June. x xi. AHM Company beginning cash balance for April is RM6,000. The company would like to maintain a minimum cash balance of RM12,000 for each month. Prepare cash budget for AHM Company for the second quarter 2013. (20 marks) Below are AHM Company forecasted sales for 2013 (in RM) 2013 January February March 100,000 110,000 90,000 April May June July 95,000 105,000 108,000 112,000 The sales are 40percent on cash basis. 35percent of sales will be collected from previous month sales and the balance is collected two month after sales. AHM Company purchases raw materials one month prior to sales and equal to 70percent of the total sales. The supplier is paid equally in two months after purchase. V. yi. iii. The monthly rental fees for AHM Company are fixed at RM2,500. iv. Wages and salaries are 12percent of monthly sales and will be paid in the same month of sales. Depreciation expense for AHM Company is RM10,000 annually. Administration cost for March is RM2,000 and it will increase by 10percent each month. v. Dividend of RM2,100 will be received twice a year in April and September. viii. Interest payment of RM1,200 will be paid at the end of each quarter. ix Taxes of RM4,000 is payable in May. AHM Company decides to repay RM10,000 of their loan in June. x xi. AHM Company beginning cash balance for April is RM6,000. The company would like to maintain a minimum cash balance of RM12,000 for each month. Prepare cash budget for AHM Company for the second quarter 2013. (20 marks)