Question;All calculations should be done in Word using Equation Editor and all charts and graphs should be done in Excel.Use the following scenario to answer the next 3 questions.Cold Stone Creamery has recorded the demand for a particular flavor of ice cream during the first seven days of July. The results are as follows:July1234567Sales566463566859641) Predict the sales for the 8th day of July using a 5-day moving average.2) Predict the sales for the 8th day of July using a 3-day moving average3) Predict the sales for the 8th day of July using a weighted 3-day moving average with weights of.5,.4, and.1.Use the following scenario to answer the next 3 questions.The data below represent the findings from a study conducted at a factory that manufactures film canisters. For 21 days, 500 film canisters were sampled and inspected. The following table lists the number of defective film canisters for each day.Day#Nonconforming262523242620212723252226252920192319182728123456789101112131415161718192021Total4) Calculate the UCL and LCL.Proportion5) Construct a control p chart, are there any proportions outside the control limits?Paste charts from Excel below:6) Is the process in a state of statistical control? Why?Use the following scenario to answer the next 2 questions.Analytics Tech. Inc. has developed the following sales forecasting model to help predict revenue (in thousands) in regards to how much is spent on advertising.Revenue = 123.5 + 2.3(Dollars), with a standard error of the estimate to be 31.2.7) How much revenue would you see if no money was spent on advertising? How much revenuewould you see if $250 was spent on advertising?8) What would the range (prediction/confidence interval) of this forecasting using two standarderrors of the estimate? Assuming that you spent $250 on advertising.
Paper#54565 | Written in 18-Jul-2015Price : $30