Question

this is a really long assignment and I need help

Question 1: Wendy's Happy Homes Inc manufactures Home Appliances. Monthly sales of Wendy's Washers and Dryer Sets for a nine month period were as follows: MONTH Washer and Dryer Sales 490 480 450 500 480 470 490 520 530 January February March April May June July August September Forecast October sales using 1) A four-month moving average 2) a six-month moving average 3. Compute the MAD for each forecast method you used Actual October sales were 320 nits. 4) Which method was the most accurate? 5) Forecast November and December using the method you believe to be the most T ot5 1211 wordh O Type here to search 5) Forecast November and December using the method you believe to be the most accurate. Question 2 (Copy the file to Excel when done submit here) Refer to the gasoline sales time series data in Tablé below to answer the following 1. Compute Three- week, four-week and five-week moving averages for the time 2. Compute the MSE for Three- week, the four-week and five-week moving average 3. Create a new column to show the trend line (y- mxtb) for the table below series forecasts. (Look over the PowerPoint) 4. What appears to be the best number of weeks of past data (three, four. or five) to 5. Plot gasoline sales time series after obtaining the contract with the Vermont state 6. Plot gasoline sales time series and three-week moving average Forecasts use in the moving average computation? police 7. Plot gasoline sales time series and add the trend line to graph 211 words Type here to search Paragraph Styles Font GASOLINE SALES TIME SERIES AFTER OBTAINING THE CONTRACT WITH THE VERMOFI STATE POLICE Week Sale (1000s of Gallons) 13 19 31 34 15 2,田. Heading 2 Styles Heading 1 r u ,嵌x, x. A·ツ. A. | -5- 1 Normal 1 No Spac Paragraph Font Question 3: A critically important aspect of customer service in a supermarket is the waiting time for the checkout Data were collected in the table below during time period in which a constant number of checkout counters were open. The total number of customers in the store and the waiting times in minutes were recorded a) Use Excel to construct the scatter plot. b) Determine the linear regression equation between number of customers and waiting time include that on the graph c) Predict the waiting period when there are 20 customers in the store. Noma T Normal 11 No Spac ←· 2-田. r u . aa x, x' A. y. A. Heading! Heading 2 . Paragraph Styles Font 12 35 25 13 2.3 0.2 0.7 2.5 15 16 17 18 19 20 21 16 21 17 3.8 16 2.8 14 15 21 27 17 1.7 23 24 25 2.9 2831 34 29 30 4.8 Paragraph members. Number of incorrect Day ills 10 1 Normal Paragraph 10 12 13 14 1e 17 18 19 20 23 24 26 27 28 29 Everyone looked at the data that had been presented Then im essla 25 26 27 28 29 30 Everyone looked at the data that had been presented. Then Tim exclaimed: "Notice that the number of errors increases in the last third of the month. The computer system had been in place for the entire month so that can't be the problem Scott, it is probably the new employees you have on staff that are not entering the data properly Scott quickly retaliated: The employees are trained properly! Everyone knows the problem is the computer system! The argument between Tim and Scott become heated, and Larraine decided to step in. She said".Scott. I think it is best if you perform some statistical analysis of that data and send us your findings. You know that we want a high-quality standard We can't be Motorola with six-sigma quantity, but let's try for three-sigma. Would you develop some control charts with the data and let us know if you think the process is in control?" Case Questions 1. Setup three-sipma control limits with the given data and graph it usng Excel (Go to the link for help ihttps-//www.youtabe.com./watch?y osl7KYzAndo Make sure the mean, upper control and lower control Sigma on the graph 2. Is the process in control? Why? 3. Based on your analysis do you think the problem is the new computer system or something else? 4. What advice would you give to Larraine based on the information that you have? re to search

Answer 1

mon廿y moinfousencige method D1 Nonthy 냐90 feb 480 Apr 500 480-480) 480 980 15 15 490 5 35 Au 530 | 98 5 나80 Jt 4A5 Augut

4 500 S = 502-5 Heam absoluti deutatiem MAD oo cast o.end 19.5 9) 6 Acnal- moui Tam 49D Hay Apr 500 Tum | 나 Jully118-3333 11.6667 1)-666 7 Aug | 520 |448-3333|41.6667 YI.666 7 Sep 530 485 498-33L8 Tbtal: 98-3339 45 oct

6 Yte 3333 6 448-3333 520 6 498 3 333 3) NA D months mouing a 19.5 MAD 6 monthy moviny lesrd 333y 3 32 3H48

monthy mouing aboas aging hmomthy movin 5 asenae umonths mouirg Actual Leal ue d) actoben man umit vaer neajen thorn 6 momthy mouiry aeae methpo And alyo minimuem