QMB 3301. HW5 Use the Excel model: T1.xlsx to perform a sensitivity analysis on total cost and units transported per route. The two variables to consider are the material availability at the warehouses and the capacity of the routes. The availability of product at the warehouses is to be analyzed at three levels: Level Balanc w high w (units available z (units available 800 700 1500 1300 300 The route capacity is to be analyzed at three levels: Norm al reducedHighly reduced 900 900 270 270 700 1,000 1,000 300 300 1,000 300 1,000 1,000 1,000 150 900 270 900 900 900 135 810 210 210 700 210 700 700 700 630 Develop a report that describes the effect on costs and units transported. Include table(s) and graphis) as deemed necessary. Analyze all 9 possible combinations. QMB 3301. HW5 Use the Excel model: T1.xlsx to perform a sensitivity analysis on total cost and units transported per route. The two variables to consider are the material availability at the warehouses and the capacity of the routes. The availability of product at the warehouses is to be analyzed at three levels: Level Balanc w high w (units available z (units available 800 700 1500 1300 300 The route capacity is to be analyzed at three levels: Norm al reducedHighly reduced 900 900 270 270 700 1,000 1,000 300 300 1,000 300 1,000 1,000 1,000 150 900 270 900 900 900 135 810 210 210 700 210 700 700 700 630 Develop a report that describes the effect on costs and units transported. Include table(s) and graphis) as deemed necessary. Analyze all 9 possible combinations