The following information is budgeted for Hamka Sdn. Bhd. (HSB) for second quarter next year: April RM10,000 RM50,000 RM6,000 RM30,000 RM2,000 May RM30,000 RM30,000 RM6,000 RM30,000 RM5,000 RM55,000 June RM40,000 RM20,000 RM6,000 RM30,000 RM5,000 Sales Purchase of materials Rental expenses Fixed overhead Variable overhead Receipt- sales of used equipment Additional information: a) All sales at HSB are on credit. Past experience indicates that 80% of sales will be collected in the month of sale and the remaining 20% will be collected in the following month. b) HSB purchase all materials on credit; 90% of purchases are paid for in the month of purchase, the remaining 10% are paid for in the following month. The purchase of materials for the month of March is RM30,000. c) Fixed overhead include depreciation of RM3,000. d) Variable overhead and rental expenses are paid within the month they are incurred. e) The company received 7% dividend from investment of RM60,000 in April. f) An equipment costing RM20,000 will be purchased in May. Payment of the equipment will be in 2 equal payments starting May. g) Opening cash balance in April is RM160,000. Required: a) Prepare a schedule of sales collections and payments of materials for the month of April, May and June. (4 marks) b) Prepare a cash budget for the months of April, May, and June. (6 marks) The following information is budgeted for Hamka Sdn. Bhd. (HSB) for second quarter next year: April RM10,000 RM50,000 RM6,000 RM30,000 RM2,000 May RM30,000 RM30,000 RM6,000 RM30,000 RM5,000 RM55,000 June RM40,000 RM20,000 RM6,000 RM30,000 RM5,000 Sales Purchase of materials Rental expenses Fixed overhead Variable overhead Receipt- sales of used equipment Additional information: a) All sales at HSB are on credit. Past experience indicates that 80% of sales will be collected in the month of sale and the remaining 20% will be collected in the following month. b) HSB purchase all materials on credit; 90% of purchases are paid for in the month of purchase, the remaining 10% are paid for in the following month. The purchase of materials for the month of March is RM30,000. c) Fixed overhead include depreciation of RM3,000. d) Variable overhead and rental expenses are paid within the month they are incurred. e) The company received 7% dividend from investment of RM60,000 in April. f) An equipment costing RM20,000 will be purchased in May. Payment of the equipment will be in 2 equal payments starting May. g) Opening cash balance in April is RM160,000. Required: a) Prepare a schedule of sales collections and payments of materials for the month of April, May and June. (4 marks) b) Prepare a cash budget for the months of April, May, and June. (6 marks) The following information is budgeted for Hamka Sdn. Bhd. (HSB) for second quarter next year: April RM10,000 RM50,000 RM6,000 RM30,000 RM2,000 May RM30,000 RM30,000 RM6,000 RM30,000 RM5,000 RM55,000 June RM40,000 RM20,000 RM6,000 RM30,000 RM5,000 Sales Purchase of materials Rental expenses Fixed overhead Variable overhead Receipt- sales of used equipment Additional information: a) All sales at HSB are on credit. Past experience indicates that 80% of sales will be collected in the month of sale and the remaining 20% will be collected in the following month. b) HSB purchase all materials on credit; 90% of purchases are paid for in the month of purchase, the remaining 10% are paid for in the following month. The purchase of materials for the month of March is RM30,000. c) Fixed overhead include depreciation of RM3,000. d) Variable overhead and rental expenses are paid within the month they are incurred. e) The company received 7% dividend from investment of RM60,000 in April. f) An equipment costing RM20,000 will be purchased in May. Payment of the equipment will be in 2 equal payments starting May. g) Opening cash balance in April is RM160,000. Required: a) Prepare a schedule of sales collections and payments of materials for the month of April, May and June. (4 marks) b) Prepare a cash budget for the months of April, May, and June. (6 marks)