Question 4 a) Construct a financial flow table from January to June, using the following Table 4a, Table 4a: Actual and Planned % of work completion. Jan Feb Mar Apr May Jun Actual % work completion 20% 35% 55% 60% 80% 90% Planned % work completion 30% 40% 60% 70% 90% 100% 1). The total project cost is $120,000 while the earning is based on the percentage of the actual work that has been completed. The payment from the client will only be received one month after the completion of the work 2). Material spending is based on the percentage of the planned work completed. With the total material cost of $30,000, the supplier has agreed on accepting a two month credits payment term. 3). The salary of one engineer is at $2,500 per month, while each of the 5 workers is getting $1300 per month. The salary should be paid on the same month. 4). Both of the utility and loan cost $5,000 per month, which also need to be settled on the same month. (15 marks) b) Scoring Model uses multiple criteria with weightage to evaluate the project, which can include financial and non-financial criteria. Use the following Table 4b to construct a table with calculated total score, comment on each project and discuss the selected project. Table 4b: Criteria rating for three projects. Criteria Weightage Project A Project B Project C Criteria 1 Compulsory Criteria 2 60% Yes No 50 Criteria 3 Criteria 4 Criteria 5 5 10 15 5 Total Score 80% 50% 90% 90% 80% 60% Yes 70% 60% 60% 65% (6 marks) 6 c) Table 4e displays the Gantt chart on the project. The solid line indicates the material availability, while the grey bar shows the work schedule. Give explanation on each of the activities ID 1, 2, 3 and 4. Discuss on the precautionary action to be taken in the event that the material does not arrive following the schedule. (4 marks) Table 4c: Gantt chart of construction project. 1 2 3 4 5 6 7 8 9 10 11 12 ID Task Name M T W T F S S M T W T F 1 2 3 4 5 6 7 Roof Inspection Electrical wiring Plumbing piping Top sol Electrical fittings Plumbing fittings Flowers Alarm system Handover 8 9