Please assist with requirements 2 &3, please include any formulas in excel form with the relative cell reference.

Thanks

Salish Craft Beers provides the following information for the Malting Department for the month of August 2024 : \begin{tabular}{l} \hline \\ \hline Beginning Work-in-Process Inventory \\ Started in Production in August \\ Total to Account For \\ Completed and Transferred to Packaging Department during \\ Ending Work-in-Process Inventory, 40% complete for direct \\ conversion costs. \\ Total Accounted For \\ Includes $23,000 direct materials and $45,000 conversion costs. \\ \hline \end{tabular} Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. ALWAYS use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. Requirement 1. Complete a production cost report for the Malting Department for the month of August 2024 to determine the cost of the units completed and transferred out, and the cost of the ending Work-in-Process Inventory. Assume Salish Craft Beers uses the weighted-average method. 2. Post the appropriate amounts to the Work In Process T-account. 3. Identify the Cost of Goods Manufactured and Work in Process Ending Inventory balance for the Malting Department for August. Excel Skills 1 Enter numbers into cells. 2 Create formulas. 3 Format the cells requiring dollar signs. 4 Format the cells requiring a single underline and cells requiring double underlines. Requirement 1 Complete a production cost report for the Malting Department for the month of August 2024 to determine the cost of the units transferred out, and the cost of the ending Work-in-Process Inventory. Assume Salish Craft Beers uses the weighted-average method. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) SALISH CRAFT BEERS Production Cost Report - MALTING DEPARTMENT Month Ended August 31, 2024 Requirement 2 Requirement 3 \begin{tabular}{|l|r|} \hline Malting Department: \\ \hline Cost of Goods Manufactured & 60,315 \\ \hline Ending Work In Process Inventory Balance & 7,685 \\ \hline \end{tabular} HINTS 1. Use an equal sign (=), the appropriate cells and numeric values from the Instructions and ENTERANSWERS tabs. 2. Do not use an equal sign (=) when entering a numeric value. 3. Do not leave any cells blank. Cell|Hint: C11, D22:F22 | Be sure to enter cell reference or formulas, not numeric values. C13 Use the =SUM( ) function to calculate the total units to account for