Q3. (a) Seroja Berhad prepares monthly cash budgets. Relevant data from operating budget for 2021 are: Credit sales Purchases Wages Manufacturing overhead Selling and administrative expenses July RM 3,600,000 1,250,000 900,000 700,000 790,000 August RM 4,000,000 1,300,000 1,000,000 750,000 860,000 September RM 4,500,000 1,400,000 1,200,000 800,000 800,000 All sales are on credit. Collections are expected to be 50% in the month of sales, 30% in the first month after the sale, and 20% in the second month after the sale. Sixty percent of purchases are paid in cash in the month of purchase, and the balance due is paid the next month. All other items are paid in the month incurred. The selling and administrative expenses include RM20,000 depreciation per month. Additional information: Expected credit sales: May 2021 RM2,600,000; June 2021 RM3,000,000. Expected purchases: June 2021 RM1,000,000. Other expected receipts: o July 2021 - Collection of 30 June 2021, commission received RM150,000. o August 2021 - Proceeds from sale of investment RM60,000. Seroja Berhad's cash balance on 1 July 2021 is expected to be RM426,000. Required: Prepare the following: (i) A table for expected collections from customers for July, August and September 2021. (5 marks) (ii) A table for expected payments for purchases for July, August and September 2021. (3 marks) A cash budget for July, August and September 2021. (13 marks) Q3. (a) Seroja Berhad prepares monthly cash budgets. Relevant data from operating budget for 2021 are: Credit sales Purchases Wages Manufacturing overhead Selling and administrative expenses July RM 3,600,000 1,250,000 900,000 700,000 790,000 August RM 4,000,000 1,300,000 1,000,000 750,000 860,000 September RM 4,500,000 1,400,000 1,200,000 800,000 800,000 All sales are on credit. Collections are expected to be 50% in the month of sales, 30% in the first month after the sale, and 20% in the second month after the sale. Sixty percent of purchases are paid in cash in the month of purchase, and the balance due is paid the next month. All other items are paid in the month incurred. The selling and administrative expenses include RM20,000 depreciation per month. Additional information: Expected credit sales: May 2021 RM2,600,000; June 2021 RM3,000,000. Expected purchases: June 2021 RM1,000,000. Other expected receipts: o July 2021 - Collection of 30 June 2021, commission received RM150,000. o August 2021 - Proceeds from sale of investment RM60,000. Seroja Berhad's cash balance on 1 July 2021 is expected to be RM426,000. Required: Prepare the following: (i) A table for expected collections from customers for July, August and September 2021. (5 marks) (ii) A table for expected payments for purchases for July, August and September 2021. (3 marks) A cash budget for July, August and September 2021. (13 marks)
