12 BPL Ltd., wie UPL Ltd., wishes to arrange overdrafts facilities with its bankers during the period April to June 2018. When it will be manufacturing mostly for stock Prepare a Cash Budget for the above period for the following data, indicating the extent of the bank facilities the company will require at the end of each month. Months February March April May June Credit Sales (Rs.) Purchases (Rs.) Wages (Rs.) 1.80,000 1.24,000 12.000 1.92.000 1.44.000 14.000 1,08,000 2,43,000 11,000 1.74,000 2.46.000 10.000 1.26.000 2,68,000 15.000 (a) (b) (c) 50 per cent of credit sales are realized in the month following the sales and the remaining 50 per cent in the second month following: Creditors are paid in the month following the month of purchases. Cash at bank on 1.4.2018 (estimated) Rs.25.000