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.
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.
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.
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.
Help Pages
In the event that you are faced with a section or option within the system that you are not sure how to operate you can always refer to these help pages. You can jump directly to a specific help page from the system by clicking the “?” icon. Clicking this icon will open a new browser tab with the specific help page per the grid/page/section that you are in. The icon is located at the top right of the window, in front of the minimize, maximize and close window icons. See example image below.
Workflows
This section will contain all workflow diagrams created for the Virtual Office system. The workflow first two diagrams below outline the most commonly used processes within our system. Click the images to enlarge them.
