3 Inventory Holding Costs, actuals > December 4,009 units; $3759 - January 6,450 units; $6554 > February 2,200 units; $2347- J Current Inventory Level (month of March) - 4000 units > J Month Apr May - Jun J Jul Aug- Pipeline Confirmed Sales Expected Addtl Sales 12,000 J 16,000 19,500 - 13,500 15,000 0- 2,000 - 4,500 - 6,500 7,000 - Production cost ($ per tire) - Avg unit price ($ per tire) - Max production level 11- 11 12 11 11- 52.54 58.32- 54.55 - 65.23 53.55 18,000 18,000 30,000 - 18,000 18,000 Min production level 6,000 - 6,000 J Max inventory level 10,000 - 10,000 - 6,000 15,000 J 6,000 J 6,000 J 10,000 - 10,000 - Min inventory level 2,000 - 2,000 J 2,000 J 2,000 J 2,000 QUESTION What is total cost for the optimal production plan (inventory cost plus cost to build, excluding March)? (Express your answer as a plain number IN THOUSANDS, no dollar sign; e.g., for a cost of $35,950 input "35.95") QUESTION 2 Upon inspection of your completed optimization model, which elements of this business scenario might be explored if seeking a better production plan? Revenue per tire Production unit maximums Production unit minimums Inventory holding costs Inventory unit maximums Inventory unit minimums Unit production costs 3 points Save Answer 7 points Save Answer QUESTION 3 3 points Save Answer In a production plan optimization model, it is possible that there exists an alternative plan with the same total cost as the identified optimal plan. True False QUESTION 4 Your director requested a cost/benefit analysis regarding elimination of the production policy that requires holding inventory. What would be the optimal total production cost, if there were no inventory minimums? (Express your answer as a plain number IN THOUSANDS, no dollar sign; e.g., for a cost of $35,950 input "35.95") 4 points Save Answer QUESTION 5 3 points Save Answer The optimization model under a zero-minimum inventory requirement still suggests that we hold inventory in certain months (despite the cost) in order to minimize COGS. True False QUESTION 6 Please attach your excel file here. Attach File Browse Local Files Browse Content Collection Browse Dropbox 0 points Save