Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Budgetary Comparison Schedule for the City of Salem appears in Illustration 2-16. Assume the general and subsidiary ledgers for the General Fund were lost

The Budgetary Comparison Schedule for the City of Salem appears in Illustration 2-16. Assume the general and subsidiary ledgers for the General Fund were lost after a water pipe burst. You are charged with reproducing the journal entries that took place during the year ended December 31, 2020. Use the Excel file provided to prepare summary journal entries, including subsidiary ledger entries, for the following events:

image text in transcribed

a. Record the original budget.

image text in transcribed

b. Record the revisions to the budget.

image text in transcribed

c. Record the actual revenues.

image text in transcribed

d. Record the encumbrances, assuming all expenditures originated as encumbrances and the encumbrance and expenditure are equal in amount.

image text in transcribed

e. Record the actual expenditures and reversal of the associated encumbrance.

image text in transcribed

CITY OF SALEM Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual: General Fund For The Year Ended December 31, 2020 Budgeted Amounts REVENUES Property Taxes Other Local Taxes Charges for Services Intergovernmental Miscellaneous TOTAL REVENUES Original 14,677,000 11,562,500 1,613,011 7,892,080 1,504,977 37,249,568 Final 14,677,000 11,562,500 1,613,011 8,047,907 1,388,385 37,288,803 Actual Amounts Budgetary Basis 15,361,830 11,761,522 1,601,435 7,098,698 1,262,549 37,086,034 Variance with Final Budget 684,830 199,022 (11,576) (949,209) (125,836) (202,769) EXPENDITURES Current General Government Judicial Administration Public Safety Public Works Health and Welfare Education Parks and Recreation Community Development TOTAL EXPENDITURES 3,567,838 1,351,000 7,753,002 4,541,651 4,823,267 8,963,248 2,983,861 872,594 34,856,461 3,489,870 1,497,845 8,325,564 4,984,353 4,440, 167 8,929,725 3,097,528 904,168 35,669,220 3,453,502 1,456,734 8,216,347 4,602,273 4,418,294 8,887,834 3,055,325 899,209 34,989,518 36,368 41,111 109,217 382,080 21,873 41,891 42,203 4,959 679,702 2,393, 107 1,619,583 2,096,516 476,933 REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES): Transfers (to) other funds (3,560,000) (3,560,000) (3,257,000) (3,257,000) (3,256,899) (3,256,899) 101 101 477,034 Excess of revenues and other sources over (under) expenditures and other uses FUND BALANCE - Beginning of Year FUND BALANCE - End of Year (1,166,893) 12,338,963 11,172,070 (1,637,417) 12,338,963 10,701,546 (1,160,383) 12,338,963 11,178,580 477,034 General Ledger Debits Credits Subsidiary Ledger Debits Credits a. Record the original budget Revenues control account Estimated Revenues ledger: Appropriations control account Appropriations subsidiary ledger. Other Financing Uses subsidiary ledger: Transfers out General Ledger Debits Credits Subsidiary Ledger Debits Credits b. Record the budget revisions Revenues subsidiary ledger: Appropriations subsidiary ledger: Other Financing Uses subsidiary ledger: c. Record the Actual Revenues General Ledger Debits Credits Subsidiary Ledger Debits Credits Revenues subsidiary ledger. General Ledger Debits Credits d. Record the encumbrances Subsidiary Ledger Debits Credits Encumbrances subsidiary ledger. General Ledger Subsidiary Ledger e. Record the actual expenditures and Encumbrance Reversals Debits Credits Debits Credits Encumbrances subsidiary ledger. Expenditures Control Expenditures subsidiary ledger: CITY OF SALEM Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual: General Fund For The Year Ended December 31, 2020 Budgeted Amounts REVENUES Property Taxes Other Local Taxes Charges for Services Intergovernmental Miscellaneous TOTAL REVENUES Original 14,677,000 11,562,500 1,613,011 7,892,080 1,504,977 37,249,568 Final 14,677,000 11,562,500 1,613,011 8,047,907 1,388,385 37,288,803 Actual Amounts Budgetary Basis 15,361,830 11,761,522 1,601,435 7,098,698 1,262,549 37,086,034 Variance with Final Budget 684,830 199,022 (11,576) (949,209) (125,836) (202,769) EXPENDITURES Current General Government Judicial Administration Public Safety Public Works Health and Welfare Education Parks and Recreation Community Development TOTAL EXPENDITURES 3,567,838 1,351,000 7,753,002 4,541,651 4,823,267 8,963,248 2,983,861 872,594 34,856,461 3,489,870 1,497,845 8,325,564 4,984,353 4,440, 167 8,929,725 3,097,528 904,168 35,669,220 3,453,502 1,456,734 8,216,347 4,602,273 4,418,294 8,887,834 3,055,325 899,209 34,989,518 36,368 41,111 109,217 382,080 21,873 41,891 42,203 4,959 679,702 2,393, 107 1,619,583 2,096,516 476,933 REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES): Transfers (to) other funds (3,560,000) (3,560,000) (3,257,000) (3,257,000) (3,256,899) (3,256,899) 101 101 477,034 Excess of revenues and other sources over (under) expenditures and other uses FUND BALANCE - Beginning of Year FUND BALANCE - End of Year (1,166,893) 12,338,963 11,172,070 (1,637,417) 12,338,963 10,701,546 (1,160,383) 12,338,963 11,178,580 477,034 General Ledger Debits Credits Subsidiary Ledger Debits Credits a. Record the original budget Revenues control account Estimated Revenues ledger: Appropriations control account Appropriations subsidiary ledger. Other Financing Uses subsidiary ledger: Transfers out General Ledger Debits Credits Subsidiary Ledger Debits Credits b. Record the budget revisions Revenues subsidiary ledger: Appropriations subsidiary ledger: Other Financing Uses subsidiary ledger: c. Record the Actual Revenues General Ledger Debits Credits Subsidiary Ledger Debits Credits Revenues subsidiary ledger. General Ledger Debits Credits d. Record the encumbrances Subsidiary Ledger Debits Credits Encumbrances subsidiary ledger. General Ledger Subsidiary Ledger e. Record the actual expenditures and Encumbrance Reversals Debits Credits Debits Credits Encumbrances subsidiary ledger. Expenditures Control Expenditures subsidiary ledger

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Cost Accounting

Authors: Don R. Hansen, Maryanne Mowen, Liming Guan, Mowen/Hansen

1st International Edition

0538749636, 978-0538749633

More Books

Students also viewed these Accounting questions

Question

Create an intervention for treating implicit racial bias.

Answered: 1 week ago