Problem 3 1. Create the spreadsheet model only with the linear demand function 2. Use DateTable to calculate profits for specified prices and highlight the best profit 3. Generate a scatter diagram based on the table created in (b) Problem 7.45(a) - Pricing = Mustang (p. 402) Current demand Current price Unit cost Current elasticity Part (a]: linear demand ab New price New demand Profit Price $21,000.00 $21 500.00 $22 000.00 $22 500.00 $23.000.00 $23,500.00 $24,000.00 $24,500.00 $25,000.00 $25,500.00 $26,000.00 $26,500.00 $27,000.00 $27.500.00 $28,000.00 $28,500.00