In: Finance
P3-3 (Budgetary Comparison Statement) This problem is based on the information about the Murphy County General Fund budgeted and actual transactions and events described in Problem 3-2.
P3-2 (Budgetary and Other Entries—General and Subsidiary Ledgers) The Murphy County Commissioners adopted the following General Fund budget for the 20X8 fiscal year:
Murphy County General FundBudget—20X8 |
|
Estimated Revenues: |
|
Taxes |
$ 8,000,000 |
Licenses and permits |
800,000 |
Intergovernmental |
2,000,000 |
Charges for services |
200,000 |
Fines and forfeits |
400,000 |
Other |
600,000 |
12,000,000 |
|
Appropriations: |
|
General government |
1,000,000 |
Public safety |
4,000,000 |
Highways and streets |
5,000,000 |
Health and sanitation |
900,000 |
Culture and recreation |
400,000 |
Other |
600,000 |
11,900,000 |
|
Excess of Estimated Revenues over Appropriations |
100,000 |
Fund Balance—Beginning |
1,400,000 |
Fund Balance—Ending (Anticipated) |
$ 1,500,000 |
The following events occurred during 20X8:
General government |
$ 300,000 |
Public safety |
1,200,000 |
Highways and streets |
2,500,000 |
Health and sanitation |
500,000 |
Culture and recreation |
300,000 |
Other |
200,000 |
$ 5,000,000 |
Taxes |
$ 8,150,000 |
Licenses and permits |
785,000 |
Intergovernmental |
1,520,000 |
Charges for services |
210,000 |
Fines and forfeits |
395,000 |
Other |
500,000 |
$11,560,000 |
Estimated Cost |
Actual Cost |
|
General government |
$ 280,000 |
$ 278,000 |
Public safety |
900,000 |
910,000 |
Highways and streets |
2,500,000 |
2,500,000 |
Health and sanitation |
440,000 |
440,000 |
Culture and recreation |
300,000 |
295,000 |
Other |
180,000 |
181,000 |
$4,600,000 |
$4,604,000 |
General government |
$ 700,000 |
Public safety |
2,560,000 |
Highways and streets |
2,271,000 |
Health and sanitation |
485,000 |
Culture and recreation |
45,000 |
Other |
391,000 |
$6,452,000 |
Required
Required
Assume that no encumbrances were outstanding at the beginning of 20X8.
Solution :-
As per the given data,
Step -1:- Preparation of budgetary comaparision statement :-
A budgetary Comparision statement is a financial statement of general Govt Fund which shows the budgeted and actual revenue and expenditure and encumbrance in the form of variance.
Step - 2:- Prepare the statement of revenue , expenditures,and changes in fund balances on budgetary basis :-
Budgetary comparision statement for the fiscal year of 2018
Step :-3 Calculation of the revised budget for publc safety expenditure :-
The estimated personal service appropriation for the fiscal year was $4,000,000.
The city Council has decreased the budget by $225,000.
Revised budget for pubilc safety
= $4,000,000 - $225,000
= $3,775,000
Step :- 4 Calculation the revised budget for highway and street :-
Highway and street appropriation for the fiscal year was $5,000,000.
The city council has decreased the budget budget by $225,000.
Revised budget for highway & Street = $5,000,000 - $225,000
= $4,750,000
Step :-5 Calculation of the revised budget for the health and sanitization
Health and Sanitization appropriation for the fiscal year was $ 900,000
The city council was increased budget by $70,000
= $900,000 + $70,000
= $970,000