Excel-Based Problems 4-11. Jefferson County General Fund began the year 2015 with the follon account balances: Debits $132,348 Cash 47,220 Taxes Receivable 1,570 Allowance for Uncollectible Taxes 660 Supplies 21.000 Deferred Inflows Property Taxes 900 Wages Payable 156.758 Fund Balance $180,228 Totals During 2015, Jefferson experienced the following transactions: 1. The budget was passed by the County Commission, providing e timated revenues of $250,000 and appropriations of $200.000 ad estimated other financing uses of $40,000. 2. Encumbrances totaling $4,800 outstanding at December 31. 2014. were re-established. 3. The Deferred Inflows Property Taxes at December 31, 2014 recognized as revenue in the current period. 4. Property taxes in the amount of s265.000 were levied by the Coun llectible. 5. Property tax collections totaled $258,000. Accounts totaling were written off as uncollectible. si. 6. Encumbrances were issued for supplies S36,000. 7. in the amount in the amount of C of s39.800 were received. Jefferson records supplies as an asset when acquired. The brances for these items totaled $40,000 and included the encumbered last year. The County paid $37.800 on accounts pay- able during the year