Answered You can hire a professional tutor to get the answer.
The question is listed clearly Need help with the questions and also the excel file the question is mentioned in the image. The question is clearly
The question is listed clearly
Need help with the questions and also the excel file the question is mentioned in the image. The question is clearly metioned in the image
List five factors that determine the optimal number of warehouses in a product distribution network. (b) You are appointed the manager of a warehouse that is transitioning from a traditional model to a supply chain mode. Identify two initiatives you would take to update the warehouse. (c) Weber has two production plants (P1, P2), from which it ships barbeque grills to its three national warehouses (W1, W2, W3). From these warehouses it feeds the supply chain of Lowes through eight regional distribution centers (D1, D2, D3, D4, D5, D6, D7, D8). The shipping costs between these locations, plant supply capacity and the weekly supply demand data in cases are shown below: Supply Shipping Cost Weekly Shipping Cost Capacity W1 W2 W3 Demand W1 W2 W3 P1 30000 $3.25 $4.50 $1.25 D1 8000 $4 $3 $1 P2 30000 $4.40 $1.50 $1.00 D2 13500 $3 $4 $1 D3 11900 $2 $5 $4 D4 3200 $1 $6 $2 D5 1400 $1 $3 $5 D6 800 $5 $2 $3 D7 6800 $4 $1 $2 D8 900 $5 $2 $1 (i) Solve the network distribution problem via LP using MS-Solver (ii) Plant P2 needs to shut down one of its assembly lines and the capacity is reduced to 23000 units. What is the new distribution plan, and what is the additional supply chain cost. (iv) If the W2 warehouse has a maximum distribution capacity of 12000 units/week how does the solution in (i) change? (v) If the production costs at P1 are $0.80 higher than P2, how does the solution in (i) change?
