Difference between revisions of "Average Price Calculation"

From Agility
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
[[Category:Inventory]]
 +
[[Category:Prices]]
 +
 +
The '''Average Price''' is a calculated measurement of the average of a range of prices paid for goods or services.
 +
In Agility the average price is calculated by taking the sum of the values and dividing it by the number of prices being examined.
 +
 
The '''Average Price''' calculation depending on the system parameter '''''AverageCalculationMode'''''.
 
The '''Average Price''' calculation depending on the system parameter '''''AverageCalculationMode'''''.
−
An average price is a representative measure of a range of prices that is calculated by taking the sum of the values and dividing it by the number of prices being examined.
+
Format of that parameter is "''[AlsoReturns] <unsgined integer> m|months|y|years|w|weeks|d|days''" .
 +
 
 +
For example "''AlsoReturns 5 m''" means calculate AveragePrice basing on Goods Receipts and Return To Supplier in last 5 monts.
 +
 
 +
If it is empty, system calculates '''Average Price''' after saving all Goods Receipts and Return To Supplier and take for account all these historical movements.
 +
To calculation Agility uses:
 +
 
 +
For Goods Receipts:
 +
'''AveragePrice = (ActualStoredGoodValue + ReceivedGoodValue)/(ActualStoreQuantity + ReceivedGoodQuantity)'''
 +
 
 +
For Return To Supplier:
 +
'''AveragePrice = (ActualStoredGoodValue - ReturnedGoodValue)/(ActualStoreQuantity + ReturnedGoodQuantity)'''
 +
 
 +
 
 +
 
 +
'''NOTE:'''
 +
 
 +
1. Goods Receipts and Return To Supplier generated for "''Direct Purchase''" also is taken into accout.
 +
 
 +
2. Depending on system parameter ''AverageCalculationMode'' the value of:
 +
 
 +
      ''ActualStoredGoodValue'' is sum of Values from Goods Receipts and Return To Supplier(if ''AlsoReturn'' is set) in set period.
 +
      ''ActualStoreQuantity''  is sum of Quantities from Goods Receipts and Return To Supplier(if ''AlsoReturn'' is set) in set period.
 +
 
 +
'''Example for empty parameter:'''
 +
[[File:AveragePriceCalc.png|1000px]]
  
−
Read more: Average Price Definition | Investopedia http://www.investopedia.com/terms/a/averageprice.asp#ixzz4MyWm08vv
+
'''Example for particular situation:'''
−
Follow us: Investopedia on Facebook
+
[[File:AveragePriceCalcDiv.png|1000px]]
  
−
If it is empty, system calculates '''Average Price''' after saving all receipts and returns. Agility  Format of that parameter is [AlsoReturns] <unsgined integer> m|months|y|years|w|weeks|d|days . For example "AlsoReturns 5 m" means calculate AveragePrice basing on Goods Receipts and Return To Supplier in last 5 monts
+
'''NOTE:'''
 +
'''For showed situation system leave price unchanged and after next Goods Receipt set price using price from this new document.'''

Latest revision as of 12:06, 14 October 2016


The Average Price is a calculated measurement of the average of a range of prices paid for goods or services. In Agility the average price is calculated by taking the sum of the values and dividing it by the number of prices being examined.

The Average Price calculation depending on the system parameter AverageCalculationMode. Format of that parameter is "[AlsoReturns] <unsgined integer> m|months|y|years|w|weeks|d|days" .

For example "AlsoReturns 5 m" means calculate AveragePrice basing on Goods Receipts and Return To Supplier in last 5 monts.

If it is empty, system calculates Average Price after saving all Goods Receipts and Return To Supplier and take for account all these historical movements. To calculation Agility uses:

For Goods Receipts: AveragePrice = (ActualStoredGoodValue + ReceivedGoodValue)/(ActualStoreQuantity + ReceivedGoodQuantity)

For Return To Supplier: AveragePrice = (ActualStoredGoodValue - ReturnedGoodValue)/(ActualStoreQuantity + ReturnedGoodQuantity)


NOTE:

1. Goods Receipts and Return To Supplier generated for "Direct Purchase" also is taken into accout.

2. Depending on system parameter AverageCalculationMode the value of: 

      ActualStoredGoodValue is sum of Values from Goods Receipts and Return To Supplier(if AlsoReturn is set) in set period.
      ActualStoreQuantity  is sum of Quantities from Goods Receipts and Return To Supplier(if AlsoReturn is set) in set period.

Example for empty parameter: AveragePriceCalc.png

Example for particular situation: AveragePriceCalcDiv.png

NOTE: For showed situation system leave price unchanged and after next Goods Receipt set price using price from this new document.

Retrieved from "http://agilitywiki.northeurope.cloudapp.azure.com/agilitywiki/index.php?title=Average_Price_Calculation&oldid=928"