HELP FOR URGENT TEST!!!

Question 4

Gigantea Berhad projected sales and purchases for the month of September to December 2022 as below:

2022	Purchases (RM)	Sales (RM)
September	6,000	9,500
October	7,000	11,000
November	6,500	9,000
December	5,000	12,000

Wages of RM1,500 are paid in the month that they are incurred. Overhead expenses of RM1,600 is due each month and these are paid one month in arrears. On 1 November 2022, the company plans to buy a second-hand van for RM12,000.

Sales are all on credit and the company policy is to allow a 30-day credit period. Half of the purchases are on credit and the length of credit period allowed is a month. The other half of the purchases are for immediate settlement. The balance at the bank as of 1 October 2022 is RM25,000.

Required:

Produce a cash budget for the 3-month period ending 31 December 2022. (20 Marks)