Fermé

Governmental Budgeting

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 second raw

Compétences : Rédaction scientifique

Voir plus : total safety, rectangle lines, rectangle line, personnel source, line rectangle, graphing problems, graphing data, first capital, data graphing, creating use case, click safety, c graphing, capital safety, bright services, governmental budgeting, public health, capital budget, Budgeting, academic writing services, graphing trends excel, data trends excel, highlight click, double spaced, pages double spaced, valuation excel

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

N° du projet : #2346979

5 freelance ont fait une offre moyenne de 276 $ pour ce travail

zhj11651

Its my pleasure to bid over here. Looking forward for your positive response. Kindly refer to pm please for details

250 $ USD en 7 jours
(1103 Commentaires)
8.6
mihai888

Hi! I'm a BA and IR grad with excellent writing skills. I would love to work for you on this project. Can start ASAP

250 $ USD en 2 jours
(3 Commentaires)
2.1
writinglance123

If you are interested let us know please?

379.99 $ USD en 4 jours
(0 Commentaires)
0.0
zelyonka

Hello, I am very interested in this assignment. I am an experienced academic writer. I have looked over your assignment and I am ready to take it on. Please PM if you have any questions.

250 $ USD en 5 jours
(0 Commentaires)
0.0
magicmarkuk

Award winning UK qualified chartered accountant with extensive experience in private practice, industry and the public sector. Accounts, business plans and financial analysis are my speciality so this project would sui Plus

250 $ USD en 5 jours
(0 Commentaires)
0.0