4 Part 3 Milos wanted to better results, so he asks Berat, an experienced forecasting specialist, to apply Gompertz Model to the given data. Assist him to analyze the market and create the sales model, use the Gompertz parameters a 1, b 0.06, k-5. L What is the estimated yearly sales of 20267 . Part 4 I What is the difference in sales between the Exponential trendline and the Gompertz Model for the year 2023? (Report a positive value.) if the average price of one smart home product is 2000, report the first year when the expected total revenue exceeds 3,952,000,000 according to Gomperta The company aims to reach a 50% market penetration in the third quarter of 2025 by only changing the rate of acceptance. Report the acceptance rate. (This question is Independent.) Berat wanted to evaluate different scenarios in order to be prepared for every alternative scenarios in the market. Help him. (Each question is independent from each others.) (Remark: use the Gompertz parameters a 1, b 0.06, k 5.) (Remark: Each question is independent from each other.) Scientists have announced that they are expecting a new variant of Covid-19 and with the new deadly version of the Covid-19, the population is expected to decline by 5% in 2023. Report the difference between the second half sales, before this assumption and after this assumption in 2024 according to Gompertz (Report a positive value.) With the increase in the euro/lira rate, the smart home appliances sector was negatively affected. Therefore, potential percentage of buyers were reduced to 25%. In order to generate the same yearly revenue in 2026, what should be the new price? (Remark: Old price is same with Part3.3) Using Solver, find the band k values that minimize the sum of squared errors in market penetration, between Gompertz and the actual data Report the parameters' new values Part 5 Berat asks you to answer the following questions about Gompertz Curve. What does the "b" value represent in the Gompertz formula? How does a higher "k" value affect the Gompertz curve? Click xfx Click Here M TABLE Men Back 230030 SABLE AF Sale 600 S(t)=ae Gompertz Curvepertuary MIR LAUS AN THIN WELL 100 A N S of 2018 as 04 91 a 2018 as 04 05 02 2020 9 1134 UMAN Q Qt REAS 22 138345 4434 3021 Q 03 L 324 2022 a 04 447 Q Q Q 94 Q 02 2034 a 01 Q 3125 as 2036 04 Q1 47 LAST 213 143 A 150% M keb Patty T 41 REME WAD LAT 4 M ANT ww 10 " M " AF A " CAIT W " 6352 H 21 2 UN 21 M L LINJUR M PA AMATER " 54 MLABOR ww Seco Degree P