Susan wants to determine how much to haul from each quarry to each construction so that the total cost of purchasing and hauling the gravel is minimized. Solve using Excel Solver step by step.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 103P
icon
Related questions
Question
100%
A contractor, Susan Meyer, has to haul gravel to three buildings.
She can buy up to 18 tons from a quarry located to the north of
the city and 14 tons from one to the south. She needs 10, 5 and
10 tons in the respective constructions 1, 2 and 3. The purchase
price per ton in each quarry and the haulage costs are as follows:
Quarry
North
South
$
$
1
Cost per ton hauled
2
100 $
180 $
3
Price per ton
300
$
420
90 $
160
110 $ 140 $
Susan wants to determine how much to haul from each quarry
to each construction so that the total cost of purchasing and
hauling the gravel is minimized.
Solve using Excel Solver step by step.
Transcribed Image Text:A contractor, Susan Meyer, has to haul gravel to three buildings. She can buy up to 18 tons from a quarry located to the north of the city and 14 tons from one to the south. She needs 10, 5 and 10 tons in the respective constructions 1, 2 and 3. The purchase price per ton in each quarry and the haulage costs are as follows: Quarry North South $ $ 1 Cost per ton hauled 2 100 $ 180 $ 3 Price per ton 300 $ 420 90 $ 160 110 $ 140 $ Susan wants to determine how much to haul from each quarry to each construction so that the total cost of purchasing and hauling the gravel is minimized. Solve using Excel Solver step by step.
Expert Solution
steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,