4. Prepare a Cash Budget from the data given below for a period of six months (July to December) (1) Month Sales (OMR) Raw Materials(OMR) May 75,000 37,500 June 75,000 37,500 July 1,50,000 52,500 August 2,25,000 3,67,500 September 3,00,000 1,27,500 October 1,50,000 97,500 November 1,50,000 67,500 December 1,37,500 (2) Collection estimates: > Within the month of sale: 10% During the month following the sale: 25% During the second month following the sale: 18% (3) Payment for raw materials is made in the next month. (4) Salary OMR 10000. Lease payment OMR 2500, Misc. Exp. OMR 6000. are paid each month. (5) Income tax OMR 23000 each in September and December (6) Payment for research in October OMR 66000 (7) Opening Balance on 1st July OMR 85.000 (3.5Marks) 4. Prepare a Cash Budget from the data given below for a period of six months (July to December) (1) Month Sales (OMR) Raw Materials(OMR) May 75,000 37,500 June 75,000 37,500 July 1,50,000 52,500 August 2,25,000 3,67,500 September 3,00,000 1,27,500 October 1,50,000 97,500 November 1,50,000 67,500 December 1,37,500 (2) Collection estimates: > Within the month of sale: 10% During the month following the sale: 25% During the second month following the sale: 18% (3) Payment for raw materials is made in the next month. (4) Salary OMR 10000. Lease payment OMR 2500, Misc. Exp. OMR 6000. are paid each month. (5) Income tax OMR 23000 each in September and December (6) Payment for research in October OMR 66000 (7) Opening Balance on 1st July OMR 85.000 (3.5Marks)