Excel-Based Problems 4-11. Jefferson County's General Fund began the year 2017 with the following account balances: Debits $132,348 47,220 Credits Cash Taxes Receivable Allowance for Uncollectible Taxes Supplies Deferred Inflows-Property Taxes $ 1,570 660 21,000 900 156,758 $180,228 Wages Payable Fund Balance Totals $180,228 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 2. Encumbrances totaling $4,800 outstanding at December 31, 2016, were 3. The Deferred Inflows-Property Taxes at December 31, 2016, is 4. Property taxes in the amount of $290,000 were levied by the County. It 5. Property tax collections totaled $263,400. Accounts totaling $1.020 other financing uses of $40,000 re-established recognized as revenue in the current period. is estimated 0.5 percent (1/2 of 1 percent) will be uncollectible 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