Spreadsheet Modeling and Decision Analysis (7th Edition)

Chapter 7 question 14 : in solution part b : what are the formulas used in the excel? what is the formula used for objective function? How did we get the value x1 + d+- + d-+ = $17250?

Step 2 of 10 A b. To summarize the LP model for GP problem is, 1 MIN: wi w2 di + di 17250 120000 Subject to X, +di - d = 17250 X, +d -d;= 120000 2000X, +12000X, +d; -d; = 150000 didi 0 for alli Enter the above goal programming model in the spreadsheet model. Consider the following spreadsheet model, A B D 2 The Olive Grove 3 4 Problem Data: Magazine TV 5 Number 0 0 6 Exposures (in 1000s) 250 1,200 7 Cost $2,000 $12,000 8 Min 10 5 9 10 Goal Constraints: Exposures Cost 11 Actual 0 $0 12 + Under 0 $0 13 - Over 0 $0 14 = Goal 0 $0 15 Target 17,250 $1,20,000 16 17 Percentage Deviation: 18 Under 0.00% 0.00% 19 Over 0.00% 0.00% 20 21 Objective: 11.67% Piolo Step 2 of 10 A b. To summarize the LP model for GP problem is, 1 MIN: wi w2 di + di 17250 120000 Subject to X, +di - d = 17250 X, +d -d;= 120000 2000X, +12000X, +d; -d; = 150000 didi 0 for alli Enter the above goal programming model in the spreadsheet model. Consider the following spreadsheet model, A B D 2 The Olive Grove 3 4 Problem Data: Magazine TV 5 Number 0 0 6 Exposures (in 1000s) 250 1,200 7 Cost $2,000 $12,000 8 Min 10 5 9 10 Goal Constraints: Exposures Cost 11 Actual 0 $0 12 + Under 0 $0 13 - Over 0 $0 14 = Goal 0 $0 15 Target 17,250 $1,20,000 16 17 Percentage Deviation: 18 Under 0.00% 0.00% 19 Over 0.00% 0.00% 20 21 Objective: 11.67% Piolo