Currently, you sell 40,000 units of a product for $45 each. The unit variable cost of producing the product is $5. You are thinking of cutting the product price by 30%. You are sure this will increase sales by an amount from 10% to 50%. Perform a sensitivity analysis to show how profit will change as a function of the percentage increase in sales. Ignore fixed costs.

Please show in excel and show formulas used and explanations on why formulas were used. Thank you.