# Oracle EBS Average Cost After Receipt and PPV Calculator

> Source: https://netray.co/tools/oracle-ebs-average-cost-receipt-and-ppv-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

See how a PO receipt moves weighted average cost, and what the same receipt would book as PPV under standard costing.

## Category

oracle

## Erp

Oracle E-Business Suite

## Industry

Discrete Manufacturing

## Audience

- EBS cost accountant
- EBS inventory analyst
- Buyer

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### On hand quantity before receipt

**Key:** on_hand

**Type:** number

**Default:** 500

**Min:** 0

**Step:** 10

**Unit:** units

#### Current average unit cost

**Key:** avg_cost

**Type:** number

**Default:** 12.4

**Min:** 0

**Step:** 0.01

**Unit:** $

#### Receipt quantity

**Key:** rcv_qty

**Type:** number

**Default:** 200

**Min:** 0

**Step:** 10

**Unit:** units

#### PO unit price

**Key:** po_price

**Type:** slider

**Default:** 13.1

**Min:** 8

**Max:** 18

**Step:** 0.1

**Unit:** $

#### Standard unit cost (if standard costing)

**Key:** std_cost

**Type:** number

**Default:** 12.5

**Min:** 0

**Step:** 0.01

**Unit:** $

#### Quantity issued after receipt

**Key:** issue_qty

**Type:** number

**Default:** 300

**Min:** 0

**Step:** 10

**Unit:** units

**Outputs:**

#### Inventory value before receipt

**Key:** old_value

**Expr:** on_hand * avg_cost

**Format:** currency

#### New average unit cost

**Key:** new_avg

**Expr:** (on_hand * avg_cost + rcv_qty * po_price) / (on_hand + rcv_qty)

**Format:** decimal

**Primary:** true

**Description:** Weighted average of existing value and receipt value.

#### Inventory value after receipt

**Key:** new_value

**Expr:** on_hand * avg_cost + rcv_qty * po_price

**Format:** currency

#### Change in average cost

**Key:** cost_shift

**Expr:** new_avg - avg_cost

**Format:** decimal

#### Value of the issue at new average

**Key:** issue_value

**Expr:** issue_qty * new_avg

**Format:** currency

**Description:** What the issue relieves from inventory at the new average.

#### PPV if standard costed

**Key:** ppv

**Expr:** (po_price - std_cost) * rcv_qty

**Format:** currency

**Primary:** true

**Description:** Positive is unfavorable (price above standard); it is a debit to the PPV account.

**Chart:**

#### New average cost vs PO price

**Type:** line

**X:** po_price

**From:** 8

**To:** 18

**Steps:** 30

**Series:**

- new_avg

**Disclaimer:** Weighted average arithmetic for a single receipt with positive on hand. Negative on hand quantity, cost updates, invoice price variance and landed cost adjustments are not modelled.

## Content

**Intro:** Whether your organization uses average or standard costing changes what a PO receipt does to the books. Under average costing the receipt changes the item cost, under standard costing the difference goes to purchase price variance. This tool shows both outcomes for the same receipt.

**Sections:**

#### How to use it

**Body:** Enter the quantity and average cost on hand before the receipt, the quantity received and the PO unit price. If the item is also costed at a standard in another organization, enter that standard to see the PPV. The calculator returns the new average cost, the value of inventory after the receipt, and the value of an issue made at the new average. The chart sweeps the PO price so you can see how much a price spike moves your average.

**Bullets:**

- Use the receipt quantity in the primary UOM
- Enter the PO price converted to the item's primary UOM
- Check the Inventory Value Report after posting to confirm

#### The formulas

**Body:** Average costing: new average cost equals (on hand quantity times current average plus receipt quantity times receipt price) divided by (on hand quantity plus receipt quantity). The result is a weighted average and it moves less when on hand is large compared with the receipt. Standard costing: PPV equals (PO price minus standard cost) times receipt quantity. A positive number means the purchase was more expensive than the standard and is booked as unfavorable variance. Oracle Cost Management books the receipt at standard to inventory and the difference to the PPV account.

#### Worked example

**Body:** With 500 units at 12.40 on hand and a receipt of 200 at 13.10, existing value is 6,200 and the receipt is 2,620. The combined value of 8,820 over 700 units gives a new average of 12.60, up 0.20. Issuing 300 units at the new average relieves 3,780. If the same item were standard costed at 12.50, the receipt would carry a PPV of 0.60 times 200, or 120 dollars unfavorable. The same purchase therefore shows up in two different places in the two costing methods.

#### Common mistakes

**Body:** Issuing before receiving and driving on hand negative produces odd average results, so check for negative balances first. Forgetting the unit of measure conversion between the PO and the item also gives wildly wrong costs. Remember that invoice price differences between PO and invoice create further adjustments, and that landed cost or freight, if not included in the receipt, will not be in this number. When prices swing, review the cost trend by item before month end close.

**Cta:** If you want an exception list of items whose average cost or PPV moved beyond a threshold, Netray can build it read-only over your EBS cost data.

**Faq:**

#### Does a receipt always change average cost?

**Answer:** Under average costing, yes, whenever the receipt price differs from the current average. If the price equals the average, the cost stays the same. The size of the move depends on the receipt size relative to on hand.

#### What happens if on hand is negative?

**Answer:** The average cost logic differs when a receipt arrives against a negative balance, and results will not match this simple formula. Resolve negative on hand before judging the cost movement.

#### Is PPV favorable or unfavorable when positive?

**Answer:** In this tool a positive PPV means the PO price was above standard, which is unfavorable and a debit. Negative means the price came in under standard. Check the sign convention in your own reports.

#### Does this include freight and duties?

**Answer:** No. Only the PO unit price is used. If your process adds freight, duty or other landed cost into the receipt or via adjustments, add it to the price per unit before entering.

## Search terms

oracle ebs average cost calculation, oracle weighted average cost receipt, purchase price variance oracle ebs, ppv calculation standard cost, oracle average costing new cost after receipt, inventory average cost calculator

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