Texts: some of it was wrong
Trent Cycles manufactures chainless bicycles. On March 31, Trent Cycles had 318 bikes in inventory. The company policy is that the ending inventory in any month must be 30% of the following month's expected sales. Trent Cycles expects to sell the following number of bikes in each of the 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.
Trent Cycle Production Budget
Data table
For the Quarter ended June 30
Month April May June 2nd Quarter
Unit sales 1,060 bikes 1,110 bikes 1,320 bikes 1,340 bikes
Plus: Desired ending inventory 333 bikes 396 bikes 402 bikes
Total needed 1,393 bikes 1,506 bikes 1,722 bikes 1,742 bikes
Less: Beginning inventory (318 bikes)
Units to produce 1,075 bikes 1,188 bikes 1,404 bikes 1,424 bikes
Print