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

                                                                                                    Actuals                                             Actuals               

                                            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

Expenditures

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