A niche bicycle manufacturer manufactures bicycles in two different sizes. David, the company's owner-manager, has just received the following forecasts for the next six months. 16inch 20inch Nov. 1,000 units 500 units Dec. 900 500 Jan. 600 300 Feb. T00 500 Mar. 1,100 400 Apr. 1,100 600 a. This part of the question is not part of your Connect assignment. b. Suppose the forecast for the two sizes of bikes are summed to obtain one forecast for each month. Currently David employs 27 full- time, highly skilled employees, each of whom can produce 50 bikes per month. Because skilled labour is in short supply in the area, David would like to keep them permanently. There is no inventory on hand at present. but David would like to have 300 units on hand at the end of April. A maximum of 200 bikes can be produced during overtime each month. Determine the minimum cost plan using these unit costs: Hint. Use overtime in November, December, and April. (Do not leave any empty spaces; input a "O" wherever it is required. Negative answers should be indicated by a minus sign.) Regular $50 per unit Inventory $2.00 per month Overtime $75 per unit Backorder $10.00 per month Period Nov Dec Jan Feb Mar Apr Total Forecast 1,500 1,400 900 1,200 1,500 1,700 8,200 Output Regular Overtime OutputForecast Inventory Beginning Ending Average Backorder COStE : Regular @ $50 Overtime @ $15 Inventory 0 $2 Backorder @ $10 Total $