Insight Manufacturing
Sandra Emsai is the production manager for Insight Manufacturing, Inc. (IMI) which has only been in business for two years. IMI makes three products for the medical instrument market. The product numbers for the three products are A-307, B-299, and C-461.
Until now, IMI has been relying solely on the predictions from the sales team to forecast demand for their products, and they have seen varying levels of performance from their supply chain, including some products where production and inventory levels have been fairly accurate, as well as products which seem to have large variations in the actual demand versus what was forecast, which has caused stock-outs and backorders when they swing one way, and excess inventory carrying costs when they swing the other way.
Finally, Sandra has one year of reliable demand information available from her ERP system, and she would like to do a better job next year at predicting demand for these three products.
Here is the demand data from the previous twelve months for the three products:
Do the following:
1. Analyze the historical data (I recommend plotting the demand over time).
2. Using a variety of forecasting methods for each product, generate forecasts for the historical data and see how close to the actuals the different forecasts are. In your analysis, be sure to also calculate common forecast accuracy values for each method.
a. Note: If you use moving averages, you will not be able to generate forecasts for periods less than the number of periods you are averaging.
b. For methods that require assumptions (number of periods, values for α, weights, etc.) use typical values (3 months, 4 months, α=0.4, etc. are all good starting points).
c. You can experiment with different numbers of periods and/or weights and values of α to see if you can improve the accuracy.
3. From that analysis, recommend an appropriate forecasting method for each product. Discuss why certain sets of data are better forecast with different methods.
| ACTUAL DEMAND | ||||||
| Period | Month | A-307 | B-299 | C-461 | ||
| 1 | January | 6,532 | 4,691 | 1,683 | ||
| 2 | February | 7,105 | 6,257 | 1,692 | ||
| 3 | March | 7,097 | 6,901 | 1,586 | ||
| 4 | April | 9,995 | 5,905 | 1,569 | ||
| 5 | May | 12,506 | 3,734 | 1,960 | ||
| 6 | June | 9,521 | 6,748 | 1,840 | ||
| 7 | July | 5,974 | 8,267 | 1,823 | ||
| 8 | August | 2,323 | 4,725 | 1,720 | ||
| 9 | September | 6,674 | 7,297 | 1,681 | ||
| 10 | October | 6,172 | 5,331 | 1,535 | ||
| 11 | November | 5,992 | 7,024 | 1,538 | ||
| 12 | December | 5,719 | 2,134 | 1,737 | ||
| Don't use plagiarized sources. Get Your Custom Essay on 2220 week 5 analysis Assignment | Online Assignment Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
| ||||||
Science is the pursuit and application of knowledge and understanding of the natural and social…
Clearly stating the definition, the values, the meaning of such values and the type of…
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…
https://www.npr.org/sections/ed/2018/04/25/605092520/high-paying-trade-jobs-sit-empty-while-high-school-grads-line-up-for-university Click on the link above. Read the entire link and answer the questions below…
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…