Custom Inventory & Production System

Problem

At Datebox, we couldn't find an inventory and warehouse management system that served our specific needs, so we built our own.

Solution

Our operations, production and inventory had 3 layers

  1. Components: Raw material inventory

  2. Box Components: (often comprised of multiple components). The items that made up a Datebox

  3. Boxes: finished, assembled, and packed Datebox experience

We needed to track inventory of components, so we knew how many boxes we could build. Box components told us how many of each component would be used, each time we built a certain SKU (Datebox), and finally box inventory, told us how many finished Datebox's of each SKU's were built, and ready to be assigned to users.

Each time we ran a production line for a given SKU, we wanted component inventory to be adjusted automatically, according to what we built, so that we always had a strong sense of component/raw material inventory levels, so that we could effectively manage replenishment timelines and procurement.

Each time an assembly/production line would finish, we would add finished boxes to inventory, and the system would know exactly what raw material components we used to execute that build.

More by Brett Kolomyjec

View profile