Question
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
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:
| Customer (requirement) | ||||||||||||
| Factory (capacity) | Customer 1 (125) | Customer 2 (150) | Customer 3 (175) | Customer 4 (75) | ||||||||
| A (100) | $ | 15 | $ | 10 | $ | 20 | $ | 17 | ||||
| B (75) | $ | 20 | $ | 12 | $ | 19 | $ | 20 | ||||
| C (100) | $ | 22 | $ | 20 | $ | 25 | $ | 14 | ||||
| D (250) | $ | 21 | $ | 15 | $ | 28 | $ | 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?
Group of answer choices
$8,750
$8,950
$9,000
$9,100
$10,050
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Strategic Management
Authors: John Pearce , Richard Robinson
13th Edition
0078029295, 978-0078029295
