Question

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. d) Show r coefficient of regression and r-coefficient of determination on the graph i. Copy the following to Excel work and go back copy and paste here in the respond 2. Go to file to Excel, click on Options, select Add-ins 3, select Analysis Tool pack follow the YouTube https://www.youtube.com/watch?vemloSZIRo36c and the link to tegression on youtube https://www.youtube.com/watch?v-Cltt47Ah304 Day Customers Time 1.2 0.8 0.5 1.7 0.5 10 0.2 2.5 17 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 Styles Paragraph Font ipboard Question 4: CASE: Scharadin Hotels: The Scharadin Hotel in San Antonio, Texas, had recently been experiencing a large number of guest complaints due to billing errors. The complaints seem to center around guests disputing charges on their final hotel bill. Guest complaints ranged from extra charges, such as meals or services that were not purchased, to confusion for not being charged at all Mfost hotel guests use express checkout on their day of departure With express checkout the hotel bill is left under the guest's door in the early morning hours and, if all is in order, does not require any additional action on the guest's part Express checkout is a welcome service by busy travelers who are free to depart the hotel at their convenience. However, the increased number of billing errors beg creating unnecessary delays and frustration for the guests who unexpectedly needed settle their bill with the front desk. The hotel staff often had to calm frustrated guests who were rushing to the airport and were aggravated that they were getting charged for items they had not purchased Identifying the Source of the Problem Larraine Scharadin. Milo Scharadin's niece, had recently been appointed to run the San Antonio hotel. A recent business school graduate, Larraine had grown up in the hotel business. She was poised and confident and understood the importance of high quality for the hotel. When she became aware of the billing problem, she immediately called a staff meeting to uncover the source of the problem. During the staff meeting discussion quickly turned to problems with the new computer system and software that had been put in place. Tim Coleman, head of MIS, defended the system, stating that the system was sound, and the problems were exaggerated. Tim claimed that a few hotel guests made an issue of a few random problems. Scott Schultz, head of operations, was not so sure. Scott said that be noticed that the number of complaints seem to have significantly increased since the new system was installed He said that he had asked bis team to perform an atudit of 50 random bills per day over the past 30 days. Scott showed the following numbers to Larraine. Tim, and the other staff members an to ot 5 1211 wordi 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

As per HOMEWORKLIB RULES we should solve only the first question with its four sub parts. Please post the other questions differently mentioning your requirements