Difference between revisions of "SCC QSP Stock Management"

From SCC Wiki
Jump to: navigation, search
(Created page with "Stock management is concerned with the use and condition of physical material (and not of "parts", which are only the specifications for material, which itself must be made or...")
(No difference)

Latest revision as of 08:40, 22 October 2018

Stock management is concerned with the use and condition of physical material (and not of "parts", which are only the specifications for material, which itself must be made or bought). When appropriate, stock can be identified by lot even uniquely by serial number. The Maestro Stock module manages stock items identified by lot or serial number, and also the relationships between stock items in a hierarchical assembly.

Maestro includes stock data for the SCC Aircraft Wireless Receiver. Hierarchical serialized records are maintained for each manufactured product, including serialized sub-assemblies.


Part Number Identifier Name Description
10000002 SN A00123 Aircraft Wireless Sold to customer
10000002 SN A00124 Aircraft Wireless Sold to customer and later repaired in field.
10000002 SN A00125 Aircraft Wireless Sold to customer, subsequent failure documented in an Issue Report, attempted repair in field, and finally disposed of as non-repairable.
10000002 SN A00126 Aircraft Wireless Assembled and ready for use
60000001 Order xxxx Aircraft Wireless Repair Kit Shipped for field repair of SN A00124
60000001 Order xxxx Aircraft Wireless Repair Kit Shipped for field repair of SN A00125

A00123 - Sold

Insert content here.

A00124 - Sold, repaired in field

Insert content here.

A00125 - Sold, issue report, repair attempted in field, unit disposed of

Insert content here.

A00126 - Ready for sale

Insert content here.

Order xxxx - Field Repair Kit for SN A00124

Insert content here.

Order xxxx - Field Repair Kit for SN A00125

Insert content here.


  • Identify Material Items (MIs) by part number, quantity, serial number and lot, with associated documents (e.g. certificate of compliance by lot, test results by serial number).
  • Support hierarchical serialized MIs and hierarchical material management (e.g. a parent MI can be identified using the serial number of a child SI).
    • The serial number of a parent MI may follow the serial number a child SI, or the parent SI may have its own serial number.
    • A hierarchical MI structure can be traversed and viewed from any level in the hierarchy.
  • Support per-MI per-production job, and per-project deviations from released PLM documentation to meet unique project requirements, or resolve a temporary production issue.
  • Support multiple inventory or stocking locations.
  • Support per-part workflows for MIs.
    • Workstation (e.g. assembly cell, test cell).
    • In-process inspection and test points.
    • Required quality records.
    • Verification and re-verification testing.
    • Ad hoc manufacturing and assembly with in-process inspections, issue to client job, return, and de-assembly of material for potential future use.
  • Demonstrable conformance to compliance requirements for manufactured parts, assemblies, and configurations.
  • Traceability from issue reports to specific SIs (part number and revision, serial number, batch, lot, etc.).
  • Validate SIs when entering or leaving control (i.e. goods receipt and order shipment), and on demand
    • Does MI meet current PLM spec?
    • Are there outstanding Issues reported against an MI jserial number or its part number?

Order Management

  • Create order
    • Associate order with project
    • Associate order with creator and assigned order picker
    • Identify desired ship date
    • Populate order from selected Parts List (1st level only)
  • Issue MIs to order by serial number
  • Return MIs from order
  • Search orders
    • By MI serial number, lot number, or part number
    • by Project
  • Support stock back-ordering
  • Order Master data
    • Order picker
    • Project
    • Customer
    • Ship Request Date
    • User Defined Fields (x10)

Supply Chain


  • Manage purchase requirements and fulfillment
  • POS-like capability for on-demand orders from production staff

Goods Receipt

  • Incoming goods inspection and receipt
  • Assign stock location for new material


Production is the conversion of raw materials into finished goods, and decomposition of finished goods to raw materials for re-manufacturing.

  • Assign serial number for new assemblies
  • Kit stock
    • In-house production
    • Contractor production
  • Issue material to parent stock assembly and production job (validate material by serial number using PLM data)
  • Return material from production jobs (validate material by serial number using PLM data)
  • Assign and manage production tasks per employee
  • PDF Kit List and Assembly Parts List reports
  • Support and manage per-job or per-serial-number PDN (product deviation notice)

Material Requirements Planning (MRP)

Material Requirements Planning is the determining material requirements for producing finished goods to meet a demand forecast, and taking into account stock on hand and stock on order.

  • Determine demand for finished goods and raw material based on project forecast, stock on hand and minimum stocking levels
  • Provide guidance to determining production schedule
  • Provide guidance to raw material purchase
  • Allocate raw material and finished goods to production schedule


  • Email and personal dashboard notifications
  • Material transactions (e.g. new part manufacturing, part issue, part scrap, part conversion or upgrade, etc.).


Reports are any regular information being reported on, and may be a live dashboard type of report or a one-off or scheduled email report in PDF format (e.g. every day, first Monday of every month...).

  • Part manufacturing and usage history.
  • Location by part number and revision or by serial number, parts and location by job, etc.
  • Stock availability and order status.
  • Stock demand (MRP)

Glossary of Related Terminology

Common Long Term Description
MI Stock Item A stock item is a physical realization of a part. One form of identification is the part number, but SIs can also be identified by lot or batch, or individual serial number (must be unique for at least that part number).
Production - The act of producing a part from its raw materials