Springer_Elizabeth_Homework 7_2.xlsx

Quality defective free out of 1000 speed reduction in

Info icon This preview shows pages 2–6. Sign up to view the full content.

Quality (Defective Free out of 1000) Speed (Reduction in Days) Project Cost over 5 Years
Image of page 2

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

26 1 - ### 395 18 $ (452,635.00) 1 27 - 1 - 67 11 $ (153,762.00) - 28 1 ### - 318 1 $ (87,959.00) - 29 1 - ### 892 22 $ 114,534.00 1 30 - 1 ### 241 25 $ (155,861.00) - 31 - 1 ### 672 12 $ (365,375.00) 1 32 - ### 1 367 1 $ (47,545.00) - 33 1 ### 1 441 19 $ (54,337.00) - 34 1 ### - 312 11 $ (25,565.00) - 35 - 1 - 741 7 $ 218,901.00 1 36 1 - ### 152 15 $ (174,572.00) - 37 1 - ### 421 14 $ 364,862.00 - 38 - 1 ### 664 18 $ (285,424.00) 1 39 1 - ### 394 17 $ 11,445.00 - 40 - 1 ### 342 15 $ 381,951.00 - 41 1 - 1 495 6 $ (364,384.00) 1 42 - 1 ### 138 10 $ 126,225.00 - 43 - ### 1 497 13 $ 314,030.00 - 44 1 - ### 600 8 $ (204,767.00) 1 45 1 - ### 70 9 $ (360,997.00) 1 46 1 ### - 328 17 $ 312,224.00 - 47 1 - ### 738 11 $ 395,810.00 - 48 - 1 ### 282 17 $ (437,307.00) 1 49 - ### 1 905 7 $ 376,547.00 - 50 1 ### - 220 5 $ (183,168.00) 1 Question 1: Using the data from Task 1. The BOD would like to know the percentage o began as an effort to overcome quality, speed, and cost issues. Also, briefly discuss t Results. Answer: The percentage of Performance Improvement program projects completed for ea Qualiity: 58%; 26%
Image of page 3
Question 2: Using the data given below, complete Task 2. NEWS is very proud of the about this next process improvement project decision. It is truly a make or break initi rate of success of past PIP initiatives? Given this probability of success, what recom Qualiity: 58%; 26% Speed: 58%; 26% Costs: 52%; 22% Auality & Speed:24%; 8% Quality & Costs: 22%; 10% Speed & Costs:32%; 14% Quality, Speed & Costs: 10%. 4% As can be seen from the above information, sucess rates bases on the confidential criteria Answer: No the briefing they gave the press is not true. Based on the old criteria, their suc would recommend that they focus on the more productive projects. Stop programs that do (speed, quality, cost) or only proceed with projects that have a one in results.
Image of page 4

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

nd controlling costs. gnments has led to successful strategic plans. ting permission for the CEO to execute the plan. that the NEWS BOD had approved. ed, or cost control project, or combination. (1 = Yes) essful or not; old BOD criteria were confidential. (1 = Yes) Task 1A: Calculate Count (1-3) Step 1: Use the =COUNTIF function in the hightlighted Count colunm bel Step 2: Enter the following cell ranges for Quality (B13:B62), Speed (C13 Step 3: Use a Criteria of "1" Task 1B: Calculate Count (4-7) Step 5: Use the =COUNTIFS function in the hightlighted Count colunm be Step 7: Use a Criteria of "1" Task 1C: Calculate PIP Percentage Step 9: Use the PIP Percentage colunm to divide each value you generat Task 1D: Calculate PIP Success Step 10: Use the =COUNTIFS function within the PIP Success colunm to Step 12: Then, divide the =COUNTIFS function by 50.
Image of page 5
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern