Question

In: Accounting

6–C. Part 3. Proprietary Fund Financial Statements Required: Prepare, in good form, for the proprietary funds...

6–C. Part 3. Proprietary Fund Financial Statements

Required:

Prepare, in good form, for the proprietary funds accounted for in Parts 1 and 2, the following:

(1) A Statement of Revenues, Expenses, and Changes in Fund Net position for the Year Ended December 31, 2017.

(2) A Statement of Net position, as of December 31, 2017.

(3) A Statement of Cash Flows for the Year Ended December 31, 2017. Include restricted assets as a part of cash and cash equivalents for this statement. (Assume any materials and labor attributable to construction in process were paid by year end).


Previous Information

6–C. Part 1. Internal Service Fund Transactions

The Stores and Service Fund of the City of Monroe had the following account balances as of January 1, 2017:

Debits

Credits

Cash

$28,000

Due from other funds

27,000

Inventory of supplies

27,500

Land

18,000

Buildings

84,000

Accumulated depreciation—buildings

$30,000

Equipment

46,000

Accumulated depreciation—equipment

25,000

Accounts payable

19,000

Advance from water utility fund

30,000

Net position

126,500

Totals

$230,500

$230,500

Required:

a. Open a general journal for the City of Monroe Stores and Service Fund and record the following transactions.

(1) A budget was prepared for FY 2017. It was estimated that the price charged other departments for supplies should be 1.25% of cost to achieve the desired breakeven for the year.

(2) The amount due from other funds as of January 1, 2017, was collected in full.

(3) During the year, supplies were ordered and received in the amount of $307,000. This amount was posted to accounts payable.

(4) $15,000 of the advance from the Water Utility Fund, originally provided for construction, was repaid. No interest is charged.

(5) During the year, supplies costing $250,560 were issued to the General Fund, and supplies costing $46,400 were issued to the Water Utility Fund. These funds were charged based on the previously determined markup ($ 313,200 to General Fund and 58,000 to the Water Utility Fund).

(6) Operating expenses, exclusive of depreciation, were recorded in accounts payable as follows: Purchasing, $15,000; Warehousing, $16,900; Delivery, $17,500; and Administrative, $9,000.

(7) Cash was received from the General Fund in the amount of $310,000 and from the Water Utility Fund in the amount of $50,000.

(8) Accounts payable were paid in the amount of $365,000.

(9) Depreciation in the amount of $10,000 was recorded for buildings and $4,600 for equipment.

b. Post the entries to the Stores and Service Fund ledger (t-accounts).

c. Prepare and post an entry closing all nominal accounts to Net position. Compute the balance in the net position accounts, assuming there are no Restricted Net position.

6–C. Part 2. Enterprise Fund Transactions

The City of Monroe maintains a Water and Sewer Fund to provide utility services to its citizens. As of January 1, 2017, the City of Monroe Water and Sewer Fund had the following account balances:

Debits

Credits

Cash

$ 98,000

Customer Accounts Receivable

84,000

Estimated Uncollectible Accounts Receivable

$4,000

Materials and Supplies

28,000

Advance to Stores and Services Fund

30,000

Restricted Assets

117,000

Water Treatment Plant in Service

4,200,000

Construction Work in Progress

203,000

Accumulated Depreciation - Utility Plant

1,200,000

Accounts Payable

97,000

Revenue Bonds Payable

2,500,000

Net position

959,000

Totals

$4,760,000

$4,760,000

Required:

a. Open a general journal for the City of Monroe Water and Sewer Utility Fund and record the following transactions.

(1) During the year, sales of water to non-government customers amounted to $1,018,000 and sales of water to the General Fund amounted to $37,000.

(2) Collections from non-government customers amounted to $976,000.

(3) The Stores and Services Fund repaid $15,000 of the long-term advance to the Water and Sewer Fund.

(4) Materials and supplies in the amount of $261,000 were received. A liability in that amount was recorded.

(5) Materials and supplies were issued and were charged to the following accounts: cost of sales and services, $169,500; selling, $15,000; administration, $18,000; construction work in progress, $50,000.

