Assignment $5$: Network Models

Answer the following short questions:

What is a balanced transportation model? Describe the approach you would use to solve an

unbalanced model.

What is a flow balance constraint? How is it implemented at each node in a network model?

Transportation Problem:

A food distribution company ships fresh spinach from its four packing plants to large East$-$Coast cities.

The shipping costs per crate and the supply and demand are shown in the table below.

a$)$ Formulate a model that will permit the company to meet its demand at the lowest possible cost.

b$)$ The company wishes to spread out the source for each of its markets to the maximum extent

possible. To accomplish this, it will accept a $5\%$ increase in its total transportation cost from part $($a$).$

What is the new transportation plan, and what is the new cost? DO IT UN EXCEL, USE EXCEL SOLVER TO DO THIS TASK $($ I NEED PICTURES OF FORMULAS AND HOW YOU DID IT$)$