Question

In: Accounting

Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager...

Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Work in Process Inventory but does show a balance for the Factory Overhead account. In addition, the accrued factory payroll (Factory Payroll Payable) has not been recorded.

Debit Credit
Cash $ 59,000
Accounts receivable 39,000
Raw materials inventory 24,500
Work in process inventory 0
Finished goods inventory 15,000
Prepaid rent 5,000
Accounts payable $ 8,600
Notes payable 11,600
Common stock 50,000
Retained earnings 94,000
Sales 161,300
Cost of goods sold 110,000
Factory overhead 25,000
Operating expenses 48,000
Totals $ 325,500 $ 325,500


After examining various files, the manager identifies the following six source documents that need to be processed to bring the accounting records up to date.

Materials requisition 21-3010: $ 4,800 direct materials to Job 402
Materials requisition 21-3011: $ 7,700 direct materials to Job 404
Materials requisition 21-3012: $ 2,500 indirect materials
Labor time ticket 6052: $ 8,000 direct labor to Job 402
Labor time ticket 6053: $ 5,000 direct labor to Job 404
Labor time ticket 6054: $ 1,000 indirect labor


Jobs 402 and 404 are the only units in process at year-end. The predetermined overhead rate is 100% of direct labor cost.

1) Determine the revised balance of the Factory Overhead account after making the entries in part 1 using T-accounts. Determine whether there is any under- or overapplied overhead for the year.
2)Prepare the adjusting entry to allocate any over- or underapplied overhead to Cost of Goods Sold, assuming the amount is not material.

3)Prepare a revised trial balance.
4)Prepare an income statement for 2017 and a balance sheet as of December 31, 2017.

Solutions

Expert Solution

1. Revised balance of Factory Overhead: $15500

Factory Overhead
Bal. 25000
Indirect materials 2500 13000 Overhead applied
Indirect labor 1000
End. Bal. 15500

2.

Account Titles and Explanation Debit Credit
Cost of goods sold 15500
Factory overhead 15500
(To close underapplied overheads to cost of goods sold)

3.

BERGAMO BAY COMPANY
Trial Balance
December 31, 2017
Debit Credit
Cash 59000
Accounts receivable 39000
Raw materials inventory 9500
Work in process inventory 38500
Finished goods inventory 15000
Prepaid rent 5000
Accounts payable 8600
Factory wages payable 14000
Notes payable 11600
Common stock 50000
Retained earnings 94000
Sales 161300
Cost of goods sold 125500
Factory overhead 0
Operating expenses 48000
Totals 339500 339500

4.

BERGAMO BAY COMPANY
Income Statement
For Year Ended December 31, 2017
Sales 161300
Cost of goods sold 125500
Gross profit 35800
Operating expenses 48000
Net income -12200
BERGAMO BAY COMPANY
Balance Sheet
December 31, 2017
Assets
Cash 59000
Accounts receivable 39000
Inventories
Raw materials inventory 9500
Work in process inventory 38500
Finished goods inventory 15000 63000
Prepaid rent 5000
Total assets 166000
Liabilities and equity
Notes payable 11600
Accounts payable 8600
Factory wages payable 14000
Total liabilities 34200
Common stock 50000
Retained earnings 81800
Total stockholders' equity 131800
Total liabilities and equity 166000

Workings:

Raw materials = $24500 - $4800 - $7700 - $2500 = $9500

Work in process inventory:
Direct materials ($4800 + $7700) 12500
Direct labor ($8000 + $5000) 13000
Factory overheads applied (100% x $13000) 13000
Work in process inventory 38500

Factory wages payable = $8000 + $5000 + $1000 = $14000

Factory overhead = $25000 + $2500 + $1000 - $13000 = $15500

Cost of goods sold = $110000 + $15500 = $125500


