[Solved] Please Show Excel Thanks Distribution Costs Los Angeles San Diego Seattle Demand Requeste Q37230987

⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀

……

Please show excel thanks

Distribution Costs Los Angeles San Diego Seattle DemandRequested (MWs) Seattle $ 436.85 $ 591.35 $ 94.58 908.08 Portland $356.25 $ 593.75 $ 138.15 803.25 San Francisco $ 178.13 $ 275.00 $296.88 2450.10 Boise $ 356.25 $ 375.00 $ 296.88 499.75 Reno $237.50 $ 475.00 $ 356.25 895.36 Bozeman $ 415.63 $ 412.63 $ 196.88553.65 Laramie $ 346.13 $ 412.63 $ 356.25 1083.52 Park City $356.25 $ 346.25 $ 465.20 715.55 a. Assuming there are norestrictions on the amount of power that can be supplied by any ofthe power plants, what is the optimal solution to this problem?What is the total annual power distribution cost for this solution?[In addition to optimal solution, provide the mathematicalformulation and Excel Model.] b. In reality, however, there aresome restrictions on the supply as follows.  Each power plant hasa maximum capacity of 3,800 MWs of power to be supplied,  Thecompany requires that the supply for the power plant in San Diegoto be at least 20% of the total supply by CSUSM power plants, Giventhese realistic constraints, what is the optimal solution? What isthe annual increase in power distribution cost that results fromadding these constraints to the original formulation? c. In part b,if the power demand for Boise increases by 300 MWs, how much theoptimal total cost will increase? Assuming that the total demandrequested by cities can increase, which city’s extra demand will bemore costly to be satisfied? Use shadow prices from sensitivityreport to answer this question. d. Is there any alternative optimalsolution? Provide your formulation or spreadsheet model.

Expert Answer

---

Answer to ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀�… . . .