Question
1) There are four plants making automobile parts, and three assembly customers. Each plant has a fixed supply, and each customer has a fixed demand.
1) There are four plants making automobile parts, and three assembly customers. Each plant has a fixed supply, and each customer has a fixed demand. The table below shows the supply and demand information, along with the cost of shipping from a given plant to a given customer. Our objective is to minimize the shipping cost.
| Customer 1 | Customer 2 | Customer 3 | Capacity | |
| Plant 1 | $8 | $12 | $4 | 100 |
| Plant 2 | $14 | $9 | $8 | 300 |
| Plant 3 | $11 | $15 | $6 | 200 |
| Plant 4 | $20 | $2 | $15 | 300 |
| Demand | 400 | 200 | 300 |
Which of the following shows the left hand side of supply constraint for Plant 4. Use the template given in "Transportation" sheet of the excel
Group of answer choices
=SUM(C20:E20)
=SUM(E17:E20)
=SUMPRODUCT(E17:E20)
=SUMPRODUCT(C20:E20)
2) What is the optimal shipment quantity from Plant 3 to Customer 1?
100
0
300
200
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
Management Accounting And Strategic Human Resource Management
Authors: John Innes, Reza Kouhy
1st Edition
1859714862, 978-1859714867
