Raelynn, a product designer for the company's high-definition sunglasses, visited with Kavon, the accounting manager, about their product costs. \begin{tabular}{|l|l} Raelynn & I looked back at the design specifications and saw that our initial cost estimates were $24 \\ per unit or less. If I 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? \end{tabular} Kavon then gathered several key pieces of information from his reports over the past few years and summarized them for the company's only production process as follows. Required: 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 Required: Use Excel, presenting all rates and dollar amounts to the nearest cent; reference cells for all calculations to avoid rounding issues. 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. \begin{tabular}{|l|l} Raelynn & I looked back at the design specifications and saw that our initial cost estimates were $24 \\ per unit or less. If I 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? \end{tabular} Kavon then gathered several key pieces of information from his reports over the past few years and summarized them for the company's only production process as follows. Required: 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 Required: Use Excel, presenting all rates and dollar amounts to the nearest cent; reference cells for all calculations to avoid rounding issues. 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