Question

The chapter 4 form worksheet is to be used to create your own worksheet version of...

The chapter 4 form worksheet is to be used to create your own worksheet version of exhibit 4-5 and exhibit 4-8 in the text.

Change all of the numbers in the data area of your worksheet so that it looks like this:

A B

1.Chapter 4: Applying Excel

2.

3. Data

4. Beginning work in process inventory   

5. Units in process 600

6. Completion with respect to materials 90%

7. Completion with respect to conversion 45%

8. Costs in the beginning work in process inventory

9. Materials cost $15, 622

If your formulas are correct, you should get the correct answers to the following questions.

(a) What is the equivalent units of production for materials?

Equivalent units of production for materials __________

(b) What is the equivalent units of production for conversion?

Equivalent units of production for conversion_____________

(c) What is the cost per equivalent unit for materials?

Cost per equivalent unit for materials___________________

The chapter 4 form worksheet is to be used to create your own worksheet version of exhibit 4-5 and exhibit 4-8 in the text.

Change all of the numbers in the data area of your worksheet so that it looks like this:

A B

1.Chapter 4: Applying Excel

2.

3. Data

4. Beginning work in process inventory   

5. Units in process 600

6. Completion with respect to materials 90%

7. Completion with respect to conversion 45%

8. Costs in the beginning work in process inventory

9. Materials cost $15, 622

If your formulas are correct, you should get the correct answers to the following questions.

(a) What is the equivalent units of production for materials?

Equivalent units of production for materials __________

(b) What is the equivalent units of production for conversion?

Equivalent units of production for conversion_____________

(c) What is the cost per equivalent unit for materials?

Cost per equivalent unit for materials___________________

The chapter 4 form worksheet is to be used to create your own worksheet version of exhibit 4-5 and exhibit 4-8 in the text.

Change all of the numbers in the data area of your worksheet so that it looks like this:

A B

1.Chapter 4: Applying Excel

2.

3. Data

4. Beginning work in process inventory   

5. Units in process 600

6. Completion with respect to materials 90%

7. Completion with respect to conversion 45%

8. Costs in the beginning work in process inventory

9. Materials cost $15, 622

If your formulas are correct, you should get the correct answers to the following questions.

(a) What is the equivalent units of production for materials?

Equivalent units of production for materials __________

(b) What is the equivalent units of production for conversion?

Equivalent units of production for conversion_____________

(c) What is the cost per equivalent unit for materials?

Cost per equivalent unit for materials___________________

The chapter 4 form worksheet is to be used to create your own worksheet version of exhibit 4-5 and exhibit 4-8 in the text.

Change all of the numbers in the data area of your worksheet so that it looks like this:

A B

1.Chapter 4: Applying Excel

2.

3. Data

4. Beginning work in process inventory   

5. Units in process 600

6. Completion with respect to materials 90%

7. Completion with respect to conversion 45%

8. Costs in the beginning work in process inventory

9. Materials cost $15, 622

If your formulas are correct, you should get the correct answers to the following questions.

(a) What is the equivalent units of production for materials?

Equivalent units of production for materials __________

(b) What is the equivalent units of production for conversion?

Equivalent units of production for conversion_____________

(c) What is the cost per equivalent unit for materials?

Cost per equivalent unit for materials___________________

The chapter 4 form worksheet is to be used to create your own worksheet version of exhibit 4-5 and exhibit 4-8 in the text.

Change all of the numbers in the data area of your worksheet so that it looks like this:

A B

1.Chapter 4: Applying Excel

2.

3. Data

4. Beginning work in process inventory   

5. Units in process 600

6. Completion with respect to materials 90%

7. Completion with respect to conversion 45%

8. Costs in the beginning work in process inventory

9. Materials cost $15, 622

If your formulas are correct, you should get the correct answers to the following questions.

(a) What is the equivalent units of production for materials?

Equivalent units of production for materials __________

(b) What is the equivalent units of production for conversion?

Equivalent units of production for conversion_____________

(c) What is the cost per equivalent unit for materials?

Cost per equivalent unit for materials___________________

The chapter 4 form worksheet is to be used to create your own worksheet version of exhibit 4-5 and exhibit 4-8 in the text.

Change all of the numbers in the data area of your worksheet so that it looks like this:

A B

1.Chapter 4: Applying Excel

2.

3. Data

4. Beginning work in process inventory   

5. Units in process 600

6. Completion with respect to materials 90%

7. Completion with respect to conversion 45%

8. Costs in the beginning work in process inventory

9. Materials cost $15, 622

If your formulas are correct, you should get the correct answers to the following questions.

(a) What is the equivalent units of production for materials?

Equivalent units of production for materials __________

(b) What is the equivalent units of production for conversion?

Equivalent units of production for conversion_____________

(c) What is the cost per equivalent unit for materials?

