Please show work in excel.

P9-2 (Lower-of-Cost-or-Market) Garcia Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and condominium complexes in northern New Jersey and southern New York. The company is in the process of preparing its annual financial state- ments for the fiscal year ended May 31, 2014, and Jim Alcide, controller for Garcia, has gathered the following data concerning inventory. At May 31, 2014, the balance in Garcia's Raw Materials Inventory account was $408,000, and Allowance to Reduce Inventory to Market had a credit balance of $27,500. Alcide summarized the relevant inventory cost and market data at May 31, 2014, in the schedule below. Alcide assigned Patricia Devereaux, an intern from a local college, the task of calculating the amount that should appear on Garcia's May 31, 2014, financial statements for inventory under the lower-of-cost- or-market rule as applied to each item in inventory. Devereaux expressed concern over departing from the historical cost principle. Net Realizable Value Aluminum siding Cedar shake siding Louvered glass doors Thermal windows Total Cost $ 70,000 86,000 112,000 140,000 $408,000 Replacement Cost $ 62,500 79,400 124,000 126,000 $391,900 Sales Price $ 64,000 94,000 186,400 154,800 $499,200 $ 56,000 84,800 168,300 140,000 $449, 100 Normal Profit $ 5,100 7,400 18,500 15,400 $46,400 Instructions (a) (1) Determine the proper balance in Allowance to Reduce Inventory to Market at May 31, 2014. (2) For the fiscal year ended May 31, 2014, determine the amount of the gain or loss that would be recorded due to the change in Allowance to Reduce Inventory to Market. (b) Explain the rationale for the use of the lower-of-cost-or-market rule as it applies to inventories