1) Describe Key Market Data, Company Information/ Description of Business, Per Share, Overview, Key Financial Ratios and Statistics and Annual Summary
etc.
2) Your company’s Supply Chain Model, recommendations for improvements.
3) Obtain relevant data for the company from web (Yahoo finance or Google etc)
4) Use company stock price and/or sales data for recent 3 years (12 quarters) and forecast price using Moving Average, Exponential Smoothing and Naïve
Methods )
5) Get the lowest MAD, MSE, or MAPE.
6) Using Least Square method, predict sales for the next quarter (March, 19). – calculate tracking signal.
7) Based on the stock prices at end of quarter ( 12 quarters) , plot x bar and r chart, calculate UCL and LCL .(could use moving range to get the average
range )
8) Calculate Cp and CPK for stock performance, Use spec. limits 0 – 75 for $1 -$25 (current stock price), 25 – 125 for $25-$50 (current stock price), 50
-150 for $75 (current stock price), 75 -200 for $100 (current stock price) and $100 – $ 500 for over $100 price.
Sample Solution
