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

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

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

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

View Full Document
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
Ask a homework question - tutors are online