Question 27 Cash Flow The programme for the construction of a small workshop building is displayed in the form of a precedence diagram, shown in Fig_027.1. The value of the work contained in each activity has been calculated from the rates contained in the bill of quantities and is listed in Table 027.1. Eig_Q27.1 Precedence diagram for construction of a workshop. 1.5 Durations in months Overlap between finish of X and start of Y 3 Table Q27.1 Value of activities. Activities Duration (months) Value (8) A Excavate 2 9 000 B Concrete base 12 000 C Erect frames 1.5 18 000 D Concrete floor slabs 1 15 000 E Fix cladding 1.5 6 000 F Install plant 1 20 000 Note: Rate of work throughout any activity is uniform The contractor undertaking the project would like you to prepare graphs of cumulative cost and monies received to date against time for activities starting as early as possible, in order to establish a clearer picture of the financial implications of this contract. From these graphs, calculate the net profit if interest is charged at 8% p.a. on outstanding monies. The gross profit margin is 10% of contract value and retention is 5% up to a maximum limit of 3000. Measurement is made monthly with a payment delay of one month. Half of the retention is paid on practical completion and the remaining half six months later. To simplify the calculation, you may assume that all costs must be met at the instant they are incurred. What is the maximum amount of cash the contractor needs in order to execute this contract and when does the contractor require this amount? Question 27 Cash Flow The programme for the construction of a small workshop building is displayed in the form of a precedence diagram, shown in Fig_027.1. The value of the work contained in each activity has been calculated from the rates contained in the bill of quantities and is listed in Table 027.1. Eig_Q27.1 Precedence diagram for construction of a workshop. 1.5 Durations in months Overlap between finish of X and start of Y 3 Table Q27.1 Value of activities. Activities Duration (months) Value (8) A Excavate 2 9 000 B Concrete base 12 000 C Erect frames 1.5 18 000 D Concrete floor slabs 1 15 000 E Fix cladding 1.5 6 000 F Install plant 1 20 000 Note: Rate of work throughout any activity is uniform The contractor undertaking the project would like you to prepare graphs of cumulative cost and monies received to date against time for activities starting as early as possible, in order to establish a clearer picture of the financial implications of this contract. From these graphs, calculate the net profit if interest is charged at 8% p.a. on outstanding monies. The gross profit margin is 10% of contract value and retention is 5% up to a maximum limit of 3000. Measurement is made monthly with a payment delay of one month. Half of the retention is paid on practical completion and the remaining half six months later. To simplify the calculation, you may assume that all costs must be met at the instant they are incurred. What is the maximum amount of cash the contractor needs in order to execute this contract and when does the contractor require this amount