Mitchells Specialties sells high-end furniture (dressers, chairs, sofas, and tables). The company has been in business for several years. Based on its experience, management projects next years sales prices of year-end inventory using the trend in monthly sales prices during the current year. Presented below are those trends in sales prices for each of its four types of inventory, as well as next years projected sales price. Also presented are the number of units of ending inventory and the average cost of each of those units. Click here to open the graphs in a new tab. Prepare the year-end adjusting entry to record inventory using the lower of cost or net realizable value method (Hint: Be sure to account for the number of units of ending inventory in your calculation).