Details of this Paper

Homework Assignment #10




Question;Homework Assignment #10;Name;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;July;Sales;1;56;2;64;3;63;4;56;5;68;6;59;7;64;1);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;# Nonconforming;Proportion;1;26;2;25;3;23;4;24;5;26;6;20;7;21;8;27;9;23;10;25;11;22;12;26;13;25;14;29;15;20;16;19;17;23;18;19;19;18;20;27;21;28;Total;4);Calculate the UCL and;LCL.;5);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 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#60644 | Written in 18-Jul-2015

Price : $31