cash flow diagram needed (cost and payment curves)

SCHOOL OF CONSTRUCTION

BCN 4703 – MGMT OF CONST PROJECTS

SPRING 2017

Homework Assignment #4 02/10/2017 Page 1| 3

Homework Assignment #4 (Due 02/17/2017 @5:00PM)

Table 1 provides some information regarding the cost and schedule of a small project. In addition, you

know that there is no advance payment, 11.5% job overhead (excluding tax and bonds), 4.5% tax, 6.5%

office overhead, 14% profit, and 1.5% bonds. Also, as per the contract agreement, payments to the

Contractor are made two months later with 10% retainage. Accordingly, you are required to draw the cash

flow diagram (cost and payment curves), and determine the maximum cash-out-of-flow.

Notes and Hints:

 The Contractor commits the cost of bonds and mobilization at beginning of month 1.

 The Contractor bills the owner for the mobilization at end of month 1.

 For pricing (and consequently billing), the cost of bonds is spread over all items.

 Payment by Contractor is made to the Subcontractor on a back-to-back basis (i.e., the Contractor pays the Subcontractor once he/she is paid by the Owner) – without retainage.

 You already developed the CPM precedence diagram to determine the early start and finish dates of each activity, see Figure-1. You will use an early start schedule.

 You already developed the recap sheet to determine the costs and prices of activities, see Table-2.

 Soft copies of the tables are available on Blackboard

SCHOOL OF CONSTRUCTION

BCN 4703 – MGMT OF CONST PROJECTS

SPRING 2017

Homework Assignment #4 02/10/2017 Page 2| 3

Figure -1

SCHOOL OF CONSTRUCTION

BCN 4703 – MGMT OF CONST PROJECTS

SPRING 2017

Homework Assignment #4 02/10/2017 Page 3| 3

M o

b il

iz at

io n

0 -

L S

1 5

,5 0

0 .0

0 6

,8 2

5 .0

1 7

,8 9

9 .0

0 7

,8 9

9 .0

0

A 2

- C

u .m

. 2

,0 0

0 2

,8 0

0 .0

0 0

7 4

0 .0

0 0

3 ,5

4 0

.0 0

4 ,3

9 2

.8 3

5 ,0

8 4

.0 8

2 .5

4

B 1

A C

u .m

. 1

,2 4

0 4

,9 0

0 .0

0 0

6 3

0 .0

0 0

5 ,5

3 0

.0 0

6 ,8

6 2

.2 4

7 ,9

4 2

.0 8

6 .4

0

C 1

A C

u .m

. 5

8 0

7 ,5

2 0

.0 0

0 1

,9 6

0 .0

0 0

9 ,4

8 0

.0 0

1 1

,7 6

3 .8

4 1

3 ,6

1 5

.0 0

2 3

.4 7

D 3

A C

u .m

. 3

3 8

7 ,1

1 0

.0 0

0 2

,1 5

0 .0

0 0

9 ,2

6 0

.0 0

1 1

,4 9

0 .8

4 1

3 ,2

9 9

.0 4

3 9

.3 5

E 2

B S

q .m

. 1

,2 0

0 2

,5 1

0 .0

0 5

,8 6

0 .0

0 6

8 0

.0 0

0 9

,0 5

0 .0

0 1

1 ,2

3 0

.2 5

1 2

,9 9

7 .4

4 1

0 .8

3

F 2

B L

S 1

0 0

0 1

1 ,8

0 0

.0 0

1 1

,8 0

0 .0

0 1

4 ,6

4 2

.7 5

1 6

,9 4

6 .9

4 1

6 ,9

4 6

.9 4

G 1

B ,C

L .m

. 8

2 0

2 ,0

5 0

.0 0

1 0

,1 4

0 .0

0 1

,2 7

0 .0

0 0

1 3

,4 6

0 .0

0 1

6 ,7

0 2

.6 7

1 9

,3 3

1 .0

1 2

3 .5

7

H 4

C S

q .m

. 1

,4 5

0 2

,1 4

0 .0

0 6

,5 2

0 .0

0 0

0 8

,6 6

0 .0

0 1

0 ,7

4 6

.2 9

1 2

,4 3

7 .3

3 8

.5 8

I 1

D e a.

8 1

0 8

1 0

.0 0

9 ,0

4 0

.0 0

0 0

9 ,8

5 0

.0 0

1 2

,2 2

