Homework 3

Prb6_14_empty.xlsm

Production Schedule

		Variable			Binary	Linking
Machine	Fixed Cost	Cost	Capacity	Quantity	Variable	Constraint
1	$1,000	$21	500
				A satisfied Microsoft Office user: Variable cell	A satisfied Microsoft Office user: Variable cell	2	$950	$23	600
				A satisfied Microsoft Office user: Variable cell		A satisfied Microsoft Office user: Constraint cell	A satisfied Microsoft Office user: Variable cell	3	$875	$25	750
				A satisfied Microsoft Office user: Variable cell		A satisfied Microsoft Office user: Constraint cell	A satisfied Microsoft Office user: Variable cell	4	$850	$24	400
				A satisfied Microsoft Office user: Variable cell		A satisfied Microsoft Office user: Constraint cell	A satisfied Microsoft Office user: Variable cell	5	$800	$20	600
				A satisfied Microsoft Office user: Variable cell		A satisfied Microsoft Office user: Constraint cell	A satisfied Microsoft Office user: Variable cell	6	$700	$26	800
				A satisfied Microsoft Office user: Variable cell		A satisfied Microsoft Office user: Constraint cell	A satisfied Microsoft Office user: Variable cell	Available
				A satisfied Microsoft Office user: Constraint cell		A satisfied Microsoft Office user: Constraint cell	Required	1800
		Total Variable Cost		$0
		Total Fixed Cost		$0
		Total Cost
				A satisfied Microsoft Office user: Objective cell

Radford Castings