Question

using the data below create a time-phased budget for the project. Show how much daily and cumulative costs of a project is, just as monthly and cumulative costs are shown in figure 10.

WBS	Activity	Intermediate Predecessor	Duration in Weeks	Resource	Hourly cost	Hours per week
1	Operational definition
1.1	Research literature		3	Becky	$35	30
1.2	Identify and define terms	1.1	1	Ann	$60	30
1.3	Obtain approval of definition	1.2	2	Clive	$50	30
2	Target selection
2.1	Solicit partners for pilot.		2	Ann
2.2	Hold brainstirming meeting	2.1	2	Becky
2.3	Identify characteristics of targets.	2.2,3.1	1	Ann
2.4	Obtain approval of partners	2.3,1.2,3.4	1	Clive
3	Question Set
3.1	Identify Process group members		2	Clive
3.2	Develop question set	2.3	4	Ann
3.3	Prototype and valid question set	3.2	3	Becky
3.4	Add partners	3.1,2.1	3	Becky

Answer 1

Important Formula:

Total Cost per week=Hourly cost*Hours week

WBS	Activity	Intermediate	Duration in	Resource	Hourly	Hours per	Total Cost per week=Hourly cost*Hours week
		Predecessor	Weeks		cost	week
1	Operational definition
1.1	Research literature		3	Becky	$35	30	$1,050
1.2	Identify and define terms	1.1	1	Ann	$60	30	$1,800
1.3	Obtain approval of definition	1.2	2	Clive	$50	30	$1,500

1	B	C	D	E	F	G	H	I
2	Activiy	Duration	1	2	3	4	5	6
3	Research literature	3	1050	1050	1050
4	Identify and define terms	1				1800
5	Obtain approval of definition	2					1500	1500
6	Cost per Week		1050	1050	1050	1800	1500	1500
7	Cumulative cost per week		1050	2100	3150	4950	6450	7950

Formula:

1	B	C	D	E	F	G	H	I
2	Activiy	Duration	1	2	3	4	5	6
3	Research literature	3	1050	1050	1050
4	Identify and define terms	1				1800
5	Obtain approval of definition	2					1500	1500
6	Cost per Week		=SUM(D3:D5)	=SUM(E3:E5)	=SUM(F3:F5)	=SUM(G3:G5)	=SUM(H3:H5)	=SUM(I3:I5)
7	Cumulative cost per week		=D6	=D7+E6	=E7+F6	=F7+G6	=G7+H6	=H7+I6

Line graph is produced using MS Excel: Step: Insert > Line

we have selected row of Cost per Week and Cumulative cost per week for each week, presented on the below Graph