Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer A, B, C. Washington City created an Information Technology department four years ago to centralize information technology (IT) functions for the city. The

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

please answer A, B, C.

Washington City created an Information Technology department four years ago 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 4 percent. The preclosing trial balance for the IT department as of last year, is shown below. Cash Due from Other Funds Materials and Supplies Inventory Machinery and Equipment Accumulated Depreciation Accounts Payable Due to Federal Government Due to Other Funds Net Position-Net Investment in Capital Assets Net Position-Unrestricted Debits Credits (in thousands) $ 14,000 4,110 360 52,700 $ 29,800 1,760 2,640 1,170 22,900 12,900 $ 71,170 $ 71,170 During the current fiscal year ended December 31, the following transactions (summarized in thousands of dollars) occurred: 1. Gross employee wages were $56,700, including the employer's share of social security taxes amounting to $4,040. Federal income and social security taxes withheld from that amount totaled $18,460. 2. Office expenses in the amount of $3,670 were paid in cash. 3. Materials and supplies purchased on account during the year were $8,330. 4. A bill totaling $14,410 was received for utilities provided by Washington City's utility fund. 5. Cash paid to the federal government for payroll taxes was $22,800. 6. Cash paid to the Utility Fund was $14,000. 7. Accounts payable at year-end totaled $2,930. 8. Materials and supplies used during the year were $8,210. 9. Charges to departments during the fiscal year were as follows: General Fund Special Revenue Fund $57,200 20,400 10. Unpaid balances at year-end were: General Fund Special Revenue Fund $ 3,500 1,900 11. The depreciation for the year was $6,000. 12. Revenue and expense accounts for the year were closed. a-3. Prepare a statement of revenues, expenses, and changes in net position for the Information Technology Fund for the current year ended December 31. (Enter your answers in thousands of dollars.) WASHINGTON CITY Information Technology Fund Statement of Revenues, Expenses, and Changes in Fund Net Position For the Year Ended December 31 Billings to Departments $ 77,600 Operating Expenses: Wage Expense 52,660 Payroll Tax Expense 4,040 Utility Expense 14,410 Office Expenses 3,670 Cost of Materials and Supplies Used 8,210 Depreciation Expense 6,000 Total Operating Expenses Operating Loss Net Position, January 1 Net Position, December 31 88,990 (11,390) 35,800 24,410 $ b. Prepare a statement of net position for the Information Technology Fund as of December 31. (Enter your answers in thousands of dollars.) WASHINGTON CITY Information Technology Fund Statement of Net Position As of December 31 Assets Current Assets Cash Due from Other Funds Materials and Supplies Inventory CA 0 0 Total Current Assets Capital Assets: Machinery and Equipment Less: Allowance for Depreciation Total Capital Assets Total Assets Liabilities Accounts Payable Due to Federal Government Due to Other Funds 0 0 Total Current Liabilities Net Position Net PositionNet Investment in Capital Assets Net PositionUnrestricted Total Net Position $ 0 c. Prepare a statement of cash flows for the Information Technology Fund for the current year ended December 31. (Negative amounts should be indicated by a minus sign. Enter your answers in thousands of dollars.) WASHINGTON CITY Information Technology Fund Statement of Cash Flows For the Year Ended December 31 Cash Flows from Operating Activities: Cash Received from Customers Cash Paid To: Employees 33,630 Federal Government (W/T, FICA) 22,500 Suppliers Other Departments 13,700 74.630 69,830 GA Net Cash Provided by Operations Net Decrease in Cash and Cash Equivalents Cash and Cash Equivalents, 01/01 Cash and Cash Equivalents, 12/31 144,460 144,460 13,700 158,160 $ $ (11,480) Reconciliation of Operating Income to Net Cash Provided by Operations Operating Income/(Loss) Adjustments: Depreciation Expense-Machinery and Equipment Increase in Inventory Increase in Receivables from Other Funds Increase in Accounts Payable Decrease in Due to Federal Government Increase in Due to Other Funds Net Cash Provided by Operating Activities 6,000 (150) (1,470) 1,290 (330) 440 (5,700) $ Washington City created an Information Technology department four years ago 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 4 percent. The preclosing trial balance for the IT department as of last year, is shown below. Cash Due from Other Funds Materials and Supplies Inventory Machinery and Equipment Accumulated Depreciation Accounts Payable Due to Federal Government Due to Other Funds Net Position-Net Investment in Capital Assets Net Position-Unrestricted Debits Credits (in thousands) $ 14,000 4,110 360 52,700 $ 29,800 1,760 2,640 1,170 22,900 12,900 $ 71,170 $ 71,170 During the current fiscal year ended December 31, the following transactions (summarized in thousands of dollars) occurred: 1. Gross employee wages were $56,700, including the employer's share of social security taxes amounting to $4,040. Federal income and social security taxes withheld from that amount totaled $18,460. 2. Office expenses in the amount of $3,670 were paid in cash. 3. Materials and supplies purchased on account during the year were $8,330. 4. A bill totaling $14,410 was received for utilities provided by Washington City's utility fund. 5. Cash paid to the federal government for payroll taxes was $22,800. 6. Cash paid to the Utility Fund was $14,000. 7. Accounts payable at year-end totaled $2,930. 8. Materials and supplies used during the year were $8,210. 9. Charges to departments during the fiscal year were as follows: General Fund Special Revenue Fund $57,200 20,400 10. Unpaid balances at year-end were: General Fund Special Revenue Fund $ 3,500 1,900 11. The depreciation for the year was $6,000. 12. Revenue and expense accounts for the year were closed. a-3. Prepare a statement of revenues, expenses, and changes in net position for the Information Technology Fund for the current year ended December 31. (Enter your answers in thousands of dollars.) WASHINGTON CITY Information Technology Fund Statement of Revenues, Expenses, and Changes in Fund Net Position For the Year Ended December 31 Billings to Departments $ 77,600 Operating Expenses: Wage Expense 52,660 Payroll Tax Expense 4,040 Utility Expense 14,410 Office Expenses 3,670 Cost of Materials and Supplies Used 8,210 Depreciation Expense 6,000 Total Operating Expenses Operating Loss Net Position, January 1 Net Position, December 31 88,990 (11,390) 35,800 24,410 $ b. Prepare a statement of net position for the Information Technology Fund as of December 31. (Enter your answers in thousands of dollars.) WASHINGTON CITY Information Technology Fund Statement of Net Position As of December 31 Assets Current Assets Cash Due from Other Funds Materials and Supplies Inventory CA 0 0 Total Current Assets Capital Assets: Machinery and Equipment Less: Allowance for Depreciation Total Capital Assets Total Assets Liabilities Accounts Payable Due to Federal Government Due to Other Funds 0 0 Total Current Liabilities Net Position Net PositionNet Investment in Capital Assets Net PositionUnrestricted Total Net Position $ 0 c. Prepare a statement of cash flows for the Information Technology Fund for the current year ended December 31. (Negative amounts should be indicated by a minus sign. Enter your answers in thousands of dollars.) WASHINGTON CITY Information Technology Fund Statement of Cash Flows For the Year Ended December 31 Cash Flows from Operating Activities: Cash Received from Customers Cash Paid To: Employees 33,630 Federal Government (W/T, FICA) 22,500 Suppliers Other Departments 13,700 74.630 69,830 GA Net Cash Provided by Operations Net Decrease in Cash and Cash Equivalents Cash and Cash Equivalents, 01/01 Cash and Cash Equivalents, 12/31 144,460 144,460 13,700 158,160 $ $ (11,480) Reconciliation of Operating Income to Net Cash Provided by Operations Operating Income/(Loss) Adjustments: Depreciation Expense-Machinery and Equipment Increase in Inventory Increase in Receivables from Other Funds Increase in Accounts Payable Decrease in Due to Federal Government Increase in Due to Other Funds Net Cash Provided by Operating Activities 6,000 (150) (1,470) 1,290 (330) 440 (5,700) $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

25.0 m C B A 52.0 m 65.0 m

Answered: 1 week ago