Springer_Elizabeth_Homework 7_2.xlsx

# Projects count pip percentage egardless of how the

• Homework Help
• 17
• 100% (1) 1 out of 1 people found this document helpful

This preview shows pages 5–9. Sign up to view the full content.

Projects Count PIP Percentage egardless of how the PIP was initially chosen, the positive or negative Step 4: Ranges and Criteria must be entered correctly for the function to Guide Tab for help on the correct format that should be used. Step 6: Depending on the combinations you are solving for, use the follo (C13:C62), or Costs (D13:D62). Step 8: Ranges and Criteria must be entered correctly for the function to Guide Tab for help on the correct format that should be used. Step 11: Depending on the combinations you are solving for, use the foll (C13:C62), or Costs (D13:D62), as well as, Results (H13:H62).

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

Quality (1) 29 58% Speed (2) 29 58% Costs (3) 26 52% Quality & Speed (4) 12 24% Quality & Costs (5) 11 22% Speed & Costs (6) 16 32% Quality, Speed, Costs (7) 5 10% Task 2: Calculate PIP Success (Old) Step 1: Use the =COUNTIF function in the highlighted cell below to deter Step 2: Enter the following cell ranges for Results (H13:H62). Step 3: Use a Criteria of "1" Step 4: Divide by 50. PIP Success (OLD) = 46% Task 3: Calculate Basic Probability Using new BOD Success Criteria Success Criteria Quality > 300 Defective Free per 1000 Speed > 15 Days Reduced Costs < \$ 200,000 per 5 Years STEP 1: Use the =COUNTIFS to determine the probability of PIP success Step 3: Use the table above to enter the appropiate Criteria for each proje Step 4: Then, divide the entire =COUNTIFS function by 50. PIP Success (NEW) = 22% Step 5: Ranges and Criteria must be entered correctly for the function to Guide Tab for help on the correct format that should be used. Step 2: Enter the following cell ranges for Quality (Defective Free out of 1 (F13:F62), and Projects Cost over 5 Years (G13:G62). Step 5: Ranges and Criteria must be entered correctly for the function to Guide Tab for help on the correct format that should be used. of PIP projects completed per each category, since their short-term memory h the PIP success rate attributable to each type of PIP effort based on the BOD' ch category is as follows with the sucess for each based on the confidential criteria
eir PIP initiative and has briefed the press that their success rate is greater tha iative for the company, and therefore a more conservative set of success crit mmendation would you make to the BOD? a are at most 26%, which means that for the most part the PIP projects are failing. ccess was only 46%. Based on the new set of criteria, their success rate has decre o not proviide the results they want. For example, stop projects that do not at least h

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

low to determine the number of projects 1-3. 3:C62), and Costs (D13:D62). elow to determine the number of projects 4-7.
This is the end of the preview. Sign up to access the rest of the document.
• Spring '13
• AnBotao

{[ snackBarMessage ]}

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern