Homework 3

profilemrsaiz
Prb6_30_empty.xlsm
Home>Business & Finance homework help>Accounting homework help>Homework 3

Ship Loading

Total Max Total Max
1 2 3 4 Weight Weight Volume Volume
Forward
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell		 3000 145000
Center
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell		 6000 180000
Rear
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell		 4000 155000
Loaded

Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell		 Available 4800 2500 1200 1700
Volume / ton 40 25 60 55
Profit / ton $70.0 $50.0 $60.0 $80.0
Total Profit

Cliff Ragsdale: Objective cell		 Weight Balance Constraints
min max
Forward 0 0 within 10% of rear
Center 0 0 between 40 to 60% of total
Binary Variables 1 2 3 4 Sum
Forward

Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell		 Center

Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell		 Rear

Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Variable cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Variable cell		 Linking Constraints 1 2 3 4
Forward

Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell		 Center

Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell		 Rear

Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell
Cliff Ragsdale: Constraint cell

ICC