Please help I'm very confused on this

Computing Overhead Rate and Preparing Schedules of Cost of Goods Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller has asked you to compute the predetermined overhead rate, the schedule of cost of goods manufactured, and the schedule of cost of goods sold. Here are some tips for using Excel: - Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. - Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. - SUM Function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges. If you entered "=SUM (C4,C5,C6) " into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "=SUM(C4:C6)", the formula would output the same result of adding those cells. 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. Excel McGraw Hill Excel Question - Saved Search ( Alt +Q) File Home Insert Draw Formulas Data Review View Help Calibri B Merge Gene A1 fx Accessibility tab summary: Financial information for Stanford Enterprises, is presented in rows 5 to 19 . A Computing Process Costs Using the Weighted-Average Method Hayword, Inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Here are some tips for using Excel: - Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. - Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. - SUM Function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges. If you entered "=SUM(C4,C5,C6)" into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "=SUM(C4:C6)", the formula would output the same result of adding those cells. 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. (Use cells B6 to C18 from the given information to complete this question. All answers should be input and displayed as positive values.) Stanford Enterprises Schedule of Cost of Goods Manufactured Direct materials: Raw materials inventory, beginning Add: Purchases of raw materials Total raw materials available Deduct: Raw materials inventory, ending Raw materials used in production Direct labor Applied manufacturing overhead Total manufacturing costs Add: Beginning work in process inventory Total cost of work in process Deduct: Ending work in process inventory Cost of goods manufactured 3. Prepare a schedue of cost of goods sold. (Use cells B6 to C18 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a negative value. All answers should be input and displayed as positive values.) Stanford Enterprises Schedule of Cost of Goods Sold Finished goods inventory, beginning Add: Cost of goods manufactured Cost of goods available for sale Deduct: Finished goods inventory, ending Unadjusted cost of goods sold Underapplied (overapplied) overhead Adjusted cost of goods sold Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. The following information relates to work in the mixing department for the month of July: \begin{tabular}{|l|r|} \hline Work in process, beginning: & \\ \hline Units in process & 300 \\ \hline Completion with respect to materials & 60% \\ \hline Completion with respect to conversion & 40% \\ \hline Costs in the beginning inventory: & \\ \hline Materials cost & $10,500 \\ \hline Conversion cost & $6,750 \\ \hline Units started into production during the period & 6,200 \\ \hline Costs added to production during the period: & \\ \hline Materials cost & $332,150 \\ \hline Conversion cost & $407,645 \\ \hline Work in process, ending: & 450 \\ \hline Units in process & 40% \\ \hline Completion with respect to materials & 30% \\ \hline Completion with respect to conversion & \\ \hline \end{tabular} Required: Use the data to fill in the following information. (Use cells A5 to B19 from the given information to complete this question.) 1. Compute equivalent units. \begin{tabular}{l} Cost of beginning work in process inventory \\ Costs added during the period \\ Total cost \\ Equivalent units of production \\ Cost per equivalent unit \\ \hline Costs of Ending Work in Process Inventory and the Units Transferred Out \\ \hline 3. Assign costs. \\ \hline Ending work in process inventory: \\ \hline Equivalent units of production \\ \hline Cost per equivalent unit \\ Cost of ending work in process inventory \\ Units completed and transferred out: \\ Units transferred to the next department \\ \hline Cost per equivalent unit \\ \hline Cost of units transferred out \\ \hline Mixing Department \\ \hline Cost Reconciliation \\ \hline Costs to be accounted for: \\ \hline Cost of beginning work in process inventory \\ \hline Costs added to production during the period \\ \hline Costal cost to be accounted for \\ \hline Cost of ending work in process inventory units transferred out \\ \hline Total cost accounted for \\ \hline \end{tabular} Computing Overhead Rate and Preparing Schedules of Cost of Goods Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller has asked you to compute the predetermined overhead rate, the schedule of cost of goods manufactured, and the schedule of cost of goods sold. Here are some tips for using Excel: - Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. - Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. - SUM Function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges. If you entered "=SUM (C4,C5,C6) " into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "=SUM(C4:C6)", the formula would output the same result of adding those cells. 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. Excel McGraw Hill Excel Question - Saved Search ( Alt +Q) File Home Insert Draw Formulas Data Review View Help Calibri B Merge Gene A1 fx Accessibility tab summary: Financial information for Stanford Enterprises, is presented in rows 5 to 19 . A Computing Process Costs Using the Weighted-Average Method Hayword, Inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Here are some tips for using Excel: - Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. - Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. - SUM Function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges. If you entered "=SUM(C4,C5,C6)" into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "=SUM(C4:C6)", the formula would output the same result of adding those cells. 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. (Use cells B6 to C18 from the given information to complete this question. All answers should be input and displayed as positive values.) Stanford Enterprises Schedule of Cost of Goods Manufactured Direct materials: Raw materials inventory, beginning Add: Purchases of raw materials Total raw materials available Deduct: Raw materials inventory, ending Raw materials used in production Direct labor Applied manufacturing overhead Total manufacturing costs Add: Beginning work in process inventory Total cost of work in process Deduct: Ending work in process inventory Cost of goods manufactured 3. Prepare a schedue of cost of goods sold. (Use cells B6 to C18 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a negative value. All answers should be input and displayed as positive values.) Stanford Enterprises Schedule of Cost of Goods Sold Finished goods inventory, beginning Add: Cost of goods manufactured Cost of goods available for sale Deduct: Finished goods inventory, ending Unadjusted cost of goods sold Underapplied (overapplied) overhead Adjusted cost of goods sold Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. The following information relates to work in the mixing department for the month of July: \begin{tabular}{|l|r|} \hline Work in process, beginning: & \\ \hline Units in process & 300 \\ \hline Completion with respect to materials & 60% \\ \hline Completion with respect to conversion & 40% \\ \hline Costs in the beginning inventory: & \\ \hline Materials cost & $10,500 \\ \hline Conversion cost & $6,750 \\ \hline Units started into production during the period & 6,200 \\ \hline Costs added to production during the period: & \\ \hline Materials cost & $332,150 \\ \hline Conversion cost & $407,645 \\ \hline Work in process, ending: & 450 \\ \hline Units in process & 40% \\ \hline Completion with respect to materials & 30% \\ \hline Completion with respect to conversion & \\ \hline \end{tabular} Required: Use the data to fill in the following information. (Use cells A5 to B19 from the given information to complete this question.) 1. Compute equivalent units. \begin{tabular}{l} Cost of beginning work in process inventory \\ Costs added during the period \\ Total cost \\ Equivalent units of production \\ Cost per equivalent unit \\ \hline Costs of Ending Work in Process Inventory and the Units Transferred Out \\ \hline 3. Assign costs. \\ \hline Ending work in process inventory: \\ \hline Equivalent units of production \\ \hline Cost per equivalent unit \\ Cost of ending work in process inventory \\ Units completed and transferred out: \\ Units transferred to the next department \\ \hline Cost per equivalent unit \\ \hline Cost of units transferred out \\ \hline Mixing Department \\ \hline Cost Reconciliation \\ \hline Costs to be accounted for: \\ \hline Cost of beginning work in process inventory \\ \hline Costs added to production during the period \\ \hline Costal cost to be accounted for \\ \hline Cost of ending work in process inventory units transferred out \\ \hline Total cost accounted for \\ \hline \end{tabular}