please show formulas and work . please put in excel format

E7-13 (Algo) Reporting Inventory at Lower of Cost or Net Realizable Value LO7-4 Sanchez Company was formed on January 1 of the current year and is preparing the annual financial statements dated December 31, current year. Ending inventory information about the four major items stocked for regular sale follows: Item A B D Quantity on Hand 31 66 46 21 ENDING INVENTORY, CURRENT YEAR Net Realizable Unit Cost When Value (Market) Acquired (FIFO) at Year-End $ 16 $ 11 45 41 56 58 33 28 Required: 1. Compute the valuation that should be used for the current year ending inventory using lower of cost or net realizable value applied on an item-by-item basis. 2. What will be the effect of the write-down of inventory to lower of cost or net realizable value on cost of goods sold for the year ended December 31, current year? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the valuation that should be used for the current year ending inventory using lower of cost or net realizable value applied on an item-by-item basis. Total Net Item Quantity Total Cost Realizable Value Lower of Cost or NRV 31 B 66 46 D 21 Total $ 0 $ 0 $ 0 E7-13 (Algo) Reporting Inventory at Lower of Cost or Net Realizable Value LO7-4 Sanchez Company was formed on January 1 of the current year and is preparing the annual financial statements dated December 31, current year. Ending inventory information about the four major items stocked for regular sale follows: Item A B C D Quantity on Hand 31 66 46 21 ENDING INVENTORY, CURRENT YEAR Net Realizable Unit Cost When Value (Market) Acquired (FIFO) at Year-End $ 16 $ 11 45 41 56 58 33 28 Required: 1. Compute the valuation that should be used for the current year ending inventory using lower of cost or net realizable value applied on an item-by-item basis. 2. What will be the effect of the write-down of inventory to lower of cost or net realizable value on cost of goods sold for the year ended December 31, current year? Complete this question by entering your answers in the tabs below. Required 1 Required 2 What will be the effect of the write-down of inventory to lower of cost or net realizable value on cost of goods sold for the year ended December 3: The write-down to lower of cost or net realizable value will cost of goods sold expense by the amount of the write-down,