MODULE TITLE : BUSINESS MANAGEMENT TECHNIQUES TOPIC TITLE : PROJECT PLANNING AND SCHEDULING TUTOR MARKED ASSIGNMENT 5 NAME....................................................................................................................................... ADDRESS................................................................................................................................ .................................................................................................................................................. .................................................................................................................................................. ...................................................... HOME TELEPHONE ..................................................... EMPLOYER............................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ...................................................... WORK TELEPHONE...................................................... BMT - 5 - TMA (v1) © Teesside University 2011 THIS BOX MUST BE COMPLETED Student Code No. .................................................................................................... Student's Signature .................................................................................................. Date Submitted ........................................................................................................ Contact e-mail ......................................................................................................... Published by Teesside University Open Learning (Engineering) School of Science & Engineering Teesside University Tees Valley, UK TS1 3BA +44 (0)1642 342740 All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording or otherwise without the prior permission of the Copyright owner. This book is sold subject to the condition that it shall not, by way of trade or otherwise, be lent, re-sold, hired out or otherwise circulated without the publisher's prior consent in any form of binding or cover other than that in which it is published and without a similar condition including this condition being imposed on the subsequent purchaser. IMPORTANT Before you start please read the following instructions carefully. 1. This assignment forms part of the formal assessment for this module. If you fail to reach the required standard for the assignment then you will be allowed to resubmit but a resubmission will only be eligible for a Pass grade, not a Merit or Distinction. You should therefore not submit the assignment until you are reasonably sure that you have completed it successfully. Seek your tutor's advice if unsure. 2. Ensure that you indicate the number of the question you are answering. 3. Make a copy of your answers before submitting the assignment. 4. Complete all details on the front page of this TMA and return it with the completed assignment including supporting calculations where appropriate. The preferred submission is via your TUOL(E) Blackboard account: https://eat.tees.ac.uk 5. Your tutor’s comments on the assignment will be posted on Blackboard. 6. Free downloads of Microsoft Project are available from the University SST website at http/sst.tees.ac.uk. (See next page for instructions.) 1 Teesside University Open Learning (Engineering) © Teesside University 2011 Free download of Microsoft Project 2002 You will require your University Student Number (letter followed by 7 digits) and IT access details, which includes your password, sent to you when you enrolled on the course. Go to SST home page at htpp://sst.tees.ac.uk/ Locate SST Downloads on the left hand menu and underneath this MSDNAA. Click on this link. The page will refresh and first brings up a dialogue box and then automatically goes to the MSDN Academic Alliance software centre. Click log in. Fill in your Account Number and Password and click log in. If this is not your first visit to this site, the page will refresh to "My Software". You should click on "To order new software click here" and then continue as follows. On the new page enter Project in the Search box and click on Go. In the list find Project Professional 2002 and click on it. On the new screen, click on Add to Cart. On the new screen click on Checkout. Fill in your details and click next. Click on Download and then on the new screen print the page and then click on Download. When the dialogue box appears click on save noting where you have saved the filed to. After this close the Browser and go the downloaded file. Click on this and the installation procedure will start. Follow the on-screen instructions. 2 Teesside University Open Learning (Engineering) © Teesside University 2011 (a) State what factors need to be considered when tendering an estimate for a contract. (b) Before tendering as a contractor supplying materials and equipment specified by the client, state briefly some checks that should be made prior to compiling the tender in order to determine any contract clauses, contingencies or unforeseen circumstances that may affect future profits. (c) Prepare a tender/estimate for the installation of 20 steel street lamps in 5 streets of a small town to replace ageing concrete lamp standards, using the following information. The holes for the lamp standards have to be excavated using manual labour. The old concrete lamps need to be removed using a lorry mounted crane or ‘Hiab’, which also serves as an extendable high platform. The old lamps are first disconnected by the Supply Authority, which does not form part of the contract. Removal of old standards to contractor depot is part to the contract. The new lamp standards consist of the lanterns (lights) complete with the ballast, ignitor, capacitor and lamp already fitted. The main materials then are the column, the lantern, the cable to wire it, a photo-electric cell, tarmas and the concrete. The lamps are supplied by the contractor to the client’s specification. The lamp standards have to be erected then concreted (6 metre columns specified require a 1.3 m buried root depth) then the luminaires/lanterns fixed to the top and connected to the connection box at the base of the column. In order to keep the street lighting disruption to a minimum during lamp standard replacement, arrangements are made with the supply authority to disconnect old standards and connect the ‘tails’ (i.e. loose cable one end of which is connected to the lamp standard to be used to connect to the supply cable) of new standards. 3 Teesside University Open Learning (Engineering) © Teesside University 2011 Connection and disconnection by the Supply Authority is not part of the project tender. This means that the new standards have to be wired ready for connection. In order to do this holes have to be excavated adjacent to the old standards to accommodate the new standards and they have to be concreted with tails brought out before connection can take place. When connection is complete, the old concrete standards are removed and temporarily stored for disposal in the contractor’s depot and the holes of both new and old standards reinstated. Generally the new standards can be placed within 2 metres adjacent to the old standards. A mobile crane or ‘Hiab’ lifts the columns and sets them in the holes and is also used as a platform for working at height. The lanterns, which contain an infra-red detector for automatic switch-on are pre-wired by the contractor to avoid damage during installation and are attached at height using the ‘Hiab’ lorry mounted crane to the columns after column installation. Cables and wiring are passed from the lantern and threaded down the column to the connection box at the bottom. The lamp standards have to be connected at the base connection box by cable ‘tails’ to an existing lighting cable run along the pavement. Identification of existing underground cables is performed by the Supply Authority and drawings passed on to the contractor prior to work commencing. Connection, made by the Supply Authority, is arranged by the client. Students may assume that the lamps are delivered to the contractor storage depot and are paid for or enter a cost for purchase and delivery in their tender. 4 Teesside University Open Learning (Engineering) © Teesside University 2011 Students are at liberty to assign their own labour, ordinary and overtime rates and costs/values for: • materials, such as concrete, cabling and accessories and paving stone replacement or tarmac reinstatement • hire of equipment, such as cranes, HIABs, concrete mixers, etc. or other hired equipment • times for excavating and the size of excavations • cable measuring, cutting, laying, connecting and testing of lantern and column cable connections prior and post erection • contractor overheads, including depot security, management, clerical (wages, etc.) and contract manager’s time compiling tender document and so on • any contingencies (e.g. bad weather, vehicle breakdown, vandalism, strikes, difficult terrain, etc, production of As-Built drawings detailing position of new lights and connections underground etc, if any) • any other contractor costs that the student may consider necessary. Costs can calculated without considering VAT. Students should endeavour to use sufficient labour to complete the work within three to four weeks and without interruption of street lighting availability. 5 Teesside University Open Learning (Engineering) © Teesside University 2011 All assumptions on which the tender is based regarding quantity of labour and type, duration of manpower employed, times for excavation, positioning and concreting of new standards, removal of old standards, etc. should be stated. Note: There are many options to consider when tendering. For example, students may opt for excavation of all holes before commencement of new column installation as this will cut down on the duration of the Hiab hire. Alternatively students may consider it more profitable for the contractor to excavate so many holes for old and new standards, then install the new and remove the old standards before proceeding with more excavations. It should be remembered that the street lighting has to be maintained during the replacement of the standards and the Supply Authority will only disconnect two old and connect two new standards per day. It is recommended that the best way to execute the contract is to leave as few excavations open as possible and to leave as many columns in lighting as possible. Temporary reinstatement usually takes place after standard positioning and connection and permanent reinstatement of flags or tarmac in a street will be performed after street completion. If costs for materials are estimated (for such as paving stones or tarmac, etc.) allowance should be made for some wastage. The tender should include labour materials, overheads and contingencies, and need not include financial arrangements between contractor and client. As the tender is a preamble to a project plan, these can be assumed to be interim payments with adjustments and final settlement and it is not necessary to prepare a cash budget, etc. Constraints should be recognised, as for example the minimum time the Hiab will be required will be 2 weeks if it installs 2 new and removes 2 old standards per day. All such modes of working should be clearly stated and reasons briefly given for the assumptions on which the tender is costed, for the benefit of the client. 6 Teesside University Open Learning (Engineering) © Teesside University 2011 If a contractor has a long term arrangement as preferred contractor with a local authority or Highways Agency Area, there would usually be a rate or price agreed at the tender stage for the erection of a new column. There would also be a number of rates to cover the different lantern types and column sizes. Alternatively some contractors tender on a ‘cost plus’ basis where the client is charged the material and labour cost plus a percentage for the contractor’s overheads and profit. This is the form the student’s tender should take, which requires work activities, amounts of labour and rates to be specified and the costs of activities, equipment, contractor’s overheads, etc. to be estimated. From this a project plan will emerge. If a tender is pitched too high with profit it may lose out to another contractor. If too low, it will lose money. It’s a fine line. (d) A Project plan is required to be prepared for the work tendered for in part (c) using Microsoft Project 2000 Software, or later, or any other suitable project software. Notes should accompany the project assignment describing the details and thinking behind the project form. The project should show such features as: • Gantt chart with tasks, dates, bar charts, etc. showing linked tasks with any lead or lag times • critical path • resources list completed • resources usage • task usage 7 Teesside University Open Learning (Engineering) © Teesside University 2011 • tracking Gantt chart • resource fixed and task costs • project % completion and cost report(s) • tasks that can start simultaneously or prior to the finish of their predecessor, if any. Task usage with associated costs (resource and task costs) should be simulated for the project at 100 % completion and reports produced. Hard copies of the project assignment are required. CDs or floppy disks can also be submitted. It should be noted that the critical path view must be saved as a separate project or as a screen dump figure pasted into, say, Paint, which is usually available in Microsoft Office (or Word) Programs/Accessories on the Start Menu. This is because, if resources are assigned to tasks the critical path is obscured and shows in normal task colour. Any views that may be lost in the course of completing the project must be saved at an appropriate time. Alternatively students may wish to do a power point presentation of various views of their project. 8 Teesside University Open Learning (Engineering) © Teesside University 2011 It is worth using the first task as a repository for making notes about the project as one progresses. This is done by selecting Project/Task Notes which brings up a dialogue box into which can be typed notes and memos, such as “foreman is not assigned to task (a) because this task is performed on the same day as task (b) to which the foreman has already been assigned”, etc. Leaving the resources dialogue box open and assigning resources will leave the same resources selected for repetitive tasks, which facilitates resource assignment. Alternatively, if there are many repetitive tasks, by holding down the ‘Control’ key each repetitive task can be highlighted and then by selecting the Assign Resources icon (or Tools/Assign Resources) and entering the resources data in the dialogue box all the tasks selected will be updated without having to select each task individually. This same technique can be applied to task progress tracking, by holding down the ‘Control’ key each repetitive task can be highlighted and then by selecting Tools/Tracking/Update Task, and entering the progress data (e.g. 100 %, actual duration and remaining duration) all the tasks will be updated without having to select each task individually. Assessment will largely be based on the type and quality of the project program of work execution. 9 Teesside University Open Learning (Engineering) © Teesside University 2011