OUTPUT

To complete the worksheet provided. Pythagoras Theorem and “ramps” resource

POINTS TO CONSIDER:

Please refer to the Resources provided below to help with this task. 

Open the ‘Preliminaries’ document and refer to the Programme tab and the Preliminaries tab. 

1. 1. 1. On the Prelims tab, use the number of days in column B to calculate the percentages of the work week in column C e.g. 5 days would be 100%, and 1 day would be 20%. Some roles in Construction will work on 1 project full time, whereas other roles will be over several projects, and their costs are split accordingly.   
      2. Use the Programme tab to identify which week each role will start and finish on site. On the Prelims tab populate column D (From) & column E (To), to calculate the number of weeks that each person is on-site.  
      3. What is the total cost of preliminaries? 
      4. The total cost of the Project is 1 Million Pounds. What percentage of the £1,000,000 is the staff Work this out in cell H63. 
      5. What is the number of staff on the project? Write this in cell H64. 
      6. What is the cost of 1 week’s preliminaries on site? Work this out in cell H65  
      7. What would the overall cost be if the programme length increased to 25 weeks instead of 20? Use your answer from item f above.  
      8. What would be the additional cost if the planner works for 2 days a week instead of 1?  
      9. What would be the additional cost if the Site Surveyor works for 5 days a week? 

OUTPUT