prepare a cash budget in respect of six months from july to december from the follow 626378

Prepare a Cash Budget in respect of six months from July to December from the following information.

Month	Sales Rs.000	Mat. Rs.000	Wages Rs.000	Production O/H Rs.000	Admn O/H Rs.	Selling O/H Rs	Dist. O/H Rs	R & D O/H Rs
April	100	40	10	4.4	3,000	1,600	800	1,000
May	120	60	11.2	4.8	2,900	1,700	900	1,000
June	80	40	8	5	3,040	1,500	700	1,200
July	100	60	8.4	4.6	2,960	1,700	900	1,200
Aug.	120	70	9.2	5.2	3,020	1,900	1,100	1,400
Sept	140	80	10	5.4	3,080	2,000	1,200	1,400
Oct	160	90	10.4	5.8	3,120	2,050	1,250	1,600
Nov	180	100	10.8	6	3,140	2,150	1,350	1,600
Dec	200	110	11.6	6.4	3,200	2,300	1,500	1,600

The cash balance as on 1st July was expected Rs.1, 50, 000

Expected Capital Expenditure:

Plant and Machinery to be installed in August to a cost of Rs.40, 000 will be payable on September 1st. The extension to the Research and Development Department amounting to Rs.10, 000 will be completed on August 1st, payable Rs.2, 000 per month from the date of completion. Under a hire purchase agreement Rs.4, 000 is to be paid each month. The Cash Sales of Rs.2, 000 per month are expected. No commission is payable. However a commission of 5% on credit sales is to be paid within the month following the sale. Period of credit allowed by suppliers 3 months, credit allowed to customers 2 months, delay in payment of overheads 1 month, delay in payment of wages 1st week of the following month. An income tax of Rs.1, 00, 000 is due to be paid on October 1st. A preference share dividend of 10% on Rs.2, 00, 000 is payable on November 1st. 10% calls on the ordinary share capital of Rs.4, 00, 000 is due on July 1st and September 1st. The dividend from investments amounting to Rs.30, 000 is expected on November 1st.