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 optimal quantity to ship from Factory B to Customer 3? Multiple Choice 25 units 50 units 75 units 100 units 125 units

Answered: A manufacturing firm has four plants…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

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 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 optimal quantity to ship from Factory B to Customer 3?

Multiple Choice