N9 A B Xfx=VLOOKUP (N8, $B$7:$K$17,2,FALSE) E F H K M 2 3 Saxon Municipal Government Budget Summary by Department 4 5 Employees % change Code Department Directors Clerks Staff Total Turnover Turnover % 2025 Budget Department summary 6 from 2024 7 CSD Central Services 3 7 15 8 EDD Economic Development 8 12 9 ESD Emergency Services 4 12 10 FID Finance 10 15 11 HRD Human Resources 10 16 12 LED Law Enforcement 5 10 13 PLD Planning 5 10 14 PUD Public Utilities 4 10 15 RED Revenue 6 12 16 SUD Sustainability 3 5 17 TRD Transit 4 8 18 Total 62 117 22222222222 25 20 24 3 4 4 3 4 3 3 25 3 12% $ 7,250,768 2.30% Code FID 44 8 18% $ 5,782,039 1.30% Dept Name Finance 41 1 2% $ 12,847,592 -0.50% Director A #N/A 0 0% $ 6,282,172 2.10% Clerks #N/A 46 7 15% 3,383,109 1.50% Staff #N/A 37 10 27% $ 10,900,924 3.30% Total #N/A 39 4 10% 8,486,265 -1.00% Turnover #N/A 32 3 9% $ 11,992,743 1.20% Turnover % #N/A 24 42 0 0% 6,654,883 0.09% 2025 Budget #N/A 2 11% $ 1,923,485 -1.10% % change #N/A 15 27 11 41% $ 4,238,817 1.20% (C 401 49 13% $ 79,742,797 0.94% N8 A B Xfx=VLOOKUP (N7, $B$7: $K$17,2,FALSE) E F G H K L M N 2 3 Saxon Municipal Government Budget Summary by Department 4 5 Employees Code Department Directors Clerks Staff Total Turnover Turnover % 2025 Budget % change Department summary 6 from 2024 7 CSD Central Services 3 7 15 25 3 12% $ 7,250,768 2.30% Code 8 EDD Economic Development 8 12 24 44 8 18% $ 5,782,039 1.30% Dept Name FID Finance 9 ESD Emergency Services 4 12 25 41 1 2% $ 12,847,592 -0.50% Directors 10 FID Finance 10 15 25 50 0 0% $ 6,282,172 2.10% Clerks 11 HRD Human Resources 10 16 20 46 7 15% $ 3,383,109 1.50% Staff 12 LED Law Enforcement 5 10 22 37 10 27% $ 10,900,924 3.30% Total 13 PLD Planning 5 10 24 39 4 10% $ 8,486,265 -1.00% 14 PUD Public Utilities 4 10 18 32 3 9% $ 11,992,743 1.20% Turnover Turnover % 15 RED Revenue 6 12 24 42 0 0% $ 6,654,883 0.09% 2025 Budget 16 SUD Sustainability 3 5 10 18 2 11% $ 1,923,485 -1.10% % change 17 TRD Transit 4 8 15 27 11 41% $ 4,238,817 1.20%

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Can somone let me know why I am not able to copy/paste the formula from n8 to cells n9 to 16 please?

  1. Enter a formula in cell N8 using the VLOOKUP function to find an exact match for the department code. Look up the department code (cell N7) using an absolute reference, search the employee table data (the range B7:K17) using absolute references, and return the department name (the 2nd column).
  2. Copy the formula in cell N8 to the range N9:N16, pasting the formula only, and then edit the copied formulas to return the value from the column indicated by the label in column M.
