Equitable Software

General Information

general Information

This section will contain general information about Virtual Office, including calculations, process operations and acronyms. This page is a work-in-progress and will be continually updated with new information. Please click the links at the top of the page to quickly access each section.

Acronyms

Calculations

Grid Sorting

 

 

Calculations

How is Bonded Amount on a quote calculated?:

The bonded amount in a quote is the amount that will be used to calculate the total amount needed of an ingredient for a BPR.

Here is an example of how the bonded amount is calculated.

Elemental Amount: 31.68MG
Assay Percentage: 90%
LOD Percentage: 10%
Intentional Overage: 10%

Calculation is as follows:

1. The Assay% is subtracted by the LOD. (90-10) = 80%
2. 100 is divided by the resulting Assay%. (100 / 80) = 1.25
3. To find the initial bonded amount the results from number 2 are multiplied by the Elemental Amount (1.25 * 31.68) = 39.60MG
4. Then the Intentional Overage is converted to a decimal and one is added to ensure the percentage amount is added to the elemental amount. (10 / 100) +1 = 1.1
5. Finally the resulting bonded amount is multiplied by the Intentional Overage Percentage. 1.1* 39.60 = 43.56MG

 

How are Case Type components calculated?

Case type components are typically items that are inserted inside a master case. An example of a Case Type could be a display box that holds 4 bottles. Case types that are required for an order are calculated by dividing the container count by the “Containers Per Case Type”. This may not be labeled the same in your system as this item can be modified during your initial Virtual Office setup process. It will always be the first input box down from the dropdown for “MFG/EXP Type” on a quote.

Example:

Container Count: 10,000
Containers Per Case Type: 6
Applied Formula: 10,000 / 6 = 1,667 (rounded up)

 

How are Master Case Type components calculated?

Master Case type components are typically items that are inserted inside a master case. Master Case types that are required for an order are calculated by dividing the Container Count by the “Containers Per Case Type”. Then divide the quotient by the “Case Type Per Master Case”. This may not be labeled the same in your system as this item can be modified during your initial Virtual Office setup process. It will always be the second input box down from the dropdown for “MFG/EXP Type” on a quote.

Example:

Container Count: 10,000
Containers Per Case Type: 6
Case Type Per Master Case: 12
Applied Formula: (10,000 / 6) / 12 = 139 (rounded up)

 

How are Pallet Label components calculated? (May not be applicable)

Pallet Label components are typically labels that are attached to a pallet. Pallet Labels that are required for an order are calculated by dividing the Container Count by the “Containers Per Case Type”. Then divide the quotient by the “Case Type Per Master Case”. Then divide the quotient by the “Master Cases Per Pallet”. This may not be labeled the same in your system as this item can be modified during your initial Virtual Office setup process. it will always be the third input box down from the dropdown for “MFG/EXP Type” on a quote.

Example:

Container Count: 10,000
Containers Per Case Type: 6
Case Type Per Master Case: 12
Master Cases Per Pallet:135
Applied Formula: ((10,000 / 6) / 12) / 135 = 2 (rounded up)

 

How is Brix amount calculated?

Bonded amounts need to be converted to the same units BEFORE proceeding with the formula. Once units have been converted to a similar base take the total bonded amount (sum of all ingredients) and divide that by the final brix percentage of gummy (this percentage will also need to be converted before dividing).

If the total bonded amount is less than the final brix amount it will turn red.

 

Acronyms

BPR = Batch Production Record
ETA = Estimated Time of Arrival
PR = Production Record
MMR = Master Manufacturing Record
PO = Purchase Order
LPN = License Plate Number
QA = Quality Assurance

 

Grid Sorting Options

There are several ways in which you can sort the grid in order to find specific results fast. If you know the name of the item you are searching for then using the Search Box will be your best bet.

You can also sort grid results by clicking the Column Titles. In doing so you will change the sort results per the column from high to low; click again to sort the opposite. See example image below.

 

Grid Sorting

 

 

Column Visibility

Column Visibility will allow you to toggle on/off columns on the grid. Start by clicking the Column Visibility action button located above the grid. In the next window you will select columns to hide/show from the grid. Column buttons that are blue are visible on the grid and Column buttons that are gray will be hidden. See example image below.

 

Column Visibility

 

Please note that the columns you decide to hide will remain hidden until you re-select them for visibility. This setting is stored/saved per the browser used while selecting Column Visibility.

 

Grid Nesting

In the event you are using the website with a small monitor or lower resolution the grid will nest column elements into each row. This is indicated by a green plus icon at the furthest left point on each row. Click the plus icon to reveal the additional columns and their info. See example image below. We recommend using the website with a minimum monitor size of 20″ with a 1920 x 1080 resolution.

Grid nesting will sometimes be available regardless of screen size and in this event the grid nesting will contain/display for information.

Grid Nesting