Construct an Excel model with solver to solve for the profit maximizing levels of price and quantity for the profit function, Z = q x p - cf - q * cv, where cf = 8000, cv = 6, and the demand function for the product is q = 2400 - 24p. Illustrate the solution with a graph of the profit function, showing the profit maximizing price level. (1%)

Construct an Excel model to solve for the profit maximizing price of B2 which is P2 when Firm 2 expects P1 to be 10. (.5%) please tell me how should I finish part-b thanks.

B9 X V fx =(2544* A9)-(24* A942)-22400 A B C D E F G H IN 0 -22400 5 - 10280 profit 10 640 15 10360 50000 20 18880 400 00 25 26200 30000 30 32320 35 37240 20000 10 40 40960 10000 11 45 43480 12 50 44800 10 20 30 40 50 60 70 80 90 55 44920 10 0 00 13 14 60 43840 -20 0 00 15 65 41560 -30 0 00 16 70 38080 17 75 33400 18 80 27520 19 20 21 22 Price Profit Profit Price Quantity 23 45016 53 1128 24 0 -22400 25 26 27 28 Price Profit 29 45016 30 22400 31 32 Demand 33 120 34 Price Profit 35 2400 10 36 100 0 80 37 38 60 39 40 40 41 20 42 0 43 500 1000 150 0 2000 2500 3000 44 45 48