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 $67,000
Accounts receivable 45,000
Raw materials inventory 27,500
Work in process inventory 0
Finished goods inventory 6,000
Prepaid rent 2,000
Accounts payable $11,500
Notes payable 14,500
Common stock 20,000
Retained earnings 91,000
Sales 184,500
Cost of goods sold 102,000
Factory overhead 27,000
Operating expenses 45,000
Totals $321,500 $321,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,700 direct materials to Job 402
Materials requisition 21-3011: $7,200 direct materials to Job 404
Materials requisition 21-3012: $2,100 indirect materials
Labor time ticket 6052: $5,000 direct labor to Job 402
Labor time ticket 6053: $8,000 direct labor to Job 404
Labor time ticket 6054: $3,000 indirect labor


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

Part 1

1. Record direct materials cost for Jobs 402 and 404

2. Record Direct labor costs for Jobs 402 and 404

3. Record the entry to allocate overheads to Jobs 402 and 404 at 150% of direct labor costs aligned

4. Record entry to assign cost of indirect materials

5. Record entry to assign cost of indirect labor

Part 2

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.

Part 3

Prepare a revised trial balance

BERGAMO BAY COMPANY
Trial Balance
December 31, 2017
Debit Credit
Cash
Accounts receivable
Raw materials inventory
Work in process inventory
Finished goods inventory
Prepaid rent
Accounts payable
Factory wages payable
Notes payable
Common stock
Retained earnings
Sales
Cost of goods sold
Factory overhead
Operating expenses
Totals $0 $0

Part 4

Prepare an income statement for 2017 and a balance sheet as of December 31, 2017.

Solutions

Expert Solution

1.

No. Account Titles and Explanation Debit Credit
1 Work in process inventory ($4700 + $7200) 11900
Raw materials inventory 11900
(Direct materials costs assigned to work in process)
2 Work in process inventory ($5000 + $8000) 13000
Factory payroll payable 13000
(Direct labor costs assigned to work in process)
3 Work in process inventory (150% x $13000) 19500
Factory overhead 19500
(Overhead costs assigned to work in process)
4 Factory overhead 2100
Raw materials inventory 2100
(Indirect materials cost assigned to factory overhead)
5 Factory overhead 3000
Factory payroll payable 3000
(Indirect labor costs assigned to factory overhead)

2.

Factory Overhead
Ending balance from trial balance 27000
Indirect materials 2100 19500 Overhead applied
Indirect labor 3000
Underapplied overhead 12600

3.

BERGAMO BAY COMPANY
Trial Balance
December 31, 2017
Debit Credit
Cash 67000
Accounts receivable 45000
Raw materials inventory 13500
Work in process inventory 44400
Finished goods inventory 6000
Prepaid rent 2000
Accounts payable 11500
Factory payroll payable 16000
Notes payable 14500
Common stock 20000
Retained earnings 91000
Sales 184500
Cost of goods sold 102000
Factory overhead 12600
Operating expenses 45000
Totals 337500 337500

4.

BERGAMO BAY COMPANY
Income Statement
For Year Ended December 31, 2017
Sales 184500
Cost of goods sold ($102000 + $12600) 114600
Gross profit 69900
Operating expenses 45000
Net income 24900
BERGAMO BAY COMPANY
Balance Sheet
December 31, 2017
Assets
Cash 67000
Accounts receivable 45000
Inventories:
Raw materials inventory 13500
Work in process inventory 44400
Finished goods inventory 6000 63900
Prepaid rent 2000
Total assets 177900
Liabilities and equity
Notes payable 14500
Accounts payable 11500
Factory payroll payable 16000
Total liabilities 42000
Common stock 20000
Retained earnings 115900
Total stockholders' equity 135900
Total liabilities and equity 177900

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 $ 59,000 Accounts receivable 39,000 Raw materials inventory 24,500 Work in process inventory 0 Finished goods inventory 15,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 $ 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