G A H Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as indicated. a. Calculate the lower of cost and net realizable value for each inventory category within Tech-T's inventory. B D E 3 BE6.10 Using Excel to Value Inventory at the Lower-of- 4 Cost or Net Realizable Value 5 PROBLEM 6 The following information on cost and net realizable value of 7 Tech-T Ltd.'s various inventory categories was gathered at 8 December 31, 2021: 9 10 Inventory Categories Cost NRV 11 Desktops $3,47,000 $3,26,000 12 Tablets and readers 1,68,700 2.24,000 13 Laptops 2.21,020 2,85,000 14 Accessories and parts 97,400 94,300 15 16 LCNRV Inventory Categories Desktops Tablets and readers Laptop 17 Accessories and parts 18 19 20 Total LCNRV b. Prepare the entry needed to adjust Tech-T's inventory value to the lower of cost or net realizable value at December 31, 2021. 21 22 23 24 25 Debit Credit 26 27 28