Project lifecycle and the triple constraint
Module 1: PM Basics for Excel Users · 9 min
In this lesson
Before the clinic project starts, the partners ask a simple question: if we add a children's play area to the scope, what happens to time and cost? That is the triple constraint.
- The five-phase project lifecycle table
- A triple-constraint calculator: extra scope -> extra days, extra cost, new finish date
Steps
- Read the lifecycle phases and their key outputs
- Enter the extra scope percentage
- Calculate the extra working days and the extra cost
- Calculate the new finish date with WORKDAY
Key formulas (first cell of each row - copy across / down)
| Sheet | Cell | Row | Formula |
|---|---|---|---|
| Lifecycle | D23 | Extra working days | =ROUNDUP(D16*D20,0) |
| Lifecycle | D24 | Extra cost | =D17*D20 |
| Lifecycle | D25 | New plan - working days | =D16+D23 |
| Lifecycle | D26 | Base finish date | =WORKDAY(D15,D16-1,$G$15:$G$17) |
| Lifecycle | D27 | New finish date | =WORKDAY(D15,D25-1,$G$15:$G$17) |
| Lifecycle | D28 | New budget | =D17+D24 |
| Lifecycle | D29 | Time status | =IF(D27<=D19,"Inside target","Late") |
| Lifecycle | D30 | Cost status | =IF(D28<=D18,"Inside budget","Over budget") |
Check your answers
| Item | Cell | Expected |
|---|---|---|
| Extra working days | Lifecycle!D23 | 10 |
| New finish date | Lifecycle!D27 | Jun 24, 2027 |
| New budget | Lifecycle!D28 | $482,680 |
| Time status | Lifecycle!D29 | Inside target |
| Cost status | Lifecycle!D30 | Over budget |
Watch out for
- Adding calendar days instead of working days to a finish date
Chapters
- 00:00 Welcome
- 00:23 The Lesson Guide
- 00:43 What makes it a project
- 01:03 Initiate and Plan
- 01:29 Execute, Monitor and Close
- 01:57 The key outputs
- 02:18 Phases with a loop
- 02:34 The triple constraint
- 02:53 The calculator inputs
- 03:28 Extra scope and holidays
- 03:49 Pause and predict
- 04:06 Extra working days
- 04:31 Extra cost and new plan
- 05:00 How WORKDAY reads
- 05:17 Base finish date
- 05:46 New finish date
- 06:15 The most common mistake
- 06:36 New budget
- 06:52 Time and cost status
- 07:26 The answer for the partners
- 07:46 Check the work
- 08:04 Your turn
Your turn
- What scope increase still finishes by June 30, 2027?
Practice files
Download Module-01-PM-Basics-for-Excel-Users-Practice-Files.zip from the Practice resources tab and open the folder Lesson 1.1: Lesson_1_1_Practice.xlsx, Lesson_1_1_Solution.xlsx. The Practice file is where you start; the Solution file shows the finished result.
Brightline Dental Group and Maple & Pine Furniture are fictional businesses; all names and numbers are for training only.
Practice resources
FREE EXCEL LESSONS BY EMAIL
Not ready to enroll yet?
Join the Academy email list for practical Excel and AI tips, free preview lessons and news when a new course opens. Unsubscribe at any time.
