pls solve

QUESTION 3 Jasper Industries Limited makes up its accounts to 31 December yearly. The company's board of directors is desirous of establishing a new branch office to penetrate a new market. It has directed the Finance Director to prepare a Cash Budget that will assist the board take a decision on the loan required to finance the new branch office. This will supplement the free cash balance for the purpose of funding the branch office estimated to cost OMR7 million. The following data are provided for the eight months ending 30 November, 2014: April May June July Aug '000'000 '000 '000 '000 Sept '000 Oct '000 Nov '000 Sales 3600 3800 4500 4800 4700 4500 4900 4500 Purchases 2400 2500 3000 3200 3200 3200 Admin/selling 300 200 150 300 200 250 Wages/salaries 500 550 600 720 450 480 Interest 300 income Taxation 300 350 3400 260 500 100 3100 270 520 The following additional information is available: (i) The company will purchase a new delivery van at a cost of OMR 700,000. The vehicle will be paid for in September 2014 though delivery will take place in November 2014. (ii) The company policy on sales is that 30% of sales is for cash while the remaining are credit sales to be collected as follows: 50% of the credit sales will be collected in the month of sales. The balance of the credit sales will be collected in the month following sale. (iii) The company enjoyed the suppliers' policy of 20% of purchases for cash, while the balance is paid in the following month. (iv) The selling and administration expenses are paid for in the month they are incurred. (v) Wages and salaries are also paid in the month they are incurred. (vi) Interest income is received in the month in which it is due. (vii) Taxation is paid a month after it is due. (viii) Closing cash balance in June, 2014 is expected to be OMR 150,000. You are required to a. Prepare a monthly Cash Budget for the first 4 months ending 31 October, 2014