Supply chain management question, have to use excel solver to solve. HELPPP PLEA

Question

Supply chain management question, have to use excel solver to solve. HELPPP PLEASEEE

problem codebook solution Sheet3 The table gives distances between Boston, Chicago, Dallas, LA and Miami. Each city requires 40,000 kilowatt hours (kWh) of power; and Chicago, Dallas and Miami are capable of producing 70,000 kWh. Assume that shipping 1000 kWh over 100 miles costs $4. From where should power be sent to minimize the cost of meeting each city's demand? All shipmen are in 1000's of kwh Distance Boston Chicago Dallas LA Miami Chicago Dallas Miami 983 1815 1539 1205 2112 801 2757 1390 1205 1390 1332 1332

Explanation / Answer

Cost of tranportation power to these cities is = $ 38,912

Boston chicago Dallas LA Miami Capacities Chicago 983 ($ 6291.20) (30,000) 0 ( 40,000 ) 1205 ($ 7712) 2112($ 13516.80) 1390($ 8896) 70,000 Dallas 1815 ($ 11,616) 1205 ($ 7712) 0 ( 40,000) 801 ($ 5126.40) (30,000) 1332 ( $ 8524.80) 70,000 Miami 1539 ( $ 9849.60)(10,000) 1390 ( $ 8896) 1332 ( $ 8524.80) 2757 ( $ 17,644.80) (10,000) 0 (40,000) 70,000 Requirement 40,000 40,000 40,000 40,000 40,000 The cost of tranportation will be = $ 6291.20+ 0 + 0 + $ 5126.40 + $ 9849.60+$ 17,644.80

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.