Please show calculations, thank you

Academic Dishonesty policy). Each case solution must be prepared using Excel. You must submit your solution in an Excel spreadsheet to the Pilot drop box which includes all supporting calculations performed with appropriate Excel formulas. Failure to do so will result in a reduction in points. Be sure to format your spreadsheet so that your work is clearly presented and easy to review. Excel Case #2 per Unit Scioto Corporation follows the Lower of Cost or Net Realizable Value (LCNRV) Rule for its inventory. The following information was taken from Scioto's inventory records as of December 31. 2020: Selling Quantity Cost Price Product on Hand per Unit Product A 9.000 11.00 15.00 Product B 4,500 16.00 14.00 Product C 4.100 22.00 24.00 Product D 9.400 31.00 35.00 Product E 4,700 27.00 32.00 Product F 7.000 29.00 30.00 Product G 2.000 60.00 58.00 Product H 9.100 42.00 45.00 Product I 600 18.00 20.00 Product J 2.300 55.00 50.00 Scioto has the following costs to sell associated with all of its products: 1. Sales commission of 4% of the selling price for each product 2. Packaging and delivery costs of 6% of the cost of each product Requirements: Complete each of the following independent requirements: a) Determine the carrying value of inventory at 12/31/20 assuming that Scioto applies the LCNRV Rule to each specific product in its inventory. Also, determine the amount of the loss (if any) that Scioto would record for 2020. b) Determine the carrying value of inventory at 12/31/20 assuming that Scioto applies the LCNRV Rule to its total inventory. Also, determine the amount of the loss (if any) that Scioto would record for 2020