4. Use Excel Solver

A company wants to minimize the cost of transporting its product from its warehouses (2) to its stores (3).

If the load leaves warehouse A, the cost of the unit transported to store C is $8, to store D is $6, and to store E is $3.

If the load leaves warehouse B, the cost of the unit transported to store C is $2, to store D is $4, and to store E is $9.

Store C demands a minimum quantity of 40 units. Store D demands a minimum quantity of 35 units. Store E demands a minimum quantity of 25 units. Warehouse A cannot store more than 70 units.

Warehouse B cannot store more than 40 units. Answer:

1. Find the minimum cost.

2. Find how many units are stored in warehouse A and warehouse B

3. Find the cost of bringing products to store E.

4. Do the above results change if the cost of the transported unit leaving the

store A to store C, is it $12 instead of $8?