Cash Budget ABC Co. wished to arrange overdraft facilities with its bankers during the period April 2017 to June 2017 when it will be manufacturing mostly for the stock. Particulars Februari 2017 Mac April Mei Jun Sales RM180,000 192,000 108,000 174,000 126,000 Purchases RM124,800 144,000 243,000 246,000 268,000 Wages RM12,000 14, 000 11, 000 10, 000 15, 000 Additional Information: a) 50% of the credit sales are realized in the month following the sales and remaining 50% in the second month following. Creditors are paid in the month following the month of purchases. There are no cash sales or cash purchases b) Cash at bank [overdraft] estimated on 1st April 2017 is RM25,000 Required: Prepare a cash budget for the above period from the following data, indicating the extent of the bank facilities the company will require at the end of each month