Mini Case 2 Eli Orchid has designed a new pharmaceutical product, Orchid Relief, which improves the night sleep. Before initiating mass production of the product, Eli Orchid has been market-testing Orchid Relief in Orange County over the past 8 weeks. The daily demand values are recorded in the Excel file provided. Eli Orchid plans on using the sales data to predict sales for the upcoming week. An accurate forecast would be helpful in making arrangements for the company's production processes and designing promotions. The COO of the company approved the initial analysis and asked for the following extensions': To fit a new multiple regression model d = 0.6227 *t - 148.1388 x, - 135.0115 x2 -108.0092x; - with dummy variables for weekdays 117.3819 x4 -71.6296 x, + 2.1227 x;+ 433.6352 (not the weekend ), and to provide the regression equation (d = a*t + bix, + Adjusted R*= 0.9517 b,x, + box, + b.x, + b,x, + box; + c), along with Adjusted R'. To use all three models: M1 M2 M3 M1: d = 1.0356t + 339.29 Mon. 398.3192 355.8565 320.9898 M2 : Tue 399.3548 356.5728 334.7398 d = 0.7163t + 116.7679w + 315.02 Wed 400.3904 357.2891 362.3648 62 Thu. 401.4260 358.0055 353.6148 M3: (the one considering Fri. 402.4616 358.7218 399.9898 weekdays) Sat. 403.4972 476.2060 474.3648 Sun 404.5328 476.9223 472.8648 to predict the demand for seven days TOTAL: 2809.9820 2739.5739 2718.9286 ahead (Mon , Tue , ..., Sun )and find the total weekly demand Take advantage of the fact that new New: M: 311 T: 341 W: 357 Th: 363 F: 390 Sa: 490 Su: 492 demand data became available and MAPE : 0.1522 use this new data to compare the MAPE M2: 0.0491 forecasts using MAPE for days 57-63. MAPE : 0.0268 To provide a line chart with the actual Daily Demand Forecast demand (including the new data) and M2 and M3 . * Round numbers to four decimal points (e.g. 0.1234), unless explicitly requested otherwise