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)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Accounting Subject
![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)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F00219058-b77c-4bbb-8f84-e202fc2fa4ea%2F850b71d7-fe9f-4a2f-bdbb-3acdcba03502%2Fgwmwaci_processed.jpeg&w=3840&q=75)
Transcribed Image Text: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)
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
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education