Answer the following Question attached below

Required : A cash budget for each of the first three months of comming year.

A cash budget by quarters for the year. Q#2:- The following data pertain to a shop. The owner has made the following sales forecasts for the first 5 months of the coming years; January Rs 40,000 February 45,000 March 55,000 April 60,000 May 50,000 Other data are as follows: 1.Accounts receivable and accounts payable balances at the beginning of the year are Rs 30,000 and Rs 14,000 respectively. The balances of other relevant assets and liabilities are: Cash balances Rs 7,500 Inventory 51,000 Accrued sales commission 3,500 2.40% sales are on cash basis, credit sales are collected in the month following sales. 3. Cost of goods sold is 60% of sales. 4. The only other variable cost is a 5 % commission to sales agents. The sales commission is paid in month after it is earned. 5. Inventory is kept equal to sales requirements for the next two months' budgeted sales. 6.Accounts payable are paid in the following month after purchase. 7.Fixed costs are Rs 5000 per month including Rs 2000 depreciation. Required:- You are required to prepare a cash budget for each of the first three months of coming year