Simplifying the Formulas For Consuming Bulk Vs. Raw Materials

Reading Time: 4 minutes


[fusion_builder_container hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” border_style=”solid” padding_top=”20px” padding_bottom=”20px”][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ spacing=”” center_content=”no” hover_type=”none” link=”” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_position=”left top” background_repeat=”no-repeat” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” padding=”” dimension_margin=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”no”][fusion_text]

New software can simplify formula stages through:

  • the ability to combine both processing steps of a formula into one, contained formula ID
  • reduced clutter from extra formulas
  • streamlined production scheduling
  • compliance document generation

How It Works

For many process manufacturers, it’s not uncommon to have multiple processing stages needed in order to arrive at the final item(s).  A typical scenario is to first consume raw materials to create WIP, or bulk, which might reside in a container for a period of time.  Then, when it is time to produce the finished goods, the WIP, or bulk, that has been sitting in the container, is then used to make the finished products.

Some manufacturing systems will require each of these steps to be assigned to a different formula ID, despite there being many other shared data elements such as quality control, safety information or other relevant data needed for compliance.

Vicinity Manufacturing software offers a way to support this process through the use of a Mix Procedure and a Fill Procedure that is enabled with all formulas.

In this example, we’ll use formula DC-VMRED.


Once the header record information is set, users can identify the necessary information for both a Mix and/or Fill procedure.

As seen below, the Mix procedure would include a combination of raw materials.


In addition, users can toggle to the Fill procedure and assign different materials.

It’s important to note that there would not be a limit to the number of ingredients, and no limit to the inclusion of instructions.

Easy Component Set-Up

In terms of component set-up, users can assign a default formula source (Mix/Fill) to produce the product.  In the two examples shown, the item DC-VMRED is typically made using the Mix process and DC-FG02 is typically completed using the Fill process.  However, since they are linked to the main formula ID, this does not prevent the users from using a Mix formula to produce item DC-FG02…



When it is time to schedule production, the scheduling manager only needs to know just the one formula ID versus having to assess which formula ID produces the bulk and which consumes the bulk.

Despite the presence of two different processing options for the formula, there are other characteristics of the formula that can be maintained which might not vary based on the mix or the fill.

These attributes would apply regardless of the Mix/Fill and can be used to:

Reference when performing a search of all formulas, meet label requirements, or generate compliance documents (such as a GHS compliant SDS or Product Specification Sheet).

Having the ability to combine both processing steps of a formula into one,contained formula ID greatly reduces the added clutter of extra formulas while also simplifying production scheduling and compliance document generation.


For questions on this software or its implementation, please contact me at


This publication contains general information only and Sikich is not, by means of this publication, rendering accounting, business, financial, investment, legal, tax, or any other professional advice or services. This publication is not a substitute for such professional advice or services, nor should you use it as a basis for any decision, action or omission that may affect you or your business. Before making any decision, taking any action or omitting an action that may affect you or your business, you should consult a qualified professional advisor. In addition, this publication may contain certain content generated by an artificial intelligence (AI) language model. You acknowledge that Sikich shall not be responsible for any loss sustained by you or any person who relies on this publication.


Join 14,000+ business executives and decision makers

Upcoming Events

Upcoming Events

Latest Insights

About The Author