Question

Prepare a table in Excel showing the time-phased budget for the project. Assume the budgeted cost is linearly distributed over the duration of the activity, e.g., if the budgeted cost of a Task is $100 and the duration of the Task is 2 weeks, then budgeted cost/week=100/2= $50.
All calculations should be done within the Excel spreadsheet.

Task		Predecessor		Budget Cost ($)		Duration (weeks)
A		-		$              1,500		4
B		A		$              1,350		2
C		A		$              1,260		3
D		A		$                 950		2
E		C, D		$              1,650		5
F		B, E		$              1,200		4
G		E		$                 700		2
H		F, G		$              1,770		3

Answer 1

The Fomula used is =QUOTIENT(E2,G2)