(Answer using excel for a thumbs up please)

Marsh Company began operations on 1/1/22. At 12/31/22, the following data were available: Compute the ending inventory at cost at 12/31/22 using the conventional retail inventory method. Your solution should be in good form with amounts clearly labeled. What adjustment will Marsh need to make to apply the LCOM rule to its ending inventory for balance sheet presentation? Marsh Company began operations on 1/1/22. At 12/31/22, the following data were available: Compute the ending inventory at cost at 12/31/22 using the conventional retail inventory method. Your solution should be in good form with amounts clearly labeled. What adjustment will Marsh need to make to apply the LCOM rule to its ending inventory for balance sheet presentation