How to Include Employee Costs in BOMs

May 6, 2016 at 3:02 PMThomas Riemann

Hello everyone. Welcome back to the NumberCruncher Blog. As most of you know, My name is Tom and I am the trainer/support tech here at NumberCruncher. If you need to learn how to do something in the All Order's software, I'm your guy! Remember, if you are struggling with something in the All Order's software, please give us a call @ 866-278-6243. We can set up a training session with you and your company remotely. So make sure you build up those questions and give us a call to set up your session today! That's not what brings me to the blog today. What I would like to talk about today is something that customers ask about all the time, "How do I include employee Costs in BOM's." So sit back and enjoy the read!

Our first step is to create an item that we can put into a BOM. We're going to create a new item called "Labor" (or whatever you would like). This item should either be a non-inventory part, service or other charge group. If you are creating this item in QuickBooks, check the "This service is performed by a Sub-contractor, owner or partner." Next, go to the purchasing tab, enter the cost. The cost should estimate the hourly wages and benefits. Of course, we're going to need to select an income account and an expense account. For income, you can select any of them. For the expense account, create a new account Called "Salaries Applies to Finished Goods". Save and close this item.

Now it is time to include this newly created item in the appropriate Bill of Materials. Go to a finished good item and edit the BOM's. Simply add this item to the component lists. Save and close. Now we can start using this finished good on a work order that will include this new Labor Item's cost.

When you finish a production, the labor cost will be deducted from Salaries Applied to Finished Goods expense and included in the cost of your finished product. Now if the salaries account is greater than the Salaries Applied to Finished Goods, this means that a) you have processed payroll but have not yet finished the product or b) the Cost amount on the item is too low. If the Salaries account is less than the Salaries Applied to Finished Goods this means that either a) you have finished product but have not yet processed payroll or b) the "Cost" amount on the item is too high.

Well, I hope this has cleared any confusion you might have with creating Employee Costs in BOM's. If you still have some question's, place a comment below, and I will answer your question directly. You can also send us an email Support. It's Friday! Take some time to yourself this weekend and get ready for Monday! Enjoy!

 

TOM

All Order's Add ons

April 8, 2016 at 3:18 PMThomas Riemann

Welcome back to the NumberCruncher blog! I hope everyone is have a great week! Today I would like to talk about an add on to the All Order's software called All Order Mobile. All Order's mobile extends inventory management into your warehouse. This will allow you to increase your efficiency in the warehouse by decreasing mistakes made. All Orders Mobile by NumberCruncher extends inventory management into your warehouse and lets you take full advantage of barcode label printing within All Orders. To me, this add on really makes our inventory system the best inventory software on the market. Just a little bit of background on myself. I use to manage a warehouse. When I was in that field, we didn't have any bar code scanning or a real time inventory management system like All Orders. Which made my job much more difficult. Adding bar coding to your company will save a lot of headaches going forward. Imagine doing your inventory count's on a hand held device, scanning instead of physically counting. I would of gave anything for this system! Now let's talk about All Orders Mobile.

All Orders Mobile by NumberCruncher will make your warehouse operations more efficient! All Orders Mobile is installed on Windows based devices. It can connect wirelessly to your All Orders database and download sales orders to be picked, purchase orders to be received and counts. Once a sales order is picked the picking information will be uploaded in real time back to the All Orders database an automatically create a Ship Doc. Similarly, once a purchase order is received through All Orders Mobile, the information will be uploaded to All Orders and a Reciever will automatically be created. Finally, All Orders Mobile will update your count in All Orders with new quantities.

  • Pick Sales Orders
  • Receive Purchase Orders
  • Perform Inventory Counts
  • Find Location/Bins of Inventory
  • Move Bins
  • Adjust Inventory
  • Transfer inventory.

Check out our Intro video on All Orders Mobile by clicking here. We also have more video tutorial's showing how to perform a Sales Order, Receiving a Purchase Order and performing an inventory count.

Well that is all for today! I hope everyone has a great weekend! Make sure to contact us if you have and Questions. support@numbercruncher.com or call us @ 866-278-6243.

What is a Consignment? How do I ship out item's?

February 19, 2016 at 3:50 PMThomas Riemann

Hello, and welcome back to the NumberCruncher Blog! Hope all of you are doing well and you business is thriving! Today I would like to talk about a feature in All Order's called Consignments. You might be asking yourself "What is a Consignment?" Consignment is the act of consigning, the act of giving over to another person or agent's charge, custody or care any material or goods but retaining legal ownership until the material or goods are sold. 

We have a perfect feature in our system for this. To start a new consignment, go to Sales - New Consignment. But lets not get ahead of ourselves. Before we get that started, you will want to make sure you set up the default location for the specific customer. You can do that by going to the customer screen, clicking the Shipping Info tab, and selecting that default location. You will want to make sure you set that location to the location where your quantity is. The reason why you have to set that up before is because only those customers with the default location set will appear in the drop down. Ok, back to the consignment. Once you add a customer and a location, all the items in that location will populate. You can use the filter tab to filter for a specific item on the list. This is where you will be able to pick and choose what item to send and how much QTY to send. You will enter this info under the ship doc column. Once you have selected that information, we can go ahead and go to Activities - Finalize. Now a Ship Doc will be created for that customer for those items. Next week, I will talk about how to get those item's that didn't sell back from that customer. Stay tuned!

Well, that is all for today. I hope you guy's have a great weekend! Remember if you have any questions, head over to our website. As always you can always e-mail customer support at support@numbercruncher.com or call us (866) 278-6243.

All Orders!

January 22, 2016 at 10:44 AMThomas Riemann

Welcome back! Hope everyone had a great week! I know some of you guy's that live up north are getting hammered with some pretty intense snow. I feel your pain, I was born and raised is South New Jersey so I know how a snow storm's can destroy a mood. I guess since you guy's will be snowed in all weekend, you might want some good reading material. Well, recently in the past 2 weeks, All Orders has been featured on http://www.intuitiveaccountant.com. They have written a great article about the All Orders program that I would love for you guy's to check out.

That isn't all, All Orders is now on appcenter.intuit.com. Click the link to see an over view of the All Orders program and how it works with Quickbooks. Take a look at our pricing, as you can see we offer training hours based off how many user's. We also include unlimited technical support and software upgrades. To find out more about our program please visit us, NumberCruncher.

Well that is all for today's blog. Make sure you check out those links so you can read up on all our key features! Next week, I will be back talking about some of our smaller features within the All Orders software. Get ready to learn about Lot/Serial #'s on Next weeks Blog! Everyone, if you are getting hit with snowy weather, please be safe out there!. Till Next week! Farewell!

 

Bins

December 24, 2015 at 8:48 AMThomas Riemann

 

Hey guy's! Welcome to the NumberCruncher Blog, Thursday Edition! Firstly, Happy Holidays from NumberCruncher team! We hope you and your employees have a great holiday weekend and spend some quality time with your families! Now, in my past 2 blogs we focused on Locations. Now we are going to focus on features within the locations, Bins.

Within the all orders program, we have a unique feature called Bins. This allows you to create a location within locations, allowing you to easily pinpoint the location of the item. If you have a huge warehouse with multiple aisles of product, this would be a key feature for you. A bin does not have to be a physical bin. A bin can be any place of storage, from an actual bin to a shelf or a crate.

For each item that is a Part or an Assembly you can specify a default bin.

When you add items to inventory (Receiving Purchase orders, completing a Work Order) the qty will automatically go into the designated bin. If you leave this area blank, it will go into the default bin. You can change which bin an item is either added to or pulled from on any transaction. You can also split qty between multiple bins in the same location. From the line item of a transaction, click details icon then click bins. Click in any column to enter in the desired bin, and then enter the quantity.

On a transaction where the qty is being decreased aka ship doc and you are not sure which bin the product is on you can click “get available” that will bring up a dialog box.

The bin feature is very useful for your warehouse staff, so make sure you take advantage of the easy to use feature within All Orders. Well, I hope you have learned something from this blog post and again I hope your company can run a little bit smoother. As I always mention, make sure you check out all our support tutorials. Remember if you have any questions or concern's the NumberCruncher is here for you. Please give our customer support line a call - (866) 278-6243. You can send us an email also - support@numbercruncher.com. Hope everyone has a safe and wonderful holiday!

