Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AutoSave Off Budget Variance Data Set Excel Search (Alt+Q) File Home Insert Page Layout Formulas Data Review View Developer Help 25 Calibri 11 General
AutoSave Off Budget Variance Data Set Excel Search (Alt+Q) File Home Insert Page Layout Formulas Data Review View Developer Help 25 Calibri 11 General Conditional Formatting $ % 9 Format as Table Paste B I U V 0 .00 .00 0 Cell Styles Undo Clipboard Font Alignment Number Styles HI H7 fx g Brionna Johnson BJ Insert v V x Delete Format Cells A B C D E F G H 1234 Preston Township Budget Variance Report by Deparment For Year Ended December 31, 2020 Deparment 5 TRAFFIC AND PARKING Budget 950,000 Actual Variance$ Variance% 881,421 68579 7.22% 6 SCHOOLS 12,360,000 12,547,310 -187310 1.52% 7 RECREATION AND YOUTH 670,000 651,034 18966 2.83% g 8 PUBLIC LIBRARIES 9 POLICE DEPARTMENT 347,500 329,921 735,000 744,835 -9835 17579 5.06% 1.34% 10 PERSONNEL DEPARTMENT 202,500 206,782 -4282 2.11% 11 OFFICE OF THE MAYOR 176,500 124,346 52154 29.55% 12 OFFICE OF PLANNING, DEVELOPMENT, AND MANAGEMENT 10,875,000 10,946,293 13 LEGAL DEPARTMENT 587,500 14 INFORMATION TECHNOLOGY 1,550,000 -71293 0.66% 607,648 -20148 3.43% 1,739,606 -189606 12.23% 15 FIRE DEPARTMENT 16 COUNCIL ON AGING 17 COMMUNICATIONS DEPARTMENT 18 CITY CLERKS OFFICE 19 BOARD OF HEALTH 20 ARTS COUNCIL 510,000 128,000 700,000 65,000 357,500 171,000 550,400 -40400 7.92% 174,733 -46733 36.51% 782,045 -82045 11.72% 70,862 -5862 9.02% 417,415 -59915 16.76% 187,125 -16125 9.43% Actual Pivot Actual Budget Pivot Budget Dept. Variance Exp. Variance Enter EO Accessibility: Good to go Comments 0 Share Editing Analyze Sensitivity Data Analysis Sensitivity J K L M N 100%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started