1:57 VOD .. 4 38% Using Excel, solve the following questions. You should have interactive cells; chaning the inputs will be reflected on the output Q1. To produce a product, it should visit two departments A and B. During January, the beginning work in process in Department A was 60% (conversion and direct material cost) The beginning inventory included $12,000 for materials and $3,000 for conversion costs. As for the ending WIP in Department A was 45% complete. To finalize the product, direct materials are added at the beginning of the process. Beginning WIP in Department B was 85% complete ( conversion cost), while Direct materials are added at the end of the process. Beginning inventories included $26,000 for transferred-in costs and $25,000 for conversion costs. Ending Inventory was 35% complete. More information about the two departments is shown below. \table[[A,B], [Beginning WIP units,20,000,20,000], [Units started in January,40,000,50, 000],[Units transferred in January, 50,000,],[Ending work-in-process units, 15,000,20,000],[Material costs added,$48,000 $28,000 Using Excel, solve the following questions. You should have interactive cells; chaning the inputs will be reflected on the output Q1. To produce a product, it should visit two departments A and B. During January, the beginning work in process in Department A was 60% (conversion and direct material cost) The beginning inventory included $12,000 for materials and $3,000 for conversion costs. As for the ending WIP in Department A was 45% complete. To finalize the product, direct materials are added at the beginning of the process. Beginning WIP in Department B was 85% complete (conversion cost), while Direct materials are added at the end of the process. Beginning inventories included $26,000 for transferred-in costs and $25,000 for conversion costs. Ending inventory was 35% complete. More information about the two departments is shown below. B Beginning WIP units 20,000 20,000 Units started in January 40,000 50,000 Units transferred in January 50,000 Ending work-in-process units 15,000 20,000 Material costs added $48,000 $28,000 Direct manufacturing labor $26,000 $40,000 Conversion costs $ 18,000 $34,000 a) Prepare a production cost worksheet using the FIFO process costing for department B. (5 points)
1:57 VOD .. 4 38% Using Excel, solve the following questions. You should have interactive cells; chaning the inputs will be reflected on the output Q1. To produce a product, it should visit two departments A and B. During January, the beginning work in process in Department A was 60% (conversion and direct material cost) The beginning inventory included $12,000 for materials and $3,000 for conversion costs. As for the ending WIP in Department A was 45% complete. To finalize the product, direct materials are added at the beginning of the process. Beginning WIP in Department B was 85% complete ( conversion cost), while Direct materials are added at the end of the process. Beginning inventories included $26,000 for transferred-in costs and $25,000 for conversion costs. Ending Inventory was 35% complete. More information about the two departments is shown below. \table[[A,B], [Beginning WIP units,20,000,20,000], [Units started in January,40,000,50, 000],[Units transferred in January, 50,000,],[Ending work-in-process units, 15,000,20,000],[Material costs added,$48,000 $28,000 Using Excel, solve the following questions. You should have interactive cells; chaning the inputs will be reflected on the output Q1. To produce a product, it should visit two departments A and B. During January, the beginning work in process in Department A was 60% (conversion and direct material cost) The beginning inventory included $12,000 for materials and $3,000 for conversion costs. As for the ending WIP in Department A was 45% complete. To finalize the product, direct materials are added at the beginning of the process. Beginning WIP in Department B was 85% complete (conversion cost), while Direct materials are added at the end of the process. Beginning inventories included $26,000 for transferred-in costs and $25,000 for conversion costs. Ending inventory was 35% complete. More information about the two departments is shown below. B Beginning WIP units 20,000 20,000 Units started in January 40,000 50,000 Units transferred in January 50,000 Ending work-in-process units 15,000 20,000 Material costs added $48,000 $28,000 Direct manufacturing labor $26,000 $40,000 Conversion costs $ 18,000 $34,000 a) Prepare a production cost worksheet using the FIFO process costing for department B. (5 points)
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter12: Activity-based Management
Section: Chapter Questions
Problem 2CE: Assume that at the beginning of 20x2, Cicleta trained the 2 assembly workers in a new approach that...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning