{"id":350,"date":"2022-08-15T09:39:40","date_gmt":"2022-08-15T09:39:40","guid":{"rendered":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/chapter\/11-5-ms-project-tutorial\/"},"modified":"2024-12-29T02:15:58","modified_gmt":"2024-12-29T02:15:58","slug":"11-5-ms-project-tutorial","status":"publish","type":"chapter","link":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/chapter\/11-5-ms-project-tutorial\/","title":{"rendered":"11.5 MS Project Tutorial"},"content":{"raw":"This MS Project tutorial will elaborate on how to conduct an EVM analysis. Table 11.5.1 provides a project with 15 activities.\r\n<p style=\"text-align: center\"><strong>Table 11.5.1: Project Activities<\/strong><\/p>\r\n\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%\" border=\"0\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 21.0691%;text-align: center\"><strong>Activity<\/strong><\/td>\r\n<td style=\"width: 40.6918%;text-align: center\"><strong>Duration (weeks)<\/strong><\/td>\r\n<td style=\"width: 38.239%;text-align: center\"><strong>Predecessors<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">A<\/td>\r\n<td style=\"width: 40.6918%\">2<\/td>\r\n<td style=\"width: 38.239%\">--<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">B<\/td>\r\n<td style=\"width: 40.6918%\">3<\/td>\r\n<td style=\"width: 38.239%\">--<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">C<\/td>\r\n<td style=\"width: 40.6918%\">1<\/td>\r\n<td style=\"width: 38.239%\">A, B<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">D<\/td>\r\n<td style=\"width: 40.6918%\">3<\/td>\r\n<td style=\"width: 38.239%\">C<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">E<\/td>\r\n<td style=\"width: 40.6918%\">2<\/td>\r\n<td style=\"width: 38.239%\">C<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">F<\/td>\r\n<td style=\"width: 40.6918%\">2<\/td>\r\n<td style=\"width: 38.239%\">D, E<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">G<\/td>\r\n<td style=\"width: 40.6918%\">3<\/td>\r\n<td style=\"width: 38.239%\">E<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">H<\/td>\r\n<td style=\"width: 40.6918%\">4<\/td>\r\n<td style=\"width: 38.239%\">F, G<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">I<\/td>\r\n<td style=\"width: 40.6918%\">2<\/td>\r\n<td style=\"width: 38.239%\">H<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">J<\/td>\r\n<td style=\"width: 40.6918%\">6<\/td>\r\n<td style=\"width: 38.239%\">I<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">K<\/td>\r\n<td style=\"width: 40.6918%\">4<\/td>\r\n<td style=\"width: 38.239%\">J<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">L<\/td>\r\n<td style=\"width: 40.6918%\">3<\/td>\r\n<td style=\"width: 38.239%\">J<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">M<\/td>\r\n<td style=\"width: 40.6918%\">2<\/td>\r\n<td style=\"width: 38.239%\">J<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">N<\/td>\r\n<td style=\"width: 40.6918%\">2<\/td>\r\n<td style=\"width: 38.239%\">K, L, M<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 21.0691%\">O<\/td>\r\n<td style=\"width: 40.6918%\">1<\/td>\r\n<td style=\"width: 38.239%\">N<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n&nbsp;\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"626\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2022\/08\/Figure-11.2.jpg\" alt=\"The Microsoft Project screenshot showing all the project activities, the schedule, and the Gantt Chart\" width=\"626\" height=\"234\" class=\"wp-image-339 size-full\" \/> Figure 11.5.1: WBS, Schedule, and the Gantt Chart[\/caption]\r\n\r\nIn this project, the resources assigned to each activity are given in Table 11.5.2. All the resources are \"Work\" type resources, meaning they are either people or equipment.\r\n<p style=\"text-align: center\"><strong>Table 11.5.2: Resources and Costs<\/strong><\/p>\r\n\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 306px\" border=\"0\">\r\n<tbody>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\"><strong>Resource Name<\/strong><\/td>\r\n<td style=\"width: 46.2935%;height: 18px\"><strong>Standard Rate<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 18px\"><strong>Activities\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">a<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$20.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">A<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">b<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$40.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">B<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">c<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$30.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">C<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">d<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$15.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">D<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">e<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$35.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">E<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">f<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$50.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">F<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">g<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$30.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">G<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">h<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$25.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">H<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">i<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$40.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">I<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">j<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$40.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">J<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">k<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$25.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">K<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">l<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$25.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">L<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">m<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$20.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">M<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">n<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$35.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">N<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">o<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$50.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">O<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20.3731%;height: 18px\">Additional Cost 1<\/td>\r\n<td style=\"width: 46.2935%;height: 18px\">$35.00\/hr<\/td>\r\n<td style=\"width: 33.3333%;height: 18px\">C<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 20.3731%\">Additional Cost 2<\/td>\r\n<td style=\"width: 46.2935%\">$25.00\/hr<\/td>\r\n<td style=\"width: 33.3333%\">F<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<div align=\"center\"><\/div>\r\nUnder the View tab, we click the \u201cResource Sheet.\u201d Then, we can type the resource names and costs, as seen in Table 11.5.2. The Resource Sheet on MS Project is given in Figure 11.5.2.\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"529\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.3.jpg\" alt=\"Resource sheet including two additional costs\" width=\"529\" height=\"288\" class=\"wp-image-340 size-full\" \/> Figure 11.5.2: Resource Sheet[\/caption]\r\n\r\nLet\u2019s select all the resources except additional costs from the drop-down menu for each resource on the Gantt Chart view. Besides, we add a new column \u201cCost\u201d to the left of \u201cResource Names\u201d. As shown in Figure 11.5.3, the project's total estimated cost is $52,400. This figure would also be our BAC (Budget at Completion).\r\n\r\n&nbsp;\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"506\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.4.jpg\" alt=\"Microsoft Project screenshot showing the activity list with the resources assigned to each activity\" width=\"506\" height=\"283\" class=\"wp-image-341 size-full\" \/> Figure 11.5.3: Gantt Chart View with the Resources Selected[\/caption]\r\n\r\nUnder the \u201cTask\u201d tab, we can select \u201cTracking Gantt\u201d from the drop-down menu (Figure 11.5.4).\r\n\r\n&nbsp;\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"285\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.5.jpg\" alt=\"Selecting the Tracking Gantt view from the dropdown menu when clicked on the Gantt Chart icon on Microsoft Project\" width=\"285\" height=\"439\" class=\"wp-image-342 size-full\" \/> Figure 11.5.4: Selecting Tracking Gantt View[\/caption]\r\n\r\nWe must create a baseline by clicking \u201cSet Baseline\u201d under the \u201cProject\u201d tab to create schedule and cost baselines. We can click OK, as shown in Figure 11.5.5.\r\n\r\n&nbsp;\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"209\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.6.jpg\" alt=\"Microsoft Project screenshot showing the &quot;Set Baseline&quot; window\" width=\"209\" height=\"252\" class=\"wp-image-343 size-full\" \/> Figure 11.5.5: Set Baseline Window[\/caption]\r\n\r\nThe Tracking Gantt Chart is shown in Figure 11.5.6. As we haven\u2019t indicated any progress, all the progress percentages are zero percent. Each bar is now composed of two horizontal parts. The lower part, which is darker, displays the baseline.\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"626\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.7.jpg\" alt=\"Bars showing the project activities on the Gantt Chart. The baseline is the bottom half of each bar highlighted with dark gray.\" width=\"626\" height=\"286\" class=\"wp-image-344 size-full\" \/> Figure 11.5.6: Tracking Gantt Chart[\/caption]\r\n\r\nThe project started on June 6, 2022. The estimated completion date is December 30, 2022. Let\u2019s assume that some time has passed in the project. Let\u2019s make the current date September 18, 2022. Under the \u201cProject\u201d tab, click \u201cProject Information\u201d. Changing the current date won\u2019t suffice (Figure 11.5.7). It will help us to see the date on the Gantt Chart. Rather, we need to change the status date to create a scenario as of September 18, 2022.\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"473\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.8.jpg\" alt=\"Microsoft Project screenshot showing the Project Information Window (start date, current date, status date)\" width=\"473\" height=\"334\" class=\"wp-image-345 size-full\" \/> Figure 11.5.7: Project Information Window[\/caption]\r\n\r\nNow, we can change the completion percentages for each activity and add \u201cAdditional Resources\u201d to create the impression that we made some progress on activities and spent more money on some of the activities. Table 11.5.2 indicates additional costs are added to activities C and F (Figure 11.5.8). The project cost changed to $55,800 with the additional costs from its cost baseline of $52,400.\r\n\r\n&nbsp;\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"527\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.9.jpg\" alt=\"Microsoft Project screenshot showing the situation after additional costs were added to the resources.\" width=\"527\" height=\"271\" class=\"wp-image-346 size-full\" \/> Figure 11.5.8: Additional Costs added to activities C and F[\/caption]\r\n\r\nAs shown in Table 11.5.3, we will also change the completion percentages for each activity.\r\n<p style=\"text-align: center\"><strong>Table 11.5.3: Completion Percentages for the Activities<\/strong><\/p>\r\n\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 288px\" border=\"0\">\r\n<tbody>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;text-align: center;height: 18px\"><strong>Activity<\/strong><\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\"><strong>Completion Percentage<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">A<\/td>\r\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">B<\/td>\r\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">C<\/td>\r\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">D<\/td>\r\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">E<\/td>\r\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">F<\/td>\r\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">G<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">100<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">H<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">50<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">I<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">J<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">K<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">L<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">M<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">N<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 25.1804%;height: 18px\">O<\/td>\r\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nWe can use the shortcuts for completion percentages (0%, 25%, 50%, 75%, 100%). Or double-clicking a task opens the \u201cTask Information\u201d window. We can type any percentage from the \u201cPercent complete\u201d on this window (Figure 11.5.9).\r\n<p style=\"text-align: center\"><img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.10.jpg\" alt=\"Shortcuts for project completion percentages under the Task tab on Microsoft Project. The percentages are zero, 25, 50, 75, and 100.\" width=\"626\" height=\"126\" class=\"aligncenter wp-image-347 size-full\" style=\"color: #373d3f;font-weight: bold;text-align: center;font-size: 14pt\" \/><span style=\"font-size: 14px;text-align: center\">Figure 11.5.9: Shortcuts for Completion Percentages<\/span><\/p>\r\nAfter we mark the completion percentages for each task, we can see the percentages to the left of each bar on the Gantt Chart (Figure 11.5.10). Besides, the upper horizontal section of each bar will get darker for 100% completion, and the \u201cIndicators\u201d column will place ticks for these activities. Activity H has a 50% completion. Therefore, the upper horizontal section for half of the activity turned darker red. Remember that weekends are considered holidays on Microsoft Project (default setting). Therefore, the coverage area may not necessarily display a 50% area on a bar.\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"626\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.11.jpg\" alt=\"Microsoft Project screenshot showing the completion percentages on the Gantt Chart next to each bar representing activities\" width=\"626\" height=\"205\" class=\"wp-image-348 size-full\" \/> Figure 11.5.10: The Percentages marked to the right of each bar on the Gantt Chart[\/caption]\r\n\r\nSo, our scenario dictates that we finished 100% of activities A, B, C, D, E, F, and G, and 50% of activity H. Besides, we spent more money on activities C and F.\r\n\r\nNow, we can open the EVM table. In the View tab, we click Tables and select More Tables. In the new menu window, we choose Earned Value. In the new sheet, we should insert SPI as a new column to the right of the existing \"SV\" column and CPI as a new column to the right of the existing \u201cCV\u201d column. Figure 11.5.11 displays the Earned Value table view as of September 18, 2022. An SPI value of 0.92 indicates that our project is behind schedule. A CPI value of 0.88 indicates that our project has an overrun budget issue. Microsoft Project provides EAC, BAC, and VAC values (Figure 11.5.11). Our cost baseline was $52,400. If we assume that the CPI value of 0.88 doesn\u2019t change during the rest of the project, we can estimate to pay $59,761 (EAC \u2013 Estimate at Completion) by the end of the project, which is $7,361 (VAC \u2013 Variation at Completion) more than our cost baseline.\r\n\r\n[caption id=\"attachment_349\" align=\"aligncenter\" width=\"586\"]<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.12.jpg\" alt=\"Earned value table view on Microsoft Project. The columns are Planned Value, Earned Value, AC, SV, SPI, CV, CPI, EAC, BAC, and VAC.\" width=\"586\" height=\"278\" class=\"wp-image-349 size-full\" \/> Figure 11.5.11: Earned Value Table View[\/caption]\r\n\r\nOur schedule baseline was 30 weeks (Figure 11.5.1). SPI is 0.92 as of September 18, 2022. If we cannot improve this SPI and it remains the same during the rest of the project, there may be a delay of 2.6 weeks [1 \u2013 (30 weeks \/ 0.92)].","rendered":"<p>This MS Project tutorial will elaborate on how to conduct an EVM analysis. Table 11.5.1 provides a project with 15 activities.<\/p>\n<p style=\"text-align: center\"><strong>Table 11.5.1: Project Activities<\/strong><\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%\">\n<tbody>\n<tr>\n<td style=\"width: 21.0691%;text-align: center\"><strong>Activity<\/strong><\/td>\n<td style=\"width: 40.6918%;text-align: center\"><strong>Duration (weeks)<\/strong><\/td>\n<td style=\"width: 38.239%;text-align: center\"><strong>Predecessors<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">A<\/td>\n<td style=\"width: 40.6918%\">2<\/td>\n<td style=\"width: 38.239%\">&#8212;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">B<\/td>\n<td style=\"width: 40.6918%\">3<\/td>\n<td style=\"width: 38.239%\">&#8212;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">C<\/td>\n<td style=\"width: 40.6918%\">1<\/td>\n<td style=\"width: 38.239%\">A, B<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">D<\/td>\n<td style=\"width: 40.6918%\">3<\/td>\n<td style=\"width: 38.239%\">C<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">E<\/td>\n<td style=\"width: 40.6918%\">2<\/td>\n<td style=\"width: 38.239%\">C<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">F<\/td>\n<td style=\"width: 40.6918%\">2<\/td>\n<td style=\"width: 38.239%\">D, E<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">G<\/td>\n<td style=\"width: 40.6918%\">3<\/td>\n<td style=\"width: 38.239%\">E<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">H<\/td>\n<td style=\"width: 40.6918%\">4<\/td>\n<td style=\"width: 38.239%\">F, G<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">I<\/td>\n<td style=\"width: 40.6918%\">2<\/td>\n<td style=\"width: 38.239%\">H<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">J<\/td>\n<td style=\"width: 40.6918%\">6<\/td>\n<td style=\"width: 38.239%\">I<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">K<\/td>\n<td style=\"width: 40.6918%\">4<\/td>\n<td style=\"width: 38.239%\">J<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">L<\/td>\n<td style=\"width: 40.6918%\">3<\/td>\n<td style=\"width: 38.239%\">J<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">M<\/td>\n<td style=\"width: 40.6918%\">2<\/td>\n<td style=\"width: 38.239%\">J<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">N<\/td>\n<td style=\"width: 40.6918%\">2<\/td>\n<td style=\"width: 38.239%\">K, L, M<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 21.0691%\">O<\/td>\n<td style=\"width: 40.6918%\">1<\/td>\n<td style=\"width: 38.239%\">N<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 626px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2022\/08\/Figure-11.2.jpg\" alt=\"The Microsoft Project screenshot showing all the project activities, the schedule, and the Gantt Chart\" width=\"626\" height=\"234\" class=\"wp-image-339 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/08\/Figure-11.2.jpg 626w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/08\/Figure-11.2-300x112.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/08\/Figure-11.2-65x24.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/08\/Figure-11.2-225x84.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/08\/Figure-11.2-350x131.jpg 350w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.1: WBS, Schedule, and the Gantt Chart<\/figcaption><\/figure>\n<p>In this project, the resources assigned to each activity are given in Table 11.5.2. All the resources are &#8220;Work&#8221; type resources, meaning they are either people or equipment.<\/p>\n<p style=\"text-align: center\"><strong>Table 11.5.2: Resources and Costs<\/strong><\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 306px\">\n<tbody>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\"><strong>Resource Name<\/strong><\/td>\n<td style=\"width: 46.2935%;height: 18px\"><strong>Standard Rate<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 18px\"><strong>Activities\u00a0<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">a<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$20.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">A<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">b<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$40.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">B<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">c<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$30.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">C<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">d<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$15.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">D<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">e<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$35.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">E<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">f<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$50.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">F<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">g<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$30.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">G<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">h<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$25.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">H<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">i<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$40.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">I<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">j<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$40.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">J<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">k<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$25.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">K<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">l<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$25.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">L<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">m<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$20.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">M<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">n<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$35.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">N<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">o<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$50.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">O<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20.3731%;height: 18px\">Additional Cost 1<\/td>\n<td style=\"width: 46.2935%;height: 18px\">$35.00\/hr<\/td>\n<td style=\"width: 33.3333%;height: 18px\">C<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20.3731%\">Additional Cost 2<\/td>\n<td style=\"width: 46.2935%\">$25.00\/hr<\/td>\n<td style=\"width: 33.3333%\">F<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div style=\"margin: auto;\"><\/div>\n<p>Under the View tab, we click the \u201cResource Sheet.\u201d Then, we can type the resource names and costs, as seen in Table 11.5.2. The Resource Sheet on MS Project is given in Figure 11.5.2.<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 529px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.3.jpg\" alt=\"Resource sheet including two additional costs\" width=\"529\" height=\"288\" class=\"wp-image-340 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.3.jpg 529w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.3-300x163.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.3-65x35.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.3-225x122.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.3-350x191.jpg 350w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.2: Resource Sheet<\/figcaption><\/figure>\n<p>Let\u2019s select all the resources except additional costs from the drop-down menu for each resource on the Gantt Chart view. Besides, we add a new column \u201cCost\u201d to the left of \u201cResource Names\u201d. As shown in Figure 11.5.3, the project&#8217;s total estimated cost is $52,400. This figure would also be our BAC (Budget at Completion).<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 506px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.4.jpg\" alt=\"Microsoft Project screenshot showing the activity list with the resources assigned to each activity\" width=\"506\" height=\"283\" class=\"wp-image-341 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.4.jpg 506w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.4-300x168.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.4-65x36.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.4-225x126.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.4-350x196.jpg 350w\" sizes=\"auto, (max-width: 506px) 100vw, 506px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.3: Gantt Chart View with the Resources Selected<\/figcaption><\/figure>\n<p>Under the \u201cTask\u201d tab, we can select \u201cTracking Gantt\u201d from the drop-down menu (Figure 11.5.4).<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 285px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.5.jpg\" alt=\"Selecting the Tracking Gantt view from the dropdown menu when clicked on the Gantt Chart icon on Microsoft Project\" width=\"285\" height=\"439\" class=\"wp-image-342 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.5.jpg 285w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.5-195x300.jpg 195w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.5-65x100.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.5-225x347.jpg 225w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.4: Selecting Tracking Gantt View<\/figcaption><\/figure>\n<p>We must create a baseline by clicking \u201cSet Baseline\u201d under the \u201cProject\u201d tab to create schedule and cost baselines. We can click OK, as shown in Figure 11.5.5.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 209px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.6.jpg\" alt=\"Microsoft Project screenshot showing the &quot;Set Baseline&quot; window\" width=\"209\" height=\"252\" class=\"wp-image-343 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.6.jpg 209w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.6-65x78.jpg 65w\" sizes=\"auto, (max-width: 209px) 100vw, 209px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.5: Set Baseline Window<\/figcaption><\/figure>\n<p>The Tracking Gantt Chart is shown in Figure 11.5.6. As we haven\u2019t indicated any progress, all the progress percentages are zero percent. Each bar is now composed of two horizontal parts. The lower part, which is darker, displays the baseline.<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 626px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.7.jpg\" alt=\"Bars showing the project activities on the Gantt Chart. The baseline is the bottom half of each bar highlighted with dark gray.\" width=\"626\" height=\"286\" class=\"wp-image-344 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.7.jpg 626w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.7-300x137.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.7-65x30.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.7-225x103.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.7-350x160.jpg 350w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.6: Tracking Gantt Chart<\/figcaption><\/figure>\n<p>The project started on June 6, 2022. The estimated completion date is December 30, 2022. Let\u2019s assume that some time has passed in the project. Let\u2019s make the current date September 18, 2022. Under the \u201cProject\u201d tab, click \u201cProject Information\u201d. Changing the current date won\u2019t suffice (Figure 11.5.7). It will help us to see the date on the Gantt Chart. Rather, we need to change the status date to create a scenario as of September 18, 2022.<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 473px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.8.jpg\" alt=\"Microsoft Project screenshot showing the Project Information Window (start date, current date, status date)\" width=\"473\" height=\"334\" class=\"wp-image-345 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.8.jpg 473w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.8-300x212.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.8-65x46.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.8-225x159.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.8-350x247.jpg 350w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.7: Project Information Window<\/figcaption><\/figure>\n<p>Now, we can change the completion percentages for each activity and add \u201cAdditional Resources\u201d to create the impression that we made some progress on activities and spent more money on some of the activities. Table 11.5.2 indicates additional costs are added to activities C and F (Figure 11.5.8). The project cost changed to $55,800 with the additional costs from its cost baseline of $52,400.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 527px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.9.jpg\" alt=\"Microsoft Project screenshot showing the situation after additional costs were added to the resources.\" width=\"527\" height=\"271\" class=\"wp-image-346 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.9.jpg 527w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.9-300x154.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.9-65x33.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.9-225x116.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.9-350x180.jpg 350w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.8: Additional Costs added to activities C and F<\/figcaption><\/figure>\n<p>As shown in Table 11.5.3, we will also change the completion percentages for each activity.<\/p>\n<p style=\"text-align: center\"><strong>Table 11.5.3: Completion Percentages for the Activities<\/strong><\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 288px\">\n<tbody>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;text-align: center;height: 18px\"><strong>Activity<\/strong><\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\"><strong>Completion Percentage<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">A<\/td>\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">B<\/td>\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">C<\/td>\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">D<\/td>\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">E<\/td>\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">F<\/td>\n<td style=\"width: 74.8196%;height: 18px;text-align: center\">100<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">G<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">100<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">H<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">50<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">I<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">J<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">K<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">L<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">M<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">N<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 25.1804%;height: 18px\">O<\/td>\n<td style=\"width: 74.8196%;text-align: center;height: 18px\">0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>We can use the shortcuts for completion percentages (0%, 25%, 50%, 75%, 100%). Or double-clicking a task opens the \u201cTask Information\u201d window. We can type any percentage from the \u201cPercent complete\u201d on this window (Figure 11.5.9).<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.10.jpg\" alt=\"Shortcuts for project completion percentages under the Task tab on Microsoft Project. The percentages are zero, 25, 50, 75, and 100.\" width=\"626\" height=\"126\" class=\"aligncenter wp-image-347 size-full\" style=\"color: #373d3f;font-weight: bold;text-align: center;font-size: 14pt\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.10.jpg 626w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.10-300x60.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.10-65x13.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.10-225x45.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.10-350x70.jpg 350w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><span style=\"font-size: 14px;text-align: center\">Figure 11.5.9: Shortcuts for Completion Percentages<\/span><\/p>\n<p>After we mark the completion percentages for each task, we can see the percentages to the left of each bar on the Gantt Chart (Figure 11.5.10). Besides, the upper horizontal section of each bar will get darker for 100% completion, and the \u201cIndicators\u201d column will place ticks for these activities. Activity H has a 50% completion. Therefore, the upper horizontal section for half of the activity turned darker red. Remember that weekends are considered holidays on Microsoft Project (default setting). Therefore, the coverage area may not necessarily display a 50% area on a bar.<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 626px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.11.jpg\" alt=\"Microsoft Project screenshot showing the completion percentages on the Gantt Chart next to each bar representing activities\" width=\"626\" height=\"205\" class=\"wp-image-348 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.11.jpg 626w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.11-300x98.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.11-65x21.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.11-225x74.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.11-350x115.jpg 350w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.10: The Percentages marked to the right of each bar on the Gantt Chart<\/figcaption><\/figure>\n<p>So, our scenario dictates that we finished 100% of activities A, B, C, D, E, F, and G, and 50% of activity H. Besides, we spent more money on activities C and F.<\/p>\n<p>Now, we can open the EVM table. In the View tab, we click Tables and select More Tables. In the new menu window, we choose Earned Value. In the new sheet, we should insert SPI as a new column to the right of the existing &#8220;SV&#8221; column and CPI as a new column to the right of the existing \u201cCV\u201d column. Figure 11.5.11 displays the Earned Value table view as of September 18, 2022. An SPI value of 0.92 indicates that our project is behind schedule. A CPI value of 0.88 indicates that our project has an overrun budget issue. Microsoft Project provides EAC, BAC, and VAC values (Figure 11.5.11). Our cost baseline was $52,400. If we assume that the CPI value of 0.88 doesn\u2019t change during the rest of the project, we can estimate to pay $59,761 (EAC \u2013 Estimate at Completion) by the end of the project, which is $7,361 (VAC \u2013 Variation at Completion) more than our cost baseline.<\/p>\n<figure id=\"attachment_349\" aria-describedby=\"caption-attachment-349\" style=\"width: 586px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.12.jpg\" alt=\"Earned value table view on Microsoft Project. The columns are Planned Value, Earned Value, AC, SV, SPI, CV, CPI, EAC, BAC, and VAC.\" width=\"586\" height=\"278\" class=\"wp-image-349 size-full\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.12.jpg 586w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.12-300x142.jpg 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.12-65x31.jpg 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.12-225x107.jpg 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/Figure-11.12-350x166.jpg 350w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><figcaption id=\"caption-attachment-349\" class=\"wp-caption-text\">Figure 11.5.11: Earned Value Table View<\/figcaption><\/figure>\n<p>Our schedule baseline was 30 weeks (Figure 11.5.1). SPI is 0.92 as of September 18, 2022. If we cannot improve this SPI and it remains the same during the rest of the project, there may be a delay of 2.6 weeks [1 \u2013 (30 weeks \/ 0.92)].<\/p>\n","protected":false},"author":3,"menu_order":6,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-350","chapter","type-chapter","status-publish","hentry"],"part":325,"_links":{"self":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters\/350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":6,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters\/350\/revisions"}],"predecessor-version":[{"id":900,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters\/350\/revisions\/900"}],"part":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/parts\/325"}],"metadata":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters\/350\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/media?parent=350"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapter-type?post=350"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/contributor?post=350"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/license?post=350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}