I need help in this question. Please solve this question on EXCEL as i posted it below. Please show me all the formulas and also if use any method like SOLVER or so, please show me the steps so i can do it myself. PLEASE DON'T COPY WRONG OR UNRELATED QUESTIONS/SOLUTIONS FROM CHEGG... Please answer this one as i posted in excel

excel sheet for part A:

excel sheet from part B :

The Links Company sells its golf clubs at golf outlet stores throughout the United States. The company knows that demand for its clubs varies considerably with price. In fact, the price has varied over the past 12 months, and the demand at each price level has been observed (shown in the Excel file "Answer Sheet"). The demands in column C are in hundreds of units. The cell comment in cell C3 is a reminder of this. The company wants to estimate the relationship between demand and price and then use this estimated relationship to find out the optimal unit selling price. Please answer the following two questions: (a) Use the power function to fit the relationship between customer demand and the selling price; Draw the fitting chart, find out constant (parameter a) and exponent (parameter b), calculate MAD, RMSE and MAPE. (b) Using the result from question (a), build a two-way data table to conduct a sensitivity analysis of unit cost and selling price, then find out the optimal (best) selling price when unit cost is $150, $200. $250. $300, and $350 respectively (assuming we only consider the selling price no more than $1200) B C D E F A 1 Demand for golf clubs 2 Month 1 2 6 3 Price 3 4 5 Demand 28 450 300 48 440 26 7 4 360 42 49 8 00 5 5 290 9 6 600 18 10 7 340 43 11 00 370 38 12 500 19 STERBREE 9 10 13 490 27 14 11 25 430 390 15 12 39 16 Prediction Absolute percentage error power Squared error Absolute error power power power Power Fitting 17 Curve 18 Power 19 Constant 20 Exponent 21 22 23 24 25 26 27 28 29 30 31 32 MAPE RMSE MAD D E B 1 Profit model, using best fitting power curve for estimating demand 2 3 Power curve (from Question 22.a) 4 Constant 5 Exponent 6 7 Monetary inputs 8 Unit cost to produce (trial value) $250 9 10 Decision variable 11 Unit price (trial value) $400 12 13 Profit model 14 Predicted demand 15 Total revenue 16 Total cost 17 Profit 18 DO $300.00 $350.00 18 19 Maximum profit from data table below, with corresponding best unit price 20 Unit Cost $150.00 $200.00 $250.00 21 Maximum profit 22 Index of Best Price 23 Best price 24 24 $350 25 Data table for profit as a function of unit price (unit cost is along the top, unit price is along the side) 26 Unit Cost 27 $150 $200 $250 $300 28 $260 29 $280 30 $300 31 $320 32 $340 33 $360 34 $380 35 $400 36 $420 37 $440 38 $460 39 $480 40 $500 41 $520 $540 43 $560 44 $580 45 $600 42 46 47 48 49 50 51 52 53 54 55 56 57 $620 $640 $660 $680 $700 $720 $740 $760 $780 $800 $820 $840 $860 $880 $900 $920 $940 $960 $980 $1,000 $1,020 $1,040 58 59 60 61 62 63 64 65 66 67 63 64 65 66 67 68 69 70 71 $960 $980 $1,000 $1,020 $1,040 $1,060 $1,080 $1,100 $1,120 $1,140 $1,160 $1,180 $1,200 72 73 74 75 76