Ms-DIsc

profilerocksolid
HMWRK-15.zip

Before doing assignment read it.txt

Assignment -1 - Read Microsoft project assignment Word Doc and do the assignment Assignment-2- Discussion -Read the Topic and Complete the Discussion ,Also Give 2 discussions which I have mentioned in chat (While chatting with you)

Discussion/discussion.docx

Read the case study "Teloxy Engineering (A)" on page 948 and answer the corresponding questions on the same page.

DISCUSSIONS

Discussions will consist of 2 parts: Your initial posting on the subject, and responses to two or more students postings.

Post your primary response by each Wednesday midnight. Respond to at least two (2) other postings by Sunday Midnight.

The primary post should be at least 300 words in length. Your second postings can either answer another student's question

to your own post or be a comment to his or her original post. Secondary posts must be at least 150 words in length.

•All initial postings must have at least one citation or reference and it must be in APA format. Failure to have a reference or not having it in APA format will deduct 5 points.

•Word counts must be met. Each 10 words short will deduct 1 point from your total discussion score.

•If any part of your postings is copied and pasted you will receive no credit for the assignment, and no resubmission is possible.

MS Project Assignment/Don Funk Music Video 10-1.mpp

MS Project Assignment/Don Funk Music Video 9-6.mpp

MS Project Assignment/MS project assignment.docx

Reading Assignment

Read chapters 20 and 17 of your textbook.

Microsoft Project Tutorial

Work through the tasks described in Lessons 9 and 10 of your workbook.

Microsoft Project Assignment 5

Complete Project 9-6: Tracking the Don Funk Music Video as Scheduled (pg.198 of your workbook).  Save your Don Funk On Schedule project file as YourLastNameYourFirstNameProject9-6 and submit it when done.

Complete Project 10-1: Creating a Dashboard Report (pg.218 of your workbook).  Save your Don Funk Dashboard Report project file as YourLastNameYourFirstNameProject10-1 and submit it when done.

MICROSOFT PROJECT ASSIGNMENTS

Each module the student will use Microsoft (MS) Project software to complete an assignment.

The use of MS Project is fundamental to helping students both understand the intricacies of

project planning and management, as well as give them practice in using a common project management software

. The student will be responsible for downloading and installing the software package from now the link available on the course home page.

MS project tutorial/Project2013_Lesson09.pptx

Project Schedule Tracking Fundamentals

Lesson 9

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

1

Microsoft Project 2013

1

Objectives

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

2

Software Orientation

The Variance Table can be used to review baseline information in table format.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

3

Software Orientation

On the Variance Table, you can also see the variance between the baseline start and the planned or actual start of a task. In other words, this table shows you if the project is ahead of schedule or behind schedule, on a task-by-task basis.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

4

Establishing a Project Baseline

In order to evaluate how well a project is progressing, it is important to review how well it was originally planned.

The schedule baseline is the project schedule that has been approved by the project sponsor.

The baseline is saved and then referred to later to track project progress.

In project management, by definition, a baseline is the approved version of the scope, schedule and budget of a project.

In Microsoft Project, a baseline is a “snap-shot” of these key values, such as the planned start and finish dates (schedule), planned costs (budget) and the tasks (scope), at a given point in time.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

5

Step by Step: Establish a Project Baseline

GET READY. Before you begin these steps, launch Microsoft Project.

1. OPEN the Don Funk Music Video 9M project schedule from the data files for this lesson.

2. SAVE the file as Don Funk Music Video 9 in the solutions folder for this lesson as directed by your instructor.

3. Click the Project tab. In the Schedule group, click the Set Baseline button and then select Set Baseline.

4. The Set Baseline dialog box appears. You will accept all of the default settings in this dialog box by clicking OK. Microsoft Project saves the baseline, although there is no indication in the Gantt Chart view that anything has changed. In the next few steps, you will explore some of the changes caused by saving the baseline.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

6

Cross Ref: You will go deeper into the Set Baseline dialog box in Lesson 11.

Take Note: You can save up to eleven baselines in a single project schedule. The baselines are named Baseline (the first baseline you would normally save) and Baseline 1 through Baseline 10. Saving multiple baselines is helpful if your project duration is especially long or if you have approved scope/schedule changes. You can save multiple baselines to record different sets of baseline values and later compare these against each other and against actual values.

6

Step by Step: Establish a Project Baseline

5. On the ribbon, click the View tab and then click the down-arrow under Gantt Chart. Select More Views, and the More Views dialog box appears.

6. In the More Views box, select Task Sheet and click Apply. Using this view, there is more room to see the fields in the table because the Gantt Chart is not shown. Now you will switch to a different table in the Task Sheet view.

7. On the ribbon, click Tables, and then click Variance. The Variance table appears. This table includes both the Scheduled and Baseline columns so that you can compare them easily. Your screen should look similar to the figure on the next slide.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

7

Step by Step: Establish a Project Baseline

Note that at this point, the values in the Start and Baseline Start, as well as the values in the Finish and Baseline Finish, are identical. This is because no actual work has occurred and no changes to the scheduled work have been made. Once actual work has been recorded or schedule adjustments have been made, the scheduled values may differ from the baseline values. Any differences would be displayed in the Variance column.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

8

