Homework 3

mrsaiz
Prb6_23_empty_Solver.xlsx
Home>Business & Finance homework help>Accounting homework help>Homework 3

Module1

Machine Scheduling

Units Run of Each Machine Unit Production Costs
Machine A B C A B C
1
A satisfied Microsoft Office user: Variable cell
A satisfied Microsoft Office user: Variable cell		 $13 $9 $10 Production Cost: $0
2
A satisfied Microsoft Office user: Variable cell
A satisfied Microsoft Office user: Variable cell
A satisfied Microsoft Office user: Variable cell		 $11 $12 $8 Setup Cost: $0
Produced
A satisfied Microsoft Office user: Constraint cell
A satisfied Microsoft Office user: Variable cell
A satisfied Microsoft Office user: Constraint cell
A satisfied Microsoft Office user: Constraint cell		 Total Cost:
Needed 3 7 4
Setups on Each Machine Setup Costs
Machine A B C A B C
1
A satisfied Microsoft Office user: Variable cell
A satisfied Microsoft Office user: Variable cell		 $55 $93 $60
2
A satisfied Microsoft Office user: Variable cell
A satisfied Microsoft Office user: Variable cell
A satisfied Microsoft Office user: Variable cell
A satisfied Microsoft Office user: Objective cell
A satisfied Microsoft Office user: Variable cell		 $65 $58 $75
Run Time per Unit
Machine A B C Used Available
1 0.4 1.1 0.9
A satisfied Microsoft Office user: Constraint cell		 8
2 0.5 1.2 1.3
A satisfied Microsoft Office user: Constraint cell		 6
Linking Constraints
Machine A B C
1

A satisfied Microsoft Office user: Constraint cell
A satisfied Microsoft Office user: Constraint cell		 2

A satisfied Microsoft Office user: Constraint cell
A satisfied Microsoft Office user: Constraint cell
A satisfied Microsoft Office user: Constraint cell
A satisfied Microsoft Office user: Constraint cell

Manufacturing Plan