Fornula: Subtract; Cell Referencing BE9.4 - Using Excel to Determine Lower-of-Cost or Market Inventory Amounts Presented below is information related to Rembrandt Inc.'s inventory, assuming Rembrandt uses lower-of-LIFO cost-or-market. \begin{tabular}{lrrr} \hline Per Unit Amounts & \multicolumn{1}{c}{ Skis } & \multicolumn{1}{c}{ Boots } & \multicolumn{1}{c}{ Parkas } \\ \hline Historical cost & $190.00 & $106.00 & $53.00 \\ Selling price & 212.00 & 145.00 & 73.75 \\ Cost to distribute & 19.00 & 8.00 & 2.50 \\ Current replacement cost & 203.00 & 105.00 & 51.00 \\ Normal profit margin & 32.00 & 29.00 & 21.25 \end{tabular} Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area, along with mathematical formulas for any amounts not given. Determine the following to be used in the lower-of-cost-or-market computation. (a) The two limits to market value (ceiling and the floor) for skis (b) The cost amount that should be used for boots Cost (c) The market amount that should be used for parkas \begin{tabular}{|l|l|l|l|l|} \hline Ceiling & Floor & ReplacementCost & DesignatedMarket \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular}