Cost Estimates:

Newfane Town Council initiated the project with funds secured from the new tax revenue generated because of the housing development and developer levies collected to support infrastructure projects. However, initial funding of $40M budgeted for the project were found to be insufficient to achieve the requirements and further funding was required. Town Recreation and Infrastructure Project Committees constructed a business plan that secured an additional $25M from a Provincial grant for a total project budget of$65M.

I have prepared the budget table

Budget table:

Resource	Cost/SF per item	Total cost per Item	% of Total Budget per Item
Contractor Fees	$40	$6,000,000	9.23%
Architectural Fees	$12	$1,800,000	2.77%
Consultation Costs	$1	$150,000	0.23%
Cost of Materials	$300	$45,000,000	69.23%
Permit/Fees	$2	$300,000	0.46%
Equipment Rentals	$50	$7,500,000	11.54%
Total Budget:		$65,000,000

I have prepared the WBS

Work Breakdown Structure (WBS)

Project: Construction of Recreational Community Centre in the Town of Newfane

Phase 1: Planning	Phase 2: Execution	Phase 3: Control	Phase 4: Turnover
Preparation of construction documents	2.1 Laying of Foundation	2.2 Building Exteriors	2.3 Building Interiors	3.1 Schedule	3.2 Budget	3.3 Quality	4.1 Physical turnover of facility
1.1.1 Identification of project scope	2.1.1 Excavation works	2.2.1 Framing of buildings / pool / court	2.3.1 Placement of drywalls / tiles	3.1.1 Monitoring of project milestones	3.2.1 Monitoring expenses	3.3.1 Conducting site inspection	4.1.1 Cleanup
1.1.2 Preparation of detailed drawings	2.1.2 Pouring of concrete	2.2.2 Roofing works	2.3.2 Electrical works			3.3.2 Monitoring compliance with building codes and regulations	4.1.2 Demobilization of equipment
1.1.3 Preparation of budget plans and work schedules			2.3.3 Plumbing works				4.1.3 Grand opening ceremony

Need budget in below excel form with reference to WBS

Labor Materials Fixed WBS `Task Hrs Rate Units $/Unit Costs Budget Actual Under(Over) [ Level 1 Category ] $ 1,300.00 $ 450.00 $ 850.00 1.1 [ Level 2 Task ] 8.0 $12.50 25.0 $4.50 $50.00 262.50 150.00 112.50 1.2 [ Level 2 Task ] 10.0 $11.25 $250.00 362.50 100.00 262.50 1.3 [ Level 2 Task ] 30.0 $22.50 675.00 200.00 475.00 1.3.1 [ Level 3 Task ] 1.3.2 [ Level 3 Task ] 1.3.2.1 [ Level 4 Task ] 1.3.2.2 [ Level 4 Task ] 1.3.3 [ Level 3 Task ] 1.4 [ Level 2 Task ] 1.5 [ Level 2 Task ] 2 [ Level 1 Category ] 2.1 [ Level 2 Task ] 2.2 [ Level 2 Task ] 2.3 [ Level 2 Task ] 2.3.1 [ Level 3 Task ] 2.3.2 [ Level 3 Task ] 2.3.2.1 [ Level 4 Task ] 2.3.2.2 [ Level 4 Task ] 2.3.3 [ Level 3 Task ] 2.4 [ Level 2 Task ] 2.5 [ Level 2 Task ] 3 [ Level 1 Category ] CA 13.1 [ Level 2 Task ] 3.2 [ Level 2 Task ] 13.3 [ Level 2 Task ] 3.3.1 [ Level 3 Task ] 3.3.2 [ Level 3 Task ] 3.3.2.1 [ Level 4 Task ] 3.3.2.2 [ Level 4 Task ] 13.3.3 [ Level 3 Task ] 3.4 [ Level 2 Task ] [ Level 2 Task ]