Comments

$])$:$\}$

$[$ Data $])$:$\}$

$[$ Chart Type $])$:$\}$

$[$ Chart

c

Format Chart Area

MyEducator Tasks

a$.$ Use the values in range B$37$:B$57$

as the values for Price.

b$.$ Use the values in range $(36$:E$36)$ as the values for Advertising Budget.

c$.$ Reference the profit calculation in cell F$12).$

$7$

$8\mathrm{.}3$ Complete the Price, Advertising, and Profitability chart.

a$.$ Notice that the series for $$25,000,000$ is already on the chart.

b$.$ Add the series for advertising budgets $$50,000,000$ and $$75,000,000$ from your data table to the chart.

$4$

$9$ Consider the one$-$way data table. What is the optimal supplier contract?

$$0$

$$10$ Million

$$20$ Million

$$30$ Million

$$40$ Million