Price variance of Product Groups

Modified on Tue, 05 Mar 2024 at 08:35 PM

How to calculate the Price variance of different product groups?

PORate is the rate of the product in the purchase order, BillRate is the rate of the product in the bill and GRNQuantity is the product quantity in the goods received note.

UDDC Name : Price Variance

UDDC Formula : ((PORate - BillRate)* GRNQty) 

Price variance is calculated by dividing the goods receipt note quantity from the difference of purchase rate and bill rate.

e.g: PO Rate = 27500, Bill Rate = 25000 and GRN Qty = 2. Therefore the price variance is 1,250.

Price variance PORate Bill Rate GRN Qty UDDC Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article