Applying Integrated Excel: Manufacturing cost flows The T-accounts below summarize a manufacturer's production activity for the year: Factory Wages Payable Debit Credit 149,000 Raw Materials Inventory Debit Credit 52,500 Factory Overhead 12,800 53,000 72,600 Debit 32,000 12,800 Credit Required: Compute the following: 134,400 96,000 53,000 Finished Goods Inventory Credit Debit 210,000 168,000 Work in Process Inventory Debit Credit • Direct materials used • Indirect materials used • Direct labor used • Indirect labor used • Cost of goods manufactured • Cost of goods sold (before closing over-or underapplied overhead) • Actual overhead incurred • Overhead applied • The amount of over-or underapplied overhead • Indicate whether overhead is over- or underapplied. • Cost of goods sold (after closing over-or underapplied overhead) Navigation: 1. Use the Open Excel in New Tab button to launch this question. 32,000 96,000 134,400 210,000

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

26.

Applying Integrated Excel: Manufacturing cost flows
The T-accounts below summarize a manufacturer's production activity for the year:
Factory Wages Payable
Debit
Credit
149,000
Raw Materials Inventory
Debit
Credit
52,500
Factory Overhead
12,800
53,000
72,600
Debit
32,000
12,800
Credit
134,
Required:
Compute the following:
, 400
96,000
53,000
Finished Goods Inventory
Debit
Credit
210,000
168,000
Work in Process Inventory
Debit
Credit
• Direct materials used
● Indirect materials used
● Direct labor used
● Indirect labor used
● Cost of goods manufactured
● Cost of goods sold (before closing over-or underapplied overhead)
• Actual overhead incurred
• Overhead applied
32,000
96,000
134,400
210,000
• The amount of over-or underapplied overhead
• Indicate whether overhead is over- or underapplied.
●
Cost of goods sold (after closing over-or underapplied overhead)
Navigation:
1. Use the Open Excel in New Tab button to launch this question.
2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.
Transcribed Image Text:Applying Integrated Excel: Manufacturing cost flows The T-accounts below summarize a manufacturer's production activity for the year: Factory Wages Payable Debit Credit 149,000 Raw Materials Inventory Debit Credit 52,500 Factory Overhead 12,800 53,000 72,600 Debit 32,000 12,800 Credit 134, Required: Compute the following: , 400 96,000 53,000 Finished Goods Inventory Debit Credit 210,000 168,000 Work in Process Inventory Debit Credit • Direct materials used ● Indirect materials used ● Direct labor used ● Indirect labor used ● Cost of goods manufactured ● Cost of goods sold (before closing over-or underapplied overhead) • Actual overhead incurred • Overhead applied 32,000 96,000 134,400 210,000 • The amount of over-or underapplied overhead • Indicate whether overhead is over- or underapplied. ● Cost of goods sold (after closing over-or underapplied overhead) Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Risk Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education