Question: this is an OMGT assignment on exponential smoothing. this is due today at 11:59 NOTE: This is the Second Chance Homework #2 Cheap Tires, Inc.

this is an OMGT assignment on exponential smoothing. this is due today at 11:59
NOTE: This is the Second Chance Homework #2 Cheap Tires, Inc. Cheap Tires, Inc. (CTI), is an automotive repair shop specializing in replacement tires. Located in Raleigh, NC., CTI has grown successfully over the past few years because of the addition of a new general manager, Julie Jones. Since selling tires is a major portion of CTI's business, Julie was surprised at the lack of forecasts for tire consumption for the company. Julie is determined to get a better idea of how many tires to hold in stock during the various months of the year. Listed below is the actual demand for 2018. Month January February March April May June Tires Used 600 500 1,200 1,800 1,300 1,100 Month July August September October November December Tires Used 900 2.600 2,200 1,600 850 700 TOTAL 15,350 Assignment: Julie has hired you to determine the best technique for forecasting CTI demand based on the given data 1. Calculate the forecasts for 2018, according to the following methods. You must include the Forecast Error, Bias, Bias Average, Absolute Deviation and Absolute Deviation Average . Calculate for all months possible. a. 3 - period Simple Moving Average (SMA) b. 3 - period Weighted Moving Average (WMA) (weights-,60,.20,.20, for the most recent, 2nd most recent, and 3rd most recent time periods, respectively) c. Exponential Smoothing, alpha=0.1 (assume 1,000 for January's forecast) d. Exponential Smoothing, alpha=0.3 (assume 1,000 for January's forecast) e. Exponential Smoothing, alpha=0.7 (assume 1,000 for January's forecast)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
