Trapper Cycles manufactures chainless bicycles. On March 31, Trapper Cycles had 200 bikes in inventory. The company has a policy that the ending inventory in any month must be 20% 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 For the Months of April through June Data table April May June Quarter April 1,000 bikes Unit sales 1,000 1,600 1,300 3,900 May 1,160 bikes 200 320 260 260 Plus: Desired ending inventory June 1,300 bikes Total needed 1,200 1,920 1,560 July 1,250 bikes 200 320 390 1,170 Less: Beginning inventory 1,000 Units to produce Print Done