Work Breakdown Structure (WBS):

Before developing a Gantt chart, it's important to complete Work Breakdown Structure (WBS) to illustrate the key components of the project. The complex will consist of a new 150,000 square foot facility with all of the elements mentioned above (e.g. hockey rink, 25m swimming pool, learner pool etc.) plus other components such as project management activities, lounges, and food concession areas. When breaking down your work, think about all these components as well as everything that goes into it (e.g. lighting, flooring, restrooms, seating, scoreboards, etc.)

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 ]