Question 4 30 points Save Answer Please create a spreadsheet for the following question. You will need to save the spreadsheet on your computer and then upload/attach the file to this question. The December 31, 2014 Inventory of Gwynn Company consisted of four products, for which certain information is provided below. ( 30 points) Replacement Estimated Expected Normal Profit Product Original Cost Cost Disposal Cost Selling Price on Sales A $25.00 $22.00 $6.50 $40.00 20% B $42.00 $40.00 $12.00 $48.00 25% $120.00 $115.00 $25.00 $190.00 30% D $18.00 $15.80 $3.00 $26.00 10% Instructions Using the lower-of-cost-or-market approach applied on an individual-item basis, compute the inventory valuation that should be reported for each product on December 31, 2014