Assignment 4: Implementing the Budget
Refer the Scenario for Assignments 1–5. Prepare a variance report for the selected agency.
Write a three to four (3-4) page paper addressing the criteria below. (Note: Change the title of the report to reflect the selected agency’s name and the years to 2013-2014.)
1. Find the variances for both the revenue and expenditures sides and then discuss two to three (2-3) problematic areas for the agency. Provide the results of the variances in a table (Excel or Word).
2. Recommend two (2) policy actions for each problematic area discussed in criterion 1. Justify the recommendations
The assignment must follow these formatting requirements:
•Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA.
•Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Variance Report from the Department of Transportation, 2013-2014
Annual First Percentage Third Percentage
Budget month spent month spent
Revenues 8.33 25.00
Federal Aid $30,000,000 $2,000,000 $6,000,000
State Aid 80,000,000 8,000,000 30,000,000
Local Aid 20,000,000 1,700,000 5,400,000
Total $130,000,000 $11,700,000 $41,000,000
CentralFleetMaint $2,267,724 $180,000 $530,000
PublicWorks& Trans 1,606,402 130,000 390,000
Public Works Dept 86,176,802 7,300,000 22,000,000
Snow Removal 12,292,072 ——- ———-
Trans Dept 27,618,759 2,300,000 2,100,000
Totals $129,961,759 $9,910,000 $25,020,000