Fig7-1 - Subject to: B12:F12=B B9:D9>=0 B10:F11>=

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
797c98cbb1d4e3a23a79f7c234ad8dd8556e21b9.xls Page 1 Problem Data Small Medium Large Square Footage 400 750 1,050 Building Cost $18,000 $33,000 $45,150 Goal Constraints Small Medium Large Sq. Ft. Cost Actual Amount 0 0 0 0 $0 + Under 0 0 0 0 $0 - Over 0 0 0 0 $0 = Goal 0 0 0 0 $0 Target Value 5 10 15 25,000 $1,000,000 Percentage Deviation Under 0.00% 0.00% 0.00% 0.00% 0.00% Over 0.00% 0.00% 0.00% 0.00% 0.00% Weights Under 1 1 1 1 0 Over 0 0 0 1 1 Objective 0.00 Davis McKeown Hotel Expansion Minimize: B23 By changing: B9:D9,B10
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Subject to: B12:F12=B B9:D9>=0 B10:F11>= 797c98cbb1d4e3a23a79f7c234ad8dd8556e21b9.xls Page 2 0:F11 B13:F13 & integer =0 small medium large 400 750 1050 18000 33000 45150 actual amount 5 10 15 25250 1097250 +under-over 250 97250 =goal 5 10 15 25000 1000000 target value 5 10 15 25000 1000000 % deviation +under-over 0.01 0.1 Weights +under 1 1 1 1-over 1 1 0.11...
View Full Document

This note was uploaded on 09/13/2009 for the course ENGINEERIN 0130661848 taught by Professor Nel during the Spring '09 term at Stellenbosch University-South Africa.

Page1 / 3

Fig7-1 - Subject to: B12:F12=B B9:D9>=0 B10:F11>=

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online