please give me a solution for excel sheet with excel formulas.

Fields Company has two manufacturing departments, Forming and Painting. The company uses the weighted average method and reports the following unit data for the Forming department. Units completed in the Forming department are transferred to the Painting department. Production cost information for the Forming department follows: Requited: a. Calculate the equivalent units of production for both direct materials and conversion for the Forming department. b. Calculate the costs per equivalent unit of production for both direct materials and conversion for the Forming department. c. Using the weighted average method, assign costs to the Forming department's output-5pecifically. its units transferred to Painting and lits ending work in process inventory. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. c. Using the weighted average method, assign costs to the Forming department's output-specifically, its units transferred to Painting and its ending work in process inventory. Flelds Company has two manufacturing departments, Forming and Painting. The company uses the weighted average method and reports the following unit data for the forming department. Units completed in the forming department are transferred to the Painting department. 24 a. Calculate the equivalent units of production (EUP) for both direct materials and conversion for the Forming department. b. Calculate the costs per equivalent unit of production for both direct materials and conversion for the Forming department. c. Using the weighted average method, assign costs to the forming department's output-specifically, its units