Work Breakdown Structure

The Work Breakdown Structure helps users break down a project into smaller tasks and assign people or teams to do them. Users can easily estimate both labor and expense costs for their projects. The WBS helps by providing details about the roles involved and expenses incurred for each defined task. This makes it easier to track everything in a clear and organized way. The WBS is a helpful tool because everyone on the team can break down tasks, add smaller subtasks, and assign resources and expenses.

The WBS is a complete tool for users because it lets them track project estimates from different versions of a proposal. You can easily copy budgets and forecasts from the Fee Estimator to the WBS. Then, you can adjust things as needed by adding roles, expenses, or even new tasks. This automatically updates the overall estimates for labor, expense cost, effort allocation, and individual task expenses.

We decided to create the Work Breakdown Structure (WBS) feature because we noticed some things:

Using tasks in Project Operations normally needs extra licensing with Microsoft Project Online. But the good news is, the Work Breakdown Structure (WBS) planner comes built-in! This means anyone on your project team can add tasks and estimate expenses and resources, as long as they have the right permissions.
The WBS helps break down projects into smaller tasks, showing both the expected cost and sales price for each. It also calculates the profit and profit margin, making it easy for everyone to understand the financial picture of the project.
This feature leverages the new xl360 platform built as canvas application.
Disconnected from MS P4W, it will allow us to use almost unlimited level of tasks and resource assignments
Tasks, Team members, Expenses and Effort assignments can be maintained on real time from a single screen directly in the Project form.

Configuration

The section highlighted below are the mandatory setups that needs to be configured by System Admin to use the WBS Planner.This feature can be enabled from the Parameters.

“WBS Planner (Preview)” is a key new feature that will replace MS Projects for the Web when activated. This feature will allow users to maintain the project structure, fee and expense estimates as well as resource assignment from just one view.

Go to Settings > General > Parameters -> Project360 -> Enable WBS Planner

Details of the fields required for WBS Planner Functionality are as follows:

Fields	Description
Enable WBS Planner	Set as “Yes” to activate the new projects360 “WBS Planner” spreadsheet within the Project form.
Enable Effort Assignment	Set as “Yes” to activate the new projects360 “Effort Assignment” spreadsheet within the Project form.

Note – This is a “Preview” feature, and it can be activated and deactivated by configuration. Implementations using MS P4W can continue using it.

If you click on the WBS tab and copy Estimates using the “Copy from Fee Estimates Button”, all the Tasks, Roles, Expenses, Total Cost, Sales, Margin, Profit%, etc., will be transferred from the selected version. If no Estimates need to be copied, the WBS will have a Standard spreadsheet with various buttons like “Add Labour” and “Add Expense Button”, and multiple fields such as Expense Markup%, Sales Currency, etc.

The fields on the top left of WBS in the WBS planner spreadsheet are as follows:

Fields	Description
Expense Markup Percentage	If Estimates are copied from the Fee Estimator, the Expense Markup Percentage field in the WBS will automatically fill with the defined percentage from the selected version, allowing users to modify it later during the project. If no Estimates are copied, the Expense Markup Percentage field will be empty, allowing users to enter a value.
Sales Currency	Sales Currency shows the currency of Contract related to the Project.
Accounting Currency	Accounting Currency shows the currency of the “Contracting unit Company” to which the Project belongs. This means that WBS will use the same currency as the Project itself.

The fields highlighted in yellow contain the list of Tasks to be defined in the WBS. These tasks can be added manually or copied from Fee Estimates.

Fields	Description
Task	Right-click any row, choose “Add Task,” and enter a name. When adding a task, you’ll see options like “Add Subtask,” “Delete Task,” “Promote Task,” and “Make Subtask.” These are clearly labeled and easy to find. If you create a subtask, the main task becomes locked from editing so you can focus on the subtask first.
Start Date	Define the Start Date of Task.
End Date	Define the End Date of Task.
Duration	It is calculated based on the start and end dates you set. The difference between those dates determines how long the task takes.

There are two helpful blue buttons in the WBS that make managing roles and expenses easier:

Add Labor button :
Clicking the “Add Labour” button opens a list where you can choose roles for a task. Click it multiple times to add as many roles as needed, making it easier to set budgets for everyone working on it. By default, you’ll see options like “Role,” “Person available,” “Job title,” “Price you charge,” and “Multiplier for adjusting the price.”

The fields which are part of “Labor button” are:

Fields	Description
Discipline	Disciplines can be defaulted for Roles and Bookable Resources.
Role	If you’re copying estimates or starting a new WBS plan, the Project Manager will always be included. Users can either manually select a role or use filter criteria based on Discipline.
Bookable Resource	Click the dropdown menu of Bookable Resources and choose the resource you want from the list. Bookable Resource is an optional field and can be left blank and users can only select the role, blank resources will be interpreted as generic resources by the system.
Position Name	When users choose a role, its description will default from the selected role.
Sales Price	The Sales Price value will be populated from the Sales Price list related to the Opportunity.
Sales Multiplier	The Sales Multiplier will be populated from Sales Price List markup and if there is no markup then it is defaulted as “1”. The Sales multiplier will be applied on top of Sales price to calculate the final Sales Amount.

Users also have the flexibility to view different Cost and Sales Estimations for Roles . This helps them get an overview of the forecasting and make necessary adjustments if needed. Once labor items are added and necessary details are either auto-generated or manually added, users will be able to see below fields under different labor items.

Fields	Description
Hours	Users must manually input the total number of hours for the labor they will perform on a particular task.
Sales Amount	The Sales Amount of the Labor/Role will be calculated as *Sales Price Sales Multiplier * Hours**.
Total Hours	Total Hours is the total number of hours estimated for labor across all tasks. Row wise calculation : For every Tasks total number of Hours = Sum of number of hours every labour who has recorded some hours for the task. Column wise calculation : The calculation of Total Hours = Sum of the total of Hours at each level of Tasks defined in Spreadsheet.

Add Expense Button
Clicking the “Add Expense” button lets you add different costs to a task. Click it multiple times to add as many cost categories as you need, making it easy to track everything. When you do this, you’ll see fields like:

Fields	Description
Expense Category	The “Expense Category” field shows you all the types of expenses that are currently used in your system.
Expense Markup %	If you choose a Expense Markup % in WBS, then that percentage will be shown in the “Expense Markup%” field , but you can still change it for each individual expense category you add.

After adding expenses and filling in the details, you’ll see both the cost and sales amount for each expense. Here is detailed explanation of both the fields:

Fields	Description
Cost Amount	Users need to enter the cost amount for each expense they added under a expense category.
Sales Amount	Sales Amount calculation varies with Sales and Accounting currency, can be demonstrated with help of some scenarios: If the “Expense Markup %” field has no value, and both the sales and accounting currencies are the same, then Sales Amount = Cost Amount. If the “Expense Markup %” field has a value, and the Sales Currency and Accounting Currency are the same, then the *Sales Amount = Cost Amount {1+ [(Cost Amount Expense Markup %)/100]}. If the “Expense Markup %” field doesn’t have a value, and the Sales Currency and Accounting Currency are different, then the Sales Amount = Cost Amount / Exchange Rate. If the “Expense Markup %” field has a value, and the Sales Currency and Accounting Currency are different, then the Sales Amount = Cost Amount {1+ [(Cost Amount * Expense Markup %)/100]}**.

There are even more useful fields in the WBS spreadsheet for managing expenses and roles. Here are the fields description highlighted below.

Fields	Description
Labor Cost	“Labor Cost” adds up the costs of all roles/resources assigned to different tasks in “Accounting Currency”.
Labor Fees	The “Labor Fees” is sum of all the Sales Amount from all the tasks in “Sales Currency”.
Expense Cost	The “Expense Cost” is the total of all the different costs added up for each task in “Accounting Currency” .
Expense Fees	“Expense Fees” are the total sum of all Sales Amounts for Expense Items defined at every task level in “Sales Currency”.
Total Cost	The “Total Cost” is the sum of the “Labor Cost” and the “Expense Cost” for a task in “Accounting Currency”.
Total Fees	The “Total Fees” is the sum of the “Labor Fees” and the “Expense Fees” for a task in “Sales Currency”.
Total Fees(ACC CUR)	If “Sales Currency” is same as currency of “Accounting currency” then Total Fees (ACC Cur) = Total Fees. If “Sales Currency” is different as currency of “Accounting currency” then *Total Fees (ACC Cur) = Total Fees Exchange Rate**.
Profit	The WBS can be used to track and analyze the actual profit for a project by comparing the actual costs incurred with the originally planned costs and sales price. Profit = Total Fees (ACC CUR) – Total Cost.
Margin %	Margin percentage in a Work Breakdown Structure (WBS) is a measure of the profit or markup applied to the cost of work at each level of the breakdown. Margin % = Profit/ Total Fees (ACC CUR).

Expense Estimates
Additionally, the manual creation of Expense Estimates is synced with the WBS Planner. This sync ensures that any changes made directly to the expense cost or sales amount in either the WBS tab or the Expense Estimates tab will be reflected in the other.

Users can still see that the sales amounts for expense items in the WBS change based on applicable exchange rates if they adjust the cost in the WBS first. This functionality continues to be supported. Additionally, the sales amount field for an expense item is now editable in the WBS, allowing users to manually input their own values. This enables the syncing of the cost and sales amount of an expense item in Expense Estimates.
Users can now also add new expense items by selecting tasks and expense categories with cost and sales in Expense Estimates. These items will directly sync to the WBS under the same task name. Additionally, if a user provides multiple lines of expense items for the same tasks and expense categories in Expense Estimates, the system will create corresponding lines of expense items with the same expense category in the WBS.

Effort Assignment

Move Task Dates/ Move All Task Dates