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 Tela Mar Apr May Actual work completion 20% 35% 55% 80% Planned % work completion 30% 70% PON 1). The total project cost is $120,000 while the eaming 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 4bc Criteria rating for three projects. Project C Criteria Weightage Project A Project Criteria 1 Compulsory Yes No Yes Criteria 2 50% 70% Criteria 3 30 90% 60% Criteria 50% 50% Criteria 5 90% 60% 65% Total Score (6 marks) c) Table 4c 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. 10 11 12 2 Electrical wiring 3 Plurking ping 5 Electrical e Puding fing Al system Handover (Total: 25 marks) 40%