Trader Cycles manufactures chainless bicycles. On March 31, Trader Cycles had 315 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, Data Table June 1,330 399 Quarter 3,540 April May 1,050 bikes 1.160 bikes Trader Cycles Production Budget For the Months of April through Juno April May Unit sales 1.050 1.100 315 348 Plus: Desired ending inventory Total needed 1365 1508 315 315 Less: Beginning inventory 1050 1193 Units to produce 1062 June 1,330 bikes 1.200 bikes July 1729 4602 348 315 Done 1381 4287 Print