Suppose Foster Generators face the following transportation problem. Foster Generators operates plants in Dallas (TX); Ann Arbor (MI) and Chester (PA). Production capacities over the next three-months planning period for one particular type of generator are as follows:

The firms distributes its generators through three regional distribution centers located in Seattle, New York and Los Angeles; the three-month forecast of demand for the distribution centers is as follows:

Unit cost per shipment from source of origin to distribution centers are shown as follows:

1. Construct a mathematical formulation of the given transportation problem 2. Solve the given transportation problem using Excel Solver. In other words, what is the optimal level of shipment from each plant to each distribution center? What is the minimum total shipping cost at those optimal shipments? Please note that you are required to provide an answer report you generated and provide a discussion on the above-mentioned issues, using at least 100 words