# SyteLine Cost Rollup Variance Calculator

> Source: https://netray.co/tools/syteline-cost-rollup-variance-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compare actual job cost to the rolled standard by material, labor and overhead, and see the inventory revaluation caused by a standard cost change.

## Category

cost-finance

## Erp

Infor SyteLine

## Industry

Discrete Manufacturing

## Audience

- Cost accountant
- Controller
- SyteLine administrator

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Standard material per unit

**Key:** std_mat

**Type:** number

**Default:** 18.5

**Min:** 0

**Step:** 0.1

**Help:** From the rolled standard cost of the item.

#### Standard labor per unit

**Key:** std_lab

**Type:** number

**Default:** 7.2

**Min:** 0

**Step:** 0.1

#### Standard overhead per unit

**Key:** std_ovh

**Type:** number

**Default:** 5.4

**Min:** 0

**Step:** 0.1

**Help:** Fixed plus variable overhead absorbed per unit.

#### Actual material per unit

**Key:** act_mat

**Type:** number

**Default:** 19.3

**Min:** 0

**Step:** 0.1

#### Actual labor per unit

**Key:** act_lab

**Type:** number

**Default:** 7.9

**Min:** 0

**Step:** 0.1

#### Actual overhead per unit

**Key:** act_ovh

**Type:** number

**Default:** 5.4

**Min:** 0

**Step:** 0.1

#### Quantity completed

**Key:** qty

**Type:** number

**Default:** 500

**Min:** 0

**Step:** 10

**Unit:** units

#### Prior standard cost per unit

**Key:** prior_std

**Type:** number

**Default:** 30.2

**Min:** 0

**Step:** 0.1

**Help:** Standard before the cost roll.

#### On-hand quantity at roll

**Key:** onhand

**Type:** number

**Default:** 1200

**Min:** 0

**Step:** 10

**Unit:** units

**Outputs:**

#### New standard cost per unit

**Key:** std_total

**Expr:** std_mat + std_lab + std_ovh

**Format:** currency

#### Actual cost per unit

**Key:** act_total

**Expr:** act_mat + act_lab + act_ovh

**Format:** currency

#### Material variance

**Key:** mat_var

**Expr:** (act_mat - std_mat) * qty

**Format:** currency

**Description:** Positive means actual cost was above standard (unfavorable).

#### Labor variance

**Key:** lab_var

**Expr:** (act_lab - std_lab) * qty

**Format:** currency

#### Overhead variance

**Key:** ovh_var

**Expr:** (act_ovh - std_ovh) * qty

**Format:** currency

#### Total job variance

**Key:** job_var

**Expr:** mat_var + lab_var + ovh_var

**Format:** currency

**Primary:** true

**Description:** Total actual less total standard for the quantity completed.

#### Variance as percent of standard

**Key:** var_pct

**Expr:** if(gt(std_total, 0), (act_total - std_total) / std_total * 100, 0)

**Format:** percent

**Primary:** true

#### Inventory revaluation from roll

**Key:** reval

**Expr:** (std_total - prior_std) * onhand

**Format:** currency

**Description:** Positive increases inventory value, negative decreases it.

**Chart:**

#### Total job variance by quantity completed

**Type:** line

**X:** qty

**From:** 0

**To:** 2000

**Steps:** 20

**Series:**

- job_var

**Disclaimer:** Simplified per-unit comparison for planning and training. Your SyteLine variance accounts, overhead absorption and posting rules may split variances differently, so reconcile to your ledger before booking anything.

## Content

**Intro:** After a cost roll, the standard changes and so does the value of everything on the shelf. Then every completed job lands either above or below the new standard. This calculator shows both effects in one place: the variance by cost element and the revaluation of on-hand stock.

**Sections:**

#### How to use the calculator

**Body:** Enter the rolled standard per unit for material, labor and overhead, then the actual cost per unit from a completed job. Set the quantity completed to scale the variance to a job total. To see what a cost roll did to inventory, enter the prior standard and the on-hand quantity at the time of the roll. The chart sweeps the quantity so you can see how a small unit variance becomes a large dollar variance on bigger runs.

#### The formulas behind it

**Body:** Each element variance is actual per unit less standard per unit, multiplied by quantity. Total variance is the sum of the three. A positive result is unfavorable, meaning you spent more than standard. Percent variance divides the unit difference by the new standard cost. Revaluation is the new standard less the prior standard, times the quantity on hand at the roll, which is the gain or loss recognized when inventory is restated. This is a simplified view: price and usage splits, scrap and overhead rate variances need more detail than one per-unit figure.

**Bullets:**

- Material variance = (actual material - standard material) x quantity.
- Revaluation = (new standard - prior standard) x on hand.
- Positive variance is unfavorable.

#### Reading results and common mistakes

**Body:** A persistent material variance usually points at stale purchase prices in the standard or at scrap and yield assumptions. A labor variance suggests routing times that no longer match the floor. Overhead variances are often an absorption issue rather than a spending issue. The most common mistake is rolling costs without reviewing the revaluation first, which surprises finance at period end. Another is comparing one job to a standard that was rolled with outdated routings, which tells you the standard is wrong, not that the floor is.

**Bullets:**

- Review revaluation before posting a new standard.
- Update routings before the roll, not after.
- Investigate variances by element, not only in total.

**Cta:** Netray can pull completed job cost and standard cost data from SyteLine and produce a variance explanation by item, with the query shown so your cost team can verify it.

**Faq:**

#### What is a cost rollup in SyteLine?

**Answer:** A cost rollup calculates an item's standard cost by summing the cost of its components, operations and overhead through the bill of materials and routing. The result becomes the standard against which actual job costs and receipts are compared.

#### Is a positive variance good or bad?

**Answer:** In this calculator a positive variance means actual cost exceeded standard, which is unfavorable. Some reports use the opposite sign convention, so check the sign used in your own ledger accounts before comparing numbers.

#### Why does inventory value change after a cost roll?

**Answer:** Stock is valued at standard cost. When the roll changes the standard, the on-hand quantity is revalued at the new figure, and the difference is posted according to your accounting setup. Review it before committing the new standard.

#### Does this replace the SyteLine variance reports?

**Answer:** No. It is a quick what-if and training tool. Your system reports reflect your posting rules, overhead absorption and price versus usage splits. Use this to understand and sanity check numbers, then reconcile to the official reports.

## Search terms

syteline cost rollup, syteline standard cost variance, standard cost rollup variance calculator, material labor overhead variance, inventory revaluation cost roll, syteline job cost variance, standard cost change impact, manufacturing cost variance calculator

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json