I know this is not only one question, but please help me out on this. I can post questions multiple times if you can answer one question each time. And please show the answer in Excel with formula, I will be really appreiacted!
Problem 1 (50 Points): Use the work breakdown structure (WBS) and activity duration data to do the following: a. On a separate sheet, create an activity on node (AON) diagram for this project. Draw it neatly. Identify the critical path. b. Calculate the Expected Time (TE) for each activity. All times are in weeks. Round off your answers for TE to two decimal places. C. Using the TE time, solve for the early start, early finish, late start, late finish, and slack time for each activity. Show your answers on the diagram. d. Calculate the weekly crash costs. Use the normal probability density function to estimate the probability that the project will be completed within 1 week of its scheduled completion time and to estimate a 90% Confidence interval for the project completion time. e. Crash Cost Per Weeke Activity Predecessor Optimistic Time Most Likely Time Available Crash Weeks Pessimistic Time e se Crash Cost (Additional $ Above Activity PV) NA Ae 1 22 42 0 Be A Ae 30 5e 8 2e $30,000 4 t 12 72 0 NA le De ce 2e 3e 52 00 NA Ee Be be le se 12e 2e $25,000 Ee 2 32 5e NA G Ee 8 ge 12e 3e $20,000 He D, F, Ge 1e 22 3e 0 NA Problem 2 (25 Points): Use the project network from the previous problem to calculate the cost for each activity and the total project baseline budget (BAC). Round off each work package cost to the nearest dollar. Round $0.50 up to the next dollar. Assume 5 work days per week. Show your work and organize it neatly. Resource Cost Data kr Activity Work Package Resources Required A Design Engineer, Designer, Market Researcher Build a Prototype Lab Tech, Fabrication Lab, Raw Materials Ce Lab Tests Lab Tech, Test Lab, Competitor Samples D Focus Group Market Researcher, Designer, Focus Group (6 People) E2 Refine Design Engineer, Designer Fe Build Prototypes Lab Tech, Machine Time, Tooling GA Market Testing Market Researcher He Final Design Engineer, Market Researcher I Resource Engineer Designer Lab Tech Market Researcher Test Lab Fabrication Lab Focus Group Stipend Competitor Samples Raw Materials Tooling Machine Time Type Labor Labore Labora Labor Daily Resource Daily Resource Daily Resource Materiale Materiale Material Da Resources Cost $600 per day $500 per day $400 per day $550 per day $1500 per day $5,000 per day $500 per day, per person $15,000 flat fee $20,000 flat fee $50,000 Flat Fee $1,200 per day I Budget Calculation Sheet Budget Calculation Sheet Activity TE (Weeks) Cost Calculation (Show Your cost Formula for Each Work Package) Total Costa A e Be De 7 1 e e e E FA G4 Total Project Baseline Budget (BAC) Problem 3 (25 Points): Using the same project and data from problems one and two, create a plan for crashing the project for the number of weeks specified. Given the number of weeks that need to be crashed, recommend which activities to crash. The constraints to apply when choosing activities to crash is to minimize crash costs, while selecting activities on the critical path. Assume that there is a weekly penalty of $12,000 for each that the project lasts beyond the week = (TE 5) weeks. In other words, crashing the project one week will incur a four-week penalty = 4($12,000) = $48,000. Crashing the project two weeks will incur a three-week penalty, crashing the project three weeks will incur a two-week penalty, and crashing the project four weeks will incur a one-week penalty. There is no penalty if the project is crashed five weeks. Determine which activities to crash and for how many weeks each, to accomplish the numbers of crash weeks (one through five). Calculate the total project cost for each option. BAC (from problem 2), Number of Weeks to Crash Activities to Crash and Number of Weeks to Crash (For example: Crash A for 1 week and crash C for 2 weeks) Crash Cost Penalty Total Cost 10 24 32 44 54 Problem 1 (50 Points): Use the work breakdown structure (WBS) and activity duration data to do the following: a. On a separate sheet, create an activity on node (AON) diagram for this project. Draw it neatly. Identify the critical path. b. Calculate the Expected Time (TE) for each activity. All times are in weeks. Round off your answers for TE to two decimal places. C. Using the TE time, solve for the early start, early finish, late start, late finish, and slack time for each activity. Show your answers on the diagram. d. Calculate the weekly crash costs. Use the normal probability density function to estimate the probability that the project will be completed within 1 week of its scheduled completion time and to estimate a 90% Confidence interval for the project completion time. e. Crash Cost Per Weeke Activity Predecessor Optimistic Time Most Likely Time Available Crash Weeks Pessimistic Time e se Crash Cost (Additional $ Above Activity PV) NA Ae 1 22 42 0 Be A Ae 30 5e 8 2e $30,000 4 t 12 72 0 NA le De ce 2e 3e 52 00 NA Ee Be be le se 12e 2e $25,000 Ee 2 32 5e NA G Ee 8 ge 12e 3e $20,000 He D, F, Ge 1e 22 3e 0 NA Problem 2 (25 Points): Use the project network from the previous problem to calculate the cost for each activity and the total project baseline budget (BAC). Round off each work package cost to the nearest dollar. Round $0.50 up to the next dollar. Assume 5 work days per week. Show your work and organize it neatly. Resource Cost Data kr Activity Work Package Resources Required A Design Engineer, Designer, Market Researcher Build a Prototype Lab Tech, Fabrication Lab, Raw Materials Ce Lab Tests Lab Tech, Test Lab, Competitor Samples D Focus Group Market Researcher, Designer, Focus Group (6 People) E2 Refine Design Engineer, Designer Fe Build Prototypes Lab Tech, Machine Time, Tooling GA Market Testing Market Researcher He Final Design Engineer, Market Researcher I Resource Engineer Designer Lab Tech Market Researcher Test Lab Fabrication Lab Focus Group Stipend Competitor Samples Raw Materials Tooling Machine Time Type Labor Labore Labora Labor Daily Resource Daily Resource Daily Resource Materiale Materiale Material Da Resources Cost $600 per day $500 per day $400 per day $550 per day $1500 per day $5,000 per day $500 per day, per person $15,000 flat fee $20,000 flat fee $50,000 Flat Fee $1,200 per day I Budget Calculation Sheet Budget Calculation Sheet Activity TE (Weeks) Cost Calculation (Show Your cost Formula for Each Work Package) Total Costa A e Be De 7 1 e e e E FA G4 Total Project Baseline Budget (BAC) Problem 3 (25 Points): Using the same project and data from problems one and two, create a plan for crashing the project for the number of weeks specified. Given the number of weeks that need to be crashed, recommend which activities to crash. The constraints to apply when choosing activities to crash is to minimize crash costs, while selecting activities on the critical path. Assume that there is a weekly penalty of $12,000 for each that the project lasts beyond the week = (TE 5) weeks. In other words, crashing the project one week will incur a four-week penalty = 4($12,000) = $48,000. Crashing the project two weeks will incur a three-week penalty, crashing the project three weeks will incur a two-week penalty, and crashing the project four weeks will incur a one-week penalty. There is no penalty if the project is crashed five weeks. Determine which activities to crash and for how many weeks each, to accomplish the numbers of crash weeks (one through five). Calculate the total project cost for each option. BAC (from problem 2), Number of Weeks to Crash Activities to Crash and Number of Weeks to Crash (For example: Crash A for 1 week and crash C for 2 weeks) Crash Cost Penalty Total Cost 10 24 32 44 54
