Purchase price

Purchase price

Revision History

The Stock item purchase price is an average price at which a stock item is accepted in the stores according to the stock-in records over a certain period of time. Other stock documents are not taken into consideration when calculating the purchase price.

The stock item purchase price is recalculated automatically based on the quantity of stock items received in the stores of the selected store group according to the stock-in records over the selected period of time. The recalculation interval is specified in the Store groups directory. This interval is specified in days counted back from current date. If the stock-in record does not fall within this interval, its data will not be taken into account when calculating the purchase price.

Example 1 Purchase price calculation for the stock item

The stock item Carrots was added to stock using the following stock-in records:

  • stock-in record dated 30.10.2013 (3.5 kg was added to stock at the price of £2.00),

  • stock-in record dated 01.11.2013 (8 kg was added to stock at the price of £2.25),

  • stock-in record dated 08.11.2013 (5 kg was added to stock at the price of £2.50),

  • stock-in record dated 11.11.2013 (7.5 kg was added to stock at the price of £2.40).

The calculation determined the purchase price of the remaining carrots.

Purchase price = (3.5*2.00+8*2.25+5*2.50+7.5*2.40)/24

This resulted in the purchase price of 1 kg of carrots being £2.31 for the stock on hand on the date of the calculation.

The purchase price calculation is performed by the system task Purchase price calculation .

To carry out the purchase price calculation, you need to:

  • in the segment, set the Purchase price recalculation attribute to Yes.

  • in the store group, set the Recalculate attribute to Active, specify the duration of the period, for which stock-in records must be selected, and define the interval between the launches of the Purchase price calculation task.

The Purchase price operational report displays information about stock item purchase prices by store groups. The operational report contains only the stock items for which the purchase price has been calculated or specified manually.

Purchase prices are presented in the report viewing window based on the quantities of stock items expressed in their basic units of measurement. The window also displays purchase prices for all remaining units of measurement of the same group (calculated using recalculation ratios).

Stock item purchase prices are used to calculate own cost of the menu items associated with these stock items.

The operational report can be generated by store group or by stock item. The viewing windows are, respectively: