Trevor Cycles manufactures chainless bicycles. On March 31, Trevor Cycles had 312 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. Trevor Cycles expects to sell the following number of bikes in each of next four months: E: (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. Trevor Cycles Production Budget Data table For the Months of April through June April May June Quarter 1,040 bikes Unit sales April May June 1,110 bikes Plus: Desired ending inventory 1,330 bikes Total needed July 1,250 bikes Less: Beginning inventory Units to produce Print Done