Case Analysis 1. For each Product, create calculations for Sale Price, Profit Amount, and Profit Margin using the following formulas: Sale Price G6:G8, G10:G12 Retail Price - (Retail Price * Percent Off) Profit Amount H6:H8,H10:H12 Sale Price less Cost Profit Margin 16:18: 110:112 Profit Amount divided by Sale Price 2. Based on the results of the above calculations, answer the following questions by highlighting the correct response. Based on the results of the above calculations, answer the following questions by highlighting the correct response. 1 Which item has the greatest profit margin? a. 27 Monitor b. Solid Oak Computer Desk c. Executive Desk Chair 2 If the Markup Rate on the 27 Monitor was reduced to 50%, what is the effect on Retail Price? a. Retail price decreases from $357.83 to $192.50 b. Retail price decreases from $357.833 to $292.50 c. Retail price increases from $357.83 to $392.50 3 If the Markup Rate for the Solid Oak Computer Desk was reduced to 150%, what is the effect on the Profit Margi a. Profit margin decreases from 50% to 43% b. Profit margin increases from 50% to 45% c. Profit Margin decreases from 50% to 40% 4 What happens to the Profit Margin when the Markup rate is increased on any item? a. Profit Margin increases b. Profit Margin decreases c. Profit Margin stays the same 5 What happens to the Profit Margin when the Percent Off rate is increased on any item? a. Profit Margin increases b. Profit Margin decreases c. Profit Maroin stavs the same ults of the above calculations, answer the following questions by highlighting the correct response. 1 Which item has the greatest profit margin? a. 27 Monitor b. Solid Oak Computer Desk c. Executive Desk Chair 2 If the Markup Rate on the 27 Monitor was reduced to 50%, what is the effect on Retail Price? a. Retail price decreases from $357.83 to $192.50 b. Retail price decreases from $357.8f3 to $292.50 c. Retail price increases from $357.83 to $392.50 3 If the Markup Rate for the Solid Oak Computer Desk was reduced to 150%, what is the effect on the Profit Margin? a.Profit margin decreases from 50% to 43% b. Profit margin increases from 50% to 45% c. Profit Margin decreases from 50% to 40% 4 What happens to the Profit Margin when the Markup rate is increased on any item? a. Profit Margin increases b. Profit Margin decreases c. Profit Margin stays the same 5 What happens to the Profit Margin when the Percent Off rate is increased on any item? a. Profit Margin increases b. Profit Margin decreases c. Profit Margin stays the same 6 What might need to be done to the Computer System Markup Rates and Percent Off rates to get the Profit Margin to at least 30% ? a. Increase the Markup Rate and increase the Percent Off rate b. Decrease the Markup Rate and decrease the Percent Off rate c. Increase the Markup Rate and decrease the Percent Off rate d. Decrease the Markup Rate and increase the Percent Off rate