N9
A
B
Xfx=VLOOKUP (N8, $B$7:$K$17,2,FALSE)
E
F
H
K
M
2
3
Saxon Municipal Government
Budget Summary by Department
4
5
Employees
% change
Code
Department
Directors
Clerks
Staff
Total
Turnover Turnover %
2025 Budget
Department summary
6
from 2024
7
CSD
Central Services
3
7
15
8
EDD
Economic Development
8
12
9
ESD
Emergency Services
4
12
10
FID
Finance
10
15
11
HRD
Human Resources
10
16
12
LED
Law Enforcement
5
10
13
PLD
Planning
5
10
14
PUD
Public Utilities
4
10
15
RED
Revenue
6
12
16
SUD
Sustainability
3
5
17
TRD
Transit
4
8
18
Total
62
117
22222222222
25
20
24
3 4 4 3 4 3 3
25
3
12% $
7,250,768
2.30%
Code
FID
44
8
18% $
5,782,039
1.30%
Dept Name
Finance
41
1
2% $
12,847,592
-0.50%
Director A
#N/A
0
0% $
6,282,172
2.10%
Clerks
#N/A
46
7
15%
3,383,109
1.50%
Staff
#N/A
37
10
27% $
10,900,924
3.30%
Total
#N/A
39
4
10%
8,486,265
-1.00%
Turnover
#N/A
32
3
9% $
11,992,743
1.20%
Turnover %
#N/A
24
42
0
0%
6,654,883
0.09%
2025 Budget
#N/A
2
11% $
1,923,485
-1.10%
% change
#N/A
15
27
11
41% $
4,238,817
1.20%
(C
401
49
13% $
79,742,797
0.94%
Transcribed Image Text:N9 A B Xfx=VLOOKUP (N8, $B$7:$K$17,2,FALSE) E F H K M 2 3 Saxon Municipal Government Budget Summary by Department 4 5 Employees % change Code Department Directors Clerks Staff Total Turnover Turnover % 2025 Budget Department summary 6 from 2024 7 CSD Central Services 3 7 15 8 EDD Economic Development 8 12 9 ESD Emergency Services 4 12 10 FID Finance 10 15 11 HRD Human Resources 10 16 12 LED Law Enforcement 5 10 13 PLD Planning 5 10 14 PUD Public Utilities 4 10 15 RED Revenue 6 12 16 SUD Sustainability 3 5 17 TRD Transit 4 8 18 Total 62 117 22222222222 25 20 24 3 4 4 3 4 3 3 25 3 12% $ 7,250,768 2.30% Code FID 44 8 18% $ 5,782,039 1.30% Dept Name Finance 41 1 2% $ 12,847,592 -0.50% Director A #N/A 0 0% $ 6,282,172 2.10% Clerks #N/A 46 7 15% 3,383,109 1.50% Staff #N/A 37 10 27% $ 10,900,924 3.30% Total #N/A 39 4 10% 8,486,265 -1.00% Turnover #N/A 32 3 9% $ 11,992,743 1.20% Turnover % #N/A 24 42 0 0% 6,654,883 0.09% 2025 Budget #N/A 2 11% $ 1,923,485 -1.10% % change #N/A 15 27 11 41% $ 4,238,817 1.20% (C 401 49 13% $ 79,742,797 0.94%
N8
A
B
Xfx=VLOOKUP (N7, $B$7: $K$17,2,FALSE)
E
F
G
H
K
L
M
N
2
3
Saxon Municipal Government
Budget Summary by Department
4
5
Employees
Code
Department
Directors
Clerks
Staff
Total
Turnover Turnover %
2025 Budget
% change
Department summary
6
from 2024
7
CSD
Central Services
3
7
15
25
3
12% $
7,250,768
2.30%
Code
8
EDD
Economic Development
8
12
24
44
8
18% $
5,782,039
1.30%
Dept Name
FID
Finance
9
ESD
Emergency Services
4
12
25
41
1
2% $
12,847,592
-0.50%
Directors
10
FID
Finance
10
15
25
50
0
0% $
6,282,172
2.10%
Clerks
11
HRD
Human Resources
10
16
20
46
7
15% $
3,383,109
1.50%
Staff
12
LED
Law Enforcement
5
10
22
37
10
27% $ 10,900,924
3.30%
Total
13
PLD
Planning
5
10
24
39
4
10% $
8,486,265
-1.00%
14
PUD
Public Utilities
4
10
18
32
3
9% $
11,992,743
1.20%
Turnover
Turnover %
15
RED
Revenue
6
12
24
42
0
0% $
6,654,883
0.09%
2025 Budget
16
SUD
Sustainability
3
5
10
18
2
11% $
1,923,485
-1.10%
% change
17
TRD
Transit
4
8
15
27
11
41% $
4,238,817
1.20%
Transcribed Image Text:N8 A B Xfx=VLOOKUP (N7, $B$7: $K$17,2,FALSE) E F G H K L M N 2 3 Saxon Municipal Government Budget Summary by Department 4 5 Employees Code Department Directors Clerks Staff Total Turnover Turnover % 2025 Budget % change Department summary 6 from 2024 7 CSD Central Services 3 7 15 25 3 12% $ 7,250,768 2.30% Code 8 EDD Economic Development 8 12 24 44 8 18% $ 5,782,039 1.30% Dept Name FID Finance 9 ESD Emergency Services 4 12 25 41 1 2% $ 12,847,592 -0.50% Directors 10 FID Finance 10 15 25 50 0 0% $ 6,282,172 2.10% Clerks 11 HRD Human Resources 10 16 20 46 7 15% $ 3,383,109 1.50% Staff 12 LED Law Enforcement 5 10 22 37 10 27% $ 10,900,924 3.30% Total 13 PLD Planning 5 10 24 39 4 10% $ 8,486,265 -1.00% 14 PUD Public Utilities 4 10 18 32 3 9% $ 11,992,743 1.20% Turnover Turnover % 15 RED Revenue 6 12 24 42 0 0% $ 6,654,883 0.09% 2025 Budget 16 SUD Sustainability 3 5 10 18 2 11% $ 1,923,485 -1.10% % change 17 TRD Transit 4 8 15 27 11 41% $ 4,238,817 1.20%
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.