Refer to your reading for this unit in the Coyle text for this assignment. Read the “Tires for You, Inc. (TFY) Case Study,” on page 251. In a 2–4 page paper, answer the four forecasting activity case questions.
As you answer the questions, relate the TFY story to any similar experiences you have had in an organization. (You may choose any organization about which you have sufficient knowledge to compare, including the organization with which you are currently employed, a former employer, or the organization you have chosen to study for your project.)
Please complete Q1, Q2 & Q6. Submit a “One Page” Word written analysis accompanied by the completed Excel Template I’ve attached, or you can write-over my template to produce your results.
Please fill-in the missing cells using appropriate Excel formula and detail to support your answers Note that the Excel Template I am providing was produced using different data, so you need to over-write these numbers and use the data information provided for Case 7-1 on pages 251-252.
There are “Four Types” of forecasting techniques;
- Simple Moving Average,
- Weighted Moving Average (3-Month Moving Avg),
- Exponential Smoothing,
- Trend Adjusted Exponential Smoothing
- Seasonal Influenced Forecast.
I reduced the number of techniques to #1 & #2 for purposes of this exercise.
Tires4U Case (Tip) (Use This).xls (77.5 KB)
To use the ebook go to https://online.vitalsource.com/
user name [email protected]