Home » Downloads » Create a Work Breakout Structure (WBS) for your project using Microsoft Excel.

Create a Work Breakout Structure (WBS) for your project using Microsoft Excel.

Create a Work Breakout Structure (WBS) for your project using Microsoft Excel.

  • Evaluate strategies for managing project scope, time, cost, and quality.
  • Create project deliverables.

Instructions

For this assignment, you will create a Work Breakout Structure (WBS) for your project using Microsoft Excel. As an industry best practice, many project managers will build their WBS using MS Excel to provide a more simplistic view and analysis of the project’s work categories and the “Work Packages.” Once the WBS is approved, the project manager will import the data into the preferred corporate PM Tool. Examples of industry-leading tools include MS Project, Primavera, Clarity, TeamGantt, Monday.com, etc. For unit 4, you are ONLY required to submit your WBS in MS Excel.

Work Breakdown Structure Overview

The Work Breakdown Structure (WBS) is a view into the project which shows what work the project encompasses.  It is a tool that helps to easily communicate the work and processes involved to execute the project.  The Project Manager and project team use the WBS to develop the project schedule, resource requirements, and costs. 

Levels of the Work Breakdown Structure

Level 0 = Project deliverable – Overall project to be delivered.

Level 1 = Key Deliverables – Deliverables required for the success of the project based on the scope.

Level 2 = Sub-deliverables – Sub-deliverables are the components that make up the key deliverables. Sub-deliverables require that the work package get completed. Sometimes, the work package is established at this level.

Level 3 = Work Package – The task level of the WBS where cost and resources and be assigned. Task must begin with a verb. The Work Package rolls up to the sub-deliverables.

WBS Example

This is an excerpt from the detailed WBS created in MS Excel.  

Isley’s Recording Studio Example  Download Isley’s Recording Studio Example [PDF]

Answer preview to Create a Work Breakout Structure (WBS) for your project using Microsoft Excel.

Create a Work Breakout Structure (WBS) for your project using Microsoft Excel

excel

Get instant access to the full solution from yourhomeworksolutions by clicking the purchase button below

Education

Engineering

English

Environmental

Ethics

Film

Food and Nutrition

Geography

Healthcare

History and Government

Human Resource Managment

Information Systems

Law

Literature

Management

Marketing

Mathematics

Nursing

Philosophy

Physics

Political Science

Psychology

Religion

Sociology

Statistics

Writing

Terms of service

Contact