task_111Manufacturing

16 verifiers · 15 core · 1 secondary · 16 LLM-graded

TaxonomyManufacturingBuyers and purchasing agents

Source files

xlsx · docx · pdf

Deliverables

docx · xlsx

Golden answer

withheld from the workspace

Verifiers

15 core · 16 LLM-graded

approved_material_source_list.xlsx8 KB

Source List12 rows

Source ID	Source Name	Source Type	Approved Spec Families	Melt Country	Origin Qualifying Status	Approval Status	Approval Expiry	Note
SRC-9F2A41	Cascade Rolled Products LLC	Mill	AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117	USA	Qualifying (USA)	Approved	2027-03-31	Aluminum plate/extrusion/bar
SRC-3B7C19	Ardenne Steelworks SA	Mill	AMS 5862, AMS 5659, AMS 5604	France	Qualifying (non-US)	Approved	2026-12-31	PH stainless; qualifying country (FR)
SRC-D14E8B	Tri-State Metals Distribution	Distributor	AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359	USA	Qualifying (USA)	Approved	2027-06-30	Distributor; passes mill certs
SRC-7A6D52	Hangzhou Precision Alloys Co	Mill	AMS-QQ-A-250, AMS 5659	China	Non-qualifying	Approved	2027-01-31	Approved source; non-qualifying origin
SRC-C2F9A7	Yellow River Specialty Steel	Mill	AMS 6359, AMS 6415, AMS 6419	China	Non-qualifying	Approved	2026-10-31	Non-qualifying origin
SRC-58E1B3	Brunderman Forge & Bar Inc	Mill	AMS 6415, AMS 6359, AMS 6419, AMS 5604	USA	Qualifying (USA)	Approved	2027-09-30	Steel bar/plate
SRC-B9D472	Lone Star Aerospace Metals	Distributor	AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117, AMS 5862	USA	Qualifying (USA)	Conditional	2026-07-15	Conditional pending requal audit
SRC-6E3F88	Pohang Advanced Alloy	Mill	AMS 5604, AMS 5659	South Korea	Qualifying (non-US)	Approved	2027-02-28	Qualifying country (KR)
SRC-A47C21	Meridian Metal Service Center	Distributor	AMS-QQ-A-250, AMS-QQ-A-200	USA	Qualifying (USA)	Suspended	2026-05-31	Suspended after FOD finding
SRC-2D8B96	Volga Forged Steel OAO	Mill	AMS 5862, AMS 6359	Russia	Non-qualifying	Not Approved	-	Not on approved list for these programs
SRC-E5C913	Adriatic Aero Alloys d.o.o.	Mill	AMS 5862, AMS 5659, AMS 5604	Slovenia	Qualifying (non-US)	Approved	2027-05-31	Qualifying country (SI)
SRC-7B2F60	Great Lakes Plate & Bar Co	Mill	AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415	USA	Qualifying (USA)	Approved	2027-08-31	Aluminum + 4340 bar

README13 rows

Approved Material Source List (AMSL)

Controlled document QE-AMSL Rev N. Effective 2026-06-01. Owner: V. Okonkwo, Supplier Quality.

Field definitions
Source ID / Source Name / Source Type — mill or distributor identity; Source ID joins from inventory lots and supplier quotes.
Approved Spec Families — specification families this source is approved to supply (e.g., AMS-QQ-A-250 covers its sub-specs; AMS 6415, AMS 5862, etc.). A source is not approved for families not listed.
Melt Country — country where the material is melted.
Origin Qualifying Status — whether the melt origin is a DFARS qualifying source. 'Qualifying (USA)' = United States; 'Qualifying (non-US)' = qualifying country other than the US; 'Non-qualifying' = neither.
Approval Status — Approved, Conditional, Suspended, or Not Approved. Conditional, Suspended, and Not Approved sources are not eligible for new commitments.
Approval Expiry — date the current approval lapses ('-' where not applicable).

Usage
Use this list to confirm that a candidate inventory lot or supplier quote comes from a source approved for the required specification, and to read its melt country for program country-of-origin and DFARS specialty-metals rules. This file states approval and origin facts only; it does not state whether any specific lot or quote may be used for a given requirement.

inventory_lot_cert_snapshot.xlsx10 KB

Lot Snapshot24 rows

