Asterwick Manufacturing
Production, quality, downtime, and component inventory
About Asterwick Manufacturing
Industry
Industrial manufacturing
Footprint
6 U.S. plants
Factory network
28 lines, 145 work centers, 260 machines
Product catalog
180 finished goods, 850 active components
Data scope
22 tables
Fact volume
1.35M shipped rows
Asterwick Manufacturing is a fictional discrete manufacturer that builds configured industrial assemblies and replacement modules for manufacturers, distributors, and field-service operators. The kit covers plant operations, supply-chain pressure, quality control, and production execution rather than a full MES or ERP exhaust. Asterwick's plants specialize by product family, but shared suppliers and components create cross-plant material risk. Production managers can drill from monthly plant scorecards into order lifecycles, run-level throughput, inspection outcomes, downtime events, component inventory, BOM exposure, and purchase-order service levels.
Operating Profile
- Production model: medium-volume configured assembly with plant, line, work-center, machine, shift, product-family, finished-good, and BOM context
- Operations cadence: production orders convert into runs, inspections, downtime exposure, and monthly plant scorecards
- Supply-chain posture: shared suppliers and components create shortage risk, late receipts, expedite behavior, and supplier-tier comparisons
- Quality posture: inspection checkpoints track first-pass yield, scrap, rework, hold reasons, and cost-of-poor-quality signals by product family and BOM revision
- Buyer use case: operations, quality, supply-chain, and plant leaders can build executive dashboards and drillthrough views from the same package
Recent Business Events
- 1Supplier reliability splits hard by tier: Preferred lands 2.6 days early, At Risk runs 6.0 days late and misses 95% of promises. Blended, 43% of lines are late.
- 2Autumn demand spikes lift material-shortage holds to about 3,100 orders a month against a 1,400 baseline, roughly 2.2x the normal rate.
- 3Unplanned events outnumber planned maintenance two to one and cost 2.3x the minutes, with material shortages the largest lost-capacity source.
These are the operating questions this kit is optimized to answer first.
Completed units, ordered units, backlog, and on-time completion
Schedule variance by plant, line, product family, and customer priority
First-pass yield, scrap rate, rework rate, and defect mix
Downtime minutes, capacity loss, reason mix, and machine criticality
Inventory health, shortage risk, component exposure, and supplier reliability
Purchase order lateness, expedite activity, and plant scorecards
Embedded Analytical Stories
Plant scorecard drillthrough
Drill from monthly throughput, yield, downtime, and shortage KPIs into runs and machines.
Material risk investigation
Connect shortage holds to BOM components, inventory health, suppliers, and open PO lines.
Quality and downtime tradeoff
Compare first-pass yield, scrap, rework, and downtime reasons to spot the friction points.