Question;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:JulySales1562643634565686597641)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 average 3)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# NonconformingProportion126225323424526620721827923102511221226132514291520161917231819191820272128Total4)Calculate the UCL and LCL. 5)Construct a controlp 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 revenue would you see if $250 was spent on advertising? 8)What would the range (prediction/confidence interval) of this forecasting using two standard errors of the estimate? Assuming that you spent $250 on advertising.
Paper#60643 | Written in 18-Jul-2015Price : $27