(6) Payroll costs for the year totaled $416,200 plus $34,200 for the employer’s share of payroll taxes. Of that amount, $351,900 was paid in cash, and the remainder was withheld for taxes. The $450,400 (416,200 + 34,200) was distributed as follows: cost of sales and services, $265,800; sales, $43,900; administration, $91,400; construction work in progress, $49,300.

(7) Bond interest (6½%) in the amount of $162,500 was paid.

(8) Interest in the amount of $17,000 (included in 7 above) was reclassified to Construction Work in Progress.

(9) Construction projects at the water treatment plant (reflected in the beginning balance of construction in process) were completed in the amount of $203,000, and the assets were placed in service. Payments for these amounts were made in the previous year (no effect on 2017 Statement of Cash Flows).

(10) Collection efforts were discontinued on bills totaling $2,890. The unpaid receivables were written off.

(11) An analysis of customer receivable balances indicated the Estimated Uncollectible Accounts needed to be increased by $5,500.

(12) Payment of accounts payable amounted to $302,000. Payments of payroll taxes totaled $95,200.

(13) Supplies transferred from the Stores and Services Fund amounted to $58,000. Cash in the amount of $50,000 was paid to the Stores and Services Fund for supplies.

(14) Depreciation expense for the year was computed to be $282,000.

(15) In accord with the revenue bond indenture, $25,000 cash was transferred from operating cash to restricted assets.

b. Post the entries to the Water and Sewer Fund ledger (t-accounts).

c. Prepare and post an entry closing all nominal accounts to Net position. Compute the balance in the net position accounts, assuming the only restricted assets are those identified with the bond indenture and the outstanding bonds are associated with the purchase of capital assets.

Solutions

Expert Solution

City of Monroe Stores and Service Fund

Journal Entry

Reference Account Titiles Debit Credit

Ac)1) No journal entry

Ac)2) Cash 27000

Due from other funds 27000

3) Inventory of supplies 307000

Accounts Payable 307000

4) Advance from Water utility fund 15000

Cash 15000

5) Due from other funds 371,200

Operating Revenues- Charges for sales and services 371,200

Operating expenses cost of sales and services 296,960

Material and Supplies 296,960

6) Operating Expenses-Cost of Sales and Services 49,400

Operating Expenses Administration 9,000

Accounts payable 58,400

7) Cash 360,000

Due from other funds 360,000

8) Accounts Payable 365,000

Cash 365,000

9)Operating expenses depreciation 14,600

Accumulated Depreciation building 10,000

Accumulated Depreciation equipment 4,600

total 1,815,160 1,815,160

                        Cash

28,000

27,000

360,000

15,000

365,000

35,000

Inventories of Supplies

27,500

307,000

296,960

37,540

                       Due from other Funds

27,000

371,200

27,000

360,000

11,200

Land

18,000

18,000

                        Building

84,000

84,000

                        Accumulated depr. Building

30,000

10,000

40,000

Equipment

46,000

46,000

                Accumulated Depr, Equipment

25,000

4,600

29,600

Accounts payable

365,000

19,000

307,000

58,400

19,400

Advances from water utility funds

15,000

30,000

15,000

Net Position (beginning)

126,500

126,500

Revenue Charges from sales and services

371,200

371,200

Operating expenses costof sales and services

296,960

49,400

346,360

Operating expenses Administration

9,000

9,000

Operating expenses Depreciation

14,600

14,600

Total Debit : 6,01,700

Total credit: 6,01,700


Related Solutions

