1-Using the data above 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.

EXHIBIT 10.9 AGGREGATION OF PROJECT BUDGET FEB MAR APR MAY JUN WP 1221 WP 1222 WP 1231 WP 1232 WP 1233 WP 1241 WP 1221 ($10,000) $10,000 WP 1222 ($10,000) $5,000 $5,000 WP 1231 ($45,000) $15,000 $30,000 WP 1232 ($20,000) $20,000 $15,000 WP 1233 ($15,000) $10,000 $10,000 WP 1241 ($20,000) $25,000 $10,000 Cost per month $15,000 $20,000 $50,000 Cumulative cost $15,000 $35,000 $85,000 $110,000 $120,000 $120K $100K $80K $60K $40K $20K 0 Source: Kevin P. Grant, University of Texas, San Antonio Adapted with permission. 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 EXHIBIT 10.9 AGGREGATION OF PROJECT BUDGET FEB MAR APR MAY JUN WP 1221 WP 1222 WP 1231 WP 1232 WP 1233 WP 1241 WP 1221 ($10,000) $10,000 WP 1222 ($10,000) $5,000 $5,000 WP 1231 ($45,000) $15,000 $30,000 WP 1232 ($20,000) $20,000 $15,000 WP 1233 ($15,000) $10,000 $10,000 WP 1241 ($20,000) $25,000 $10,000 Cost per month $15,000 $20,000 $50,000 Cumulative cost $15,000 $35,000 $85,000 $110,000 $120,000 $120K $100K $80K $60K $40K $20K 0 Source: Kevin P. Grant, University of Texas, San Antonio Adapted with permission. 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