Question

In: Accounting

Washington City created an Information Technology department in 2013 to centralize information technology (IT) functions for...

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.

Debits Credits
  Cash $ 14,500
  Due from Other Funds 4,250
  Materials and Supplies Inventory 350
  Machinery and Equipment 53,600
  Accumulated Depreciation $ 30,100
  Accounts Payable 2,550
  Payroll Taxes Payable 2,650
  Due to Other Funds 1,200
  Net Position – Net Investment in Capital Assets 23,500
  Net Position – Unrestricted 12,700
$ 72,700 $ 72,700
During the fiscal year ended December 31, 2017, the following transactions (summarized) occurred:
1.

Gross employee wages were $57,600, including the employer’s share of social security taxes amounting to $4,100. Federal income and social security taxes withheld from that amount totaled $18,725.

2. Office expenses in the amount of $3,700 were paid in cash.
3. Materials and supplies purchased on account during the year were $8,400.
4. Received a bill totaling $14,525 for utilities provided by Washington City’s utility fund.
5. Cash paid to the federal government for payroll taxes was $23,000.
6. Cash paid to the Utility Fund was $14,500.
7. Accounts payable at year end totaled $2,950.
8. Materials and supplies used during the year were $8,250.
9. Charges to departments during the fiscal year were as follows:
  General Fund $ 57,500
  Special Revenue Fund 20,600
10. Unpaid balances at year end were:
  General Fund $ 3,500
  Special Revenue Fund 1,800
11. The depreciation for the year was $6,100.
12. Revenue and expense accounts for the year were closed.
Required
a-1.

Prepare journal entries for the Information Technology Fund for 2017. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) (Journal entries are numberes 1-11)


1. Gross employee wages were $57,600, including the employer’s share of social security taxes amounting to $4,100. Federal income and social security taxes withheld from that amount totaled $18,725.

2. Office expenses in the amount of $3,700 were paid in cash.

3. Materials and supplies purchased on account during the year were $8,400.

4. Received a bill totaling $14,525 for utilities provided by Washington City’s utility fund.

5. Cash paid to the federal government for payroll taxes was $23,000.

6. Cash paid to the Utility Fund was $14,500.

7. Accounts payable at year end totaled $2,950.

8. Materials and supplies used during the year were $8,250.

9. Record the billing to departments.

10. Record the cash received from other funds.

11. The depreciation for the year was $6,100.

Additionally,

Prepare closing entry for the Information Technology Fund for 2017. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) (Journal Entries are numbered 1-3)

1. Record the closure of revenue and expense accounts.

2. Record the operating loss for the year.

3. The depreciation for the year was $6,100.

Solutions

Expert Solution

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.

Date Account Debit Credit
1 Wage Expense (57600-4100) 53500
Payroll Tax Expense 4100
Cash 34775
Due to Federal (4100+18725) 22825
2 Office Expense 3700
Cash 3700
3 Material and Supplies Inventory 8400
Accounts Payable 8400
4 Utility Expense 14525
Due to other funds 14525
5 Due to Federal 23000
Cash 23000
6 Due to other funds 14500
Cash 14500
7 Accounts Payable (2550+8400-2950) 8000
Cash 8000
8 Cost of Material and Supplies 8250
Material and Supplies Inventory 8250
9 Due from other Funds 78100
Billing to Department 78100
10 Cash (4250+78100-3500-1800) 77050
Due from other Funds 77050
11 Depreciation Expense 6100
Allowance for Depreciation 6100
Closing Entries:
1a Billing to Department 78100
Excess of Cost over Net Billings to Department 12075
Wage Expense 53500
Payroll Tax Expense 4100
Utility Expense 14525
Office Expense 3700
Cost of Material and Supplies 8250
Depreciation Expense 6100
1b Net Position- Unrestricted 12075
Excess of Cost over Net Billings to Department 12075
1c Net Position-Net investment in capital asset 6100
Net Position-Unrestricted 6100

Related Solutions

Washington City created an Information Technology department four years ago to centralize information technology (IT) functions...
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 5 percent. The preclosing trial balance for the IT...
Colleges in Washington state offer many programs in information technology and computer science. Productivity of workers...
Colleges in Washington state offer many programs in information technology and computer science. Productivity of workers increases dramatically. Draw a graph to show how the increase in labor productivity will affect the loanable funds market. Would GDP increase or decrease?
Internal resources, such as the legal department, training department, information technology, tend to be under-utilized, leading...
Internal resources, such as the legal department, training department, information technology, tend to be under-utilized, leading to a death spiral, when: A. managers may choose whether to purchase the service internally or externally B. the internal pricing system seeks to recover sunk costs C. the internal pricing system utilizes full costs D. all of the choices are correct Of the following statements, which is true? A. Joint costs are incurred only in disassembly B. The costs of harvesting a pineapple...
Imagine that you are working as manager of the Information Technology Department, ASCS College, King Saud...
Imagine that you are working as manager of the Information Technology Department, ASCS College, King Saud University, Riyadh, Saudi Arabia. Write a business letter (Alternative block format) to Sales Manager, Dell Company situated at the following address Dell Computer Corporation, One Dell Way Round Rock, Texas 78682, United States of America. Requesting them to send the price quotation of 100 workstations with the following configuration. Precision T3630;Tower Workstation; Intel Xeon E-2174G, 4 Core HT, 8MB Cache, 3.8Ghz, 4.7GHz; Windows 10...
Cheyenne Washington is the department manager for Religious Books, a manufacturer of religious books that are...
Cheyenne Washington is the department manager for Religious Books, a manufacturer of religious books that are sold through Internet companies. Ms. Washington's bonus is based on reducing production costs. Ms. Washington has identified a supplier, Cheap Paper, tht can provide paper products at a 10% cost reduction. The paper quality is not the same as that of the current papaer used in production. If Irwin uses the supplier, she will certainly achieve her personal bonus goals; however, other company goals...
Charter Financial Bank operates three branches in a southeastern city. Ray Copper, Vice-President of Information Technology...
Charter Financial Bank operates three branches in a southeastern city. Ray Copper, Vice-President of Information Technology at the bank, has recently been charged by the bank’s president to develop a Website to promote bank services, to provide access to customer account information, and to allow individuals to apply online for loans and credit cards. Ray decided to assign this project to Rachel Smith, one of two directors in the information technology group. Since Charter Financial did not currently have a...
Omni Optical Inc Omni Optical, Inc. was created in 2013 and entered the optical equipment industry....
Omni Optical Inc Omni Optical, Inc. was created in 2013 and entered the optical equipment industry. Its made-to-order optical equipment requires large investments in research and development. To fund these needs, ONMI made a public stock offering, which was completed in 2014. Although the offering was moderately successful, ONMI’s ambitious management is convinced that it must report a good profit this year (2015) to maintain the current market price of the stock. ONMI’s president recently stressed this point when she...
American Printing Company’s information technology department administers the company’s material requirements planning and general ledger systems....
American Printing Company’s information technology department administers the company’s material requirements planning and general ledger systems. It also provides support to the computer-based shop floor reporting and payroll systems, as well as personnel computing services for each department’s administration. Recently, American Printing’s Controller, Sally Sound, has been considering outsourcing IT operations to Cloud computing providers to minimize support department expenses. She has been reviewing potential contracts with Cloud suppliers, and interviewed the managers of departments that receive support from the...
Taxpayer Information                Name:   John Washington                Address:   3450 Gr
Taxpayer Information                Name:   John Washington                Address:   3450 Green St.                                   Miami, FL 54321                DOB:   5/5/1960                Filing Status: Married                SSN: 434-20-2020                Occupation: Engineer                Name: Debra Washington                Address: 3450 Green St.                                  Miami, FL 54321                DOB: 7/7/1962                Filing Status: Married                SSN: 411-21-4568                Occupation: Teacher INCOME INFORMATION:                Wages and Compensation The following information is taken from John Washington’s 2017 Form W-2 Wage and Tax Statement:                                              Box 1...
What terms are related to information sharing technology? COURSE: Information Technology for the Health Professions
What terms are related to information sharing technology? COURSE: Information Technology for the Health Professions
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT