Use the subsequent website for the City of Decatur GA for information needed-
"Decaturga"
1. Payroll Forecast. Observing at employees compensation forecast payroll-
a. Provide a rationale on what the costs as well as benefits would be for a 2%, 4% or 5% pay increase for the fiscal year 2014.
b. Explain the effects of the increase on benefits for the agency
c. Offer a chart depicting the increase for each percent.
2. Trend Analysis- Evaluation the agency's expenditures trend over the past 5 years
a. Make an analysis explaining the trend for expenditures.
b. Comprise a figure depicting the trend.
3. Expenditure Forecast
a. Prepare as well as explain a five (5) year forecast of the four (4) highest expenditures.
b. Make an XY plot of the data.
c. Comprise in the analysis whether the costs should be approved or not approved. Validate the reasoning with examples