En cours

Budgeting Essay, Excell skills needed

You will be analyzing trends in St Charles County Government budgets. In this case looking at the

budgets for 2008—2012

Use an Excel format to look at the category titled INTERGOVERNMENTAL (the pie chart for GENERAL

SOURCE REVENUE BY SOURCE)

Creating an Excel chart

The percentage of GENERAL SOURCE REVENUE BY SOURCE--INTERGOVERNMENTAL

2008 percentage?

2009 “

2010 “

2011 “

2012 “

Use an Excel format to look at the category titled PERSONNEL (the pie chart for GENERAL FUND

EXPENDITURES BY CATEGORY)

Creating an Excel Chart

The percentage of GENERAL FUND EXPENDITURES BY CATEGORY—PERSONNEL

2008 percentage?

2009 “

2010 “

2011 “

2012 “

Use an Excel format to look at the categories titled: PUBLIC SAFETY, GOVERNMENT OPERATIONS,

HEALTH & HUMAN SERVICES (the pie chart for GENERAL FUND EXPENDITURES BY FUNCTION)

The percentage of GENERAL FUND EXPENDITURES BY FUNCTION (all three in here)

2008 percentage? (PUBLIC SAFETY, GOV’T OPERATIONS, HEALTH &)

2009 “

2010 “

2011 “

2012 “Develop an Excel chart for ASSESSED VALUATION –REAL ESTATE

2008

2009

2010

2011

2012

Look for in the 2012 budget: 2012 Annual Budget: All Funds

Look at EXPENDITURES then CAPITAL OUTLAY and create an Excel chart

SO: Capital Outlay/Total Expenditures=percentage

2009 (actual) percentage?

2010 (actual) “

2011 (estimate) “

2012 (Approp) “

Using the above charts, develop your analysis regarding the county’s budgetary trends and, therefore,

bright spots or problems. Your analysis should be a minimum of four pages (typed, double spaced).

USING EXCEL

Using EXCEL

Microsoft Excel and using graphing

Open up EXCEL and enter the data, just like below.

General Fund Expenditures By Function

Public Safety Gov’t Operations Health & Human Services

2008 number number number

2009 “ “ “

2010 “ “ “

2011 “ “ “

2012 “ “ “

ASSUME there are lines up and down between the columns which is what you’ll see in Excel (they look

like rectangles).

After entering the data, highlight everything by starting above the 2008 (chances are that particular

rectangle will not be highlighted). Now, click INSERT and go over to LINE and click it, you’ll see seven selections, choose the first one in the

Compétences : Rédaction scientifique

Voir plus : writing essay format, total safety, rectangle lines, rectangle line, personnel source, line rectangle, health essay writing, graphing problems, graphing data, format essay writing, first capital, essay writing services, data graphing, creating use case, create essay, click safety, c graphing, capital safety, bright services, 24 seven, microsoft excel skills, skills needed writing, format writing essay, essay writing skills, essay writing format

Concernant l'employeur :
( 3 commentaires ) Saint Louis, United States

N° du projet : #2347023

Décerné à :

sdk2788

Greetings! I would love to work with you once again! Looking forward for another opportunity. I have now studies all the details and placed my bid offer. Awaiting your response and my selection. Cheers!

420 $ USD en 5 jours
(823 Commentaires)
8.3

2 freelance ont fait une offre moyenne de 400 $ pour ce travail

writinglance123

We Work With You Until You Get It Right...! A highly driven professional freelance academic writers' team possessing excellent skills with certification to credit, seeking a high profile opportunities We want contr Plus

379.99 $ USD en 7 jours
(0 Commentaires)
0.0