The director of the Riley County, Kansas, library system would like to forecast evening patron usage for next week. Below are the data for the past 4 weeks: Week 1 Week 2 Week 3 Week 4 Mon 210 215 220 225 Tue Wed Thu Fri Sat 215 160 180 213 165 185 178 250 180 250 176 260 220 175 190 260 225 176 190 178 a) Calculate a seasonal index for each day of the week (enter your responses rounded to three decimal places). Mon Tue Wed Thu Fri Sat Day of the week Seasonal index b) Let x = 1 for Monday of Week 1. If the trend equation for this problem is: y=201.74 +0.18x, the forecast for each day of week 5 is (round your responses to the nearest whole number): Mon Tue Wed Thu Day of week 5 Forecast Fri Sat

Don't use Ai

Asvnch Problem - Statistical Forecasting Data Set – Eunice BC Fashion Monthly Sales, in million units. Year Total Sales Year Total Sales 2010 38 2016 43 2011 41 2017 40 2012 40 2018 45 2013 45 2019 47 2014 50 2020 42 2015 42 2021 48 Questions: a. Find the naïve forecast. b. Use the 3 years moving average forecast. c. Have a 5 years weighted moving average. d. Develop forecast using exponential smoothing with a = 0.2. e. Determine the trend line equation and present the forecast. f. Find the best forecast for year 2022. Note: Use the first 5 years as the training samples and the last 5 years as the forecasting samples. Solve it in Excel Sheet/Sheet with Equations as possible.

Period 1 2 3 4 5 New Accounts Period 201 215 212 229 236 6 7 8 9 10 New Accounts Period 233 249 253 254 268 11 12 13 14 15 New Accounts 282 276 281 289 311

ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows:    Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using a five-month moving average approach.

You manager gave you February 2021 actual sales and sales forecast. This is the only raw data you have access to. Which of the following is the most appropriate technique for forecasting March 2021's sales? a.Simple moving average b.Exponential smoothing c.Causal relationship forecasting d.Simple linear regression e.Weighted moving average

The Toro Cutlery Company has collected monthly sales information below: MONTH January February March April The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): 87667 Forecast (January, 4-month MA): 72500 Forecast (January, 5-month MA): 69600 b. What will the forecast be for January the following year using exponential smoothing with a = 0.6? Assume the forecast for February this year is 25,000. Do not round intermediate calculations. Round your answer to the nearest whole number. SALES 25,000 18,000 43,000 110,000 MONTH May June July August SALES MONTH 84,000 September 28,000 October 97,000 November 58,000 December SALES 27,000 105,000 82,000 76,000

Which one of the forecasting methods is capable of handling large amounts of data and uncovering complex relationships? O a. Qualitative forecasting O b. Weather forecasting O c. Quantitative forecasting O d. Sales forecasting