please fill in the yellow blanks

10 in this Workbook you are going to use that model to develop a forecast of the next flscat year. 11 We have added a new column (Column I) in which you can enter your Trypothesired scenario' in the vellow boxes and the moded will forecast the results in the other cells. 12 In this case two competitors distribute through two distribution channels. 13 Distribution channels can include: E-commerce - Internet generated sales direct to customers Value-Added Reseller-retailer that bundles the sale of the product with related services, such as set-up or installation Deater-intermediary between manufacturers and retailers (or buyers and sellers). ec car sales, feal eitate agencies Sales Agents - self-employed agents selling within a specified region EXHIBIT: DISTRIBUTIONCHANNES \begin{tabular}{|c|c|} \hline Directs & company sells itsproduct direct to customers (e. 2 . Tesla) \\ \hline Retail & company sellsits product to retailers who sell to consumers (es. Ford) \\ \hline Wholesalers & company sells its product to wholesaless that resell the product to retailert who sell to consumers \\ \hline E-commerce & Internet generated wles direct to customers \\ \hline Value-Added Reseller & retailer that bundles the sale of the product with related services, weh as set-up or installation \\ \hline Dealer & intermediary between manufacturers and retailers (or buyers and sellers) e e car sales, real estate agencies. \\ \hline Sales Acents & self-employed agents selling within a specified tesion \\ \hline \end{tabular} Source Mrimne Wolk s nichard Herwe The revenues and costs generally vary significantly across distribution channels. The level of service and support often varies across distribution channels. In this Case, you had to develop a model by assuming relationships about data that was not available. Below in row 55 is the model you developed in Developing a Model (Workbook 7 ). We will use the relationships developed in the model to forecast using a hypotheised scenario. Inputs - Total Market Size in Units increases by 258 in the current year. - The trend toword Direct sales reverses and declines to 45 - The Company increased pricing to Retailers to $150 and Refoil Market share declined to soX - The Price to Direct and Oirect Market Share are unchanged - The Unir Cost does not change. - The Oirect SGSA Percent declines to BS becouse the company has improwed its add-spend while Retail SGBA Fercent is unchanged You can see that the formulas other than the yellow boxes in which you enter data in Column I are the ume as in Columns o through G, as the aume relationships perise. 38 inputs 39 - Total Market Size in Units increases by 25% in the current year. -The trend toward Direct solei reverses and declines to 45: - The Company increosed pricing to Retailers to $150 and Retall Market Share declined to sos - The Price to Direct and Direct Market Share are unchanged - The Unit Cost does not change. - The Oirect 3GSA Percent declines to $ becourse the company has improwed its add -spend while Refail SGSA Percent is winchanged In the two grey boxes below we demonstrate how the hypothevind scenario can be entered into the model. in is 7 we hive alrtady entered the hypothesized Growth Alate'. Enter values or formuls in the yellow cells below to develop the forecast. 2019-2022 \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & C & D & E & F & G & H & 1 \\ \hline= & & & & & & & 20192022 & \\ \hline 55 & Industry Unit Model & & 2019 & 2020 & 2021 & 2022 & CAGA & 2023E \\ \hline 5 & \multicolumn{2}{|c|}{ Etimated Total Market Size in Units } & 600 & 660 & 726 & 799 & 100 & 998 \\ \hline 57 & Growth Rate & & & 10x & 10x & 10x & & 25% \\ \hline 58 & Estimated Percent Direct & & 335 & 40x & 48 & & 20x & 458 \\ \hline$9 & Direst Market Sire in Units & & 200 & 264 & 348 & 460 & 32 & 442 \\ \hline 60 & Retail Market Sige in Units & & 400 & 396 & 378 & 339 & 5% & 549 \\ \hline 6 & & & & & & & & \\ \hline 62 & & & & & Company & & & \\ \hline 63 & Compary Unit Models & & 2019 & 2020 & 2021 & 2022 & CAGR & 2023E \\ \hline 64 & \multicolumn{2}{|l|}{ Estimated Oirect Market Share } & 50% & 40% & 30x & 20x & & \\ \hline 65 & \multicolumn{2}{|l|}{ Estimated Retail Market Share } & 70 & 75% & 80% & ss\% & - & \\ \hline 66 & \multirow{2}{*}{\begin{tabular}{l} Direct Units Sold of \\ Retail Units Sold \end{tabular}} & & 100 & 106 & 105 & 92 & 64 & - \\ \hline 67 & & & 280 & 297 & 302 & 283 & 232x & 42 \\ \hline 68 & Total Units Sold & A. & 380 & 403 & 407 & 380 & 716% & \\ \hline 69 & {[} & & & & +1 & & . & \\ \hline 70 & Revenues Model & & 2019 & 2020 & 2021 & 2022 & cach & 2023E \\ \hline 71 & Priceto Direct & & 200 & 200 & 200 & 200 & os & \\ \hline 72 & Priceto Retaliers & & 125 & 125 & 125 & 125 & ox & \\ \hline 73 & Direct Revenues & Di & 20,000 & 21,120 & 20,909 & 18,400 & 3 & . \\ \hline 74 & Retail Revenues & & 35,000 & 37,125 & 37,752 & 35,977 & 18 & \\ \hline 75 & Total flevenues & & 55,000 & 58,245 & 58,661 & 34,377 & ox & =0 \\ \hline 76 & & & & & & +4 & & \\ \hline 77 & & - & & & & & & \\ \hline 78 & Grows Profit Model & -7 & 2019 & 2020 & 2021 & 2022 & CAGR & 2023 \\ \hline 79 & Unit cost & & 100 & 100 & 100 & 160 & & \\ \hline 8 & Direct cost of Revenues & & 10,000 & 10,560 & 10,454 & 9,200 & 3x & \\ \hline 81 & Retail Cost of Revenues & & 28,000 & 29,700 & 30,202 & 28,712 & 18 & . \\ \hline 82 & Direct Gross Proff: & & 10,000 & 10,560 & 10,454 & 9,200 & 3x & \\ \hline 83 & Retail Gross Profit & & 7,000 & 7,425 & 7,550 & 2,195 & is &. \\ \hline & Total Cross Profit & & 17,000 & 17,955 & 18,005 & 16,395 & 4x & - \\ \hline & & & & & 4 & & x & \\ \hline & Operating Proft Model & & 2019 & 2020 & 2021 & 2022 & CACA & 2023t \\ \hline 8 & Direct SGEAPercent & & 10N & 10x & 10 & 10N & 8 & \\ \hline & Retail SGEAPercent & & 5N & 5x & 5% & 5 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & \begin{tabular}{l} A \\ Totarouss \end{tabular} & B & c & DIrovou & \begin{tabular}{l} E \\ 117,905 \end{tabular} & \begin{tabular}{l} F \\ xo,0us \end{tabular} & G & H & I \\ \hline 85 & x2+x2 & & & & & 3 & & & \\ \hline 86 & Operating Profit & Model & & 2019 & 2020 & 2021 & 2022 & CAGR & 2023E \\ \hline 87 & DirectSG\&A & Percent & & 10x & 10% & 10x & 10% & & \begin{tabular}{r} \\ \end{tabular} \\ \hline 88 & Retail SG\&A & Percent & & 5% & 5% & 5% & 5% & & \\ \hline 89 & Direct SG\&A & & & 2,000 & 2,112 & 2,091 & 1,840 & 3x & \\ \hline 90 & Retail SG8A & & & 1,750 & 1,856 & 1,888 & 1,799 & 18 & . \\ \hline 91 & Direct EBrT & & & 8,000 & 8,448 & 8,364 & 7,360 & 3x & . \\ \hline 92 & Retail EBrr & & & 5,250 & 5,569 & 5,663 & 5,397 & 18 & . \\ \hline 93 & Total EBrT & & & 13,250 & 14,017 & 14,026 & 12,756 & -16 & . \\ \hline 94 & & & & & & & & & \\ \hline 95 & & a & & & 10 & & & & \\ \hline 96 & & is & & 3. & 12 & & & & \\ \hline 97 & & & & & & 3 & B & & \\ \hline 98 & + & the & & & & & 5y & & 3 \\ \hline 99 & & & 3 & & & 8 & & & \\ \hline 100 & & & & & & & & & \\ \hline 101 & & .3 & & & & . & & & \\ \hline 102 & & & & & & & & & \\ \hline \end{tabular}