1. Download the cost baseline template. 2. Use the information below to create a time-scaled network...

 

Transcribed Image Text:

1. Download the cost baseline template. 2. Use the information below to create a time-scaled network diagram (FS = finish-to-start) honoring all dependencies. Assume early start dates for each work package (WP). Outline or highlight the cells to indicate the duration of each work package. Work package one has been done for you as an example. Work Package One Work Package Two Work Package Three Work Package Four Work Package Five Work Package Six Work Package Seven Work Package Eight Work Package Nine Work Package Ten Budget $ 12,000 $5,000 $ 8,000 $ 36,000 $6,000 $ 20,000 $ 2,500 $4,200 $ 3,500 $ 2,400 Duration 4 weeks 2 weeks 8 weeks 9 weeks 3 weeks 8 weeks 5 weeks. 6 weeks 1 week 3 weeks Dependency None None None FS with WP#3 FS with WP#1 FS with WP#2 FS with WP#6 FS with WP#5 FS with WP#8 and FS with WP#7 FS with WP#9 and FS with WP#4 3. Use the budget information above to calculate the weekly budget. Assume a linear relationship between time and money. For example, if a work package was three weeks and has a total budget of $3,000, the weekly budget would be $1,000 (3 x $1,000 = $3,000). 4. There is one row for every work package. The time-scale is in weeks represented as "W1,W2, etc." for week 1, week 2, etc. in the column headers. 5. Calculate the weekly incremental budget for each work package and place it in the correct week based on dependencies and work package durations. 6. Calculate the project's weekly incremental costs and place the total in the "incremental costs" cell for each week (column). 7. Calculate the project's cumulative budget to-date for each week and place in the "cumulative costs" cell for each week (column). 8. Answer the questions related to the completed assignment. 9. Once complete, submit your assignment as instructed. Work Package One Work Package Two Work Package Three Work Package Four Work Package Five Work Package Six Work Package Seven Work Package Eight Work Package Nine Work Package Ten Incremental costs Cumulative costs W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17 W18 W19 W20 Total project budget is: Week with highest incremental cost: How many weeks have exactly two work packages planned? At which week does the cumulative budget first exceed $40,000? At which week is the incremental budget exactly $4,200? 1. Download the cost baseline template. 2. Use the information below to create a time-scaled network diagram (FS = finish-to-start) honoring all dependencies. Assume early start dates for each work package (WP). Outline or highlight the cells to indicate the duration of each work package. Work package one has been done for you as an example. Work Package One Work Package Two Work Package Three Work Package Four Work Package Five Work Package Six Work Package Seven Work Package Eight Work Package Nine Work Package Ten Budget $ 12,000 $5,000 $ 8,000 $ 36,000 $6,000 $ 20,000 $ 2,500 $4,200 $ 3,500 $ 2,400 Duration 4 weeks 2 weeks 8 weeks 9 weeks 3 weeks 8 weeks 5 weeks. 6 weeks 1 week 3 weeks Dependency None None None FS with WP#3 FS with WP#1 FS with WP#2 FS with WP#6 FS with WP#5 FS with WP#8 and FS with WP#7 FS with WP#9 and FS with WP#4 3. Use the budget information above to calculate the weekly budget. Assume a linear relationship between time and money. For example, if a work package was three weeks and has a total budget of $3,000, the weekly budget would be $1,000 (3 x $1,000 = $3,000). 4. There is one row for every work package. The time-scale is in weeks represented as "W1,W2, etc." for week 1, week 2, etc. in the column headers. 5. Calculate the weekly incremental budget for each work package and place it in the correct week based on dependencies and work package durations. 6. Calculate the project's weekly incremental costs and place the total in the "incremental costs" cell for each week (column). 7. Calculate the project's cumulative budget to-date for each week and place in the "cumulative costs" cell for each week (column). 8. Answer the questions related to the completed assignment. 9. Once complete, submit your assignment as instructed. Work Package One Work Package Two Work Package Three Work Package Four Work Package Five Work Package Six Work Package Seven Work Package Eight Work Package Nine Work Package Ten Incremental costs Cumulative costs W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17 W18 W19 W20 Total project budget is: Week with highest incremental cost: How many weeks have exactly two work packages planned? At which week does the cumulative budget first exceed $40,000? At which week is the incremental budget exactly $4,200?