Using Excel Solver:

Car Parker, a mediocre car dealership with two locations in the Midwest (Wayoutthere and Overhere), has requested 100 cars for each dealership (so they want 200 total) from its two finest suppliers, WeSellem and Utotem. WeSellem has 80 cars available and Utotem has 120. WeSellem ships to Wayoutthere for $200 per car and to Overhere for $100 per car, while Utotem ships to Wayoutthere for $200 per car and to Overhere for $50 per car. Charlie Parker, the assistant to the General Manager, has told WeSellem that Wayoutthere only wants at most 70 of their vehicles. Use Excel to solve the linear programming problem that will minimize the cost of shipping the 200 cars desired by Car Parker, given the constraints in the story and include your Excel file with at least an answer and sensitivity report. Also answer the following:

a-what is the minimum cost of shipping?

b-how much is shipped from each supplier to each location?

c-Charlie wonders how much it cost him, if anything, to limit the number of cars to 70 from Wesellem to Wayoutthere. Where would Charlie look on the sensitivity report to find this information and what would he find as the impact on the bottom line?

d-Charlie wakes up in a cold sweat that morning and wonders what would the impact on the cost of shipping would be if he just limited the number of cars to 75 at WeSellem, given all the other information in the problem. Where would Charlie look on the sensitivity report to find this information and what would he find as the impact on the bottom line?