1.ABC chemical factory produces different detergent, cosmetic and similar products. After cases of Covid-19 pandemic are reported in the country, the demand for disinfectant chemicals and hand sanitizer has boomed and some companies have been producing it before COVID-19. Due to the increase in demand, ABC started producing the sanitizer and distributes throughout major cities in the country. The following table shows weekly demand data and identified determinant variables in 30 major cities.The second table also shows the weekly total sales of 1-liter hand sanitizer for the past 3 months.

THE DATA IS ATTACHED UNDER HERE

1. ABC chemical factory produces different detergent, cosmetic and similar products. After cases of Covid-19 pandemic are reported in the country, the demand for disinfectant chemicals and hand sanitizer has boomed and some companies have been producing it before COVID-19. Due to the increase in demand, ABC started producing the sanitizer and distributes throughout major cities in the country. The following table shows weekly demand data and identified determinant variables in 30 major cities. The second table also shows the weekly total sales of 1-liter hand sanitizer for the past 3 months. Sanitizer Demand (1 Litre) Company Maj Week Pric Competi adv or ly e in tors ert citi Dema Birr price in cost es nd Birr 1 1290 137 94 814 2 1177 147 81 896 3 1155 149 89 852 4 1299 117 92 854 5 1166 135 86 810 6 1186 143 79 768 7 1293 113 91 978 8 1322 111 82 821 9 1338 109 81 843 10 1160 129 82 849 11 1293 124 91 797 12 1413 117 76 988 13 1299 106 90 914 14 1238 135 88 913 15 1467 117 99 867 16 1089 147 76 785 17 1203 124 83 817 18 1474 103 98 846 19 1235 140 78 768 20 1367 115 83 856 21 1310 119 76 771 22 1331 138 100 947 23 1293 122 90 831 24 1437 105 86 905 25 1165 145 96 996 26 1328 138 97 929 27 1515 116 97 100 0 28 1223 148 84 951 29 1293 134 88 848 30 1215 127 87 891 for ABC Househo ld income (annual) 53123 51749 49881 43589 42799 55565 37959 47196 50163 39080 43263 51291 38343 39473 51501 37809 41471 46663 55839 47438 54348 45066 44166 55380 38656 46084 52249 50855 54546 38085 A. Estimate the demand using regression based on the data provided B. Show the interpretation of the results, the coefficients, significance of the result and explanatory power of the regression model C. Based on your estimate results forecast weekly demand for the following new markets (cities) with the characteristics given. Forecast the demand for New markets (cities) New Price of Competitors Advert Househo Cities sanitizer price in birr cost ld in birr income AA 115 90 790 41234 AB 122 101 812 39845 AC 116 87 905 47543 AD 140 82 778 53560 AE 133 79 996 39870 D. Based on the given sales volume of ABC's sanitizer product for 16 weeks, construct the trend projection using graphs, 3 weeks moving average, and Wee Sanitizer exponential smoothing methods. ks sales 1 5600 2 5200 3 4570 4 4305 5 5465 6 8900 7 15680 8 24680 9 35040 10 36500 11 38575 12 35300 13 35200 14 35150 15 34950 16 34500