Please show formulas and keep in the same format The Blue is given and the rest is where I can not find the correct answer. any help please

That is all I can zoom in but all the information is in the screenshot

A B C E F G 1 N P R S 1 2 2 3 4 5 6 7 8 9 J K L M 0 Q The Problem The cost of setting up the production line depends on the built-in capacity and it is $2 per unit of line capacity. The variable cost of production per unit is $40. We need to determine the optimal capacity at which the production line must be set up and the price per unit at which the product should be sold such that the total profit is maximized. Demand 500 400 Problem #1 Variable cost per unit 40 Price Capacity costlunit 2 65 70 a. Demand function (5 points) 75 80 85 Insert the plot of demand and price here. Constant Elasticity Demand 325 280 275 From past records we have five price points and the corresponding demands. Fit a constant elasticity demand function and use the coefficients to determine the demand function. a. Set up a plot for demand and price and copy paste the demand function coefficients. Use B11 for the constant and C11 for the elasticity. Set up the model for total profit with an initial trial value of 400 for the capacity of the production line. Note that any demand over the line capacity is lost. c. Using GRG Non-linear Solver determine the price at which profit will be maximized. d. Run SolverTable with capacity starting from 250 to 450 in increments of 10. At what capacity level would the profit be maximized? What is the price and profit? Explain. 10 11 12 13 14 15 16 17 18 19 20 21 22 22 600 SOD 400 . 300 200 y.238,124,8511620 100 24 25 26 27 28 29 30 31 32 0 10 20 30 40 50 60 70 80 90 Price per Unit G H J K L M N 0 P R S B C E F 33 Constant Elasticity 34 8,238, 124.85 -2.33619 35 36 37 38 b. Pricing model Price 375 40 Demand 8237248.78 Revenue $ 0 41 Capacity cost 800 42 Capacity 400 Variable cost 16000 43 Sales (Units) 0 Profit $ -16800 44 45 d. State your answer to (d) below. Justify the answer to fit the box below. (10 points) 46 47 Hint: Sales (units) cannot exceed demand or capacity Ansrerkey: 11290 48 49 50 51 52 53 54 55 56 57 58 59