assignment 4 pad 505

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

 

                                                                                                    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