Time Phased Budget 2 NOTE: The formula for Weekly Total looks like this: =SUM(D36:041) This will some all the values in that column. You must include All cells in that range. Add the appropriate formula for all weeks. ID Cost by Week A B 15,000.00 The formula for Cumulative Total looks like this:=043+E42 You are adding the previous totals to the current weeks total. c Activity Design $ Programming $ Testing $ Dacumentation $ User Training $ Total Project Budget $ Budget 20,000.00 $ 30,000.00 $ 20,000.00 15,000.00 15,000.00 $ 100,000.00 $ $ 20,000.00 15,000.00 $ 20,000.00 5,000.00 $ 7 500.00 $ D 5.000.00 5.000.00 $ 7,500.00 At the end of the project in Week 6, you should have the same value that is in C9 Total Project Budget. F 1 2 3 1 B B 3 3 4 4 0 0 0 0 U 5 2 0 A 1 1 2 3 3 1 4 o 0 0 1 1 1 D 4 4 E 6 0 1 2 0 0 0 0 3 4 1 3 4 4 2 6 in 3 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 ID A B Activity Design Programming Testing Documentation User Training $ $ $ $ $ C D E Budget 20,000.00 30,000.00 20,000.00 15,000.00 15,000.00 Daily Total Cumulative Total 1 2 3 $0.00 $0.00 + 5 This total should match the Total Project Budget in C9 7