12B PL 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 Credit Sales (Rs.) Purchases (Rs.) Wages (Rs.) February 1.80,000 1.24,000 12,000 March 1,92,000 1,44,000 14.000 April 1,08,000 2,43,000 11,000 May 1.74,000 2,46,000 10,000 June 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