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 A 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.
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 A 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.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![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
A
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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F97c709ea-16a7-4473-934e-85795c693e7d%2Fab24d885-0990-4dec-ba8c-88a99300c447%2Fhok2zzd_processed.png&w=3840&q=75)
Transcribed Image Text: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
A
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.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education