XYZ analysis is useful when your spreadsheets already contain figures, yet decisions are still made by guesswork. Money is moving, projects are progressing, and the team is busy, but there is no predictability: today you have enough materials, tomorrow a crew is idle; one month advertising brings a steady flow of leads, the next it goes quiet; one supplier delivers on time, another brings a surprise every time.
The idea behind XYZ analysis is simple: it shows which items behave consistently and which fluctuate and disrupt planning. In construction and renovation, you can apply it to materials, contractors, expense categories, types of work, lead channels, and even client payments.
If keeping schedules, money, and expectations under control is a familiar challenge, combining analysis with management rules can help. We discuss the general framework for regularly reviewing a business through data in our article on business efficiency analysis (in Russian).
Contents:
- Why a construction company needs XYZ analysis
- What XYZ analysis is and what it shows
- What to analyze: materials, expenses, clients, and contractors
- How to calculate XYZ analysis: formula and steps
- How to use the results: decisions for X, Y, and Z
- Combining XYZ with ABC: a priority matrix
- Making XYZ analysis part of management accounting and company routines
- Common XYZ analysis mistakes
Why does a construction company need XYZ analysis?
In a project business, work with the same name can follow different patterns. One month you purchase mainly materials for rough work, the next you complete purchases for finishing work, and in the third additional work piles up. Looking only at total expenses makes management difficult: large categories can hide the disorder within them.
XYZ analysis helps answer a practical question: where can you rely on rules and a plan, and where do you need safeguards and scenarios? This directly affects schedules and money. In construction, high costs often begin with a one-week delay.
Another advantage is that XYZ analysis fits well into regular management reviews. It helps you improve the system: where to record actual results, where to introduce a limit, and where to change agreements with suppliers. The purpose is to adjust how the business works rather than look for someone to blame.
What is XYZ analysis, and what does it show?
XYZ analysis is a way to divide items into three groups according to how consistently they behave over time. You usually take monthly data for a period and examine the spread around the mean.
Group X contains stable items. Their consumption or amount stays close to the mean from month to month, making them easier to plan under comparable conditions.
Group Y contains items with an understandable but changing pattern. This often reflects seasonality, work phases, or external factors such as weather, delivery schedules, and waves of leads.
Group Z contains items with an irregular pattern. Today there is zero activity, tomorrow a spike, then zero again. For these items, it is useful to identify the events that trigger spending or demand and review the forecasting approach; the mean alone is insufficient.
What can you analyze?
Start by choosing your unit of analysis. In construction, materials and expense categories are the most common starting points: they quickly reveal what you can standardize and what needs the project manager’s attention.
Several useful ways to apply XYZ analysis:
- Materials and material groups. Adhesive, primer, drywall, and fasteners may fall into X when consumption is regular; tiles and plumbing fixtures may fall into Y or Z when design choices and delivery times have a significant impact. Your data determines the group, not the material’s name.
- Project expense categories. Logistics, tool rental, waste removal, and subcontracting often fluctuate and exceed the plan.
- Contractors and crews. The consistency of payments and work volumes for a particular crew helps you distinguish regular workloads from one-off engagements.
- Lead channels. If leads arrive in bursts followed by quiet periods, XYZ analysis of inquiries or payments will highlight where you need a different planning model.
If your accounting lacks a clear category structure, XYZ analysis will be noisy: identical expenses will end up in different rows. It therefore makes sense to organize your categories first. Our article on allocating expenses to categories (in Russian) can help.
How do you perform XYZ analysis?
The standard calculation uses the coefficient of variation: V = σ / x̄ × 100%, where σ is the standard deviation and x̄ is the mean of the series. The higher V is, the greater the spread relative to the mean. The coefficient itself does not identify the cause of fluctuations or guarantee forecast accuracy. V is undefined when the mean is zero; if all values are zero, the row cannot be classified using this formula. When the mean is close to zero, the coefficient is sensitive to small changes: these rows need a separate check. The limitations are explained in the NIST reference on the coefficient of variation.
Next, set the group boundaries. Common thresholds are X: V ≤ 10%, Y: 10% < V ≤ 25%, and Z: V > 25%. In a project business, you can adjust these boundaries to your circumstances; the key is to preserve their meaning: X provides a foundation for planning, while Z represents uncertainty.
The steps are as follows:
Step 1. Choose a period. In construction, 6–12 months is a common choice for seeing seasonality and work phases.
Step 2. Collect a series for each item: the monthly amount in rubles or quantity in units, using one format for all rows.
Step 3. Calculate the mean and standard deviation for each series.
Step 4. Calculate the coefficient of variation V.
Step 5. Assign the item to group X, Y, or Z using your chosen boundaries.
Step 6. Check 5–10 rows from each group: this will help you quickly determine whether the period is appropriate and whether the data contains errors or irrelevant entries.
Technically, you can do this in Excel in an evening. Gathering complete source data is harder. That is why management accounting matters more than formulas.
How do you use the results: decisions for X, Y, and Z?
Each group calls for its own set of management decisions: where to establish a standard, where to keep a time and money buffer, and where to switch to working on demand.
| Group | What does it look like in construction? | What should you do? |
|---|---|---|
| X | Consistent expenses, repeated purchases, regular payments | Standards, procedures, price lists, a designated supplier, and checklist-based price and quality control |
| Y | Waves linked to work phases, seasonality, and noticeable month-to-month deviations | Planning by phase, schedule buffers, scenarios, and monitoring the causes of planned-versus-actual deviations |
| Z | One-off spikes, long pauses, unreliable deliveries, or one-off purchases | Advance orders, advance payments, purchasing for a specific project, separate approval, and a rule against keeping stock just in case |
For example, if logistics falls into Z, it signals either that delivery rules are missing and everyone arranges transport however they can, or that the category combines different types of activity. Here it helps to connect XYZ with an analysis of deviations and the factors behind overspending. Our article on business efficiency analysis (in Russian) covers this.
Combining XYZ with ABC: a priority matrix
XYZ shows consistency; ABC shows the financial contribution. Together they create a nine-cell matrix that helps you set priorities without overcomplicating the discussion.
How to read the matrix in practice:
- A+X. A major financial contribution and stable behavior. This calls for rules, price control, and clear ownership.
- A+Z. A major financial contribution and unpredictability. This is where schedule disruptions and cash shortfalls most often hide. The solution is almost always organizational: approvals, delivery terms, advance payment, and a time reserve.
- C+Z. A small financial contribution and unpredictability. Here, simplification works well: less attention, fewer procedures, and more work on demand.
To keep the matrix useful for decisions, keep your core financial reports alongside it: Cash Flow, P&L, and the balance sheet. Our article “Three Essential Reports for Business Owners” is a helpful guide.
How do you make XYZ analysis part of your company’s management accounting?
It is useful to make XYZ analysis a habit. Calculating it once is helpful. Reviewing it regularly and changing the rules turns it into management.
A simple routine that most teams can maintain:
- Once a month: update XYZ for one area, such as materials or expense categories for your main projects.
- Once a quarter: revisit the boundaries and check whether the business model has changed, for example through new project types, new channels, or a new team.
- Every week: briefly review deviations in groups Y and Z: what happened, who owns the issue behind it, and what rules are needed.
When records are kept in different places, gathering data starts to consume time and errors in the figures become routine. In a project business, it is therefore more convenient to manage each construction job as a separate project, with every event linked to a category and a document. This approach underpins the 101 App and its project analytics. For more on building analytics in your company, see our article on a business analytics system (in Russian).
Would you like to examine your situation through the numbers and understand which views of the data could help you this month? Join a demonstration: it is an easier setting for discussing your project model and suitable ways to organize your accounting.
Common XYZ analysis mistakes
Mistake 1. Mixing different types of items. Materials, work, deliveries, and miscellaneous expenses all end up in one table. XYZ then becomes noise. Keep each table focused on one analytical dimension.
Mistake 2. Choosing too short a period. Three months rarely reveal seasonality. In construction, 6–12 months is a better choice, especially if you have winter troughs or summer peaks.
Mistake 3. Misinterpreting months with zero activity. For one-off work, zeros may be normal. In that case, Z is an accurate result, and the response is a management decision: working on demand, advance payment, and separate terms.
Mistake 4. Taking no action after creating the table. XYZ should be part of how you manage. It should change the rules: limits, approvals, delivery terms, category structure, and phase planning.
Ultimately, XYZ analysis helps you do two things: stop spending attention on stable minor items and spot in advance the areas where planning breaks down most often. From there, disciplined recordkeeping and regular analysis take over. Our article on business efficiency analysis (in Russian) provides a useful foundation and explains the principle of comparing plan with actual results, finding the causes, and making changes stick.
