Pricing Tab

The Pricing tab is where all prices for this particular stock code are set or displayed.

The stock pricing grid allows setting the selling price of stock for each price level and/or particular customer. This information will be taken across to the job stock grid as stock is added to jobs.

On the Pricing tab you will see in the far right a field called Prices for. Here you can select the different unit measures and the prices in the grid will change to show pricing for each unit measure when multiple unit measures are in use.

As well as this, the stock pricing grid will carry over nominated price breaks if required, so that larger quantities of stock sold to specific price levels (or particular customers that are nominated) will attract calculated price breaks.

The default price calculation methods have probably already been set up in the Stock Pricing options. View and/or change the price calculation method from within this grid.

Price calculation method refers to the method of calculating the selling price for a stock code for a particular price level. There are numerous price calculation methods that Jim2 can use. If applicable, GST is added after the price calculation has been completed.

Stock code ABC has 2 price levels. These are Retail and Wholesale. The method of price calculation for this stock code for the Retail price level is Last COGS (what it cost to buy the stock) + Markup (the percentage to add to the cost). In this example, the last COGS is $50 and the Markup is 100%. The Retail price level selling price would be $100 ($50 + ($50*100%)), plus GST.

In this example the Wholesale price level will calculate at Last COGS + Markup, where the markup is 80%. As such, the selling price is $90 ($50 + ($50*80%)), plus GST.

The available price calculation methods are detailed below. Click down arrow

to reveal the drop down list.

Area

Field

Explanation

Price Options

(top grey area)

Last Cost

This is the last cost price recorded on a finished PO for this stock code. Last cost looks at 3 things: Vendor tab last updated (this needs to be manually updated), Received PO and any stock adjustments and takes the latest date from these 3 and updates Last Cost.

Last COG

This is the last cost price and on-cost/landed cost recorded on a finished purchase order and expense order for this stock.

Max COG

This is the maximum cost price paid for remaining quantities (stock on hand) of this stock code, including on-costs/landed costs.

Avg. Cost

This is the average cost price of remaining quantities (stock on hand).

Avg. COG

This is the average cost price of remaining quantities (stock on hand) of this stock code, including on-costs/landed costs. If there is no quantity on hand, it will pick up the estimated cost from the Vendor tab.

Avg PO COGS

This is strictly the average cost price paid for this stock, including on-costs/landed costs. Jim2 will recalculate this figure each time a purchase order is finished. Vendor price feeds will not affect this pricing.

The Avg PO COGS field will show the average for all purchase orders.

How it relates to the Buying Tab

This is calculated by multiplying each (Qty x Cost) for each Purchase Order, totalling the amount, then dividing it by the total Qty.

List Ex. (or Inc.)

This is a field which can be used to enter a recommended selling price, including or excluding GST. The GST option is dictated by the preferred Calc Tax Total From field in Tools > Options > Stock Pricing.

List Effective (date)

This field has no actual function. However, when stock is imported and there is a change to the List price ex, the date will populate/change to reflect the date it changed.

Price Template

Here, choose from a predefined list of price levels and calculation methods for this stock group. For example, set up a price template for stock which is grouped as paper products, and another one for toner, etc. Price templates can be set up in Tools > Setups > Stock > Price Templates.

Prices for

This displays the unit measure that the pricing fields are based on, ie. the prices are applicable to selling this stock as a UNIT, BOX, DOZ, etc.

Pricing Grid

Price Level

Sets a price level for this price level line, eg. Wholesale, Dealer, Retail, etc.

Note: The price level on the customer record must match a price level on the stock record. Whilst a stock record may have more than one price level, it will pick the one that matches the cardfile price level.

Price Calc Method

The method of setting the prices for this price level, eg. Fixed, Discount, Avg. COGS + Margin, etc.

Note: If there is no stock on hand, both Max and Avg COGS will not work. Jim2 will use Last COGS instead.

