Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Basis Pricing is used to calculate an item price based on other items.

This is most commonly used to price feed for sale. A feed item is based on a formula with multiple ingredient items. Each ingredient item has a quantity needed to produce the feed.

A simple example of a feed formula is below

FeedM0527PKL BR GR PELL CONV-4UnitsPack
Ingr. 151010CORN575575
Ingr. 253010CALCIUM250250
Ingr. 353040BLENDED FAT170170
Ingr. 40000172Vitamin D55


Totals10001000

For Basis Pricing we use Formulas configured in ERP Work Orders.

We then set a basis price for each ingredient item using Price Basis Cost. The basis price can be set manually or derived from the ingredient item cost in ERP Inventory.

Once the ingredient items are priced the Formula Price can be calculated. The calculated basis formula item price can then be used as a starting price on a customer pricing template.

The above is a simplified explanation of Basis Pricing. It does not include details like a formula can have multiple effective dates, a formula can have multiple markups, a formula can have a formula as an ingredient, basis pricing for ingredients are also based on effective dates and grouped by a price basis code. These addition configurations allow Basis Pricing to incorporate the business rules for our clients.

Pre-Requisites

  1. Items Masters
  2. Formulas
  3. Customers

Setup Steps

  1. Price Basis Codes
  2. Price Basis Costs
  3. Formula Price Calculations
  4. Formula Price Input
  5. Template Manager


Price Basis Codes

Master > Pricing > Price Basis Codes


Price Basis codes allow the client to setup multiple prices for the same ingredient item.


There are two Types: Inventory and Standard


Inventory type gets cost from the ingredient items current available inventory. The software calculates a weighted average price for the ingredient item.


Standard allows the client enter a standard cos

Each Price Basis Code has it's own list of valid items.


Price Basis items can be both ingredient and formula items


If the Price Basis item is a formula item a Formula Markup can be specified.


Price Basis Costs

Master > Pricing > Price Basis Costs

Create New Price Basis Costs (new effective date)

Click Add button 

Choose Price Basis Code

Select Effective Date

Click Okay

This screen is used to either enter Costs for each item or calculate costs from available inventory.


Before you can calculate the inventory cost you must select the division to use.


Click the Divisions tab


Select the desired Division(s)


Click the Calculate button

You will be prompted that items configured as Inventory costs will be replaced

Click the OK button

Costs will be calculated using the current inventory values



Click the Items Tab to see the calculated Cost for each item

The client can now use these prices as is or manually adjust a price. 

If a price is changed the Fixed checkbox will be set by the software.


Click Save button

Click the Report button to see a proof report of the Price Basis Costs


Note: I change the price for item 0000173 from .99 to 1.00


View or Modify Existing Price Basis Costs

Click ellipsis button to the right of the Basis to view the Price Basis Cost search form.

Choose Basis code and click Retrieve button.

Select the Price Basis Costs for the desired Effective Date.


Click Ok to Proceed

You now have several options

  • View the costs

  • Add division on Division tab

  • Re-Calculate the costs as of this moments available inventory

  • Manually change a calculated cost

  • Print the proof Report 

  • Delete the costs for this effective date

One addition option is Copy


Click the Copy button

Choose the Price Basis code

Select a new Effective Date

The current Price Basis Costs will be copied to the selected Price Basis Code and Effective Date.


Formula Price Calculations

Work Orders > Utilities > Formula Price Calculation







  • No labels