D. HOTEL EXPANSION 4 Problem Data 5 Square Footage 6 Building Cost Large 1,050 $18,000 $33,000 $45,150 Small 400 Medium 750 8 Goal Constraints 9 Actual Amount 10 Under 11- Over 12 = Goal 13 Target Value Sq. Ft. Cost($000) SO $0 Small Medium Large $0 $1,000 10 15 25,000 14 15 Percentage Deviation 16 Under 17 Over 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 18 19 Weights 20 Under 21 Over 1 1 1 1 1 1 1 1 1 1 22 23 Objective What is the formula in Cell D16? = (D15-D9) %3D = D10/D13 = D9/D12 D12/D13 %3D

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Question 16
A
D.
HOTEL EXPANSION
1
4 Problem Data
s Square Footage
6 Building Cost
Small
Medium
750
$18,000 $33,000 $45,150
Large
1,050
400
7.
8 Goal Constraints
9 Actual Amount
10 + Under
11- Over
12 = Goal
13 Target Value
Sq. Ft. Cost($000)
$O
$0
Small
Medium
Large
$0
$0
$1,000
10
15
25,000
14
15 Percentage Deviation
16 Under
17 Over
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
18
19 Weights
20 Under
21 Over
1
1
1
1
1
1
1
1
1
22
23 Objective
What is the formula in Cell D16?
= (D15-D9)
%3D
D10/D13
%3D
D9/D12
%3!
= D12/D13
Transcribed Image Text:Question 16 A D. HOTEL EXPANSION 1 4 Problem Data s Square Footage 6 Building Cost Small Medium 750 $18,000 $33,000 $45,150 Large 1,050 400 7. 8 Goal Constraints 9 Actual Amount 10 + Under 11- Over 12 = Goal 13 Target Value Sq. Ft. Cost($000) $O $0 Small Medium Large $0 $0 $1,000 10 15 25,000 14 15 Percentage Deviation 16 Under 17 Over 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 18 19 Weights 20 Under 21 Over 1 1 1 1 1 1 1 1 1 22 23 Objective What is the formula in Cell D16? = (D15-D9) %3D D10/D13 %3D D9/D12 %3! = D12/D13
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY