Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, I need some help figuring out what I did wrong for this excel sheet. I am supposed to do the calculations and then test

Hello, I need some help figuring out what I did wrong for this excel sheet. I am supposed to do the calculations and then test to see if my calculations are correct by changing the values and it was in fact correct until I had to change some other values and answer questions such as: What is the equivalent units of production for materials?, What is the equivalent units of production for conversion?, What is the cost per equivalent unit for materials?, What is the cost per equivalent unit for conversion?, and What is the cost of the units transferred out?. I put in my answers from the edited sheet and the questions are still wrong. This means that I made an error somewhere in the original sheet which I will attach pictures of to this post and I am really hoping to figure this out because I am really not sure what I did wrong. I realize this post is quite long, but I don't know what else to do. I am not sure if the last 3 photos are needed but I have attached them just in case and the picture with requirement 2 are the values that must be changed in the original sheet (previous photos) to be able to answer the questions. Thank you.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Chapter 5: Applying Excel Data Beginning work in process inventory: \begin{tabular}{|l|r|} \hline Units in process & 200 \\ \hline Completion with respect to materials & 55% \\ \hline Completion with respect to conversion & 30% \\ \hline Costs in the beginning work in process inventory: & \\ \hline Materials cost & $9,600 \\ \hline Conversion cost & $5,575 \\ \hline Units started into production during the period & 5,000 \\ \hline Costs added to production during the period: & \\ \hline Materials cost & $368,600 \\ \hline Conversion cost & $350,900 \\ \hline Ending work in process inventory: & \\ \hline Units in process & 400 \\ \hline Completion with respect to materials & 40% \\ \hline Completion with respect to conversion & 25% \\ \hline \end{tabular} Enter a formula into each of the cells marked with a? below Weighted Average method: Equivalent Units of Production Costs per Equivalent Unit Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion Total Ending work in process inventory: \begin{tabular}{|l|r|r|r|} \hline Equivalent units & 160 & 100 & \\ \hline Cost per equivalent unit & $175.09 & $72.75 & \\ \hline Cost of ending work in process inventory & $28,015 & $7,275 & $35,290 \\ \hline \end{tabular} Units completed and transferred out: Units transferred to the next department Cost per equivalent unit Cost of units transferred out \begin{tabular}{|r|r|r|} \hline 4,800 & 4,800 & \\ \hline$175.09 & $72.75 & \\ \hline$840,444 & $349,200 & $1,189,644 \\ \hline \end{tabular} Cost Reconciliation Costs to be accounted for: \begin{tabular}{l|r} Cost of beginning work in process inventory & $15,175 \\ \hline Costs added to production during the period & $719,500 \\ \hline Total cost to be accounted for & $734,675 \\ \hline \hline \end{tabular} Costs accounted for as follows: Cost of ending work in process inventory Cost of units transferred out Total cost accounted for $1,189,644$1,224,934 Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: EXHIBIT 5-5 Shaping and Milling Department Production Data for May *We always assume that units transferred out of a department are 100% complete with respect to the processing done in that department. EXHIBIT 5-8 Shaping and Milling Department Cost Data for May \begin{tabular}{|l|r|r|} \hline \multicolumn{3}{|c|}{ Shaping and Milling Department } \\ \hline \multicolumn{3}{|c|}{ Costs per Equivalent Unit } \\ \hline Cost of beginning work in process inventory & Materials & Conversion \\ \hline Costs added during the period & $9,600 & $5,575 \\ \hline Total cost (a) & 368,600 & 350,900 \\ \hline Equivalent units of production (see Exhibit 5-6) (b) & $378,200 & $356,475 \\ \hline Cost per equivalent unit (a) ( (b) & 4,960 & 4,900 \\ \hline \end{tabular} Chapter 5: Applying Excel Data Beginning work in process inventory: \begin{tabular}{|l|r|} \hline Units in process & 200 \\ \hline Completion with respect to materials & 55% \\ \hline Completion with respect to conversion & 30% \\ \hline Costs in the beginning work in process inventory: & \\ \hline Materials cost & $9,600 \\ \hline Conversion cost & $5,575 \\ \hline Units started into production during the period & 5,000 \\ \hline Costs added to production during the period: & \\ \hline Materials cost & $368,600 \\ \hline Conversion cost & $350,900 \\ \hline Ending work in process inventory: & \\ \hline Units in process & 400 \\ \hline Completion with respect to materials & 40% \\ \hline Completion with respect to conversion & 25% \\ \hline \end{tabular} Enter a formula into each of the cells marked with a? below Weighted Average method: Equivalent Units of Production Costs per Equivalent Unit Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion Total Ending work in process inventory: \begin{tabular}{|l|r|r|r|} \hline Equivalent units & 160 & 100 & \\ \hline Cost per equivalent unit & $175.09 & $72.75 & \\ \hline Cost of ending work in process inventory & $28,015 & $7,275 & $35,290 \\ \hline \end{tabular} Units completed and transferred out: Units transferred to the next department Cost per equivalent unit Cost of units transferred out \begin{tabular}{|r|r|r|} \hline 4,800 & 4,800 & \\ \hline$175.09 & $72.75 & \\ \hline$840,444 & $349,200 & $1,189,644 \\ \hline \end{tabular} Cost Reconciliation Costs to be accounted for: \begin{tabular}{l|r} Cost of beginning work in process inventory & $15,175 \\ \hline Costs added to production during the period & $719,500 \\ \hline Total cost to be accounted for & $734,675 \\ \hline \hline \end{tabular} Costs accounted for as follows: Cost of ending work in process inventory Cost of units transferred out Total cost accounted for $1,189,644$1,224,934 Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: EXHIBIT 5-5 Shaping and Milling Department Production Data for May *We always assume that units transferred out of a department are 100% complete with respect to the processing done in that department. EXHIBIT 5-8 Shaping and Milling Department Cost Data for May \begin{tabular}{|l|r|r|} \hline \multicolumn{3}{|c|}{ Shaping and Milling Department } \\ \hline \multicolumn{3}{|c|}{ Costs per Equivalent Unit } \\ \hline Cost of beginning work in process inventory & Materials & Conversion \\ \hline Costs added during the period & $9,600 & $5,575 \\ \hline Total cost (a) & 368,600 & 350,900 \\ \hline Equivalent units of production (see Exhibit 5-6) (b) & $378,200 & $356,475 \\ \hline Cost per equivalent unit (a) ( (b) & 4,960 & 4,900 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introductory Accounting Finance And Auditing For Lawyers

Authors: Lawrence Cunningham

6th Edition

0314280456, 978-0314280459

More Books

Students also viewed these Accounting questions

Question

Communicate your wishes using empathy and unambiguous statements.

Answered: 1 week ago