Lot ID	Heat / Cast No.	Alloy	Material Spec	Temper / Condition	Product Form	Source ID	On Hand Qty (lb)	Allocated Qty (lb)	Hold Status	Cert Type	Traceability Status	Received Date	Cert Expiry	Yield Factor	Storage Location	Note
LOT-C7A340	HEAT-9F1B66	15-5PH	AMS 5659	H1025	Bar	SRC-7A6D52	360	60	None	3.1	Full	2026-03-27	-	0.84	Bar Cage B3	Hangzhou melt (CN)
LOT-3E8C71	HEAT-7A2F94	4340	AMS 6415	Annealed	Bar	SRC-58E1B3	520	0	None	3.1	Full	2026-05-06	-	0.8	Bar Cage B4	Bar lengths
LOT-8D4B19	HEAT-1C9E37	7075	AMS-QQ-A-200/11	T6511	Extrusion	SRC-9F2A41	600	95	None	3.1	Full	2026-04-15	-	0.77	Extrusion Bay E2	Door stop profile
LOT-2C9E14	HEAT-4A1F60	7075	AMS-QQ-A-250/12	T651	Plate	SRC-9F2A41	690	0	None	3.1	Full	2026-03-04	-	0.85	Plate Rack A1	T651 plate stock
LOT-3A7C82	HEAT-5B1E94	6061	AMS-QQ-A-250/11	T651	Plate	SRC-7B2F60	880	0	None	3.1	Full	2026-04-18	-	0.87	Plate Rack A9	Great Lakes plate
LOT-7F3A2B	HEAT-9D4E7B	7075	AMS-QQ-A-250/12	T7351	Plate	SRC-9F2A41	1040	410	None	3.1	Full	2026-02-11	-	0.82	Plate Rack A3	Mixed-size remnants
LOT-A1E9F4	HEAT-4C7D29	6061	AMS-QQ-A-250/11	T651	Plate	SRC-D14E8B	980	300	None	3.1	Full	2026-02-04	-	0.87	Plate Rack A5	Distributor pass-through
LOT-D6B821	HEAT-1E7C93	4340	AMS 6415	Annealed	Bar	SRC-D14E8B	880	120	None	C of C	Full	2026-01-29	-	0.78	Bar Cage B2	Distributor stock
LOT-E8C520	HEAT-2A6B74	6061	AMS-QQ-A-250/11	T651	Plate	SRC-9F2A41	1320	240	None	3.1	Full	2026-03-18	-	0.88	Plate Rack A4	General-purpose plate
LOT-9C5F28	HEAT-3F6D17	2024	AMS-QQ-A-250/4	T351	Plate	SRC-9F2A41	540	75	None	3.1	Full	2026-03-22	-	0.83	Plate Rack A6	Shim stock
LOT-5C9A16	HEAT-7E2B58	7075	AMS-QQ-A-250/12	T7351	Plate	SRC-7A6D52	920	0	None	3.1	Full	2026-04-30	-	0.8	Plate Rack A8	Hangzhou melt (CN)
LOT-7E1C95	HEAT-2D5A83	6061	AMS 4117	T651	Bar	SRC-9F2A41	330	40	None	3.1	Full	2026-04-09	-	0.82	Bar Cage B7	Spacer bar stock
LOT-5B2E88	HEAT-3D8F52	2024	AMS-QQ-A-200/3	T3511	Extrusion	SRC-9F2A41	410	0	None	3.1	Full	2026-04-02	-	0.79	Extrusion Bay E1	Seal retainer profile
LOT-2E6B95	HEAT-7D3F28	7075	AMS-QQ-A-200/11	T6511	Extrusion	SRC-7B2F60	430	0	None	3.1	Full	2026-04-25	-	0.78	Extrusion Bay E3	Stop profile, short runs
LOT-B3E7C0	HEAT-5F9A21	15-5PH	AMS 5862	Cond A	Plate	SRC-3B7C19	1180	0	Quality Hold - MRB	3.1	Full	2026-02-26	-	0.83	Stainless Rack S2	Surface pitting under review
LOT-2B7E54	HEAT-8E1A49	300M	AMS 6419	Annealed	Bar	SRC-C2F9A7	290	0	None	3.1	Full	2026-04-28	-	0.74	Bar Cage B6	Yellow River melt (CN)
LOT-8F4D17	HEAT-1A9C63	17-4PH	AMS 5604	H1075	Bar	SRC-3B7C19	250	0	Quality Hold - Recv Insp	3.1	Full	2026-05-23	-	0.85	Bar Cage B8	Awaiting receiving inspection
LOT-1D6B43	HEAT-9A4E72	15-5PH	AMS 5862	Cond A	Plate	SRC-2D8B96	800	0	None	3.1	Full	2026-05-27	-	0.83	Stainless Rack S3	Volga melt (RU)
LOT-6F2A87	HEAT-5D3B81	17-4PH	AMS 5604	H1075	Bar	SRC-6E3F88	470	130	None	3.1	Full	2026-03-09	-	0.85	Bar Cage B5	Pohang melt (KR)
LOT-1F9D63	HEAT-6E4C18	6061	AMS-QQ-A-250/11	T651	Plate	SRC-A47C21	760	0	None	3.1	Partial - heat not traceable	2026-01-08	-	0.86	Plate Rack A2	Meridian SC stock
LOT-4A8D62	HEAT-6B9C40	7075	AMS-QQ-A-250/12	T651	Plate	SRC-D14E8B	700	0	None	C of C	Full	2026-05-11	-	0.84	Plate Rack A7	Distributor; cofc only
LOT-4D1A95	HEAT-8C3E47	15-5PH	AMS 5862	Cond A	Plate	SRC-B9D472	540	0	None	3.1	Full	2026-05-19	-	0.8100000000000001	Stainless Rack S1	Lone Star conditional source
LOT-6B2F39	HEAT-2C8D71	15-5PH	AMS 5862	Cond A	Plate	SRC-E5C913	610	0	None	3.1	Full	2026-05-02	-	0.82	Stainless Rack S4	Adriatic melt (SI, qualifying)
LOT-9A4F37	HEAT-7B2D58	4340	AMS 6415	Annealed	Bar	SRC-58E1B3	305	0	None	3.1	Full	2026-04-22	-	0.8	Bar Cage B1	Short bar lengths

README17 rows

Inventory Lot & Certification Snapshot

Source system: WMS extract WMS-EXP-20260620-0741, certification fields joined from the Quality Management System (QMS) lot records. Rows are in extract order (not grouped by alloy).

Field definitions
Lot ID / Heat or Cast No. — physical lot and its melt/heat identity for traceability.
Alloy / Material Spec / Temper or Condition / Product Form — as certified for the lot; compare against the demand callout.
Source ID — originating mill or distributor; joins to the Approved Material Source List for approval status and melt country.
On Hand Qty (lb) — physical pounds in stock.
Allocated Qty (lb) — pounds already committed (firm reservation) to other work orders; not available for new allocation.
Hold Status — None, or an open hold/MRB tag. Material on hold is not available until the hold is cleared.
Cert Type — certificate on file: 3.1 or 3.2 are mill test reports with results; 'C of C' is a certificate of conformance without reported test results.
Traceability Status — Full, or a noted limitation (e.g., partial / heat not traceable).
Received Date / Cert Expiry — receipt date and certificate expiry where applicable ('-' if not tracked).
Yield Factor — historical fraction of available material expected to remain usable after machining/yield loss for this form and alloy.

Coverage arithmetic
Usable on-hand quantity = (On Hand Qty − Allocated Qty) × Yield Factor. Apply only to lots that also satisfy the engineering callout, certification, traceability, hold, source-approval, and country-of-origin requirements. This file reports raw status only; it does not state whether any lot may be used.

material_demand_forecast.xlsx9 KB

Demand Forecast26 rows

Requirement ID	Program ID	Program Name	Alloy	Material Spec	Temper / Condition	Product Form	Net Required Usable Qty (lb)	UOM	Need-By Date	MRP Firmed	Planner Note
REQ-H4A2	PRG-RAVEN	Raven Cargo Door Actuation Hinge	7075	AMS-QQ-A-250/12	T7351	Plate	842	lb	2026-08-10	Y	Hinge arm machined-stock plate
REQ-K9P1	PRG-RAVEN	Raven Cargo Door Actuation Hinge	4340	AMS 6415	Annealed	Bar	615	lb	2026-08-05	Y	Pivot pin bar, HT in house
REQ-C9T1	PRG-RAVEN	Raven Cargo Door Actuation Hinge	300M	AMS 6419	Annealed	Bar	176	lb	2026-08-03	Y	High-strength actuation pin bar
REQ-X5M3	PRG-RAVEN	Raven Cargo Door Actuation Hinge	15-5PH	AMS 5862	Cond A	Plate	394	lb	2026-08-12	Y	Actuation backing plate
REQ-T2C7	PRG-SABLE	Sable Emergency Egress Hinge Arm	15-5PH	AMS 5862	Cond A	Plate	430	lb	2026-08-24	Y	Egress latch plate
REQ-B6N3	PRG-SABLE	Sable Emergency Egress Hinge Arm	7075	AMS-QQ-A-250/12	T7351	Plate	268	lb	2026-08-22	Y	Egress arm gusset
REQ-F6B8	PRG-SABLE	Sable Emergency Egress Hinge Arm	6061	AMS 4117	T651	Bar	233	lb	2026-08-26	Y	Egress mechanism spacer bar
REQ-L8Q4	PRG-SABLE	Sable Emergency Egress Hinge Arm	4340	AMS 6359	Norm	Plate	287	lb	2026-08-28	Tentative	Egress strike plate
REQ-M1X8	PRG-MERIDIAN	Meridian Cabin Door Latch Hinge	6061	AMS-QQ-A-250/11	T651	Plate	512	lb	2026-09-21	Y	Latch housing plate
REQ-D7R4	PRG-MERIDIAN	Meridian Cabin Door Latch Hinge	2024	AMS-QQ-A-200/3	T3511	Extrusion	347	lb	2026-09-18	Y	Cabin door seal retainer extrusion
REQ-W3F9	PRG-MERIDIAN	Meridian Cabin Door Latch Hinge	15-5PH	AMS 5659	H1025	Bar	198	lb	2026-09-14	Y	Latch pawl bar
REQ-R7W2	PRG-MERIDIAN	Meridian Cabin Door Latch Hinge	7075	AMS-QQ-A-250/12	T651	Plate	412	lb	2026-09-12	Y	Latch backing plate
REQ-G2J9	PRG-MERIDIAN	Meridian Cabin Door Latch Hinge	6061	AMS 4117	T651	Bar	159	lb	2026-09-16	Tentative	Latch guide spacer bar
REQ-J5G7	PRG-TUNDRA	Tundra Cargo Door Stop Fitting	7075	AMS-QQ-A-200/11	T6511	Extrusion	455	lb	2026-10-12	Y	Cargo door stop extrusion
REQ-P2H6	PRG-TUNDRA	Tundra Cargo Door Stop Fitting	17-4PH	AMS 5604	H1075	Bar	284	lb	2026-10-09	Y	Stop fitting bar
REQ-V1D9	PRG-TUNDRA	Tundra Cargo Door Stop Fitting	15-5PH	AMS 5862	Cond A	Plate	357	lb	2026-10-06	Y	Stop fitting mounting plate
REQ-Y8K2	PRG-TUNDRA	Tundra Cargo Door Stop Fitting	2024	AMS-QQ-A-200/3	T3511	Extrusion	213	lb	2026-10-11	Tentative	Stop seal retainer extrusion
REQ-Q8L5	PRG-HALCYON	Halcyon Service Door Hinge Bracket	6061	AMS-QQ-A-250/11	T651	Plate	726	lb	2026-11-02	Y	Service door hinge bracket plate
REQ-Z4V2	PRG-HALCYON	Halcyon Service Door Hinge Bracket	4340	AMS 6359	Norm	Plate	389	lb	2026-11-01	Y	Bracket reinforcement plate
REQ-N3K4	PRG-HALCYON	Halcyon Service Door Hinge Bracket	2024	AMS-QQ-A-250/4	T351	Plate	301	lb	2026-11-05	Y	Hinge shim plate stock
REQ-S6P3	PRG-HALCYON	Halcyon Service Door Hinge Bracket	7075	AMS-QQ-A-250/12	T651	Plate	244	lb	2026-11-04	Tentative	Bracket cover plate
REQ-A2F7	PRG-CALDER	Calder Overwing Hatch Hinge Set	6061	AMS-QQ-A-250/11	T651	Plate	333	lb	2026-11-16	Y	Overwing hatch hinge plate
REQ-E9C1	PRG-CALDER	Calder Overwing Hatch Hinge Set	7075	AMS-QQ-A-200/11	T6511	Extrusion	271	lb	2026-11-14	Y	Hatch hinge stop extrusion
REQ-U4B8	PRG-CALDER	Calder Overwing Hatch Hinge Set	17-4PH	AMS 5604	H1075	Bar	162	lb	2026-11-18	Tentative	Hatch latch pin bar
REQ-H7D5	PRG-CALDER	Calder Overwing Hatch Hinge Set	4340	AMS 6415	Annealed	Bar	205	lb	2026-11-13	Y	Hatch hinge pin bar
REQ-W9A3	PRG-CALDER	Calder Overwing Hatch Hinge Set	15-5PH	AMS 5659	H1025	Bar	147	lb	2026-11-17	Tentative	Hatch pawl bar

README14 rows

Material Demand Forecast — Door/Hinge Mechanism Assemblies

Source system: MRP run MRP-2026-0619-R2. Planner: D. Achebe, Materials Planning. Review cycle: 2026-Q3 build wave.

Field definitions
Requirement ID — unique MRP line identifier; joins to the analysis workbook and to supplier RFQ lines.
Program ID / Program Name — owning build program; joins to the Program Priority & Build Schedule.
Alloy / Material Spec / Temper or Condition / Product Form — the engineering material callout. All four must be satisfied for a lot or quote to apply.
Net Required Usable Qty (lb) — the quantity of conforming, usable material the program needs, expressed in pounds of raw stock after expected machining/yield loss is accounted for. This is the figure that on-hand and quoted material must cover.
Need-By Date — date raw material must be on hand to protect the program build start (which is later; see Program schedule). Receiving inspection and in-house processing consume the interval between.
MRP Firmed — Y = firm planned order; Tentative = planning estimate that may shift.

How to assess inventory coverage
Usable on-hand quantity for a lot = (On Hand Qty − Allocated Qty) × Yield Factor, using the figures in the Inventory Lot & Certification Snapshot. A requirement is met from inventory when the usable quantity from lots that satisfy the callout, certification, traceability, source-approval, hold, and country-of-origin rules is at least the Net Required Usable Qty above.
Quantities are pounds of raw stock. They do not encode any usability, compliance, or sourcing decision; those are determined by reading this file together with the inventory, source list, quote matrix, substitution policy, and program schedule.

program_priority_build_schedule.docx13 KB

Program Priority & Build Schedule

2026 Q3 Door/Hinge Mechanism Build Wave — Production Control Release PC-2026-0618

Issued by: Production Control & Program Management Office (PMO). Distribution: Sourcing, Materials Planning, Quality, MRB. Status as of 2026-06-19.

1. Purpose

This release fixes program priority ranking and committed build dates for the current review cycle. Where multiple programs compete for the same eligible material, allocation shall favor the higher-priority program (lower priority rank number). Contractual country-of-origin and specialty-metals restrictions stated in Section 3 are flowed from the customer contracts and are binding on sourcing decisions; they are not discretionary and may not be relaxed for cost or schedule convenience.

2. Program Priority Ranking and Build Commitments

Program ID

Program / Assembly

Customer

Priority Rank

Build Start

Restriction

PRG-RAVEN

Raven Cargo Door Actuation Hinge

Lockmar Defense Systems

1 (highest)

2026-08-17

DFARS

PRG-SABLE

Sable Emergency Egress Hinge Arm

Lockmar Defense Systems

2026-08-31

DFARS

PRG-MERIDIAN

Meridian Cabin Door Latch Hinge

Aerolux Commercial

2026-09-28

CUST-EU

PRG-TUNDRA

Tundra Cargo Door Stop Fitting

Northwind Regional

2026-10-19

CUST-EU

PRG-HALCYON

Halcyon Service Door Hinge Bracket

Aerolux Commercial

2026-11-09

None

PRG-CALDER

Calder Overwing Hatch Hinge Set

Northwind Regional

6 (lowest)

2026-11-23

None

Note: build start is the first date material must be available on the floor; raw-material need-by dates in the demand forecast are set earlier to allow incoming inspection and in-house processing.

3. Contractual Sourcing Restrictions

Code

Applies To

Restriction Detail

DFARS

PRG-RAVEN, PRG-SABLE (Lockmar Defense)

Specialty-metals clause DFARS 252.225-7008/7009 flows to these contracts. Steel and specialty alloys must be melted and manufactured in the United States or a qualifying country. Material of non-qualifying origin (including but not limited to People's Republic of China and Russian Federation melt) is not acceptable for these programs regardless of certificate quality.

CUST-EU

PRG-MERIDIAN, PRG-TUNDRA (Aerolux / Northwind)

Customer master agreement prohibits raw material melted in the People's Republic of China or the Russian Federation. Material melted in the United States or in European/allied qualifying countries (e.g., France, South Korea) is acceptable. This restriction is independent of, and stricter than, any commercial preference.

None

PRG-HALCYON, PRG-CALDER

No special country-of-origin restriction beyond standard approved-source requirements. Standard AMSL approval and certification rules still apply.

4. Allocation and Contention Guidance

Where a single eligible inventory lot can serve more than one program's requirement and its usable quantity is insufficient for both, the higher-priority program shall be allocated first. Lower-priority requirements left short by such allocation shall be covered by new purchase if a compliant, feasible quote exists, or escalated otherwise. Allocation decisions shall respect the certification, traceability, source-approval, and country-of-origin constraints in the engineering material substitution policy; a lower price or shorter lead time does not override those constraints.

Schedule risk callouts for this cycle: the two Lockmar (DFARS) programs have the earliest need-by dates and the tightest origin constraints, so any reliance on non-qualifying-origin stock or on quotes promising receipt on or after need-by must be raised to the PMO. Calder, as the lowest-priority program with the latest build start, is the preferred bill-payer for any reallocation of contested material, subject to its own need-by dates.

Authorized: T. Vasquez, Senior Manager, Production Control & PMO — 2026-06-19

supplier_quote_leadtime_matrix.xlsx13 KB

Quote Matrix32 rows

Quote ID	RFQ ID	Source ID	Alloy	Material Spec	Temper / Condition	Product Form	Quoted Qty (lb)	Unit Price ($/lb)	Extended Cost ($)	Lead Time (days)	Quoted Receipt Date	Cert Offered	Melt Country	Min Order (lb)	Quote Expiry	Note
QTE-8B3F19	RFQ-1C9E44	SRC-58E1B3	300M	AMS 6419	Annealed	Bar	250	14.2	3550	27	2026-07-26	3.1	USA	150	2026-07-14	Brunderman
QTE-7C3A95	RFQ-4B9D52	SRC-D14E8B	2024	AMS-QQ-A-250/4	T351	Plate	400	6.4	2560	18	2026-09-22	3.1	USA	200	2026-09-05	Tri-State
QTE-3A9F18	RFQ-2B7E55	SRC-3B7C19	15-5PH	AMS 5862	Cond A	Plate	900	11.75	10575	33	2026-08-06	3.1	France	400	2026-07-20	Ardenne; qualifying
QTE-F1C8A6	RFQ-6C2A91	SRC-7B2F60	7075	AMS-QQ-A-250/12	T7351	Plate	450	9.95	4477.5	34	2026-08-14	3.1	USA	250	2026-07-18	Great Lakes; later dock
QTE-9C4E27	RFQ-2B7E55	SRC-2D8B96	15-5PH	AMS 5862	Cond A	Plate	1000	8.1	8100	24	2026-07-28	3.1	Russia	500	2026-07-18	Volga; lowest price
QTE-2A7E61	RFQ-4D8A12	SRC-7B2F60	6061	AMS-QQ-A-250/11	T651	Plate	650	4.45	2892.5	28	2026-08-12	3.1	USA	300	2026-07-28	Great Lakes
QTE-5F1B83	RFQ-4D8A12	SRC-9F2A41	6061	AMS-QQ-A-250/11	T651	Plate	800	4.3	3440	41	2026-08-25	3.1	USA	300	2026-08-01	Cascade
QTE-1E8C57	RFQ-9A4F22	SRC-58E1B3	4340	AMS 6415	Annealed	Bar	650	5.2	3380	22	2026-07-25	3.1	USA	300	2026-07-12	Brunderman
QTE-8C3D49	RFQ-4D8A12	SRC-D14E8B	6061	AMS-QQ-A-250/11	T651	Plate	900	4.15	3735	16	2026-07-31	3.1	USA	300	2026-07-21	Tri-State
QTE-7E2A85	RFQ-3E8B27	SRC-E5C913	17-4PH	AMS 5604	H1075	Bar	250	11.1	2775	35	2026-08-15	3.1	Slovenia	150	2026-07-23	Adriatic; later dock
QTE-9B4F27	RFQ-7F1A38	SRC-D14E8B	2024	AMS-QQ-A-200/3	T3511	Extrusion	350	7.85	2747.5	18	2026-07-24	3.1	USA	200	2026-07-15	Tri-State extrusion
QTE-7D2B40	RFQ-6C2A91	SRC-7A6D52	7075	AMS-QQ-A-250/12	T7351	Plate	800	6.85	5480	19	2026-07-22	3.1	China	400	2026-07-10	Hangzhou; lowest price
QTE-3F7D92	RFQ-2C7F49	SRC-7B2F60	6061	AMS 4117	T651	Bar	250	5.9	1475	19	2026-08-08	3.1	USA	150	2026-07-24	Great Lakes bar
QTE-A3F91C	RFQ-6C2A91	SRC-9F2A41	7075	AMS-QQ-A-250/12	T7351	Plate	600	9.4	5640	26	2026-07-30	3.1	USA	250	2026-07-15	Cascade direct
QTE-4C8F12	RFQ-6F2C83	SRC-7B2F60	7075	AMS-QQ-A-250/12	T651	Plate	400	8.95	3580	21	2026-08-01	3.1	USA	250	2026-07-18	Great Lakes
QTE-6F1A93	RFQ-2B7E55	SRC-B9D472	15-5PH	AMS 5862	Cond A	Plate	600	10.2	6120	21	2026-07-26	3.1	USA	300	2026-07-19	Lone Star; conditional source
QTE-1A6E38	RFQ-2C7F49	SRC-9F2A41	6061	AMS 4117	T651	Bar	300	5.75	1725	23	2026-08-12	3.1	USA	150	2026-07-25	Cascade bar
QTE-8A1D63	RFQ-8D3A19	SRC-7A6D52	15-5PH	AMS 5659	H1025	Bar	350	7.4	2590	22	2026-07-27	3.1	China	150	2026-07-17	Hangzhou; cheaper
QTE-6D1B84	RFQ-3C8F27	SRC-58E1B3	4340	AMS 6359	Norm	Plate	450	6.9	3105	30	2026-08-26	3.1	USA	250	2026-08-05	Brunderman 4340 plate
QTE-6A2D58	RFQ-3E8B27	SRC-6E3F88	17-4PH	AMS 5604	H1075	Bar	350	10.9	3815	31	2026-08-04	3.1	South Korea	200	2026-07-21	Pohang
QTE-2F8C41	RFQ-8D3A19	SRC-3B7C19	15-5PH	AMS 5659	H1025	Bar	300	9.85	2955	28	2026-08-09	3.1	France	150	2026-07-23	Ardenne bar
QTE-5B9E41	RFQ-4B9D52	SRC-9F2A41	2024	AMS-QQ-A-250/4	T351	Plate	350	6.65	2327.5	24	2026-09-28	3.1	USA	200	2026-09-08	Cascade; later dock
QTE-4E9A72	RFQ-1C9E44	SRC-C2F9A7	300M	AMS 6419	Annealed	Bar	300	9.55	2865	20	2026-07-19	3.1	China	150	2026-07-09	Yellow River; cheaper
QTE-C1E7B4	RFQ-5A2F61	SRC-9F2A41	7075	AMS-QQ-A-200/11	T6511	Extrusion	500	8.9	4450	30	2026-08-03	3.1	USA	250	2026-07-22	Cascade extrusion
QTE-2D7C64	RFQ-7F1A38	SRC-9F2A41	2024	AMS-QQ-A-200/3	T3511	Extrusion	400	7.6	3040	29	2026-08-02	3.1	USA	200	2026-07-19	Cascade extrusion
QTE-1F7C93	RFQ-3E8B27	SRC-3B7C19	17-4PH	AMS 5604	H1075	Bar	300	11.4	3420	26	2026-08-01	3.1	France	150	2026-07-20	Ardenne
QTE-9A2E57	RFQ-3C8F27	SRC-C2F9A7	4340	AMS 6359	Norm	Plate	500	5.45	2725	22	2026-08-18	3.1	China	250	2026-08-02	Yellow River; cheaper
QTE-B6D2A9	RFQ-9A4F22	SRC-D14E8B	4340	AMS 6415	Annealed	Bar	700	4.95	3465	12	2026-07-15	C of C	USA	250	2026-07-08	Tri-State; cofc only
QTE-5D8B72	RFQ-2B7E55	SRC-E5C913	15-5PH	AMS 5862	Cond A	Plate	700	12.4	8680	30	2026-08-03	3.1	Slovenia	300	2026-07-22	Adriatic; qualifying
QTE-D9F3B1	RFQ-9A4F22	SRC-7B2F60	4340	AMS 6415	Annealed	Bar	500	5.35	2675	20	2026-07-23	3.1	USA	250	2026-07-14	Great Lakes bar
QTE-3D9B16	RFQ-5A2F61	SRC-7B2F60	7075	AMS-QQ-A-200/11	T6511	Extrusion	400	9.15	3660	24	2026-07-29	3.1	USA	250	2026-07-20	Great Lakes extrusion
QTE-9E4B27	RFQ-6F2C83	SRC-9F2A41	7075	AMS-QQ-A-250/12	T651	Plate	500	8.7	4350	25	2026-08-04	3.1	USA	250	2026-07-20	Cascade

README16 rows

Supplier Quote & Lead-Time Matrix
Compiled from RFQ responses received 2026-06-12 through 2026-06-19. Buyer: R. Castellanos, Procurement.
Field definitions
Quote ID / RFQ ID — quote line and the RFQ it answers. Multiple quotes may answer one RFQ.
Source ID — quoting mill or distributor; joins to the Approved Material Source List.
Alloy / Material Spec / Temper or Condition / Product Form — material offered on the quote line.
Quoted Qty (lb) / Unit Price ($/lb) / Extended Cost ($) — offered pounds, price per pound, and their product (Extended Cost = Quoted Qty × Unit Price).
Lead Time (days) — calendar days from PO release to dock.
Quoted Receipt Date — supplier-promised dock date. Compare against the requirement Need-By Date for schedule feasibility.
Cert Offered — certificate the supplier will provide (3.1 / 3.2 / C of C).
Melt Country — melt origin for country-of-origin and DFARS rules.
Min Order (lb) / Quote Expiry — minimum order quantity for the line and the date the quote lapses.
Usage
A quote answers a requirement only when its material matches the callout (or an allowance in the engineering substitution policy), its source is approved and its origin satisfies the program rule, its certificate meets the certification requirement, and its Quoted Receipt Date precedes the Need-By Date with margin for inspection and processing. This file reports quoted facts only; it does not state which quotes should be acted on.

Dockerfile1 KB

# EKW task - Python environment with data analysis + document skills

FROM alpine/git:2.45.2 AS skills

ARG ANTHROPIC_SKILLS_REF=da20c92503b2e8ff1cf28ca81a0df4673debdbf7

RUN git clone --filter=blob:none --no-checkout https://github.com/anthropics/skills.git /tmp/anthropic-skills \
    && cd /tmp/anthropic-skills \
    && git sparse-checkout init --cone \
    && git sparse-checkout set skills/xlsx skills/pdf skills/docx \
    && git -c advice.detachedHead=false checkout "${ANTHROPIC_SKILLS_REF}" \
    && mkdir -p /harbor/skills \
    && cp -a skills/xlsx /harbor/skills/xlsx \
    && cp -a skills/pdf /harbor/skills/pdf \
    && cp -a skills/docx /harbor/skills/docx

FROM python:3.11-slim
WORKDIR /workspace
RUN apt-get update && apt-get install -y --no-install-recommends \
    libreoffice poppler-utils && rm -rf /var/lib/apt/lists/*
COPY --from=skills /harbor/skills /harbor/skills
RUN chmod -R a+rX /harbor/skills
RUN pip install --no-cache-dir \
    numpy==2.3.3 pandas==2.3.3 matplotlib==3.10.7 pypdf==6.7.0 openpyxl \
    pdfplumber pdf2image pillow defusedxml lxml python-docx pytest pyyaml
COPY data/ /workspace/data/
RUN mkdir -p /workspace/output

instruction.md3 KB

You are supporting a material sourcing review for an aerospace components manufacturer that builds certified door and hinge mechanism assemblies. Upcoming production lots require aluminum and steel raw materials, including plate, bar, extrusion, and machined-stock inputs. Several material requirements are at risk because available inventory, supplier quotes, lead times, certification status, source approvals, allocations, yield loss, and program priorities do not all align. Production and sourcing leadership need a sourcing plan that identifies which material lots can be used, which supplier quotes should be acted on, which requirements remain at risk, and which program commitments should be prioritized. The objective is not simply to buy the cheapest or fastest available material; the recommendation must distinguish physically available material from material that is actually usable for certified aerospace production. Using the attached material sourcing packet, determine the recommended sourcing and allocation plan for the current review cycle. Identify which aluminum and steel requirements can be covered from compliant on-hand inventory, which require new purchases, which supplier quotes are feasible, and which shortages or compliance issues require escalation. Evaluate the tradeoffs among material specification, temper or condition, product form, mill certification, traceability, approved-source status, country-of-origin or customer restrictions, available quantity after allocation, usable yield, lead time, cost, and program delivery impact. Work only from the attached materials: the material demand forecast, inventory lot and certification snapshot, approved material source list, supplier quote and lead-time matrix, engineering material substitution policy, and program priority / build schedule. Do not invent alternate alloys, tempers, substitutions, engineering approvals, customer waivers, supplier capacity, expedite options, certification corrections, yield assumptions, or allocation changes that are not documented in the source files. Where commercial pressure, supplier promises, or apparent physical availability conflict with material specification, certification, traceability, approved-source, or substitution-policy constraints, treat the documented compliance constraints as authoritative. Do not treat material as usable merely because it is physically on hand or quoted as available. A material lot or quote should be considered usable only if the source materials support that it meets the required alloy/specification, temper or condition, product form, certification and traceability requirements, approved-source rules, and available quantity after existing allocations and yield loss. If a substitution is not explicitly permitted by the attached engineering material substitution policy or documented approval records, do not assume it is allowed. Produce the following deliverables in `/workspace/output/`: - `material_sourcing_recommendation_memo.docx` — a structured recommendation memo for sourcing, production, and quality leadership explaining the recommended material sourcing plan, key constraints, program risks, cost and lead-time tradeoffs, and required escalations. - `material_sourcing_analysis_workbook.xlsx` — a supporting workbook documenting requirement-level material coverage, inventory-lot usability, supplier quote feasibility, allocation decisions, yield-adjusted quantity analysis, at-risk requirements, alternatives considered, and recommended sourcing actions.

task.toml1 KB

version = "1.0"
artifacts = ["/workspace/output"]

[verifier]
timeout_sec = 3600.0

[verifier.env]
# values withheld by the publishing pipeline

[agent]
timeout_sec = 14400.0

[environment]
build_timeout_sec = 900.0
memory_mb = 4096
storage_mb = 10240
allow_internet = true
skills_dir = "/harbor/skills"

[metadata]
taxonomy_ids = ["EKW-13"]
domain = "Operations & Supply Chain"
occupation = "Procurement & Purchasing"
sector = "Manufacturing"
subdomain = "Supply chain & procurement"
task_type = "Material sourcing / material allocation / sourcing risk review"