Prepare a budget for the second quarter

Trader Cycles manufactures chainless bicycles. On March 31. Trader Cycles had 100 bikes in inventory The company has a poficy that the ending inventor/ in any month must be 10% of the following month's expected sales_ Trader Cycles expects to sen 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 Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce Get more help April 1.110 May June 124 Data table April. June. July Quarter 124 1 bikes 1, 110 bikes . 1.370 bikes bikes