A B D E F 1 HOTEL EXPANSION 2 3 4 Problem Data 5. Square Footage 6 Building Cost Small 400 $18,000 Medium 750 $33,000 Large 1,050 $45,150 7 Medium 0 0 0 0 10 Large 0 0 0 0 15 Sq. Ft. 0 0 0 0 25,000 Cost($000) $0 $0 $0 $0 $1,000 8 Goal Constraints Small 9 Actual Amount 0 10+ Under 0 11 - Over 0 12 = Goal 0 13 Target Value 5 14 15 Percentage Deviation 16 Under 0.00% 17 Over 0.00% 18 19 Weights 20 Under 1 21 Over 1 22 23 Objective 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1 1 1 1 1 1 1 1 The LHS constraint relationship for square footage would be represented in Solver as: Square Footage is not a Constraint. O Cell E13 Cell E12 Cell E9