Trapper Cycles manufactures chainless bicycles. On March 31, Trapper 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. Trapper 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 Trapper Cycles Production Budget Data Table For the Months of April through June April May June Quarter Unit sales April.. ............ 1,040 bikes Plus: Desired ending inventory May . 1,180 bikes Total needed June..... ..... 1,300 bikes Less: Beginning inventory July.... ..... 1.270 bikes Units to produce Print Done Enter any number in the edit fields and then continue to the next