Project Scheduling and Budgeting

Project proposal with supporting documents (Gantt Chart, Network Diagram, Budget) and answers to questions (equivalent of 1,500 words)

Learning Outcomes: Knowledge and Understanding assessed in this assignment:
Examine, explain, and evaluate a variety of techniques used for project scheduling and budgeting
Critically analyse and apply appropriate project scheduling and budgeting techniques to real world projects

Formulate and solve model project schedules and resource plans using appropriate techniques;
Develop project schedules and resource plans for decision-making;
Report the results in a form of project schedule and budget plans, including issues of monitoring and control of projects.

Assignment Title: Project Budgeting and Scheduling - Holiday Home

George and Jane Jetsons have just retired and want to build a small holiday house in the beautiful Greek Island of Mykonos. They have hired Theo Papadopoulos as the general contractor for the project. He has assembled a team of twelve very capable workers who will be available in order to complete the project: 1 electrician (E), 3 bricklayers (B), 1 plumber (P), 1 carpenter (C), and 6 general construction workers (G). Theo has negotiated a cost-plus contract with the Jetsons whereby he will receive 20 percent beyond all the costs (labour and materials). Before they sign the contract, the Jetsons want an estimate of how much the project is likely to cost and how long it will take. Get Homework Help Now!

Theo has estimated the cost for materials as follows: bricks £50,000, metallic parts £20,000, timber £15,000, tiles £14,000, concrete £14,000, electrical wires 5,000, pipes and other plumbing materials 11,000. He wants to determine labour costs as well as how long the project will take. This is one of Theo's several projects. Theo is only managing the team (he is also teaching project management), and other than occasionally helping, his role is strictly limited to supervising and planning the work.

Theo has devised the following master plan and assignments (see table below).
The project will start with 5 general construction workers preparing the site, which will take between 16 and 20 days. Then two bricklayers will join them to pour the foundations. After that, the same five men, with the addition of a third bricklayer, will erect the frame and when frame is done, they will build the walls. The roof can start once the walls are finished, and the three Bricklayers with a Carpenter and two General Construction workers will build it. As soon as the roof is completed, work on Doors and Windows, Plumbing, and Electrical installations can start. As soon electrical and plumbing work are completed, then tiling can start. Works at Patio/Garden and Swimming Pool can also start once plumbing is completed. Once tiles are in place, kitchen installation and heating installation can take place. Walls can be painted/decorated once kitchen and heating have been installed and doors/windows are in place. The carpenter can fit the wardrobes after painting is done. Finally, after fitting wardrobes and finishing the work at external spaces (patio/garden) the team will clean up and hand over the house to the Jetsons.

Electrician and Plumber get paid £200 a day, while carpenter and bricklayers get paid £170 per day. Each general construction worker receives £100 per day of work. Theo has negotiated a 10 percent management reserve to deal with unexpected problems. Any unused funds will be returned to the Jetsons.

For each task you can choose a value withing the given range. For example, for task A the time can be chosen as 20, 21, 22, 23 or 24. Create a new table with the chosen durations.

ID Task Time (days) Resources Needed
A Prepare Site 20 to 24 5G
B Pour Foundation 15 to 20 2B, 5G
C Erect Frame 15 to 18 3B, 5G
D Walls 27 to 34 3B, 5G
E Roof 17 to 22 2B, C, G
F Windows/Doors 9 to 11 C, 2G
G Electrical 9 to 10 E, G
H Plumbing 11 to 15 P, G
I Tiles 8 to 10 B, 2G
J Heating 6 to 8 P, G
K Install Kitchen 10 to 14 C, P, E
L Paint/Decorate 5 to 8 3G
M Fit Wardrobes 5 to 6 C
N Patio/Garden 6 to 9 4G
O Swimming Pool 18 to 22 P, E, 4G
P Clean Up 3 to 4 4G

Description of the assignment, task, content and structure:

Tasks
Choose a time estimation for each task and create a new table. What is the estimated duration and estimated total cost for this project? When will the project finish if the team works five days a week and start on 4th of November 2024?
Prepare a Network Diagram and a Gantt Chart for this project
Prepare a Budget and a Cost Baseline for this project
Did resource limitations affect the final schedule? If so, how?
What is going to be the impact on the project of a 5-days delay in Task B and a 14-days delay on Task F? What would you suggest as a course of action in that case?
What risks does this project face that might increase the cost for the Jetsons or delay their project? What risks are associated with the contract they have signed? What can the Jetsons do to protect themselves against those risks?
After 11 weeks, tasks A, B, and C have been completed and £120,000 have been spent. Use EVM to discuss the progress of the project and to re-estimate its total cost and duration. What do you think about the project progress?

Any specific instructions:

You are advised to use MS Project, but other software can also be used as long as it is fit for purpose.