I need help with the pivot table

brane functions to answer the following questions. Q1. What is the value of inventory when lower of cost or market is applied to total inventory? sx Q2. What is the value of inventory when lower of cost or market is applied to each item in the inventory? $ x Q3. What is the value of inventory when lower of cost or market is applied to each class of inventory? $ x Q4. When lower of cost or market is applied to each item in inventory, how much value did inventory lose due to market decline? x Q5. The lower of cost or market method is an example of a company choosing an accounting method to reduce the possibility of overstating assets and income. results in a gain on the income statement if market value is greater than cost. is required when the prices of all of the inventory items a company is purchasing are continuously rising. is an alternative to FIFO as an inventory cost flow assumption