Related Solutions

Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager...
Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Work in Process Inventory but does show a balance for the Factory Overhead account. In addition, the accrued factory payroll (Factory Payroll Payable) has not been recorded. Debit Credit Cash $ 61,000 Accounts receivable 40,000 Raw materials inventory 25,000 Work in process inventory 0 Finished goods inventory 12,000...
Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager...
Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Work in Process Inventory but does show a balance for the Factory Overhead account. In addition, the accrued factory payroll (Factory Payroll Payable) has not been recorded. Debit Credit Cash $ 62,000 Accounts receivable 36,000 Raw materials inventory 23,000 Work in process inventory 0 Finished goods inventory 12,000...
Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager...
Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Work in Process Inventory but does show a balance for the Factory Overhead account. In addition, the accrued factory payroll (Factory Payroll Payable) has not been recorded. Debit Credit Cash $67,000 Accounts receivable 45,000 Raw materials inventory 27,500 Work in process inventory 0 Finished goods inventory 6,000 Prepaid...
Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager...
Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Work in Process Inventory but does show a balance for the Factory Overhead account. In addition, the accrued factory payroll (Factory Payroll Payable) has not been recorded. Debit Credit Cash $ 56,000 Accounts receivable 35,000 Raw materials inventory 22,500 Work in process inventory 0 Finished goods inventory 9,000...
Bergamo Bay's computer system generated the following trial balance on December 31, 2019. The company’s manager...
Bergamo Bay's computer system generated the following trial balance on December 31, 2019. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Work in Process Inventory but does show a balance for the Factory Overhead account. In addition, the accrued factory payroll (Factory Wages Payable) has not been recorded. Debit Credit Cash $ 80,000 Accounts receivable 49,000 Raw materials inventory 29,500 Work in process inventory 0 Finished goods inventory 15,000...
Bergamo Bay's computer system generated the following trial balance on December 31, 2019. The company’s manager...
Bergamo Bay's computer system generated the following trial balance on December 31, 2019. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Work in Process Inventory but does show a balance for the Factory Overhead account. In addition, the accrued factory payroll (Factory Wages Payable) has not been recorded. Debit Credit Cash $ 80,000 Accounts receivable 49,000 Raw materials inventory 29,500 Work in process inventory 0 Finished goods inventory 15,000...
   Thai Bay’s computer system generated the following trial balance on December 31, 2011. The company’s...
   Thai Bay’s computer system generated the following trial balance on December 31, 2011. The company’s manager knows something is wrong with the trial balance because it does not show any balance for Goods in Process Inventory but does show balances for the Factory Payroll and Factory Overhead accounts. Debit Credit   Cash $ 48,000   Accounts receivable 42,000   Raw materials inventory 26,000   Goods in process inventory 0   Finished goods inventory 9,000   Prepaid rent 3,000   Accounts payable $ 10,500   Notes payable 13,500...
JC’s Company’s unadjusted and adjusted trial balances at December 31, 2017, follow. Unadjusted trial Balance DR...
JC’s Company’s unadjusted and adjusted trial balances at December 31, 2017, follow. Unadjusted trial Balance DR CR Cash 105,000 Prepaid Rent 60,000 Supplies 38,000 Office furniture 460,000 Accumulated dep office furniture 92,000 Accounts payable 102,500 Salaries payable Unearned service revenue 15,900 SWT, Capital 453,000 SWT, Drawing 15,400 Service revenue 205,000 Salaries expense 110,000 Depreciation expense Supplies Expense Rent Expense 80,000 868,400 868,400 Adjusted Trial Balance DR CR Cash 105,000 Prepaid Rent 20,000 Supplies 19,500 Office furniture 460,000 Accumulated dep office...
The unadjusted trial balance for Forever Fitness as December 31, 2017 is provided on the trial...
The unadjusted trial balance for Forever Fitness as December 31, 2017 is provided on the trial balance tab. Information for adjustments is as follows: As of December 31, 2017, employees had earned $1,300 of unpaid and unrecorded salaries. The next payday is January 4, at which time $1,625 of salaries will be paid. The cost of supplies still available at December 31, 2017, is $1,700. The notes payable requires an interest payment to be made every three months. The amount...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the closing entries were posted: Account Title Cash $ 140,000 Accounts receivable 131,000 Allowance for doubtful accounts $ 21,000 Inventory 437,000 Accounts payable 101,000 Common stock 480,000 Retained earnings 106,000 Tile, Etc. had the following transactions in 2018: Purchased merchandise on account for $610,000. Sold merchandise that cost $450,000 for $950,000 on account. Sold for $275,000 cash merchandise that had cost $172,000. Sold merchandise for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT