A contractor is planning a job that will require a large amount of gravel and sand. The estimates for the necessary gravel and sand are: Coarse gravel Fine gravel Sand 20,000 yd³ 29,000 yd³ 20,000 yd³ There are two pits from which material can be obtained, and the plan is to haul from these two pits and to separate (screen) on the job whatever material is needed. Analysis shows that the material at each pit has the following composition: Pit A Pit B Coarse gravel Fine gravel Sand Waste 20% 14% 25% 41% 30% 50% 20% 0%

Elementary Geometry For College Students, 7e
7th Edition
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Alexander, Daniel C.; Koeberlein, Geralyn M.
Chapter9: Surfaces And Solids
Section9.4: Polyhedrons And Spheres
Problem 23E: The surface of a soccer ball is composed of 12 regular pentagons and 20 regular hexagons. With each...
icon
Related questions
Question
A contractor is planning a job that will require a large amount of gravel and sand. The
estimates for the necessary gravel and sand are:
Coarse gravel
Fine gravel
Sand
20,000 yd³
29,000 yd³
20,000 yd³
There are two pits from which material can be obtained, and the plan is to haul
from these two pits and to separate (screen) on the job whatever material is needed.
Analysis shows that the material at each pit has the following composition:
Pit A
Pit B
Coarse gravel
Fine gravel
Sand
Waste
20%
14%
25%
41%
30%
50%
20%
0%
It costs $8/yd³ for material and hauling from pit A and $16/yd³ from pit B. Set
this up as a linear programming problem to minimize delivered cost.
Formulate and Solve with graphical solution method AND with Excel (Provide
Model, Answer and Sensitivity Report)
Transcribed Image Text:A contractor is planning a job that will require a large amount of gravel and sand. The estimates for the necessary gravel and sand are: Coarse gravel Fine gravel Sand 20,000 yd³ 29,000 yd³ 20,000 yd³ There are two pits from which material can be obtained, and the plan is to haul from these two pits and to separate (screen) on the job whatever material is needed. Analysis shows that the material at each pit has the following composition: Pit A Pit B Coarse gravel Fine gravel Sand Waste 20% 14% 25% 41% 30% 50% 20% 0% It costs $8/yd³ for material and hauling from pit A and $16/yd³ from pit B. Set this up as a linear programming problem to minimize delivered cost. Formulate and Solve with graphical solution method AND with Excel (Provide Model, Answer and Sensitivity Report)
Expert Solution
steps

Step by step

Solved in 5 steps with 14 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
Elementary Geometry for College Students
Elementary Geometry for College Students
Geometry
ISBN:
9781285195698
Author:
Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:
Cengage Learning
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell