CCT90 - Independent Assignment #1 - Building a Tiny Home Determine Budget/Time-Phased Cash Flow Created by: Jeremy Spencley (this is a fictional case study) 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" worksheetProject Data Human Resources Resource $ per Hr % of time allocated per task Project Manager 100 30 General Labour 25 100 Framer 30 100 Electrician 40 100 Plumber 40 100 Roofer 25 100 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 $2000b. 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 References: Photo: https://www.prefabreview.com/blog/best-tiny-homes-for-sale-in-virginia

	Project Budget
	Task	Duration (Days)	Start	Predecessor	Project Costs
	Labour	Materials	Risk Contingency	Cost Baseline Total	Per day
1			Jun 1
2
3
4
5
6
7
8
9
10
11
12
13
	Total Project	$ -	$ -	$ -	$ -
	Questions:
	1. Will the project be completed on time and within budget?
	2. Is the funding schedule sufficient to allow the project to remain cash positive throughout? Explain why this is so in your own words.

basis of estimate

Task 1

Task 2

Task 3

Task 4

Task 5

Task 6

Task 7

Task 8

Task 9

Task 10

Task 11

Task 12

Task 13

Task

Direct Labour

Human Resource Type

Optimistic hours

Pessimistic hours

Most Likely hours

Beta Hours

Task Duration in days

Labour Rate/hour

Labour Cost

Other Direct Costs

Contingency Allowance

time phased cashflow

Task	June																													July
1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	30	1	2	3	4	5	6
1
2
3
4
5
6
7
8
9
10
11
12
13
Task	Total costs for the Activity	Week 1	Week 2	Week 3	Week 4	Week 5
1
2
3
4
5
6
7
8
9
10
11
12
13
Outlfow Total Weekly Cost
Outlfow Cumulative Cost
InflowWeekly Funds
Inflow Cumulative Funds
Net Cash Flow based on Cumulative Inflow vs Outflow