Excel-Based Problems 4-11. Jefferson County's General Fund began the year 2017 with the following account balances: Debits Credits Cash $132,348 Taxes Receivable 47,220 Allowance for Uncollectible Taxes $ 1,570 Supplies 660 Deferred InflowsProperty Taxes 21,000 Wages Payable Fund Balance 156,758 Totals $180,228 $180,228 900 During 2017, Jefferson experienced the following transactions: 1. The budget was passed by the County Commission, providing estimated revenues of $285,000 and appropriations of $235,000 and estimated other financing uses of $40,000. 2. Encumbrances totaling $4,800 outstanding at December 31, 2016, were re-established. 3. The Deferred InflowsProperty Taxes at December 31, 2016, is recognized as revenue in the current period. 4. Property taxes in the amount of $290,000 were levied by the County. It is estimated 0.5 percent (1/2 of 1 percent) will be uncollectible. 5. Property tax collections totaled $263,400. Accounts totaling $1,020 were written off as uncollectible. 6. Encumbrances were issued for supplies in the amount of $37,100. 7. Supplies in the amount of $40,500 were received. Jefferson County records supplies as an asset when acquired. The related encumbrances for these items totaled $41,000 and included the $4,800 encumbered last year. The County paid $37,800 on accounts payable during the year. 8. The County contracted to have alarm systems (capital assets) installed in the administration building at a cost of $46,000. The systems were installed and the amount was paid. 9. Paid wages totaling $135,900, including the amount payable at the end of 2016. (These were for general page 115 3. The Deferred InflowsProperty Taxes at December 31, 2016, is recognized as revenue in the current period. 4. Property taxes in the amount of $290,000 were levied by the County. It is estimated 0.5 percent (1/2 of 1 percent) will be uncollectible. 5. Property tax collections totaled $263,400. Accounts totaling $1,020 were written off as uncollectible. 6. Encumbrances were issued for supplies in the amount of $37.100. page 115 7. Supplies in the amount of $40,500 were received. Jefferson County records supplies as an asset when acquired. The related encumbrances for these items totaled $41,000 and included the $4,800 encumbered last year. The County paid $37,800 on accounts payable during the year. 8. The County contracted to have alarm systems (capital assets) installed in the administration building at a cost of $46,000. The systems were installed and the amount was paid. 9. Paid wages totaling $135,900, including the amount payable at the end of 2016. (These were for general government operations.) 10. Paid other general government operating items of $7,600. 11. The General Fund transferred $43,000 to the debt service fund in anticipation of bond interest and principal payments. Additional Information 12. Wages earned but unpaid at the end of the year amounted to $1,050. 13. Supplies of $350 were on hand at the end of the year. (Supplies are used for general government operations.) 14. A review of property taxes receivable indicates that $22,000 of the outstanding balances would likely be collected more than 60 days after year-end and should be deferred. Required: Use the Excel template provided on the textbook website to complete the following requirements. A separate tab is provided in Excel for the following items: a. Prepare journal entries to record the information described in items 1 to 14. Classify expenditures in the General Fund as either General Government or Capital Outlay. Make entries directly to these and the individual revenue accounts; do not use subsidiary ledgers. Excel-Based Problems 4-11. Jefferson County's General Fund began the year 2017 with the following account balances: Debits Credits Cash $132,348 Taxes Receivable 47,220 Allowance for Uncollectible Taxes $ 1,570 Supplies 660 Deferred InflowsProperty Taxes 21,000 Wages Payable Fund Balance 156,758 Totals $180,228 $180,228 900 During 2017, Jefferson experienced the following transactions: 1. The budget was passed by the County Commission, providing estimated revenues of $285,000 and appropriations of $235,000 and estimated other financing uses of $40,000. 2. Encumbrances totaling $4,800 outstanding at December 31, 2016, were re-established. 3. The Deferred InflowsProperty Taxes at December 31, 2016, is recognized as revenue in the current period. 4. Property taxes in the amount of $290,000 were levied by the County. It is estimated 0.5 percent (1/2 of 1 percent) will be uncollectible. 5. Property tax collections totaled $263,400. Accounts totaling $1,020 were written off as uncollectible. 6. Encumbrances were issued for supplies in the amount of $37,100. 7. Supplies in the amount of $40,500 were received. Jefferson County records supplies as an asset when acquired. The related encumbrances for these items totaled $41,000 and included the $4,800 encumbered last year. The County paid $37,800 on accounts payable during the year. 8. The County contracted to have alarm systems (capital assets) installed in the administration building at a cost of $46,000. The systems were installed and the amount was paid. 9. Paid wages totaling $135,900, including the amount payable at the end of 2016. (These were for general page 115 3. The Deferred InflowsProperty Taxes at December 31, 2016, is recognized as revenue in the current period. 4. Property taxes in the amount of $290,000 were levied by the County. It is estimated 0.5 percent (1/2 of 1 percent) will be uncollectible. 5. Property tax collections totaled $263,400. Accounts totaling $1,020 were written off as uncollectible. 6. Encumbrances were issued for supplies in the amount of $37.100. page 115 7. Supplies in the amount of $40,500 were received. Jefferson County records supplies as an asset when acquired. The related encumbrances for these items totaled $41,000 and included the $4,800 encumbered last year. The County paid $37,800 on accounts payable during the year. 8. The County contracted to have alarm systems (capital assets) installed in the administration building at a cost of $46,000. The systems were installed and the amount was paid. 9. Paid wages totaling $135,900, including the amount payable at the end of 2016. (These were for general government operations.) 10. Paid other general government operating items of $7,600. 11. The General Fund transferred $43,000 to the debt service fund in anticipation of bond interest and principal payments. Additional Information 12. Wages earned but unpaid at the end of the year amounted to $1,050. 13. Supplies of $350 were on hand at the end of the year. (Supplies are used for general government operations.) 14. A review of property taxes receivable indicates that $22,000 of the outstanding balances would likely be collected more than 60 days after year-end and should be deferred. Required: Use the Excel template provided on the textbook website to complete the following requirements. A separate tab is provided in Excel for the following items: a. Prepare journal entries to record the information described in items 1 to 14. Classify expenditures in the General Fund as either General Government or Capital Outlay. Make entries directly to these and the individual revenue accounts; do not use subsidiary ledgers