6–C. Part 3. Proprietary Fund Financial Statements Required: Prepare, in good form, for the proprietary funds...
6–C. Part 3. Proprietary Fund Financial Statements Required: Prepare, in good form, for the proprietary funds accounted for in Parts 1 and 2, the following: (1) A Statement of Revenues, Expenses, and Changes in Fund Net position for the Year Ended December 31, 2017. (2) A Statement of Net position, as of December 31, 2017. (3) A Statement of Cash Flows for the Year Ended December 31, 2017. Include restricted assets as a part of cash and cash equivalents for...
Chapter 6 – Proprietary Funds I need Part 3 6–C. Part 1. Internal Service Fund Transactions...
Chapter 6 – Proprietary Funds I need Part 3 6–C. Part 1. Internal Service Fund Transactions The Stores and Service Fund of the City of Monroe had the following account balances as of January 1, 2017: Debits Credits Cash $28,000 Due from other funds 27,000 Inventory of supplies 27,500 Land 18,000 Buildings 84,000 Accumulated depreciation—buildings $30,000 Equipment 46,000 Accumulated depreciation—equipment 25,000 Accounts payable 19,000 Advance from water utility fund 30,000 Net position 126,500 Totals $230,500 $230,500 Required: a. Open a...
5–C. Part 4. Governmental Funds Financial Statements Required: a. Prepare a Balance Sheet for the governmental...
5–C. Part 4. Governmental Funds Financial Statements Required: a. Prepare a Balance Sheet for the governmental funds for the City of Monroe as of December 31, 2017. Include the General Fund, the Street and Highway Fund (P4–C), the City Hall Debt Service Fund, and the City Jail Debt Service Fund. Use the balances computed in 4-C for the General Fund and special revenue fund portions of this statement. b. Prepare a Statement of Revenues, Expenditures, and Changes in Fund Balances...
How do proprietary fund financial statements differ from other fund type’s financial statements?
How do proprietary fund financial statements differ from other fund type’s financial statements?
Which of the following statements is not a required part of the basic financial statements of...
Which of the following statements is not a required part of the basic financial statements of Carlton City? Question 25 options: Government-wide statement of net position. Statement of revenues, expenditures, and changes in fund balances for all governmental funds. Statement of revenues, expenses, and changes in net assets for all fiduciary funds. Statement of cash flows for all proprietary funds.
1. Describe the attributes of the Proprietary Fund Category. Discuss the purposes of the two funds...
1. Describe the attributes of the Proprietary Fund Category. Discuss the purposes of the two funds within this category. Explain why accrual accounting and the economic resources measurement focus are the appropriate methods for the proprietary funds 2.Describe the attributes of the Fiduciary Fund Category Discuss the purposes of the four funds within this category. Explain why accrual accounting and the economic resources measurement focus are the appropriate methods for the proprietary funds
Which of the following is true regarding proprietary funds? A. When an Enterprise Fund is used,...
Which of the following is true regarding proprietary funds? A. When an Enterprise Fund is used, expenses are accrued only if they are expected to be paid within 60 days of year end. B. An Enterprise Fund may not be used if the fund receives a subsidy from another fund. C. An Internal Service Fund is used if the main customers paying for the service are other funds or agencies of the government. D. An Enterprise Fund must be used...
Q1. The following are statements for the use of Proprietary Funds State whether the following are...
Q1. The following are statements for the use of Proprietary Funds State whether the following are true or false. For the false items, explain why they are false. ​​a.​Enterprise Funds are used only when all services are provided to non-governmental entities, and Internal Service Funds are used only when all services are provided to governmental agencies that are a part of the reporting government. ​​b.​Enterprise Funds use the economic resources measurement focus and full accrual basis of accounting only when...
Here is the proprietary fund transactions and statements to be completed. As of July 1, 2016,...
Here is the proprietary fund transactions and statements to be completed. As of July 1, 2016, the City of Saratoga Springs decided to purchase a privately operated swimming pool and to create a Swimming Pool (Enterprise) Fund. During the year, the following transactions occurred: 1.    A permanent contribution of $ 1,200,000 was received from the General Fund. 2.    $ 1,000,000 was borrowed with a Note Payable from a local bank at an interest rate of 6%. The note was dated July 1,...
E-45 (Statement of revenues, expenditures, and changes in fund balances) prepare, in good form, the 20x1...
E-45 (Statement of revenues, expenditures, and changes in fund balances) prepare, in good form, the 20x1 statement of revenues, expenditures, and changes in fund balances for the general fund of Crabtree township, based on the following information: Property tax revenues $13,000,000 Licenses and permits $800,000 Intergovernmental grants $2,500,000 Short-term note proceeds $775,000 General capital asset sale proceeds (Equal to book value less 10%) $523,000 Receipt of residual assets of terminated Debt Service Fund $90,000 Amount paid to Debt service fund...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT