Company: ATUS (alt ice usa.Inc). First follow all the instructions to finish the excel sheet and put all the result in a word file. Second use the result to make a PPT for 5 minutes speech. ( When you calculate the data you may need to use the “Pom”, I upload a tool installation if you don’t have it.)

Company: ATUS (alt ice usa.Inc). First follow all the instructions to finish the excel sheet and put all the result in a word file. Second use the result to make a PPT for 5 minutes speech. ( When you calculate the data you may need to use the “Pom”, I upload a tool installation if you don’t have it.)

Project: Company (stock symbol allocated) and Case study. (160 points)

1) Describe Key Market Data, Company Information/ Description of Business Per Share, Overview, Key Financial Ratios and Statistics and Annual Summary.

2) Your company’s Supply Chain Model, recommendations for improvements. (20)

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 lowest MAD, MSE, or MAPE.

6) Using Least Square method, predict sales for the next quarter (March, 18). – calculate tracking signal. (40)

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. (40)

9) Recommend Strategy in a Global Environment for improvement of productivity, reduce cost and other Operations changes which can improve its stock performance (In your words with text book relevance) (30)

10) Present in class (PPT – 5 min. max) on last day before Finals and send e-mail version copy of your case study. (30)

Need Help With a Project on This or Another Topic?

Cooperate with seasoned experts directly — create your project now and start getting help in 2 minutes.

Order Now Free Inquiry