Troubleshooting: If any column displays pound signs (####), double-click between the column titles to widen the column.

8

Step by Step: Establish a Project Baseline

8. SAVE the project schedule.

PAUSE. LEAVE Project open to use in the next exercise.

In this exercise, you learned how to save a baseline for your project schedule.

You must save a baseline before you begin tracking project progress.

The table on the following slide lists the specific values saved in the baseline, which include the task, resource, and assignment fields, as well as the timephased fields–task, resource, and assignment values distributed over time.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

9

Step by Step: Establish a Project Baseline

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

10

Step by Step: Establish a Project Baseline

You should save a baseline when:

You have developed the project schedule as much as possible. (You can still add tasks, resources, or an assignment after the work has begun. This is usually not avoidable.)

Your project has been approved and accepted by the project sponsor.

You have not started to enter actual values, such as a percentage of completion for the task.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

11

Step by Step: Establish a Project Baseline

The first phase of a project focuses on project planning—developing and communicating the details of a project before actual work begins.

When work begins, so does your next phase of project management: tracking project progress.

Tracking refers to all of the collecting, entering, and analyzing of actual project performance data, such as actual work values on tasks (usually expressed in hours), actual resource costs, and actual durations.

These details, collectively, are often called actuals and can be recorded in a Microsoft Project file.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

12

Step by Step: Establish a Project Baseline

Accurately tracking project performance and comparing it against the baseline helps you to answer questions such as:

Are tasks starting and finishing as planned? If not, what will be the impact on the finish date?

Are resources completing the proper amount of the scope? Are they doing unapproved work (scope creep)?

Are resources requiring more or less than the scheduled amount of time to complete tasks?

Are tasks being completed above or below scheduled cost?

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

13

Step by Step: Establish a Project Baseline

There are several ways to track progress in Microsoft Project, depending on the level of detail or control required by you, the stakeholders, and the project sponsor—the individual or organization that provides financial support and supports the project team within the larger organization.

Because tracking requires more work from you and possibly from the resources working on the project, you need to determine the level of detail you need.

In this lesson, we will examine the following different levels of tracking:

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

14

Step by Step: Establish a Project Baseline

Project work as scheduled. This works best if everything in the project occurs exactly as it was scheduled.

Record each task’s percentage of completion. You can do this at precise values or at increments such as 25%, 50%, 75%, and 100%.

Record the actuals. The actual start, actual finish, actual work, and actual and remaining duration for each task or assignment are recorded.

Track assignment-level work by time period. You record actual work values by day, week, or other time interval that you select. This is the most detailed level of tracking. This is rarely used as a method of tracking project progress as it is too costly and time consum- ing for the added benefit of detailed information.

You can apply a combination of these approaches within a single project, as different parts of a project may have different tracking needs.

Tracking a Project as Scheduled

Once a baseline has been saved for a project schedule, the work done on the project can be tracked against the baseline values.

The simplest approach to tracking is to report that the actual work is proceeding as planned.

You record project actuals by updating work to the current date.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

16

Step by Step: Track a Project as Scheduled

USE the project schedule you created in the previous exercise.

1. On the ribbon, click Gantt Chart. The Gantt Chart view appears.

2. Move the vertical divider bar to a point just to the right of the Start column.

3. Click on the Project tab, and then click Update Project in the Status group. The Update Project dialog box appears.

4. Make sure the Update work as complete through option is selected. In the adjacent date box, type or select February 12, 2016, and then click OK. Microsoft Project records the actual work for the projects that were scheduled to start before February 12. It also draws progress bars in the Gantt bars for those tasks to show this progress visually.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

17

Step by Step: Track a Project as Scheduled

5. Select the name of task 5, Develop production layouts. Click the Task tab, and then click Scroll to Task in the Editing group. Your screen should look similar to the figure below.

6. SAVE the project schedule.

PAUSE. LEAVE the project schedule open to use in the next exercise.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

18

Step by Step: Track a Project as Scheduled

In this exercise, you updated the project to show that work had occurred as scheduled through a certain date.

This date is sometimes called the data date or status date—the date up to or through which all progress information is collected and entered for a project.

The progress bar in the Gantt Chart view shows how much of each task has been completed.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

19

Step by Step: Track a Project as Scheduled

A check mark appears in the Indicators column for tasks 2 and 3 to indicate these tasks have been completed.

In addition, a progress bar is drawn through the entire length of these tasks’ Gantt bars.

Because only a portion of task 5 has been completed by February 12, the progress bar for this task only extends to February 12 and no check mark appears in the Indicators column.

Also notice that because some of the recurring status meetings have been completed by February 12, progress bars appear in the summary Gantt bars for these tasks.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

20

Entering the Completion Percentage for a Task

As you continue to make progress on your project, it is important to record the work that has been done on a task.

There are many ways to record this work. One of the quickest ways is to record the completion percentage of the task.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

21

Step by Step: Enter the Completion Percentage for a Task

USE the project schedule you created in the previous exercise.

1. Click the View tab, click the Tables button, and then select the Work table from the list.

2. Slide the vertical divider bar between the table and the Gantt bar chart so that more of the table columns are visible. You may need to auto fit the columns to see all the data. Notice the Work and % Work Complete columns. You will enter task completion percentages in the % Work Complete column.

3. In the % Work Complete column for Task 5, type or select 100, and then [press Enter]. Microsoft Project extends the progress bar through the length of the Gantt bar for task 5 and records the actual work for the task as scheduled.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

22

Step by Step: Enter the Completion Percentage for a Task

4. Select Task 5 again. On the ribbon, click Selected Tasks in the Zoom group. Your screen should look similar to the figure below.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

23

Take Note: You can also use the schedule percent complete buttons to quickly update tasks that are 0%, 25%, 50%, 75%, and 100% complete. The schedule percent complete buttons are located in the Schedule group on the Task tab. Select the task you want to update, and then click the appropriate percentage button.

23

Step by Step: Enter the Completion Percentage for a Task

5. In the % Work Complete field for Task 6, type or select 50, and then [press Enter]. Microsoft Project records the actual work for the task as scheduled, calculates the remaining work, and then updates the progress line through 50% of the Gantt bar.

6. Scroll the Gantt Chart to see the Gantt bar for Task 6.

7. SAVE the project schedule.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

24

Step by Step: Enter the Completion Percentage for a Task

8. CLOSE the project schedule. In the next exercise, you will use an updated version of the Don Funk Music Video 9 project schedule to simulate the passage of time.

PAUSE. LEAVE Microsoft Project open to use in the next exercise.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

25

Take Note: You can view a task’s completion percentage and other tracking information by pointing to a progress bar in a task’s Gantt bar. A ScreenTip will appear.

25

Step by Step: Enter the Completion Percentage for a Task

There are several ways you can quickly record task progress as a percentage:

Use one of the % complete fields in either the Work or Tracking tables.

Use the preset buttons for recording 0%, 25%, 50%, 75%, and 100% completion on a task.

Use the Update Tasks dialog box (on the Task ribbon, click the down-arrow to the right of the Mark on Track button, and then click Update Tasks).

Use the General tab of the Task Information dialog box (by double-clicking the task you want to update) to update the Percent Complete field.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

26

Step by Step: Enter the Completion Percentage for a Task

Using the last two methods, you can also enter any percentage you want.

When you use any of these methods to enter a percentage other than 0% complete, Microsoft Project changes the task’s actual start date to match its scheduled start date. It also calculates actual duration, remaining duration, actual costs, and other values, based on the percentage you enter.

In deciding to use “percent complete” as a method of tracking progress, understand that there are four types of percent complete:

Physical % Complete: based on some physical measurement. For example, if you are constructing a two-mile road, and you complete one mile of it, you are physically 50% complete.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

27

Step by Step: Enter the Completion Percentage for a Task

Work % Complete: based on the planned amount of work. For example, if you planned to spend 10,000 hours of effort building a two mile road, and you spent 4000 hours to build the first mile, you are only 40% work % complete, even though you are 50% physically complete.

Cost % Complete: based on the approved budget. For example, if the total approved budget for a two-mile road was $468,000, and you have spent $140,000 to build the first mile, you are only about 29.9% cost % complete, even though you have completed half of the total road.

Schedule % Complete: based on planned duration. For example, if a two-mile road project was planned for 120 days, and you built the first mile in 30 days, you are 25% schedule % complete, even though you have completed half the total road.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

28

Identifying Over Budget Tasks and Resources

So far, you have focused on a project’s schedule as a key part of the overall success of the project.

However, another critical piece of information is the cost variance, or how the actual costs compare to the projected costs.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

29

Step by Step: Identify Over Budget Tasks and Resources

GET READY. To identify over budget tasks and resources, perform the following steps.

1. OPEN the Don Funk Music Video 9MA project schedule.

2. SAVE the file as Don Funk Music Video 9A.

3. On the ribbon, click the Project tab, and then click Project Information in the Properties group. The Project Information Dialog box appears.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

30

Step by Step: Identify Over Budget Tasks and Resources

4. Click the Statistics button. The Project Statistics dialog box appears. Your screen should look similar to the figure below.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

31

Step by Step: Identify Over Budget Tasks and Resources

The Cost column displays the current, baseline, actual, and remaining cost values for the entire project.

The current cost is the sum of the actual and remaining cost values.

The baseline cost is the total planned cost of the project when the baseline was saved.

The actual cost is the cost that has been incurred so far (after the indicated total work has been completed).

The remaining cost is the difference between the current cost and actual cost.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

32

Step by Step: Identify Over Budget Tasks and Resources

It is obvious that some cost variance has occurred, but it is not possible to tell from the Project Statistics dialog box when or where the variance occurred.

5. Click the Close button. The Project Statistics dialog box closes.

6. On the ribbon, click View. Click the Tables button and then click Cost. The Cost table appears in the Task Sheet view. Move the vertical divider so you can see all the available columns. Take a moment to review the columns in the Cost table. Note that although costs are not scheduled in the same sense that work is scheduled, costs (except fixed costs) are derived from the scheduled work.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

33

Another Way: To change the table, you can also right-click on the upper left corner of the active table and click Cost in the short-cut menu that appears.

33

Step by Step: Identify Over Budget Tasks and Resources

7. Click the Task Name column heading. Click the Outline button in the Data group, and then select Level 1. Microsoft Project collapses the task list to display only the first level of summary tasks (which in this case correspond to the major phases of the project). Your screen should look similar to the figure below.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

34

Step by Step: Identify Over Budget Tasks and Resources

8. Click the expand button next to Task 28, Production. Using the collapse button, hide the subtasks for scenes 1 through 4. Your screen should look similar to the figure below. Although Scenes 1 and 2 both had some variance, Scene 2 had the greater variance, so you will focus on that scene.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

35

Step by Step: Identify Over Budget Tasks and Resources

9. Click the expand button next to summary Task 38, Scene 2. Microsoft Project expands the Scene 2 summary task to show all of the subtasks. Your screen should look similar to the figure below.

10. Click the Task Name column heading.

Take note of the variance column. It shows that most of the Scene 2 variance can be tracked to Task 42, Scene 2 vocal recording.

36

Step by Step: Identify Over Budget Tasks and Resources

11. Click the Outline button and then select Show Subtasks button on the Formatting toolbar. Microsoft Project expands all of the summary tasks to show all of the tasks in the project.

12. On the View ribbon, in the Data group, click the down-arrow next to the Filter: selection box. Select More Filters from the list. The More Filters dialog box appears.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

37

Another way to look for tasks that are over budget is with a filter.

37

Step by Step: Identify Over Budget Tasks and Resources

13. Select the Cost Overbudget filter and click Apply. Microsoft Project applies the filter to the task list to show only those tasks that had actual and scheduled costs greater than their baseline costs. Your screen should look similar to the figure below.

14. SAVE the project schedule.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

38

Step by Step: Identify Over Budget Tasks and Resources

15. CLOSE the project schedule. In the next exercise, you will use an updated version of the Don Funk Music Video 9 to simulate the passage of time.

PAUSE. LEAVE Microsoft Project open to use in the next exercise.

Project managers and stakeholders often focus on the project schedule (Did tasks start and finish on time?). For projects such as this one that include cost information, cost variance is another critical indicator of overall project health.

In Microsoft Project, evaluating cost variance enables you to make incremental budget adjustments for individual tasks to avoid exceeding your project’s overall budget.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

39

Identifying Time and Schedule Problems

In complex projects, it is very likely that there will be some schedule variance.

The project manager must control the project by identifying, understanding, and correcting the problem.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

40

Step by Step: Reschedule Uncompleted Work

GET READY. To reschedule uncompleted work, perform the following tasks:

1. OPEN the Don Funk Music Video 9MB project schedule from the data files for this lesson.

2. SAVE the file as Don Funk Music Video 9B in the solutions folder for this lesson as directed by your instructor.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

41

Step by Step: Reschedule Uncompleted Work

3. [Press the F5 key]. Type 46 in the ID box, and then click OK. The Gantt Chart view scrolls to display the Gantt bar for Task 46, Scene 3. At this point in the project, the first two scheduled scenes have been completed. This task has one day of actual work completed and one day of scheduled work remaining. Your screen should look similar to the figure below.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

42

Step by Step: Reschedule Uncompleted Work

You have just been informed that late on the afternoon of June 6, a lightning strike caused a nearby electrical transformer to short-circuit and repairs will not be completed until Thursday, June 9. You will not be able to resume work in the studio until Friday, June 10.

5. On the ribbon, click the Project tab, and then click Update Project. The Update Project dialog box appears.

6. Select the Reschedule uncompleted work to start after: option, and in the date box type or select 06/09/16.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

43

Step by Step: Reschedule Uncompleted Work

7. Click OK to close the Update Project dialog box. Microsoft Project splits Task 48 so that the incomplete portion is delayed until Friday, June 10. Your screen should look similar to the figure below. Note that although the duration of Task 48 remains at two days, its finish and subsequent start dates for successor tasks have been pushed out. Remember that duration is the number of work periods required to complete a task, not elapsed time.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

44

Take Note: It is possible to disable the ability of Microsoft Project to reschedule uncompleted work on tasks that are showing any actual work. Click the File tab then select Options. In the Options dialog box, click the Schedule tab. In the section that reads Scheduling options for this project, clear the Split in-progress tasks check box.

44

Step by Step: Reschedule Uncompleted Work

8. SAVE the project schedule. CLOSE the project schedule.

PAUSE. If you are continuing to the next lesson, keep Project open. If you are not continuing to additional lessons, CLOSE Project.

Depending upon the length and complexity of your project, as a project manager you may see one or many of these types of interruptions.

When you reschedule incomplete work, you specify the date after which work can resume.

Microsoft Project handles tasks in relation to the scheduled restart date in the following ways:

If the task does not have any actual work recorded for it prior to the rescheduled date and there is no constraint in place, the entire task is rescheduled to begin after that date.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

45

Step by Step: Reschedule Uncompleted Work

If the task has some actual work recorded prior to but not after the rescheduled date, the task is split so that all remaining work starts after the rescheduled date. The actual work is not affected.

If the task has some actual work recorded for it prior to as well as after the rescheduled date, the task is not affected.

Keep in mind that when you address a problem by rescheduling a task, you may create other issues or problems in the remainder of the project. This is why project management is an iterative process: a change in one part of the schedule–be it a time, cost, or scope change–can, and usually does, affect the schedule elsewhere.

When changing or correcting the schedule due to unforeseen delays, such as the scenario in this exercise, you should also place a note in the notes field of the affected task(s) stating why the task has been changed. These become helpful when looking for explanations regarding why the project is not performing to the baseline.

Skill Summary

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

47

image1.png

image2.png

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.png

image12.png

image13.png

MS project tutorial/Project2013_Lesson10.pptx

Project Reporting

Lesson 10

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

1

Microsoft Project 2013

1

Objectives

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

2

Software Orientation

The new Report Ribbon makes locating and selecting a report easier than ever before. With predefined dashboard reports, the user can show an overview of the project, project burn- down, cost overview, work overview and many more.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

3

Software Orientation

The Project Overview Dashboard provides the basic information need to present project performance to date, which tasks are late, which milestones are coming dues and an overall percent complete.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

4

Activate and Print a Dashboard Report

Using a Dashboard report you can quickly see all of the major information about your project then print the information on paper.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

5

Step by Step: Select and Print a Dashboard Report

GET READY. Before you begin these steps, launch Microsoft Project 2013.

1. OPEN the Don Funk Music Video 10M project schedule.

2. SAVE the file as Don Funk Music Video 10.

3. On the ribbon, click the Project tab. In the Status group click the calendar icon in the Status Date field. Microsoft Project displays the Status Date dialog box.

4. In the Select Date: field type or select 6/10/16. Your screen should look like the figure at right.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

6

Step by Step: Select and Print a Dashboard Report

5. Click OK or press Enter to close the Status Date dialog box. You set the Status Date to tell Microsoft Project you want information as of this date.

6. On the ribbon, click the Report tab and then select the Dashboards button. From the dropdown menu that appears, select Project Overview. Your screen should look similar to the figure above.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

7

Step by Step: Select and Print a Dashboard Report

7. On the ribbon, click the File tab and then select Print from the navigation bar on the left side of the screen. Your screen should look similar to the figure at right. You may notice that some of the report is cut |off at the right side of the print pre- view area.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

8

Take Note: You may or may not see the Print Preview screens in color, depending upon the printer and print drivers you have installed.

8

Step by Step: Select and Print a Dashboard Report

8. At the lower right of the Settings section, click the Page Setup hyperlink. Microsoft Project displays the Page Setup dialog box.

9. On the Page tab, in the Scaling section, click Fit to: and choose 1 against the pages wide by and tall boxes. Your dialog box should look like the figure at right.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

9

Step by Step: Select and Print a Dashboard Report

10. Now select the Margins tab. Set all margins to 0.5 inches. Click the OK to close the dialog box. Your screen should now look like the figure below.

11. SAVE the project schedule.

PAUSE. LEAVE Project open to use in the next exercise.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

10

Step by Step: Select and Print a Dashboard Report

A report is anything the project manager uses to transmit information about the project. Most all reports are done in writing, using both words and graphics. Some reports are made available through dashboards.

A dashboard is a generic term used to mean an easy to read, single page interface (usually centrally located–such as a SharePoint web page) that senior management can quickly view to obtain a high-level view of current project status.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

11

Customize and Print a Report

Using the new options of the reports feature in Microsoft Project 2013 allows you to fully customize the information you wish to include in the report.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

12

Step by Step: Create, Customize and Print a Report

GET READY. USE the project schedule you created in the previous exercise.

1. Click the Report tab. On the ribbon, click the New Report button.

2. On the drop- down menu that appears, click Table.

3. In the Report Name box that appears, name the new report Remaining Work Report and then click OK. Your screen should look like the figure above.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

13

Step by Step: Create, Customize and Print a Report

4. At the top of the field list at the right of the screen, click Resources.

5. Using the scroll box at the right of the field list box, navigate down until the Work fields are visible and then select the expand button next to Work.

6. Select the check box next to Remaining Work.

7. In the Filter box, select Resources: Work.

8. In the Sort by box, select Name.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

14

Step by Step: Create, Customize and Print a Report

9. Auto fit the name and Remaining Work columns (make them wider so all information fits on one line) and then center the entire table on the screen under the report name.

10. Click the File tab and then select Print. You will note that the report may not be centered on the page. This is because the previous report was on Landscape orientation.

11. In the settings section, change the orientation to Portrait.

12. Click the return arrow at the top.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

15

Take Note: At this point, you can print the information by clicking the Print button (the print preview is adequate for purposes of this lesson). When printing in Microsoft Project 2013, there are additional options in the Print dialog box (the Print command is accessed from the File tab). For example, you can print specific date or page ranges.

15

Step by Step: Create, Customize and Print a Report

13. Click the minus sign on the zoom slider at the lower right portion of the screen two or three times. Manually move the table and the report name box to the center of the page. You will note page breaks are indicated by the dashed lines.

Step by Step: Create, Customize and Print a Report

14. Click the File tab and then select Print. You will note that the report is now centered on the page.

15. SAVE the project schedule.

PAUSE. LEAVE Project open to use in the next exercise.

Printing information from a project schedule to share with stakeholders is a common activity for project managers.

Stakeholders are the people or organizations that might be affected by project activities and can range from resources working on the project to customers receiving the project deliverables.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

17

Reporting Project Status

Microsoft Project provides many different ways to report a project’s status in terms of budget or variance.

A key part of a project manager’s job is knowing which stakeholders need to see which details in which format.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

18

Step by Step: Report Project Variance with a “Stoplight” View

USE the project schedule you created in the previous exercise.

1. Click the View tab, then in the Task views group, select Other Views then select More Views. In the list select Task Sheet and then click Apply. Microsoft Project displays the Task Sheet view.

2. Select the Tables button and then click Cost.

3. Click on the Project tab, and then click the Custom Fields button. The Custom Fields dialog box appears.

4. Under the Field label at the top of the dialog box, make sure that Task is selected. In the Type box, select Number from the dropdown list.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

19

Step by Step: Report Project Variance with a “Stoplight” View

5. In the Field list, select Overbudget (Number3).

6. Under the Custom attributes label, click the Formula button. The Formula dialog box is displayed. The formula shown in this dialog box has been pre-entered for accuracy and to save time. Your screen should look similar to the figure below.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

20

Step by Step: Report Project Variance with a “Stoplight” View

The formula evaluates each task’s cost variance.

If the task is above 20 percent above baseline, the formula assigns the number 30 to the task; if it is between 20 percent and 10 and percent, a 20; and if below 10 percent, a 10. If the task does not fit within those criteria, such as the case with a milestone task which should have no costs, the formula returns a zero value.

Note: For the purposes of this project, a variance of 20 percent above baseline has been decided on by the project manager and sponsor as the maximum tolerance level.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

21

Step by Step: Report Project Variance with a “Stoplight” View

7. Click Cancel to close the Formula dialog box.

8. In the Custom Fields dialog box, under the Values to display label, click the Graphical Indicators button. The Graphical Indicators dialog box appears. This dialog box enables you to specify a unique graphical indicator to display, depending on the value of a field for each task. In this usage, the values returned from the formula in the figure on slide 20 are used to assign the graphical indicator. To save time, the indicators have already been selected.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

22

Step by Step: Report Project Variance with a “Stoplight” View

9. Click the first cell under the Image column heading, and then click the downarrow. Here you can see the many graphical indicators you can associate with the values of fields.

10. Click Cancel twice to close the Graphical Indicators dialog box, and then click Cancel again to close the Custom Fields dialog box.

11. Right-click the Fixed Cost column heading. Select Insert Column from the list.

12. From the keyboard, start typing the word “Over”.

Notice how Project narrows the list down as you type. You can also navigate using the scroll bar to Overbudget (Number3).

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

23

Step by Step: Report Project Variance with a “Stoplight” View

Microsoft Project displays the Overbudget column in the Cost table. Your screen should look similar to the figure below.

Step by Step: Report Project Variance with a “Stoplight” View

The custom field Overbudget (Number3) displays a graphical indicator that represents one of three different levels of cost variance.

The graphical indicators will change, according to the ranges specified in the formula, as each task’s cost variance changes. This is a useful format for identifying tasks whose cost variance is higher than you would like (as indicated by the red and yellow indicators).

This makes it easy for any stakeholder to quickly scan the task list and locate tasks that need further attention.

13. SAVE the project schedule.

PAUSE. LEAVE Project open to use in the next exercise.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

25

Step by Step: Report Project Variance with a “Stoplight” View

In this exercise, you used a custom field with a custom formula to create a custom stoplight report.

As a project manager, you will find many ways to present the current status of your project. Bear in mind the audience of the report. For example, you will want to present high level information to upper management. Conversely, you will want to give detailed information to the project team.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

26

Cross Ref: You will learn more about saving Microsoft Project data in other formats in lesson 12.

26

Using Visual Reports

The Visual Reports feature of Microsoft Project 2013 combines the power of Microsoft Excel and Microsoft Visio with the data of your project to create high impact, visually centered reports.

You can use a preformatted report, edit a report or create a new report that includes a specific set of fields from Microsoft Project.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

27

Step by Step: Create a Visual Report

USE the project schedule you created in the previous exercise.

1. On the ribbon, click the Report tab, and then select the Visual Reports button. The Visual Reports–Create Report dialog box appears. Your screen should look like the figure at right.

2. Click the Task Usage tab, and then click Cash Flow Report.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

28

Step by Step: Create a Visual Report

3. In the Select level of usage data to include in the report: box, select Months.

4. Click the View button. The Visual Report engine gathers data from your project file and builds an Online Analytical Processing (OLAP) cube. The application Microsoft Excel opens and the report is presented in Chart form from a preformatted report template. Your screen should look similar to the figure above.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

29

Step by Step: Create a Visual Report

5. At the bottom of the Excel window, select the Task Usage sheet tab.

6. In the PivotTable Field List box, navigate to the Time field. Place your cursor on Monthly Calendar and drag it to the Rows box. Your screen should look similar to the figure at right.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

30

Step by Step: Create a Visual Report

7. In the PivotTable area, click the expand button next to the year 2016, to reveal all the available time data. Your screen should look similar to the figure at right.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

31

Step by Step: Create a Visual Report

8. Click the Chart1 sheet tab at the bottom of the screen. Your screen should look similar to the figure at right.

9. Save the Excel visual report as Don Funk Cash Flow in your My Documents folder or another folder directed by your instructor.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

32

Step by Step: Create a Visual Report

10. CLOSE Microsoft Excel.

11. CLOSE the Visual Reports Dialog box.

12. SAVE the project schedule.

PAUSE. LEAVE Project open to use in the next exercise.

In this exercise, you created a new visual report.

A visual report is a specific type of report that utilizes the combines the power of either Microsoft Excel or Microsoft Visio and the data which you have created in your project file.

The data is translated into pivot tables and graphs. You must have Microsoft Excel 2007 or newer to view the Excel reports with the Visual Reports feature.

You must have Microsoft Visio 2007 Professional or higher installed on your system to view the Visio reports. If this is not installed, the Visio reports will not be listed in the dialog box.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

33

Customizing and Printing a View

Using a view, you can see your project schedule information on screen.

You can change what you see by customizing the view.

You can also apply these customized views to print the information on paper.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

34

Step by Step: Customize and Print a Gantt Chart View

USE the project schedule you created in the previous exercise.

1. Click the View tab, then select the Gantt Chart button.

2. Click the File tab and then click Print. Microsoft Project displays print options on the left side and the Gantt Chart view in the right side, which is the Print Preview window. Your screen should look like the figure above.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

35

Step by Step: Customize and Print a Gantt Chart View

3. On the Print Preview toolbar, click the Page Right and/or Page Down button to display different pages.

4. On the Print Preview toolbar, click the Multiple Pages button. Most of the pages of the Gantt Chart appears in the Print Preview window. When the multiple pages Print Preview is active the printed output is displayed on separate sheets. You navigate using the scroll control at the bottom of the Print Preview pane. The Page Right, Page Left, Page Up, and Page Down buttons are inactive. The paper size displayed is determined by your printer settings. Your screen should look similar to the figure on the next slide.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

36

Step by Step: Customize and Print a Gantt Chart View

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

37

Step by Step: Customize and Print a Gantt Chart View

The left side of the Print Preview Toolbar status bar should read “3 rows 3 columns.” In the Print Preview window, this means there are three rows of pages by three columns of pages, for a total of nine pages. The status bar can help you quickly determine the total number of pages your printed view will be.

5. On the Print Preview toolbar, click the One Page button. The first page of the Gantt Chart is displayed.

6. Click the Page Setup hyperlink. The Page Setup dialog box appears. This is the same dialog box that would appear if you selected the Page Setup option on the File tab.

7. Click the Header tab. You want to add the company name to the header that prints on each page.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

38

Step by Step: Customize and Print a Gantt Chart View

8. There are three Alignment tabs in the center section of the Header tab box. Select Center if it is not already selected. In the General box, click Company Name and then click the Add button next to the General box. Microsoft Project places the following code into the header: &[Company]. The software also displays a preview in the Preview window of the Page Setup dialog box.

9. Click the Legend tab. You want to change some of the content of the Gantt Chart view’s legend.

10. There are three Alignment tabs in the center of the Legend tab box. Click the Left tab. Currently, Microsoft Project is formatted to print the project title and current date on the left side of the legend. You also want to print the start date and duration on the right side of the legend.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

39

Step by Step: Customize and Print a Gantt Chart View

12. Click the Right Alignment tab. Click the Right Alignment box, press Enter, and then type Start: followed by a space.

13. In the General box, select Project Start Date from the dropdown list. Click the Add button next to the General box. Microsoft Project adds the label and code for the project start date to the legend.

14. Press Enter to add a second line to the legend and then type Duration: followed by a space.

15. In the Project Fields box, select Scheduled Duration from the dropdown list. Click the Add button next to the Project Fields box. Microsoft Project adds the label and code for project duration to the legend.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

40

Step by Step: Customize and Print a Gantt Chart View

16. In the Width box, type or use the scroll buttons to enter 3. This increases the width of the box that appears on the left side of the legend. Your screen should look similar to the figure above.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

41

Step by Step: Customize and Print a Gantt Chart View

17. Click OK to close the Page Setup dialog box. Microsoft Project applies the custom changes to the legend.

18. Move your mouse cursor to the lower left corner of the page preview (your cursor appears as a magnifying glass). Click the lower left corner of the page. Microsoft Project zooms in to show the legend. Your screen should look similar to the figure on the next slide.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

42

Take Note: At this point, you can print the project schedule by clicking the Print button (the print preview is adequate for purposes of this lesson). When printing in Microsoft Project 2013, there are additional options in the Print dialog box (the Print command is accessed from the File tab). For example, you can print specific date or page ranges.

42

Step by Step: Customize and Print a Gantt Chart View

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

43

Step by Step: Customize and Print a Gantt Chart View

The data you added to the legend will print on every page of the printed output.

19. Click the Task tab to return to the Gantt Chart view. Take note that although you did not print, your changes to the header and the legend will be saved when you save the project file.

20. SAVE the project schedule.

PAUSE. If you are continuing to the next lesson, keep Project open. If you are not continuing to additional lessons, CLOSE Project.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

44

Step by Step: Customize and Print a Gantt Chart View

In a view, you can enter, read, edit, and print information. In a report, you can only print the information, you cannot change the data. Printing a view allows you to provide, on paper, almost everything you see on your screen. You can print any view you see in Microsoft Project, with just a few exceptions.

You cannot print form views (for instance, Task Form) or certain diagrams, such as the Relationship Diagram.

If you have two views displayed in a combination view (one view in the top pane and the other view in the bottom pane), only the view in the active pane will print.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

45

Cross Ref: For a review of the types of views, including form views, refer back to Lesson 8.

45

Step by Step: Customize and Print a Gantt Chart View

In this lesson, you applied some custom formulas and graphical indicators to make it simple to review the status of tasks using the Task Sheet view.

Communicating the project status to stakeholders is one of the most important functions of a project manager and one that may occupy a significant portion of your working time.

It is imperative that the project manager know who needs to know the project status and why, as well as in what format and level of detail these people need the information.

The time to find the answers to these questions is in the initial planning stages of the project.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

46

Step by Step: Customize and Print a Gantt Chart View

Once work on the project has commenced, your primary communication task will be reporting project status. This can take several forms:

Status reports describe where the project is in terms of scope, cost, and schedule. These are often referred to as the triple constraint, which is a popular model of project management.

Progress reports that provide the specific accomplishments of the project team.

Forecasts that predict future project performance.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

47

Step by Step: Customize and Print a Gantt Chart View

Standard report formats may already exist if your organization is highly focused on projects and project management. If your organization does not have standard reports, you may be able to introduce project status formats that are based on clear communication and project management principles. You may be able to report project status using some of the following:

Printing the Project Overview dashboard report.

Copying Microsoft Project data to other applications. For example, you could copy the Calendar view to Microsoft Office Word or Microsoft Office PowerPoint.

Saving Microsoft Project data in other formats, such as Excel, HTML or GIF.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

48

Step by Step: Customize and Print a Gantt Chart View

It is important to keep in mind that the part of the project schedule you see on your screen is only a small part of the total project. For example, to print a six-month project with 75 tasks may require more than a dozen letter-sized pages.

In general, Gantt Charts and Network Diagrams can use significant amounts of paper on large projects.

Some experienced project managers who regularly use Microsoft Project print their projects on poster-sized paper using plotters (a type of printer that draws pictures or graphs using attached pens) or other specialized printing equipment.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

49

Step by Step: Customize and Print a Gantt Chart View

Projects with several hundred tasks or long time frames will not print legibly on letter or legal-sized paper.

To reduce the number of required pages, you can print just summary tasks or filtered data.

If you are interested in a specific timeframe, you can print just that portion of the timescale, which is the band across the top of the Gantt Chart grid that denotes units of time.

A filter could be applied to display only the information that is of interest to a specific audience. In any case, it is a good idea to preview the views you want to print.

By using the Page Setup dialog box along with the Print Preview window, you can control many features of the view to be printed. For example, you can set the number of pages on which the view will be printed, apply headers and footers, and determine content that appears in the legend of the Gantt Chart and some other views.

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

50

Take Note: When printing in views that contain a timescale, such as the Gantt Chart view, you can change the number of pages required by adjusting the timescale before printing. To adjust the timescale so that it shows the largest time span in the smallest number of pages, click the View tab, then in the Zoom group, click Entire Project.

50

Skill Summary

© 2014, John Wiley & Sons, Inc.

Microsoft Official Academic Course, Microsoft Project 2013

51

image1.png

image2.png

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.png

image12.png

image13.png

image14.png

image15.png

image16.png

image17.png

image18.png

image19.png

image20.png

image21.png

Reading Assignment/Chapter17.ppt

Chapter 17

Risk Management

Basic Concept

  • Risk management focuses on:

Known unknowns

Proactive management

The alternative to proactive management is reactive management, also called crisis management. This requires significantly more resources and takes longer for problems to surface.

RISK MANAGEMENT

  • RISK MANAGEMENT FOCUSES ON THE FUTURE
  • RISK AND INFORMATION ARE INVERSELY RELATED

RISK MANAGEMENT (CONT.)

  • HISTORICALLY, WE FOCUSED OUR ATTENTIONS ON SCHEDULE AND COST RISK MANAGEMENT.
  • TODAY, OUR PRIMARY EMPHASIS IS ON TECHNOLOGICAL RISK MANAGEMENT:

CAN WE DESIGN IT AND BUILD IT?

WHAT IS THE RISK OF OBSOLESCENCE?

Definition Of Risk

Risk = f(Likelihood, Impact)

  • Likelihood is the probability of occurrence
  • Impact is the amount at stake

event

Tolerance For Risk

  • Risk avoider
  • Risk neutral
  • Risk lover

Decision-Making Categories

  • Complete uncertainty
  • Relative uncertainty (partial information)
  • Complete certainty

Maximin Approach

Maximax Approach

Minimax regret Approach

Insufficient Reason Approach

Developing and Using Payoff Tables

Establishing the procedure to follow

Construct the

Payoff table

Decision-making

under certainty

Decision-making

under complete

uncertainty

Decision-making

under risk

Expected Monetary Value (EMV) Approach

Expected Opportunity Loss (EOL) Approach

Expected Value of Perfect Information (EVPI) Approach

FIVE STEPS TO DEVELOP PAYOFF TABLE

  • List all the alternatives.
  • List the future consequences of each alternative.
  • Identify the payoffs associated with each combination.
  • Assess the degree of certainty that these combinations will materialize
  • Decide on a decision criterion.

Risk Management Processes

  • Risk planning
  • Risk assessment

Risk identification

Risk analysis/quantification

  • Risk handling
  • Risk monitoring

Developing Contingency Plans

Types Of Risks (General)

  • Business risks
  • Insurable (pure) risk

Direct property damage

Indirect consequential loss

Legal liability

Personnel

Types Of Risk (PMI Method)

  • External – unpredictable
  • External – predictable
  • Internal – non-technical
  • Internal – technical
  • Legal

Risk Types at Boeing

  • Financial risks
  • Market risks
  • Technical risks
  • Production risks

Risk Quantification

STAGE I

STAGE II

GUID-

ANCE

WARHEAD

COST

MANU.

TEST

DESIGN

HIGH

MEDIUM

LOW

LEGEND

PROGRAM

SUMMARY

Risk Handling

  • Assumption (retention)
  • Avoidance
  • Control (mitigation)
  • Transfer

Risk Problem-Solving

Idea Generation:
Brainstorming

Special Topics In Risk Management

Future Risks

Customer’s
Knowledge

Experienced

Inexperienced

Simple

Complex

Contract Type

Future Risks

Customer’s
Knowledge

Experienced

Inexperienced

Simple

Complex

Contract Type

INCREASING RISKS

How Much Risk Is Acceptable?

  • High tolerance for risk
  • Medium tolerance for risk
  • Low tolerance for risk

Degrees of Downstream Risk

R&D

Manufacturing

Marketing

Time

Low Risk

Degrees of Downstream Risk

R&D

Manufacturing

Marketing

Information Exchange

Time

Moderate Risk

Degrees of Downstream Risk

R&D

Manufacturing

Marketing

Time

High Risk

Prioritization of Risks

Schedule

Cost

Technical
Performance
or Quality

First (Highest)
Priority

Second
Priority

Third
Priority

Risk Controls

Schedule Length

Risk Controls

Appropriate

Too
Long

Low

High

Too Many
Risk Management
Filters and
Gates

No
Risk Plan

Risk Control Measures

Intensity of Controls

Risk Intensity

Standard
Controls

High

Low

Low

Extreme

Range of Controls

Project Procedural
Documentation

Guidelines

High

Low

Tolerance for Risk

Which Method to Use?

Rigid
Policies/

Procedures

Assumption

Reduction

Transfer

Avoidance

The Risk-Reward Matrix

Low

High

Reward

Medium

Risk

High

Low

Medium

Quality of

Resources Needed

Low

Medium

High

Specification Limit
On Characteristic B

Interacting Risks

Product Feature A

Product Feature B

Desirable

Undesirable

Undesirable

Desirable

Poor Risk Management

Risk Planning

Technical
Inability

Customer Expectations

Actual Performance

Performance

Time

Reading Assignment/Chapter20.PPT

Chapter 20

Quality Management

Quality Drivers

Higher performance requirements

Faster product development

Higher technology levels

Materials and processes pushed to the limit

Lower contractor profit margins

Fewer defects/rejects

Market Expectations

Salability: the balance between quality and costs

Produceability: the ability to produce the product with available technology and workers, and at an acceptable cost

Social acceptability: the degree of conflict between the product or process and the values of society (i.e., safety, environment)

Operability: the degree to which a product can be operated safely

Market Expectations (Continued)

Availability: the probability that the product, when used under given conditions, will perform satisfactorily when called upon

Reliability: the probability of the product performing without failure under given conditions and for a set period of time

Maintainability: the ability of the product to be retained in or restored to a performance level when prescribed maintenance is performed

Strategic Quality Management

Quality is defined by the customer.

Quality is linked with profitability on both the market and cost sides.

Quality has become a competitive weapon.

Quality is now an integral part of the strategic planning process.

Quality requires an organization-wide commitment.

ACT

CHECK

PLAN

DO

  • Immediate

Remedies

  • Future Actions
  • Objectives
  • Methods
  • Against Objectives
  • How Methods are
  • Train
  • Execute

The Deming Cycle For Continuous Improvement
(Also Known as The Shewhart Cycle)

Executed

Degrees of Quality

Structural (length, frequency)

Sensory (taste, beauty, appeal)

Time-oriented (reliability, maintainability)

Commercial (warrantee)

Ethical (courtesy, honesty)

Quality Expectations

Quality policy

Quality objectives

Quality assurance

Quality control

Quality audit

Quality program plan

Quality Policy

Be a statement of principles, stating what, not how

Promote consistency throughout the organization and across projects

Provide and explanation to outsiders of how the organization views quality

Provide specific guidelines for important quality matters

Provide provisions for changing/updating the policy

Quality Objectives

Be obtainable

Define specific goals

Be understandable

State specific deadlines

Quality Assurance

Identify objectives and standards

Be multifunctional and prevention oriented

Plan for collection and use data in a cycle of continuous improvement

Plan for the establishment and maintenance of performance measures

Include quality audits

Quality Control

Select what to control

Set standards that provide the basis for decisions regarding possible corrective action

Establish the measurement methods used

Compare the actual results to the quality standards

Act to bring nonconforming processes and material back to the standard based on the information collected

Quality Control (Continued)

Monitor and calibrate measuring devices

Include detailed documentation for all processes

Quality Audit

The planned quality for the project will be met.

The products are safe and fit for use.

All pertinent laws and regulations are followed.

Data collection and distribution systems are accurate and adequate.

Proper corrective action is taken when required.

Improvement opportunities are identified.

Quality Plan

Identify all of the organization’s external and internal customers

Cause the design of a process that produces the features desired by the customer

Bring in suppliers early in the process

Cause the organization to be responsive to changing customer needs

Prove that the process is working and that quality goals are being met

Prevention: cost associated

with design and planning

of a quality control (QC)

program

Appraisal: costs involved

in the direct appraisal of

quality both in the plant

and in the field

Internal failure: costs

directly related to the

occurrence of defective

production within the plant

External failure: costs

associated with the failure

of a product or service in

the field

·

QC administration and

systems planning

·

Quality training

·

Quality planning (QC

engineering work)

Incoming, in-process,

final inspection, and

test planning

Special processes

planning

Quality data analysis

and feedback

Procurement planning

Vendor surveys, audit

and surveillance

planning

Reliability studies

·

Design and development

of quality measurement

and control equipment

·

Qualification of material

·

Testing

·

Inspection

·

Quality audits

·

Incoming test and

inspection and laboratory

acceptance

·

Checking labor

·

Laboratory or other

measurement service

·

Setup for test and

inspection

·

Test and inspection

material

·

Outside endorsements

·

Maintenance and

calibration

·

Product engineering

review and shipping

release

·

Field Testing

·

Scrap, at full shop cost

·

Rework, at full shop cost

·

Scrap and rework, fault of

vendor

·

Material procurement

·

Factory contact

engineering

·

QC investigations (of

failures)

·

Material review activity

·

Repair and troubleshooting

·

Complaints and loss of

customer good will

·

Warranty cost

·

Field maintenance and

product service

·

Returned material

processing and repair

·

Replacement inventories

·

Strained distributor

relations

Cost of Quality (COQ)
Definitions & Examples

Check Sheets

  • Agree on what is being observed
  • Decide on time period
  • Design form
  • Collect data

Problem

Month

1

2

3

Total

5

3

12

20

|

|

||||

7

||

|

||

5

||

|

||||

8

A

B

C

TOTAL

Cause-And-Effect Analysis

METHOD

LOCATION

PEOPLE

MATERIAL

TESTING

CAUSE

EFFECT

MACHINE

PROBLEM

Cause-And-Effect Analysis (With “Bones” Inserted)

MACHINE

PROBLEM

SPEED TOO SLOW

SPEED TOO FAST

LOOSE

FITTINGS

WORN

CUTTER

EXCESSIVE

GEAR WEAR

Histogram

FREQUENCY

From Histogram To Pareto

FREQUENCY

FREQUENCY

Histogram

Pareto (Chosen Few)

Pareto Analysis

BEFORE

AFTER

FREQUENCY

FREQUENCY

Scatter Diagram

TEST SCORES, %

YEARS OF EXPERIENCE

Scatter Plot Correlation

NO CORRELATION

CURVILINEAR CORRELATION

POSITIVE CORRELATION

NEGATIVE CORRELATION

Scatter Charts That Correlate Well Are Also Referred To As Trend Charts.

The Bell-Shaped Curve

s

s

s

s

s

s

-1

-2

-3

+1

+2

+3

s

1

+

_

x

_

x

_

_

+

+

_

_

2

3

s

s

68 %

95 %

99.73 %

RANGE

AREA

68 %

95 %

99.73 %

x

_

x

Control Chart

UPPER SPECIFICATION LIMIT

LOWER SPECIFICATION LIMIT

UPPER CONTROL LIMIT

LOWER CONTROL LIMIT

CENTER LINE OF PROCESS

X

_

+3

s

-3

s

Normal Distribution Attributes

s)

SPECIFICATIONRANGE (+/- PERCENT WITHIN RANGE DEFECTS PER BILLION PARTS
1 68.27 317,300,000
2 95.45 45,400,000
3 99.73 2,700,000
4 99.9937 63,000
5 99.999943 57
6 99.9999998 2

Common Cause Variability

Common cause variability or variation: This source of random variation is always present in any process. It is that part of the variability inherent in the process itself. The cause of this variation can be corrected only by a management decision to change the basic process.

Common Cause Variability
(Continued)

Special cause variability or variation: This variation can be controlled at the local or operational level. Special causes are indicated by a point on the control chart that is beyond the control limit or by a persistent trend approaching the control limit.

Process Capability

USL - LSL

6

=

C

p

s

Capability Index

C

p

=

k

CL – NEAREST SPEC LIMIT

s

3

Sampling Plans

Single sampling: This is the acceptance or rejection of a lot based upon one sampling run.

Double sampling: A small sample size is tested. If the results are not conclusive, then a second sample is tested.

Multiple sampling: This process requires the sampling of several small lots.

Sampling Risks

Producer’s risk: This is called the  (alpha) risk or type I error. This is the risk to the producer that a good lot will be rejected.

Consumer’s risk: This is called the  (beta) risk or type II error. This is the consumer’s risk of accepting a bad lot.

Quality Circle Elements

They give a team effort.

They are completely voluntary.

Employees are trained in group dynamics, motivation, communications, and problem solving.

Members rely upon each other for help.

Management support is active but as needed.

Creativity is encouraged.

Management listens to recommendations.

Quality Benefits

Improved quality of products and services

Better organizational communications

Improved worker performance

Improved morale

Cost of Waste

Rejects of completed work

Design flaws

Work in progress

Improperly instructed manpower

Excess or noncontributing management (who still charge time to the project)

Improperly assigned manpower

Improper utilization of facilities

Excessive expenses that do not necessarily contribute to the project (i.e., unnecessary meetings, travel, lodgings, etc.)