Finance Assignment - Implementing the budget
Assignment 4: Implementing the Budget
Prepare a variance report for the NASA. Refer to Table 8.4.
Write a three (3) 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.
TABLE 8.4
Variance Report from the Department of Transportation, 2007-2008
Actuals Actuals
Annual | First Percentage | Third Percentage | |
budget | month spent | month spent | |
Revenues | 8.33 | 25.00 | |
Federal aid | 530,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,400,000 |
Expenditures | |||
Central fleet maintenance | $2,257,724 | $180,000 | $530,000 |
Public works and transportation | 1,606,402 | 130,000 | 390,000 |
Public works department | 86,176,802 | 7,300,000 | 22,000,000 |
Snow removal | 12,292,072 | — | — |
Transportation department | 27,618,759 | 2,300,000 | 2,100.000 |
Total | $129,961,759 | $9,910,000 | $25,020,000 |
10 years ago
Purchase the answer to view it
- the_variance_1447818424.doc