20. Determine percentage of completion
To manage a project it is necessary to determine the percentage of completion. This can be accomplished with the following calculation.
To calculate percentage of completion:
1. In a worksheet, enter data in columns A, B, and D as shown in Figure 1-20, or use your own data.
2. Select cell E2 and type =B2+B3.
3. Select cell E3 and enter the target value of 200.
4. In cell E5, type the formula =E3-E2 to get the difference between the target and the number already produced.
5. Calculate the percentage of missing products in cell E6 with this formula: =1-E2/E3.
6. Select cell E8 and calculate the percentage of production by using this formula: =100%-E6.
Watch the Video Tutorial - https://www.youtube.com/watch?v=a2mDIuJmJps
Hope You Like This Tutorial - Give Comments
No comments:
Post a Comment