Thu Feb $8,15$:$27$

Comments

Share

dation

H$?$

What$-$If

Analysis

$$

Subtotal

Analysis Tools

Data Analysis

MyEducator Tasks

cullualls

$8\mathrm{.}1$ Create a one$-$way data table for profit at different levels of supplier contract in range B$22$:C$33).$

a$.$ Ensure that the price in cell $(3)$ is $$290$ and the advertising budget in cell C$5)$ is $$35,000,000($you may need to manually adjust these values$).$

b$.$ Use the values in range B$23$:B$33)$ as the different levels of the supplier contract.

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

d$.$ Notice the Supplier Contract and Profitability chart updates with the values in the data table to visually demonstrate the relationship between supplier contract amounts and the profitability.

$8$

$8\mathrm{.}2$ Create a two$-$way data table

$8\mathrm{.}3$ Complete the Price,

$9$ Consider the one$-$way data table. What is the