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 n
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