task_111Manufacturing
All trialsGPT-5.6 TerracodexTrial 02
Trial reward
GPT-5.6 TerraFail
Trial 02 — 2nd of 4 by reward score. This model averages 82.5% across 4 trials on this task.
- 12/15Core verifiers passed
- 13/16All verifiers passed
- 3Core failed
- 41Turns
- 31Tool calls
- $1.41Cost
- 25.7mTime
- 62kOutput tokens
Missed 3 of 15 core — traceability, memo_recommendation and no_fabrication_side_effects.
core (15)
usable_quantityLLMPass
Why it mattersCoverage must be assessed on usable yield-adjusted quantity net of allocations, and the original attempt's central risk is treating gross or physically-present pounds as usable.
How to passChecks that the analysis workbook reports usable on-hand quantity using the formula (On Hand - Allocated) x Yield Factor for inventory lots rather than gross on-hand pounds.
Reads
country_of_originLLMPass
Why it mattersCountry-of-origin restrictions are binding contractual constraints, and the cheapest/fastest options for several critical lines are non-qualifying-origin material that must not be selected.
How to passChecks that material melted in China or Russia is excluded for the DFARS programs (Raven, Sable) and the CUST-EU programs (Meridian, Tundra) regardless of price or certificate quality.
Reads
cert_traceabilityLLMPass
Why it mattersEN 10204 3.1/3.2 certification and full traceability are minimum eligibility gates, and the original attempt risks accepting C-of-C or non-traceable material that is physically attractive.
How to passChecks that Certificate-of-Conformance-only lots/quotes and partial-traceability lots are excluded from certified-production coverage.
Reads
source_hold_statusLLMPass
Why it mattersApproved-source status and hold status are hard eligibility gates, and otherwise-attractive USA-origin material from these sources must not be planned against requirements.
How to passChecks that sources in Suspended, Conditional, or Not Approved status, and material under an open quality/MRB or receiving-inspection hold, are excluded from new commitments.
Reads
substitution_policyLLMPass
Why it mattersThe substitution policy is exhaustive and prohibits interchange (e.g., T651 vs T7351, /11 vs /12, bar vs plate vs extrusion), so a model must not silently treat near-match material as covering a callout.
How to passChecks that no alloy, temper/condition, product-form, or specification sub-spec substitution is applied beyond same-spec oversize/remnant cutdown.
Reads
allocation_priorityLLMPass
Why it mattersProgram-priority allocation is an explicit contention rule, and getting it wrong misassigns scarce compliant stock between competing programs.
How to passChecks that contested inventory lots usable by more than one requirement are allocated to the higher-priority (lower rank number) program first, with lower-priority shortfalls flowing to new purchase.
Reads
lead_time_feasibilityLLMPass
Why it mattersLead-time feasibility is an explicit gate, and the original attempt risks counting a compliant quote that docks on or after need-by as resolving a requirement on schedule.
How to passChecks that a supplier quote is treated as feasible only when its quoted dock/receipt date precedes the requirement need-by date.
Reads
requirement_coverageLLMPass
Why it mattersRequirement-level coverage classification is the core analytical output the task asks for and must be complete across all demand lines.
How to passChecks that the workbook classifies each of the 26 requirements into a coverage disposition (covered from compliant inventory, partial inventory plus buy, or full new purchase) at the requirement-ID level.
Reads
traceabilityLLMFail
Why it mattersRequirement-level traceability is an explicit auditability obligation and is exactly where a weaker solution omits the why-rejected evidence chain.
How to passChecks that for each at-risk requirement the workbook records the selected inventory lot(s) with usable quantity, the rejected lots with reasons, the selected quote, the rejected quote alternatives with reasons, the residual after inventory, and the resulting purchase quantity and cost.
Reads
Failure mode Decision Audit Trail Fragmented or Incomplete
Why it failedSelected lots, rejected alternatives, selected and rejected quotes, and purchase cost for an at-risk requirement each live on a different sheet instead of one joined view.
Justification
Fail. The workbook does not provide a single per-requirement view tying together selected lots, rejected matching lots with reasons, selected/rejected quotes, residual after inventory, and resulting PO qty/cost. Example: REQ-T2C7 shows the selected lot LOT-6B2F39 (106.2 lb) and rejected lots only in Inventory Allocation/Inventory Req Eligibility, the selected quote QTE-3A9F18 and alternative quotes only in Quote Feasibility, the residual 323.8 lb in Requirement Coverage, and the PO qty/cost 680.8 lb / $7,999.40 only in Purchase Plan (shared with REQ-V1D9), so the required audit trail is not tied together per requirement.
residual_vs_moqLLMPass
Why it mattersConflating need with MOQ-inflated buy quantity was a defect in the earlier attempt and obscures both true demand and committed spend.
How to passChecks that requirement residual quantity is reported separately from the minimum-order-quantity-adjusted purchase quantity, with the excess identified.
Reads
cost_reconciliationLLMPass
Why it mattersA reconciled, self-consistent committed total was an explicit fix from the earlier attempt, where the memo and PO tab disagreed on the headline figure and shared lines risked double-charging.
How to passChecks that the workbook presents a single authoritative total committed new-buy cost with no conflicting totals and a cost chain that reconciles, with shared quote lines not double-counted.
Reads
escalation_languageLLMPass
Why it mattersClarifying escalation language so that 'every requirement has a feasible path' is not conflated with quality holds awaiting action was an explicit obligation from the earlier revision.
How to passChecks that the memo states there is no hard sourcing dead-end while separately listing quality/MRB/process escalations.
Reads
memo_recommendationLLMFail
Why it mattersThe task's core decision principle is distinguishing usable material from merely cheap/fast/available material, and the memo is where that reasoning must be made legible to leadership.
How to passChecks that the memo recommends a sourcing/allocation plan that prioritizes compliance over lowest price or shortest lead time and explicitly identifies rejected cheaper/faster non-compliant options.
Reads
Failure mode Escalation or Tradeoff Communication Incomplete
Why it failedThe memo argues compliance over price or lead time but omits naming at least one of the three required attractive, cheaper, or faster non-compliant quotes along with the specific reason it was rejected.
Justification
The memo does recommend a compliant sourcing/allocation plan and states that certification, source approval, country restrictions, and 3.1/3.2 evidence override price and lead time. However, it does not explicitly identify all of the required attractive-but-rejected options: the lowest-price China-melt 7075-T7351 quote (~$6.85/lb) and the lowest-price Russia-melt 15-5PH quote (~$8.10/lb) are not specifically named, and although QTE-B6D2A9 is rejected as C-of-C-only, the memo does not show it as the cheapest/fastest 4340 bar quote (~$4.95/lb).
no_fabrication_side_effectsLLMFail
Why it mattersThe task forbids inventing options beyond the source packet, and penalizing fabricated content or unrequested side-additions protects against hallucinated uplift that would look like a stronger answer.
How to passChecks that the deliverables do not introduce fabricated alloys, tempers, substitutions, approvals, waivers, expedite options, or other material not present in the source files, and do not add materially unsolicited deliverables.
Reads
Failure mode Eligibility or Controlling Rule Applied Incorrectly
Why it failedQuote Feasibility rows state a receipt-on-or-after-need-by rejection reason that contradicts the row's own dock and need-by dates.
Justification
Not all critical gating facts are supported in the provided extract: the source data for program priority/country rules is not shown, the AMSL/source-approval section is truncated so spec/status calls like 'Great Lakes not approved for AMS 4117' and several Approved/Conditional/Suspended statuses cannot be independently verified, and the Quote Feasibility tab contains contradictory unsupported reasons (e.g. QTE-7C3A95/REQ-N3K4 and QTE-3A9F18/REQ-X5M3 say 'receipt on/after need-by' even though those rows show receipt before need-by).
residual_po_reconciliationLLMPass
Why it mattersThe shared-PO double-counting failure mode (inflating the committed total by billing one quote line at each requirement's minimum) is exactly where the earlier attempt produced an unreconciled headline figure, and catching it is a fair, materially distinct core check.
How to passChecks that the sum of per-requirement residual purchase needs reconciles to the consolidated purchase-order quantities and committed cost, so shared quote lines are not double-counted across the requirements they serve.
Reads
secondary (1)
memo_consistencyLLMPass
Why it mattersIf the memo asserts headline counts or program restriction classes, they must be accurate and self-consistent; this guards against a confidently-stated but wrong summary rather than mandating an unprompted structure.
How to passChecks that any coverage counts or per-program restriction classes the memo chooses to state are internally consistent and correct, without forcing the memo to include specific counts.
Reads
2 deliverables · what this trial produced
Read Me
| Material Sourcing Analysis Workbook | ||
|---|---|---|
| 2026 Q3 door/hinge mechanism build wave — compliant material coverage, allocation, quote feasibility, and escalation support. | ||
| Source basis: material demand forecast; inventory lot & certification snapshot; approved material source list; supplier quote & lead-time matrix; ENG-MSP Rev H; program priority & build schedule. | ||
| Decision snapshot | ||
| Requirements reviewed | 26 | Requirement-level callouts in MRP forecast |
| Total net usable demand (lb) | 8960 | Demand is already stated as net usable quantity |
| Planned compliant inventory coverage (lb) | 5852.25 | Yield-adjusted and after existing allocations |
| Planned compliant purchase coverage (lb) | 3107.75 | Quote quantity assessed against net usable demand per ENG-MSP §5 |
| Residual coverage gap (lb) | 0 | Must remain zero before release |
| Selected PO quantity (lb) | 3626.5 | Includes stated minimum-order quantities |
| MOQ-driven excess controlled stock (lb) | 518.75 | Excess is driven by selected 4340 bar, 7075 plate, and 7075 extrusion MOQ |
| Selected purchase cost ($) | 32343.92 | Unit prices and MOQ are as quoted; no unquoted costs included |
| Authoritative controls applied | ||
| Control | Application | |
| Exact callout | All planned allocations and purchases match alloy, specification, temper/condition, and product form exactly. No substitution is used. | |
| Certification / trace | Only 3.1 or 3.2 certification with Full traceability is usable. C of C-only and partial traceability are excluded. | |
| Quality holds | Lots on an open Quality Hold / MRB tag are excluded from coverage, even if physically on hand. | |
| Source approval | Only sources in Approved status and approved for the applicable specification family are eligible. Conditional, Suspended, and Not Approved sources are excluded. | |
| Country restrictions | DFARS programs require qualifying origin; CUST-EU programs prohibit China and Russia; unrestricted programs still require approved source and certification. | |
| Inventory quantity | Usable inventory = (On Hand − existing Allocated) × documented Yield Factor. The allocation plan never exceeds that usable amount. | |
| Quote timing | A dated quote must be before the need-by date. The workbook separately flags the two-day margin on REQ-L8Q4 because ENG-MSP requires an inspection/processing margin but does not quantify it. | |
| Commercial gate | Quotes must be accepted or revalidated by their stated expiry. The packet does not document a post-expiry extension, revised lead time, price, or capacity. |
Requirement Coverage
| Requirement-Level Coverage Plan | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Coverage is in net usable pounds. Inventory is yield-adjusted and after firm WMS allocations; quoted purchase is assessed directly against net usable demand per ENG-MSP §5. | |||||||||||||||||||
| Source: material_demand_forecast.xlsx / Demand Forecast; allocation and purchase plan derived under ENG-MSP Rev H and program schedule controls. | |||||||||||||||||||
| Requirement ID | Program ID | Program / Assembly | Priority | Country Rule | MRP Firmed | Need-By Date | Alloy | Material Spec | Temper / Condition | Product Form | Net Required Usable (lb) | Planned Inventory (usable lb) | Planned Purchase (usable lb) | Planned Total (lb) | Gap (lb) | Coverage Status | Recommended Sourcing Action | Key Constraint / Risk | Source / Basis |
| REQ-H4A2 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 1 | DFARS | Y | 2026-08-10 | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 842 | 516.6 | 325.4 | 842 | 0 | Covered | Use LOT-7F3A2B plus purchase QTE-A3F91C. | QTE-A3F91C replaces lower-priced CN quote rejected by DFARS. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-K9P1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 1 | DFARS | Y | 2026-08-05 | 4340 | AMS 6415 | Annealed | Bar | 615 | 615 | 0 | 615 | 0 | Covered | Use LOT-3E8C71 and LOT-9A4F37; no purchase. | C of C-only LOT-D6B821 excluded. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-C9T1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 1 | DFARS | Y | 2026-08-03 | 300M | AMS 6419 | Annealed | Bar | 176 | 0 | 176 | 176 | 0 | Covered | Purchase QTE-8B3F19. | Lower-cost QTE-4E9A72 is China origin and cannot serve DFARS Raven. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-X5M3 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 1 | DFARS | Y | 2026-08-12 | 15-5PH | AMS 5862 | Cond A | Plate | 394 | 394 | 0 | 394 | 0 | Covered | Use LOT-6B2F39; no purchase. | Held / nonapproved / conditional 15-5PH inventory is not a backup plan. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-T2C7 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 2 | DFARS | Y | 2026-08-24 | 15-5PH | AMS 5862 | Cond A | Plate | 430 | 106.2 | 323.8 | 430 | 0 | Covered | Use LOT-6B2F39 balance plus purchase QTE-3A9F18. | Higher-priority Raven receives compliant lot first. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-B6N3 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 2 | DFARS | Y | 2026-08-22 | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 268 | 0 | 268 | 268 | 0 | Covered | Purchase QTE-A3F91C. | CN quote is not DFARS eligible; selected US quote meets dated need. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-F6B8 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 2 | DFARS | Y | 2026-08-26 | 6061 | AMS 4117 | T651 | Bar | 233 | 233 | 0 | 233 | 0 | Covered | Use LOT-7E1C95; no purchase. | QTE-3F7D92 excluded because its source lacks AMS 4117 approval. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-L8Q4 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 2 | DFARS | Tentative | 2026-08-28 | 4340 | AMS 6359 | Norm | Plate | 287 | 0 | 287 | 287 | 0 | Covered | Purchase QTE-6D1B84; obtain PMO/Quality timing confirmation. | Receipt is 2026-08-26 vs 2026-08-28 need-by: only 2 days of dated margin. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-M1X8 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | Y | 2026-09-21 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 512 | 512 | 0 | 512 | 0 | Covered | Use LOT-3A7C82; no purchase. | Full certified US inventory exceeds demand. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-D7R4 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | Y | 2026-09-18 | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 347 | 323.9 | 23.1 | 347 | 0 | Covered | Use LOT-5B2E88 plus purchase QTE-2D7C64. | Cascade quote is lower-priced than Tri-State and timely. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-W3F9 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | Y | 2026-09-14 | 15-5PH | AMS 5659 | H1025 | Bar | 198 | 0 | 198 | 198 | 0 | Covered | Purchase QTE-2F8C41. | CN inventory/quote cannot serve Meridian CUST-EU. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-R7W2 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | Y | 2026-09-12 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 412 | 412 | 0 | 412 | 0 | Covered | Use LOT-2C9E14; no purchase. | Only T651 plate is used; T7351 not substituted. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-G2J9 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | Tentative | 2026-09-16 | 6061 | AMS 4117 | T651 | Bar | 159 | 4.8 | 154.2 | 159 | 0 | Covered | Use LOT-7E1C95 balance plus purchase QTE-1A6E38. | Great Lakes quote is not approved for AMS 4117. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-J5G7 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | Y | 2026-10-12 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 455 | 455 | 0 | 455 | 0 | Covered | Use LOT-8D4B19 and LOT-2E6B95; no purchase. | Priority allocation consumes first eligible extrusion stock. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-P2H6 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | Y | 2026-10-09 | 17-4PH | AMS 5604 | H1075 | Bar | 284 | 284 | 0 | 284 | 0 | Covered | Use LOT-6F2A87; no purchase. | LOT-8F4D17 remains on receiving hold and is excluded. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-V1D9 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | Y | 2026-10-06 | 15-5PH | AMS 5862 | Cond A | Plate | 357 | 0 | 357 | 357 | 0 | Covered | Purchase QTE-3A9F18. | Qualifying France source; lower-price Volga/Lone Star alternatives are unusable. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-Y8K2 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | Tentative | 2026-10-11 | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 213 | 0 | 213 | 213 | 0 | Covered | Purchase QTE-2D7C64. | Selected shared Cascade quote is timely and lower priced. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-Q8L5 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 5 | None | Y | 2026-11-02 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 726 | 726 | 0 | 726 | 0 | Covered | Use LOT-E8C520; no purchase. | Compliant inventory coverage; suspended/partial-trace lot excluded. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-Z4V2 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 5 | None | Y | 2026-11-01 | 4340 | AMS 6359 | Norm | Plate | 389 | 0 | 389 | 389 | 0 | Covered | Purchase QTE-9A2E57. | China-origin quote allowed only because Halcyon has no country restriction. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-N3K4 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 5 | None | Y | 2026-11-05 | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 301 | 301 | 0 | 301 | 0 | Covered | Use LOT-9C5F28; no purchase. | Exact compliant inventory exceeds demand. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-S6P3 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 5 | None | Tentative | 2026-11-04 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 244 | 174.5 | 69.5 | 244 | 0 | Covered | Use LOT-2C9E14 balance plus purchase QTE-9E4B27. | 250-lb MOQ creates 180.50 lb controlled excess. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-A2F7 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 6 | None | Y | 2026-11-16 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 333 | 333 | 0 | 333 | 0 | Covered | Use LOT-A1E9F4; no purchase. | Compliant eligible inventory; lower-priority allocation after earlier programs. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-E9C1 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 6 | None | Y | 2026-11-14 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 271 | 269.25 | 1.75 | 271 | 0 | Covered | Use LOT-2E6B95 balance plus purchase QTE-C1E7B4. | 250-lb MOQ fills a 1.75-lb residual and creates controlled excess. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-U4B8 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 6 | None | Tentative | 2026-11-18 | 17-4PH | AMS 5604 | H1075 | Bar | 162 | 0 | 162 | 162 | 0 | Covered | Purchase QTE-7E2A85. | Higher unit price than QTE-6A2D58, but 162-lb PO avoids 200-lb MOQ and costs less in total. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-H7D5 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 6 | None | Y | 2026-11-13 | 4340 | AMS 6415 | Annealed | Bar | 205 | 45 | 160 | 205 | 0 | Covered | Use LOT-9A4F37 balance plus purchase QTE-D9F3B1. | 250-lb MOQ has lower total spend than lower-unit-price 300-lb MOQ alternative. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
| REQ-W9A3 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 6 | None | Tentative | 2026-11-17 | 15-5PH | AMS 5659 | H1025 | Bar | 147 | 147 | 0 | 147 | 0 | Covered | Use LOT-C7A340; no purchase. | Approved CN source is allowed for unrestricted Calder, not for Meridian. | Demand forecast + ENG-MSP / source list / quote matrix / schedule |
Purchase Plan
| Selected Purchase Plan | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected lines only. Planned PO quantity is the larger of the requirement coverage allocation and the stated minimum order quantity; no unquoted yield factor is applied to supplier quotes. | ||||||||||||||||
| Source: supplier_quote_leadtime_matrix.xlsx / Quote Matrix; eligibility evaluated against AMSL, ENG-MSP Rev H, and program schedule. | ||||||||||||||||
| Quote ID | Source ID | Source Name | Material Description | Melt Country | Cert Offered | Quoted Receipt | Quote Expiry | Quoted Qty (lb) | Min Order (lb) | Planned PO Qty (lb) | PO vs Quote Capacity | Unit Price ($/lb) | Planned Cost ($) | Covered Requirement(s) | Action / Tradeoff | Commercial / Schedule Gate |
| QTE-A3F91C | SRC-9F2A41 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | USA | 3.1 | 2026-07-30 | 2026-07-15 | 600 | 250 | 593.4 | Within quoted qty | 9.4 | 5577.96 | Raven H4 + Sable B6 | US Cascade is the only selected quote timely for both; Hangzhou price cannot override DFARS. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-8B3F19 | SRC-58E1B3 | Brunderman Forge & Bar Inc | 300M | AMS 6419 | Annealed | Bar | USA | 3.1 | 2026-07-26 | 2026-07-14 | 250 | 150 | 176 | Within quoted qty | 14.2 | 2499.2 | Raven C9 | Higher price than CN quote, but CN origin is non-qualifying for DFARS. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-3A9F18 | SRC-3B7C19 | Ardenne Steelworks SA | 15-5PH | AMS 5862 | Cond A | Plate | France | 3.1 | 2026-08-06 | 2026-07-20 | 900 | 400 | 680.8 | Within quoted qty | 11.75 | 7999.4 | Sable T2 + Tundra V1 | Ardenne France is approved/qualifying and lower priced than Adriatic; Volga/Lone Star unusable. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-6D1B84 | SRC-58E1B3 | Brunderman Forge & Bar Inc | 4340 | AMS 6359 | Norm | Plate | USA | 3.1 | 2026-08-26 | 2026-08-05 | 450 | 250 | 287 | Within quoted qty | 6.9 | 1980.3 | Sable L8 | US source required for Sable; 2-day dated receipt margin requires PMO/Quality confirmation. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-2D7C64 | SRC-9F2A41 | Cascade Rolled Products LLC | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | USA | 3.1 | 2026-08-02 | 2026-07-19 | 400 | 200 | 236.1 | Within quoted qty | 7.6 | 1794.36 | Meridian D7 + Tundra Y8 | Cascade is lower priced than Tri-State and covers both residuals. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-2F8C41 | SRC-3B7C19 | Ardenne Steelworks SA | 15-5PH | AMS 5659 | H1025 | Bar | France | 3.1 | 2026-08-09 | 2026-07-23 | 300 | 150 | 198 | Within quoted qty | 9.85 | 1950.3 | Meridian W3 | France source complies with CUST-EU; CN alternative is prohibited. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-1A6E38 | SRC-9F2A41 | Cascade Rolled Products LLC | 6061 | AMS 4117 | T651 | Bar | USA | 3.1 | 2026-08-12 | 2026-07-25 | 300 | 150 | 154.2 | Within quoted qty | 5.75 | 886.65 | Meridian G2 | Cascade is approved for AMS 4117; Great Lakes is not. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-9A2E57 | SRC-C2F9A7 | Yellow River Specialty Steel | 4340 | AMS 6359 | Norm | Plate | China | 3.1 | 2026-08-18 | 2026-08-02 | 500 | 250 | 389 | Within quoted qty | 5.45 | 2120.05 | Halcyon Z4 | CN origin is permitted only for unrestricted Halcyon; never allocate to Sable. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-9E4B27 | SRC-9F2A41 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T651 | Plate | USA | 3.1 | 2026-08-04 | 2026-07-20 | 500 | 250 | 250 | Within quoted qty | 8.7 | 2175 | Halcyon S6 | Cheapest timely compliant T651 plate; 250-lb MOQ exceeds 69.50-lb residual. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-C1E7B4 | SRC-9F2A41 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | USA | 3.1 | 2026-08-03 | 2026-07-22 | 500 | 250 | 250 | Within quoted qty | 8.9 | 2225 | Calder E9 | Lower price than Great Lakes; 250-lb MOQ exceeds 1.75-lb residual. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-7E2A85 | SRC-E5C913 | Adriatic Aero Alloys d.o.o. | 17-4PH | AMS 5604 | H1075 | Bar | Slovenia | 3.1 | 2026-08-15 | 2026-07-23 | 250 | 150 | 162 | Within quoted qty | 11.1 | 1798.2 | Calder U4 | Higher unit price than Pohang, but 162-lb PO is lower total spend than Pohang's 200-lb MOQ. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| QTE-D9F3B1 | SRC-7B2F60 | Great Lakes Plate & Bar Co | 4340 | AMS 6415 | Annealed | Bar | USA | 3.1 | 2026-07-23 | 2026-07-14 | 500 | 250 | 250 | Within quoted qty | 5.35 | 1337.5 | Calder H7 | 250-lb MOQ costs less than Brunderman's 300-lb MOQ; C of C-only Tri-State quote excluded. | Accept or obtain documented revalidation by stated quote expiry; no extension is documented. |
| Selected Purchase Total | 3626.5 | 32343.92 |
At-Risk & Escalations
| At-Risk Requirements, Compliance Blocks, and Escalations | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| These items are not alternate supply unless the documented hold/approval/certification condition is resolved. This workbook does not assume a waiver, certification correction, expedite, or reallocation beyond the packet. | |||||||||
| Source: ENG-MSP Rev H; inventory lot & certification snapshot; AMSL; quote matrix; program priority & build schedule. | |||||||||
| Risk ID | Category | Requirement / Lot / Quote | Program / Priority | Documented Condition | Impact on Plan | Required Escalation / Gate | Owner | Status | Source / Basis |
| R-01 | Schedule / lead time | REQ-L8Q4 / QTE-6D1B84 | Sable / Rank 2 | Compliant US 4340 plate quote receipts 2026-08-26 for a 2026-08-28 need-by (2 calendar days). ENG-MSP requires receipt before need-by with inspection/processing margin, but the packet does not quantify the margin. | Only selected path for Sable 4340 AMS 6359 plate; no eligible inventory. | PMO and Quality must confirm that the documented two-day dated interval is adequate before relying on the quote; otherwise escalate per ENG-MSP §7. | PMO + Quality + Buyer | Open — timing gate | Quote matrix; ENG-MSP §6; program schedule |
| R-02 | Quote lifecycle | All 12 selected quote lines | All programs | Each selected quote has a stated expiry; the packet contains no accepted PO, extension, or refreshed supplier confirmation. | Price, quantity, and dock date cannot be assumed beyond the listed quote expiry. | Buyer must release within expiry or obtain documented revalidation. Do not assume capacity, price, or expedite on a lapsed quote. | Procurement | Open — commercial gate | Quote matrix README / quote expiry column |
| R-03 | Quality hold | LOT-B3E7C0 | 15-5PH plate candidates | 979.40 yield-adjusted lb is on Quality Hold — MRB for surface pitting. | Not included in Raven/Sable/Tundra 15-5PH coverage; selected purchases remain required. | Maintain exclusion until hold is formally cleared. MRB may disposition separately, but no plan credit is allowed now. | Quality / MRB | Open — excluded | Inventory snapshot; ENG-MSP §2 |
| R-04 | Quality hold | LOT-8F4D17 | 17-4PH bar candidates | 212.50 yield-adjusted lb is on Quality Hold — Receiving Inspection. | Not included in Tundra/Calder 17-4PH coverage; QTE-7E2A85 remains required for Calder. | Complete receiving inspection/MRB outside the sourcing plan; do not consume before clearance. | Quality Receiving | Open — excluded | Inventory snapshot; ENG-MSP §2 |
| R-05 | Certification | LOT-D6B821 / QTE-B6D2A9 | 4340 AMS 6415 bar | Both present only a C of C; ENG-MSP requires 3.1 or 3.2 test-report evidence. | 592.80 inventory usable lb and the lower-price quote are not usable for certified production. | Do not allocate or purchase as a substitute. Certification correction is not assumed; retain QTE-D9F3B1 plan. | Quality + Procurement | Blocked — noncompliant | Inventory / quote matrix; ENG-MSP §2 |
| R-06 | Certification | LOT-4A8D62 | 7075-T651 plate | C of C only; 588.00 yield-adjusted physical lb is not eligible. | Halcyon residual still requires QTE-9E4B27 despite physical stock. | Do not use without documented 3.1/3.2 evidence; no correction is assumed. | Quality | Blocked — noncompliant | Inventory snapshot; ENG-MSP §2 |
| R-07 | Trace / source | LOT-1F9D63 | 6061 plate | Partial traceability (heat not traceable) and source SRC-A47C21 is Suspended. | 653.60 physical usable lb is excluded; it is not a backup for Meridian/Halcyon/Calder. | Keep segregated; do not plan against any certified requirement. | Quality + Materials | Blocked — noncompliant | Inventory snapshot; AMSL; ENG-MSP §§2–3 |
| R-08 | Source approval | LOT-4D1A95 / QTE-6F1A93 | 15-5PH plate | SRC-B9D472 is Conditional. Conditional sources are ineligible for new commitments. | Physical lot and lower-price quote are excluded from the 15-5PH plan. | Do not allocate/commit while conditional period is unresolved. No requalification is assumed. | Supplier Quality | Blocked — conditional source | AMSL README; ENG-MSP §3 |
| R-09 | Origin / DFARS | LOT-5C9A16 / QTE-7D2B40 | Raven/Sable 7075-T7351 plate | China melt is non-qualifying for DFARS Lockmar programs. | Lower-cost inventory and quote cannot cover Raven/Sable; Cascade US purchase is selected. | Maintain country-of-origin block; no customer waiver is documented. | Procurement + PMO | Blocked — origin | AMSL; program schedule; ENG-MSP §3 |
| R-10 | Origin / DFARS | LOT-2B7E54 / QTE-4E9A72 | Raven 300M bar | China melt is non-qualifying for DFARS Raven. | Lower-price physical stock/quote cannot cover REQ-C9T1; QTE-8B3F19 is selected. | Maintain DFARS block; no substitute or waiver is documented. | Procurement + PMO | Blocked — origin | AMSL; program schedule; ENG-MSP §3 |
| R-11 | Origin / customer | LOT-C7A340 / QTE-8A1D63 | Meridian 15-5PH H1025 bar | China melt is prohibited by Meridian CUST-EU restriction. | Cannot cover REQ-W3F9; CN lot is allocated only to unrestricted Calder. | Use QTE-2F8C41 for Meridian. Prevent cross-program reassignment to CUST-EU work. | Materials Planning | Controlled allocation | Program schedule; ENG-MSP §3 |
| R-12 | Source spec scope | QTE-3F7D92 | 6061 AMS 4117 bar | SRC-7B2F60 is Approved but its approved spec families do not list AMS 4117. | Fast Great Lakes quote cannot cover Sable/Meridian spacer-bar requirements. | Use Cascade QTE-1A6E38 only; do not infer approval from source’s general approved status. | Supplier Quality + Buyer | Blocked — spec family | AMSL; quote matrix |
| R-13 | MOQ / inventory control | QTE-9E4B27, QTE-C1E7B4, QTE-D9F3B1 | Halcyon / Calder | Minimum orders exceed the residual requirement by 180.50, 248.25, and 90.00 lb respectively. | Selected purchase total exceeds allocation demand by 518.75 lb. | Create controlled residual-stock reservations with full heat/cert traceability; do not allocate residual to mismatched or restricted programs. | Materials Planning + Quality | Open — stock control | Quote matrix; purchase plan |
Inventory Allocation
| Compliant On-Hand Allocation Plan | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Allocation quantities are yield-adjusted usable pounds and respect existing WMS allocations. Higher-priority programs are assigned first where eligible inventory is shared. | |||||||||||||
| Source: inventory snapshot + AMSL + ENG-MSP Rev H + program priority schedule. Existing WMS Allocated Qty is not changed by this workbook. | |||||||||||||
| Requirement ID | Program | Priority | Need-By | Lot ID | Source ID | Source Name | Melt Country | Exact Material | Planned Allocation (usable lb) | Lot Eligible Usable Before Plan (lb) | Lot Remaining Usable (lb) | Compliance Basis | Allocation Decision |
| REQ-H4A2 | Raven Cargo Door Actuation Hinge | 1 | 2026-08-10 | LOT-7F3A2B | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 516.6 | 516.6 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Highest-priority Raven gets all eligible T7351 plate first. |
| REQ-K9P1 | Raven Cargo Door Actuation Hinge | 1 | 2026-08-05 | LOT-3E8C71 | SRC-58E1B3 | Brunderman Forge & Bar Inc | USA | 4340 | AMS 6415 | Annealed | Bar | 416 | 416 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Eligible US 4340 bar; existing usable balance. |
| REQ-K9P1 | Raven Cargo Door Actuation Hinge | 1 | 2026-08-05 | LOT-9A4F37 | SRC-58E1B3 | Brunderman Forge & Bar Inc | USA | 4340 | AMS 6415 | Annealed | Bar | 199 | 244 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Raven receives remaining eligible 4340 bar before lower-priority Calder. |
| REQ-X5M3 | Raven Cargo Door Actuation Hinge | 1 | 2026-08-12 | LOT-6B2F39 | SRC-E5C913 | Adriatic Aero Alloys d.o.o. | Slovenia | 15-5PH | AMS 5862 | Cond A | Plate | 394 | 500.2 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Adriatic qualifying-origin 15-5PH plate allocated to Rank 1 Raven. |
| REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | 2026-08-24 | LOT-6B2F39 | SRC-E5C913 | Adriatic Aero Alloys d.o.o. | Slovenia | 15-5PH | AMS 5862 | Cond A | Plate | 106.2 | 500.2 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Balance after Raven allocation; source is approved and qualifying. |
| REQ-F6B8 | Sable Emergency Egress Hinge Arm | 2 | 2026-08-26 | LOT-7E1C95 | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 6061 | AMS 4117 | T651 | Bar | 233 | 237.8 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Rank 2 Sable receives eligible 6061 AMS 4117 bar first. |
| REQ-M1X8 | Meridian Cabin Door Latch Hinge | 3 | 2026-09-21 | LOT-3A7C82 | SRC-7B2F60 | Great Lakes Plate & Bar Co | USA | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 512 | 765.6 | 253.6 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Exact 6061 plate, full cert/trace, approved US source. |
| REQ-D7R4 | Meridian Cabin Door Latch Hinge | 3 | 2026-09-18 | LOT-5B2E88 | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 323.9 | 323.9 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Rank 3 Meridian receives eligible 2024 extrusion first. |
| REQ-R7W2 | Meridian Cabin Door Latch Hinge | 3 | 2026-09-12 | LOT-2C9E14 | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 412 | 586.5 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Exact 7075-T651 plate; T7351 is not substituted. |
| REQ-G2J9 | Meridian Cabin Door Latch Hinge | 3 | 2026-09-16 | LOT-7E1C95 | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 6061 | AMS 4117 | T651 | Bar | 4.8 | 237.8 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Residual after higher-priority Sable allocation. |
| REQ-J5G7 | Tundra Cargo Door Stop Fitting | 4 | 2026-10-12 | LOT-8D4B19 | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 388.85 | 388.85 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Tundra receives first eligible 7075 extrusion lot. |
| REQ-J5G7 | Tundra Cargo Door Stop Fitting | 4 | 2026-10-12 | LOT-2E6B95 | SRC-7B2F60 | Great Lakes Plate & Bar Co | USA | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 66.15 | 335.4 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Second eligible US extrusion lot completes Tundra demand. |
| REQ-P2H6 | Tundra Cargo Door Stop Fitting | 4 | 2026-10-09 | LOT-6F2A87 | SRC-6E3F88 | Pohang Advanced Alloy | South Korea | 17-4PH | AMS 5604 | H1075 | Bar | 284 | 289 | 5 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Exact 17-4PH H1075 bar from approved qualifying country. |
| REQ-Q8L5 | Halcyon Service Door Hinge Bracket | 5 | 2026-11-02 | LOT-E8C520 | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 726 | 950.4 | 224.4 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Exact compliant 6061 plate; no allocation conflict. |
| REQ-N3K4 | Halcyon Service Door Hinge Bracket | 5 | 2026-11-05 | LOT-9C5F28 | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 301 | 385.95 | 84.95 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Exact compliant 2024-T351 plate. |
| REQ-S6P3 | Halcyon Service Door Hinge Bracket | 5 | 2026-11-04 | LOT-2C9E14 | SRC-9F2A41 | Cascade Rolled Products LLC | USA | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 174.5 | 586.5 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Remaining 7075-T651 plate after Meridian (higher priority). |
| REQ-A2F7 | Calder Overwing Hatch Hinge Set | 6 | 2026-11-16 | LOT-A1E9F4 | SRC-D14E8B | Tri-State Metals Distribution | USA | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 333 | 591.6 | 258.6 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Exact compliant 6061 plate; lower-priority Calder supplied from remaining eligible stock. |
| REQ-E9C1 | Calder Overwing Hatch Hinge Set | 6 | 2026-11-14 | LOT-2E6B95 | SRC-7B2F60 | Great Lakes Plate & Bar Co | USA | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 269.25 | 335.4 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Residual eligible extrusion after Tundra allocation. |
| REQ-H7D5 | Calder Overwing Hatch Hinge Set | 6 | 2026-11-13 | LOT-9A4F37 | SRC-58E1B3 | Brunderman Forge & Bar Inc | USA | 4340 | AMS 6415 | Annealed | Bar | 45 | 244 | 0 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Residual eligible 4340 bar after Raven allocation. |
| REQ-W9A3 | Calder Overwing Hatch Hinge Set | 6 | 2026-11-17 | LOT-C7A340 | SRC-7A6D52 | Hangzhou Precision Alloys Co | China | 15-5PH | AMS 5659 | H1025 | Bar | 147 | 252 | 105 | 3.1 + Full trace + no hold + Approved source/spec + program-origin eligible | Hangzhou CN lot is permitted for Calder only; no country restriction applies. |
Purchase Allocation
| Selected Quote Allocation by Requirement | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Quote quantities are not yield-adjusted because ENG-MSP §5 directs quoted material to be assessed against the same net usable requirement quantity. Planned coverage may be less than PO quantity where a MOQ applies. | ||||||||||||||
| Source: supplier quote matrix + AMSL + ENG-MSP Rev H + program schedule. | ||||||||||||||
| Requirement ID | Program | Priority | Need-By | Quote ID | Source ID | Quoted Receipt | Planned Coverage (usable lb) | Unit Price ($/lb) | Quoted Qty (lb) | Min Order (lb) | Cert | Melt Country | Eligibility Basis | Allocation Decision |
| REQ-H4A2 | Raven Cargo Door Actuation Hinge | 1 | 2026-08-10 | QTE-A3F91C | SRC-9F2A41 | 2026-07-30 | 325.4 | 9.4 | 600 | 250 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Completes Raven T7351 plate; US 3.1 quote arrives 11 days early. |
| REQ-B6N3 | Sable Emergency Egress Hinge Arm | 2 | 2026-08-22 | QTE-A3F91C | SRC-9F2A41 | 2026-07-30 | 268 | 9.4 | 600 | 250 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Completes Sable T7351 plate on same compliant US quote. |
| REQ-C9T1 | Raven Cargo Door Actuation Hinge | 1 | 2026-08-03 | QTE-8B3F19 | SRC-58E1B3 | 2026-07-26 | 176 | 14.2 | 250 | 150 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Only compliant timely 300M option for DFARS Raven. |
| REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | 2026-08-24 | QTE-3A9F18 | SRC-3B7C19 | 2026-08-06 | 323.8 | 11.75 | 900 | 400 | 3.1 | France | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Completes Sable 15-5PH plate from approved France mill. |
| REQ-V1D9 | Tundra Cargo Door Stop Fitting | 4 | 2026-10-06 | QTE-3A9F18 | SRC-3B7C19 | 2026-08-06 | 357 | 11.75 | 900 | 400 | 3.1 | France | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Covers Tundra 15-5PH plate from same compliant quote. |
| REQ-L8Q4 | Sable Emergency Egress Hinge Arm | 2 | 2026-08-28 | QTE-6D1B84 | SRC-58E1B3 | 2026-08-26 | 287 | 6.9 | 450 | 250 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Only selected compliant US 4340 plate for DFARS Sable; dated receipt is tight. |
| REQ-D7R4 | Meridian Cabin Door Latch Hinge | 3 | 2026-09-18 | QTE-2D7C64 | SRC-9F2A41 | 2026-08-02 | 23.1 | 7.6 | 400 | 200 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Completes Meridian 2024 extrusion; lower unit price than Tri-State. |
| REQ-Y8K2 | Tundra Cargo Door Stop Fitting | 4 | 2026-10-11 | QTE-2D7C64 | SRC-9F2A41 | 2026-08-02 | 213 | 7.6 | 400 | 200 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Covers Tundra 2024 extrusion on the same compliant US quote. |
| REQ-W3F9 | Meridian Cabin Door Latch Hinge | 3 | 2026-09-14 | QTE-2F8C41 | SRC-3B7C19 | 2026-08-09 | 198 | 9.85 | 300 | 150 | 3.1 | France | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | France-origin 15-5PH H1025 bar is compliant for Meridian CUST-EU. |
| REQ-G2J9 | Meridian Cabin Door Latch Hinge | 3 | 2026-09-16 | QTE-1A6E38 | SRC-9F2A41 | 2026-08-12 | 154.2 | 5.75 | 300 | 150 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Completes Meridian 6061 AMS 4117 bar from source approved for AMS 4117. |
| REQ-Z4V2 | Halcyon Service Door Hinge Bracket | 5 | 2026-11-01 | QTE-9A2E57 | SRC-C2F9A7 | 2026-08-18 | 389 | 5.45 | 500 | 250 | 3.1 | China | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Approved CN-source 4340 plate is allowed for unrestricted Halcyon only. |
| REQ-S6P3 | Halcyon Service Door Hinge Bracket | 5 | 2026-11-04 | QTE-9E4B27 | SRC-9F2A41 | 2026-08-04 | 69.5 | 8.7 | 500 | 250 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Completes Halcyon 7075-T651 plate; minimum order drives excess stock. |
| REQ-E9C1 | Calder Overwing Hatch Hinge Set | 6 | 2026-11-14 | QTE-C1E7B4 | SRC-9F2A41 | 2026-08-03 | 1.75 | 8.9 | 500 | 250 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Completes Calder 7075 extrusion; minimum order drives excess stock. |
| REQ-U4B8 | Calder Overwing Hatch Hinge Set | 6 | 2026-11-18 | QTE-7E2A85 | SRC-E5C913 | 2026-08-15 | 162 | 11.1 | 250 | 150 | 3.1 | Slovenia | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Selected over lower-unit-price Pohang due to lower required PO quantity and total spend. |
| REQ-H7D5 | Calder Overwing Hatch Hinge Set | 6 | 2026-11-13 | QTE-D9F3B1 | SRC-7B2F60 | 2026-07-23 | 160 | 5.35 | 500 | 250 | 3.1 | USA | Exact match + 3.1 + Approved source/spec + program-origin eligible + receipt before need-by | Completes Calder 4340 bar; 250-lb MOQ yields lower total spend than 300-lb MOQ alternative. |
Inventory Lots
| Inventory Lot Usability Assessment | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Generic compliance is assessed before program-specific country rules. A lot may be generically compliant yet ineligible for a particular DFARS or CUST-EU program; see Inventory Req Eligibility. | |||||||||||||||||||||||
| Source: inventory_lot_cert_snapshot.xlsx / Lot Snapshot, joined to approved_material_source_list.xlsx / Source List; usable quantity formula per inventory README and ENG-MSP §5. | |||||||||||||||||||||||
| Lot ID | Heat / Cast | Alloy | Material Spec | Temper / Condition | Product Form | Source ID | Source Name | Melt Country | Source Status | Cert Type | Traceability | Hold Status | On Hand (lb) | Existing Allocation (lb) | Free Raw (lb) | Yield Factor | Yield-Adjusted Usable (lb) | Generic Compliance | Generic Compliance Issue | Exact Candidate Requirement(s) | Planned Allocation (usable lb) | Remaining Usable (lb) | Source / Basis |
| LOT-C7A340 | HEAT-9F1B66 | 15-5PH | AMS 5659 | H1025 | Bar | SRC-7A6D52 | Hangzhou Precision Alloys Co | China | Approved | 3.1 | Full | None | 360 | 60 | 300 | 0.84 | 252 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-W3F9, REQ-W9A3 | 147 | 105 | Inventory snapshot + AMSL |
| LOT-3E8C71 | HEAT-7A2F94 | 4340 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | Brunderman Forge & Bar Inc | USA | Approved | 3.1 | Full | None | 520 | 0 | 520 | 0.8 | 416 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-K9P1, REQ-H7D5 | 416 | 0 | Inventory snapshot + AMSL |
| LOT-8D4B19 | HEAT-1C9E37 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | SRC-9F2A41 | Cascade Rolled Products LLC | USA | Approved | 3.1 | Full | None | 600 | 95 | 505 | 0.77 | 388.85 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-J5G7, REQ-E9C1 | 388.85 | 0 | Inventory snapshot + AMSL |
| LOT-2C9E14 | HEAT-4A1F60 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | SRC-9F2A41 | Cascade Rolled Products LLC | USA | Approved | 3.1 | Full | None | 690 | 0 | 690 | 0.85 | 586.5 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-R7W2, REQ-S6P3 | 586.5 | 0 | Inventory snapshot + AMSL |
| LOT-3A7C82 | HEAT-5B1E94 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-7B2F60 | Great Lakes Plate & Bar Co | USA | Approved | 3.1 | Full | None | 880 | 0 | 880 | 0.87 | 765.6 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-M1X8, REQ-Q8L5, REQ-A2F7 | 512 | 253.6 | Inventory snapshot + AMSL |
| LOT-7F3A2B | HEAT-9D4E7B | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-9F2A41 | Cascade Rolled Products LLC | USA | Approved | 3.1 | Full | None | 1040 | 410 | 630 | 0.82 | 516.6 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-H4A2, REQ-B6N3 | 516.6 | 0 | Inventory snapshot + AMSL |
| LOT-A1E9F4 | HEAT-4C7D29 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-D14E8B | Tri-State Metals Distribution | USA | Approved | 3.1 | Full | None | 980 | 300 | 680 | 0.87 | 591.6 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-M1X8, REQ-Q8L5, REQ-A2F7 | 333 | 258.6 | Inventory snapshot + AMSL |
| LOT-D6B821 | HEAT-1E7C93 | 4340 | AMS 6415 | Annealed | Bar | SRC-D14E8B | Tri-State Metals Distribution | USA | Approved | C of C | Full | None | 880 | 120 | 760 | 0.78 | 592.8 | Ineligible | C of C only; 3.1/3.2 required | REQ-K9P1, REQ-H7D5 | 0 | 592.8 | Inventory snapshot + AMSL |
| LOT-E8C520 | HEAT-2A6B74 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-9F2A41 | Cascade Rolled Products LLC | USA | Approved | 3.1 | Full | None | 1320 | 240 | 1080 | 0.88 | 950.4 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-M1X8, REQ-Q8L5, REQ-A2F7 | 726 | 224.4 | Inventory snapshot + AMSL |
| LOT-9C5F28 | HEAT-3F6D17 | 2024 | AMS-QQ-A-250/4 | T351 | Plate | SRC-9F2A41 | Cascade Rolled Products LLC | USA | Approved | 3.1 | Full | None | 540 | 75 | 465 | 0.83 | 385.95 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-N3K4 | 301 | 84.95 | Inventory snapshot + AMSL |
| LOT-5C9A16 | HEAT-7E2B58 | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-7A6D52 | Hangzhou Precision Alloys Co | China | Approved | 3.1 | Full | None | 920 | 0 | 920 | 0.8 | 736 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-H4A2, REQ-B6N3 | 0 | 736 | Inventory snapshot + AMSL |
| LOT-7E1C95 | HEAT-2D5A83 | 6061 | AMS 4117 | T651 | Bar | SRC-9F2A41 | Cascade Rolled Products LLC | USA | Approved | 3.1 | Full | None | 330 | 40 | 290 | 0.82 | 237.8 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-F6B8, REQ-G2J9 | 237.8 | 0 | Inventory snapshot + AMSL |
| LOT-5B2E88 | HEAT-3D8F52 | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | SRC-9F2A41 | Cascade Rolled Products LLC | USA | Approved | 3.1 | Full | None | 410 | 0 | 410 | 0.79 | 323.9 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-D7R4, REQ-Y8K2 | 323.9 | 0 | Inventory snapshot + AMSL |
| LOT-2E6B95 | HEAT-7D3F28 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | SRC-7B2F60 | Great Lakes Plate & Bar Co | USA | Approved | 3.1 | Full | None | 430 | 0 | 430 | 0.78 | 335.4 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-J5G7, REQ-E9C1 | 335.4 | 0 | Inventory snapshot + AMSL |
| LOT-B3E7C0 | HEAT-5F9A21 | 15-5PH | AMS 5862 | Cond A | Plate | SRC-3B7C19 | Ardenne Steelworks SA | France | Approved | 3.1 | Full | Quality Hold - MRB | 1180 | 0 | 1180 | 0.83 | 979.4 | Ineligible | Quality Hold - MRB | REQ-X5M3, REQ-T2C7, REQ-V1D9 | 0 | 979.4 | Inventory snapshot + AMSL |
| LOT-2B7E54 | HEAT-8E1A49 | 300M | AMS 6419 | Annealed | Bar | SRC-C2F9A7 | Yellow River Specialty Steel | China | Approved | 3.1 | Full | None | 290 | 0 | 290 | 0.74 | 214.6 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-C9T1 | 0 | 214.6 | Inventory snapshot + AMSL |
| LOT-8F4D17 | HEAT-1A9C63 | 17-4PH | AMS 5604 | H1075 | Bar | SRC-3B7C19 | Ardenne Steelworks SA | France | Approved | 3.1 | Full | Quality Hold - Recv Insp | 250 | 0 | 250 | 0.85 | 212.5 | Ineligible | Quality Hold - Recv Insp | REQ-P2H6, REQ-U4B8 | 0 | 212.5 | Inventory snapshot + AMSL |
| LOT-1D6B43 | HEAT-9A4E72 | 15-5PH | AMS 5862 | Cond A | Plate | SRC-2D8B96 | Volga Forged Steel OAO | Russia | Not Approved | 3.1 | Full | None | 800 | 0 | 800 | 0.83 | 664 | Ineligible | source status Not Approved | REQ-X5M3, REQ-T2C7, REQ-V1D9 | 0 | 664 | Inventory snapshot + AMSL |
| LOT-6F2A87 | HEAT-5D3B81 | 17-4PH | AMS 5604 | H1075 | Bar | SRC-6E3F88 | Pohang Advanced Alloy | South Korea | Approved | 3.1 | Full | None | 470 | 130 | 340 | 0.85 | 289 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-P2H6, REQ-U4B8 | 284 | 5 | Inventory snapshot + AMSL |
| LOT-1F9D63 | HEAT-6E4C18 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-A47C21 | Meridian Metal Service Center | USA | Suspended | 3.1 | Partial - heat not traceable | None | 760 | 0 | 760 | 0.86 | 653.6 | Ineligible | traceability not Full; source status Suspended | REQ-M1X8, REQ-Q8L5, REQ-A2F7 | 0 | 653.6 | Inventory snapshot + AMSL |
| LOT-4A8D62 | HEAT-6B9C40 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | SRC-D14E8B | Tri-State Metals Distribution | USA | Approved | C of C | Full | None | 700 | 0 | 700 | 0.84 | 588 | Ineligible | C of C only; 3.1/3.2 required | REQ-R7W2, REQ-S6P3 | 0 | 588 | Inventory snapshot + AMSL |
| LOT-4D1A95 | HEAT-8C3E47 | 15-5PH | AMS 5862 | Cond A | Plate | SRC-B9D472 | Lone Star Aerospace Metals | USA | Conditional | 3.1 | Full | None | 540 | 0 | 540 | 0.81 | 437.4 | Ineligible | source status Conditional | REQ-X5M3, REQ-T2C7, REQ-V1D9 | 0 | 437.4 | Inventory snapshot + AMSL |
| LOT-6B2F39 | HEAT-2C8D71 | 15-5PH | AMS 5862 | Cond A | Plate | SRC-E5C913 | Adriatic Aero Alloys d.o.o. | Slovenia | Approved | 3.1 | Full | None | 610 | 0 | 610 | 0.82 | 500.2 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-X5M3, REQ-T2C7, REQ-V1D9 | 500.2 | 0 | Inventory snapshot + AMSL |
| LOT-9A4F37 | HEAT-7B2D58 | 4340 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | Brunderman Forge & Bar Inc | USA | Approved | 3.1 | Full | None | 305 | 0 | 305 | 0.8 | 244 | Eligible pending program origin | Meets generic cert, trace, hold, and approved-source controls | REQ-K9P1, REQ-H7D5 | 244 | 0 | Inventory snapshot + AMSL |
Inventory Req Eligibility
| Inventory Lot-to-Requirement Eligibility Matrix | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| One row appears for every inventory lot with an exact alloy/spec/temper/form match to a forecast requirement. This makes program-specific country restrictions visible rather than treating physical stock as automatically usable. | |||||||||||||||
| Source: inventory lot snapshot; AMSL; program schedule; ENG-MSP Rev H. | |||||||||||||||
| Lot ID | Requirement ID | Program | Priority | Country Rule | Melt Country | Exact Material Match | 3.1/3.2 Cert | Full Trace | No Hold | Source Approved / Spec | Program Origin Eligible | Usable Available (lb) | Overall Eligible | Planned Allocation (usable lb) | Decision / Reason |
| LOT-C7A340 | REQ-W3F9 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | China | Y | Y | Y | Y | Y | N | 252 | N | 0 | Melt origin China is not permitted for CUST-EU |
| LOT-C7A340 | REQ-W9A3 | Calder Overwing Hatch Hinge Set | 6 | None | China | Y | Y | Y | Y | Y | Y | 252 | Y | 147 | Selected in allocation plan |
| LOT-3E8C71 | REQ-K9P1 | Raven Cargo Door Actuation Hinge | 1 | DFARS | USA | Y | Y | Y | Y | Y | Y | 416 | Y | 416 | Selected in allocation plan |
| LOT-3E8C71 | REQ-H7D5 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | Y | Y | Y | Y | Y | 416 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-8D4B19 | REQ-J5G7 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 388.85 | Y | 388.85 | Selected in allocation plan |
| LOT-8D4B19 | REQ-E9C1 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | Y | Y | Y | Y | Y | 388.85 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-2C9E14 | REQ-R7W2 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 586.5 | Y | 412 | Selected in allocation plan |
| LOT-2C9E14 | REQ-S6P3 | Halcyon Service Door Hinge Bracket | 5 | None | USA | Y | Y | Y | Y | Y | Y | 586.5 | Y | 174.5 | Selected in allocation plan |
| LOT-3A7C82 | REQ-M1X8 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 765.6 | Y | 512 | Selected in allocation plan |
| LOT-3A7C82 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket | 5 | None | USA | Y | Y | Y | Y | Y | Y | 765.6 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-3A7C82 | REQ-A2F7 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | Y | Y | Y | Y | Y | 765.6 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-7F3A2B | REQ-H4A2 | Raven Cargo Door Actuation Hinge | 1 | DFARS | USA | Y | Y | Y | Y | Y | Y | 516.6 | Y | 516.6 | Selected in allocation plan |
| LOT-7F3A2B | REQ-B6N3 | Sable Emergency Egress Hinge Arm | 2 | DFARS | USA | Y | Y | Y | Y | Y | Y | 516.6 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-A1E9F4 | REQ-M1X8 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 591.6 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-A1E9F4 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket | 5 | None | USA | Y | Y | Y | Y | Y | Y | 591.6 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-A1E9F4 | REQ-A2F7 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | Y | Y | Y | Y | Y | 591.6 | Y | 333 | Selected in allocation plan |
| LOT-D6B821 | REQ-K9P1 | Raven Cargo Door Actuation Hinge | 1 | DFARS | USA | Y | N | Y | Y | Y | Y | 592.8 | N | 0 | C of C only; 3.1/3.2 required |
| LOT-D6B821 | REQ-H7D5 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | N | Y | Y | Y | Y | 592.8 | N | 0 | C of C only; 3.1/3.2 required |
| LOT-E8C520 | REQ-M1X8 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 950.4 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-E8C520 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket | 5 | None | USA | Y | Y | Y | Y | Y | Y | 950.4 | Y | 726 | Selected in allocation plan |
| LOT-E8C520 | REQ-A2F7 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | Y | Y | Y | Y | Y | 950.4 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-9C5F28 | REQ-N3K4 | Halcyon Service Door Hinge Bracket | 5 | None | USA | Y | Y | Y | Y | Y | Y | 385.95 | Y | 301 | Selected in allocation plan |
| LOT-5C9A16 | REQ-H4A2 | Raven Cargo Door Actuation Hinge | 1 | DFARS | China | Y | Y | Y | Y | Y | N | 736 | N | 0 | Melt origin China is not permitted for DFARS |
| LOT-5C9A16 | REQ-B6N3 | Sable Emergency Egress Hinge Arm | 2 | DFARS | China | Y | Y | Y | Y | Y | N | 736 | N | 0 | Melt origin China is not permitted for DFARS |
| LOT-7E1C95 | REQ-F6B8 | Sable Emergency Egress Hinge Arm | 2 | DFARS | USA | Y | Y | Y | Y | Y | Y | 237.8 | Y | 233 | Selected in allocation plan |
| LOT-7E1C95 | REQ-G2J9 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 237.8 | Y | 4.8 | Selected in allocation plan |
| LOT-5B2E88 | REQ-D7R4 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 323.9 | Y | 323.9 | Selected in allocation plan |
| LOT-5B2E88 | REQ-Y8K2 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 323.9 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-2E6B95 | REQ-J5G7 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | USA | Y | Y | Y | Y | Y | Y | 335.4 | Y | 66.15 | Selected in allocation plan |
| LOT-2E6B95 | REQ-E9C1 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | Y | Y | Y | Y | Y | 335.4 | Y | 269.25 | Selected in allocation plan |
| LOT-B3E7C0 | REQ-X5M3 | Raven Cargo Door Actuation Hinge | 1 | DFARS | France | Y | Y | Y | N | Y | Y | 979.4 | N | 0 | Quality Hold - MRB |
| LOT-B3E7C0 | REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | DFARS | France | Y | Y | Y | N | Y | Y | 979.4 | N | 0 | Quality Hold - MRB |
| LOT-B3E7C0 | REQ-V1D9 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | France | Y | Y | Y | N | Y | Y | 979.4 | N | 0 | Quality Hold - MRB |
| LOT-2B7E54 | REQ-C9T1 | Raven Cargo Door Actuation Hinge | 1 | DFARS | China | Y | Y | Y | Y | Y | N | 214.6 | N | 0 | Melt origin China is not permitted for DFARS |
| LOT-8F4D17 | REQ-P2H6 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | France | Y | Y | Y | N | Y | Y | 212.5 | N | 0 | Quality Hold - Recv Insp |
| LOT-8F4D17 | REQ-U4B8 | Calder Overwing Hatch Hinge Set | 6 | None | France | Y | Y | Y | N | Y | Y | 212.5 | N | 0 | Quality Hold - Recv Insp |
| LOT-1D6B43 | REQ-X5M3 | Raven Cargo Door Actuation Hinge | 1 | DFARS | Russia | Y | Y | Y | Y | N | N | 664 | N | 0 | source status Not Approved |
| LOT-1D6B43 | REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | DFARS | Russia | Y | Y | Y | Y | N | N | 664 | N | 0 | source status Not Approved |
| LOT-1D6B43 | REQ-V1D9 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | Russia | Y | Y | Y | Y | N | N | 664 | N | 0 | source status Not Approved |
| LOT-6F2A87 | REQ-P2H6 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | South Korea | Y | Y | Y | Y | Y | Y | 289 | Y | 284 | Selected in allocation plan |
| LOT-6F2A87 | REQ-U4B8 | Calder Overwing Hatch Hinge Set | 6 | None | South Korea | Y | Y | Y | Y | Y | Y | 289 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-1F9D63 | REQ-M1X8 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | USA | Y | Y | N | Y | N | Y | 653.6 | N | 0 | traceability not Full; source status Suspended |
| LOT-1F9D63 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket | 5 | None | USA | Y | Y | N | Y | N | Y | 653.6 | N | 0 | traceability not Full; source status Suspended |
| LOT-1F9D63 | REQ-A2F7 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | Y | N | Y | N | Y | 653.6 | N | 0 | traceability not Full; source status Suspended |
| LOT-4A8D62 | REQ-R7W2 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | USA | Y | N | Y | Y | Y | Y | 588 | N | 0 | C of C only; 3.1/3.2 required |
| LOT-4A8D62 | REQ-S6P3 | Halcyon Service Door Hinge Bracket | 5 | None | USA | Y | N | Y | Y | Y | Y | 588 | N | 0 | C of C only; 3.1/3.2 required |
| LOT-4D1A95 | REQ-X5M3 | Raven Cargo Door Actuation Hinge | 1 | DFARS | USA | Y | Y | Y | Y | N | Y | 437.4 | N | 0 | source status Conditional |
| LOT-4D1A95 | REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | DFARS | USA | Y | Y | Y | Y | N | Y | 437.4 | N | 0 | source status Conditional |
| LOT-4D1A95 | REQ-V1D9 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | USA | Y | Y | Y | Y | N | Y | 437.4 | N | 0 | source status Conditional |
| LOT-6B2F39 | REQ-X5M3 | Raven Cargo Door Actuation Hinge | 1 | DFARS | Slovenia | Y | Y | Y | Y | Y | Y | 500.2 | Y | 394 | Selected in allocation plan |
| LOT-6B2F39 | REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | DFARS | Slovenia | Y | Y | Y | Y | Y | Y | 500.2 | Y | 106.2 | Selected in allocation plan |
| LOT-6B2F39 | REQ-V1D9 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | Slovenia | Y | Y | Y | Y | Y | Y | 500.2 | Y | 0 | Eligible but not selected; inventory is allocated by priority or not needed |
| LOT-9A4F37 | REQ-K9P1 | Raven Cargo Door Actuation Hinge | 1 | DFARS | USA | Y | Y | Y | Y | Y | Y | 244 | Y | 199 | Selected in allocation plan |
| LOT-9A4F37 | REQ-H7D5 | Calder Overwing Hatch Hinge Set | 6 | None | USA | Y | Y | Y | Y | Y | Y | 244 | Y | 45 | Selected in allocation plan |
Quote Feasibility
| Supplier Quote Feasibility Matrix | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Only exact material matches are shown. ‘Overall Feasible’ uses documented compliance and receipt-before-need-by tests; any unquantified inspection margin remains a decision risk, highlighted for REQ-L8Q4. | |||||||||||||||||||||||||
| Source: supplier_quote_leadtime_matrix.xlsx / Quote Matrix, AMSL, ENG-MSP Rev H, and program priority/build schedule. | |||||||||||||||||||||||||
| Quote ID | Requirement ID | Program | Priority | Country Rule | Alloy | Material Spec | Temper / Condition | Product Form | Quoted Qty (lb) | MOQ (lb) | Cert Offered | Cert Eligible | Source ID | Source Status | Source Spec Eligible | Melt Country | Origin Eligible | Quoted Receipt | Need-By | Days Early | Dated Timing | Quote Expiry | Overall Feasible | Selected | Decision / Reason |
| QTE-8B3F19 | REQ-C9T1 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 300M | AMS 6419 | Annealed | Bar | 250 | 150 | 3.1 | Y | SRC-58E1B3 | Approved | Y | USA | Y | 2026-07-26 | 2026-08-03 | 8 | Before need-by | 2026-07-14 | Y | Y | Selected in purchase plan |
| QTE-7C3A95 | REQ-N3K4 | Halcyon Service Door Hinge Bracket | 5 | None | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 400 | 200 | 3.1 | Y | SRC-D14E8B | Approved | Y | USA | Y | 2026-09-22 | 2026-11-05 | 44 | Before need-by | 2026-09-05 | Y | N | receipt on/after need-by |
| QTE-3A9F18 | REQ-X5M3 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 900 | 400 | 3.1 | Y | SRC-3B7C19 | Approved | Y | France | Y | 2026-08-06 | 2026-08-12 | 6 | Before need-by | 2026-07-20 | Y | N | receipt on/after need-by |
| QTE-3A9F18 | REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 900 | 400 | 3.1 | Y | SRC-3B7C19 | Approved | Y | France | Y | 2026-08-06 | 2026-08-24 | 18 | Before need-by | 2026-07-20 | Y | Y | Selected in purchase plan |
| QTE-3A9F18 | REQ-V1D9 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 900 | 400 | 3.1 | Y | SRC-3B7C19 | Approved | Y | France | Y | 2026-08-06 | 2026-10-06 | 61 | Before need-by | 2026-07-20 | Y | Y | Selected in purchase plan |
| QTE-F1C8A6 | REQ-H4A2 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 450 | 250 | 3.1 | Y | SRC-7B2F60 | Approved | Y | USA | Y | 2026-08-14 | 2026-08-10 | -4 | On/after need-by | 2026-07-18 | N | N | receipt on/after need-by |
| QTE-F1C8A6 | REQ-B6N3 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 450 | 250 | 3.1 | Y | SRC-7B2F60 | Approved | Y | USA | Y | 2026-08-14 | 2026-08-22 | 8 | Before need-by | 2026-07-18 | Y | N | receipt on/after need-by |
| QTE-9C4E27 | REQ-X5M3 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 1000 | 500 | 3.1 | Y | SRC-2D8B96 | Not Approved | N | Russia | N | 2026-07-28 | 2026-08-12 | 15 | Before need-by | 2026-07-18 | N | N | source status Not Approved; origin Russia not allowed for DFARS; receipt on/after need-by |
| QTE-9C4E27 | REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 1000 | 500 | 3.1 | Y | SRC-2D8B96 | Not Approved | N | Russia | N | 2026-07-28 | 2026-08-24 | 27 | Before need-by | 2026-07-18 | N | N | source status Not Approved; origin Russia not allowed for DFARS; receipt on/after need-by |
| QTE-9C4E27 | REQ-V1D9 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 1000 | 500 | 3.1 | Y | SRC-2D8B96 | Not Approved | N | Russia | N | 2026-07-28 | 2026-10-06 | 70 | Before need-by | 2026-07-18 | N | N | source status Not Approved; origin Russia not allowed for CUST-EU; receipt on/after need-by |
| QTE-2A7E61 | REQ-M1X8 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 650 | 300 | 3.1 | Y | SRC-7B2F60 | Approved | Y | USA | Y | 2026-08-12 | 2026-09-21 | 40 | Before need-by | 2026-07-28 | Y | N | receipt on/after need-by |
| QTE-2A7E61 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket | 5 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 650 | 300 | 3.1 | Y | SRC-7B2F60 | Approved | Y | USA | Y | 2026-08-12 | 2026-11-02 | 82 | Before need-by | 2026-07-28 | Y | N | receipt on/after need-by |
| QTE-2A7E61 | REQ-A2F7 | Calder Overwing Hatch Hinge Set | 6 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 650 | 300 | 3.1 | Y | SRC-7B2F60 | Approved | Y | USA | Y | 2026-08-12 | 2026-11-16 | 96 | Before need-by | 2026-07-28 | Y | N | receipt on/after need-by |
| QTE-5F1B83 | REQ-M1X8 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 800 | 300 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-25 | 2026-09-21 | 27 | Before need-by | 2026-08-01 | Y | N | receipt on/after need-by |
| QTE-5F1B83 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket | 5 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 800 | 300 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-25 | 2026-11-02 | 69 | Before need-by | 2026-08-01 | Y | N | receipt on/after need-by |
| QTE-5F1B83 | REQ-A2F7 | Calder Overwing Hatch Hinge Set | 6 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 800 | 300 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-25 | 2026-11-16 | 83 | Before need-by | 2026-08-01 | Y | N | receipt on/after need-by |
| QTE-1E8C57 | REQ-K9P1 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 4340 | AMS 6415 | Annealed | Bar | 650 | 300 | 3.1 | Y | SRC-58E1B3 | Approved | Y | USA | Y | 2026-07-25 | 2026-08-05 | 11 | Before need-by | 2026-07-12 | Y | N | receipt on/after need-by |
| QTE-1E8C57 | REQ-H7D5 | Calder Overwing Hatch Hinge Set | 6 | None | 4340 | AMS 6415 | Annealed | Bar | 650 | 300 | 3.1 | Y | SRC-58E1B3 | Approved | Y | USA | Y | 2026-07-25 | 2026-11-13 | 111 | Before need-by | 2026-07-12 | Y | N | receipt on/after need-by |
| QTE-8C3D49 | REQ-M1X8 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 900 | 300 | 3.1 | Y | SRC-D14E8B | Approved | Y | USA | Y | 2026-07-31 | 2026-09-21 | 52 | Before need-by | 2026-07-21 | Y | N | receipt on/after need-by |
| QTE-8C3D49 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket | 5 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 900 | 300 | 3.1 | Y | SRC-D14E8B | Approved | Y | USA | Y | 2026-07-31 | 2026-11-02 | 94 | Before need-by | 2026-07-21 | Y | N | receipt on/after need-by |
| QTE-8C3D49 | REQ-A2F7 | Calder Overwing Hatch Hinge Set | 6 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 900 | 300 | 3.1 | Y | SRC-D14E8B | Approved | Y | USA | Y | 2026-07-31 | 2026-11-16 | 108 | Before need-by | 2026-07-21 | Y | N | receipt on/after need-by |
| QTE-7E2A85 | REQ-P2H6 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | 250 | 150 | 3.1 | Y | SRC-E5C913 | Approved | Y | Slovenia | Y | 2026-08-15 | 2026-10-09 | 55 | Before need-by | 2026-07-23 | Y | N | receipt on/after need-by |
| QTE-7E2A85 | REQ-U4B8 | Calder Overwing Hatch Hinge Set | 6 | None | 17-4PH | AMS 5604 | H1075 | Bar | 250 | 150 | 3.1 | Y | SRC-E5C913 | Approved | Y | Slovenia | Y | 2026-08-15 | 2026-11-18 | 95 | Before need-by | 2026-07-23 | Y | Y | Selected in purchase plan |
| QTE-9B4F27 | REQ-D7R4 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 350 | 200 | 3.1 | Y | SRC-D14E8B | Approved | Y | USA | Y | 2026-07-24 | 2026-09-18 | 56 | Before need-by | 2026-07-15 | Y | N | receipt on/after need-by |
| QTE-9B4F27 | REQ-Y8K2 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 350 | 200 | 3.1 | Y | SRC-D14E8B | Approved | Y | USA | Y | 2026-07-24 | 2026-10-11 | 79 | Before need-by | 2026-07-15 | Y | N | receipt on/after need-by |
| QTE-7D2B40 | REQ-H4A2 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 800 | 400 | 3.1 | Y | SRC-7A6D52 | Approved | Y | China | N | 2026-07-22 | 2026-08-10 | 19 | Before need-by | 2026-07-10 | N | N | origin China not allowed for DFARS; receipt on/after need-by |
| QTE-7D2B40 | REQ-B6N3 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 800 | 400 | 3.1 | Y | SRC-7A6D52 | Approved | Y | China | N | 2026-07-22 | 2026-08-22 | 31 | Before need-by | 2026-07-10 | N | N | origin China not allowed for DFARS; receipt on/after need-by |
| QTE-3F7D92 | REQ-F6B8 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 6061 | AMS 4117 | T651 | Bar | 250 | 150 | 3.1 | Y | SRC-7B2F60 | Approved | N | USA | Y | 2026-08-08 | 2026-08-26 | 18 | Before need-by | 2026-07-24 | N | N | source not approved for spec family; receipt on/after need-by |
| QTE-3F7D92 | REQ-G2J9 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 6061 | AMS 4117 | T651 | Bar | 250 | 150 | 3.1 | Y | SRC-7B2F60 | Approved | N | USA | Y | 2026-08-08 | 2026-09-16 | 39 | Before need-by | 2026-07-24 | N | N | source not approved for spec family; receipt on/after need-by |
| QTE-A3F91C | REQ-H4A2 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 600 | 250 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-07-30 | 2026-08-10 | 11 | Before need-by | 2026-07-15 | Y | Y | Selected in purchase plan |
| QTE-A3F91C | REQ-B6N3 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 600 | 250 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-07-30 | 2026-08-22 | 23 | Before need-by | 2026-07-15 | Y | Y | Selected in purchase plan |
| QTE-4C8F12 | REQ-R7W2 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 400 | 250 | 3.1 | Y | SRC-7B2F60 | Approved | Y | USA | Y | 2026-08-01 | 2026-09-12 | 42 | Before need-by | 2026-07-18 | Y | N | receipt on/after need-by |
| QTE-4C8F12 | REQ-S6P3 | Halcyon Service Door Hinge Bracket | 5 | None | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 400 | 250 | 3.1 | Y | SRC-7B2F60 | Approved | Y | USA | Y | 2026-08-01 | 2026-11-04 | 95 | Before need-by | 2026-07-18 | Y | N | receipt on/after need-by |
| QTE-6F1A93 | REQ-X5M3 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 600 | 300 | 3.1 | Y | SRC-B9D472 | Conditional | N | USA | Y | 2026-07-26 | 2026-08-12 | 17 | Before need-by | 2026-07-19 | N | N | source status Conditional; receipt on/after need-by |
| QTE-6F1A93 | REQ-T2C7 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 600 | 300 | 3.1 | Y | SRC-B9D472 | Conditional | N | USA | Y | 2026-07-26 | 2026-08-24 | 29 | Before need-by | 2026-07-19 | N | N | source status Conditional; receipt on/after need-by |
| QTE-6F1A93 | REQ-V1D9 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 600 | 300 | 3.1 | Y | SRC-B9D472 | Conditional | N | USA | Y | 2026-07-26 | 2026-10-06 | 72 | Before need-by | 2026-07-19 | N | N | source status Conditional; receipt on/after need-by |
| QTE-1A6E38 | REQ-F6B8 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 6061 | AMS 4117 | T651 | Bar | 300 | 150 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-12 | 2026-08-26 | 14 | Before need-by | 2026-07-25 | Y | N | receipt on/after need-by |
| QTE-1A6E38 | REQ-G2J9 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 6061 | AMS 4117 | T651 | Bar | 300 | 150 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-12 | 2026-09-16 | 35 | Before need-by | 2026-07-25 | Y | Y | Selected in purchase plan |
| QTE-8A1D63 | REQ-W3F9 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 15-5PH | AMS 5659 | H1025 | Bar | 350 | 150 | 3.1 | Y | SRC-7A6D52 | Approved | Y | China | N | 2026-07-27 | 2026-09-14 | 49 | Before need-by | 2026-07-17 | N | N | origin China not allowed for CUST-EU; receipt on/after need-by |
| QTE-8A1D63 | REQ-W9A3 | Calder Overwing Hatch Hinge Set | 6 | None | 15-5PH | AMS 5659 | H1025 | Bar | 350 | 150 | 3.1 | Y | SRC-7A6D52 | Approved | Y | China | Y | 2026-07-27 | 2026-11-17 | 113 | Before need-by | 2026-07-17 | Y | N | receipt on/after need-by |
| QTE-6D1B84 | REQ-L8Q4 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 4340 | AMS 6359 | Norm | Plate | 450 | 250 | 3.1 | Y | SRC-58E1B3 | Approved | Y | USA | Y | 2026-08-26 | 2026-08-28 | 2 | Before need-by | 2026-08-05 | Y | Y | Selected in purchase plan |
| QTE-6D1B84 | REQ-Z4V2 | Halcyon Service Door Hinge Bracket | 5 | None | 4340 | AMS 6359 | Norm | Plate | 450 | 250 | 3.1 | Y | SRC-58E1B3 | Approved | Y | USA | Y | 2026-08-26 | 2026-11-01 | 67 | Before need-by | 2026-08-05 | Y | N | receipt on/after need-by |
| QTE-6A2D58 | REQ-P2H6 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | 350 | 200 | 3.1 | Y | SRC-6E3F88 | Approved | Y | South Korea | Y | 2026-08-04 | 2026-10-09 | 66 | Before need-by | 2026-07-21 | Y | N | receipt on/after need-by |
| QTE-6A2D58 | REQ-U4B8 | Calder Overwing Hatch Hinge Set | 6 | None | 17-4PH | AMS 5604 | H1075 | Bar | 350 | 200 | 3.1 | Y | SRC-6E3F88 | Approved | Y | South Korea | Y | 2026-08-04 | 2026-11-18 | 106 | Before need-by | 2026-07-21 | Y | N | receipt on/after need-by |
| QTE-2F8C41 | REQ-W3F9 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 15-5PH | AMS 5659 | H1025 | Bar | 300 | 150 | 3.1 | Y | SRC-3B7C19 | Approved | Y | France | Y | 2026-08-09 | 2026-09-14 | 36 | Before need-by | 2026-07-23 | Y | Y | Selected in purchase plan |
| QTE-2F8C41 | REQ-W9A3 | Calder Overwing Hatch Hinge Set | 6 | None | 15-5PH | AMS 5659 | H1025 | Bar | 300 | 150 | 3.1 | Y | SRC-3B7C19 | Approved | Y | France | Y | 2026-08-09 | 2026-11-17 | 100 | Before need-by | 2026-07-23 | Y | N | receipt on/after need-by |
| QTE-5B9E41 | REQ-N3K4 | Halcyon Service Door Hinge Bracket | 5 | None | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 350 | 200 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-09-28 | 2026-11-05 | 38 | Before need-by | 2026-09-08 | Y | N | receipt on/after need-by |
| QTE-4E9A72 | REQ-C9T1 | Raven Cargo Door Actuation Hinge | 1 | DFARS | 300M | AMS 6419 | Annealed | Bar | 300 | 150 | 3.1 | Y | SRC-C2F9A7 | Approved | Y | China | N | 2026-07-19 | 2026-08-03 | 15 | Before need-by | 2026-07-09 | N | N | origin China not allowed for DFARS; receipt on/after need-by |
| QTE-C1E7B4 | REQ-J5G7 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 500 | 250 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-03 | 2026-10-12 | 70 | Before need-by | 2026-07-22 | Y | N | receipt on/after need-by |
| QTE-C1E7B4 | REQ-E9C1 | Calder Overwing Hatch Hinge Set | 6 | None | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 500 | 250 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-03 | 2026-11-14 | 103 | Before need-by | 2026-07-22 | Y | Y | Selected in purchase plan |
| QTE-2D7C64 | REQ-D7R4 | Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 400 | 200 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-02 | 2026-09-18 | 47 | Before need-by | 2026-07-19 | Y | Y | Selected in purchase plan |
| QTE-2D7C64 | REQ-Y8K2 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 400 | 200 | 3.1 | Y | SRC-9F2A41 | Approved | Y | USA | Y | 2026-08-02 | 2026-10-11 | 70 | Before need-by | 2026-07-19 | Y | Y | Selected in purchase plan |
| QTE-1F7C93 | REQ-P2H6 | Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | 300 | 150 | 3.1 | Y | SRC-3B7C19 | Approved | Y | France | Y | 2026-08-01 | 2026-10-09 | 69 | Before need-by | 2026-07-20 | Y | N | receipt on/after need-by |
| QTE-1F7C93 | REQ-U4B8 | Calder Overwing Hatch Hinge Set | 6 | None | 17-4PH | AMS 5604 | H1075 | Bar | 300 | 150 | 3.1 | Y | SRC-3B7C19 | Approved | Y | France | Y | 2026-08-01 | 2026-11-18 | 109 | Before need-by | 2026-07-20 | Y | N | receipt on/after need-by |
| QTE-9A2E57 | REQ-L8Q4 | Sable Emergency Egress Hinge Arm | 2 | DFARS | 4340 | AMS 6359 | Norm | Plate | 500 | 250 | 3.1 | Y | SRC-C2F9A7 | Approved | Y | China | N | 2026-08-18 | 2026-08-28 | 10 | Before need-by | 2026-08-02 | N | N | origin China not allowed for DFARS; receipt on/after need-by |
| QTE-9A2E57 | REQ-Z4V2 | Halcyon Service Door Hinge Bracket | 5 | None | 4340 | AMS 6359 | Norm | Plate | 500 | 250 | 3.1 | Y | SRC-C2F9A7 | Approved | Y | China | Y | 2026-08-18 | 2026-11-01 | 75 | Before need-by | 2026-08-02 | Y | Y | Selected in purchase plan |
Requirements Source
| Demand Forecast Source Data | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Verbatim source fields retained for audit traceability; formulas shown in supplier extended cost are re-expressed as source values for the working analysis. | |||||||||||
| Source: material_demand_forecast.xlsx / Demand Forecast | |||||||||||
| 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 |
Inventory Source
| Inventory Snapshot Source Data | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Verbatim source fields retained for audit traceability; formulas shown in supplier extended cost are re-expressed as source values for the working analysis. | ||||||||||||||||
| Source: inventory_lot_cert_snapshot.xlsx / Lot Snapshot | ||||||||||||||||
| 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.81 | 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 |
Quotes Source
| Supplier Quote Source Data | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Verbatim source fields retained for audit traceability; formulas shown in supplier extended cost are re-expressed as source values for the working analysis. | ||||||||||||||||
| Source: supplier_quote_leadtime_matrix.xlsx / Quote Matrix | ||||||||||||||||
| 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 |
AMSL Source
| Approved Material Source List | ||||||||
|---|---|---|---|---|---|---|---|---|
| Verbatim source fields retained for audit traceability; formulas shown in supplier extended cost are re-expressed as source values for the working analysis. | ||||||||
| Source: approved_material_source_list.xlsx / Source List | ||||||||
| 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 |
Program Schedule
| Program Priority & Build Schedule | |||||
|---|---|---|---|---|---|
| Verbatim source fields retained for audit traceability; formulas shown in supplier extended cost are re-expressed as source values for the working analysis. | |||||
| Source: program_priority_build_schedule.docx / Table 1 | |||||
| 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 | 2 | 2026-08-31 | DFARS |
| PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Aerolux Commercial | 3 | 2026-09-28 | CUST-EU |
| PRG-TUNDRA | Tundra Cargo Door Stop Fitting | Northwind Regional | 4 | 2026-10-19 | CUST-EU |
| PRG-HALCYON | Halcyon Service Door Hinge Bracket | Aerolux Commercial | 5 | 2026-11-09 | None |
| PRG-CALDER | Calder Overwing Hatch Hinge Set | Northwind Regional | 6 (lowest) | 2026-11-23 | None |
Policy Controls
| Engineering Material Substitution Policy — Applied Controls | ||
|---|---|---|
| Condensed operational controls from ENG-MSP Rev H. The policy itself remains the governing source; this sheet documents how the analysis applies its express requirements. | ||
| Source: engineering_material_substitution_policy.pdf / ENG-MSP Rev H, effective 2026-05-15. | ||
| Policy Section | Authoritative Rule Applied | Workbook Application |
| §1 — Authority | A lot or quote covers a requirement only when it exactly matches or falls within an enumerated allowance; anything else requires document-controlled deviation. | No alloy/spec/temper/form substitutions are used. No waiver, deviation, verbal approval, or unrecorded engineering instruction is assumed. |
| §2 — Cert / trace | 3.1 or 3.2 is minimum; C of C alone is insufficient. Full heat/cast trace is required. Open hold/MRB material is ineligible. | Excluded C of C inventory/quotes, partial traceability, and lots on Quality Hold / MRB. |
| §3 — Source / origin | Source must be Approved for applicable specification family; Conditional, Suspended, and Not Approved are ineligible for new commitments. DFARS must use qualifying origin; customer restrictions also govern. | Source status and spec scope checked for every lot/quote. DFARS and CUST-EU country rules applied by program. |
| §4 — Substitution | No cross-alloy, product-form, or 7075 T651/T7351 interchange. PH condition must match. Larger/remnant stock requires documented yield treatment. | Only exact match used. Larger/remnant usable quantities are limited to the provided lot yield factors. |
| §5 — Yield | Usable on-hand = (On Hand − Allocated) × documented yield factor. Quoted material is evaluated against net usable demand; partial coverage documented. | Inventory Lots sheet calculates usable amount; allocations do not exceed it. Purchase allocation records remaining net coverage demand without an invented quote yield factor. |
| §6 — Timing | Quote must precede need-by with inspection/processing margin; no expedite beyond documented quote may be assumed. | Dated timing is calculated per quote/requirement. QTE-6D1B84 is highlighted because it is only two days early and no numeric inspection margin is supplied. |
| §7 — Escalation | No eligible inventory or feasible compliant quote requires MRB and affected program office escalation; priority resolves contests. | Program priority governs shared inventory allocations. Timing/commercial gates and compliance blocks are listed in At-Risk & Escalations. |
Material Sourcing Recommendation Memo
2026 Q3 Door / Hinge Mechanism Build Wave
To
From
Review basis
Decision requested
Sourcing, Production, and Quality Leadership
Materials Sourcing Review
MRP forecast, WMS/QMS lot snapshot, AMSL, quote matrix, ENG-MSP Rev H, and PMO schedule
Approve compliant allocations and authorize the listed PO releases / quote revalidations subject to the gates below.
Recommendation
Approve the compliant sourcing and allocation plan shown in the supporting workbook. It covers all 26 forecast requirements (8,960.00 net usable lb) using 5,852.25 lb of compliant, yield-adjusted inventory and 3,107.75 lb of quoted purchase coverage. The selected PO quantities total 3,626.50 lb and $32,343.92, including 518.75 lb of controlled residual stock caused solely by stated minimum-order quantities.
This is not an authorization to use every physically available lot or the lowest-priced quote. The recommendation treats certification, heat traceability, quality-hold status, approved-source scope, country restrictions, exact specification/temper/form, existing allocation, and documented yield as controlling. No alternate alloy, temper, form, engineering approval, customer waiver, expedite, certification correction, or undocumented allocation change is assumed.
Decision metric
Result
Leadership interpretation
Coverage gap
0.00 lb
All requirements are covered in the proposed plan; coverage remains contingent on the selected quotes being valid and released/revalidated.
Inventory-only requirements
11 of 26
These can proceed from compliant on-hand inventory after existing allocations and lot yield are applied.
Purchase-dependent requirements
15 of 26
Use the selected quote matrix only; every selected line is an exact material match and has 3.1 certification.
Primary schedule gate
REQ-L8Q4 / Sable 4340 plate
The selected US quote docks 2 calendar days before need-by; PMO/Quality must confirm the required inspection/processing margin.
Commercial gate
12 selected quote lines
The packet records no accepted PO or extension. Release by expiry or obtain documented revalidation; do not assume commercial terms persist.
Priority-Based Coverage by Program
Allocation follows the PMO ranking whenever a compliant lot is shared. Raven is allocated first, followed by Sable, Meridian, Tundra, Halcyon, and Calder. This is why lower-priority programs sometimes receive a purchase for a residual rather than a reallocation from a higher-priority program.
Program
Rank
Demand (lb)
Inventory (lb)
Purchase (lb)
Recommendation / constraint
Raven
1
2,027.00
1,525.60
501.40
Covered: use compliant inventory for 4340 and 15-5 plate; purchase US 7075-T7351 and US 300M. DFARS blocks lower-cost China alternatives.
Sable
2
1,218.00
339.20
878.80
Covered: protected after Raven. QTE-6D1B84 is the sole selected 4340 plate path and has a two-day dated receipt margin.
Meridian
3
1,628.00
1,252.70
375.30
Covered: use compliant plate/extrusion/bar inventory first; purchase France 15-5PH bar and Cascade AMS 4117 bar. China is prohibited.
Tundra
4
1,309.00
739.00
570.00
Covered: eligible extrusion and 17-4PH inventory; shared France 15-5PH plate and Cascade 2024 extrusion purchase. China/Russia are prohibited.
Halcyon
5
1,660.00
1,201.50
458.50
Covered: compliant inventory plus China-origin 4340 plate only because this program has no special country restriction. No cross-program use of that quote.
Calder
6
1,118.00
794.25
323.75
Covered: receives remaining eligible inventory and three small residual purchases; minimum orders create controlled residual stock.
Compliance Decisions That Govern the Plan
No material substitution is used. All planned inventory and purchases match the released alloy, specification, temper or condition, and product form exactly. The only quantity treatment is the documented lot yield for on-hand stock.
C of C-only material is excluded: LOT-D6B821 and LOT-4A8D62, plus QTE-B6D2A9, are physically present or commercially attractive but cannot support certified hardware without 3.1/3.2 test evidence.
Quality-held material is excluded: LOT-B3E7C0 (15-5PH plate) and LOT-8F4D17 (17-4PH bar) receive no coverage credit until formally cleared. They are not backup supply in this recommendation.
Source and origin rules are program-specific. China-origin material is rejected for Raven/Sable DFARS work and Meridian/Tundra CUST-EU work, but QTE-9A2E57 and LOT-C7A340 are permitted only for unrestricted Halcyon and Calder respectively.
An Approved source still needs applicable spec-family approval. QTE-3F7D92 is excluded because Great Lakes is not listed for AMS 4117, despite its general Approved status.
Cost and Lead-Time Tradeoffs
The plan does not optimize on unit price alone. It rejects lower-cost China/Russia material where program restrictions prohibit it, rejects C of C-only and conditional/nonapproved sources, and chooses total PO cost where MOQs differ. For example, Adriatic QTE-7E2A85 is $0.20/lb above Pohang QTE-6A2D58 but permits a 162-lb PO rather than a 200-lb minimum, lowering direct spend for Calder. Likewise, Great Lakes QTE-D9F3B1 has a slightly higher unit price than Brunderman QTE-1E8C57 but its 250-lb MOQ costs less than the 300-lb minimum for the Calder residual.
Required Gates and Escalations
Priority
Required action
Reason
1
Confirm QTE-6D1B84 timing for REQ-L8Q4 before commitment
Sable's US 4340 AMS 6359 plate quote is dated 2026-08-26 against a 2026-08-28 need-by. ENG-MSP requires an inspection/processing margin but supplies no numeric threshold.
2
Release or formally revalidate all selected quotes by their stated expiry
The packet does not document a PO acceptance, quote extension, revised supplier capacity, revised price, or revised dock date. Commercial promises cannot be assumed.
3
Maintain Quality/MRB exclusions for LOT-B3E7C0 and LOT-8F4D17
Potential physical supply must remain unavailable until its documented hold is cleared; no plan credit is taken here.
4
Create traceable controlled-stock reservations for MOQ excess
QTE-9E4B27, QTE-C1E7B4, and QTE-D9F3B1 create 180.50 lb, 248.25 lb, and 90.00 lb excess respectively. Those residues cannot be casually cross-assigned to a different specification, form, or restricted program.
Leadership Decision
Authorize the material-plan allocations and the selected quote actions in Appendix A only after the two-day Sable timing gate is cleared and the buyer verifies active quote validity. If either condition cannot be satisfied, escalate the affected requirement to the Material Review Board and the relevant program office under ENG-MSP §7. Do not bridge the gap with excluded lots, non-qualifying origin material, C of C-only certification, a conditional source, or a substitution outside ENG-MSP Rev H.
The supporting workbook is the requirement-level audit trail for coverage, inventory-lot eligibility, quote feasibility, yields, allocations, non-selected alternatives, and escalation items.
Appendix A — Selected Purchase Authorization Detail
The PO quantities below include stated minimum-order quantities. ‘Approve’ means proceed only after verification of the quote-expiry gate; the single ‘Conditional approval’ line also requires the Sable timing confirmation stated in the memo.
Quote ID
Coverage
Source / Origin / Cert
PO Qty (lb)
Quoted Receipt
Planned Cost
Decision / tradeoff
QTE-A3F91C
Raven H4; Sable B6
Cascade / USA / 3.1
593.40
2026-07-30
$5,577.96
Approve: selected US quote covers both DFARS 7075-T7351 residuals.
QTE-8B3F19
Raven C9
Brunderman / USA / 3.1
176.00
2026-07-26
$2,499.20
Approve: China alternative is not DFARS eligible.
QTE-3A9F18
Sable T2; Tundra V1
Ardenne / France / 3.1
680.80
2026-08-06
$7,999.40
Approve: qualifying source; cheaper Volga and conditional Lone Star options are unusable.
QTE-6D1B84
Sable L8
Brunderman / USA / 3.1
287.00
2026-08-26
$1,980.30
Conditional approval: only 2 days before 2026-08-28 need-by; PMO/Quality timing confirmation required.
QTE-2D7C64
Meridian D7; Tundra Y8
Cascade / USA / 3.1
236.10
2026-08-02
$1,794.36
Approve: lower priced than Tri-State and timely for both CUST-EU programs.
QTE-2F8C41
Meridian W3
Ardenne / France / 3.1
198.00
2026-08-09
$1,950.30
Approve: qualifying France origin replaces prohibited China stock/quote.
QTE-1A6E38
Meridian G2
Cascade / USA / 3.1
154.20
2026-08-12
$886.65
Approve: Cascade is approved for AMS 4117; Great Lakes is not.
QTE-9A2E57
Halcyon Z4
Yellow River / China / 3.1
389.00
2026-08-18
$2,120.05
Approve only for unrestricted Halcyon; do not allocate to DFARS or CUST-EU programs.
QTE-9E4B27
Halcyon S6
Cascade / USA / 3.1
250.00
2026-08-04
$2,175.00
Approve: 250-lb MOQ fills 69.50-lb residual; control 180.50 lb residual stock.
QTE-C1E7B4
Calder E9
Cascade / USA / 3.1
250.00
2026-08-03
$2,225.00
Approve: 250-lb MOQ fills 1.75-lb residual; control 248.25 lb residual stock.
QTE-7E2A85
Calder U4
Adriatic / Slovenia / 3.1
162.00
2026-08-15
$1,798.20
Approve: higher unit price than Pohang but lower total spend because only 162 lb is needed.
QTE-D9F3B1
Calder H7
Great Lakes / USA / 3.1
250.00
2026-07-23
$1,337.50
Approve: 250-lb MOQ is lower total spend than Brunderman's 300-lb MOQ; Tri-State C of C excluded.
Selected PO total: 3,626.50 lb | Selected direct purchase cost: $32,343.92 | MOQ-driven controlled residual: 518.75 lb
Appendix B — Material That Is Physically Present or Quoted but Not Usable
Candidate
Why it is not usable for the affected requirement
Plan response
LOT-B3E7C0 / LOT-8F4D17
Open Quality Hold / MRB or Receiving Inspection hold. ENG-MSP §2 makes held material ineligible until cleared.
No coverage credit; selected purchases remain in the plan.
LOT-D6B821 / LOT-4A8D62 / QTE-B6D2A9
C of C only; 3.1 or 3.2 test-report evidence is required for certified hardware.
Excluded despite physical quantity or lower commercial price.
LOT-1F9D63
Partial heat traceability and Suspended source status.
Excluded from all certified allocations.
LOT-4D1A95 / QTE-6F1A93
Conditional source is ineligible for new commitments.
Excluded from 15-5PH coverage.
China/Russia origin options for Raven, Sable, Meridian, or Tundra
DFARS requires qualifying origin for Raven/Sable; CUST-EU prohibits China/Russia for Meridian/Tundra.
Rejected irrespective of price or lead-time; CN material used only on unrestricted Halcyon/Calder lines.
QTE-3F7D92
Source is not approved for the AMS 4117 specification family.
Use Cascade QTE-1A6E38 for the Meridian residual.
Basis documents reviewed: Material Demand Forecast (MRP-2026-0619-R2); Inventory Lot & Certification Snapshot (WMS-EXP-20260620-0741); Approved Material Source List QE-AMSL Rev N; Supplier Quote & Lead-Time Matrix; ENG-MSP Rev H; Program Priority & Build Schedule PC-2026-0618.
User prompt → 41 turns · 31 tool calls → final responsecodex
1systemskills instructions · Skills A skill is a set of instructions provided through a SKILL.md source. Below is the list of s…
skills instructions
Skills
A skill is a set of instructions provided through a
SKILL.mdsource. Below is the list of skills that can be used. Each entry includes a name, description, and source locator.filelocators are on the host filesystem,executor packagelocators are owned by their execution environment,orchestrator packagelocators are opaque package identifiers, andcustom resourcelocators use their provider's access mechanism.Available skills
- imagegen: Generate or edit raster images when the task benefits from AI-created bitmap visuals such as photos, illustrations, textures, sprites, mockups, or transparent-background cutouts. Use when Codex should create a brand-new image, transform an existing image, or derive visual variants from references, and the output should be a bitmap asset rather than repo-native code or vector. Do not use when the task is better handled by editing existing SVG/vector/code-native assets, extending an established icon or logo system, or building the visual directly in HTML/CSS/canvas. (file: /tmp/codex-home/skills/.system/imagegen/SKILL.md)
- openai-docs: Use for Codex models/pricing, scheduled tasks, skills, settings, setup, troubleshooting, customization, automations, and self-knowledge—including 'you,' 'your,' 'this app,' or 'this coding agent' when they refer to Codex—and for OpenAI APIs/products and ChatGPT Work. Also use for model choice/migration, prompting, SDKs, Responses, Realtime, agents, evals, and Chat/Work/Codex comparisons. Do not use for generic app/software tasks that merely mention Codex. (file: /tmp/codex-home/skills/.system/openai-docs/SKILL.md)
- plugin-creator: Create and scaffold plugin directories for Codex with a required
.codex-plugin/plugin.json, optional plugin folders/files, valid manifest defaults, and personal-marketplace entries by default. Use when Codex needs to create a new personal plugin, add optional plugin structure, generate or update marketplace entries for plugi
… 3,403 more characters in the raw trajectory.
2systemYou are /root, the primary agent in a team of agents collaborating to fulfill the user's goals. At the start of your tur…
You are
/root, the primary agent in a team of agents collaborating to fulfill the user's goals.At the start of your turn, you are the active agent.
You can spawn sub-agents to handle subtasks, and those sub-agents can spawn their own sub-agents.
All agents in the team, including the agents that you can assign tasks to, are equally intelligent and capable, and have access to the same set of tools.You can use
spawn_agentto create a new agent,followup_taskto give an existing agent a new task and trigger a turn, andsend_messageto pass a message to a running agent without triggering a turn.
Child agents can also spawn their own sub-agents.
You can decide how much context you want to propagate to your sub-agents with thefork_turnsparameter.You will receive messages in the analysis channel in the form:
Message Type: MESSAGE | FINAL_ANSWER Task name: <recipient> Sender: <author> Payload: <payload text>They may be addressed as to=/root
Note that collaboration tools cannot be called from inside
functions.exec. Callspawn_agent,send_message,followup_task,wait_agent,interrupt_agent, andlist_agentsonly as direct tool calls using the recipient shown in their tool definitions, such asto=functions.collaboration.spawn_agent, since they are intentionally absent from thefunctions.exectools.*namespace. Available tools infunctions.execare explicitly described with atoolsnamespace in the developer message.All agents share the same directory. In detail:
- All agents have access to the same container and filesystem as you.
- All agents use the same current working directory.
- As a result, edits made by one agent are immediately visible to all other agents.
When calling
wait_agent, prefer longer waits (minutes) to avoid busy polling.There are 4 available concurrency slots, meaning that up to 4 agents can be active at once, including you.
Full-history forks (
fork_turnsomitted or"all") inherit the parent mod… 264 more characters in the raw trajectory.
3systemmulti agent mode · Any earlier instruction enabling proactive multi-agent delegation no longer applies. Do not spawn sub…
multi agent mode
Any earlier instruction enabling proactive multi-agent delegation no longer applies. Do not spawn sub-agents unless the user or applicable AGENTS.md/skill instructions explicitly ask for sub-agents, delegation, or parallel agent work.
4userenvironment context · /workspace bash 2026-08-20 Etc/UTC /workspace
environment context
- cwd
- /workspace
- shell
- bash
- current date
- 2026-08-20
- timezone
- Etc/UTC
- root
- /workspace
5userYou are supporting a material sourcing review for an aerospace components manufacturer that builds certified door and hi…
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 a
… 1,544 more characters in the raw trajectory.
6I’ll review the supplied packet against the documented certification and approval constraints, then produce both the dec…
I’ll review the supplied packet against the documented certification and approval constraints, then produce both the decision memo and its auditable workbook in
/workspace/output/. I’m using the document and spreadsheet skills because the requested deliverables are a Word memo and an Excel analysis workbook.7Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const results = await Promise.all([ tools.exec_command({"cmd":"sed -n '1,240p' /root/.agents/skills/docx/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":30000}), tools.exec_command({"cmd":"sed -n '1,260p' /root/.agents/skills/xlsx/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":30000}) ]); text(results.map(r => r.output).join("\n\n--- XLSX SKILL ---\n"));Output
Script completed Wall time 0.1 seconds Output: --- name: docx description: "Use this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation." license: Proprietary. LICENSE.txt has complete t
… 18,338 more characters of output in the raw trajectory.
8Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const results = await Promise.all([ tools.exec_command({"cmd":"wc -l /root/.agents/skills/docx/SKILL.md /root/.agents/skills/xlsx/SKILL.md && sed -n '241,520p' /root/.agents/skills/docx/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":30000}), tools.exec_command({"cmd":"sed -n '261,620p' /root/.agents/skills/xlsx/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":30000}) ]); text(results.map(r => r.output).join("\n\n--- XLSX SKILL CONTINUED ---\n"));Output
Script completed Wall time 0.1 seconds Output: 590 /root/.agents/skills/docx/SKILL.md 291 /root/.agents/skills/xlsx/SKILL.md 881 total new Paragraph({ children: [new PageBreak()] }) // Or use pageBreakBefore new Paragraph({ pageBreakBefore: true, children: [new TextRun("New page")] }) ``` ### Hyperlinks ```javascript // External link new Paragraph({ children: [new ExternalHyperlink({ children: [new TextRun({ text: "Click here", style: "Hyperlink" })], link: "https://example.com", })] }) // Internal link (bookmark + reference) // 1. Create bookmark at destination new Paragraph({ heading: HeadingLevel.HEADING_1, children: [ new Bookmark({ id: "chapter1", children: [new TextRun("Chapter 1")] }), ]}) // 2. Link to it new Paragraph({ children: [new InternalHyperlink({ children: [new TextRun({ text: "See Chapter 1", style: "Hyperlink" })], anchor: "chapter1", })]})… 10,375 more characters of output in the raw trajectory.
9Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"sed -n '521,680p' /root/.agents/skills/docx/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":20000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: ```xml <w:del w:author="Jane" w:id="5"> <w:r><w:delText>deleted text</w:delText></w:r> </w:del> <w:ins w:author="Claude" w:id="10"> <w:r><w:t>deleted text</w:t></w:r> </w:ins> ``` ### Comments After running `comment.py` (see Step 2), add markers to document.xml. For replies, use `--parent` flag and nest markers inside the parent's. **CRITICAL: `<w:commentRangeStart>` and `<w:commentRangeEnd>` are siblings of `<w:r>`, never inside `<w:r>`.** ```xml <!-- Comment markers are direct children of w:p, never inside w:r --> <w:commentRangeStart w:id="0"/> <w:del w:id="1" w:author="Claude" w:date="2025-01-01T00:00:00Z"> <w:r><w:delText>deleted</w:delText></w:r> </w:del> <w:r><w:t> more text</w:t></w:r> <w:commentRangeEnd w:id="0"/> <w:r><w:rPr><w:rStyle w:val="CommentReference"/></w:rPr><w:commentReference w:id="0"/></w:r> <!-- Comment 0 wit
… 1,330 more characters of output in the raw trajectory.
10Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"rg --files -g '!output/**' -g '!node_modules/**' /workspace | sed -n '1,300p'","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: /workspace/data/supplier_quote_leadtime_matrix.xlsx /workspace/data/program_priority_build_schedule.docx /workspace/data/material_demand_forecast.xlsx /workspace/data/inventory_lot_cert_snapshot.xlsx /workspace/data/engineering_material_substitution_policy.pdf /workspace/data/approved_material_source_list.xlsx
11The packet includes the engineering substitution policy as a PDF, so I’m also using the PDF skill to extract that policy…
The packet includes the engineering substitution policy as a PDF, so I’m also using the PDF skill to extract that policy before evaluating any apparent substitutes.
12Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"sed -n '1,320p' /root/.agents/skills/pdf/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":40000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: --- name: pdf description: Use this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill. license: Proprietary. LICENSE.txt has complete terms --- # PDF Processing Guide ## Overview This guide covers essential PDF processing operations using Python libraries and command-line tools. For advanced features, JavaScript libraries, and detailed examples, see REFERENCE.md. If you need to fill out a PDF form, read FORMS.md and follow its instructions. ## Quick Start ```python from pypdf im
… 7,489 more characters of output in the raw trajectory.
13exec1
Tool execution only — no assistant text
execconst r = await tools.update_plan({explanation:"Review the six source files, establish compliant coverage and allocation decisions, then create and validate the requested Word memo and Excel workbook.",plan:[{step:"Extract and reconcile demand, inventory, source-approval, quote, substitution-policy, and schedule data","status":"in_progress"},{step:"Determine compliant allocations, purchases, shortages, and escalations by requirement","status":"pending"},{step:"Create the supporting Excel workbook and validate formulas","status":"pending"},{step:"Create and valida
Arguments
const r = await tools.update_plan({explanation:"Review the six source files, establish compliant coverage and allocation decisions, then create and validate the requested Word memo and Excel workbook.",plan:[{step:"Extract and reconcile demand, inventory, source-approval, quote, substitution-policy, and schedule data","status":"in_progress"},{step:"Determine compliant allocations, purchases, shortages, and escalations by requirement","status":"pending"},{step:"Create the supporting Excel workbook and validate formulas","status":"pending"},{step:"Create and valida… 117 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}14Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const results = await Promise.all([ tools.exec_command({"cmd":"python - <<'PY'\nimport os\nfrom openpyxl import load_workbook\nbase='/workspace/data'\nfor fn in sorted(os.listdir(base)):\n if not fn.endswith('.xlsx'): continue\n p=os.path.join(base,fn)\n wb=load_workbook(p, data_only=False)\n print('\\n'+'='*100)\n print(fn, wb.sheetnames)\n for ws in wb.worksheets:\n print('\\n--',ws.title, 'dimensions',ws.max_row,ws.max_column)\n for row in ws.iter_rows(values_only=True):\n print('\\t'.join('' if v is None else str… 595 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.2 seconds Output: ==================================================================================================== approved_material_source_list.xlsx ['Source List', 'README'] -- Source List dimensions 13 9 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 All
… 29,446 more characters of output in the raw trajectory.
15Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python - <<'PY'\nfrom docx import Document\np='/workspace/data/program_priority_build_schedule.docx'\nd=Document(p)\nprint('PARAGRAPHS')\nfor i, para in enumerate(d.paragraphs):\n t=para.text.strip()\n if t: print(f'{i}: {t}')\nprint('\\nTABLES')\nfor ti, table in enumerate(d.tables,1):\n print(f'-- Table {ti} --')\n for row in table.rows:\n print('\\t'.join(c.text.replace('\\n',' | ') for c in row.cells))\nPY","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":30000}); text(r.o… 9 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.4 seconds Output: PARAGRAPHS 0: Program Priority & Build Schedule 1: 2026 Q3 Door/Hinge Mechanism Build Wave — Production Control Release PC-2026-0618 2: Issued by: Production Control & Program Management Office (PMO). Distribution: Sourcing, Materials Planning, Quality, MRB. Status as of 2026-06-19. 3: 1. Purpose 4: 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. 5: 2. Program Priority Ranking and Build Commitments 6: Note: build start is the
… 3,073 more characters of output in the raw trajectory.
16I’ve reconciled the packet’s cross-references. The central finding is that several low-cost options are physically avail…
I’ve reconciled the packet’s cross-references. The central finding is that several low-cost options are physically available but cannot be planned because of non-qualifying origin, C of C-only certification, holds, incomplete traceability, or conditional/not-approved source status. I’m now building the auditable allocation and quote-feasibility model around the compliant alternatives.
17Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"rg --files /root/.agents /tmp/codex-home/skills 2>/dev/null | rg '/(recalc|validate|soffice)\\.py$' | sed -n '1,160p'\nnode -e \"try { console.log(require.resolve('docx')) } catch(e) { console.log('DOCX_MODULE_NOT_FOUND') }\"","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":20000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: /root/.agents/skills/xlsx/scripts/recalc.py /root/.agents/skills/xlsx/scripts/office/soffice.py /root/.agents/skills/xlsx/scripts/office/validate.py /root/.agents/skills/docx/scripts/office/soffice.py /root/.agents/skills/docx/scripts/office/validate.py DOCX_MODULE_NOT_FOUND
18Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"npm root -g && find /workspace -maxdepth 3 -type d -name docx -print | sed -n '1,40p' && command -v libreoffice || command -v soffice || true","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":20000}); text(r.output);Output
Script completed Wall time 0.2 seconds Output: /root/.nvm/versions/node/v22.23.2/lib/node_modules /usr/bin/libreoffice
19Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"npm install -g docx","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 2.0 seconds Output: added 22 packages in 2s 1 package is looking for funding run `npm fund` for details
20exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Add File: /tmp/build_material_sourcing_workbook.py\n+from __future__ import annotations\n+\n+import json\n+import os\n+from collections import defaultdict\n+from datetime import datetime\n+\n+from docx import Document\n+from openpyxl import Workbook, load_workbook\n+from openpyxl.comments import Comment\n+from openpyxl.formatting.rule import CellIsRule, FormulaRule\n+from openpyxl.styles import Alignment, Border, Font, PatternFill, Side\n+from openpyxl.utils import get_column_letter\n+from openpyxl.worksheet.datavalidation import Da
Arguments
const patch = "*** Begin Patch\n*** Add File: /tmp/build_material_sourcing_workbook.py\n+from __future__ import annotations\n+\n+import json\n+import os\n+from collections import defaultdict\n+from datetime import datetime\n+\n+from docx import Document\n+from openpyxl import Workbook, load_workbook\n+from openpyxl.comments import Comment\n+from openpyxl.formatting.rule import CellIsRule, FormulaRule\n+from openpyxl.styles import Alignment, Border, Font, PatternFill, Side\n+from openpyxl.utils import get_column_letter\n+from openpyxl.worksheet.datavalidation import Da
… 68,247 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}21exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Update File: /tmp/build_material_sourcing_workbook.py\n@@\n- if idx in {7, 8, 9, 10, 11}:\n+ if idx in {7, 8, 9, 10, 11, 12}:\n ws.cell(idx, 2).number_format = '#,##0.00;[Red](#,##0.00);-'\n- if idx == 12:\n+ if idx == 13:\n ws.cell(idx, 2).number_format = '$#,##0.00;[Red]($#,##0.00);-'\n@@\n- f\"=VLOOKUP(E{r},'Inventory Lots'!$A$5:$Q$28,16,FALSE)\", f\"=K{r}-SUMIF($E:$E,E{r},$J:$J)\",\n+ f\"=VLOOKUP(E{r},'Inventory Lots'!$A$5:$W$28,18,FALSE)\", f\"=
Arguments
const patch = "*** Begin Patch\n*** Update File: /tmp/build_material_sourcing_workbook.py\n@@\n- if idx in {7, 8, 9, 10, 11}:\n+ if idx in {7, 8, 9, 10, 11, 12}:\n ws.cell(idx, 2).number_format = '#,##0.00;[Red](#,##0.00);-'\n- if idx == 12:\n+ if idx == 13:\n ws.cell(idx, 2).number_format = '$#,##0.00;[Red]($#,##0.00);-'\n@@\n- f\"=VLOOKUP(E{r},'Inventory Lots'!$A$5:$Q$28,16,FALSE)\", f\"=K{r}-SUMIF($E:$E,E{r},$J:$J)\",\n+ f\"=VLOOKUP(E{r},'Inventory Lots'!$A$5:$W$28,18,FALSE)\", f\"=… 560 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}22Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python /tmp/build_material_sourcing_workbook.py","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":40000}); text(r.output);Output
Script completed Wall time 0.9 seconds Output: Traceback (most recent call last): File "/tmp/build_material_sourcing_workbook.py", line 776, in <module> main() File "/tmp/build_material_sourcing_workbook.py", line 373, in main ws.column_dimensions[1].width = 33 ~~~~~~~~~~~~~~~~~~~~^^^ File "/usr/local/lib/python3.11/site-packages/openpyxl/utils/bound_dictionary.py", line 25, in __getitem__ setattr(value, self.reference, key) File "/usr/local/lib/python3.11/site-packages/openpyxl/descriptors/base.py", line 46, in __set__ raise TypeError(msg) TypeError: <class 'openpyxl.worksheet.dimensions.ColumnDimension'>.index should be <class 'str'> but value is <class 'int'>23exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Update File: /tmp/build_material_sourcing_workbook.py\n@@\n- ws.column_dimensions[1].width = 33\n- ws.column_dimensions[2].width = 24\n+ ws.column_dimensions[\"A\"].width = 33\n+ ws.column_dimensions[\"B\"].width = 24\n*** End Patch"; const r = await tools.apply_patch(patch); text(typeof r === "string" ? r : JSON.stringify(r));
Arguments
const patch = "*** Begin Patch\n*** Update File: /tmp/build_material_sourcing_workbook.py\n@@\n- ws.column_dimensions[1].width = 33\n- ws.column_dimensions[2].width = 24\n+ ws.column_dimensions[\"A\"].width = 33\n+ ws.column_dimensions[\"B\"].width = 24\n*** End Patch"; const r = await tools.apply_patch(patch); text(typeof r === "string" ? r : JSON.stringify(r));
Output
Script completed Wall time 0.0 seconds Output: {}24Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python /tmp/build_material_sourcing_workbook.py","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":40000}); text(r.output);Output
Script completed Wall time 2.0 seconds Output: { "total_requirements": 26, "total_demand": 8960.0, "inventory_coverage": 5852.25, "purchase_coverage": 3107.75, "po_total": 3626.4999999999995, "po_excess": 518.7499999999995, "purchase_cost": 32343.920000000002, "programs": [ { "program": "PRG-RAVEN", "name": "Raven Cargo Door Actuation Hinge", "priority": 1, "restriction": "DFARS", "required": 2027.0, "inventory": 1525.6, "purchase": 501.4 }, { "program": "PRG-SABLE", "name": "Sable Emergency Egress Hinge Arm", "priority": 2, "restriction": "DFARS", "required": 1218.0, "inventory": 339.2, "purchase": 878.8 }, { "program": "PRG-MERIDIAN", "name": "Meridian Cabin Door Latch Hinge", "priority": 3, "restriction": "CUST-EU", "required": 1628.… 1,565 more characters of output in the raw trajectory.
25Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python /root/.agents/skills/xlsx/scripts/recalc.py /workspace/output/material_sourcing_analysis_workbook.xlsx 60","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":40000}); text(r.output);Output
Script completed Wall time 3.2 seconds Output: status: success total_errors: 0 error_summary: {} total_formulas: 59926Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python - <<'PY'\nfrom openpyxl import load_workbook\np='/workspace/output/material_sourcing_analysis_workbook.xlsx'\nwbv=load_workbook(p,data_only=True)\nfor name, cells in {\n 'Read Me':['B6','B7','B8','B9','B10','B11','B12','B13'],\n 'Purchase Plan':['K17','N17'],\n 'Requirement Coverage':['M5','N5','O5','P5','Q5','M30','N30','O30','P30','Q30'],\n 'Inventory Allocation':['K5','L5'],\n 'Inventory Lots':['P5','R5','V5','W5'],\n 'Quote Feasibility':['U5','V5','X5']\n}.items():\n ws=wbv[name]\n print(name, [(c,ws[c].value) for… 422 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.6 seconds Output: Read Me [('B6', 26), ('B7', 8960), ('B8', 5852.25), ('B9', 3107.75), ('B10', 0), ('B11', 3626.5), ('B12', 518.75), ('B13', 32343.92)] Purchase Plan [('K17', 3626.5), ('N17', 32343.92)] Requirement Coverage [('M5', 516.6), ('N5', 325.4), ('O5', 842), ('P5', 0), ('Q5', 'Covered'), ('M30', 147), ('N30', 0), ('O30', 147), ('P30', 0), ('Q30', 'Covered')] Inventory Allocation [('K5', 516.6), ('L5', 0)] Inventory Lots [('P5', 300), ('R5', 252), ('V5', 147), ('W5', 105)] Quote Feasibility [('U5', 8), ('V5', 'Before need-by'), ('X5', 'Y')] sheets: ['Read Me', 'Requirement Coverage', 'Purchase Plan', 'At-Risk & Escalations', 'Inventory Allocation', 'Purchase Allocation', 'Inventory Lots', 'Inventory Req Eligibility', 'Quote Feasibility', 'Requirements Source', 'Inventory Source', 'Quotes Source', 'AMSL Source', 'Program Schedule', 'Policy Controls'] coverage gaps [(5, '=M… 632 more characters of output in the raw trajectory.
27Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"NODE_PATH=$(npm root -g) node - <<'NODE'\nconst d = require('docx');\nconsole.log('docx loaded', typeof d.Document, typeof d.Packer, d.PageOrientation ? 'orientation ok' : 'no orient');\nNODE","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":20000}); text(r.output);Output
Script completed Wall time 0.3 seconds Output: docx loaded function function orientation ok
28exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Add File: /tmp/build_material_sourcing_memo.js\n+const fs = require(\"fs\");\n+const {\n+ AlignmentType,\n+ BorderStyle,\n+ Document,\n+ Footer,\n+ Header,\n+ HeadingLevel,\n+ LevelFormat,\n+ PageBreak,\n+ PageNumber,\n+ Packer,\n+ Paragraph,\n+ SectionType,\n+ ShadingType,\n+ Table,\n+ TableCell,\n+ TableRow,\n+ TextRun,\n+ VerticalAlign,\n+ WidthType,\n+ PageOrientation,\n+} = require(\"docx\");\n+\n+const summary = JSON.parse(fs.readFileSync(\"/tmp/material_sourcing_summary.json\", \"u
Arguments
const patch = "*** Begin Patch\n*** Add File: /tmp/build_material_sourcing_memo.js\n+const fs = require(\"fs\");\n+const {\n+ AlignmentType,\n+ BorderStyle,\n+ Document,\n+ Footer,\n+ Header,\n+ HeadingLevel,\n+ LevelFormat,\n+ PageBreak,\n+ PageNumber,\n+ Packer,\n+ Paragraph,\n+ SectionType,\n+ ShadingType,\n+ Table,\n+ TableCell,\n+ TableRow,\n+ TextRun,\n+ VerticalAlign,\n+ WidthType,\n+ PageOrientation,\n+} = require(\"docx\");\n+\n+const summary = JSON.parse(fs.readFileSync(\"/tmp/material_sourcing_summary.json\", \"u… 22,811 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}29Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"NODE_PATH=$(npm root -g) node /tmp/build_material_sourcing_memo.js && ls -lh /workspace/output/material_sourcing_recommendation_memo.docx","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 0.4 seconds Output: -rw-r--r-- 1 root root 22K Aug 20 17:11 /workspace/output/material_sourcing_recommendation_memo.docx
30Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":40000}); text(r.output);Output
Script completed Wall time 1.4 seconds Output: Paragraphs: 0 → 221 (+221) All validations PASSED!
31Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python /root/.agents/skills/docx/scripts/office/soffice.py --help","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":20000}); text(r.output);Output
Script completed Wall time 0.3 seconds Output: LibreOffice 25.2.3.2 520(Build:2) Usage: soffice [argument...] argument - switches, switch parameters and document URIs (filenames). Using without special arguments: Opens the start center, if it is used without any arguments. {file} Tries to open the file (files) in the components suitable for them. {file} {macro:///Library.Module.MacroName} Opens the file and runs specified macro from My Macros container. {file} {macro://./Library.Module.MacroName} Opens the file and runs specified macro from… 10,939 more characters of output in the raw trajectory.
32Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"task_render_dir=$(mktemp -d /tmp/material-memo-render-XXXXXX)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$task_render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx\npdfinfo \"$task_render_dir/material_sourcing_recommendation_memo.pdf\" | rg 'Pages|Page size'\npdftoppm -jpeg -r 120 \"$task_render_dir/material_sourcing_recommendation_memo.pdf\" \"$task_render_dir/page\" >/dev/null 2>&1\nfind \"$task_render_dir\" -maxdepth 1 -type f -name 'pa… 181 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.2 seconds Output: Warning: failed to launch javaldx - java may not function correctly convert /workspace/output/material_sourcing_recommendation_memo.docx as a Writer document -> /tmp/material-memo-render-vS8TJS/material_sourcing_recommendation_memo.pdf using filter : writer_pdf_Export Pages: 5 Page size: 612 x 792 pts (letter) /tmp/material-memo-render-vS8TJS/page-1.jpg /tmp/material-memo-render-vS8TJS/page-2.jpg /tmp/material-memo-render-vS8TJS/page-3.jpg /tmp/material-memo-render-vS8TJS/page-4.jpg /tmp/material-memo-render-vS8TJS/page-5.jpg /tmp/material-memo-render-vS8TJS
33exec1
Tool execution only — no assistant text
execconst imgs = await Promise.all([ tools.view_image({"path":"/tmp/material-memo-render-vS8TJS/page-1.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-vS8TJS/page-3.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-vS8TJS/page-4.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-vS8TJS/page-5.jpg","detail":"high"}) ]); for (const img of imgs) image(img.image_url, img.detail);
Arguments
const imgs = await Promise.all([ tools.view_image({"path":"/tmp/material-memo-render-vS8TJS/page-1.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-vS8TJS/page-3.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-vS8TJS/page-4.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-vS8TJS/page-5.jpg","detail":"high"}) ]); for (const img of imgs) image(img.image_url, img.detail);Output
Script completed Wall time 0.1 seconds Output:
… 904,658 more characters of output in the raw trajectory.
34exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Update File: /tmp/build_material_sourcing_memo.js\n@@\n makeTable(\n@@\n ),\n new Paragraph({ spacing: { before: 80, after: 80 }, children: [run(`Selected PO total: ${fmtQty(summary.po_total)} lb | Selected direct purchase cost: ${fmtMoney(summary.purchase_cost)} | MOQ-driven controlled residual: ${fmtQty(summary.po_excess)} lb`, { size: 18, bold: true, color: NAVY })] }),\n+ new Paragraph({ children: [new PageBreak()] }),\n heading(\"Appendix B — Material That Is Physically Present or Quoted but Not Usable\", 1),\n*** End Pa
Arguments
const patch = "*** Begin Patch\n*** Update File: /tmp/build_material_sourcing_memo.js\n@@\n makeTable(\n@@\n ),\n new Paragraph({ spacing: { before: 80, after: 80 }, children: [run(`Selected PO total: ${fmtQty(summary.po_total)} lb | Selected direct purchase cost: ${fmtMoney(summary.purchase_cost)} | MOQ-driven controlled residual: ${fmtQty(summary.po_excess)} lb`, { size: 18, bold: true, color: NAVY })] }),\n+ new Paragraph({ children: [new PageBreak()] }),\n heading(\"Appendix B — Material That Is Physically Present or Quoted but Not Usable\", 1),\n*** End Pa… 107 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}35Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"NODE_PATH=$(npm root -g) node /tmp/build_material_sourcing_memo.js\npython /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx\nrender_dir=$(mktemp -d /tmp/material-memo-render-XXXXXX)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx >/dev/null\npdfinfo \"$render_dir/material_sourcing_recommendation_memo.pdf\" | rg 'Pages|Page size'\npdftoppm… 252 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 3.1 seconds Output: Paragraphs: 0 → 222 (+222) All validations PASSED! Warning: failed to launch javaldx - java may not function correctly Pages: 5 Page size: 612 x 792 pts (letter) /tmp/material-memo-render-uOANTV
36exec1
Tool execution only — no assistant text
execconst imgs = await Promise.all([ tools.view_image({"path":"/tmp/material-memo-render-uOANTV/page-4.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-uOANTV/page-5.jpg","detail":"high"}) ]); for (const img of imgs) image(img.image_url, img.detail);
Arguments
const imgs = await Promise.all([ tools.view_image({"path":"/tmp/material-memo-render-uOANTV/page-4.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-uOANTV/page-5.jpg","detail":"high"}) ]); for (const img of imgs) image(img.image_url, img.detail);Output
Script completed Wall time 0.0 seconds Output:
… 395,364 more characters of output in the raw trajectory.
37exec1
Tool execution only — no assistant text
execconst imgs = await Promise.all([ tools.view_image({"path":"/tmp/material-memo-render-uOANTV/page-2.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-uOANTV/page-3.jpg","detail":"high"}) ]); for (const img of imgs) image(img.image_url, img.detail);
Arguments
const imgs = await Promise.all([ tools.view_image({"path":"/tmp/material-memo-render-uOANTV/page-2.jpg","detail":"high"}), tools.view_image({"path":"/tmp/material-memo-render-uOANTV/page-3.jpg","detail":"high"}) ]); for (const img of imgs) image(img.image_url, img.detail);Output
Script completed Wall time 0.0 seconds Output:
… 432,588 more characters of output in the raw trajectory.
38The workbook and memo are now built and validated. The proposed plan closes all forecasted net-demand gaps only through…
The workbook and memo are now built and validated. The proposed plan closes all forecasted net-demand gaps only through compliant material: 5,852.25 lb from eligible on-hand lots and 3,626.50 lb of selected POs (including MOQ-driven residual stock). I’m performing the final consistency checks on coverage, quote capacity, and the documented escalation gates.
39Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python - <<'PY'\nfrom openpyxl import load_workbook\np='/workspace/output/material_sourcing_analysis_workbook.xlsx'\nwb=load_workbook(p,data_only=True)\nerrors=[]\nfor ws in wb.worksheets:\n for row in ws.iter_rows():\n for cell in row:\n if isinstance(cell.value,str) and cell.value.startswith('#'):\n errors.append(f'{ws.title}!{cell.coordinate}={cell.value}')\nreq=wb['Requirement Coverage']\ncoverage=[]\nfor r in range(5,31):\n coverage.append((req.cell(r,1).value, req.cell(r,16).value,… 1,220 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.8 seconds Output: requirement gaps/status: [('REQ-H4A2', 0, 'Covered'), ('REQ-K9P1', 0, 'Covered'), ('REQ-C9T1', 0, 'Covered'), ('REQ-X5M3', 0, 'Covered'), ('REQ-T2C7', 0, 'Covered'), ('REQ-B6N3', 0, 'Covered'), ('REQ-F6B8', 0, 'Covered'), ('REQ-L8Q4', 0, 'Covered'), ('REQ-M1X8', 0, 'Covered'), ('REQ-D7R4', 0, 'Covered'), ('REQ-W3F9', 0, 'Covered'), ('REQ-R7W2', 0, 'Covered'), ('REQ-G2J9', 0, 'Covered'), ('REQ-J5G7', 0, 'Covered'), ('REQ-P2H6', 0, 'Covered'), ('REQ-V1D9', 0, 'Covered'), ('REQ-Y8K2', 0, 'Covered'), ('REQ-Q8L5', 0, 'Covered'), ('REQ-Z4V2', 0, 'Covered'), ('REQ-N3K4', 0, 'Covered'), ('REQ-S6P3', 0, 'Covered'), ('REQ-A2F7', 0, 'Covered'), ('REQ-E9C1', 0, 'Covered'), ('REQ-U4B8', 0, 'Covered'), ('REQ-H7D5', 0, 'Covered'), ('REQ-W9A3', 0, 'Covered')] all requirement coverage pass: True negative inventory allocation balance: [] purchase quote-capacity exceptions: [] select… 932 more characters of output in the raw trajectory.
40exec1
Tool execution only — no assistant text
execconst r = await tools.update_plan({explanation:"All source documents were reconciled; the compliant allocation/purchase plan, supporting workbook, and recommendation memo have been created and validated.",plan:[{step:"Extract and reconcile demand, inventory, source-approval, quote, substitution-policy, and schedule data","status":"completed"},{step:"Determine compliant allocations, purchases, shortages, and escalations by requirement","status":"completed"},{step:"Create the supporting Excel workbook and validate formulas","status":"completed"},{step:"Create and v
Arguments
const r = await tools.update_plan({explanation:"All source documents were reconciled; the compliant allocation/purchase plan, supporting workbook, and recommendation memo have been created and validated.",plan:[{step:"Extract and reconcile demand, inventory, source-approval, quote, substitution-policy, and schedule data","status":"completed"},{step:"Determine compliant allocations, purchases, shortages, and escalations by requirement","status":"completed"},{step:"Create the supporting Excel workbook and validate formulas","status":"completed"},{step:"Create and v… 124 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}41Completed and validated both deliverables: - [Recommendation memo](/workspace/output/material_sourcing_recommendation_me…
Completed and validated both deliverables:
- Recommendation memo
- Supporting analysis workbook
Key result: all 26 requirements are covered under the documented constraints—5,852.25 lb from compliant yield-adjusted inventory and 3,107.75 lb from selected purchases. Selected PO quantities total 3,626.50 lb and $32,343.92, including 518.75 lb of MOQ-driven controlled residual stock.
Critical gates: confirm the two-day timing margin for Sable’s QTE-6D1B84, and release or formally revalidate all selected quotes by their stated expiry. The plan excludes held, C of C-only, untraceable, conditional/suspended, and restricted-origin material.
3 failure modes across 3 verifier failures
1Eligibility or Controlling Rule Applied IncorrectlyView on Failure Modes ↗Reasoning and Computation1 failure
Description
Does the artifact keep an option eligible, exclude a required option, or elevate an advisory rule contrary to a documented origin, certification, source-status, schedule, route, seasonality, hold, lock, or authority rule?
Failure evidence · per affected verifier
Quote Feasibility rows state a receipt-on-or-after-need-by rejection reason that contradicts the row's own dock and need-by dates.
2Decision Audit Trail Fragmented or IncompleteView on Failure Modes ↗Deliverable Completion and Structure1 failure
Description
Must a reviewer join separate sheets or infer unstated links to connect an item or requirement with its inputs, alternatives, decision, rationale, quantities, and resulting economics?
Failure evidence · per affected verifier
Selected lots, rejected alternatives, selected and rejected quotes, and purchase cost for an at-risk requirement each live on a different sheet instead of one joined view.
3Escalation or Tradeoff Communication IncompleteView on Failure Modes ↗Presentation and Communication1 failure
Description
Does the final communication omit or conflate a required escalation, rejected attractive alternative, disqualifying reason, residual risk, or distinction between a feasible plan and separate process actions?
Failure evidence · per affected verifier
The memo argues compliance over price or lead time but omits naming at least one of the three required attractive, cheaper, or faster non-compliant quotes along with the specific reason it was rejected.