Need help with this question please. Need the working and final answer. Exhibit 10 and Excel screenshot is attached

Lower-of-cost-or-market method On the basis of the following data, determine the value of the inventory at the lower of cost or market. Apply lower of cost or market to each inventory item, as shown in Exhibit 10. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X pen spreadsheet Feedback Check My Work Under the lower-of-cost-or-market method, you must compute the total cost and total market value for each item. Then choose the lower of total cost or total market value for each item as the assigned value for computing the total inventory. Exhibit 10 Determining Inventory at Lower of Cost or Market (LCM) On the basis of the following data, determine the value of the inventory at the lower of cost or market. Apply lower of cost or market to each inventory item. Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv2 for grading