Question

Requirement 2 Change all of the numbers in the data area of your worksheet so that it looks like this 3 Data 4 Beginning work in process inventory: 5 Units in process 6 Completion with respect to materials 7 Completion with respect to conversion 8 Costs in the beginning work in process inventory: 9 10 Conversion cost 11 Units started into production during the period 12 Costs added to production during the period 13 Materials cost 14 Conversion cost 15 Ending work in process inventory: 16 Units in process 17 Completion with respect to materials 18 Completion with respect to conversion 800 85 % 60% Materials cost S31,078 S34,840 17,600 $798,842 $1,549,940 500 60% 80 % 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 17,720 (b) What is the equivalent units of production for conversion? Equivalent units of production for conversion $18,020

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Solution Calculation as per weighted average method
1 Summary of Physical Units and Equivalent Unit calculation
Units to account for
Beginning Inventory                          800
Units started during the period                     17,600
Total units to account for                     18,400 (800+17,600)
Total units accounted for
Units completed and transferred out during May                     17,900 (18,400-500)
Ending-Work in process (In units)                          500
Total units accounted for                     18,400
2 Equivalent units of production-Weighted average method
(unit*% Material) (unit*% Conversion)
Units % Material EUP-Material % Conversion EUP-Conversion
Units completed and transferred out                     17,900 100%                     17,900 100%                     17,900
Ending-Work in process (In units)                          500 60%                          300 80% $                      400
Equivalent Units of conversion                     18,200                     18,300
3 Cost per Unit Material Conversion Total
Cost of beginning work in progress $                 31,078 $                 34,840 $                 65,918
Cost incurred during the current period $              7,98,842 $           15,49,940 $           23,48,782
Total Cost Cost $              8,29,920 Cost $           15,84,780 $           24,14,700
Equivalent Units of production EUP                     18,200 EUP                     18,300
Cost per Unit (Cost/EUP) $                   45.60 (Cost/EUP) $                   86.60
4 Cost assignment and reconciliation aa bb aa*bb
EUP Cost per EUP Total Cost
Cost transferred out
Direct material                     17,900 $                 45.600 $              8,16,240 (17900*45.60)
Conversion Cost                     17,900 $                 86.600 $           15,50,140 (17,900*86.60)
The total cost of units transferred out $           23,66,380
Answer:
a. Equivalent units of production for material                     18,200 Units
b. Equivalent units of production for conversion                     18,300 Units
c. Cost per equivalent unit for material $                   45.60
d. Cost per equivalent unit for conversion $                   86.60
e. Cost of units transferred out $           23,66,380
Add a comment
Know the answer?
Add Answer to:
Requirement 2 Change all of the numbers in the data area of your worksheet so that...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Requirement 2: Change all of the numbers in the data area of your worksheet so that...

    Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: B U 2 العا 4 es 300 35 % 50 % А 1 Chapter 5: Applying Excel 2 Data 4 Beginning work in process inventory: 5 Units in process 6 Completion with respect to materials 7 Completion with respect to conversion 8 Costs in the beginning work in process inventory: 9 Materials cost 10 Conversion cost 11 Units started into...

  • Requirement 3 Either print a copy of your worksheet or make a copy of the worksheet...

    Requirement 3 Either print a copy of your worksheet or make a copy of the worksheet in your workbook before proceeding You will need to refer back to this worksheet. Change the percentage completion with respect to conversion for the beginning inventory from 50% to 30%, but keep everything the same as in Requirement 2, The data area of your worksheet should now look like this 3 Data 4 Beginning work in process inventory: 5 Units in process 6 Completion...

  • Return to questio Requirement 2: Change all of the numbers in the data area of your...

    Return to questio Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: B В с A Chapter 4: Applying Excel 1 2 2 3 Data 300 60 % 30 % 00 $ 7.994 $ 4 Beginning work in process inventory: 5 Units in process 6 Completion with respect to materials 7 Completion with respect to conversion Costs in the beginning work in process inventory: 9 Materials cost 10 Conversion...

  • 5 GRADED 0 Saved Requirement 2: Change all of the numbers in the data area of...

    5 GRADED 0 Saved Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: 1 Chapter 5: Applying Excel eBook Print 5 eferences 300 65 $ 3 Data 4 Beginning work in process inventory: Units in process Completion with respect to materials Completion with respect to conversion Costs in the beginning work in process inventory: Materials cost Conversion cost 11 Units started into production during the period 12 Costs added...

  • very confused :-) 1 Required information The Chapter 5 Form worksheet is to be used to...

    very confused :-) 1 Required information The Chapter 5 Form worksheet is to be used to create your own worksheet version of Exhibit 5-5 and Exhibit 5-8 in the text. pped Book Print erences Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B34 enter the formula "B9". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the...

  • Download the Applying Excel form and enter formulas in all cells that contain question marks. For...

    Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B34 enter the formula "= B9". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the beginning work in process inventory to 300 units, the units started into production during the period to 18,200 units, and the units in ending work in...

  • Given the following data, answer the questions below the table: -------------------------------------------------------------------------------------------------------------------------------- Data Beginning work in process...

    Given the following data, answer the questions below the table: -------------------------------------------------------------------------------------------------------------------------------- Data Beginning work in process inventory: Units in process 100 Completion with respect to materials 75% Completion with respect to conversion 30% Costs in the beginning work in process inventory: Materials cost $1,877 Conversion cost $1,912 Units started into production during the period 14,900 Costs added to production during the period: Materials cost $361,213 Conversion cost $918,035 Ending work in process inventory: Units in process 300 Completion with respect...

  • Chapter 4: Applying Excel Data Beginning work in process inventory: Units in process 200 Completion with...

    Chapter 4: Applying Excel Data Beginning work in process inventory: Units in process 200 Completion with respect to materials 100% Completion with respect to conversion 40% Costs in the beginning work in process inventory: Materials cost $2,000 Conversion cost $800 Units started into production during the period 1,800 Costs added to production during the period: Materials cost $18,400 Conversion cost $38,765 Ending work in process inventory: Units in process 100 Completion with respect to materials 100% Completion with respect to...

  • Paste В І ov Merge & Center $ % 98 -28 Conditional Format Cell Formatting as...

    Paste В І ov Merge & Center $ % 98 -28 Conditional Format Cell Formatting as Table Styles Insert Delete Format C1 . B C 1 Chapter 4: Applying Excel Name: 2 3 Data 4 Beginning work in process inventory: 5 Units in process 200 6 Completion with respect to materials 55% 7 Completion with respect to conversion 30% 8 Costs in the beginning work in process inventory: 9 Materials cost $9,600 10 Conversion cost $5,575 11 Units started into...

  • Bachelet Inc. uses the weighted-average method in its process costing system. The following data concern the...

    Bachelet 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 Stage of completion with respect to materials Stage of completion with respect to conversion Costs in the beginning inventory: 400 90% 40% Materials cost Conversion Cost $756 $4,448 Units started into production during the month Units completed and transferred out 13,000 13,300 Costs added to production...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT