Finance help due today

profilesisimo

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        

 

 

 

 

    • 7 years ago
    • 20
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      management_vs_stakeholders.docx