Sat Nov is 12:16PM Q .2? Ii Word File Edit View Insert Format Tools Table Window Help or eu- Aumsave GD :3 CTQ Baseline Data.xlsx - Read-Only l O AutoSave .orr l3] Home Insert Draw Page Layout Formulas Data Review g Tell me [a Share Q Cor Home Insert Draw Design Layout Q Tell me If Editing Q Comments 3. v % v - Conditional Formatting v v p v r.\\ [u [an V Times New... v 12 v A. Av Aa v A0 AI v 0 g ' ' . Format as Table v .. L E ' V Clipboard Font Alignment Number M Cell Styles v Cells Editing AriDaalyaze massif): B I Q v ab x2 X2 A v i v A v paragraph Styles Dictate Editor F22 : This project is designed to allow you to complete primary components of a quality improvement project. The information and data will be provided to you in class and/or in A B C D E F G H I l K L M documents. You will use this information to work through the Six Sigma DMAIC 1 CTQ Baseline Data process. This is the second phase of this project. 2 3 - This Phase ofyour term project is due via the Assignment Link by 11:59 PM 4 Period 1 2 3 4 5 6 7 8 9 1 0 1 I. 1 2 Eastern. Sunday on the due date. 5 , - This Phase of your term project is worth 75 ot' the 300 total points for the project. 6 Guest Room Cleanliness 82% 83% 80% 85% 84% 79% 83% 85% 80% 81% 84% 80% . Late Work will not be accepted. 7 Mari Hours Per Occupied Room 0.50 0.49 0.47 0.48 0.49 0.51 0.52 0.48 0.51 0.48 0.47 0.50 I 8 Direct Expense per Occupied Room $5.35 $5.50 $5.85 $6.25 $5.50 $5.35 $5.25 $5.50 $5.10 $5.25 $5.40 $5.50 9 Check In Speed 1.1 1.2 1.3 1.5 1.1 1.0 1.2 1.3 1.4 1.5 1.0 1.3 Part 2 [Measure] 10 Take Rate (9/0 of multi-night stays) 1.3% 1.4% 2.5% 2.3% 1.8% 1.4% 2.4% 1.6% 1.1% 2.5% 3.0% 1.9% 1 1 In this phase, you will be required to complete the Measure phase of the problem. You 12 will need to dene the Critical to Quality elements and how to measure them. Data will 13 be provided to you, and you must develop Control Charts for the CTQ data. These 14 measuremean are for the baseline period. The baseline period is the period of time prior 15 to you implementing the project change(s). Later, in the Control Phase, you will compare 16 the baseline period to the periods after the process change(s) are made. This allows you i; to see if the project changes actually identied the root cause and corrected/improved the process. 19 3(1) Make certain you are referring to the Discussion Forum on the CTQ measurements 22 ' before you recommend your CTf 2'5. 23 24 Measure Phase: 25 1. Develop Critical to Quality components of this project for both internal and 26 external customers. Following the discussion on the forum this week, M 27 instructor will determine which CTQ elements will be used. 28 a. For each nt' these, write a short section nn how this process is measured. 29 2. Prepare baseline measurement control charts based on the data le that has been 3(1) provided to you. 32 a. One Chart for each measurement. See notes on the require chart format 33 b. Baseline control charts must be prepared in Excel and copied into your 34 project Word document once you arc done. You will submit ONLY the 35 Word document that will include the copies of the charts. 36 37 Chart Requirements: 1. Each Chart must have a title. 7 Al Page 1 0t 2 526 words W C 1 Focus CTQ Baseline Data + + 117% '- J. saamne AutoSave OFF A A C GO ... Week 4_Term Project Part 2 MEASURE - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Editing Comments Times New... v 12 A" A Aav Ap EV EVEVEE AaBbCcDdE AaBbCcDdE AaBbCcD AaBbCcDdE AaBbCcDdE AaBbCcDdEe Paste BIUvab X X A DAY Norma No Spacing Heading 1 Heading 2 Heading 3 Heading 4 Styles Dictate Editor Pane JOHNSON & WALES UNIVERSITY 3. All periods are on the Chart. 4. The LOWER limit on the vertical axis is set to be slightly less than the lowest data point value. This is REALLY IMPORTANT 5. The UPPER limit on the vertical axis is set to be slightly more than the highest data point value. This is REALLY IMPORTANT 6. The vertical axis is properly formatted for the correct type of value ($, %, or count) 7. Each chart must have a TREND line. Example Chart Guest Room Cleanliness 86% 85% 84% 83% 82% 81% 80% 79% 78% 77% 76% 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Grading Rubric: 1. Document is professionally written using the language of Business and of Six Sigma. 2. Document is written as if it were being presented to a Senior executive and sponsor of your project. 3. Document is formatted as if it were being presented to a Senior executive and sponsor of your project. 4. Was the procedure for the use of the tools followed correctly? For this assignment specifically, were the specific instructions for chart format followed. 5. Spelling, Grammar, and Format. Page 2 of 2 526 words English (United States) Focus E + 117%