1:57 VOD 438% 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. Beginning WIP units B 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 438% 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. Beginning WIP units B 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...

See similar textbooks