Creating a New Quantity Adjustment

December 2, 2015 at 11:51 AMThomas Riemann

Hey Guys! Welcome back to the NumberCruncher Blog!!! It's Tom from the NumberCruncher team again! Last Friday we talked about how to "Perform Inventory Counts" within the All Orders program. If you are struggling doing inventory, go check that link out and read our last blog post. Maybe that's not what your looking for, maybe your company doesn't need help doing inventory counts. You might just need to Adjust some Inventory due to a trade show where you gave away some Inventory as prizes. Or your company had a fire and due to that fire some inventory was lost in the process. The perfect tool for this in All Orders is called an "Adjustment".

To start a New Quantity Adjustment, you can do 1 of 2 things, Warehouse – New Qty Adjustment or from the company home screen select Adjustments. After you have selected one of those 2 options you now can select a location for the adjustment.

Once that is selected, you now need to choose an account. Keep in mind the account you choose should NOT be an inventory asset account. If desired, you can also choose a Quickbooks class but this is not a requirement.

Next you will want to start adding items into the form. If your company uses bar code scanners, you can place your cursor in the bar code area and scan your barcode. You could also type the item name in the same box and hit tab. If you are not using the barcode tool, you can choose the item by using the drop down menu. Simply click the first blank line in the Item column of the list. Now, you can adjust the quantity of the Item in the QTY field. Use negative values to indicate lost inventory. If needed, you can adjust the date of the adjustment in the upper right had corner of this form. Check “only adjust” in NumberCruncher if you do not want these adjustments to reflect in Quickbooks.

Well, that pretty much sum's up how to create a Quantity Adjustment. If you are still having trouble, don't forget to check out some of our Tutorial videos. Well guys, that's it for today's post. I will be uploading blog's like this every Friday. If you have any topic's you would like for me to blog about, feel free to contact me directly at tom@numbercruncher.com. I will be sure to listen to all of your suggestions. As always our NumberCruncher support team is always here for any other question's you may have. Please contact us at anytime. Thank you guys for reading!!! I will see you next Friday!!

Posted in:

Tags: , , , , , , ,

Bill of Materials for Food and Beverage Manufacturers

October 27, 2014 at 2:52 PMIan Benoliel

An important tool for manufacturers is the Bill of Materials also known as the BoM or recipe.     The bill of materials is a listing of the raw materials and work in progress and the quantities of each needed to manufacture a finished product.      The bill of materials has multiple purposes including:

  • Pricing: A labor and overhead element can also be included in the bill of materials. By listing each raw materials and associated labor you can derive a cost for your products. You then compare that to the market price to ensure you will be producing profitablly.
  • Production: The BoM is the basis for manufacturing the product. It is used for pick sheets and routing. It can also be used for raw material back flushing.
  • Purchasing: The BoM is used to forecast the raw materials demand based on the quantity of finished products that needs to be produced.

Indented bill of materials

The term indented bill of materials refers to a product that has multiple stages of production. The typical manufacturing process has at least one work in progress stage and packaging stage.   At each stage the product is inventoried which implies that a seperate SKU or Item should be created for each stage. The indented bill of materials will show a hierarchical nature of a finished goods with the top level reprsenting the finished product which may be comprised of raw materials and work in progress. The following is an example of 2 stages in production:

  • Batch: The raw ingrdedients are mixed and one or more batches are created. Lot or batch #s are used to distinguish between batches made at different times. The bill of materials will contain the raw materials necessary to create the batch.
  • Package: The batch will be combined with other raw materials to create the finished product. The bill of materials will contain the quantity per of the batch necessary to create a unit of the finished product.

Routes vs. Stages

A stage is different than a route.   A route refers to a step in the production process to achieve a certain stage.  For example in producing the batch there may be mutiple steps including pouring, mixing, cooking, cooling etc.   You draw the line between a step and a stage by determining if you need to keep track of the inventory of work in process (WIP). If you need to inventory WIP then it should be a stage and it should it have its own SKU and bill of materials.  Otherwise it should be a route or step.

Posted in:

Tags: ,