The following information is budgeted for Gagasao Sdn. Bhd.(GSB) for second quarter next year: Sales Purchase...

 

Transcribed Image Text:

The following information is budgeted for Gagasao Sdn. Bhd.(GSB) for second quarter next year: Sales Purchase of materials Administration expenses Fixed overhead Direct labour cost Variable overhead Proceeds-sales of securities Sales of motor vehicle Repaid loan April RM 120,000 RM 90,000 RM 50,000 RM 60,000 RM 50,000 RM 25,000 RM 150,000 RM 15,000 RM 10,000 May RM 100,000 RM 95,000 RM 40,000 RM 60,000 RM 30,000 RM 15,000 RM 152,000 June RM 130,000 RM 85,000 RM 35,000 RM 60,000 RM 40,000 RM 15,000 RM 90,000 Collections are expected to be 70% in the month ofsale and 30% in the month following sale. GSB purchase all material on credit.80% of purchases are paid for in the month of purchase, the remaining 20% are paid for in the following month. The purchase of material for the month of March is RM70,000. Fixed overhead include depreciation of RM5,000. Direct labour cost, variable overhead and administration expenses are paid within the month they are incurred. During the month of May and June, the company also paid 3% on sales as a bonus to top management. The company's cash balance on April 1 is expected to be RM100,000. The company wants to maintain a minimum cash balance of RM10,000. Required: A) Prepare a schedule ofexpected cash collections for the month of April, May and June. B) Prepare schedule for payment of materials for April, May and June. C) Prepare a cash budget for the months of April, May and June. The following information is budgeted for Gagasao Sdn. Bhd.(GSB) for second quarter next year: Sales Purchase of materials Administration expenses Fixed overhead Direct labour cost Variable overhead Proceeds-sales of securities Sales of motor vehicle Repaid loan April RM 120,000 RM 90,000 RM 50,000 RM 60,000 RM 50,000 RM 25,000 RM 150,000 RM 15,000 RM 10,000 May RM 100,000 RM 95,000 RM 40,000 RM 60,000 RM 30,000 RM 15,000 RM 152,000 June RM 130,000 RM 85,000 RM 35,000 RM 60,000 RM 40,000 RM 15,000 RM 90,000 Collections are expected to be 70% in the month ofsale and 30% in the month following sale. GSB purchase all material on credit.80% of purchases are paid for in the month of purchase, the remaining 20% are paid for in the following month. The purchase of material for the month of March is RM70,000. Fixed overhead include depreciation of RM5,000. Direct labour cost, variable overhead and administration expenses are paid within the month they are incurred. During the month of May and June, the company also paid 3% on sales as a bonus to top management. The company's cash balance on April 1 is expected to be RM100,000. The company wants to maintain a minimum cash balance of RM10,000. Required: A) Prepare a schedule ofexpected cash collections for the month of April, May and June. B) Prepare schedule for payment of materials for April, May and June. C) Prepare a cash budget for the months of April, May and June.

Answer rating: 100% (QA)

A Calculations of Cash Collections From Sales Particulars April May June Sales 120000100000130000 Ca... View the full answer