Prepare cash budget for January - June from for following attachaed information.

UH4: Prepare cash budget for January-June from the following information: (i) The estimated sales and expenses are as follows: Particulars Nov. Dec. Jan. Feb Mar. Apr. May June Sales(Rs) 200000 220000 120000 100000 150000 240000 200000 200000 Wages and salaries(Rs) 30000 30000 24000 24000 24000 30000 27000 27000 Misc. expenses(Rs) 27000 27000 21000 30000 24000 27000 27000 27000 (ii) 20% of the sales are on cash and balance on credit. (iti) The firm has a gross margin of 25% on sales. (iv) 50% of the credit sales are collected in the month following the sales, 30% in the second month and 20% in the third month. Material for the sale of each month is purchased one month in advance on a credit for two months. (vi) The time-lag in the payment of wages and salaries is one-third of a month and of miscellaneous expenses, one month. ( vii) Debentures worth Rs 40000 were sold in January. (vili) The firm maintains a minimum cash balance of Rs 40000. Funds can be borrowed @ 12% per annum in the multiples of Rs 1000, the interest being payable on monthly basis. (ix) Cash balance at the end of December is Rs 60000