Budgeting Essay, Excell skills needed
$250-750 USD
Pagado a la entrega
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
Nº del proyecto: #2347023
Sobre el proyecto
Adjudicado a:
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!
2 freelancers están ofertando un promedio de $400 por este trabajo
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 Más