Reference no: EM133346348

Assignment - Building a Tiny Home

Determine Budget/Time-Phased Cash Flow

The Case:

The City of Peterborough has decided to try something new to address the significant issue of homelessness. The city council is interested in pursuing a community of tiny homes, with most of the features of a full-sized home, to allow an affordable housing option for those on limited incomes. The first step in the project is to construct a single home to verify the costs and timeline projected for the effort.

You have been selected as the project manager for the initial tiny home. Your company has a good reputation for quality work and the ability to manage issues effectively. The total budget for the effort is $40,000 CAD, and you have been given one month to complete the work. You will be responsible for having all of the work completed, as well as keeping track of the cash flow on the project to serve as a guideline for future builds. The house will be built on an unused piece of city property, for transportation to its final location later. You will allow for a 10% budget contingency on all tasks to account for any possible risks on the project. It is also customary that no work will take place on the weekends. Your time as a project manager will be calculated at 30% of the numbers of hours for each whole day of the project.

Your Mission:
1. Complete the basis of estimates and budget worksheet using the task and resources information in this case.
2. Complete a time-phased cash flow forecast on the associated worksheet.
3. Answer the questions at the bottom of the "Budget" worksheet

Project Data
Human Resources

Assumptions:
1 day = 8 hrs
*Task durations will be rounded to nearest whole day

Project Tasks:
1. Buy a tiny house trailer and level it on the property.
a. Trailer - $2500
b. General Labour - Optimistic hrs (6), Most Likely Hrs (8), Pessimistic hrs (10)
2. Build and insulate the foundation and install the subflooring.
a. Material - $1000
b. Framers - Optimistic hrs (14), Most Likely Hrs (15), Pessimistic hrs (20)
c. Predecessor is Task 1
3. Frame and install the wall sections including the lofts for sleeping.
a. Materials - $2500
b. Framers - Optimistic hrs (28), Most Likely Hrs (32), Pessimistic hrs (36)
c. Predecessor is task 2
4. Install the roof rafters and sheathing.
a. Materials $1000
b. Framers - Optimistic hrs (14), Most Likely Hrs (15), Pessimistic hrs (20)
c. Predecessor is task 3
5. Enclose the house with sheathing and ty-par weather resistant wrap.
a. Materials $1000
b. General Labour - Optimistic hrs (14), Most Likely Hrs (15), Pessimistic hrs (20)
c. Predecessor is task 4
6. Install windows and doors.
a. Materials $1000
b. General Labour - Optimistic hrs (14), Most Likely Hrs (15), Pessimistic hrs (20)
c. Predecessor is task 5
7. Install the roof.
a. Materials $2000

b. Roofers - Optimistic hrs (14), Most Likely Hrs (15), Pessimistic hrs (20)
c. Predecessor is task 5
8. Install exterior siding and trims.
a. Materials $2000
b. General Labour - Optimistic hrs (20), Most Likely Hrs (23), Pessimistic hrs (30)
c. Predecessor is tasks 6,7
9. Plumbing rough-in
a. Materials $2000
b. Plumber - Optimistic hrs (20), Most Likely Hrs (23), Pessimistic hrs (30)
c. Predecessor is task 7
10. Electrical rough-in
a. Materials $2000
b. Electrician - Optimistic hrs (14), Most Likely Hrs (15), Pessimistic hrs (20)
c. Predecessor is task 9
11. Insulate the walls and roof.
a. Materials $1000
b. General Labour - Optimistic hrs (14), Most Likely Hrs (15), Pessimistic hrs (20)
c. Predecessor is task 10
12. Install interior siding and trims.
a. Materials $1500
b. General Labour - Optimistic hrs (14), Most Likely Hrs (15), Pessimistic hrs (20)
c. Predecessor is task 11
13. Finishing touches
a. Materials $500
b. General Labour - Optimistic hrs (6), Most Likely Hrs (8), Pessimistic hrs (10)
c. Predecessor is task 12

City of Peterborough Schedule of Payments Week 1 - $8000
Week 2 - $8000 Week 3 - $9000 Week 4 - $15,000

Attachment:- Time-Phased Cash Flow.rar