Pine Assembly Workshop: Bill of materials exploded for a production order
Bill of materials exploded for a production order for Pine Assembly Workshop. The same structure exploded for BUILD-1, an order for 2 DESK. Extended quantity is quantity per parent times parent quantity on every row, and the leaf totals of 8 LEG, 2 PANEL and 24 SCREW equal the material requirements the inventory-manufacturing model already holds for that order, which the model_requirement column repeats on each leaf row for comparison.
csv
text/csv
- Document Set
- manufacturing
- Industry
- manufacturing
- Source Kit
- inventory-manufacturing
- Entity
- Pine Assembly Workshop
- Synthetic
- true
- As Of
- 2026-09-08
Binary csv: no in-browser preview. Download it above to open in a compatible application.
Specifications
- Document Set
- manufacturing
- Industry
- manufacturing
- Source Kit
- inventory-manufacturing
- Entity
- Pine Assembly Workshop
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 6
- Production Order
- BUILD-1
- Order Quantity
- 2
- Multi Path Components
- 1
- Leaf Total LEG
- 8
- Leaf Total PANEL
- 2
- Leaf Total SCREW
- 24
Testing contract
Expected to pass- Scenario
- Check the multiplication on every row, then total the leaves by component and compare with the model_requirement column.
- Expected result
- All 6 rows multiply correctly and the three leaf totals are 8, 2 and 24, matching the model requirements exactly. SCREW is the one component reached down two branches, 16 through BASE and 8 through TOP, so a reader that takes only the first match for a component gets it wrong.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Pine Assembly Workshop: Bill of materials exploded for a production order” is a deterministic Novus Examples fixture for Data import, CSV parsing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 6 rows. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("bill-of-materials-explosion.csv")
print(df.head())
print(df.dtypes)Related files
- csvPine Assembly Workshop: Attribute sampling planAttribute sampling plan for Pine Assembly Workshop. The sampling table the inspection used. The lot of 16 legs, being the quantity issued to BUILD-1 and BUILD-2 together, falls in the 16 to 25 band, which calls for a sample of 5 and an accept number of 0, and 5 is exactly the number of samples inspection-measurements.csv holds for each characteristic. With an accept number of 0 and 2 nonconforming readings, the lot is rejected on the plan and dealt with by nonconformance rather than by acceptance.
- csvPine Assembly Workshop: Certificate of conformance registerCertificate of conformance register for Pine Assembly Workshop. Two certificates against the same lot and the same inspection report, one per production order. The first discloses 2 nonconformances and the second none, because the nonconforming legs were consumed by the replacement on the first order and the second order drew clean stock from the same lot.
- csvPine Assembly Workshop: First article inspectionFirst article inspection for Pine Assembly Workshop. The first article record for LEG against DRW-LEG-002 revision C: all 5 characteristics measured and passed before the run started. The readings are the fourth sample from the production inspection, which is deliberate: the first article passes on every characteristic while the production lot later fails on two, so the pair shows that a clean first article does not guarantee a clean run.
- csvPine Assembly Workshop: Gauge calibration registerGauge calibration register for Pine Assembly Workshop. The 5 gauges used on this inspection, each with its calibration certificate, the date it was calibrated and the date it falls due. All 5 were inside calibration on 2026-09-10, the inspection date, and the used_for column names the characteristics each one measured, so every characteristic can be traced to a gauge and every gauge to a certificate.
- csvPine Assembly Workshop: Indented bill of materialsIndented bill of materials for Pine Assembly Workshop. The DESK structure exploded to 2 levels in 6 rows, with an indent column so the tree is readable and an is_assembly flag so leaves can be told from sub-assemblies. Per finished unit the leaves are 4 LEG, 1 PANEL and 12 SCREW, which cost 25.20 USD. The 35.00 USD of sub-assembly rows is the same material counted again at a higher level and must not be added to it.
- csvPine Assembly Workshop: Inspection characteristics and tolerancesInspection characteristics and tolerances for Pine Assembly Workshop. The 5 characteristics taken from DRW-LEG-002 revision C, with the nominal, both tolerances and the resulting limits. Four are bilateral and one, surface roughness, is unilateral with a lower tolerance of zero, so its lower limit equals its nominal and a reader that assumes symmetry computes a limit that does not exist.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.