Question

In: Accounting

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 department as of last year, is shown below.

Debits Credits
(in thousands)
Cash $ 13,800
Due from Other Funds 3,990
Materials and Supplies Inventory 340
Machinery and Equipment 52,500
Accumulated Depreciation $ 29,600
Accounts Payable 1,640
Due to Federal Government 2,620
Due to Other Funds 1,170
Net Position—Net Investment in Capital Assets 22,900
Net Position—Unrestricted 12,700
$ 70,630 $ 70,630

During the current fiscal year ended December 31, the following transactions (summarized in thousands of dollars) occurred:

  1. Gross employee wages were $56,100, including the employer’s share of social security taxes amounting to $4,000. Federal income and social security taxes withheld from that amount totaled $18,280.
  2. Office expenses in the amount of $3,630 were paid in cash.
  3. Materials and supplies purchased on account during the year were $8,230.
  4. A bill totaling $14,230 was received for utilities provided by Washington City’s utility fund.
  5. Cash paid to the federal government for payroll taxes was $22,600.
  6. Cash paid to the Utility Fund was $13,800.
  7. Accounts payable at year-end totaled $2,890.
  8. Materials and supplies used during the year were $8,090.
  9. Charges to departments during the fiscal year were as follows:
General Fund $ 56,400
Special Revenue Fund 20,200

10. Unpaid balances at year-end were:

General Fund $ 3,500
Special Revenue Fund 1,900

11. The depreciation for the year was $6,000.
12. Revenue and expense accounts for the year were closed.

Required

  1. a-1. Prepare journal entries for the Information Technology Fund for the current year ended December 31. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field. Enter your answers in thousands of dollars.)



  1. a-2. Prepare closing entry for the Information Technology Fund for the current year ended December 31. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field. Enter your answers in thousands of dollars.)



  1. 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.)


  1. Prepare a statement of net position for the Information Technology Fund as of December 31. (Enter your answers in thousands of dollars.)


  1. 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.)
  1. Has the manager of the IT department been able to achieve the goal of recovering costs through user fees?
  • Yes

  • No

Solutions

Expert Solution

a-1. Prepare journal entries for the Information Technology Fund for the current year ended December 31.

No. Trn. General Journal Debit Credit
A 1 Wage Expense [$56100 - $4000] $52,100
Payroll Tax Expense $4,000
Due to federal government $33,820
Cash [$18280 + $4000] $22,280
B 2 Office Expense $3,630
Cash $3,630
C 3 Materials and Supplies Inventory $8,230
Accounts payable $8,230
D 4 Utility Expense $14,230
Due to other funds $14,230
E 5 Due to Federal Government $22,600
Cash $22,600
F 6 Due to Other Funds $13,800
Cash $13,800
G 7 Accounts payable $6,980
Cash [$1640 + $8230 - $2890] $6,980
H 8 Cost of Materials and supplies used $8,090
Materials and supplies Inventory $8,090
I 9 Due from Other Funds [$56400+$20200] $76,600
Billings to Departments $76,600
J 10 Cash [$3990 + $76600 - $3500 - $1900] $75,190
Due from Other Funds   $75,190
K 11 Depreciation Expense $6,000
Allowance for depreciation $6,000

_____________________________________________________________________

a-2. Prepare closing entry for the Information Technology Fund for the current year ended December 31.

No. Trn. General Journal Debit Credit
A 12(a) Billings to Departments $76,600
Excess of cost over net billings to department $11,450
Wage Expense $52,100
Office Expenses $3,630
Utility Expenses $14,230
Cost of Materials and supplies used $8,090
Depreciation Expense $6,000
Payroll Tax Expense $4,000
B 12(b) Net position-Unrestricted $11,450
Excess of cost over net billings to departments $11,450
C 12(c ) Net position-Net Investment in capital assets $6,000
Net position-unrestricted $6,000

Related Solutions

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...
Ten years ago, a large nursery sold hundreds of trees to the city through the Department...
Ten years ago, a large nursery sold hundreds of trees to the city through the Department of Parks and Recreation with the pledge that in ten years, they would reach a minimum mean height of 5.5 feet with a standard deviation od 9 inches. This week the city manager randomly selected 81 trees and found the mean height to be 5 feet. Would the sample result support a city request for a partial refund from the nursery for breach of...
Carson Company is a large manufacturing firm in Accra that was created 20 years ago by...
Carson Company is a large manufacturing firm in Accra that was created 20 years ago by the Carson family. It was initially financed with an equity investment by the Carson family and 10 other individuals. Over time, Carson Company has obtained substantial loans from finance companies and commercial banks. The interest rate on the loans is tied to the market interest rate and is adjusted every six months. Thus, Carson’s cost of obtaining funds is sensitive to interest rate movements....
Carson Company is a large manufacturing firm in Accra that was created 20 years ago by...
Carson Company is a large manufacturing firm in Accra that was created 20 years ago by the Carson family. It was initially financed with an equity investment by the Carson family and 10 other individuals. Over time, Carson Company has obtained substantial loans from finance companies and commercial banks. The interest rate on the loans is tied to the market interest rate and is adjusted every six months. Thus, Carson’s cost of obtaining funds is sensitive to interest rate movements....
Under a program that commenced 30 months ago, the social services department of a large city...
Under a program that commenced 30 months ago, the social services department of a large city has been awarding contracts to provide day-care services for children of mothers who attend special training programs to improve their work skills. Each year, the city awards 10 contracts, each for $75,000. The same 10 providers have received contracts in each of the three years. The providers are required to keep records of their costs to perform the contracts, but the contracts do not...
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?
Four years ago, Paul invested $1500. Three years ago, Trek invested $1600. Today, these two investments...
Four years ago, Paul invested $1500. Three years ago, Trek invested $1600. Today, these two investments are each worth $1800. Assume each account continues to earn its respective rate of return. (1) What is annual interest rate that Saul earned? (2) What is annual interest rate that Trek earned? (3) Was Trek’s investment worth less than Saul one year ago?
Charles and Ann live in a house that they purchased four years ago. It is a...
Charles and Ann live in a house that they purchased four years ago. It is a large Victorian-era home with 12 rooms and cost them $250,000 at the time Charles has life insurance three times his salary (salary - $81,000) from the college, and Ann has life insurance through her employer for twice her salary(salary - $40,000). Charles and Ann each purchased five-year term individual insurance policies from a local insurance broker when they purchased the house, with a face...
Five years ago, the City of Baltimore sold at par a $1,000 bond with a coupon...
Five years ago, the City of Baltimore sold at par a $1,000 bond with a coupon rate of 8 percent and 20 years to maturity. If this bond pays interest annually, what is the value of this bond to an investor who requires an 8 percent rate of return? A. $607.72 B. $692.00 C. $1,000 D. cannot be determined from the information given What is the value of an Orion bond that has a 10 percent coupon, pays interest annually,...
A few years ago, the Boston Globe reported that the city of Boston planned to spend...
A few years ago, the Boston Globe reported that the city of Boston planned to spend $14 million to convert the FleetCenter sports arena and entertainment center into an appropriate venue for the Democratic National Convention (DNC). The city engaged Shawmut Design and Construction in a contractual relationship to complete the work, which was supposed to start 48 days prior to the commencement of the DNC on July 26. However, when negotiations between Boston’s mayor and the police union broke...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT