Question: Please show work in excel Examine the provided data. We are working with a restaurant to improve service times. We have collected data on server

Please show work in excel

Please show work in excel Examine the provided

Examine the provided data. We are working with a restaurant to improve service times. We have collected data on server times in minutes. The specification is 1.8 to 2.1 minutes. Based on this data, should you create an Xbar and R or Xbar and s chart. Why? Create the Xbar and (R or s) chart. Is this process in control? Calculate the Cp and Cok for this process. How is the process performing? Data is attached below. TABLE C7.1.2 Server-to-Car Times in Minutes Server 5 Subgroup Number 1 2 3 4 2.2 WNE Server 1 2.3 2.2 2.2 2.0 Server 2 2.2 2.1 2.1 2.3 Server 3 2.0 2.0 2.0 2.3 Server 4 2.4 2.2 2.3 2.2 2.3 2.0 2.1 5 6 7 8 2.2 00 On 2.0 2.2 2.2 2.4 2.3 2.5 2.2 2.6 2.1 2.3 2.4 2.5 1.9 2.1 2.0 2.2 2.4 9 10 11 12 2.5 2.2 2.0 2.3 2.2 2.0 2.3 2.2 2.4 2.2 2.1 2.1 1.9 2.5 2.2 2.3 2.2 2.0 2.1 2.2 13 2.1 2.1 2.2 2.3 14 15 2.1 2.2 2.1 2.2 wooo 2.1 2.4 2.3 2.3 2.0 2.0 2.0 2.1 2.2 2.1 16 2.0 2.1 2.0 17 18 19 20 2.1 2.0 2.3 2.0 NNNN 2.0 2.1 2.3 2.3 2.2 2.4 2.1 2.4 1.9 2.3 1.9 NNN 1.9 2.2 2.3 2.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

All the data i have show in excel Examine the provided data. We are working with a restaurant to improve service times. We have collected data on server times in minutes. The specification is 1.8 to...

2. (35 Points) Examine the provided data. We are working with a restaurant to improve service tims. We have collected data on server times in minutes. The specification is 1.8 to 2.1 minutes. Based...

Use the accompanying Excel spreadsheet to calculate the costs and profit margins of the three different office visits using i) the RCC method and ii) TDABC (Time-Driven Activity Based Costing)...

Independent Journal of Management & Production E-ISSN: 2236-269X ijmp@ijmp.jor.br Instituto Federal de Educao, Cincia e Tecnologia de So Paulo Brasil Gumus, Seigha; Monday Bubou, Gordon; Humphrey...

UAT 2 - Unit Skills Assessment The student must ensure they are ready for the assessment task before undertaking it. Section 1: Information for Trainers/Assessors Please make sure the student has...

GRADUATE CERTIFICATE IN PROJECT MANAGEMENT PROJ5010: PROJECT PROCUREMENT AND STRATEGIC SOURCING. CASE STUDIES CONTENTS 1. Proj5010: The World Bank RFP Case Study covers 1. Assignment 1: Marks = 5 2....

Q1 - What is the capacity utilization of each resource for lunch? What is the capacity utilization of each resource for dinner? Please use a table similar to the following to present your answers for...

Consider the queue of trucks arriving to an emission inspection station in Virginia. All vehicles with Virginia license plates are subject to biannual emissions inspections. There is one queue and...

please see attachment for instructions,Only the following budget spreadsheets are to be included: Sales, Collections, and Production. Be sure to use Word Wrapping, Alignment, and Punctuation for...

Would you be able to put together another monthly cash flow analysis, this time for year 1? INCOME STATEMENT Year 1 269,115.00 48,930.00 20,388.00 338,433.00 $ $ $ $ COGS $ 113,940.00 $ 125,940.00 $...

Classy Clothiers manufactures women??s business suits. The company uses a standard cost accounting system. In March 2012, 15,700 suits were made. The following standard and actual cost data applied...

What possible social advantages of price increases arise in the following cases? a. Charging higher prices for electrical power on very hot days when many people use air conditioners b. Raising water...

Josh, an electrician, is about 10 years from retirement. His retirement income will be derived primanly from the savings in his PASP plan, which is predominantly comprised of GICs. Josh has grown...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...