Change all of the numbers in the data area of your worksheet so that it looks...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/04/642bb57907c75_104642bb578e3f86.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/04/642bb57a7d6d4_105642bb579cffd3.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/04/642bb57b6ff2b_107642bb57b56f74.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/04/642bb57c682ab_108642bb57c4ea32.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/04/642bb57d480c0_109642bb57d3074e.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/04/642bb57e25e30_110642bb57e113ed.jpg)
Transcribed Image Text:
Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 5: Applying Excel 2 3 Data 4 5 6 7 8 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 Ending work in process inventory: Units in process G Beginning work in process inventory: Units in process 15 16 17 18 Completion with respect to materials Completion with respect to conversion Costs in the beginning work in process inventory: Materials cost Completion with respect to materials Completion with respect to conversion $ $ B 500 70 % 40 % 16,380 12,998 17,200 $ 802,848 $ 1,127,838 200 C 40 % 80 % (e) What is the cost of the units transferred out? Answer is complete but not entirely correct. $ 1,912,640 X Cost of units transferred out Change the percentage completion with respect to conversion for the beginning inventory from 40% to 20%, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: 1 2 3 Data 4 5 6 7 8 9 10 11 A Chapter 5: Applying Excel 12 13 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 Units started into production during the period Costs added to production during the period: Materials cost Conversion cost 14 15 Ending work in process inventory Prev $ $ B 500 70 % 20 % 16,380 12,998 17,200 $ 802,848 $1,127,838 C 1 of 1 # Noxt Required information 3 Data Beginning work in process inventory: Units in process Completion with respect to materials 7 Completion with res to conversion 8 Costs in the beginning work in process inventory: Materials cost 9 10 Conversion cost 11 Units started into production during the period Costs added to production during the period: 12 13 Materials cost 14 Conversion cost 15 Ending work in process inventory: Units in process Completion with respect to materials Completion with respect to conversion 4 5 6 567 18 $ 500 70 % 20 % 16,380 12,998 17,200 $ 802,848 $1,127,838 200 40 % 80 % If your formulas are correct, you should get the correct answers to the following question= (a) What is the equivalent units of production for materials? O Answer is complete but not entirely correct. Equivalent units of production for materials 17,540 (c) What is the cost per equivalent unit for materials? (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. 46.71 X Cost per equivalent unit for materials $ (e) What is the cost of the units transferred out? Answer is complete but not entirely correct. $ 1,947,925 X Cost of units transferred out Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 5: Applying Excel 2 3 Data 4 5 6 7 8 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 Ending work in process inventory: Units in process G Beginning work in process inventory: Units in process 15 16 17 18 Completion with respect to materials Completion with respect to conversion Costs in the beginning work in process inventory: Materials cost Completion with respect to materials Completion with respect to conversion $ $ B 500 70 % 40 % 16,380 12,998 17,200 $ 802,848 $ 1,127,838 200 C 40 % 80 % (e) What is the cost of the units transferred out? Answer is complete but not entirely correct. $ 1,912,640 X Cost of units transferred out Change the percentage completion with respect to conversion for the beginning inventory from 40% to 20%, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: 1 2 3 Data 4 5 6 7 8 9 10 11 A Chapter 5: Applying Excel 12 13 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 Units started into production during the period Costs added to production during the period: Materials cost Conversion cost 14 15 Ending work in process inventory Prev $ $ B 500 70 % 20 % 16,380 12,998 17,200 $ 802,848 $1,127,838 C 1 of 1 # Noxt Required information 3 Data Beginning work in process inventory: Units in process Completion with respect to materials 7 Completion with res to conversion 8 Costs in the beginning work in process inventory: Materials cost 9 10 Conversion cost 11 Units started into production during the period Costs added to production during the period: 12 13 Materials cost 14 Conversion cost 15 Ending work in process inventory: Units in process Completion with respect to materials Completion with respect to conversion 4 5 6 567 18 $ 500 70 % 20 % 16,380 12,998 17,200 $ 802,848 $1,127,838 200 40 % 80 % If your formulas are correct, you should get the correct answers to the following question= (a) What is the equivalent units of production for materials? O Answer is complete but not entirely correct. Equivalent units of production for materials 17,540 (c) What is the cost per equivalent unit for materials? (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. 46.71 X Cost per equivalent unit for materials $ (e) What is the cost of the units transferred out? Answer is complete but not entirely correct. $ 1,947,925 X Cost of units transferred out
Expert Answer:
Answer rating: 100% (QA)
Beginning work in process inventory Units in process 500 Completion with respect to materials 70 Com... View the full answer
Related Book For
Introduction To Managerial Accounting
ISBN: 9781265672003
9th Edition
Authors: Peter Brewer, Ray Garrison, Eric Noreen
Posted Date:
Students also viewed these accounting questions
-
This exercise relates to the Double Diamond Skis Shaping and Milling Department that was discussed earlier in the chapter. The Excel worksheet form that appears below consolidates data from Exhibits...
-
This exercise relates to the Double Diamond Skis' Shaping and Milling Department that was discussed earlier in the chapter. The Excel worksheet form that appears below consolidates data from Exhibits...
-
2. Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit Manufacturing costs: 5 6 7 8 Variable per...
-
What are the advantages and disadvantages of decentralization? Would you prefer to work in a centralized or decentralized organization and why? What are opportunity costs and what are the economic...
-
A solution contains 0.0500 M Ca2+ and 0.030 0 M Ag+. Can 99% of Ca2+ be precipitated by sulfate without precipitating Ag+? What will be the concentration of Ca2+ when Ag2SO4 begins to precipitate?
-
4 Accounts Receivable by Age Over 90 days past due 1 61-90 days past due 31-60 days past due 1-30 days past due Not yet due $0 $200,000 $400,000 $600,000 $800,000 Accounts Receivable (s) Percent...
-
Which sociocultural factors have informed McDonalds global expansion? MCDONALDSA GLOBAL GIANT From the Maharaja Mac in India to the Prosperity Burger prepared especially for Chinese New Year...
-
In most large corporations, ownership and management are separated. What are the main implications of this separation?
-
Exercise 2-8 Preparing T-accounts (ledger) and a trial balance LO P2 Following are the transactions of a new company called Pose-for-Pics Aug. 1 Madison Harris, the owner, invested $7,400 cash and...
-
5 5 7 B 9 Problem Ithacor Training Inc. started as a single facility for job retraining in Ithaca, New York. The company recently expanded to a new, much larger, second facility in Cortland. The...
-
Please help me to choose the correct answer . I have 10 min to answer A. RIVIJU, UV B. RM39,400 RM168,400 X RM180,000 1.6 The provision for doubtful debts is an example of which accounting concept?...
-
A new partner C is invited to join in the AB partnership. Currently, A's and B's capital are $540,000 and $100,000, respectively. According to their profit and loss sharing contract, partner A and B...
-
The two tanks shown are connect through a mercury manometer. What is the relation between ???? and ? water Az water Ah
-
1. After reading about the types of rights that prisoners have while incarcerated, which of these rights, if any, should be reduced or diminished? Why? 2. In the same way, what rights do you believe...
-
According to the Socratic view of morality summarized by Frankena, is a person brought up by immoral parents in a corrupt society capable of making correct moral judgements? Why or why not? Do you...
-
Loma Company manufactures basketball backboards. The following information pertains to the company's normal operations per month: Output units15,000 boards Machine-hours4,000 hours Direct...
-
At the beginning of last year, Tarind Corporation budgeted $1,200,000 of fixed manufacturing overhead and chose a denominator level of activity of 600,000 machine-hours. At the end of the year,...
-
Choose a company from the SEC EDGAR Web site for your Key Assignment to evaluate for the impact of convergence to IFRS. Review the financial reports and notes of the company you have chosen from the...
-
Jaffre Enterprises distributes a single product whose selling price is $16 per unit and whose variable expense is $11 per unit. The companys fixed expense is $16,000 per month. Required: 1. Prepare a...
-
How do you compute the cost of goods manufactured?
-
Variable costs and differential costs mean the same thing. Do you agree? Explain.
-
What changes, if any, would you recommend, and why?
-
2. Identify one or more of Unilevers strengths, weaknesses, opportunities, and threats.
-
1. For Samsungs management, is adding a solar and wind power unit a strategic management issue? Explain.
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App