i need answers with excel formula.

2 Fields Company has two manufacturing departments, Forming and Painting. The company uses the 3 weighted average method and reports the following unit data for the Forming department. Units 4 completed in the Forming department are transferred to the Painting department. 5 6 7 c 1 1 1 13 Production cost information for the forming department follows. 14 23 Required: 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 transferred to Painting and its ending work in process inventory. 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: Required: 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-specifically, its units transferred to Painting and its 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. 2 Fields Company has two manufacturing departments, Forming and Painting. The company uses the 3 weighted average method and reports the following unit data for the Forming department. Units 4 completed in the Forming department are transferred to the Painting department. 5 6 7 c 1 1 1 13 Production cost information for the forming department follows. 14 23 Required: 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 transferred to Painting and its ending work in process inventory