From the following information prepare a monthly cash budget for the three months ending 31st Dec.2023...

Transcribed Image Text:

From the following information prepare a monthly cash budget for the three months ending 31st Dec.2023 Sales Materials Wages Production Admin. Selling, etc Month (RM) (RM) (RM) (RM) (RM) June 36,000 22,000 7,800 3,000 1,850 July 39,000 25,000 9,000 3,250 2,200 Aug. 42,000 30,000 10,000 3,500 2,400 Sep. 45,000 27,000 11,400 3,600 2,800 Oct. 50,000 28,500 12,600 3,800 3,000 Nov. 52,000 30,000 13,800 4,200 3,200 Dec. 60,000 33,000 15,200 4,500 3,500 Credit terms Sales - 3 months to debtors. 20% of sales are on cash. On an average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following Creditors for material 2 months. Lag in payment Wages. 1/4 month, overheads 1/2 month. Other information Plant and Machinery to be installed in Aug. at a cost of RM150,000. It will be paid for by monthly installments of RM6,000 each from 1st Oct.; Preference share dividend @ 5% on RM280,000 are to be paid on 1st Dec. Calls on 4,000 equity shares @ RM4 per share expected on 1st November; Dividends from investments amounting to RM7,500 are expected on 31st Dec.; Income tax (advance) to be paid in December RM 5,000 Cash and Bank Balance on 1st Oct. expected RM18,000. Required: Prepare cash budget for 3 months period ending 31st December 2023 in detail with appropriate workings. From the following information prepare a monthly cash budget for the three months ending 31st Dec.2023 Sales Materials Wages Production Admin. Selling, etc Month (RM) (RM) (RM) (RM) (RM) June 36,000 22,000 7,800 3,000 1,850 July 39,000 25,000 9,000 3,250 2,200 Aug. 42,000 30,000 10,000 3,500 2,400 Sep. 45,000 27,000 11,400 3,600 2,800 Oct. 50,000 28,500 12,600 3,800 3,000 Nov. 52,000 30,000 13,800 4,200 3,200 Dec. 60,000 33,000 15,200 4,500 3,500 Credit terms Sales - 3 months to debtors. 20% of sales are on cash. On an average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following Creditors for material 2 months. Lag in payment Wages. 1/4 month, overheads 1/2 month. Other information Plant and Machinery to be installed in Aug. at a cost of RM150,000. It will be paid for by monthly installments of RM6,000 each from 1st Oct.; Preference share dividend @ 5% on RM280,000 are to be paid on 1st Dec. Calls on 4,000 equity shares @ RM4 per share expected on 1st November; Dividends from investments amounting to RM7,500 are expected on 31st Dec.; Income tax (advance) to be paid in December RM 5,000 Cash and Bank Balance on 1st Oct. expected RM18,000. Required: Prepare cash budget for 3 months period ending 31st December 2023 in detail with appropriate workings.