You are currently working as a planner in a construction company. The company is currently running 4 different construction works. The monthly planned value of work done for each project is according to the schedule as shown in Table 2. Table 2: The Planned Value of Work Done Schedule Jan Feb March April May Project A 60,000 100,000 120,000 120,000 200,000 Project B 100,000 80,000 120,000 140,000 140,000 Project C 80,000 80,000 70,000 90,000 100,000 Project D 120,000 120,000 100,000 120,000 150,000 Based on the data obtained from each project, you have found out the value of work done on the 31st of March, which is shown in Table 3 below. Table 3: The Actual Value of Work Done and Direct Cost Incurred as of the Project 31st of March Actual Value of Work Direct Cost Incurred ABCD Done 300,000 250,000 250,000 280,000 220,000 180,000 200,000 240,000 Each project is supposed to contribute 10% profit and 8% overhead to the company. You are requested to present to the company the turnover as of the 31st of March. Prepare your answer by answering the following questions. a) Calculate the planned value of work done, the total planned overhead and the total profit contribution from all the projects as of the 31st of March. (4 marks) b) Calculate the actual value of work done and the total actual profit contribution from all the projects as of the 31st of March. (3 marks) c) Analyse on the variance between the planned and actual nett profit contribution of all the projects as of the 31st of March, and comment on the status of the projects