The following transactions are provided to you MonthsMarchAprilMayJuneSales (Rs)400,000400,000500,000500,000Purchase (Rs)240,000240,000300,000300,000Wages (Rs)40,00040,00050,00060,000Office expenses…

The following transactions are provided to you MonthsMarchAprilMayJuneSales (Rs)400,000400,000500,000500,000Purchase (Rs)240,000240,000300,000300,000Wages (Rs)40,00040,00050,00060,000Office expenses (Rs)20,00020,00030,00040,000Selling expenses (Rs)40,00040,00050,00060,000 Additional information: ➤ 60 percent sales on cash and 40 percent collected in next month of sales ➤ 50 percent purchases are paid in the month of purchase and balance next month of purchase ➤ Wages, office and selling expenses are paid in the same month. ➤ Dividend Rs 60,000 paid in June ➤ Tax paid Rs 70,000 in May ➤ Sale of old machine at Rs 30,000 in April ➤ Opening cash balance Rs 30,000 Required: Cash budget for three-month April, May and June