A Sales Manager designed a series of Split Test experiments for one of his products to determine the optimum customer perceived value and price to reach maximum profitability. The experimental results are shown below:

	Campaign	Product	Cost	Price	Sales Volume
	1	Std A	$ 9.50	$ 12.79	1100
	2	Std A	$ 9.50	$ 22.38	800
	3	Std A	$ 9.50	$ 39.17	500
	4	Std A	$ 9.50	$ 68.55	200
	5	Std A	$ 9.50	$ 88.49	75
	6	Std A	$ 9.50	$ 119.96	20

Based on the test results, determine the optimum price point for the Std A product in the current market.

Please upload an Excel spreadsheet containing the following:

Solution #1:

1. Solution based on linear regression for volume prediction

2. Chart showing predicted profit over the price range

3. Solver predicted optimum profit for the given model

Solution 2:

1. Solution based on 2nd order polynomial regression for volume prediction

2. Chart showing predicted profit over the price range

3. Solver predicted optimum profit for the given model