Cost per equivalent unit for materials___________________

Homework Answers

Answer #1

(a)

Equivalent units of production for materials : 540 units

Equivalent units of production for materials = units in process * % of completion with respect to materials

Equivalent units of production for materials = 600 * 90%

Equivalent units of production for materials = 540

(b)

Equivalent units of production for conversion : 270 Units

Equivalent units of production for conversion = Units in process * % of completion with respect to conversion

Equivalent units of production for conversion 600 * 45%

Equivalent units of production for conversion = 270

(c)

Cost per equivalent unit for materials : 28.9296

Cost per equivalent unit for materials = Material costs / Equivalent units for material

Cost per equivalent unit for materials = 15622 / 540

Cost per equivalent unit for materials = 28.9296

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Required information Chapter 8: Applying Excel [LO8-2, LO8-3, LO8-4] The Chapter 8 Form worksheet is to...
Required information Chapter 8: Applying Excel [LO8-2, LO8-3, LO8-4] The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Chapter 8: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula "= B5". Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year...
The AMZ company produces winter growing pots for garden centres. Materials and conversion costs in the...
The AMZ company produces winter growing pots for garden centres. Materials and conversion costs in the XYZ Handling Department are applied at various rates in the manufacturing process. For September 2020, the beginning work in process inventory in the XYZ Handling Department was 3,300 units that were 35% complete with respect to materials and 25% complete with respect to conversion costs. The ending work in process inventory was 6,800 units averaging 40% completion with respect to materials and 20% complete...
Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added...
Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added evenly throughout the process. Direct materials are added at the beginning of the process. During November, the company transferred 755,000 units of product to finished goods. At the end of November, the work in process inventory consists of 199,000 units that are 50% complete with respect to conversion. Beginning inventory had $558,090 of direct materials and $128,175 of conversion cost. The direct material cost...
Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added...
Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added evenly throughout the process. Direct materials are added at the beginning of the process. During November, the company transferred 810,000 units of product to finished goods. At the end of November, the work in process inventory consists of 197,000 units that are 90% complete with respect to conversion. Beginning inventory had $392,730 of direct materials and $123,413 of conversion cost. The direct material cost...
Tannenbaum Corporation uses the weighted average method in its process costing system. This month, the beginning...
Tannenbaum Corporation uses the weighted average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 400 units. The costs and percentage completion of these units in beginning inventory were:                                                             Cost                % complete             Materials costs                        5,700               65%             Conversion costs                     6,800               45% A total of 6,500 units were started and 5,900 units were transferred to the second processing department during the month. The first processing department incurred $125,500 of materials...
Jarvene Corporation uses the FIFO method in its process costing system. The following data are for...
Jarvene Corporation uses the FIFO method in its process costing system. The following data are for the most recent month of operations in one of the company’s processing departments: Units in beginning inventory 410 Units started into production 4,330 Units in ending inventory 330 Units transferred to the next department 4,410 Materials Conversion Percentage completion of beginning inventory 70 % 30 % Percentage completion of ending inventory 90 % 50 % The cost of beginning inventory according to the company’s...
Process costing system. Bakel Inc. uses the weighted-average method in its process costing system. The following...
Process costing system. Bakel Inc. uses the weighted-average method in its process costing system. The following data concern the operations of the company’s first processing department for a recent month. Work in process, beginning: Units in process............300 Stage of completion with respect to materials..........60% Stage of completion with respect to conversion...........60% Cost in the beginning inventory: Materials cost ...........$1,314 Conversion cost ..........$ 6,102 Units started into production during the month ......... 22,000 Units completed and transferred out........21,800 Costs added to...
Required information [The following information applies to the questions displayed below.] Victory Company uses weighted-average process...
Required information [The following information applies to the questions displayed below.] Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added evenly throughout the process. Direct materials are added at the beginning of the process. During November, the company transferred 790,000 units of product to finished goods. At the end of November, the work in process inventory consists of 180,000 units that are 70% complete with respect to conversion. Beginning inventory had $252,200 of...
Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added...
Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added evenly throughout the process. Direct materials are added at the beginning of the first process. During November, the first process transferred 810,000 units of product to the second process. Additional information for the first process follows. At the end of November, work in process inventory consists of 198,000 units that are 60% complete with respect to conversion. Beginning work in process inventory had $458,640...
Problem 4A-74 Dana Inc. uses the FIFO method in its... Dana Inc. uses the FIFO method...
Problem 4A-74 Dana Inc. uses the FIFO method in its... Dana Inc. uses the FIFO method in its process costing system. The following data concern the operations of the company’s first processing department for a recent month.   Work in process beginning:   Units in process 300   Percent complete with respect to materials 40 %   Percent complete with respect to conversion 20 %   Costs in the beginning inventory:   Materials cost $500   Conversion cost $2,090   Units started into production during the month 10,000...