Raelynn, a product designer for the company's high-definition sunglasses, visited with Kavon, the accounting manager, about their product costs. Raelynn: I looked back at the design specifications and sawthat our initial cost estimates were \$24 per unit or less. IfI recall correctly, we needed to keep the unit cost at or below that level to meet target profit goals, since we have almost no wiggle room on selling prices due to fierce competition. That was a few years ago, though. How is production doing with these units? Are our costs in line with these expectations? Kavon: Well, we've definitely been tracking our production costs and quantity of units produced and completed. I don't recall off the top of my head if our per-unit cost has been staying in that \$24 range or not, though. We were actually just about to do a different comparison looking at our cost assignment under weighted-average compared to the FIFO method that we have been using. Why don't I wrap up that analysis, and then we can review per-unit costs together? Kavon then gathered severalkey pieces of information from his reports over the past few years and summarized them for the company's only production process as follows. \begin{tabular}{|l|r|r|r|} \hline Year 1 & Units & DM \\ \cline { 1 - 2 } Units in beginning WIP Inventory & & \\ \hline Beginning WIP Inventory degree of completion & & 0% \\ \hline Costs in beginning WIP Inventory & 1,000 & \\ \hline New units started & & \\ \hline Costs added to WIP Inventory this period & 800 & $10,000 \\ \hline Units completed & 200 & \\ \hline Units in ending WIP Inventory & & 100% \\ \hline Ending WIP Inventory degree of completion & 1,000 & \\ \hline Year 2 & & $10,500 \\ \hline New units started & 800 & 100% \\ \hline Costs added to WIP Inventory this period & 400 & \\ \hline Units completed & & \\ \hline Units in ending WIP Inventory & 1,000 & \\ \hline Ending WIP Inventory degree of completion & & \\ \hline Year 3 & 1,000 & \\ \hline New units started & 400 & \\ \hline Costs added to WIP Inventory this period & & \\ \hline Units completed & Units in ending WIP Inventory & & \\ \hline Ending WIP Inventory degree of completion & & & \\ \hline \end{tabular} Use Excel, presenting all rates and dollar amounts to the nearest cent; reference cells for all calculations to avoid rounding issues. - Using the company's originally selected FIFO method of process costing, determine equivalent units and assign costs to units completed and to units in ending WIP Inventory for the past 3 years (complete Steps 1-5 of the template for each of the 3 years). - Use the weighted-average method of process costing to complete the same analysis as in part (a), so Kavon can see how the two methods compare. - Create a chart to summarize the cost per completed unit under both FIFO and weighted-average for each of the 3 years. If they are different for any of the years considered, provide a plausible explanation for the difference. - How did the company's actual cost per unit compare with its target cost as specified by the product designer? - As if you were Kavon, write a brief summary to the rest of the accounting team, summarizing the key differences between the FIFO and weighted-average methods for determining the costs of sunglasses over this 3 -year period. Be sure to include his recommendation to either continue with the FIFO method or switch to the weightedaverage method to account for the company's production work and costs going forward. Raelynn, a product designer for the company's high-definition sunglasses, visited with Kavon, the accounting manager, about their product costs. Raelynn: I looked back at the design specifications and sawthat our initial cost estimates were \$24 per unit or less. IfI recall correctly, we needed to keep the unit cost at or below that level to meet target profit goals, since we have almost no wiggle room on selling prices due to fierce competition. That was a few years ago, though. How is production doing with these units? Are our costs in line with these expectations? Kavon: Well, we've definitely been tracking our production costs and quantity of units produced and completed. I don't recall off the top of my head if our per-unit cost has been staying in that \$24 range or not, though. We were actually just about to do a different comparison looking at our cost assignment under weighted-average compared to the FIFO method that we have been using. Why don't I wrap up that analysis, and then we can review per-unit costs together? Kavon then gathered severalkey pieces of information from his reports over the past few years and summarized them for the company's only production process as follows. \begin{tabular}{|l|r|r|r|} \hline Year 1 & Units & DM \\ \cline { 1 - 2 } Units in beginning WIP Inventory & & \\ \hline Beginning WIP Inventory degree of completion & & 0% \\ \hline Costs in beginning WIP Inventory & 1,000 & \\ \hline New units started & & \\ \hline Costs added to WIP Inventory this period & 800 & $10,000 \\ \hline Units completed & 200 & \\ \hline Units in ending WIP Inventory & & 100% \\ \hline Ending WIP Inventory degree of completion & 1,000 & \\ \hline Year 2 & & $10,500 \\ \hline New units started & 800 & 100% \\ \hline Costs added to WIP Inventory this period & 400 & \\ \hline Units completed & & \\ \hline Units in ending WIP Inventory & 1,000 & \\ \hline Ending WIP Inventory degree of completion & & \\ \hline Year 3 & 1,000 & \\ \hline New units started & 400 & \\ \hline Costs added to WIP Inventory this period & & \\ \hline Units completed & Units in ending WIP Inventory & & \\ \hline Ending WIP Inventory degree of completion & & & \\ \hline \end{tabular} Use Excel, presenting all rates and dollar amounts to the nearest cent; reference cells for all calculations to avoid rounding issues. - Using the company's originally selected FIFO method of process costing, determine equivalent units and assign costs to units completed and to units in ending WIP Inventory for the past 3 years (complete Steps 1-5 of the template for each of the 3 years). - Use the weighted-average method of process costing to complete the same analysis as in part (a), so Kavon can see how the two methods compare. - Create a chart to summarize the cost per completed unit under both FIFO and weighted-average for each of the 3 years. If they are different for any of the years considered, provide a plausible explanation for the difference. - How did the company's actual cost per unit compare with its target cost as specified by the product designer? - As if you were Kavon, write a brief summary to the rest of the accounting team, summarizing the key differences between the FIFO and weighted-average methods for determining the costs of sunglasses over this 3 -year period. Be sure to include his recommendation to either continue with the FIFO method or switch to the weightedaverage method to account for the company's production work and costs going forward