ACCT90 - 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. the basis of estimates and budget worksheet using the task and resources information in this case. 2. 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 Resource $ per Hr % of time allocated Project Manager 100 30 (per day) General Labour 25 100 (per task) Framer 30 100 (per task) Electrician 40 100 (per task) Plumber 40 100 (per task) Roofer 25 100 (per task) 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 Indirect Costs: There will be a one time indirect cost of $250 due on June 15 to cover the mobile phone for the PM. 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