For this assignment, complete the following in the Spreadsheet template: 

  • In the provided spreadsheet template, you will find three tabs along the bottom of the screen. Read through the “Instructions” tab and the “Sample” tab.  
  • In the “Blank Template – Fill This In” tab, complete the following: 
    • Outline a plausible list of tasks needed to complete your chosen project.  
    • Estimate plausible timelines for each task or group of tasks.
  • If you need guidance working in Excel, refer back to the Excel training link in the Week 4 activity. 

Then, in a Word document titled, “Project Tasks and Timeline Rationale”, write a paper: 

  • Use the following headers in your paper: 
    • Part 1: Overview of the Project (Note: This portion of your paper should be about 1 page) 
      • Summary of Goals and Objectives 
      • Summary of Resources and Budget 
    • Part 2: Explanation of Tasks and Timeline (Note: This portion of your paper should be about 2 pages) 
      • Description of all Tasks 
      • Description of Timeline 
      • Explanation of Method(s) Used to Determine Dates (Note: use concepts from the textbook to support your rationale in this section) 
    • Part 3: Risk Factors and Mitigation (Note: This portion of your paper should be about 1 page) 
      • Potential Risks and Mitigation 

Include and highlight in your paper the following ten key terms from the textbook, using each term correctly and in a professional context: 

  • Choose any key term from chapters 1 through 4  
  • “Estimates,” “top-down estimating,” and “bottom-down estimating” from chapter 5  
  • “Activity” from chapter 6  
  • “Risks” from chapter 7  
  • “Resources” and “constraints” from chapter 8  
  • “Project duration” and “project scope” from chapter 9 

Instructions

Week 6 Assignment – Project Tasks and Timeline

Instructions:

Carefully look through the “Sample” tab. Pay close attention to the amount of detail included, and the formatting and organization of the list. You will use this sample list as a guide to create your own list of tasks, but you should not duplicate the content from the sample exactly.

Navigate to the third tab titled, “Blank Template – Fill This In” and complete the following:

1. In the “Activity” column, outline a plausible list of tasks needed to complete your chosen project. You may group tasks together as in the Sample tab, or list each task separately.

2. In the “Start Date”, “End Date”, and “Days to Complete” columns, estimate plausible timelines for each task or group of tasks. In the first row, highlighted in yellow, give a start and end date for the project as a whole.

tc={E7F4959B-F80D-4A4D-B776-698FBD452113}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
Recommend adding language to clearly point out that the three tabs are at the bottom and that they are not to duplicate the content from the sample.

Sample

Project Tasks and Timeline
Developed by John Smith
October 2022
Activity Days to Complete Start Date End Date
Construction Plan 253 Saturday, January 1, 2022 Sunday, September 11, 2022
Planning Activites 30 Saturday, January 1, 2022 Monday, January 31, 2022
Finalize Plans
Sign Contract to Proceed
Construction Activities 45 Monday, January 31, 2022 Thursday, March 17, 2022
Prepare Site
Prepare Foundation for Property
Establish Framing for Property
Exterior Work Activities 30 Thursday, March 17, 2022 Saturday, April 16, 2022
Install Roof
Install Windows
Install Doors
Install Bricks
Install Siding
Interior Work Activities 120 Saturday, April 16, 2022 Sunday, August 14, 2022
Install Insulation
Install Drywall
Install Plumbing & Related Fixtures
Install Electrical & Related Fixtures
Install HVAC
Install Cabinets
Install Flooring
Install Appliances
Grounds Work Activities 14 Sunday, August 14, 2022 Sunday, August 28, 2022
Install Driveway
Install Sidewalks
Install Fencing
Install Deck
Lay Sod & Plants
Final Acceptance 14 Sunday, August 28, 2022 Sunday, September 11, 2022
Clean Up Property for Inspection (Cleaning Service)
Inspection by Local Government
Address Issues from Government Inspection
Inspection by Owner
Address Issues from Owner Inspection
Turn Property Over to Owner

Blank Template – Fill This In

Project Tasks and Timeline
Name
Date
Activity Days to Complete Start Date End Date

Instructions

Week 4 Activity – Project Resources and Budget

Instructions:

Carefully look through the “Sample” tab. Pay close attention to the amount of detail included, and the formatting and organization of the list. You will use this sample list as a guide to create your own list of resources.

Navigate to the third tab titled, “Blank Template – Fill This In” and complete the following:

1. In the “Resources” column, outline a plausible list of resources, goods, and services needed to complete your chosen project. Include at least five resources in your list.

2. In the “Type” column, assign each resource a type. Include at least two different types in your list. You may categorize each resource using the same types as in the Sample tab or utilize your own.

3. In the “Cost” column, estimate appropriate costs for each resource. Though these figures are hypothetical estimates, they should relate to each other and be proportional. .

Then, in the fourth tab titled, “Sources,” list your resources in proper SWS style.

Sample

Project Resources and Budget
Developed by John Smith
August 2022
Resource Type Cost
Foundation Contractor Labor $10,000.00
Framing Contractor Labor $10,000.00
Roofing Contractor Labor $5,000.00
Windows Contractor Labor $2,500.00
Doors Contractor Labor $2,500.00
Bricks Contractor Labor $5,000.00
Siding Contractor Labor $5,000.00
Insulation Contractor Labor $5,000.00
Drywall Contractor Labor $5,000.00
Plumbing Contractor Labor $5,000.00
Electrical Contractor Labor $10,000.00
HVAC Contractor Labor $5,000.00
Cabinet Contractor Labor $2,500.00
Flooring Contractor Labor $2,500.00
Appliances Contractor Labor $2,500.00
Driveway/Sidewalk Contractor Labor $2,500.00
Fencing Contractor Labor $2,500.00
Deck Contractor Labor $2,500.00
Landscaping Contractor Labor $2,500.00
Government Inspector Labor $500.00
Inspection Resolvers Labor $500.00
Cleaning Service Labor $500.00
Lumber Materials $100,000.00
Bricks Materials $50,000.00
Windows Materials $10,000.00
HVAC Equipment $10,000.00
Appliances Equipment $20,000.00
Fence Equipment $10,000.00
Deck Equipment $10,000.00
Flooring Materials $10,000.00
Bathroom / Kitchen Fixtures Equipment $10,000.00
Cabinets Equipment $5,000.00
$324,000.00

Blank Template – Fill This In

Project Resources and Budget
Developed by Tashina Tupai
Date October 31, 2022
Resource Type Cost
Contractors
Plumber Labour $2,700
Electrician Labour $1,800
Painters Labour $900
Drywall installation Labour $3,200
Interior designer Labour $10,000
Flooring Labour $1,900
Insulation Labour $6,300
HVAC Labour $2,700
Fixtures materials $3,200
Light fixture materials $300
Vanity/Sinks (4) materials $3,000
Countertops materials $1,500
Doors and Windows materials $1,500
Paint materials $200
Mirrors (8) materials $4,000
Plumbing materials $2,000
Lotion Bottles (4) materials $800
Doors and Windows materials $2,000
$ 48,000.00

Sources

Sources
Tom Grupa. July 5, 2021. How much does it cost to remodel a bathroom? https://www.homeguide.com/costs/bathroom-remodel-cost#breakdown