please give me the EXCEL FORMILAS (not just the answer) for anything blank and the yellow blanks

3 weighted average method, and units completed in the Molding department are transferred to the Packaging 4 department. Production unit information for the Molding department follows. 11 Production cost information for the Molding department for the same period follows. 12 \begin{tabular}{|l|l|r|} \hline 13 & Beginning work in process inventory (direct materials) & $1,200 \\ \hline 14 & Direct materials added this period & 27,900 \\ \hline 15 & & \end{tabular} 15 16 Required: 17 1. Compute the Molding department's (a) units completed and transferred out. fx Accessibility tab summary: Production unit information for the Molding departr A B C D F (Use cells A6 to C14 from the given information to complete this question.) Units completed and transferred out 2. Compute the Molding department's (b) equivalent units of production for direct materials, and (c) cost per equivalent unit of production for direct materials. i has two manufacturing departments, forming and painting. The company uses the weighted average method and it reports the following unit data for the Forming department. Units completed in the forming department are transferred to the painting department. 13 Production cost information for the forming department follows. 14 24 a. Calculate the equivalent units of production for both direct materials and conversion for the forming department. (Use cells A6 to D21 from the given information to complete this question.) b. Calculate the costs per equivalent unit of production for both direct materials and conversion for the forming department. (Use cells A6 to D21 from the given information to complete this question.) 45 c. Using the weighted average method, assign costs to the forming department's output - specifically, its units transferred 46 to painting and its ending work in process inventory. File Home Insert Draw Formulas Data Review View Help Editing A1 fx Accessibility tab summary: Unit data for F \begin{tabular}{l|l} \hline 49 & Cost \\ 50 & Coms \\ 51 & Complot \\ 52 & Direct \\ 53 & Conve \\ 54 \\ 55 & Ending \\ 56 \\ 57 \\ 58 \\ 59 \\ 60 \\ 61 \\ 62 \end{tabular} Total Completed and transferred out Ending work in process Direct materials Conversion EUP Cost per EUP Total cost Total cost of ending work in process Total costs accounted for 2 wises the weighted average method of process costing. Information for the company's first production process follows. All 3 direct materials are added at the beginning of this process, and conversion costs are added uniformly throughout the process. (Use cells AS to D17 from the given information to complete this question.) C. Assign costs to the department's output-specifically, to the units transferred out and to the units in ending work in process inventory. (Round "Cost per EUp" to 2 decimal places.) (Use cells AS to D17 from the given information to complete this question.) 2 The following information relates to work in the mixing department for the month of July: 4 Work in process, July 1: 12 Costs added to production during the period: Use the data to answer the following. Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out 46 Ending work in process inventory: Materials Conversion Total Equivalent units of production Cost per equivalent unit Cost of ending work in process inventory Units completed and transferred out: Units transferred to the next department Cost per equivalent unit Cost of units transferred out 4. Prepare reconciliation. Mixing Department Cost Reconciliation Costs to be accounted for: Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for Costs accounted for as follows: 64 Cost of ending work in process inventory 65 Cost of units transferred out 66 Total cost accounted for