MODEL Markebine Strateer You are analyaine a company that selb replacement windows, its only product The compary has only one competitoc: As a reminder from Economics, an indartry with wath orly two playen is cal a 'docoply'. Boch companies seli throuch two distribution chantels: Retat Clannel-seling indred Erough retallen surh as Home Depot and towes Before conttructing the model the compary had a qualtative thowlede of signifant chaneri oxtining in the induntry. (These are observed phenomena and unmeaiured.) - The overall market has been crowine relativelir quicky - There has been a broad wift from the retalchannel to the diect (e-commerce) channel. Nerther cempary moorts francial data beyond the data required in their 10 Kreporive. Average prices by channel are wrallable trom a price das infomation service. Whot is o Direct Chaninel? Indrect seline may indude Datritutors, Fufilment andor Fetal sales. Enter formulas in the yellow cells to create a model. Industry Unit Model Estimated Total Market Sue in Unts Growth late Estimated Percent Direct Channel Direct Oannel Market Size in Units Fetail Channel Market Size in Units Direct Ohannel: Market Share Retail Channel Market Share Dinect Channel: Unita Sold. Retail Chanrel. Units Sold. Totalunes sold Revenues Model Ourect Channel: Pitce Fetal Channel: Price Direct Ohamel, Revenues Retail Clannet: Revenues Total Revenues Gross Profit Model Unit Cost Direct Channel Cost of Revernues Retal Ohamel: Cost of Revenues Direct Channet Gross Profit Retail Channel: Gross Profit Total Gross Profit Total Grosi Margin EAIT (Operating Prefit) Model Direct Channel SGSA Percent Petall Channel SGBA Percent Direct Chanhel: SG8A Retal Oannel SGSA Direct Channel Ebil Retal Channel: reat Total EAT \begin{tabular}{|c|c|c|c|c|} \hline \\ \hline 2019 & 2020 & 2021 & 2022 & CAGA \\ \hline 620 & & & . & 15% \\ \hline & 15% & 15% & 15% & \\ \hline 33% & 40% & 48% & 58% & 20% \\ \hline & & & & 0x \\ \hline & & & & on \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & = & Company & & \\ \hline 2019 & 2020 & 2021 & 2022 & CAGA \\ \hline 500 & 45% & 40% & 35% & 11% \\ \hline \multirow[t]{4}{*}{70N} & 75% & 80% & BSK, & 7x \\ \hline & & & & ox \\ \hline & 4 & & & ON \\ \hline & & & & ow \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & & & & os \\ \hline 2019 & 2020 & 2021 & 2022 & CAOH \\ \hline 200 & 200 & 200 & 200 & on \\ \hline \multirow[t]{4}{*}{125} & 125 & 125 & 125 & \\ \hline & & & & on \\ \hline & & & = & ax \\ \hline & & & & ax \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multirow[b]{2}{*}{2019} & \multicolumn{3}{|c|}{ Sole Competitor } & \multirow[b]{2}{*}{ CAGR } \\ \hline & 2020 & 2021 & 2022 & \\ \hline & & & & os \\ \hline & & & & ON \\ \hline & & & & ON \\ \hline \multirow[t]{3}{*}{} & & & & ON \\ \hline & & & & os \\ \hline & & & & os \\ \hline 2019 & 2020 & 2021 & 2022 & CAGR \\ \hline 190 & .180 & 170 & 160 & -65 \\ \hline \multirow[t]{4}{*}{125} & 125 & 125 & 125 & os \\ \hline & & & & os \\ \hline & & & & ox \\ \hline & & & - & os \\ \hline & & & & * \\ \hline \\ \hline \multirow[t]{9}{*}{2019} & 2020 & 2021 & 2022 & CAGN \\ \hline & & - & & on \\ \hline & & & & cos \\ \hline & & + & & On \\ \hline & + & & & os \\ \hline & & & & ion \\ \hline & & & & oss \\ \hline & + & +2 & & +4 \\ \hline & & & & = \\ \hline 2019 & 2020 & 2021 & 2022 & CAGR \\ \hline 10N & 10% & 10k & 105 & \\ \hline \multirow[t]{6}{*}{5%} & 5% & SW & 5x & \\ \hline & & & & on \\ \hline & & & & on \\ \hline & & & & os \\ \hline & & & & ON \\ \hline & & & - & os \\ \hline \end{tabular} \begin{tabular}{r} CAGR \\ ON \\ ON \\ ON \\ ON \\ \hline OK \\ \hline ON \\ \hline CAGR \\ \hline ON \\ \hline ON \\ \hline ON \\ \hline ON \\ \hline OS \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline 2019 & 2020 & 2021 & 2022 & CAGR \\ \hline \multirow[t]{7}{*}{100} & 100 & 100 & 100 & of \\ \hline & & & & \\ \hline & & & & os \\ \hline & & & & =0x \\ \hline & & & & . 0K \\ \hline & & & & OW \\ \hline & & & & 2+x \\ \hline 4 & & & & \\ \hline 2019 & 2020 & 2021 & 2022 & CAGR \\ \hline 10N & 106 & 10x & 10 & \\ \hline \multirow[t]{4}{*}{5%} & 5N & 5% & 5x & \\ \hline & & & & os \\ \hline & & & & os \\ \hline & & & & ON \\ \hline & - & & & os \\ \hline & q & + & & os \\ \hline \end{tabular} What was the CAGR of the competitor's 'Total Revenues'? What was the CAGR of the competitor's 'Direct Channel: Price'? What was the CAGR of the company's 'Total EBIT'? Did either company eam the majority of EBIT in Direct Channel