please help with filling in the yellow blanks. if you are just going to give an explanation then please dont answer the question. i appreciate it and thank you.
SHEET ROADMAP 7 This entire Sheet is Required Homework. \begin{tabular}{|c|} \hline 8 \\ \hline 9 \\ \hline 10 \\ \hline 11 \\ \hline 12 \\ \hline 13 \\ \hline 14 \\ \hline \end{tabular} Decision To Be Made This is a situation where granular historical data was not available You will cobble together avalable data into a model to analyze what had happened with respect to channel mix and pricing. You will apply the model to analyze future marketing strategies including channel focus and pricing. Strategic Considerations \& KPIs Industry structure, competitive costs, distribution channels, units, price, unit cost, financials Occasionally, we develop a model to better understand past performance in cases where all of the underlying data is not discoverable. We bulld the model to indentify key performance indicators (KPIs) and understand the strategic relationships that might inform forward looking decisions. An understanding of what has happened is fundamental and critical to formulating a business strategy. This 'MODEL Marketing Strategr' case provides an example of this. In this case we are 'modeling' history to develop an understanding of what has happened. While we do not make any forward looking decisions in this case, the analysis you perform of the Direct distribution channel should lead you to some strategic conclusions about the company's forward-looking distribution decisions and its impact on the company's future pricing and costs. Enter formulas in the yellow cells to create a model. \begin{tabular}{|c|c|c|c|c|} \hline \multirow[b]{2}{*}{2019} & \multicolumn{3}{|c|}{ Sole Competitor } & \multirow[b]{2}{*}{ CAGI } \\ \hline & 2020 & 2021 & 2022 & \\ \hline & & & & cos \\ \hline & & & & on \\ \hline & & & & os \\ \hline 1 & & & & on \\ \hline & & & & on \\ \hline & & & & oN \\ \hline 2019 & 2020 & 2021 & 2027 & caca \\ \hline 190 & 180 & 170 & 160 & 6s \\ \hline 125 & 125 & 125 & 125 & on \\ \hline & & & & on \\ \hline & & & & on \\ \hline & & & & os \\ \hline \end{tabular} Gos Profit Model Unitcost Direct Channel cost of Arvenues Metat Ohanfiel Cont of Revenues Dired Channet Cosi Prefl Retall Chamet Gross Profes Total Cros Prolit Total Cooss Margin Use the model you have created to answer the following questions. What was the CACR of the "Tstimated Total Market Sise in Units? What was the CMGR of the Direct Channet: Market Sise' in Units? What win the CAGh of the competitor's 'Total Revenues'? What was the CAGS of the compethor's Direct Oramel Fice