Question

6–C. Part 1. Internal Service Fund Transactions The Stores and Service Fund of the City of...

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.

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

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Town of Weston has a Water Utility Fund with the following trial balance as of...
The Town of Weston has a Water Utility Fund with the following trial balance as of July 1, 2016, the first day of the fiscal year: Debits Credits Cash $ 338,000 Customer accounts receivable 204,800 Allowance for uncollectible accounts $ 30,800 Materials and supplies 123,200 Restricted assets (cash) 256,000 Utility plant in service 7,009,000 Accumulated depreciation—utility plant 2,609,000 Construction work in progress 108,000 Accounts payable 129,600 Accrued expenses payable 81,100 Revenue bonds payable 3,509,000 Net position 1,679,500 Totals $ 8,039,000...
The Town of Weston has a Water Utility Fund with the following trial balance as of...
The Town of Weston has a Water Utility Fund with the following trial balance as of July 1, 2019, the first day of the fiscal year: Debits Credits Cash $ 349,000 Customer accounts receivable 211,400 Allowance for uncollectible accounts $ 31,900 Materials and supplies 132,000 Restricted assets (cash) 267,000 Utility plant in service 7,031,000 Accumulated depreciation—utility plant 2,631,000 Construction work in progress 119,000 Accounts payable 142,800 Accrued expenses payable 98,500 Revenue bonds payable 3,531,000 Net position 1,674,200 Totals $ 8,109,400...
Following is the June 30, 2019, statement of net position for the City of Bay Lake...
Following is the June 30, 2019, statement of net position for the City of Bay Lake Water Utility Fund. CITY OF BAY LAKE Water Utility Fund Statement of Fund Net Position June 30, 2019 Assets Current assets: Cash and investments $ 1,775,142 Accounts receivable (net of $13,367 provision for uncollectible accounts) 306,870 Accrued utility revenue 499,600 Due from General Fund 29,288 Interest receivable 81,936 Total current assets 2,692,836 Restricted assets: Cash 9,194 Capital assets: Land $ 1,781,141 Buildings (net of...
Inglis City had a beginning cash and cash equivalents balance in its internal service fund of...
Inglis City had a beginning cash and cash equivalents balance in its internal service fund of $895,705. During the current year, the following transactions occurred: Interest received on investments totaled $42,420. The city acquired additional equity investments totaling $75,070. A grant was received from the state in the amount of $50,000 for summer interns. Receipts from sales of goods or services totaled $2,915,530. Payments for supplies were made in the amount of $1,642,180. Payments to employees for salaries amounted to...
The city’s only internal service fund, a print shop fund, is included in the proprietary funds...
The city’s only internal service fund, a print shop fund, is included in the proprietary funds statements. Prepare necessary adjustments in order to incorporate the internal service fund in the government-wide statements as a part of governmental activities: - 3 Separate entries Exclusive of the interest expense, the internal service fund reported operating income from interfund transactions of $120,000 for the current year. An examination of the records indicates that services were provided to general government departments. Balance sheet accounts...
Part V. Internal Service Fund Moody Village maintains an Internal Service Fund (ISF) for the motor...
Part V. Internal Service Fund Moody Village maintains an Internal Service Fund (ISF) for the motor pool. Prepare the journal entries to record the following transactions in the accounts of the ISF only. a. The general fund (GF) transfers $250,000 to the ISF as capital to start the ISF. (Assume no accruals have been recorded, nor should there have been, for this transfer.) b. The ISF purchases various equipment for $100,000 on account. c. The ISF purchased supplies for $10,000,...
The beginning balances as of 1/1/2017 for the City of Monroe's General Fund are listed below....
The beginning balances as of 1/1/2017 for the City of Monroe's General Fund are listed below. The City follows the modified accrual accounting method for its general fund journal entries and financial statements. The following steps are required for this project. Beginning balances: Cash $711,250; Delinquent Property Taxes Receivable $210,000; Allowance for Uncollectible Property Taxes $37,000; Accounts Payable $99,000; Due to Other Funds $27,000; Deferred Inflows of Resources $210,000; Total Fund Balance $548,250 Step 1) Record journal entries for the...
The beginning balances as of 1/1/2017 for the City of Monroe's Special Revenue Fund are listed...
The beginning balances as of 1/1/2017 for the City of Monroe's Special Revenue Fund are listed below. The City follows the modified accrual accounting method for its special revenue fund journal entries and financial statements. The following steps are required for this project. Beginning balances: Cash $23,000; Investment $59,000; Due from State Government $107,000; Accounts Payable $9,000; Total Fund Balance $180,000 Step 1) Record journal entries for the transactions below for FY2017 in Tab #1. Step 2) Create a trial...
Record journal entries for the following transactions for FY 2017 and post to the general ledger....
Record journal entries for the following transactions for FY 2017 and post to the general ledger. As there are relatively few revenues and expenditures, the use of control accounts is not necessary. (Make entries directly to individual revenue and expenditure accounts). (1) The state government notified the City that $1,065,000 will be available for street and highway maintenance during 2017 (i.e. the City has met eligibility requirements). The funds are not considered reimbursement-type as defined by GASB standards. (2) Cash...
The City of Little River had the following transactions related to the construction of a new...
The City of Little River had the following transactions related to the construction of a new courthouse: January 2, 2017: 20-year, 6%, general-obligation serial bonds with a face value of $2,000,000 are issued at 101. Interest payments are made on January 1 and July 1 of each year. The premium was transferred into the debt-service fund. The general fund will fully fund each payment as it becomes due. March 1, 2017: Land is purchased for a new park at a...