In: Accounting
The Town of Bedford Falls approved a General Fund operating budget for the fiscal year ending June 30, 2017. The budget provides for estimated revenues of $2,838,000 as follows: property taxes, $1,948,000; licenses and permits, $380,000; fines and forfeits, $280,000; and intergovernmental (state grants), $230,000. The budget approved appropriations of $2,782,000 as follows: General Government, $530,000; Public Safety, $1,660,000; Public Works, $380,000; Culture and Recreation, $156,000; and Miscellaneous, $56,000. |
Required |
a&b. |
Prepare the journal entry (or entries), to record the Town of Bedford Falls’s General Fund operating budget on July 1, 2016, the beginning of the Town’s 2017 fiscal year and also record the following transactions that occurred during the month of July 2016. Also show entries in the subsidiary ledger accounts, to record the Town of Bedford Falls’s General Fund operating budget on July 1, 2016, the beginning of the Town’s 2017 fiscal year. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) |
1. |
Revenues were collected in cash amounting to $37,000 for licenses and permits and $15,000 for fines and forfeits. |
2. |
Supplies were ordered by the following functions in early July 2016 at the estimated costs shown: |
General Government | $ | 8,000 |
Public Safety | 12,500 | |
Public Works | 6,700 | |
Culture and Recreation | 4,800 | |
Miscellaneous | 1,500 | |
Total | $ | 33,500 |
3. |
During July 2016, supplies were received at the actual costs shown below and were paid in cash. General Government, Culture and Recreation, and Miscellaneous received all supplies ordered. Public Safety and Public Works received part of the supplies ordered earlier in the month at estimated costs of $11,300 and $6,500, respectively. |
Actual Cost | Estimated Cost | |||||
General Government | $ | 7,900 | $ | 8,000 | ||
Public Safety | 11,400 | 11,300 | ||||
Public Works | 6,700 | 6,500 | ||||
Culture and Recreation | 4,700 | 4,800 | ||||
Miscellaneous | 1,500 | 1,500 | ||||
Total | $ | 32,200 | $ | 32,100 | ||
c. |
Calculate the amount of budgeted but unrealized revenues in total and from each source as of July 31, 2016. |
d. |
Calculate the amount of available appropriation in total and for each function as of July 31, 2016. Revenues were collected in cash amounting to $37,000 for licenses and permits and $15,000 for fines and forfeits. Record the issuance of the purchase orders and contracts. Record the issuance of the purchase orders and contracts. |
a) | Town of Bedford | General Ledger | Subsidiary Ledger | ||
Date | General Journal | Debit | Credit | Debit | Credit |
a) | Estimated Revenues | $2,838,000.00 | |||
Budgetary Fund Balance | $56,000.00 | ||||
Appropriations | $2,782,000.00 | ||||
Estimated Revenues Ledger | |||||
Taxes | $1,948,000.00 | ||||
Licenses and permits | $380,000.00 | ||||
Fines and forfeits | $280,000.00 | ||||
Intergovernmental Revenues | $230,000.00 | ||||
Appropriations Ledger | |||||
General Government | $530,000.00 | ||||
Public Safety | $1,660,000.00 | ||||
Public Works | $380,000.00 | ||||
Culture and Recreation | $156,000.00 | ||||
Miscellaneous | $56,000.00 | ||||
b) | |||||
1) | Cash ($37000 + $15000) | $52,000.00 | |||
Revenue | $52,000.00 | ||||
Revenues Ledger: | |||||
$37,000.00 | |||||
$12,000.00 | |||||
2) | Encumbrances | $33,500.00 | |||
Reserve for Encumbrances | $33,500.00 | ||||
Encumbrances Ledger: | |||||
General Government | $ | $8,000.00 | |||
Public Safety | $12,500.00 | ||||
Public Works | $6,700.00 | ||||
Culture and Recreation | $4,800.00 | ||||
Miscellaneous | $1,500.00 | ||||
3) | Reserve for Encumbrances | $32,100.00 | |||
Encumbrances | $32,100.00 | ||||
Expenditures | $32,200.00 | ||||
Cash | $32,200.00 | ||||
Encumbrances Ledger: | |||||
General Government | $8,000.00 | ||||
Public Safety | $11,300.00 | ||||
Public Works | $6,500.00 | ||||
Culture and Recreation | $4,800.00 | ||||
Miscellaneous | $1,500.00 | ||||
Expenditure Ledger: | |||||
General Government | $7,900.00 | ||||
Public Safety | $11,400.00 | ||||
Public Works | $6,700.00 | ||||
Culture and Recreation | 4700 | ||||
Miscellaneous | 1500 | ||||
c) | |||||
Budgeted | Actual | Unrealized Revenue | |||
Property Taxes | $1,948,000.00 | 0 | $1,948,000.00 | ||
Licenses and Permits | $380,000.00 | $37,000.00 | $343,000.00 | ||
Fines and Forfeits | $280,000.00 | $15,000.00 | $265,000.00 | ||
Intergovernmental | $230,000.00 | $0.00 | $230,000.00 | ||
Total | $2,838,000.00 | $52,000.00 | $2,786,000.00 | ||
d) | |||||
Appropriations | Encumbrances | Expenditures | Available Appropriations | ||
General Government | $530,000.00 | $0.00 | $7,900.00 | $522,100.00 | |
Public Safety | $1,660,000.00 | $1,200.00 | $11,400.00 | $1,647,400.00 | |
Public Works | $380,000.00 | $200.00 | $6,700.00 | $373,100.00 | |
Culture and Recreation | $156,000.00 | $0.00 | $4,700.00 | $151,300.00 | |
Miscellaneous | $56,000.00 | $0.00 | $1,500.00 | $54,500.00 | |
Total | $2,782,000.00 | $1,400.00 | $32,200.00 | $2,748,400.00 |