Assignment: Chapter 9 Homework 2. Trader Cycles manufactures chainless bicycles. On March 31. Trader Cycles had 306 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 Production Budget For the Months of April through June April May June Quarter Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce 1: Data Table April.................... 1,020 bikes May ...... .......... 1,180 bikes June...... 1,350 bikes July .................. 1,230 bikes