Share
Explore BrainMass

Mathematics - Numerical Analysis (LPP using Excel Solver)

Need help with the following problem, am stuck trying to set it up correctly. Can you help with the objective function and constraints, also the formulas for solver.

John Taylor's construction company currently has three projects under way in various counties of Iowa. Each requires a specific supply of gravel. Three gravel pits are available in Iowa to provide for Smith's needs, but shipping costs differ from location to location. The table below summarizes the problem Smith faces. Determine the optimal shipping assignment so as to minimize total cost.

FromTo - Job 1 - Job 2 - Job 3 | Tonnage Allowance

Dubuque pit - $6 - $8 - $10 | 150
Davenport pit - $7 - $11 - $11 | 175
Des Moines pit - $4 - $5 - $12 | 275
Job requirements:
(in tons) - 200 - 100 - 300 | 600

Solution Preview

John Taylor's construction company currently has three projects under way in various counties of Iowa. Each requires a specific supply of gravel. Three gravel pits are available in Iowa to provide for Smith's needs, but shipping costs differ from location to location. The table below summarizes the problem Smith faces. Determine the optimal shipping assignment so as to minimize total cost.

FromTo - Job 1 - Job 2 - Job 3 | Tonnage Allowance

Dubuque pit - $6 - $8 - $10 | 150
Davenport pit - $7 - $11 - $11 | 175
Des Moines pit - ...

Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached file.

$2.19