PM Comm Plan

profileSbrain1722
FamilyHouseConstructionProjectTimelineBudget.xlsx
Home>Business & Finance homework help>Economics homework help>PM Comm Plan

Intro

Individual Term Project Part 3
Shannon Brain
Yorkville University
BUSI 3623 Project Planning Essentials
16-Feb-20

Budget

Family House Construction Plan
Project Owner: Joseph Manning
Budget $500,000
Requirement Anaylsis Planned Actual (+/-) Comments
Engineering project reports $145,000.00 123,000.00 $22,000.00
Product quality checks report $3,000.00 3,200.00 -$200.00 Additional reports requested
Design documents $5,000.00 4,850.00 $150.00
Proposals $1,000.00 1,250.00 -$250.00 Updated quote
Drawings $1,000.00 1,100.00 -$100.00 Customer changes
Survey/Prepare Site $7,500.00 6,250.00 $1,250.00
Design structural components $5,000.00 6,000.00 -$1,000.00 Customer changes
House assessment report $2,000.00 1,100.00 $900.00
Install Foundation $75,000.00 82,000.00 -$7,000.00 Rework cement
Frame $25,000.00 23,750.00 $1,250.00
Roof install $50,000.00 47,000.00 $3,000.00
Window/Doors $50,000.00 50,000.00 $0.00
   Power connection $10,000.00 10,000.00 $0.00
Water connection $12,000.00 13,500.00 -$1,500.00 Change in scope
Progress Reports $1,000.00 2,500.00 -$1,500.00 Additional reports requested
Drywall install $7,000.00 9,000.00 -$2,000.00 Additional labour
Trim $3,000.00 3,200.00 -$200.00
Paint $5,000.00 4,400.00 $600.00
Floor install $20,000.00 18,000.00 $2,000.00
Kitchen Install $40,000.00 42,000.00 -$2,000.00 Added Features
Bathroom install $20,000.00 26,009.00 -$6,009.00 Added Features
Grade Yard $10,000.00 26,000.00 -$16,000.00 Driveway added
Build Inspection $2,500.00 2,200.00 $300.00
Total $500,000.00 $506,309.00 -$6,309.00 Result :
Over Budget

Gantt Timeline

Create a Gantt Chart in this worksheet. Enter title of this project in cell B1. Legend title is in cell I1. Information about how to use this worksheet, including instructions for screen readers and the author of this workbook is in the About worksheet. Continue navigating down column A to hear further instructions. Family House Construction Project Legend:
Enter Company Name in cell B2. A legend is in cells I2 through AC2. Family House Construction Project On Track Low Risk Med Risk High Risk Unassigned
Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell F3 or allow the sample formula to find the smallest date value from the Gantt Data table. Project Start Date: label is in cell D3. Joseph Manning Project Start Date: 1/1/20
A Scrolling Increment is in cell F4. Months for the dates in row 5 are displayed starting in cells I4 through cell BL4. Do not modify these cells. They are auto updated based on the project start date in cell F3. Scrolling Increment: 0 January February
Cells I5 through BL5 contain the day number of the month for the Month represented in the cell block above each date cell and are auto calculated. Do not modify these cells. Today's date is outlined in Red (hex #AD3815) from today's date in row 5 through the entire date column to the end of the project schedule. 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 29 30 31 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
A scrollbar is in cells I6 through BL6. The increment for paging through the data is defined as 2 pages at a time and can be configured in the settings for the control bar. To jump forward or backward in the timeline, enter a value of 0 or higher in cell F4. A value of 0 takes you to the beginning of the chart.
This row contains headers for the project schedule that follows below them. Navigate from B7 through BL7 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell I7 and continues through cell BL7. All project timeline charting is auto generated based on the category, start date and number of days entered in the Milestones table. Milestone Description Category Assigned To Progress Start No. Days Column1 W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T
Do not delete this row. This row is hidden to preserve a formula that is used to highlight the current day within the project schedule.
Requirement Anaylsis Milestone T Smith 100% 1/11/20 8
Enter Project information starting in cell B9 through cell G9. Sample data is in cells B9 through G33. Enter Milestone Description, select a Category from the drop-down list, assign someone to the item, enter the progress, start date and number of days for the task to start charting. The next instruction is in cell A34. Engineering project reports On Track T Smith 59% 2/14/19 2
Product quality checks report Goal A Solce 75% 3/13/20 3
Design documents On Track A Solce 100% 1/1/20 30
Proposals Low Risk T Smith 90% 3/10/20 10
Drawings Milestone A Solce 100% 1/22/20 14 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Survey/Prepare Site Milestone J Baker 100% 2/5/20 7
Design structura;Componentns Design structural components Milestone J Baker 100% 1/29/20 10
House assessment report Milestone Jbaker 100% 3/19/20 6
Install Foundation Milestone J Baker 75% 2/14/20 14
Frame On Track L Coal 0% 2/28/20 14
Roof install On Track L Coal 0% 3/6/20 7
Window/Doors Milestone Graybar 0% 3/13/20 4
   Power connection On Track C Docker 0% 3/14/20 7
Water connection On Track L Coal 0% 3/14/20 7
Progress Reports Low Risk T Smith 0% 3/19/20 11
Drywall install On Track J Baker 0% 3/23/20 14
Trim On Track J Baker 0% 4/6/20 7
Paint On Track J Baker 0% 4/7/20 14
Floor install Goal J Baker 0% 4/20/20 21
Kitchen Install Goal J Baker 0% 5/12/20 5
Bathroom install Low Risk J Baker 0% 5/12/20 4
Grade Yard Milestone J Baker 0% 4/20/20 2
Build Inspection Milestone J Baker 0% 5/15/20 1
Walk thru/Final Acceptance Milestone J Baker 0% 5/30/20 1