Kinaxis case study - forecasting the unforeseeable

Assignment Help Supply Chain Management

Reference no: EM133549487

Kinaxis Case Study - Forecasting the Unforeseeable

Read the Kinaxis case study, pages 1 through 4.

Part 1: Forecast 2019 monthly average demand
You have been given the attached demand data, which covers the sales of Cough and InfeX from 2017 through the end of 2018.
Your team is tasked with the following:
• To makeforecasts for CoughX and InfeX for the data up through 12/2019, determine what your best forecast method is for each product.
• Recommend one method they should use for CoughX for 2020.
• Recommend one method they should use for InfeX for 2020 (it does not have to be the same method).
• Write up your results in an Executive Memo.

Part 2: Forecast 2020 monthly average demand
You have been given the attached demand data, which covers the sales of Cough and InfeX from 2017 through the end of 2019.
Your team is tasked with the following:
• To make forecasts for CoughX and InfeX for the data up through 12/2020, determine what your best forecast method is for each product.
• Analyze the quality of the results (models) between 2019 and 2020 forecasts and write up your results in an Executive Memo.

Part 3: Research a Commercial Alternative
1. Ladonya has asked you to evaluate the Kinaxis supply chain software, a commercial option which says it can forecast demand better than these rudimentary methods. She's found the Demand Planning brochure
2. Review the Kinaxis.com website and under "Resources" find one case study which seems most similar to ours with CoughX and InfeX.
3. List three advantages the Kinaxis software appears to have over any of your methods.
4. List three drawbacks you might see from the Kinaxis software implementation.

Part 4: Write your Report
Write an executive memo for Ladonya and Rajeev outlining your answers to the questionsfrom above. For each question, include screenshots of any visualizations or other output you use. In addition, answer the following questions:
• If they could choose only one method to use for forecasting CoughX for 2021, which would you suggest they use and why? (Let's say you choose linear regression. You will be ‘allowed' to update the linear regression coefficients and forecast as every single month happens during 2021, but you won't be ‘allowed' to change to a moving average forecast halfway through the year, because it costs time and money to program the computers to calculate this.)
• If they could choose only one method to use for forecasting InfeX for 2021, which would you suggest and why?
• In both of these, be sure to take into consideration any behavior of the demand for each product (Does it jump? Is it seasonal? Steady?)
• Would you recommend we use Kinaxis software instead? Why or why not?

Please review the attached files.

1. Using the data for 2017- 2018 and applying:
a. the naive algorithm
b. moving average (please select n - number of periods)
c. exponential smoothing
Then apply the best method that you choose to the data for 2017-2019

2. Using the data for 2017- 2019 and applying:
a. the naive algorithm
b. moving average (please select n - number of periods)
c. exponential smoothing
Then apply the best method that you choose to the data for 2017-2020

3. Write an executive memo of your results (minimum 3 pages)

References
Chopra, S. (2019). Supply chain management: Strategy, planning, and operation (7th ed.). Boston, MA: Pearson.

Attachment:- Forecasting.rar

Reference no: EM133549487

Questions Cloud

Mentalistic and behavioral approaches to therapy : Identify the difference between mentalistic and behavioral approaches to therapy. Discuss the use of data collection to determine treatment effectiveness

Research australian law on collecting public data : Research Australian Law on collecting public data and show the validity of this mobility dataset according to Australian Law.

Create a purchase order for the deluxe touring bike : Reviewing the stock, you realise that stock is required, and you are required to start the procurement process. The Deluxe Touring Bike

Design of a small food retail outlet : Design of a small food retail outlet, and the associated construction detailing of the street facing wall - discuss their independent ways of approaching

Kinaxis case study - forecasting the unforeseeable : Applying the naive algorithm, moving average and exponential smoothing - Forecast 2020 monthly average demand

Different view points on why society expects nurses : What are different view points on why society expects nurses and healthcare professionals to act ethically?

Neutrality is valuable in the context of reporting the news : According to Tim Kenyon: Clear Thinking in a Blurry World. Neutrality is valuable in the context of reporting the news.

What are clinical trials and studies : Myopia and Ambient Night-Time Lighting. What Are Clinical Trials and Studies?

How did you know the child was unwell : How did you know the child was unwell? What measures did you take to prevent cross-contamination of the child's illness?

User Account

All Pages