QSO 320 Mgmt Science Thru Spread Sheets Problem 5-13 Shipments: To Flow balance equations From Job 1 Job 2 Job 3 Flow out Location Flow in Flow...

3.5 Ratings (596 Votes)

See Answer

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

QSO 320 Mgmt Science Thru Spread Sheets Problem 5-13

Shipments:	To				Flow balance equations
From	Job 1	Job 2	Job 3	Flow out	Location	Flow in	Flow out	Net flow	Sign	RHS
Central				0.0	Central	0	0	0	>=	-3000
Rock				0.0	Rock	0	0	0	>=	-4000
Acme				0.0	Acme	0	0	0	>=	-6000
Flow in	0.0	0.0	0.0		Job 1	0	0.0	0	=	2500
					Job 2	0	0.0	0	=	3750
Unit costs:	To				Job 3	0	0.0	0	=	4850
From	Job 1	Job 2	Job 3
Central	$9	$8	$7
Rock	$7	$11	$6
Acme	$4	$3	$12

Total cost =	$0		<--- Minimize total transportation costs.Formula = SUMPRODUCT(B5:D7,B12:D14)

Note:
Once all values are entered in the appropriate shaded areas, go tothe DATA tab on the Excel sheet ribbon, click on the Data AnalysisGroup, and then choose Solver. Click SOLVE to run Excel's Solveradd-in to obtain the optimized solution. Note that if Solver is noton the DATA tab, refer to the Help file (Solver) for instructionsor pages 569–571 of Balakrishnan (2013) Managerial DecisionModeling With Spreadsheets. For more information on enteringinformation in Solver, refer to pages 44–49 of Balakrishnan (2013).To learn more about how to set up and solve linear programming (LP)problems, refer to pages 40–51 of Balakrishnan (2013). For the changing variable cells (yellow shaded), the initialentries in the cells can be blank or any value of your choice basedon the given constraints.

Other questions asked by students