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