Price calculation method	Explanation
Fixed Price	A fixed price which is not altered by new purchase prices, etc.
Last COGS + Markup	The last COGS (cost of goods sold) of the stock, plus a percentage markup. (Markup is the amount by which the cost of a product is increased in order to derive the selling price. For example, a markup of $30 from $70 yields a selling price of $100. Or, stated as a percentage, the markup percentage is 42.9%, calculated as the markup amount divided by the product cost.)
Avg COGS + Markup	The average COGS of the *stock on hand plus a percentage markup.
Max COGS + Markup	The maximum COGS of the *stock on hand plus a percentage markup
Last COGS + Margin	The last COGS of the stock plus a margin. (Margin is sales minus the cost of goods sold. For example, if a product sells for $100 and costs $70 to manufacture, its margin is $30. Or, stated as a percentage, the margin percentage is 30%, calculated as the margin divided by sales.) Last COGS is based on all costs associated with that stock, including stock adjustments, vendor stock feeds, etc.
Avg COGS + Margin	The average COGS of the *stock on hand, plus a margin.
Max COGS + Margin	The maximum COGS of the *stock on hand, plus a margin.
Last PO COGS + Markup	The selling price is cost of goods plus markup, based only on the last actual PO COGS. COGS in this are only based on Cost COGS on the PO.
Last PO COGS + Margin	The selling price is cost of goods plus margin, based only on the last actual PO COGS. COGS in this are only based on Cost COGS on the PO.
List – Discount	The list price minus a percentage amount (which can also be 0, ie. in a retail situation). When selected, this will show on an invoice report.
List – Percent	The list price minus a percentage (which can also be 0, ie. in a retail situation). This will not show on an invoice report.
Est Cost + Markup	The Vendor Tab estimated cost plus a percentage markup.
Est Cost + Margin	The Vendor Tab Estimated Cost plus a percentage margin.
Price Level – Discount	The price level minus a percentage, which can be 0%. This will not show on an invoice report.
Price Level – Percent	The price level minus a percentage, which can be 0%. This will not show on an invoice report.
Specific Customer	Select a specific customer to give them a special price on this stock item.

* Avg COGS is the original price method based on an average cost price of what is in stock, ie. 2 in stock at $100, plus 2 in stock at $80 – Jim2 will work out the average cost to be $90. Avg COGS is affected if you have stock feeds enabled. This means you might buy 3 of a part for $100 each, so the Avg COGS is $100. Then you get a new price feed from a supplier and their price is $150 per unit. The Avg COGS price is adjusted to that new price.

Base PL

Choose to use a different price level to base a discount amount on, for instance.

Tax

The tax rate, eg. G (for GST). This is determine by the tax code entered in the stock header.

Pcnt %

Est Cost + Markup

Price Ex.

Est Cost + Margin

Price Inc.

Avg PO COGS + Markup

Discount Prices in the Grid.

Only one group is explained here, but a total of four can be set up, with different discount levels (%)

>=Qty

Avg PO COGS + Margin

Pcnt %

Price Level – Discount

Price Ex.

Price Level – Percent

Price Inc.

The price including tax for this discounted quantity of stock.

Special Stock covers stock where costs from the supplier will fluctuate. Special stock is also uniquely purchased for a specific job. The cost of goods will be taken across to the job when the stock is added, hence it uses the Exact COGS rather than the Last COGS.

For Special stock, also use Exact Cost + as per below. Once the special stock is selected on a job, the price will be the exact cost of the stock plus the percentage as set up here.

In the Stock tab of the Options screen the default calculate tax on Actual Selling Price would have been chosen. This selection will affect how prices are calculated.

Add each price level code to the grid, and the Cust# of anyone to provide special pricing to.

The pricing entered is based upon the base unit measure. By default, when viewing the Transactions tab in a stock record, it will show the pricing based on the Sell unit. Use the drop down list at the top of the pricing grid to switch between the different unit measures (if applicable), to view the selling price of those.

Within the stock grid objects in Jim2 there is a solid arrowhead arrow symbol

in the top left corner. Clicking this arrow will expand/collapse columns within the stock grid.

To enter prices, click the ellipsis [...] within the Price Inc. field (or Price Ex., depending on how stock pricing has been set up), to access the Calculate Sale Price screen. This can only be performed in Edit mode.

Field	Purpose
Price Level	Select the price level code: Retail, Wholesale, etc. Select the required code, or enter the price level number.
Price Calc Method	The method used for price calculation. Make a choice from the drop down list.
Base PL	Choose to use a different price level to base a discount amount on, for instance.
Tax	The tax type, eg. G for GST.
Pcnt %	Percentage of markup.
Price Ex.	Add the tax free selling price of each unit measure.
Price Inc.	Calculated tax paid selling price of each unit measure.
>= Qty	Add the quantity of the first price break (eg. 10 or greater).
Pcnt %	Percentage of markup.
Price Ex.	Add the tax free selling price of each unit in the first price break.
Price inc.	Calculated tax paid selling price of each unit in the first price break.
>= Qty	Add the quantity of the second price break (eg. 20 or greater).
Pcnt %	Percentage of Markup.
Price Ex.	Add the Tax Free selling price of each unit in the second price break.
Price Inc.	Calculated Tax Paid selling price of each unit in the second price break.
>= Qty	Add the quantity of the third price break (eg. 30 or greater).
Pcnt %	Percentage of markup.
Price Ex.	Add the tax free selling price of each unit in the third price break.
Price inc.	Calculated tax paid selling price of each unit in the third price break.
>= Qty	Add the quantity of the fourth price break (eg. 40 or greater).
Pcnt %	Percentage of markup.
Price Ex.	Add the tax free selling price of each unit in the fourth price break.
Price inc.	Calculated tax paid selling price of each unit in the fourth price break.