please answer this accounting question

equirements wmryoursoruions anuu mese suPpormg caICuraious must ve prepareo wtran xcer spreadsheet. You must submit one printed copy of the Excel spreadsheet which contains your case solution and a second printed copy displaying the formulas contained in each cell of your spreadsheet. Excel Case # 2 Raider Industries must follow the Lower of Cost or Net Realizable Value (LCNRV) Rule for its inventory. The following information was taken from Raider's inventory records as of December 31, 2019: Selling Price per Unit 15.00 Product ID Quantity on Hand 3,250 4,000 Cost Number Item # 101 per Unit 12.00 Item # 102 60.00 55.00 Item #103 6,000 7,00 8.00 Item #104 2,700 4.00 6.00 Item #105 Item # 201 Item #202 Item # 203 500 75.00 80.00 600 80.00 90,00 1,500 4.000 5.00 5.50 16.00 17.00 Raider has the following costs to sell associated with all of its products: 1. Sales commission of 10 % of the selling price for each product 2. Packaging and delivery costs of 5% of the cost of each product Requirements: Complete each of the following independent requirements: a) Determine the carrying value of inventory at 12/31/19 assuming that Raider applies the LCNRV Rule to each specific product in its inventory. Also, assuming that Raider would record any loss recognized as a separate line item in its income statement, determine the amount of the loss (if any) that Raider would record for 2019 b) Determine the carrying value of inventory at 12/31/19 assuming that Raider applies the LCNRV Rule to its total inventory. Also, assuming that Raider would record any loss recognized as a separate line item in its income statement, determine the amount of the loss (if any) that Raider would record for 2019 msi quirements The case submitted must be each student's own work; collaboration among students in completing the case is not permitted (sce the course syllabus for a further description of the Academic Dishonesty policy). Each case solution must be typed. Handwritten work will not be accepted and, if submitted, will not be graded. You must include all supporting calculations with your solutions and these supporting calculations must be prepared with an Excel spreadsheet. You must submit one printed copy of the Excel spreadsheet which contains your case solution and a second printed copy displaying the formulas contained in each cell of your spreadsheet. Excel Case #2 Raider Industries must follow the Lower of Cost or Net Realizable Value (LCNRV) Rule for its inventory. The following information was taken from Raider's inventory records as of December 31, 2019: Selling Price Product ID Quantity on Hand 3,250 4,000 Cost Number Item # 101 per Unit 15.00 55.00 per Unit 12.00 Item # 102 60.00 Item # 103 6,000 7.00 8.00 Item #104 Item #105 2,700 4.00 6.00 500 75.00 80.00 Item #201 600 80.00 90.00 Item # 202 1,500 4,000 5.00 5.50 Item #203 16.00 17.00 Raider has the following costs to sell associated with all of its products: 1. Sales commission of 10 % of the selling price for each product each product 2. Packaging and delivery costs of 5% of the cost Requirements: Complete each of the following independent requirements: a) Determine the carrying value of inventory at 12/31/19 assuming that Raider applies the LCNRV Rule to each specific product in its inventory. Also, assuming that Raider would record any loss recognized as a separate line item in its ineome statement, determine the amount of the loss (if any) that Raider would record for 2019 b) Determine the carrying value of inventory at 12/31/19 assuming that Raider applies the LCNRV Rule to its total inventory. Also, assuming that Raider would record any loss recognized as a separate line item in its income statement, determine the amount of the loss (if