Assignment 4: Implementing the Budget Prepare a variance report for the NASA.Refer to Table 8.4. Write a three (3) page paper addressingthe criteria below. (Note: Change the title of the report to...

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

Answered Same DayDec 22, 2021

Answer To: Assignment 4: Implementing the Budget Prepare a variance report for the NASA.Refer to Table 8.4....

Robert answered on Dec 22 2021

135 Votes

Case 2
1. The Variance for the revenue as well as expenditure is calculated in the following table.



    First Percentage
    Variance
    Third Percentage
    Variance

    Annual budget
    Monthly Budget
    month spent

    month spent

    Revenues


    8.33

    25

    Federal aid
    53,00,00,000
    4,41,66,667
    20,00,000
    4,21,66,667
    60,00,000
    3,81,66,667
    State aid
    8,00,00,000
    66,66,667
    80,00,000
    -13,33,333
    3,00,00,000
    -2,33,33,333
    Local aid
    2,00,00,000
    16,66,667
    17,00,000
    -33,333
    54,00,000
    -37,33,333
    Total
    13,00,00,000
    1,08,33,333
    1,17,00,000
    -8,66,667
    4,14,00,000
    -3,05,66,667
    Expenditures






    Central fleet...

SOLUTION.PDF

Assignment 4: Implementing the Budget Prepare a variance report for the NASA.Refer to Table 8.4. Write a three (3) page paper addressingthe criteria below. (Note: Change the title of the report to...

Answer To: Assignment 4: Implementing the Budget Prepare a variance report for the NASA.Refer to Table 8.4....

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment