Please show cell references for Excel for this Cost of Goods Manufactured Schedule.

Yes the answer is provided for reference, I need to know how the answers were determined using cell referencing in Excel.

Save View Help Se Home Insert Page Layout Formulas Data Review 1 Co Online Pictures 3D Models - Shapes SmartArt able Recommended Table Pictures Pivot Tables Screenshot Tables illustrations Get Add-ins My Add-ins - Icons Add-ins fr BROOKS CORPORATION BROOKS CORPORATION Cost of Goods Manufactured Schedule For the Year Ended December 31, 2019 Work in process, Jan 1 Direct labor Direct Materials Raw Materials Inventory Jan. 1 Raw Materials Purchased Less: Raw Materials Inventory, Dec. 31 Direct materials used Total manufacturing overhead Total manufacturing costs Total cost of work in process Less: Work in process, Dec 31 Cost of goods manufactured Grading Rubric -1 for each number used instead of cell referencing or formulas (up to 10 pts total) (Ans! will show the formulas for all the cells. Verify there are no numbers.) for each purple cell that contains a reference to the "Given Info" tab (4 pts total lans "Given Info" do not appear in any purple box.) -2 for an incorrect file name (should be - First Name Last Name - Excel #2) (2 pts total) (A -1 for each blank cell or cell that contains the wrong numerical value (up to 10 pts total) 1-10 for an Excel #2 submission from a previous semester or a blank file or a file not able to How to Use Cell References Given Info Answers AutoSave Off b. View Hel ile Home Insert Page Layout Formulas Data Review Cg Online Pictures 3D Models To Shapes SmartArt wotTable Recommended Table Pictures Screenshot Pivot Tables Get Add-i My Add-in Tables illustrations Add-ins 3 Brooks Corporation has the following cost records for December 2019. $ 210,000 $ 25,000 $ 18,000 $ 30,000 $ 24,000 Raw Materials, 1/1/15 Raw Materials, 12/31/15 Raw Materials Purchases Direct Labor Work in process, 1/1/15 5 Work in process, 12/31/15 5 Finished goods, 1/1/15 7 Finished goods, 12/31/15 Total Manufacturing 8 Overhead $ 32,000 $ 44,000 $ 145,000 $ 200,000 10 11 1 INSTRUCTIONS 1. Review the tab "How to Use Cell References." 2. Complete the Cost of Goods Manufactured Schedule FYE December 2019 on the "Answers" works formulas. 3. Save your file using the following format: First Name Last Name - Excel #2. Submit your file via the 13 NOTE: You MUST use this semester's Excel file and NOT any Excel assignment from a previous semest receive a O for this assignment. 21 22 23 Helpful Hints . Don't leave messages in the "Add Comments field when submitting your Excel homework. Leam's "A instructors gathers all the homework together for grading purposes, but it doesn't show any of the me If you have a problem or concern, send your Graduate Assistant a Course Message via Learn. Make sure that you submit the assignment by the date and time listed on the syllabus. 24 25 learn.unm.edu Maps YouTube ws The $25,000 BROOKS CORPORATION Cost of Goods Manufactured Schedule For the Year Ended December 31, 2019 Work in process, Jan 1 Direct labor $210,000 Direct Materials Raw Materials Inventory Jan. 1 $32,000 Raw Materials Purchased $145,000 Less: Raw Materials Inventory, Dec. 31 $44,000 Direct materials used $133,000 Total manufacturing overhead $200,000 Total manufacturing costs Total cost of work in process Less: Work in process, Dec 31 Cost of goods manufactured $543,000 $568,000 $18,000 $550,000 Grading Rubric -1 for each number used instead of cell referencing or formulas (up to 10 pts total) (Answe show the formulas for all the cells. Verify there are no numbers.) -1 for each purple cell that contains a reference to the "Given Info" tab (4 pts total) (Answr Info" do not appear in any purple box.) -2 for an incorrect file name (should be - First Name Last Name - Excel #2) (2 pts total) (An -1 for each blank cell or cell that contains the wrong numerical value (up to 10 pts total) -10 for an Excel #2 submission from a previous semester or a blank file or a file not able to