Trader Cycles manufactures chainless bicycles. On March 31, Trader Cycles had 108 bikes In Inventory. The company has a policy that the ending Inventory in any month must be 10% of the following month's expected sales. Trader Cycles expects to sell the following number of bikes in each of next four months: E (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 Unit sales 1,000 1,160 Plus: Desired ending inventory 324 34B Total needed 14041 1508 Quarter June 1.300 3,540 390 390 1690 4602 Less: Beginning inventory Units to produce Trader Cycles manufactures chainless bicycles. On March 31, Trader Cycles had 108 bikes In Inventory. The company has a policy that the ending Inventory in any month must be 10% of the following month's expected sales. Trader Cycles expects to sell the following number of bikes in each of next four months: E (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 Trader Cycles Production Budget For the Months of April through June April May Unit sales 1,000 1,160 Plus: Desired ending inventory 324 34B Total needed 14041 1508 June 1.300 3901 April 1,080 bikes 1890 May 1.160 bikes Less: Beginning inventory June July 1,300 bikes 1.230 bikes Units to produce Print Done