A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Factory (capacity) A (100) B (75) C (100) D (250) Customer (requirement) Customer 1 Customer 2 Customer 3 (125) $15 $20 $22 $21 (150) $10 $12 $20 $15 (175) $20 $19 $25 $28 Customer 4 (75) $17 $20 $14 $12 Note: This question requires Solver. Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer requirements?
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Factory (capacity) A (100) B (75) C (100) D (250) Customer (requirement) Customer 1 Customer 2 Customer 3 (125) $15 $20 $22 $21 (150) $10 $12 $20 $15 (175) $20 $19 $25 $28 Customer 4 (75) $17 $20 $14 $12 Note: This question requires Solver. Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer requirements?
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.1: Prisms, Area And Volume
Problem 37E: Zaidah plans a raised flower bed 2 ft high by 12 ft wide by 15 ft long. The mulch, soil, and peat...
Related questions
Question
Transcribed Image Text:A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements its four
customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are
shown in the table below:
Factory
(capacity)
A (100)
B (75)
C (100)
D (250)
Customer 1
(125)
$15
A. $10,050
B. $9,000
C. $9,100
D. $8,950
E. $8,750
$20
$22
$21
Customer (requirement)
Customer 2 Customer 3
(150)
$10
$12
$20
$15
(175)
$20
$19
$25
$28
Customer 4
(75)
$17
$20
$14
$12
Note: This question requires Solver.
Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer
requirements?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Recommended textbooks for you
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill