Using Excel Solver Question 2 only

[ad_1]
Q1Allied Freight supplies goods to three customers, who each require 30 units. The company has two warehouses. In warehouse 1, 40 units are available, and shipping one unit from each warehouse to each customer are shown in the file P05-67.xlsx. There is a penalty for eachunsatisfied customer unit of demand: with customer 1, a penalty cost of $90 is incurred; with customer 2, $80; and with customer 3, $110.a. Determine how to minimize the sum of penalty and shipping costs.b. Use Solver Table to see how a change in the unit penalty cost of customer 3 affects the optimal cost.c. Use Solver Table to see how a change in the capacity of warehouse 2 affects the optimal cost.Q2In the United Copiers service center model, we assumed that the potential locations of service centers are the same as existing customer locations. Change the model so that the customer locations are the ones given, but the only potential service center locations are in Memphis, Houston, Cleveland, Buffalo, Minneapolis, St. Louis, and Kansas City. Use Solver to find the optimal solution.

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"