Construction Management Coursework
Using the information provided in the Bar Chart below, answer the following questions:
a) What is the maximum / highest cost of resources on any single day of the schedule?
b) How many schedule days is the project operating at the maximum resource usage?
c) What is the minimum / lowest cost of resources on any single day of the schedule?
d) What is the total amount of resources used on the project ?
e) How many days does it take for the project to use 80% of the total resources?
A Microsoft Excel version of this question is provided on Black board Act Dur res per 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
day
A 5 2,000$ 400$ 400$ 400$ 400$ 400$ 400$
B 6 6,000$ 1,000$ 1,000$ 1,000$ 1,000$ 1,000$ 1,000$ 1,000$
C 5 7,500$ 1,500$ 1,500$ 1,500$ 1,500$ 1,500$ 1,500$
D 4 6,000$ 1,500$ 1,500$ 1,500$ 1,500$ 1,500$
E 6 4,200$ 700$ 700$ 700$ 700$ 700$ 700$ 700$
F 3 3,600$ 1,200$ 1,200$ 1,200$ 1,200$
G 5 4,000$ 800$ 800