2 .9

8 1

4 ,1

4 6

.3 9

1 7

.4 6

J 3

E ,F

S q .m

. 1

,4 5

0 3

,5 4

0 .0

0 3

,2 5

0 .0

0 1

,1 9

0 .0

0 0

7 ,9

8 0

.0 0

9 ,9

0 2

.4 7

1 1

,4 6

0 .7

3 7

.9 0

K 2

H ,I

L S

1 0

0 0

1 0

,5 6

0 .0

0 1

0 ,5

6 0

.0 0

1 3

,1 0

4 .0

2 1

5 ,1

6 6

.0 8

1 5

,1 6

6 .0

8

L 2

G ,J

,K S

q .m

. 8

8 5

8 2

0 .0

0 6

,0 2

0 .0

0 4

6 0

.0 0

0 7

,3 0

0 .0

0 9

,0 5

8 .6

5 1

0 ,4

8 4

.1 3

1 1

.8 5

M 1

K S

q .m

. 1

,4 2

0 1

,9 2

0 .0

0 5

,7 4

0 .0

0 8

9 0

.0 0

0 8

,5 5

0 .0

0 1

0 ,6

0 9

.7 9

1 2

,2 7

9 .3

5 8

.6 5

N 1

L ,M

S q .m

. 3

6 0

4 ,8

2 0

.0 0

9 2

0 .0

0 1

,4 6

0 .0

0 0

7 ,2

0 0

.0 0

8 ,9

3 4

.5 6

1 0

,3 4

0 .5

1 2

8 .7

2

1 2

7 ,7

2 0

.0 0

1 5

8 ,4

8 9

.1 9

1 8

3 ,4

2 9

.1 1

T o

ta l

D ir

e c t

C o

st 1

2 7

,7 2

0 .0

0

Jo b O

ve rh

e ad

e x c l

T ax

& B

o n d s(

1 1

.5 %

) $

1 4

,6 8

7 .8

0

S u b to

ta l

$ 1

4 2

,4 0

7 .8

0

C o

st F

ac to

r= T

o ta

l C

o st

E x c lu

d in

g B

o n d s/

T o

ta l

D ir

e c t

C o

st =

1

.2 4

0 9

1 T

ax (

4 .5

% )

$ 6

,4 0

8 .3

5

P ri

c e F

ac to

r =

T o

ta l

B id

P ri

c e /T

o ta

l D

ir e c t

C o

st =

1

.4 3

6 1

8 S

u b to

ta l

$ 1

4 8

,8 1

6 .1

5

O ff

ic e O

ve rh

e ad

( 6

.5 %

) $

9 ,6

7 3

.0 5

S u b to

ta l

$ 1

5 8

,4 8

9 .1

9

P ro

fi t

(1 4

% )

$ 2

2 ,1

8 8

.4 8

S u b to

ta l

$ 1

8 0

,6 7

7 .6

9

B o

n d s

(1 .5

% )

$ 2

,7 5

1 .4

4

T o

ta l

B id

P r ic

e $

1 8

3 ,4

2 9

.1 1

T o

ta l

C o

st (

E x c lu

d in

g B

o n

d s)

= T

o ta

l D

ir e c t

C o

st +

J o

b O

ve rh

e ad

e x c l

ta x &

b o

n d s

+ T

ax +

O ff

ic e O

ve rh

e ad

s =

$ 1

5 8

,4 8

9 .1

9

T o

ta l

C o

st (

In c lu

d in

g B

o n

d s)

= T

o ta

l D

ir e c t

C o

st +

J o

b O

ve rh

e ad

e x c l

ta x &

b o

n d s

+ T

ax +

O ff

ic e O

ve rh

e ad

s +

B o

n d s

= $

1 6

1 ,2

4 0

.6 3

A c ti

v it

y D

u r a ti

o n

(m o

n th

)

D e p

e n

d s

O n

U n

it E

st im

a te

d

Q u

a n

ti ty

U n

it

P r ic

e

($ )

T o

ta lsM

a te

r ia

l

C o

st

($ )

E q

u ip

m e n

t

C o

st

($ )

S u

b c o

n tr

a c t

C o

st

($ )

D ir

e c t

C o

st

($ )

T o

ta l

C o

st

($ )

(E x c lu

d in

g

B o

n d

s)

T o

ta l

P r ic

e

($ )

L a b

o r

C o

st

($ )

T ab

le -

2