Categories: Uncategorized

2220 week 5 analysis Assignment | Online Assignment

  • Read the attached case study: Insight Manufacturing.
  • For your convenience, I have attached a spreadsheet with the historical data so you don’t have to transcribe it.
  • Do the analysis as indicated at the end of the case and make your recommendations as requested.
  • This case is well-suited to a spreadsheet analysis, and you are welcome to submit a spreadsheet (including the appropriate recommendations) as your response to this case.

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!
Order Essay

 

 

 

 

Suzie Mercy

Recent Posts

What is the easy difination of science | Quick Solution

Science is the pursuit and application of knowledge and understanding of the natural and social…

4 years ago

definition, values, meaning of such values and type of goods with such elasticity value …….. | Quick Solution

Clearly stating the definition, the values, the meaning of such values and the type of…

4 years ago

Acct 422 – Nora D | Quick Solution

All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…

4 years ago

Acct 322 – Nora D | Quick Solution

All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…

4 years ago

Macro Economics Question | Quick Solution

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…

4 years ago

MGT 322 – Nora D | Quick Solution

All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…

4 years ago