Reference no: EM131525721

Question: Jefferson County operates a centralized motor pool to service county vehicles. At the end of 2011, the Motor Pool Internal Service Fund had the following account balances:

The following events took place during 2012:

1. Additional supplies were purchased on account in the amount of $35,000.

2. Services provided to other departments on account totaled $95,000. A total of $65,000 was for departments in the General Fund and $30,000 for enterprise fund departments.

3. Supplies used amounted to $36,700.

4. Payments made on accounts payable amounted to $38,200.

5. Cash collected from the General Fund totaled $57,000 and cash collected from the enterprise fund totaled $30,000.

6. Salaries were paid in the amount of $47,000. Included in this amount is the accrued wages payable at the end of 2011. All of these are determined to be part of the cost of services provided.

7. In a previous year, the enterprise fund loaned the Motor Pool money under an advance for the purpose of purchasing garage equipment. In the current year, the Motor Pool repaid the enterprise fund $7,000 of this amount.

8. On July 1, 2012, the Motor Pool Fund borrowed $10,000 from the bank, signing a 12 percent note that is due on June 30, 2013. The borrowings are not related to capital asset purchases but were made to provide working capital.
Additional information includes:

9. Depreciation for the year amounted to $7,500.

10. The payment of interest on the note is payable on June 30, 2013.

11. Unpaid wages relating to the final week of the year totaled $420.
Using the Excel template provided; a separate tab is provided for each of the requirements:

a. Prepare journal entries.

b. Post entries to the T-accounts.

c. Prepare closing entries.

d. Prepare a Statement of Revenues, Expenses and Changes in Fund Net Assets.

e. Prepare a Statement of Net Assets.

f. Prepare a Statement of Cash Flows for the year ending December-31-2012.