please solve this question:

Question 3

WXYZ is preparing for the first half of the next year. The following information was available:

a. Sales - 15% of monthly sales are in cash while the balance is sold on credit. Collections from receivables are 50% in the first month after sales, 30% in the second month and the balance in the third month after sales.

b. Purchases are usually 55% of sales and paid in the month of purchase.

c. Insurance company is expected to pay the sum of RM525,000 in the month of February based on the companys accidented vehicles.

d. Salary deductions are paid on preceding month basis.

e. Company income tax of RM475,550 will be paid in the month of March.

f. Cash and Cash equivalent balance as at December is RM502,760.00.

g. Bank Charges is 1% of total payment for the month.

h. Additional Information is as follows:

Required: Prepare the cash budget for the first three months of the year.

October March RM November December January RM RM RM 600,000 850,000 520,000 200,000 250,000 210,000 RM 750,000 230,000 February RM 670,000 240,000 Sales 800,000 270,000 200,000 187,500 197,500 177,200 187,500 192,700 Net Salaries Other Expenses Salaries Deductions 29,400 28,400 39,400 28,700 32,750 27,650