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:
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...
-
Which of the other six D aldohexoses yield optically active aldaric acids on oxidation, and which yield optically inactive (meso) aldaric acids?
-
If you hold a spoon in front of your face so that you see your image in the bowl of the spoon, your image is upright when you hold the spoon close to your face, but inverted when you hold the spoon...
-
Evans \& Sons is converting its sales revenues to corresponding cash amounts using the direct method. Sales revenue on the income statement are \(\$ 1,025,000\). Beginning and ending accounts...
-
Consider the following transactions of Pearl Software: Mar 31 Recorded cash sales of $180,000, plus sales tax of 8% collected for the state of Texas. Apr 6 Sent March sales tax to the state....
-
In the required reading article entitled " SecurityScorecard Exposes Government Security Vulnerabilities Across Federal, State, and Local Levels(listed below) ," the author highlights some key areas...
-
1. Evaluate Theo's new strategy in light of the company's strengths, weaknesses, opportunities, and threats. 2. Using the BCG matrix, explain Theo's decision to offer a classic line of chocolate bars...
-
Toss a coin repeatedly. Assume the probability of a head or tail is 1/2. Let X;= = 1 if the j-th toss is a head and X; = -1 if the j-th toss is a tail. Consider the stochastic process Mo, M, M,......
-
If \(A x^{2}+C y^{2}+D x+E y+F=0\), for Problems 9-13, then list conditions on the constants to assure that the indicated graph results. an ellipse \(A\) and Chave the same signs
-
In Griffin v. California (1965), a case involving the rape and murder of a woman in a dark alley, the Supreme Court considered whether the following arguments by the prosecutor constituted...
-
Consider the model \[ y=\theta_{1}-\theta_{2} e^{-\theta_{3} x}+\varepsilon \] This is called the Mitcherlich equation, and it is often used in chemical engineering. For example, \(y\) may be yield...
-
Suppose the probabilities are 0.89,0.09, and 0.02 that the finish on a new car will be rated acceptable, easily repairable, or unacceptable. Find the probability that, among 20 cars painted one...
-
The probabilities that a quality control team will visit \(0,1,2,3\), or 4 production sites on a single day are 0.15,0.22,0.35,0.21, and 0.07. (a) Simulate the inspection team's visits on 30 days....
-
What is the worst complication that the patient may experience, and how will it prevent, identify and treat Autism. (Death is the worst, but what will cause it)
-
Write an essay describing the differing approaches of nursing leaders and managers to issues in practice. To complete this assignment, do the following: 1. Select an issue from the following list:...
-
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.
-
For binary diffusion with convection, use Eqs. (15-15e), (15-15f), (15-17a), (15-17b), and sum of mole fractions equals 1.0 to show that \(D_{\mathrm{AB}}=D_{\mathrm{BA}}\). Fick's law diffusive flux...
-
For binary distillation with \(\mathrm{CMO}, \mathrm{v}_{\text {ref,mol }}=0\). If \(\mathrm{CMO}\) is valid, show that \(\mathrm{v}_{\text {ref,mass }} eq 0\) if \(\mathrm{MW}_{\mathrm{A}} eq...
-
Derive Eq. (15-40a). Equation (15-40a) KPL.mol 1-C3XA.I.mol PL.mol NA,mol In C3=1+ C3 1-C3XA.bulk,mol. PS,mol
Study smarter with the SolutionInn App