ZenteinBars$\_$Case$\_$Worksheet$\_$Blanks$-1...$Ex $1-$ DIFM channel shareEx $2-$ PL and brand shareAnalysis $-$ Eco$7$ economicsZentein Nutrition Bars Contribution Analysis and Projected ProfitabilitySee rows $56$ to $61$ for suggested completion steps.All Listed CostsCosts Relevant to $($All$,$ Company Website, or Amazon$)$Company Website Company Website$($Single Box$)($Average Order$)$Amazon$.$CAPhysical RetailStore $($Single Box$)$Physical RetailStore $($AverageOrder$)$Selling PriceVariable costs $($per box$)$Raw Materials $($p$.2)$Ketchen labour $($p$.2)$Shipping $($Website$)($p$.4)$Amazon Referrl Fees $($p$.5)$Fulfillment by Amazon $($FBA$)$ fees $($p$.5)$Total Variable CostsUnit ContributionContribution MarginFixed CostsInsurance $($p$.2)$Kitchen Rent $($p$.2)$Transportaiton $($p$.2)$Website Fees $($p$.2)$Samples $($p$.3)$Social Media Management $($p$.4)$Amazon Seller Subscription $($p$.5)$Total Fixed CostsBreak$-$even point in $($# of average orders$)$Break$-$evet point in $($$ of average orders$)$$$140\mathrm{.}00$$$54\mathrm{.}00$$$35$Don'tNote t$$15$ All$$2$$$12$Company Website$$8$$$8$$$45$$$15$$$2$$$150$$$2.$$$12$$$8$$$29$$$74\mathrm{.}00$$$18\mathrm{.}0038\mathrm{.}89\%$$$2,00051\mathrm{.}43\%$Fixed$$2,000$ All$$1,50051,000$$$840$$$500$$$10,800$$$360$ Amazon$$18,000$$$12,000$$$10,800$$$840$Be car$$10,800$$$44,1402096|2425$The #$$85,432\mathrm{.}26$$$84,855\mathrm{.}56$Projected Profitability$-$ Company WebsiteAnnual OrdersSales $($Total Revenue$)$Less: Variable Costs $($Total$)$Gross Profit$/$ContributionLess: Fixed costsProfit PotentialHigh Projection$1000$Low Projection$900$$$126,00\mathrm{.}00$ Be sure you are using the AVerage order is from above $($rather than "single box."$$74,000\mathrm{.}00$$$44,140$$$22,460\mathrm{.}00$Projected Profitability$-$ Amazon.CaAnnual OrdersSales $($Total Revenue$)$Less: Variable costs $($Total$)$Gross Profit$/$Contribution ess: Fixed CostsProfit PotentialHigh ProjectionLow Projection$40003000$$$162,000\mathrm{.}00$$$63,000\mathrm{.}00$$$40,000\mathrm{.}00$Projected Profitability$-$ Physical Retail Store Partners High ProjectionNumber of StoresAnnual Orders per Store$1226$Total Annual OrdersSales $($Total Revenue$)$Less: Variable costs $($Total$)$Gross Profit$/$Contribution ess: Fixed CostsProfit Potential$$12,520$Low Projection$826208"$Bi$-$weBe sur $|$Be sur$$43,640$Step $1$: Determine whether each cost listed in column C is televant to all distribution channels, only the company website, or only Amazon and record answers in column D$.$ Hint: Refer to the page # next to each 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 channel $($columns E$).$Step $3$: Repeat steps $1$ and $2$ for the distribution channels represented in columns F thru I.Step $4$: Using numbers reported in the case and calculations from upper part of worksheet, fill in rows $27$ thru $32$ for High Projection $($Column C$)$ and Low Projection $($Column D$)$ for the Company Website distributi Step $5$: Repeat step $4$ for the Amazon. CA distribution channel $($rows $36$ thru $41)|$and the Physical Retail Store$-$Average Order distribuion channel $($rows $45$ thru $52).||$