WBS Code	Name
1	Charter signed off
2	Purchase supplies	1
3	Shutters
3.1	Repair shutters	2
3.2	Paint shutters	3.1
3.3	Hang shutters	3.2
4	Porch
4.1	Repair porch	2
4.2	Paint porch	4.1
5	Floor
5.1	Repair floor	2
5.2	Sand floor	5.1
5.3	Refinish (paint) floor	5.2
6	Painting
6.1	Paint ceilings	5.1
6.2	Paint doors	6.3
6.3	Paint interior walls	5.2
6.4	Paint exterior walls	4.1
7	Windows
7.1	Wash exterior windows	6.3
7.2	Wash interior windows	6.4
7.3	Hang curtains	6.3
8	Project completion

Old Farm House Project Case Study

You have inherited a century old farm house and acreage in a rural area. You have visited the site and made an inspection. The house needs a great deal of repair work to make it liveable. You have itemized the most important things that need to be done and broadly estimated that 2 weeks will be required to complete the project with the resources shown below.

You plan to use this house for holidays and as a rental property. Your parents have provided you with a personal loan of $10,000 - that will give you enough money to buy the supplies and have a budget to hire assistance from a local carpenter, a painter and their apprentice. You yourself have committed to working 80 hours over your holiday to fix up the house, but you are terrible at carpentry and painting. Your two weeks holiday leave starts on Monday the 1st of June. Assume you, the carpenter, the painter and the apprentice^[1] all can work up to 8 hrs per day, 5 days per week.

Each activity is to be performed by one person only. Each person can only work on one activity at a time.

Continually ask yourself the question "when this is done, what else can I start now, or which things can I at the same time?".

Resources	Cost	Note
Supplies	$5,000
You	$0	Can do every job except carpentry (wood repair) and painting
Carpenter	$125 per hour	Expert in carpentry (wood repair), cannot paint
Painter	$60 per hour	Expert in painting, cannot do wood repairs
Apprentice	$40 per hour	Can do every job except carpentry (wood repairs) and painting

Please note while working on this project, many assumptions are made that appear unrealistic, such as for example the wages, or constraints around who can do what.

[1] For this case the carpenter/ painter does not need to be present to have the apprentice working on site.

Can you please help me make this WBS above into an Excel AoN chart? With forward and backwards pass calculations, please?

Thank you