1. EX.09.53.EXCEL. ALGO (Algorithmic) excel Production Budget Aqua-Pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April May June 270,000 330,000 300,000 360,000 July Company policy requires that ending inventories for each month be 30% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pumps is only 29,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Required: Prepare a production budget for the second quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total. Aqua-pro Inc. Production Budget For the Second Quarter April May June Q2 Sales Desired ending inventory Total needs Less: Beginning inventory Units produced as:/N2.cengagenow.com/ilm/takeAssignment/printUntakenAssignment.do?assignment/d=2665920 1/2