TABLE OF CONTENTS

• What is WIP Report dashboard
• Who can access the dashboard
• Available Build Plans
• Dashboards features
• Calculations in WIP dashboard
  • How the Date Filter Affects WIP Calculation
  • When WIP Is Calculated
  • Excluding Build Plans from WIP Calculations and When WIP Appears Empty
  • Key Columns and Their Sources in WIP Dashboard

What is WIP Report dashboard

Generally, WIP (Work in Progress) is a way of calculation the value of all your goods and services that are not quite finished. To monitor WIP indicator, observe changes in WIP from one period to the next, we use the WIP Report dashboard. The dashboard describes step by step the WIP figure calculation. It shows you budgeted expenses and revenue, actual costs consumed to finish a Build Plan, received revenue from a sale. Using these values, we can calculate adjusted spend and revenue according to the BP completion percentage, and thus determine the current and the previous month WIP.

Who can access the dashboard

Access to the WIP Report dashboard is granted to employees assigned the Financial Employee role.

Available Build Plans

The list of Build Plans (BPs) shown in the WIP Report dashboard is the same as in the Build Plans Dashboard.

A Build Plan is considered available if you have some connection to it. Access depends on your roles memberships:

• If you are a Build Plan Owner, you will see all your BPs.
• If you are a Project Owner, you will have access to all BPs within your projects.
• If you belong to a Project Role with the “has financial access rights” option enabled, you can access BPs where you participate.
• Having the Employee Role “All Direct Cost BPs Financials” grants access to all Direct Cost BPs.
• The “Full Financial” Employee Role provides advanced access to all Build Plans.

By default, the dashboard displays all accessible active Build Plans with approved budgets. To view other Build Plans (such as closed ones or those without budgets), simply uncheck the “Active Only” and “Has Budget” filters.

Dashboards features

To help you use the dashboard effectively, here are some key features:

• Use the top filters to narrow down Build Plans by Customer, Profit Center, Class, or Market.
• By default, the dashboard filters to show only Build Plans that are active and have approved budgets. You can uncheck these filters to include closed Build Plans or those without a budget.
• Use the date filter to view data as of a specific date. This adjusts budgets and financial distributions accordingly. Note: If a Build Plan was completed before the selected date, the WIP value will be empty (null). To see WIP for ongoing Build Plans, select a date before their completion.
• Click the Excel icon to export the displayed data to an Excel file.
• Click on a row to open detailed information about that Build Plan.

Click on the image or open the image in a new tab to enlarge it.

“Has WIP” filter shows you the BPs whose Current WIP and Previous Month Closed WIP is not zero or empty (cannot be calculated because a BP is already closed on the selected dates).

Calculations in WIP dashboard

The WIP calculation is based on multiple data sources, including Budgets, Sales Orders (SOs), Customer Purchase Orders (POs), and Financial Distributions (costs and revenues). Each line in the WIP dashboard represents a Build Plan, and all calculations are performed at the BP level.

How the Date Filter Affects WIP Calculation

WIP is calculated as of a specific date — either today or a date you choose. When you apply a date filter:

• Only data valid on or before that date is included.
• Build Plans must have an approved budget with a Budget Effective Date on or before the selected date.
• Financial Distributions are included only if their dates are on or before the selected date.

When WIP Is Calculated

• A Build Plan must have an approved budget with planned expenses and revenues equal to or greater than zero.
• The Budget Effective Date must be on or before the selected date (either the current date or a user-filtered date).
  • By default, the Budget Effective Date is the Budget Approved Date.
  • For the first budget revision on a started BP, the effective date is set to the BP Started Date.
• If the BP was completed on or before the selected date, the WIP will be empty (null) because the work is finished.
• To view WIP for completed BPs, select a date prior to their completion.
• WIP can also be calculated for BPs that have not yet started, as long as they have an approved budget meeting the conditions above.
• Both the current approved budget and any previous approved budgets valid as of the selected date are considered in the calculation.

Excluding Build Plans from WIP Calculations and When WIP Appears Empty

Certain Build Plans or entire Projects can be excluded from WIP calculations. When a BP or Project is excluded, its WIP value will show as empty (null) in reports and dashboards. This happens because excluded items are deliberately omitted from the calculation, meaning no WIP amount is calculated or reported for them.

Why WIP May Appear Empty (Null)

• Exclusion Settings: If a Build Plan or Project has the "Exclude from WIP" option enabled, its data is removed from WIP calculations entirely. REad more here
• Completed Build Plans (Past Selected Date): If a BP was completed before the chosen date filter, no WIP is calculated since the work is finished.
• No Approved Budget: BPs without an approved budget or with missing planned expenses and revenues are also excluded from WIP, causing empty values.
• Overhead Scenario Build Plans: These are automatically excluded from WIP calculations, resulting in null WIP values.

Key Columns and Their Sources in WIP Dashboard

Here is the detailed table of what data is presented in each column.

Adjusted Baseline, Completion % — sets revenue and spend according to your completion percentage.

This group of columns is ruled by the system constant “BPPercentageCalc”.  The constant determines the method of how you calculate adjusted spends and revenue, and consequently the WIP.

Given that the constant defines of how we can get the BP completion percentage, it can be:

1. The estimated completion percentage (EC %) — it's put manually and stored in the Build Plan card. (Default configuration)
2. The percentage of spent (% Spent) — it is a ratio of actual spend divided to budgeted spend.

In the scheme below, we show how we calculate the adjusted baseline of spend and revenue according to the set configuration of WIP calculation.

We compare then your adjusted spend with the total actual spend, and adjusted revenue with current revenue. It will show us variances in spend and revenue.

Variance under/over spend will be always 0 if you use the percentage of spent. Using the 2nd method determines only variance under/over billed.

Another feature to calculate WIP is the constant “WIPPercentageforBPsWithoutBudget”. It shows you the expected margin — the percentage of sales revenue. We use it to calculate WIP for all BPs that do not have approved budgets or budgets at all (there is no projected revenue).

It can be (according to your preferences on WIP calculations):

• Empty or 0 — do not calculate WIP for Build Plans without approved budgets. Adjusted Spend, Adjusted Revenue, Variance Spend and Variance Revenue are also empty.
• Determined Percentage (more than 0) — means that a BP do not have budgeted revenue. In this case, we charge Actual Spend to the Actual Revenue account and adjust with the specified percentage.

Read next about WIP Summary dashboard.