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 companys 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)
Unformatted Attachment Preview
Purchase answer to see full
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more