A Project plan is required to be prepared for the work tendered below, 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 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.

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.

Tender plan

Work activity	amount	rate	cost
Materials
Lanterns	20	10	200
Ballast	20	5	100
Ignitor	20	5	100
Capacitor	20	5	100
Column	20*6*4metre	10.per metre	4800
Cable	20*10 metre	10	2000
Photo electric cell	20*1	50	1000
Tarmac	20*10kg	10	2000
Concrete	20*15kg	10	3000
Hiring charges
Crane	10 days	200 per day	2000
Hiab	10 days	300 per day	3000
Concrete mixer	5 days	100 per day	500

Total material and hiring cost - 18800

Work plan	amount	rate	cost
Excavation of holes	20+ 20 hrs	10 per hour	400
Hiab operator	10 days	200	2000
Wiring of new lamps	20 hours	10 per hour	200
Column installation	20 hours	10 per hour	200
Lantern attachment	20 hours	5.per hour	200
Temporary reinstatement	10 days	100 per day	1000
Permanent reinstatement	5.days	100 per day	500
Transport charges			2000
Contigency			2000
Wastage allowance			2000
Depot security			1000
Admin and management			4000
Contract manager			2000
Drawings cost			1000

Total labour and fixed cost - 18500

Total cost - 37300

Profit margin - 10% - 3730

Total tender cost - 41030

Assumptions used -

Firstly all old and new holes are excavated - 40 holes.

It takes one hour to excavate one hole - 40 manhours

5 people with 8 hour shift are deployed for hole excavation in one day.

Everyday two new lamps are completed and old lamp removed

So it takes 10 days of hiab work

Two lamps of one street are kept working and two are removed every day. So lighting disruption is minimal.

Lamps are purchased and paid for by client

Temporary reinstatement happens every day - 10 days

Permanent reinstatement happens after work of a street is completed - every alternative day - 5 days