homework week 9 please use the excel sheet that is with home work

hw9_answer_sheet_2015.xlsx

P1 and P2

The Livewright Medical Supplies Company
			South	East	Midwest
		Earning	600	540	375
						Constraint
		Expense	80	70	50		<=	750	Budget constraint
							<=	5	Southern region must have no more than 5 sales people
	Decision variables						All decision variables MUST BE integers
	Objective function		Maximize Profits
Solve the mixed integer linear programming model
		x1	x2	x3
	coefficients	5	6	4
	constraints	5	3	6		<=	20
		1	3	0		<=	12
		x1	x2	x3
		>= 0, Real	>= 0, integer	>= 0, real			x2 must be integer
	DV
	Objective
		Maximixe Z

&"Helvetica,Regular"&12&K000000 &P

Texas Consolidated Electronics Company
		Project	Expense ($1,000s)	Management Scientists required	Estimated Profit
					(1,000,000s)	Project Selection constraints
		1	$60	7	$0.36
		2	110	9	0.82
		3	53	8	0.29
		4	47	4	0.16
		5	92	7	0.56
		6	85	6	0.61
		7	73	8	0.48
		8	65	5	0.41
	Constraints
			<=	<=
			300	40
	DV	Project
		1
		2			Please include the following constraints in your solutions
		3
		4			Note: project 5 >= project 2
		5
		6			Note: All projects must be integer (1 or 0)
		7
		8
	Objective	Maximize Profits

&"Helvetica,Regular"&12&K000000 &P

Terraco Motor Company
		From Plant	Transportation Costs ($1000s)				Annual Production Capacity	Annual Fixed Operating Costs
			to Warehouse
			A	B	C	D
		1	$56	$21	$32	$65	12,000	$2,100,000
		2	18	46	70	35	18,000	850,000		Note F7 cell should be $70 NOT $7
		3	12	71	41	52	14,000	1,800,000
		4	30	24	61	28	10,000	1,100,000
		5	45	50	26	31	16,000	900,000
		Annual	6,000	14,000	8,000	10,000
		Demand
	DV	Plant to warehouse	A	B	C	D			Plant idle capacity
		1						=	0
		2						=	0
		3						=	0
		4						=	0
		5						=	0
			=	=	=	=
		Annual Demand	6,000	14,000	8,000	10,000
	DV	Plants Operation
		1
		2			Plant operation is either 0 (close) or 1 (open)
		3
		4
		5
	Objective	Minimize Cost

&"Helvetica,Regular"&12&K000000 &P