B&W Systems Case Study Solution
The Excel NORMDIST formula is used to calculate the probability that the project will be completed in 35 weeks. In project management, the NORMDIST formula has four parameters:
Parameter delay 1, in this case 35 weeks.
Parameter 2 - Estimated completion time of the project, which in this case is 40 weeks.
Parameter 3 - Standard deviation of the article; the square root of the variation of the article, which is equal to 2.68 weeks for the article.
The value of parameter 4 is 1, which gives the total probability.
The formula is therefore = NORMDIST (35, 40, 2.68, 1) = 3.09 percent
Minimum Expected Time and Probability of Completing the Project:
It should be used in case the plan does not answer this question. Linear programming is the best modeling method to determine the minimum expected completion time for 33 projects.
As the normal distribution averages 33 weeks; the probability of completing the project is 50 percent, this time.
Additional Cost and Crashed Cost Function:
With linear programming, the answer can be $ 41,214.29. The specific tasks collected to reach the milestone, are:
Activities | Weeks |
c | 0.67 |
d | 2.33 |
f | 1 |
h | 0.17 |
k | 1 |
Impact on the Crashing Solution:
Due to the very long downtime of Task B, which might be shown in Appendix 1 of the document; it turns out that increasing the planned time from 7 to 9, does not affect the solution collected.
Impact on the Crashing Solution for Task D:
As Task D is unlicensed and so is on a critical path; reducing the expected time to 7 weeks can indeed bring a significant improvement in the resolution of the error. You can find new fault solutions with linear programming:
Additional fees = $ 27,047.62
The specific tasks to be performed for this purpose, are:
Activities | Weeks |
d | 2.33 |
f | 1 |
h | 0.17 |
k | 1 |
Crashing Cost Function:
By sing linear programming; the locking cost function is illustrated in Figure 1...................................
This is just a sample partical work. Please place the order on the website to get your own originally done case solution.