ZenteinBars$\_$Case$\_$Worksheet$\_$Blanks$-1$

Insert

Page Layout

Formulas

Data

Review

View

Cut

Verdana

$9$

Wrap Text

General

Copy

Merge & Center

Format

B

I

$U_{?}$

Z

A

A

$A=$

$=$

$=$

$$

$.$

$$

$\frac{1}{1}=2$

$2$

$x$

$$

Cell

Insert

Delete

ce Update To keep up$-$to$-$date with security updates, fixes, and improvements, choose Check for Updates.

ivate Microsoft $365$ to Create and Edit Activate Microsoft $365$ to Create and Edit

Zentein Nutrition Bars Contribution Analysis and Projected Profitability

B

Zentein Nutrition Bars Contribution Analysis and Pipected Profitability See rows $56$ to $61$ for suggested completion steps.

Be sure you are using the "Average order" #s from above $($rather than "single box." Be sure you are using the "Average order" #s from above $($rather than "single box."

Activate Microsoft $365$ to Create and Edit Activate Microsoft $365$ to Create and Edit

A

B

Zentein Nutrition Bars Contribution Analysis and Projected Profitability

See rows $56$ to $61$ for suggested completion steps. Step $1$: Identify variable costs $($rows $6$ thru $10)$ and calculate the total variable costs $($row $11)$ for the Company Website $($Single Box$)$ distribution channel $($columns E$)$

Step $2$: Identify fixed costs $($rows $15$ thru $21)$ and calculate the total fixed costs $($row $22)$ for the Company Website $($Single Box$)$ distribution chaimel $($columns E$).$

Step $3$: Repeat steps $1$ and $2$ for the distribution channes represented in columns F thru I.

Ready

Accessibility: Investigate