Washington City created an Information Technology department in 2013 to centrali
ID: 2542324 • Letter: W
Question
Washington City created an Information Technology department in 2013 to centralize information technology (IT) functions for the city. The goal of the department was to reduce costs, avoid duplication of efforts, and provide up-to-date technology to all of the city's operations. The fund was designed to be self-supporting; that is, all costs are to be recovered through user fees, but any excess of fees over expenses should be less than 5%. The pre-closing trial balance for the IT department as of December 31, 2017 is shown below. Credits Debits $13,700 3,810 320 52,200 Cash Due from Other Funds Materials and Supplies Inventory Machinery and Equipment Accumulated Depreciation Accounts Payable Payroll Taxes Payable Due to Other Funds Net Position - Net Investment in Capital Assets Net Position – Unrestricted $29,300 1,470 2,590 1,170 22,900 12,600 $70,030 $70,030 During the fiscal year ended December 31, 2017, the following transactions (summarized) occurred: 1. Gross employee wages were $55, 100, including the employer's share of social security taxes amounting to $3,930. Federal income and social security taxes withheld from that amount totaled $17,960. 2. Office expenses in the amount of $3,560 were paid in cash. 3. Materials and supplies purchased on account during the year were $8,060. 4. Received a bill totaling $13,930 for utilities provided by Washington City's utility fund. 5. Cash paid to the federal government for payroll taxes was $22,200. 6. Cash paid to the Utility Fund was $13,700. 7. Accounts payable at year end totaled $2,830. 8. Materials and supplies used during the year were $7,910. 9. Charges to departments during the fiscal year were as follows: General Fund Special Revenue Fund $55,200 19,900 10. Unpaid balances at year end were: General Fund Special Revenue Fund $ 3,500 1,900 11. The depreciation for the year was $6,200. 12. Revenue and expense accounts for the year were closed.Explanation / Answer
Washington City Information Technology Fund Statement of Cash Flows For the Year Ended December 31,2017 Cash flow from Operating Activities 1.Cash Received from Customers $73,510.00 2.Cash Paid to $79,370.00 a.Employees $33,210.00 b.Federal Government $22,200.00 c.Supplier(13700+6700) $20,400.00 d.Other Depts $3,560.00 Net Cash Provided by Operations(1-2) -$5,860.00 Net Decrease in Cash and Cash Equivalents -$5,860.00 Cash and Cash Equivalents- 01/01/2017 $13,700.00 Cash and Cash Equivalents- 31/12/2017 $7,840.00 Reconciliation of Operating Income to Net Cash Provided by Operations Operating Income/(loss) -$11,600.00 Adjustments Depreciation Expense $6,200.00 Increase in Inventory(470-320) -$150.00 Increase in Receivables(5400-3810) -$1,590.00 Increase in Accounts Payable(2830-1470) $1,360.00 Decrease in Due to federal govt(2590-2280) -$310.00 Increase in due to other funds(1400-1170) $230.00 Net Cash Provided by Operating Activities -$5,860.00 Increase in Inventory means we have purchased some inventory that means outflow of Cash Decrease in Receivables means amount received from Customers and viceversa for Increase in Receivables Increase in Account Payable means new liability received that is Inflow of Cash Decrease in due to Govt means paid to govt then there is outflow of cash Increase in due to other funds is same as increase in Accounts Payable
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.