Please solve both the questions. I need help in both the questions and must show easy caclulations to undesatnd. Both the questions are same, just change of figures so do in excel and it will be easy.

URCES Problem 8-8 John's Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2017, John adopted dollar-value LIFO and decided to use a single inventory pool. The company's January 1 inventory consists of: rk Category Quantity Cost per Unit Total Cost Portable Midsize Flat-screen 6,000 7,800 2,900 16,700 $110 660,000 275 2,145,000 440 1,276,000 $4,081,000 Study During 2017, the company had the following purchases and sales. Quantity Quantity Selling Price Category Purchased Cost per Unit 14,700 20,100 10,100 44,900 Sold 14,000 23,900 per Unit Portable Midsize Flat-screen $121 330 550 $165 446 660 6,000 43,900 Calculate price index. (Round price index to 4 decimal places, e.g. 1.4562.) Price index