In food manufacturing it is common for brands to have the actual manufacturing done by contract manufacturersknown as “co-packers.”
You order and pay for the raw materials, often having them shipped directly to the co-packer, and then place an order for a set amount of finished goods (which may or may not use up all of these raw materials).
On the positive side, working with a co-packer eliminates the need to build and run your own manufacturing facility. But this does not come without cost, as it forces you to give up a certain amount of visibility and control, which can make planning difficult.
Luckily there is a solution: Set things up so that you are paralleling your co-packer’s inventory levels and production inside your own Fishbowl installation. This way you can easily see what raw materials the co-packer is storing on your behalf, your scrap rates, your finished goods inventory, and more. This visibility not only gives you the data you need for planning purposes, it also creates accountability.
Here’s how to use Fishbowl to monitor co-packers and other contract manufacturers
Set Up Your Fishbowl Inventory File
Create all of the following:
A part representing the service the co-packer is going to perform (I recommend that you use the “Non-Inventory” part type)
Raw material parts that you will be supplying to the co-packer
Finished product partsfor each part that the co-packer will be producing
Bill of Materials defining the materials and services that will be consumed to create the finished product
A location group for the co-packer (keeping in mind that in Fishbowl terminology a “location group” can refer to a single location, such as a co-packer’s facility or a physical warehouse)
Manage Your Raw Materials
In a co-packer environment you are typically purchasing materials and having them shipped to the co-packer. To track and manage this you need to:
Create a Purchase Order in Fishbowl to order the items from your raw materials vendor; Use the co-packer’s address as the “ship to” address.
Create a processthat uses the co-packer’s signed-off report of the items and quantity received to receiveraw materials against this Purchase Order in Fishbowl. This internal control step is important because you don’t really know if your vendor sent the right items and quantity to your co-packer. You want your co-packer to sign off on it—and it’s in their best interest to do so, because they don’t want to be held responsible for “losing” materials that never actually arrived.
Resolve discrepancies between your vendor’s ship notice and your co-packer’s received count. This task usually falls to the Accounts Payable clerk.
Reconcile the billfollowing your normal Accounts Payable procedures.
Manage Your Purchases From Your Co-Packer
In creating the finished product, the following tasks do not have to be done in this exact sequence, but all have to be done:
Create and issue a Purchase Order in Fishbowl to the co-packer for the service that the co-packer is providing.
Create and issue a Manufacturing/Work Order in Fishbowl for the finished product, just like you would if you were making the product yourself.
When the co-packer notifies you of completion, receive the quantity completed against the co-packer Purchase Order in Fishbowl.
Fulfill the Manufacturing/Work Order in Fishbowl to consume raw materials inventory, put the finished product into stock and roll up the costs of the inputs to the finished product.
Need Help with Your Fishbowl implementation?
Not sure about the right way to do things in the Fishbowl/QuickBooks world? Wondering if something that can’t be done in QuickBooks can be done in Fishbowl? Give us a call! As Fishbowl Inventory Super Heroes, we’re here for you.
TaraByte Solutions has been providing expert QuickBooks consulting and accounting services to small and mid-market firms since 2001. Our focus is the selection, sale and implementation of inventory solutions. Join the many retail, wholesale, manufacturing and e-commerce businesses that count on us for scalable best-of-breed applications.
Toll Free North America: (888) 745-1533 Worldwide: (949) 645-1019