I need help specifically with the spreadsheets and using Solver! Step by step would be best if possible! Thank you!

Scenario: Doll Crafters is planning on setting up a distribution network.

Dolls from various factories must be transported to the various retail locations.

Factories are as follows $($with the number of with number of doll production capacities$)$

Factory $1(400)$

Factory $2(1600)$

Factory $3(200)$

Factory $4(1300)$

Factory $5(500)$

There are three retail locations $($with demand$)$

Location $1$

$(1000)$

Location $2$

$(1000)$

Loc. $3(1500)$

The respective transportation cost $($$$)$ per doll is given as follows:

Part A$.$ Please formulate by hand:

Identify the correct variables $($including labeling$).$

Set up the objective function.

Set up the respective constraints including non$-$negativity.

Part B$.$ Please set up the problem onto your spreadsheet. You will need to locate

Solver $($add$-$on QM is not needed$).$ Use solver to come up with the optimal

transportation plan and provide a cost.

Part C$.$ Additional to the scenario due to a grass fire near Location $2$ this retail outlet

will be closed and not be selling any dolls. Reformulate the problem by hand.

Identify the correct variables $($including labeling$).$

Set up the objective function.

Set up the respective constraints including non$-$negativity.

Part D$.$ Please set up the revised problem in Part C onto your spreadsheet. You will

need to locate Solver $($add$-$on QM is not needed$).$ Use solver to come up with the

optimal transportation plan and provide a cost. Explain difference in costs & flow

patterns between Part B and D$.$