Step $5$: Sensitivity Analysis. There are two big unknowns: $1)$ product quality and $2)$ penetration rate. So create a What If table to show sales forecast under various assumptions.

Product Quality

Penetration "Excellent

Product" "Average

Product" Mediocre Product Fill in the chart to show what sales will be depending on product quality and penetration rate

$5\%$ Start by copy$/$paste Tru Earth sales in the baseline case $(11\%$ penetration$)$

$11\%$ Then rerun the entire analysis with $5\%$

$15\%$ Then rerun the entire analysis with $15\%$

Is Tru Earth likely to hit the $$12$M hurdle?

Insight: would your conclusion change if you had use different assumptions for repeat purchases $($line $32$ above$)?$ For example, the Pasta repeat assumptions? Based on the research, what do you think perceived product quality will be$?$ What other factors emerged from the research that would inform your opinion about what sales volume is likely to be$?$