Product Setup Examples

These tables might help with the task of assigning the various units associated with each product. Although a bit tedious to enter, these are critical to the calculation of correct quantities of product displayed on Blend Tickets, Delivery Tickets, and ultimately on the customer Invoice.

The Ratio Wizard provided when adding or editing a product helps with some of the more difficult ratios (often the Rate to Blend and Blend to Inventory ratios) that are important to successfully calculate product quantities. Selecting OK saves the calculated ratios in the Product information.

Fertilizers

Fertilizers

Dry
Stored in Lbs

Dry
Stored in Tons

Dry
Stored in 50# Bags

Liquid
Stored in Gallons

Inventory Units

Storage Units, Units shown with quantity on the Invoice

Lbs

Tons

Lbs

Gal

Unit Weight

Weight in Lbs of one Inventory Unit

1

2000

1

Density
Ex. 9.8 Lbs/Gal

Package Size

# of Inventory Units in one Package Size container (more applicable for chemicals)

1

.0005

50

1

Package Units

Name of package container (more applicable for chemicals)

Lbs

Lbs

Bag

Gal

Rate/Acre Units

Units used when talking about a per acre rate

Lbs

Lbs

Lbs

Lbs

Blending Units

Metering/Measuring units – how is this measured?

Lbs

Lbs

Lbs

Lbs

Rate/Blending Ratio

# of Rating Units in one Blending Unit

1

1

1

1

Blend to Inventory Ratio

# of Blending Units in one Inventory Unit

1

2000

1

Density

Billing Units

Units in which it is priced – shown on the Invoice with the price

Tons

Tons

Bag

Gal

Billing Divisor

# of Inventory Units in one Billing Unit

2000

1

50

1

Chemicals

Chemicals

Bulk
Stored in Gals

2 x 2.5 Gal Jugs

Bottles So many Ozs

Automatic Blender Stored in Gals

Inventory Units

Storage Units, Units shown with quantity on the Invoice

Gal

Gal

Oz

Gal

Unit Weight

Weight in Lbs of one Inventory Unit

Density
Ex. 9.8 Lbs/Gal

Density
Ex. 9.8 Lbs/Gal

.0625
(1/16)

Density
Ex. 9.8 Lbs/Gal

Package Size

# of Inventory Units in one Package Size container

1

2.5

5*
(Like 5 oz to bottle)

1

Package Units

Name of package container (more applicable for chemicals)

Gal

Jug

Bottle

Gal

Rate/Acre Units

Units used when talking about a per acre rate

Pts*

Qts*

Oz

Gal

Blending Units

Metering/Measuring units – how is this measured?

Gal*

Gal*

Oz

Lbs

Rate/Blending Ratio

# of Rating Units in one Blending Unit

8

4

1

.1020408
1 Gal/9.8 Lbs

Blend to Inventory Ratio

# of Blending Units in one Inventory Unit

1

1

1

Density
Ex. 9.8 Lbs/Gal

Billing Units

Units in which it is priced – shown on the Invoice with the price

Gal

Gal

Oz

Gal

Billing Divisor

# of Inventory Units in one Billing Unit

1

1

1

1

* These settings depend entirely on the specific product.

Seed/Feed

Seed/Feed

60# Bag Show Lbs on Invoice

60# Bag Show Bags on Invoice

Bulk Stored in Lbs

Inventory Units

Storage Units, Units shown with quantity on the Invoice

Lbs

Bag

Lbs

Unit Weight

Weight in Lbs of one Inventory Unit

1

60

1

Package Size

# of Inventory Units in one Package Size container (more applicable for chemicals)

60

1

1

Package Units

Name of package container (more applicable for chemicals)

Bag

Bag

Lbs

Rate/Acre Units

Units used when talking about a per acre rate

Lbs

Lbs

Lbs

Blending Units

Metering/Measuring units – how is this measured?

Lbs

Lbs

Lbs

Rate/Blending Ratio

# of Rating Units in one Blending Unit

1

1

1

Blend to Inventory Ratio

# of Blending Units in one Inventory Unit

Bag

Bag

Lbs

Billing Divisor

# of Inventory Units in one Billing Unit

60

1

1