Please use below information to create a Budget for the School Library Renovation.

Project cost estimate:

Hourly wage rates

Project Manager (PM) wage rate is $75/hr

Architect hourly billing rate is $120/hr

School employee wages are not included in the project budget

Material costs

Demolition lump sum cost is $15,000

Wall construction lump sum cost is $25,000

Mechanical and Electrical systems lump sum cost $35,000

Painting and carpet installation lump sum cost is $25,000

Furniture costs

Room #1 furniture cost is $12,400 (includes tables, chairs and computer stations)

Room #2 and #3 furniture cost is $7,500 for each room (includes lecture stands and mobile desks)

Below is just an example on how should it look like. Please use below excel template to complete the chart.

Work package Notes Duration (days) 3 1.1 Stakeholder interviews PM works four (4) hours on each of the three days 1.2 Architect selected 1 PM works two (2) hours 1.3 Concept plans created 3 1.4 Concept plan meeting 1 1.5 1.6 Design approved Furniture ordered 1 1 1.7 2.1 General contractor selected Building permit received 1 2 2.2 Demolition 4 2.3 Walls constructed 3 Architect bills for six (6) hours on each of days one and two and four (4) hours on the third day PM works four (4) hours and Architect bills for four (4) hours PM works three (3) hours PM works two (2) hours (ordering material, and manufacturer requires 50% deposit on material cost PM works two (2) hours PM works three (3) hours on day one and one (1) hour on day two PM works four (4) hours on days one and four Architect bills for (4) hours on days one and four General contractor submits bill for Lump Sum price estimate PM works four (4) hours on day three Architect bills for (4) hours on day three General contractor submits bill for Lump Sum price estimate PM works four (2) hours on days three and five General contractor submits bill for Lump Sum price estimate PM works four (4) hours on days one and four General contractor submits bill for Lump Sum price estimate PM works six (6) hours Architect bills for four (4) hours PM works for three (3) Manufacturer submits bill for the remaining 50% PM works five (5) hours PM works two (2) hours Architect bills for six (6) hours 2.4 M/E systems installed 5 2.5 Painting/carpet completed 2 2.6 Final inspection 1 3.1 3.2 3.3 3.4 Furniture delivered Furniture installed Stakeholder walkthrough Project closeout 1 2 1 1 Proj: Budget Baseline Stakeholders/Functions PM Employee Subs PM: Material Date: WBS ID Task Name Demolition Enter $/hour for each Stakeholder/Function $30/hr $15/hr lump sum lump sum Enter total amount for each WBS work 30 480 120 30 30 30 Order Cabintes 3990 1.1 2.1 2.2 2.3 2.4 3.1 Total Budget $510 $4,110 $590 $2,525 $270 560 2495 240 60 Order sink/faucet Order Appliance Order paint Create countertop subcontract Create tile subcontract Create painting subcontract Install cabinets Install countertops Install tile floors Install sink/faucet Install appliances Paint walls & ceiling PM Inspection/punchlist Walk through/acceptance 120 30 60 600 3.2 3.3 4.1 4.2 4.3 4.4 4.5 5.1 6.1 6.2 630 1235 $1,295 $120 $30 $660 1455 $1,455 815 $1,445 $120 $240 $480 $120 $30 Total $14,000 120 240 480 60 60 30 Work package Notes Duration (days) 3 1.1 Stakeholder interviews PM works four (4) hours on each of the three days 1.2 Architect selected 1 PM works two (2) hours 1.3 Concept plans created 3 1.4 Concept plan meeting 1 1.5 1.6 Design approved Furniture ordered 1 1 1.7 2.1 General contractor selected Building permit received 1 2 2.2 Demolition 4 2.3 Walls constructed 3 Architect bills for six (6) hours on each of days one and two and four (4) hours on the third day PM works four (4) hours and Architect bills for four (4) hours PM works three (3) hours PM works two (2) hours (ordering material, and manufacturer requires 50% deposit on material cost PM works two (2) hours PM works three (3) hours on day one and one (1) hour on day two PM works four (4) hours on days one and four Architect bills for (4) hours on days one and four General contractor submits bill for Lump Sum price estimate PM works four (4) hours on day three Architect bills for (4) hours on day three General contractor submits bill for Lump Sum price estimate PM works four (2) hours on days three and five General contractor submits bill for Lump Sum price estimate PM works four (4) hours on days one and four General contractor submits bill for Lump Sum price estimate PM works six (6) hours Architect bills for four (4) hours PM works for three (3) Manufacturer submits bill for the remaining 50% PM works five (5) hours PM works two (2) hours Architect bills for six (6) hours 2.4 M/E systems installed 5 2.5 Painting/carpet completed 2 2.6 Final inspection 1 3.1 3.2 3.3 3.4 Furniture delivered Furniture installed Stakeholder walkthrough Project closeout 1 2 1 1 Proj: Budget Baseline Stakeholders/Functions PM Employee Subs PM: Material Date: WBS ID Task Name Demolition Enter $/hour for each Stakeholder/Function $30/hr $15/hr lump sum lump sum Enter total amount for each WBS work 30 480 120 30 30 30 Order Cabintes 3990 1.1 2.1 2.2 2.3 2.4 3.1 Total Budget $510 $4,110 $590 $2,525 $270 560 2495 240 60 Order sink/faucet Order Appliance Order paint Create countertop subcontract Create tile subcontract Create painting subcontract Install cabinets Install countertops Install tile floors Install sink/faucet Install appliances Paint walls & ceiling PM Inspection/punchlist Walk through/acceptance 120 30 60 600 3.2 3.3 4.1 4.2 4.3 4.4 4.5 5.1 6.1 6.2 630 1235 $1,295 $120 $30 $660 1455 $1,455 815 $1,445 $120 $240 $480 $120 $30 Total $14,000 120 240 480 60 60 30