I know that the beginning inventory is wrong where it says 500 and 700, I forgot to get rid of it.

pters 11 and 13) i Saved Dundas Bike Components Inc. of Wheelville, Illinois, manufactures bicycle wheels in two different sizes for the Big Bike Co. assembly plant located across town. David Dundas, the firm's owner-manager, has just received Big Bike's order for the next six months. 20-Inch Wheels 24-Inch Wheels Nov. 1,000 units 500 units Dec 900 500 Jan. 600 300 Feb. 700 500 Mar. 1,100 400 Apr. 1,100 600 Click here for the Excel Data File Currently, Dundas employs 28 full-time, employees, each of whom can produce 50 wheels per month in addition to their other tasks. Because labor is in short supply in the Wheelville area, David would like to develop one pure level-output plan. There is no inventory of finished wheels on hand at present, but David would like to have 300 on hand at the end of April. Big Bike will tolerate back orders of up to 200 units per month. Show your level plan in tabular form and calculate the total annual cost of your plan using these costs: (Round your Average, Overtime, Inventory and Total values to 1 decimal place. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "O" wherever required.) Hints: 1) If overtime is used, the amount produced using overtime should be the same in every period except the last month when overtime will be 0. 2) Check the cost of two possible plans: a) Using overtime without hiring additional employees, b) Hiring additional employees without using overtime. Fill in the table below with the solution which has the lower cost. Regular Overtime Part-time Subcontract $ 50 Hiring $ 75 Layoff NA Inventory NA Back order $ 300 $ 400 $1.00 $6.00 e to search DIE W Nov. Dec. Jan. Feb. Mar. April Total 1,500 1,400 1,400 1,400 900 1,400 1,200 1,400 1,500 1,400 1,700 1,400 8,200 8,400 TE 0 0 500 700 600 Forecast Output Reg. Output Part Time Output Overtime Output Subcontract Output Minus Forecast Inventory Begin Ending Average Backlog Cost Reg. @ 50 Cost Part Time Cost Overtime @ 7.5 Hire/Layoff Inventory @ 1 Backorders @6 Totals Nov. Dec. Jan. Feb. Mar. April Total Forecast Output Reg. Output Part Time Output Overtime Output Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Cost Regular @ 50 Cost Part Time Cost Overtime @ 7.5 Subcontract Hire/Layoff Inventory @ 1 Backorders @6 Totals