Requirements/Shortages
One of the critical processes that a manufacturer must perform is a requirements/shortage analysis. If I want to build a certain number of an inventory assembly, what do I need and what parts do I have to purchase or build? QuickBooks® by itself can only analyze this to a single level. If you want to work with multiple level assemblies you must use CCRQBOM.
Working with the 0050-MC assembly item, if we wish to issue a build for quantity 1 with QuickBooks® you can see that we cannot issue the build as we are short of some subassemblies.
Before we can build this assembly we must build some number of the WHAS and PU-1800 sub assemblies. Unfortunately, from this screen, it is not clear how many of each we need to build. It appears that we need 2 of WHAS and one of PU-1800, but that is misleading. Recall that in our example the PU-1800 itself requires a WHAS assembly, which isn’t apparent here.
To resolve this we will use CCRQBOM. Starting at the Assembly window:
To generate a requirements/shortage report for an assembly in CCRQBOM you must first select the assembly from the assembly window. Click the Full Level option, enter the quantity you want to assemble in the Quantity field, then click the Build (Requirements) button.
The following screen shows that there are no shortages of parts – we can actually build this assembly if we build the sub assemblies.
Note that this report lists the Assembly items as well as the Inventory items. Since this is a full-level explosion, a shortage is not listed for the assembly items themselves. Instead you will see a value in the build column that specifies how many of the subassembly items will be built.
You can modify this grid in several ways to make it fit your needs. Note that this is described in detail in the Working with Grids chapter later.
• You can choose which columns to display
• You can resize the screen by dragging the lower left corner. You can also resize any columns by dragging the separator bar in the column headings.
• You
can sort the items by clicking on the item header. This sample is sorted by Item
ID, as shown by the arrow in the heading.
• You
can “group” the items by any of the columns by dragging
the column header to the “drag” area as shown on the screen. In this sample we
dragged the type column, which groups the items by the inventory item
type. You can click on the “-“ and +’” buttons to hide and expand the
levels.
•
Filtering can be a very useful feature. This allows you to filter
the items shown by the values of a column. Click on the check mark next to the
column heading and select the filter that you wish to use. In this sample we are
filtering by the Type column – we selected “Assembly” items, so that only
assembly items show.
This
shows us that we need to build one PU-1800 and four WHAS assemblies (they don’t
show as “short” because we asked for a full level explosion – these items will
be built).
You can click on the Layout button to save the changes that you make. Note that this saves the layout for only the current workstation, it will not affect other users.
Negative Inventory and
Subassembly Balances