Please include a excel table and the formulas and calculation explanation.

17-24 Weighted-average method, equivalent units. The assembly division of Quality Time Pieces, Inc. uses the weighted-average method of process costing. Consider the following data for the month of May 2017: Required: For the data in Exercise 17-24, summarize the total costs to account for, calculate the cost per equivalent unit for direct materials and conversion costs, and assign costs to the units completed (and transferred out) and units in ending work in process