S9-5 (similar to) Question Help Trader Cycles manufactures chainless bicycles. On March 31, Trader Cycles had 309 bikes in inventory. The company has a policy that the ending inventory in any month must be 30% of the following month's expected sales. Trader Cycles expects to sell the following number of bikes in each of next four months: (Click the icon to view the data) Prepare a production budget for the second quarter, with a column for each month and for the quarter. Trader Cycles Data Table June Quarter Production Budget For the Months of April through June April May Unit sales 1,030 1,100 309 330 Plus: Desired ending inventory Total needed 1339 1430 1,390 3,520 417 1056 April May June 1,030 bikes 1,100 bikes 1807 4576 1,390 bikes Less: Beginning inventory July 1,230 bikes Units to produce Print Done