Is it possible to show me how to do this in excel?

1. 20 points. Super Cy Soccer Manufacturing produces red and gold soccer balls in two stages. The first stage is Molding and the second stage is Painting. This period, Painting began with 10,000 balls which were 60% complete as to both materials and conversion costs. In the Painting stage, all conversion costs are added uniformly throughout the process and direct materials were added when balls were 50 percent done. The beginning inventory of 10,000 units had associated with it, $10,200 of transferred in costs, $3,000 of direct materials and $2,625 of conversion costs. During the period, an additional 50,000 balls were started with a transferred in costs of $45,000. $15,200 of direct materials was added during the period as well as $17,500 of conversion costs. 52,000 balls were finished in Painting this period. Of those 52,000 balls, 2,000 were spoiled. Normal spoilage is considered 3 percent of good units. Ending WIP was 30% complete. Find the following using both the weighted average and FIFO methods (please highlight your final answers in red): a. Cost per equivalent unit for transferred-in costs b. Cost per equivalent unit for direct materials c. Cost per equivalent unit for conversion costs d. The value of good units completed and transferred out