1-Using the data below create a time-phased budget for the project. the daily and cumulative costs for the project are, just as the monthly and cumulative costs are shown in Exhibit 10.9

2-Hint 1: Create a network diagram before filling out each person's hours. Hint 2: Tasks don't always start at the beginning of the day nor finish at the end of the day.

The attached pic goes to day 60

Sheet1 Sheet2 Sheet3 A B D E F G H 1 J K L M N 0 Q R S T U + ON+ Day Day 6 Day 7 Day 8 Day 9 Day Day 10 11 1. 1. Work Immediate Duration Hourly Hours Hours Total Day Day Day Day Activity Predecessor in days Resource cost per Day Req'd Hours Cost 1 2 3 4 5 2 A Evaluate freezers 2 Alcides $45 16 16 $ 720 6 6 4 3 B Chart temperatures 6 Joan $50 48 16 $ 800 4 4 4 4 4 C Review service record 2 Alcides $45 16 14 $ 630 2 6 6 5 D Consult with HVAC engineer A,B,C 3 Alcides $45 24 0 $ - 0 6 E Develop construction plan D 10 Joan $50 80 0 $ -0 7 F Complete IC assignment E 2 Alcides $45 16 0 $ - 0 8 G Complete ROI analysis E 5 Joan $50 40 0 $ - 0 9 H Conduct regulatory review E 4 Joan $50 32 0 $ -0 101 Obtain construction approval F,G,H 2 Alcides $45 16 0 $ -0 11 $45 6 46 Alcides 666 6 12 $50 Joan 4 4 4 4 0 13 - Duration assumes an 8 hr workday. Alcides $1,350 $270 $270 $270 $270 $270 14 Work Hours per Day = max time the person can work on THIS project each day. Joan $ 800 $200 $200 $200 $200 $0 15 Daily Cost = $470 $470 $470 $470 $270 16 Cumulative Cost = $2,150 0 0 0 0 0 0 i 0 0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 17 18 19 Sheet1 Sheet2 Sheet3 A B D E F G H 1 J K L M N 0 Q R S T U + ON+ Day Day 6 Day 7 Day 8 Day 9 Day Day 10 11 1. 1. Work Immediate Duration Hourly Hours Hours Total Day Day Day Day Activity Predecessor in days Resource cost per Day Req'd Hours Cost 1 2 3 4 5 2 A Evaluate freezers 2 Alcides $45 16 16 $ 720 6 6 4 3 B Chart temperatures 6 Joan $50 48 16 $ 800 4 4 4 4 4 C Review service record 2 Alcides $45 16 14 $ 630 2 6 6 5 D Consult with HVAC engineer A,B,C 3 Alcides $45 24 0 $ - 0 6 E Develop construction plan D 10 Joan $50 80 0 $ -0 7 F Complete IC assignment E 2 Alcides $45 16 0 $ - 0 8 G Complete ROI analysis E 5 Joan $50 40 0 $ - 0 9 H Conduct regulatory review E 4 Joan $50 32 0 $ -0 101 Obtain construction approval F,G,H 2 Alcides $45 16 0 $ -0 11 $45 6 46 Alcides 666 6 12 $50 Joan 4 4 4 4 0 13 - Duration assumes an 8 hr workday. Alcides $1,350 $270 $270 $270 $270 $270 14 Work Hours per Day = max time the person can work on THIS project each day. Joan $ 800 $200 $200 $200 $200 $0 15 Daily Cost = $470 $470 $470 $470 $270 16 Cumulative Cost = $2,150 0 0 0 0 0 0 i 0 0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 17 18 19