Please see furniture Max excel graph

A furniture manufacturer, Furniture Max (simply FMax), has three warehouses (1, 2, 3) and three retail stores (4, 5, 6), which are located in six different cities. The network below indicates the routes and the costs between two cities. The value on an arc indicates the cost required to transport one truckload from one city to another. The number beside a warehouse (node 1, 2, or 3) indicates the supply of furniture in that warehouse. The number beside a retail store (node 4, 5, or 6) indicates the demand of furniture in that store. Use Answer report and sensitivity report to answer question.

b) Suppose the retail store in city 4 would like to be supplied by more than one route to reduce risk of supply delay or interruption. Explain which route should it consider such that an alternative solution with the same least cost would result. Give one alternative solution.

(c) Suppose the retail store in city 4 would like to be supplied by more than one route to reduce risk of supply delay or interruption. Explain which route should it consider such that an alternative solution with the same least cost would result. Give one alternative solution. [5 marks]

(d) Suppose the three cities 4, 5 and 6 (with retail stores) are each expected to experience 10% increase in demand during the National Day public holiday period. Determine the impact on the current optimal solution or explain whether the model needs to be resolved. [7 marks]

(e) Suppose the travel restriction from city 2 has tightened recently due to the local health condition and the manufacturer can only transport 80% of its current supply from its warehouse. Knowing this situation, the demand in cities 4 and 5 will likely increase by 10% each as they are directly connected to city 2. Determine the impact on the current optimal solution or explain whether the model needs to be resolved.

Variahla ralle Microsoft Excel 16.0 Sensitivity Report Worksheet: [Lecture 4 Examples.xIsx]FurnitureMax Report Created: 2022-10-05 2:06:54 PM Variable Cells Variahla ralle Microsoft Excel 16.0 Sensitivity Report Worksheet: [Lecture 4 Examples.xIsx]FurnitureMax Report Created: 2022-10-05 2:06:54 PM Variable Cells