Mathematics - Numerical Analysis (LPP using Excel Solver)
Not what you're looking for?
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
Purchase this Solution
Solution Summary
A Complete, Neat and Step-by-step Solution is provided in the attached file.
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 - ...
Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Probability Quiz
Some questions on probability
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.