Easily check the cost and availability of components needed to build an assembly. For each component, enhancement IAR - Assembly Costing Report prints number required, extended cost, quantity on hand, number of pending sales, quantity on Open POs and additional quantity needed.

To print the Assembly Costing Report, choose Assembly Items Reports from the Inventory Reports Menu, and select Assembly Costing Report:

+--------------------------------------------------------------------+
|+==================================================================+|
||INRPTS             Assembly Items Reports       COMPANY ID: SP    ||
||05/12/91          Software Professionals Inc.   GENERATION #: 12  ||
|+==================================================================+|
|                                                                    |
|                 +========= SELECT REPORT =========+                |
|                 |  A - Assembly Items List        |                |
|                 |  C - Component Items Usage      |                |
|                 |  O - Assembly Costing Report    |                |
|                 +=================================+                |
+--------------------------------------------------------------------+

The report will look similar to the following:

+----------------------------------------------------------------------------------------------------------------------------+
|                                   # Per     Cost of    Cost Per  Cost Per    Total #    On     Pending     Open     Over + |
|T Dep Item Number  Description    Assembly  Component   Assembly  Assembly   Required   Hand     Sales      POs      Under -|
| --- ------------ -------------- -------- ----------- ---------- ---------  -------- ------- --------- --------- ---------- |
|                                                                                                                            |
|Assembly: P ELE 8100000SPC      PORT. RADIO SPECIAL                                                                         |
|P ELE 810425RAD   PORTABLE RADIO     1.00    9.898788   9.898788  9.898788    10.00    30.00      0.00      0.00      20.00 |
|P ELE 810534BAT   BATTERIES          4.00    0.555556   2.222222  2.222222    40.00    60.00      0.00      0.00      20.00 |
|P ELE 810229BLNK  BEACH BLANKET      1.00    1.000000   1.000000  1.000000    10.00     5.00      0.00      0.00      -5.00 |
|P ELE 810598EAR   EARPHONES          1.00    3.250000   3.250000  3.250000    10.00   125.00    120.00      0.00      -5.00 |
|                                                     =========== =========                                                  |
|Components in Assembly: 4  Total Cost For 1 Assembly = 16.371010 16.371010    Cost For 10  Assemblies =         163.71      |
+----------------------------------------------------------------------------------------------------------------------------+

Total # Required is calculated by multiplying the # Per Assembly times Number of Assemblies you enter. Pending Sales comes from un-posted Sales Invoices and Open POs comes from un-received Purchase Orders. Pending Sales will be zero unless you sell the component by itself as well as part of an assembly.

The Over+/Under- column is calculated by the following formula:

On Hand - Total # Required - Pending Sales + Open POs.

It can be used as an indication of whether additional items need to be ordered. However, if the component is used in more than one assembly, the Over+/Under- column is not a true indication of the quantity needed. Since this report analyzes one assembly at a time, it does not show aggregate demand when a component is used in multiple assemblies.