Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in .numbers format will receive a 0. MFG Student Name => Section Number => Data Section: Depreciation-equipment $45,000 Direct labor 642,000 Direct materials inventory, 1/1 Direct materials inventory, 12/31 Factory rent Finished goods, 1/1 Finished goods, 12/31 91,500 93,000 76,410 132,000 172,500 Indirect labor 37,500 26,250 645,180 30,300 28,665 Indirect materials Purchases of direct materials Work in process, 1/1 Work in process, 12/31 Answer Section: Jackson Manufacturing Schedule of Cost of Goods Manufactured and Sold For the Year Ended December 31 Work in process, 1/1 30,300 Direct materials Direct materials inventory, 1/1 91,500 Add: Purchases of Materials 172500 Cost of direct materials available $264,000 Less: Direct Material, 12/31 -91500 Cost of direct materials used ($81,000) 642.000 Direct labor Manufacturing overhead: Factory rent Depreciation - Equipment $76,410 45,000 37,500 26,250 Indirect Labor Indirect Material 185,160 Total manufacturing costs incurred Formula Total manufacturing costs $0 Less: Work in Process, 12/31 Formula Cost of goods manufactured Finished Goods, 1/1 Formula Formula Cost of goods available for sale Finished goods, 12/31 FORMULA11 Less: 172,500 Cost of Goods Sold FORMULA12 ===========
Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in .numbers format will receive a 0. MFG Student Name => Section Number => Data Section: Depreciation-equipment $45,000 Direct labor 642,000 Direct materials inventory, 1/1 Direct materials inventory, 12/31 Factory rent Finished goods, 1/1 Finished goods, 12/31 91,500 93,000 76,410 132,000 172,500 Indirect labor 37,500 26,250 645,180 30,300 28,665 Indirect materials Purchases of direct materials Work in process, 1/1 Work in process, 12/31 Answer Section: Jackson Manufacturing Schedule of Cost of Goods Manufactured and Sold For the Year Ended December 31 Work in process, 1/1 30,300 Direct materials Direct materials inventory, 1/1 91,500 Add: Purchases of Materials 172500 Cost of direct materials available $264,000 Less: Direct Material, 12/31 -91500 Cost of direct materials used ($81,000) 642.000 Direct labor Manufacturing overhead: Factory rent Depreciation - Equipment $76,410 45,000 37,500 26,250 Indirect Labor Indirect Material 185,160 Total manufacturing costs incurred Formula Total manufacturing costs $0 Less: Work in Process, 12/31 Formula Cost of goods manufactured Finished Goods, 1/1 Formula Formula Cost of goods available for sale Finished goods, 12/31 FORMULA11 Less: 172,500 Cost of Goods Sold FORMULA12 ===========
Chapter3: Setting Up A New Company
Section: Chapter Questions
Problem 3.4C
Related questions
Question
How do i solve this using the Excel formulas????
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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