978-0078025815 Exercise 3 Excel

subject Type Homework Help
subject Pages 3
subject Words 504
subject Authors Paul Copley

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
CITY OF Grafton
Schedule of Revenues, Expenditures and Changes in Fund Balance -
Budget and Actual: General Fund
For The Year Ended December 31, 2015
Budgeted Amounts
REVENUES
Original Final
Actual Amounts
Budgetary Basis
Variance with Final
Budget
Property Taxes 3,205,000$ 3,205,000 3,212,000 7,000$
Licenses and permits 800,000 800,000 803,000 3,000
Intergovernmental 300,000 290,000 290,000 -
Miscellaneous 200,000 197,000 195,000 (2,000)
TOTAL REVENUES 4,505,000 4,492,000 4,500,000 8,000
EXPENDITURES AND ENCUMBRANCES
Current
General Government 900,000 898,000 898,000 -
Public Safety 2,125,000 2,125,000 2,107,000 18,000
Health and Welfare 1,400,000 1,400,000 1,398,000 2,000
TOTAL EXPENDITURES 4,425,000 4,423,000 4,403,000 20,000
REVENUES OVER (UNDER) EXPENDITURES 80,000 69,000 97,000 28,000
OTHER FINANCING SOURCES (USES):
Transfers (to) other funds (120,000) (120,000) (120,000) -
TOTAL OTHER FINANCING SOURCES (USES) (40,000) (120,000) (120,000) -
Excess of revenues and other sources over
(under) expenditures and other uses 40,000 (51,000) (23,000) 28,000
FUND BALANCE - Beginning of Year 1,038,000 1,038,000 1,038,000 -
FUND BALANCE - End of Year 1,078,000$ 987,000 1,015,000 28,000$
page-pf2
CITY OF SALEM
Schedule of Revenues, Expenditures and Changes in Fund Balance -
Budget and Actual: General Fund
For The Year Ended December 31, 2015
Budgeted Amounts
REVENUES
Original Final
Actual Amounts
Budgetary Basis
Variance with
Final Budget
Property Taxes 14,666,000 14,666,000 15,361,830 695,830
Other Local Taxes 11,562,500 11,562,500 11,761,522 199,022
Charges for Services 1,613,011 1,613,011 1,601,435 (11,576)
Intergovernmental 7,892,080 8,047,907 7,098,698 (949,209)
Miscellaneous 1,504,977 1,388,385 1,262,549 (125,836)
TOTAL REVENUES 37,238,568 37,277,803 37,086,034 (191,769)
EXPENDITURES
Current
General Government 3,567,838 3,489,870 3,353,502 136,368
Judicial Administration 1,321,048 1,497,845 1,456,734 41,111
Public Safety 7,753,002 8,325,564 8,216,347 109,217
Public Works 4,541,651 4,984,353 4,602,273 382,080
Health and Welfare 4,823,267 4,440,167 4,418,294 21,873
Education 8,963,248 8,929,725 8,887,834 41,891
Parks and Recreation 2,983,861 3,097,528 3,055,325 42,203
Community Development 872,594 904,168 899,209 4,959
TOTAL EXPENDITURES 34,826,509 35,669,220 34,889,518 779,702
REVENUES OVER (UNDER) EXPENDITURES 2,412,059 1,608,583 2,196,516 (971,471)
OTHER FINANCING SOURCES (USES):
Transfers (to) other funds (3,560,000) (3,257,000) (3,256,899) 101
(3,560,000) (3,257,000) (3,256,899) 101
Excess of revenues and other sources over
(under) expenditures and other uses (1,147,941) (1,648,417) (1,060,383) 588,034
FUND BALANCE - Beginning of Year 12,338,963 12,338,963 12,338,963 -
FUND BALANCE - End of Year 11,191,022 10,690,546 11,278,580 588,034
Type your name here
a. Record the original budget Debits Credits Debits Credits
Revenues control account
Estimated Revenues Control 37,238,568
Estimated Other Financing Uses Control -
Budgetary Fund Balance 37,238,568
Revenues ledger:
Property Taxes 14,666,000
Other Local Taxes 11,562,500
Charges for Services 1,613,011
Intergovernmental Revenue 7,892,080
Miscellaneous 1,504,977
37,238,568
Appropriations control account
Budgetary Fund Balance 38,386,509
Appropriations Control 34,826,509
Estimated Other Financing Uses Control 3,560,000
Appropriations subsidiary ledger:
General Government 3,567,838
Juidicial Administration 1,321,048
Public Safety 7,753,002
Public Works 4,541,651
Health and Welfare 4,823,267
Education 8,963,248
Parks and Recreation 2,983,861
Community Development 872,594
34,826,509
Other Financing Uses subsidiary ledger:
Transfers out 3,560,000
b. Record the budget revisions Debits Credits Debits Credits
Estimated Revenues Control 39,235
Estimated Other Financing Uses Control 303,000
Budgetary Fund Balance 500,476
Appropriations Control 842,711
Revenues subsidiary ledger:
Intergovernmental Revenues 155,827
Miscellaneous 116,592
39,235
decrease in estm' revenues
Appropriations subsidiary ledger:
General Government 77,968
Juidicial Administration 176,797
Public Safety 572,562
Public Works 442,702
Health and Welfare 383,100
Education 33,523
Parks and Recreation 113,667
Community Development 31,574
842,711 increase in appropriations
Other Financing Uses subsidiary ledger:
Transfers out 303,000 303,000 decrease in estm' transfers
500,476 Decrease in budgetary fund balance
Subsidiary Ledger
Subsidiary Ledger
page-pf3
c. Record the Actual Revenues Debits Credits Debits Credits
Cash 37,086,034
Revenues Control 37,086,034
Revenues subsidiary ledger:
Property Taxes 15,361,830
Other Local Taxes 11,761,522
Charges for Services 1,601,435
Intergovernmental Revenue 7,098,698
Miscellaneous 1,262,549
37,086,034
d. Record the encumbrances Debits Credits Debits Credits
Encumbrances Control 34,889,518
Budgetary Fund Balance - Reserve for Encumbrances 34,889,518
Encumbrances subsidiary ledger:
General Government 3,353,502
Juidicial Administration 1,456,734
Public Safety 8,216,347
Public Works 4,602,273
Health and Welfare 4,418,294
Education 8,887,834
Parks and Recreation 3,055,325
Community Development 899,209
34,889,518
e. Record the actual expenditures and
Encumbrance Reversals
Debits Credits Debits Credits
Budgetary Fund Balance - Reserve for Encumbrances
34,889,518
Encumbrances Control 34,889,518
Encumbrances subsidiary ledger:
General Government 3,353,502
Juidicial Administration 1,456,734
Public Safety 8,216,347
Public Works 4,602,273
Health and Welfare 4,418,294
Education 8,887,834
Parks and Recreation 3,055,325
Community Development 899,209
34,889,518
Expenditures Control 34,889,518
Accounts Payable 34,889,518
Expenditures subsidiary ledger:
General Government 3,353,502
Judicial Administration 1,456,734
Public Safety 8,216,347
Public Works 4,602,273
Health and Welfare 4,418,294
Education 8,887,834
Parks and Recreation 3,055,325
Community Development 899,209
34,889,518
Subsidiary Ledger
Subsidiary Ledger
Subsidiary Ledger

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.