The Simmons Coal Company produces coal at four mines and ships to four power plants. The following

Question:

The Simmons Coal Company produces coal at four mines and ships to four power plants. The following table shows the cost person or producing coal for each mine, the production capacity (in tons) for each mine, the cost (in dollars) of shipping a ton of coal from each mine to each plant and the number of tons of coal demanded by each customer.

Miue Capacity 125 Production Power Plant Cost 15 6. Mine 1 50 57 55 61 10 12 12 11 130 14 11 Mine 2 Mine 3 100 150 120 1

For example, to produce a ton of coal at Mine 1 and ship it to Plant I would cost $59 ($50 to produce it and $9 to ship it)
c) Enter your model in Excel an use. Solver to find the optimal distribution plan. Include your spreadsheet in your homework submission.

Distribution
The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...