Case $4.$ Highway Expansion $(15\%)$

Task $1$:

Use the file $4.$ Highway Expansion$\_$Template.xlsx to find an optimal solution by allocating supplier capacity to demand of Granular A and B in the six areas. One worksheet $$Template$$ was already created and all necessary setup was completed to facilitate your work.

Answer the following questions:

$1.$ What are your total costs using Solver compared with the current proposed total costs? How much did you save, if applicable?

$2.$ Does each supplier exceed the $50\%$ rule?

$3.$ Does your Solver allocation allow $3\%$ discount rule for Supplier $3?$ How much is your total cost after applying the $3\%$ discount on Supplier $3?$