Question

Please step by step like how can I do them by hand

Solve by hand (or you can use Excel). Solving by hand is preferred since you will not have access to a computer duripg the exams or quizzes Sue Higgins, the sales manager at The Boler Corporation, has given you the following information regarding the sales history of one of Boler's products, the Candi Kane: 330 350 300 270 235 220 195 180 a. Plot the quarterly sales data for each year b. What seasonal index for each quarter could be used to forecast the sales of this product for year 4 c. Forecast quarter 2 and 3 for year 4 d. Assume 180 units of demand (actual demand) for year 4 quarter 1 and 185 units for year 4 quarter2 Forecast quarter 1 for year 5 (aap-o4) ABC Corporation has given you the following information sales history. QuarterDemand 5 2016 12 10 20 15 17 32 19 15 17 10 Plot the quarterly sales data for cach year What is the trend and the seasonal index for each quarter? Assume exponential, trend and seasonal smoothing with α-02, β-0.3 andy-04. Forecast the dema for the 2nd and 3rd quarter of 2017 Ifactual demand during the 1 quarter of 2017 is 50, find the updated seasonality index, level and trend 1 quarter 2017 and forecast the second quarter of 2017 a. b. c. d. 3. The following data relate the sales figures of the bar in a small bed and breakfast inn in Portland the number of guests registered that week Week Guests () 16 12 18 14 Bar sales (S 330 270 380 300 a. Perform a linear regression that relates bar sales to guests. How good is the model in predicting sales b. If the forecast is for 20 guests next week, what are the sales expected to be?