Desa Cemerlang Sdn Bhd has been engaged in the process of forecasting its financing needs over the next quarter and has made the following forecasts of planned cash receipts and disbursements: The monthly sales for the year of 2021: RM RM April 550,000 August 680,000 May 660,000 September 565,000 June 700,000 October 620,000 July 650,000 November 650,000 a) The firm's sales of 60% is collected in the month of sale and the remaining balance will be collected equally in the following two months after sales. b) The raw materials are 70% of sales purchased two (2) months before the sales month. The supplier is paid one month after the purchases on the cash payment basis. c) The wages and salaries is paid based on 10% of sales in the month. The utilities for the firm is 5% of sales in themonth of their incurrence.

1. Furthermore, the monthly rent expenses is RM7,000.
2. RM5,000 tax paymentsare to be made in the second monthof each quarter.
3. A 5% annualinterest on a RM500,000 term loan will be paid monthly.
4. Beginning cash balance for the budgetperiod is RM70,000with a minimum cash balanceof RM45,000 and an increase to RM90,000 in August and RM135,000 in September.
5. Any short term financingneeded to maintainthe minimum cash balance should be paid off the month after the financing month with an annual interest rate of 15% per annum.

Prepare a monthly cash budget for the three-month period ended 30th September.