Problem 5-13
Shipments:
From
Central
Rock
Acme
Flow in Job 1 0.0 Unit costs:
From
Central
Rock
Acme Job 1
$9
$7
$4 Total cost = $0 To
Job 2 0.0
To
Job 2
$8
$11
$3 Job 3 0.0 Flow out
0.0
0.0
0.0 Location
Central
Rock
Acme
Job 1
Job 2
Job 3 Flow balance equations
Flow in Flow out Net flow
0
0
0
0
0
0
0
0
0
0
0.0
0
0
0.0
0
0
0.0
0 Sign
>=
>=
>=
=
=
= Job 3
$7
$6
$12
<--- Minimize total transportation costs. Formula = SUMPRODUCT(B5:D7,B12:D14) Note: Once all values are entered in the appropriate shaded areas, go to the DATA tab on the Excel sheet ribbon,
click on the Data Analysis Group, and then choose Solver. Click SOLVE to run Excel's Solver add-in to
obtain the optimized solution. Note that if Solver is not on the DATA tab, refer to the Help file (Solver) for
instructions or pages 569–571 of Balakrishnan (2013) Managerial Decision Modeling With Spreadsheets.
For more information on entering information 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 initial entries in the cells can be blank or any value of
your choice based on the given constraints. ns
RHS
-3000
-4000
-6000
2500
3750
4850 CT(B5:D7,B12:D14) Problem 5-13 (Transshipment)
Shipments:
From
Central
Rock
Acme
Flow in To
Job 1 Job 2 Job 3 Acme Flow out
0.0
0.0
0.0
0.0
0.0
0.0
0.0 Unit costs:
From
Central
Rock
Acme Job 1
$9
$7
$4 Total cost = $0 To
Job 2 Job 3 Acme
$8
$7
$1
$11
$6
$1
$3
$12
$0 Location
Central
Rock
Acme
Job 1
Job 2
Job 3 Flow balance equations
Flow in Flow out Net flow
0
0
0
0
0
0
0.0
0
0.0
0
0
0
0
0
0
0
0
0 Note: Once all values are entered in the appropriate shaded areas, go to the DATA tab on the Excel sheet
ribbon, click on the Data Analysis Group, and then choose Solver. Click SOLVE to run Excel's Solver addin to obtain the optimized solution. Note that if Solver is not on the DATA tab, refer to the Help file (Solver)
for instructions or pages 569–571 of Balakrishnan (2013) Managerial Decision Modeling With
Spreadsheets. For more information on entering information 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 initial entries in the cells can be blank or any value of
your choice based on the given constraints. quations
Sign RHS
>=
-3000
>=
-4000
>=
-6000
=
2500
=
3750
=
4850

 

• 1503042437-qso320_mod6_problem_5-13.xlsx

AccountingQueen

(3)

Status NEW Posted 18 Aug 2017 07:08 AM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer