cesInter-State Moving and Storage Company wishes to establish a control chart to monitor the proportion of residential movesthat result in written complaints due to late delivery, lost items, or damaged items. A sample of 50 moves is selected for eachof the last 12 months. The number of written complaints in each sample is 8, 7, 4, 8, 2, 7, 11, 6, 7, 6, 8, and 12.Click here for the Excel Data Filea. Insert the mean proportion defective, UCL, and LCL (Leave no cells blank - be certain to enter "0" wherever required.Round your intermediate calculations and final answers to 2 decimal places.)Mean proportion defectiveUCLLCLc. Does it appear that the number of complaints is out of control for any of the months?YesONO

Answered: Inter-State Moving and Storage Company…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Which one of the methods is most accurate (Exponential smoothing or 3 month moving average) based on MAD ?
Plastomer, Inc., specializes in the manufacture of high-grade plastic film used to wrap food products. Film is rejected and scrapped for a variety of reasons (e.g., opacity, high carbon content, incorrect thickness or gauge, scratches, etc.). During the past month, management collected data on the types of rejects and the amount of scrap generated by each type. The following table presents the results:Draw a Pareto chart to identify which type of failure management should attempt to eliminate first.
Racks Company has developed the following standards for one of its products: Direct materials 12 kilograms @ $14 per kg Direct labour 3 hours @ $18 per hour Variable overhead 3 hours @ $ 8 per hour The following activities occurred during the month of October: Materials purchased 10,000 kilograms at $13.60 per kg Materials used 9,000 kilograms Units produced 800 units Direct labour 2,500 hours at $19.00 per hour Actual variable overhead $22,000 The company records materials price variances at the time of purchase. Racks Company's materials price variance would be Racks Company's materials usage variance would be Racks Company's labour rate variance would be Racks Company's labour efficiency variance would be Who would NOT be responsible for an unfavourable material usage variance caused by poor quality material?
5. Why do you think most PMs use Gantt chart more commonly than the network diagram ?
Cross-functional teams (those that work in brief production cycles to produce product increments over time) perform work in parallel. Is it necessary to construct numerous models to convey the process model of COVID-19?
Develop a Ghantt Chart in excel based on the following information Start Date End Date Duration(Days) 1/18/22 5/1/22 103 1/18/22 1/25/22 7 1/19/22 1/22/22 3 1/21/22 1/23/22 2 1/22/22 1/23/22 1 1/23/22 1/24/22 1 1/28/22 2/28/22 31 1/28/22 2/8/22 11 2/8/22 2/14/22 6 2/15/22 2/17/22 2 2/17/22 2/19/22 2 2/19/22 2/20/22 1 2/21/22 2/23/22 2 2/24/22 2/25/22 1 2/26/22 2/27/22 1 2/27/22 2/28/22 1 2/28/22 2/28/22 0 3/1/22 3/25/22 24 3/2/22 3/7/22 5 3/8/22 3/11/22 3 3/12/22 3/15/22 3 3/16/22 3/23/22 7 3/24/22 3/25/22 1 3/26/22 4/15/22 20 3/27/22 4/5/22 9 4/6/22 4/15/22 9 4/16/22 4/30/22 14 4/17/22 4/22/22 5 4/23/22 4/26/22 3 4/27/22 5/1/22 4
IV. The following data represent the number of dishes that are broken at a restaurant while loading and unloading the dishwasher. The total number of dishes washed varies daily. Construct a p chart for these data. What can you conclude about the situation? Do you have any recommendations? Total Number of dishes washed 465 425 500 Day Number of broken Day Total Number of dishes Number of broken dishes 51 42 washed 465 dishes 39 1 13 14 425 500 500 41 15 16 55 51 4 500 53 47 425 425 425 44 17 18 19 425 425 425 38 44 41 39 41 465 47 20 465 48 500 500 425 465 56 43 46 21 465 500 500 42 10 22 23 47 51 11 12 49 24 465 36
Case Part B: Patient Satisfaction Thirty patients who check out of the Metropolitan General Hospital each week are asked to complete a questionnaire about hospital service. Since patients do not feel well when they are in the hospital, they typically are very critical of the service. Management recorded the number of patients who indicated dissatisfaction of any kind with the service for each 30-patient sample for a 16-week period (see Excel file, Hospital Case Part B spreadsheet). Perform a data analysis for the Hospital. Prepare a report that summarizes your findings and recommendations. Include the following: Questions for Part B: 1. What type of control chart would you use to monitor customer satisfaction at the hospital? 2. Construct the appropriate three-sigma control chart. 3. What comments can you make about the results of the questionnaire? Does the current process appear to be in control? Explain.
TO DO: Prepare a check sheet to analyze the data below from customer complaints, then prepare a list of recommendations that will address these complaints. Case: Tip Top Markets is a regional chain of supermarkets located in the southeastern United States. Karen Martin, manager of one of the stores, was disturbed by the large number of complaints from customers at her store, particularly on Tuesdays, so she obtained complaint records from the store’s customer service desk for the last nine Tuesdays. June 1 out of orange yogurt produce not fresh bread stale lemon yogurt past sell date checkout lines too long couldn’t find rice overcharged milk past sell date double charged stock clerk rude meat smelled strange cashier not friendly charged for item not purchased out of maple walnut ice cream couldn’t find the sponges something green in meat meat tasted strange didn’t like music store too cold checkout lines…
Hotel ComplaintsA luxury hotel has been receiving a lot of complaints from guests recently. The manager worries that if these complaints continue, the hotel will start to lose clients. Therefore, you have been hired as a consultant to correct the problem(s). A list of the major complaints by week for the last month is as follows: Complaint Number of Occurrences Week 1Error on bill 10Room not ready at check-in 8Room service delivery late 3Longline at check-out 10 Week 2Error on bill 12Noise in hallway 2Longline at check-out…
Problem 10-6 (Static) A medical facility does MRIs for sports Injuries. Occasionally, a test yields inconclusive results and must be repeated. Using the following sample data and n = 200. Number of retests 1 2 1 2 UCL LCL 3 2 b. Is the process in control? 4 The process is in control. O The process is not in control. 0 5 2 SAMPLE 6 7 1 2 Click here for the Excel Data File a. Determine the upper and lower control limits for the fraction of retests using two-sigma limits. (Do not round intermediate calculations. Round your final answers to 4 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) 8 9 10 11 12 13 2 7 3 2 1
Background: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing themMethods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a classification…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS