#### Details of this Paper

##### BUSN 444 Module 10 Assignment

Description

solution

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

Price : \$44