Excel McGraw Hill Excel Question - Saved Search (Option+O) File Home Insert Draw IMPORTANT: Answer grading policy x Formulas Data Calibri 11 B A1 Accessibility tab summary: The lis B For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. ent is p 1 In its first month of operations, Literacy for the Illiterate opened merchandise in the following order: (1) 300 units at $7 on Janua 2. Reference cells, Instead of entering values. Example: -83+C3 M 2 and (3) 750 units at $9 on January 29. 3 OK 4 January 1 January 5 Number of units 300 450 750 $7 $8 $9 6 Amount per unit 7 B Required: 9 used. 10 11 sale, ending inventory, and cost of goods sold under LIFO. Assume a periodic inventory system is 12 Cost of Goods Available for Sale 13 Ending Inventory 14 Cost of Goods Sold 15 16 17 LIFO 900 18 Students The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 19 Nothing in this area will be graded, but it will be submitted with your assignment. 20 21 22 23 24 25 Graded Worksheet Workbook Statistics + Calculation Mode: Automatic