Trapper Cycles manufactures chainless bicycles. On March $31,$ Trapper Cycles had $102$ bikes in inventory. The company's policy is that the ending inventory in any month must be $10\%$ of th following month's expected sales. Trapper Cycles expects to sell the following number of bikes in each of next $4$ 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.

$\backslash$table$[[\backslash$table$[[$Trapper Cycles$],[$Production Budget$],[$For the Quarter ended June $30]]],[,$Month,$],[,$April.,May,June,$2$nd Quarter$],[$Unit sales,$1,020,1,120,1,340,3,480],[$Plus: Desired ending inventory,$112,134,135,381],[$Total needed,$1,132,1,254,1,475,3,861],[$Less: Beginning inventory,$102,112,134,102],[$Units to produce,$1,030,1,142,1,341,3,759]]$

Trapper Cycles manufactures chainless bicycles. On March $31,$ Trapper Cycles had $102$ bikes in inventory. The company's policy is that the ending inventory in any month must be $10\%$ of the following month's expected sales. Trapper Cycles expects to sell the following number of bikes in each of next $4$ 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.

$\backslash$table$[[,\backslash$table$[[$Cycles$],[$tion Budget$],[$ter ended Ju$]],,,],[,,$lonth,$-,],[,$April.,May,June,$2$nd Quarter$],[$Unit sales,$1,020,1,120,1,340,3,480],[$Plus: Desired ending inventory,$112,134,135,381],[$Total needed,$1,132,1,254,1,475,3,861],[$Less: Beginning inventory,$102,112,134,102],[$Units to produce,$1,030,1,142,1,341||,3,759]]$

Data table

$\backslash$table$[[$April$..................,1,020$ bikes$],[$May$..,1,120$ bikes$],[$June$....,1,340$ bikes$],[$July $....,1,350$ bikes$]]$