task_111Manufacturing
All trialsGPT-5.6 TerracodexTrial 04
Trial reward
GPT-5.6 TerraFail
Trial 04 — 1st of 4 by reward score. This model averages 82.5% across 4 trials on this task.
- 13/15Core verifiers passed
- 14/16All verifiers passed
- 2Core failed
- 36Turns
- 25Tool calls
- $1.32Cost
- 36.2mTime
- 64kOutput tokens
Missed 2 of 15 core — traceability and memo_recommendation.
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
The workbook contains the pieces, but not in a single per-requirement audit view for at-risk lines. Requirement Coverage and Allocation Plan show selected lots/quotes and lb (e.g., REQ-H4A2 uses LOT-7F3A2B 516.6 lb plus QTE-A3F91C 325.4 lb), while Inventory Usability and Quote Feasibility hold rejected lots/quotes with reasons in separate sheets. Purchase Plan is only quote-level, not requirement-level; shared quotes such as QTE-A3F91C (REQ-H4A2 and REQ-B6N3) and QTE-3A9F18 (REQ-T2C7 and REQ-V1D9) do not show resulting purchase quantity/cost per requirement. So rejected options, residuals, and purchase quantities/costs are not tied together per requirement as required.
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 present a compliance-first sourcing/allocation plan (it states exclusions override price and availability) and it explicitly rejects China 7075-T7351 QTE-7D2B40 for DFARS and C-of-C-only QTE-B6D2A9 because a C of C is not a 3.1 substitute. However, it does not explicitly identify and reject the required lowest-price Russia-melt 15-5PH quote (~$8.10/lb), and it does not clearly label QTE-B6D2A9 as the cheapest/fastest 4340 bar quote. The rubric’s minimum rejected-option documentation is therefore incomplete.
no_fabrication_side_effectsLLMPass
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
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
Executive Summary
| Material Sourcing Analysis — Executive Summary | |||||||
|---|---|---|---|---|---|---|---|
| 2026 Q3 door/hinge mechanism build wave. Coverage uses exact callout matching, 3.1/3.2 certification, Full traceability, no open hold, approved source, applicable country rule, existing allocations, and documented yield. | |||||||
| Review date | 46254 | Packet status basis | Program schedule: 2026-06-19; inventory snapshot: 2026-06-20; source list effective 2026-06-01. | ||||
| Metric | Value | Interpretation | |||||
| Forecast demand (usable lb) | 8960 | All 26 demand lines; raw-stock need after documented yield loss. | |||||
| Eligible inventory allocated (usable lb) | 5857.25 | Only policy-compliant lots, net of existing allocation and yield. | |||||
| Selected quote coverage (lb) | 3102.75 | Coverage capacity assigned from selected compliant quotes. | |||||
| Requirements fully covered in packet-period plan | 26 | All lines are mathematically covered by exact-match inventory and/or selected quote capacity. | |||||
| Selected quote target purchase qty (lb) | 3621.5 | Target = greater of allocated quote coverage and stated minimum order; exact orderable quantity must be revalidated. | |||||
| Estimated target PO spend | 32288.42 | Modeled from published unit prices only; not a valid purchase commitment after quote expiration. | |||||
| Selected quote terms currently open | 0 | No selected quote term remains open as of the stated review date. | |||||
| Decision: reserve only the compliant inventory allocations shown in this workbook and use the selected quotes as packet-period sourcing candidates. Do not release a PO from any selected quote as written: each selected term is expired as of 2026-08-20. Refresh/revalidate price, quantity, receipt, 3.1 certification, source approval, and melt origin before commitment. No substitution is proposed or assumed. | |||||||
| Program | Rank | Restriction | Demand (lb) | Inventory Allocated (lb) | Quote Coverage (lb) | Coverage Balance (lb) | Current Execution Gate |
| Raven Cargo Door Actuation Hinge | 1 | DFARS | 2027 | 1525.6 | 501.4 | 0 | PMO escalation if need-by has passed; otherwise refresh quote terms or verify current WMS/QMS status. |
| Sable Emergency Egress Hinge Arm | 2 | DFARS | 1218 | 339.2 | 878.8 | 0 | PMO escalation if need-by has passed; otherwise refresh quote terms or verify current WMS/QMS status. |
| Meridian Cabin Door Latch Hinge | 3 | CUST-EU | 1628 | 1252.7 | 375.3 | 0 | PMO escalation if need-by has passed; otherwise refresh quote terms or verify current WMS/QMS status. |
| Tundra Cargo Door Stop Fitting | 4 | CUST-EU | 1309 | 739 | 570 | 0 | PMO escalation if need-by has passed; otherwise refresh quote terms or verify current WMS/QMS status. |
| Halcyon Service Door Hinge Bracket | 5 | None | 1660 | 1201.5 | 458.5 | 0 | PMO escalation if need-by has passed; otherwise refresh quote terms or verify current WMS/QMS status. |
| Calder Overwing Hatch Hinge Set | 6 | None | 1118 | 799.25 | 318.75 | 0 | PMO escalation if need-by has passed; otherwise refresh quote terms or verify current WMS/QMS status. |
Requirement Coverage
| Requirement-Level Material Coverage | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Exact callout matching only. Inventory allocations exclude existing reservations and apply lot-specific yield; quote coverage uses quoted quantity without an invented yield factor. | |||||||||||||||||||
| Requirement ID | Program ID | Priority | Program | Restriction | MRP Firmed | Alloy | Material Spec | Temper / Condition | Product Form | Need-By Date | Net Required Usable Qty (lb) | Eligible Inventory Allocation (lb) | Selected Quote Coverage (lb) | Total Planned Coverage (lb) | Coverage Balance (lb) | Packet-Period Status | Current Execution Gate | Recommended Sourcing Action | Key Constraint / Rationale |
| REQ-H4A2 | PRG-RAVEN | 1 | Raven Cargo Door Actuation Hinge | DFARS | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 46244 | 842 | 516.6 | 325.4 | 842 | 0 | COVERED—INVENTORY + SELECTED QUOTE | NEED-BY PASSED—PMO ESCALATION | Reserve LOT-7F3A2B; refresh/requote QTE-A3F91C for 325.40 lb coverage. | DFARS; T7351 cannot be supplied by T651. China alternative is ineligible. |
| REQ-K9P1 | PRG-RAVEN | 1 | Raven Cargo Door Actuation Hinge | DFARS | Y | 4340 | AMS 6415 | Annealed | Bar | 46239 | 615 | 615 | 0 | 615 | 0 | COVERED—COMPLIANT INVENTORY | NEED-BY PASSED—PMO ESCALATION | Reserve LOT-3E8C71 and LOT-9A4F37; no purchase planned. | Exact USA 4340 bar inventory covers requirement after yield and existing allocations. |
| REQ-C9T1 | PRG-RAVEN | 1 | Raven Cargo Door Actuation Hinge | DFARS | Y | 300M | AMS 6419 | Annealed | Bar | 46237 | 176 | 0 | 176 | 176 | 0 | COVERED—INVENTORY + SELECTED QUOTE | NEED-BY PASSED—PMO ESCALATION | Refresh/requote QTE-8B3F19; China inventory/quote cannot support DFARS. | DFARS excludes China-melt 300M despite physical stock and lower quote price. |
| REQ-X5M3 | PRG-RAVEN | 1 | Raven Cargo Door Actuation Hinge | DFARS | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46246 | 394 | 394 | 0 | 394 | 0 | COVERED—COMPLIANT INVENTORY | NEED-BY PASSED—PMO ESCALATION | Reserve LOT-6B2F39; no purchase planned. | Qualifying Slovenia source; 3.1/full trace/no hold. |
| REQ-T2C7 | PRG-SABLE | 2 | Sable Emergency Egress Hinge Arm | DFARS | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46258 | 430 | 106.2 | 323.8 | 430 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Reserve remaining LOT-6B2F39; refresh/requote QTE-3A9F18 for residual. | Raven priority consumes compliant inventory first; qualifying quote fills residual. |
| REQ-B6N3 | PRG-SABLE | 2 | Sable Emergency Egress Hinge Arm | DFARS | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 46256 | 268 | 0 | 268 | 268 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Refresh/requote QTE-A3F91C; do not use China T7351 stock. | Only USA T7351 quote selected; no T651 / China substitution. |
| REQ-F6B8 | PRG-SABLE | 2 | Sable Emergency Egress Hinge Arm | DFARS | Y | 6061 | AMS 4117 | T651 | Bar | 46260 | 233 | 233 | 0 | 233 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-7E1C95; no purchase planned. | Exact, eligible USA AMS 4117 bar inventory. |
| REQ-L8Q4 | PRG-SABLE | 2 | Sable Emergency Egress Hinge Arm | DFARS | Tentative | 4340 | AMS 6359 | Norm | Plate | 46262 | 287 | 0 | 287 | 287 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Escalate and refresh/requote QTE-6D1B84; published receipt is only two days pre-need. | Tentative MRP line; only selected DFARS path is published 2026-08-26 receipt vs 2026-08-28 need. |
| REQ-M1X8 | PRG-MERIDIAN | 3 | Meridian Cabin Door Latch Hinge | CUST-EU | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46286 | 512 | 512 | 0 | 512 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-E8C520; no purchase planned. | Exact USA plate inventory covers requirement. |
| REQ-D7R4 | PRG-MERIDIAN | 3 | Meridian Cabin Door Latch Hinge | CUST-EU | Y | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 46283 | 347 | 323.9 | 23.1 | 347 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Reserve LOT-5B2E88; refresh/requote QTE-2D7C64 for 23.10 lb residual. | Meridian receives inventory before lower-priority Tundra; exact USA quote fills residual. |
| REQ-W3F9 | PRG-MERIDIAN | 3 | Meridian Cabin Door Latch Hinge | CUST-EU | Y | 15-5PH | AMS 5659 | H1025 | Bar | 46279 | 198 | 0 | 198 | 198 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Refresh/requote QTE-2F8C41; China H1025 bar is prohibited by CUST-EU. | CUST-EU excludes China; selected France source is approved. |
| REQ-R7W2 | PRG-MERIDIAN | 3 | Meridian Cabin Door Latch Hinge | CUST-EU | Y | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 46277 | 412 | 412 | 0 | 412 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-2C9E14; no purchase planned. | Exact T651 inventory; no T7351 interchange. |
| REQ-G2J9 | PRG-MERIDIAN | 3 | Meridian Cabin Door Latch Hinge | CUST-EU | Tentative | 6061 | AMS 4117 | T651 | Bar | 46281 | 159 | 4.8 | 154.2 | 159 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Use remaining LOT-7E1C95; refresh/requote QTE-1A6E38 for residual if MRP firms. | Great Lakes quote is not approved for AMS 4117; Cascade is selected. |
| REQ-J5G7 | PRG-TUNDRA | 4 | Tundra Cargo Door Stop Fitting | CUST-EU | Y | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 46307 | 455 | 455 | 0 | 455 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-8D4B19 and LOT-2E6B95; no purchase planned. | Higher-priority Tundra receives eligible extrusion before Calder. |
| REQ-P2H6 | PRG-TUNDRA | 4 | Tundra Cargo Door Stop Fitting | CUST-EU | Y | 17-4PH | AMS 5604 | H1075 | Bar | 46304 | 284 | 284 | 0 | 284 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-6F2A87; no purchase planned. | Eligible Korea source inventory covers requirement. |
| REQ-V1D9 | PRG-TUNDRA | 4 | Tundra Cargo Door Stop Fitting | CUST-EU | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46301 | 357 | 0 | 357 | 357 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Refresh/requote QTE-3A9F18 for 357 lb. | Qualifying France 15-5PH plate quote, exact Cond A. |
| REQ-Y8K2 | PRG-TUNDRA | 4 | Tundra Cargo Door Stop Fitting | CUST-EU | Tentative | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 46306 | 213 | 0 | 213 | 213 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Refresh/requote QTE-2D7C64 if MRP firms. | Tentative; selected USA quote is exact extrusion. |
| REQ-Q8L5 | PRG-HALCYON | 5 | Halcyon Service Door Hinge Bracket | None | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46328 | 726 | 726 | 0 | 726 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-E8C520 and LOT-3A7C82; no purchase planned. | Eligible USA plate inventory covers requirement. |
| REQ-Z4V2 | PRG-HALCYON | 5 | Halcyon Service Door Hinge Bracket | None | Y | 4340 | AMS 6359 | Norm | Plate | 46327 | 389 | 0 | 389 | 389 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Refresh/requote QTE-9A2E57 for unrestricted Halcyon only. | China source is acceptable only because Halcyon has no contract country restriction. |
| REQ-N3K4 | PRG-HALCYON | 5 | Halcyon Service Door Hinge Bracket | None | Y | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 46331 | 301 | 301 | 0 | 301 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-9C5F28; no purchase planned. | Eligible USA 2024 plate inventory covers requirement. |
| REQ-S6P3 | PRG-HALCYON | 5 | Halcyon Service Door Hinge Bracket | None | Tentative | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 46330 | 244 | 174.5 | 69.5 | 244 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Reserve remaining LOT-2C9E14; refresh/requote QTE-9E4B27 if MRP firms. | Tentative; higher-priority Meridian uses T651 inventory first. |
| REQ-A2F7 | PRG-CALDER | 6 | Calder Overwing Hatch Hinge Set | None | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46342 | 333 | 333 | 0 | 333 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-3A7C82; no purchase planned. | Eligible USA plate inventory covers requirement. |
| REQ-E9C1 | PRG-CALDER | 6 | Calder Overwing Hatch Hinge Set | None | Y | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 46340 | 271 | 269.25 | 1.75 | 271 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Reserve LOT-2E6B95; refresh/requote QTE-C1E7B4 for residual. | Calder absorbs 1.75 lb residual under lower-priority allocation rule. |
| REQ-U4B8 | PRG-CALDER | 6 | Calder Overwing Hatch Hinge Set | None | Tentative | 17-4PH | AMS 5604 | H1075 | Bar | 46344 | 162 | 5 | 157 | 162 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Use remaining LOT-6F2A87; refresh/requote QTE-7E2A85 if MRP firms. | Tentative; Tundra receives 17-4 inventory first. |
| REQ-H7D5 | PRG-CALDER | 6 | Calder Overwing Hatch Hinge Set | None | Y | 4340 | AMS 6415 | Annealed | Bar | 46339 | 205 | 45 | 160 | 205 | 0 | COVERED—INVENTORY + SELECTED QUOTE | REFRESH/REQUOTE BEFORE PO | Use remaining LOT-9A4F37; refresh/requote QTE-D9F3B1 for residual. | Raven receives 4340 inventory first; USA 3.1 quote fills Calder residual. |
| REQ-W9A3 | PRG-CALDER | 6 | Calder Overwing Hatch Hinge Set | None | Tentative | 15-5PH | AMS 5659 | H1025 | Bar | 46343 | 147 | 147 | 0 | 147 | 0 | COVERED—COMPLIANT INVENTORY | VERIFY CURRENT WMS/QMS STATUS | Reserve LOT-C7A340 for unrestricted Calder; no purchase planned. | China lot has compliant source/cert/trace and no Calder country restriction; cannot support Meridian. |
Allocation Plan
| Recommended Allocation Transactions | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| These are new allocations only from capacity remaining after the inventory snapshot’s existing reservations. Allocated amount is coverage, not gross raw stock. | ||||||||||||
| Allocation ID | Requirement ID | Supply Type | Lot / Quote ID | Supply Source / Heat | Material Identity | Program / Priority | Allocated Usable Coverage (lb) | Available Usable / Quote Capacity (lb) | Need-By Date | Published Quote Receipt | Source / Cert / Origin Basis | Allocation Rationale |
| ALC-001 | REQ-H4A2 | Inventory | LOT-7F3A2B | HEAT-9D4E7B | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | Raven Cargo Door Actuation Hinge / 1 | 516.6 | 516.6 | 46244 | 195 | Highest-priority Raven takes the only DFARS-eligible on-hand T7351 plate first. | |
| ALC-002 | REQ-H4A2 | Quote | QTE-A3F91C | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | Raven Cargo Door Actuation Hinge / 1 | 325.4 | 600 | 46244 | 46233 | Approved; quote cert 3.1; USA | Residual covered by qualifying USA Cascade quote capacity. |
| ALC-003 | REQ-K9P1 | Inventory | LOT-3E8C71 | HEAT-7A2F94 | Brunderman Forge & Bar Inc | 4340 | AMS 6415 | Annealed | Bar | Raven Cargo Door Actuation Hinge / 1 | 416 | 416 | 46239 | 195 | Eligible USA 4340 bar. | |
| ALC-004 | REQ-K9P1 | Inventory | LOT-9A4F37 | HEAT-7B2D58 | Brunderman Forge & Bar Inc | 4340 | AMS 6415 | Annealed | Bar | Raven Cargo Door Actuation Hinge / 1 | 199 | 244 | 46239 | 195 | Eligible USA 4340 bar; Raven priority is applied before Calder. | |
| ALC-005 | REQ-C9T1 | Quote | QTE-8B3F19 | Brunderman Forge & Bar Inc | 300M | AMS 6419 | Annealed | Bar | Raven Cargo Door Actuation Hinge / 1 | 176 | 250 | 46237 | 46229 | Approved; quote cert 3.1; USA | China 300M inventory/quote is excluded by DFARS; USA quote selected. |
| ALC-006 | REQ-X5M3 | Inventory | LOT-6B2F39 | HEAT-2C8D71 | Adriatic Aero Alloys d.o.o. | 15-5PH | AMS 5862 | Cond A | Plate | Raven Cargo Door Actuation Hinge / 1 | 394 | 500.2 | 46246 | 221 | Eligible Adriatic (Slovenia) plate, 3.1/full trace/no hold. | |
| ALC-007 | REQ-T2C7 | Inventory | LOT-6B2F39 | HEAT-2C8D71 | Adriatic Aero Alloys d.o.o. | 15-5PH | AMS 5862 | Cond A | Plate | Sable Emergency Egress Hinge Arm / 2 | 106.2 | 500.2 | 46258 | 221 | Remainder after Raven priority allocation. | |
| ALC-008 | REQ-T2C7 | Quote | QTE-3A9F18 | Ardenne Steelworks SA | 15-5PH | AMS 5862 | Cond A | Plate | Sable Emergency Egress Hinge Arm / 2 | 323.8 | 900 | 46258 | 46240 | Approved; quote cert 3.1; France | Qualifying France quote; selected after compliance and date screen. |
| ALC-009 | REQ-B6N3 | Quote | QTE-A3F91C | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | Sable Emergency Egress Hinge Arm / 2 | 268 | 600 | 46256 | 46233 | Approved; quote cert 3.1; USA | Same compliant T7351 quote covers Sable after Raven residual. |
| ALC-010 | REQ-F6B8 | Inventory | LOT-7E1C95 | HEAT-2D5A83 | Cascade Rolled Products LLC | 6061 | AMS 4117 | T651 | Bar | Sable Emergency Egress Hinge Arm / 2 | 233 | 237.8 | 46260 | 195 | Eligible USA AMS 4117 bar. | |
| ALC-011 | REQ-L8Q4 | Quote | QTE-6D1B84 | Brunderman Forge & Bar Inc | 4340 | AMS 6359 | Norm | Plate | Sable Emergency Egress Hinge Arm / 2 | 287 | 450 | 46262 | 46260 | Approved; quote cert 3.1; USA | Only selected DFARS-compliant 4340 plate path; published dock is marginal. |
| ALC-012 | REQ-M1X8 | Inventory | LOT-E8C520 | HEAT-2A6B74 | Cascade Rolled Products LLC | 6061 | AMS-QQ-A-250/11 | T651 | Plate | Meridian Cabin Door Latch Hinge / 3 | 512 | 950.4 | 46286 | 195 | Eligible USA 6061 plate. | |
| ALC-013 | REQ-D7R4 | Inventory | LOT-5B2E88 | HEAT-3D8F52 | Cascade Rolled Products LLC | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | Meridian Cabin Door Latch Hinge / 3 | 323.9 | 323.9 | 46283 | 195 | Eligible USA 2024 extrusion allocated to higher-priority Meridian first. | |
| ALC-014 | REQ-D7R4 | Quote | QTE-2D7C64 | Cascade Rolled Products LLC | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | Meridian Cabin Door Latch Hinge / 3 | 23.1 | 400 | 46283 | 46236 | Approved; quote cert 3.1; USA | Residual on compliant USA Cascade 2024 extrusion quote. |
| ALC-015 | REQ-W3F9 | Quote | QTE-2F8C41 | Ardenne Steelworks SA | 15-5PH | AMS 5659 | H1025 | Bar | Meridian Cabin Door Latch Hinge / 3 | 198 | 300 | 46279 | 46243 | Approved; quote cert 3.1; France | China H1025 bar is prohibited by CUST-EU; France quote selected. |
| ALC-016 | REQ-R7W2 | Inventory | LOT-2C9E14 | HEAT-4A1F60 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T651 | Plate | Meridian Cabin Door Latch Hinge / 3 | 412 | 586.5 | 46277 | 195 | Eligible USA T651 plate; no T7351 interchange is used. | |
| ALC-017 | REQ-G2J9 | Inventory | LOT-7E1C95 | HEAT-2D5A83 | Cascade Rolled Products LLC | 6061 | AMS 4117 | T651 | Bar | Meridian Cabin Door Latch Hinge / 3 | 4.8 | 237.8 | 46281 | 195 | Remainder after Sable priority allocation. | |
| ALC-018 | REQ-G2J9 | Quote | QTE-1A6E38 | Cascade Rolled Products LLC | 6061 | AMS 4117 | T651 | Bar | Meridian Cabin Door Latch Hinge / 3 | 154.2 | 300 | 46281 | 46246 | Approved; quote cert 3.1; USA | Cascade is approved for AMS 4117; Great Lakes quote is not. |
| ALC-019 | REQ-J5G7 | Inventory | LOT-8D4B19 | HEAT-1C9E37 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | Tundra Cargo Door Stop Fitting / 4 | 388.85 | 388.85 | 46307 | 195 | Eligible USA extrusion allocated to higher-priority Tundra first. | |
| ALC-020 | REQ-J5G7 | Inventory | LOT-2E6B95 | HEAT-7D3F28 | Great Lakes Plate & Bar Co | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | Tundra Cargo Door Stop Fitting / 4 | 66.15 | 335.4 | 46307 | 195 | Remainder from second eligible USA extrusion lot. | |
| ALC-021 | REQ-P2H6 | Inventory | LOT-6F2A87 | HEAT-5D3B81 | Pohang Advanced Alloy | 17-4PH | AMS 5604 | H1075 | Bar | Tundra Cargo Door Stop Fitting / 4 | 284 | 289 | 46304 | 284 | Eligible Korean 17-4PH bar. | |
| ALC-022 | REQ-V1D9 | Quote | QTE-3A9F18 | Ardenne Steelworks SA | 15-5PH | AMS 5862 | Cond A | Plate | Tundra Cargo Door Stop Fitting / 4 | 357 | 900 | 46301 | 46240 | Approved; quote cert 3.1; France | Qualifying France 15-5PH plate quote. |
| ALC-023 | REQ-Y8K2 | Quote | QTE-2D7C64 | Cascade Rolled Products LLC | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | Tundra Cargo Door Stop Fitting / 4 | 213 | 400 | 46306 | 46236 | Approved; quote cert 3.1; USA | Compliant USA 2024 extrusion quote. |
| ALC-024 | REQ-Q8L5 | Inventory | LOT-E8C520 | HEAT-2A6B74 | Cascade Rolled Products LLC | 6061 | AMS-QQ-A-250/11 | T651 | Plate | Halcyon Service Door Hinge Bracket / 5 | 438.4 | 950.4 | 46328 | 195 | Remainder after Meridian allocation. | |
| ALC-025 | REQ-Q8L5 | Inventory | LOT-3A7C82 | HEAT-5B1E94 | Great Lakes Plate & Bar Co | 6061 | AMS-QQ-A-250/11 | T651 | Plate | Halcyon Service Door Hinge Bracket / 5 | 287.6 | 765.6 | 46328 | 195 | Eligible USA 6061 plate. | |
| ALC-026 | REQ-Z4V2 | Quote | QTE-9A2E57 | Yellow River Specialty Steel | 4340 | AMS 6359 | Norm | Plate | Halcyon Service Door Hinge Bracket / 5 | 389 | 500 | 46327 | 46252 | Approved; quote cert 3.1; China | China melt is permitted only for unrestricted Halcyon; not used for Sable. |
| ALC-027 | REQ-N3K4 | Inventory | LOT-9C5F28 | HEAT-3F6D17 | Cascade Rolled Products LLC | 2024 | AMS-QQ-A-250/4 | T351 | Plate | Halcyon Service Door Hinge Bracket / 5 | 301 | 385.95 | 46331 | 195 | Eligible USA 2024 plate. | |
| ALC-028 | REQ-S6P3 | Inventory | LOT-2C9E14 | HEAT-4A1F60 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T651 | Plate | Halcyon Service Door Hinge Bracket / 5 | 174.5 | 586.5 | 46330 | 195 | Remainder after Meridian priority allocation. | |
| ALC-029 | REQ-S6P3 | Quote | QTE-9E4B27 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T651 | Plate | Halcyon Service Door Hinge Bracket / 5 | 69.5 | 500 | 46330 | 46238 | Approved; quote cert 3.1; USA | Compliant USA T651 plate quote; no temper substitution. |
| ALC-030 | REQ-A2F7 | Inventory | LOT-3A7C82 | HEAT-5B1E94 | Great Lakes Plate & Bar Co | 6061 | AMS-QQ-A-250/11 | T651 | Plate | Calder Overwing Hatch Hinge Set / 6 | 333 | 765.6 | 46342 | 195 | Eligible USA 6061 plate. | |
| ALC-031 | REQ-E9C1 | Inventory | LOT-2E6B95 | HEAT-7D3F28 | Great Lakes Plate & Bar Co | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | Calder Overwing Hatch Hinge Set / 6 | 269.25 | 335.4 | 46340 | 195 | Remainder after Tundra priority allocation. | |
| ALC-032 | REQ-E9C1 | Quote | QTE-C1E7B4 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | Calder Overwing Hatch Hinge Set / 6 | 1.75 | 500 | 46340 | 46237 | Approved; quote cert 3.1; USA | Calder is lower priority and absorbs the small residual; USA quote meets callout. |
| ALC-033 | REQ-U4B8 | Inventory | LOT-6F2A87 | HEAT-5D3B81 | Pohang Advanced Alloy | 17-4PH | AMS 5604 | H1075 | Bar | Calder Overwing Hatch Hinge Set / 6 | 5 | 289 | 46344 | 284 | Remainder after Tundra priority allocation. | |
| ALC-034 | REQ-U4B8 | Quote | QTE-7E2A85 | Adriatic Aero Alloys d.o.o. | 17-4PH | AMS 5604 | H1075 | Bar | Calder Overwing Hatch Hinge Set / 6 | 157 | 250 | 46344 | 46249 | Approved; quote cert 3.1; Slovenia | Eligible Slovenia 17-4PH quote. |
| ALC-035 | REQ-H7D5 | Inventory | LOT-9A4F37 | HEAT-7B2D58 | Brunderman Forge & Bar Inc | 4340 | AMS 6415 | Annealed | Bar | Calder Overwing Hatch Hinge Set / 6 | 45 | 244 | 46339 | 195 | Remainder after Raven priority allocation. | |
| ALC-036 | REQ-H7D5 | Quote | QTE-D9F3B1 | Great Lakes Plate & Bar Co | 4340 | AMS 6415 | Annealed | Bar | Calder Overwing Hatch Hinge Set / 6 | 160 | 500 | 46339 | 46226 | Approved; quote cert 3.1; USA | Eligible USA 4340 bar quote; Tri-State C of C alternative is excluded. |
| ALC-037 | REQ-W9A3 | Inventory | LOT-C7A340 | HEAT-9F1B66 | Hangzhou Precision Alloys Co | 15-5PH | AMS 5659 | H1025 | Bar | Calder Overwing Hatch Hinge Set / 6 | 147 | 252 | 46343 | 332 | China origin is acceptable only for unrestricted Calder; not allocated to CUST-EU Meridian. |
Purchase Plan
| Selected Quote Purchase Plan | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target PO quantity = MAX(assigned coverage, stated minimum order), constrained by offered capacity. It is a planning quantity only; the packet does not document partial-order confirmation, so buyer must revalidate before PO release. | ||||||||||||||
| Quote ID | Source | Material Identity | Assigned Requirement(s) | Quote Capacity (lb) | Stated MOQ (lb) | Allocated Quote Coverage (lb) | Modeled Target PO Qty (lb) | Unit Price ($/lb) | Estimated Target Spend ($) | Published Receipt | Quote Expiry | Current Quote Term | Packet-Date Feasibility | Buyer Action / Tradeoff |
| QTE-A3F91C | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | REQ-H4A2, REQ-B6N3 | 600 | 250 | 593.4 | 593.4 | 9.4 | 5577.96 | 46233 | 46218 | EXPIRED | FEASIBLE ON PUBLISHED DATES | USA, 3.1, exact T7351; covers Raven/Sable combined residual. Cheaper and on time versus split/later alternative for Raven. |
| QTE-8B3F19 | Brunderman Forge & Bar Inc | 300M | AMS 6419 | Annealed | Bar | REQ-C9T1 | 250 | 150 | 176 | 176 | 14.2 | 2499.2 | 46229 | 46217 | EXPIRED | FEASIBLE ON PUBLISHED DATES | Only selected DFARS-compliant 300M path; lower-priced China alternative is ineligible. |
| QTE-3A9F18 | Ardenne Steelworks SA | 15-5PH | AMS 5862 | Cond A | Plate | REQ-T2C7, REQ-V1D9 | 900 | 400 | 680.8 | 680.8 | 11.75 | 7999.4 | 46240 | 46223 | EXPIRED | FEASIBLE ON PUBLISHED DATES | France / qualifying source, 3.1. Lower unit price than Adriatic; published arrival remains before Sable/Tundra needs. |
| QTE-2D7C64 | Cascade Rolled Products LLC | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | REQ-D7R4, REQ-Y8K2 | 400 | 200 | 236.1 | 236.1 | 7.6 | 1794.36 | 46236 | 46222 | EXPIRED | FEASIBLE ON PUBLISHED DATES | USA, 3.1, lower unit price than Tri-State; covers Meridian/Tundra extrusion residuals. |
| QTE-1A6E38 | Cascade Rolled Products LLC | 6061 | AMS 4117 | T651 | Bar | REQ-G2J9 | 300 | 150 | 154.2 | 154.2 | 5.75 | 886.65 | 46246 | 46228 | EXPIRED | FEASIBLE ON PUBLISHED DATES | Cascade is AMS 4117-approved; Great Lakes alternative lacks that spec-family approval. |
| QTE-6D1B84 | Brunderman Forge & Bar Inc | 4340 | AMS 6359 | Norm | Plate | REQ-L8Q4 | 450 | 250 | 287 | 287 | 6.9 | 1980.3 | 46260 | 46239 | EXPIRED | FEASIBLE ON PUBLISHED DATES | Only selected DFARS-compliant 4340 plate path for Sable; receipt is only two calendar days before need-by. |
| QTE-9A2E57 | Yellow River Specialty Steel | 4340 | AMS 6359 | Norm | Plate | REQ-Z4V2 | 500 | 250 | 389 | 389 | 5.45 | 2120.05 | 46252 | 46236 | EXPIRED | FEASIBLE ON PUBLISHED DATES | China origin is permissible only for unrestricted Halcyon; do not allocate to DFARS Sable. |
| QTE-2F8C41 | Ardenne Steelworks SA | 15-5PH | AMS 5659 | H1025 | Bar | REQ-W3F9 | 300 | 150 | 198 | 198 | 9.85 | 1950.3 | 46243 | 46226 | EXPIRED | FEASIBLE ON PUBLISHED DATES | France / qualifying; avoids prohibited China melt for Meridian. |
| QTE-9E4B27 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T651 | Plate | REQ-S6P3 | 500 | 250 | 69.5 | 250 | 8.7 | 2175 | 46238 | 46223 | EXPIRED | FEASIBLE ON PUBLISHED DATES | USA exact T651; selected after Meridian priority consumes inventory. MOQ creates 180.50 lb unassigned remainder. |
| QTE-C1E7B4 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | REQ-E9C1 | 500 | 250 | 1.75 | 250 | 8.9 | 2225 | 46237 | 46225 | EXPIRED | FEASIBLE ON PUBLISHED DATES | USA exact extrusion; MOQ creates 248.25 lb unassigned remainder for a 1.75 lb Calder residual. |
| QTE-7E2A85 | Adriatic Aero Alloys d.o.o. | 17-4PH | AMS 5604 | H1075 | Bar | REQ-U4B8 | 250 | 150 | 157 | 157 | 11.1 | 1742.7 | 46249 | 46226 | EXPIRED | FEASIBLE ON PUBLISHED DATES | Slovenia / qualifying; lowest modeled spend among compliant 17-4 alternatives at required coverage. |
| QTE-D9F3B1 | Great Lakes Plate & Bar Co | 4340 | AMS 6415 | Annealed | Bar | REQ-H7D5 | 500 | 250 | 160 | 250 | 5.35 | 1337.5 | 46226 | 46217 | EXPIRED | FEASIBLE ON PUBLISHED DATES | USA, 3.1; lower modeled commitment than Brunderman due to 250 lb MOQ. Tri-State C of C is invalid. |
Inventory Usability
| Inventory Lot Usability Assessment | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A lot is usable only when every policy gate is met. Physical quantity and yield alone never make a lot eligible. | |||||||||||||||||||||
| Lot ID | Requirement ID | Program / Restriction | Alloy | Material Spec | Temper / Condition | Product Form | On Hand (lb) | Existing Allocation (lb) | Free Physical (lb) | Yield Factor | Yield-Adjusted Free (lb) | Source ID | Approval Status OK | Spec Family OK | Cert 3.1/3.2 OK | Traceability Full OK | No Hold OK | Origin OK | Exact Callout OK | Overall Usable for Requirement | Disposition / Reason |
| LOT-1D6B43 | REQ-X5M3 | Raven Cargo Door Actuation Hinge / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 800 | 0 | 800 | 0.83 | 664 | SRC-2D8B96 | N | Y | Y | Y | Y | N | Y | NOT USABLE | source status Not Approved; Russia melt violates DFARS |
| LOT-1D6B43 | REQ-T2C7 | Sable Emergency Egress Hinge Arm / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 800 | 0 | 800 | 0.83 | 664 | SRC-2D8B96 | N | Y | Y | Y | Y | N | Y | NOT USABLE | source status Not Approved; Russia melt violates DFARS |
| LOT-1D6B43 | REQ-V1D9 | Tundra Cargo Door Stop Fitting / CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 800 | 0 | 800 | 0.83 | 664 | SRC-2D8B96 | N | Y | Y | Y | Y | N | Y | NOT USABLE | source status Not Approved; Russia melt violates CUST-EU |
| LOT-1F9D63 | REQ-M1X8 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 760 | 0 | 760 | 0.86 | 653.6 | SRC-A47C21 | N | Y | Y | N | Y | Y | Y | NOT USABLE | source status Suspended; traceability is not Full |
| LOT-1F9D63 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 760 | 0 | 760 | 0.86 | 653.6 | SRC-A47C21 | N | Y | Y | N | Y | Y | Y | NOT USABLE | source status Suspended; traceability is not Full |
| LOT-1F9D63 | REQ-A2F7 | Calder Overwing Hatch Hinge Set / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 760 | 0 | 760 | 0.86 | 653.6 | SRC-A47C21 | N | Y | Y | N | Y | Y | Y | NOT USABLE | source status Suspended; traceability is not Full |
| LOT-2B7E54 | REQ-C9T1 | Raven Cargo Door Actuation Hinge / DFARS | 300M | AMS 6419 | Annealed | Bar | 290 | 0 | 290 | 0.74 | 214.6 | SRC-C2F9A7 | Y | Y | Y | Y | Y | N | Y | NOT USABLE | China melt violates DFARS |
| LOT-2C9E14 | REQ-R7W2 | Meridian Cabin Door Latch Hinge / CUST-EU | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 690 | 0 | 690 | 0.85 | 586.5 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-2C9E14 | REQ-S6P3 | Halcyon Service Door Hinge Bracket / None | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 690 | 0 | 690 | 0.85 | 586.5 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-2E6B95 | REQ-J5G7 | Tundra Cargo Door Stop Fitting / CUST-EU | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 430 | 0 | 430 | 0.78 | 335.4 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-2E6B95 | REQ-E9C1 | Calder Overwing Hatch Hinge Set / None | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 430 | 0 | 430 | 0.78 | 335.4 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-3A7C82 | REQ-M1X8 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 880 | 0 | 880 | 0.87 | 765.6 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-3A7C82 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 880 | 0 | 880 | 0.87 | 765.6 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-3A7C82 | REQ-A2F7 | Calder Overwing Hatch Hinge Set / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 880 | 0 | 880 | 0.87 | 765.6 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-3E8C71 | REQ-K9P1 | Raven Cargo Door Actuation Hinge / DFARS | 4340 | AMS 6415 | Annealed | Bar | 520 | 0 | 520 | 0.8 | 416 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-3E8C71 | REQ-H7D5 | Calder Overwing Hatch Hinge Set / None | 4340 | AMS 6415 | Annealed | Bar | 520 | 0 | 520 | 0.8 | 416 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-4A8D62 | REQ-R7W2 | Meridian Cabin Door Latch Hinge / CUST-EU | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 700 | 0 | 700 | 0.84 | 588 | SRC-D14E8B | Y | Y | N | Y | Y | Y | Y | NOT USABLE | C of C does not meet 3.1 minimum |
| LOT-4A8D62 | REQ-S6P3 | Halcyon Service Door Hinge Bracket / None | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 700 | 0 | 700 | 0.84 | 588 | SRC-D14E8B | Y | Y | N | Y | Y | Y | Y | NOT USABLE | C of C does not meet 3.1 minimum |
| LOT-4D1A95 | REQ-X5M3 | Raven Cargo Door Actuation Hinge / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 540 | 0 | 540 | 0.81 | 437.4 | SRC-B9D472 | N | Y | Y | Y | Y | Y | Y | NOT USABLE | source status Conditional |
| LOT-4D1A95 | REQ-T2C7 | Sable Emergency Egress Hinge Arm / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 540 | 0 | 540 | 0.81 | 437.4 | SRC-B9D472 | N | Y | Y | Y | Y | Y | Y | NOT USABLE | source status Conditional |
| LOT-4D1A95 | REQ-V1D9 | Tundra Cargo Door Stop Fitting / CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 540 | 0 | 540 | 0.81 | 437.4 | SRC-B9D472 | N | Y | Y | Y | Y | Y | Y | NOT USABLE | source status Conditional |
| LOT-5B2E88 | REQ-D7R4 | Meridian Cabin Door Latch Hinge / CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 410 | 0 | 410 | 0.79 | 323.9 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-5B2E88 | REQ-Y8K2 | Tundra Cargo Door Stop Fitting / CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 410 | 0 | 410 | 0.79 | 323.9 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-5C9A16 | REQ-H4A2 | Raven Cargo Door Actuation Hinge / DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 920 | 0 | 920 | 0.8 | 736 | SRC-7A6D52 | Y | Y | Y | Y | Y | N | Y | NOT USABLE | China melt violates DFARS |
| LOT-5C9A16 | REQ-B6N3 | Sable Emergency Egress Hinge Arm / DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 920 | 0 | 920 | 0.8 | 736 | SRC-7A6D52 | Y | Y | Y | Y | Y | N | Y | NOT USABLE | China melt violates DFARS |
| LOT-6B2F39 | REQ-X5M3 | Raven Cargo Door Actuation Hinge / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 610 | 0 | 610 | 0.82 | 500.2 | SRC-E5C913 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-6B2F39 | REQ-T2C7 | Sable Emergency Egress Hinge Arm / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 610 | 0 | 610 | 0.82 | 500.2 | SRC-E5C913 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-6B2F39 | REQ-V1D9 | Tundra Cargo Door Stop Fitting / CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 610 | 0 | 610 | 0.82 | 500.2 | SRC-E5C913 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-6F2A87 | REQ-P2H6 | Tundra Cargo Door Stop Fitting / CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | 470 | 130 | 340 | 0.85 | 289 | SRC-6E3F88 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-6F2A87 | REQ-U4B8 | Calder Overwing Hatch Hinge Set / None | 17-4PH | AMS 5604 | H1075 | Bar | 470 | 130 | 340 | 0.85 | 289 | SRC-6E3F88 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-7E1C95 | REQ-F6B8 | Sable Emergency Egress Hinge Arm / DFARS | 6061 | AMS 4117 | T651 | Bar | 330 | 40 | 290 | 0.82 | 237.8 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-7E1C95 | REQ-G2J9 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS 4117 | T651 | Bar | 330 | 40 | 290 | 0.82 | 237.8 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-7F3A2B | REQ-H4A2 | Raven Cargo Door Actuation Hinge / DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 1040 | 410 | 630 | 0.82 | 516.6 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-7F3A2B | REQ-B6N3 | Sable Emergency Egress Hinge Arm / DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 1040 | 410 | 630 | 0.82 | 516.6 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-8D4B19 | REQ-J5G7 | Tundra Cargo Door Stop Fitting / CUST-EU | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 600 | 95 | 505 | 0.77 | 388.85 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-8D4B19 | REQ-E9C1 | Calder Overwing Hatch Hinge Set / None | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 600 | 95 | 505 | 0.77 | 388.85 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-8F4D17 | REQ-P2H6 | Tundra Cargo Door Stop Fitting / CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | 250 | 0 | 250 | 0.85 | 212.5 | SRC-3B7C19 | Y | Y | Y | Y | N | Y | Y | NOT USABLE | open hold: Quality Hold - Recv Insp |
| LOT-8F4D17 | REQ-U4B8 | Calder Overwing Hatch Hinge Set / None | 17-4PH | AMS 5604 | H1075 | Bar | 250 | 0 | 250 | 0.85 | 212.5 | SRC-3B7C19 | Y | Y | Y | Y | N | Y | Y | NOT USABLE | open hold: Quality Hold - Recv Insp |
| LOT-9A4F37 | REQ-K9P1 | Raven Cargo Door Actuation Hinge / DFARS | 4340 | AMS 6415 | Annealed | Bar | 305 | 0 | 305 | 0.8 | 244 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-9A4F37 | REQ-H7D5 | Calder Overwing Hatch Hinge Set / None | 4340 | AMS 6415 | Annealed | Bar | 305 | 0 | 305 | 0.8 | 244 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-9C5F28 | REQ-N3K4 | Halcyon Service Door Hinge Bracket / None | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 540 | 75 | 465 | 0.83 | 385.95 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-A1E9F4 | REQ-M1X8 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 980 | 300 | 680 | 0.87 | 591.6 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-A1E9F4 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 980 | 300 | 680 | 0.87 | 591.6 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-A1E9F4 | REQ-A2F7 | Calder Overwing Hatch Hinge Set / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 980 | 300 | 680 | 0.87 | 591.6 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-B3E7C0 | REQ-X5M3 | Raven Cargo Door Actuation Hinge / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 1180 | 0 | 1180 | 0.83 | 979.4 | SRC-3B7C19 | Y | Y | Y | Y | N | Y | Y | NOT USABLE | open hold: Quality Hold - MRB |
| LOT-B3E7C0 | REQ-T2C7 | Sable Emergency Egress Hinge Arm / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 1180 | 0 | 1180 | 0.83 | 979.4 | SRC-3B7C19 | Y | Y | Y | Y | N | Y | Y | NOT USABLE | open hold: Quality Hold - MRB |
| LOT-B3E7C0 | REQ-V1D9 | Tundra Cargo Door Stop Fitting / CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 1180 | 0 | 1180 | 0.83 | 979.4 | SRC-3B7C19 | Y | Y | Y | Y | N | Y | Y | NOT USABLE | open hold: Quality Hold - MRB |
| LOT-C7A340 | REQ-W3F9 | Meridian Cabin Door Latch Hinge / CUST-EU | 15-5PH | AMS 5659 | H1025 | Bar | 360 | 60 | 300 | 0.84 | 252 | SRC-7A6D52 | Y | Y | Y | Y | Y | N | Y | NOT USABLE | China melt violates CUST-EU |
| LOT-C7A340 | REQ-W9A3 | Calder Overwing Hatch Hinge Set / None | 15-5PH | AMS 5659 | H1025 | Bar | 360 | 60 | 300 | 0.84 | 252 | SRC-7A6D52 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-D6B821 | REQ-K9P1 | Raven Cargo Door Actuation Hinge / DFARS | 4340 | AMS 6415 | Annealed | Bar | 880 | 120 | 760 | 0.78 | 592.8 | SRC-D14E8B | Y | Y | N | Y | Y | Y | Y | NOT USABLE | C of C does not meet 3.1 minimum |
| LOT-D6B821 | REQ-H7D5 | Calder Overwing Hatch Hinge Set / None | 4340 | AMS 6415 | Annealed | Bar | 880 | 120 | 760 | 0.78 | 592.8 | SRC-D14E8B | Y | Y | N | Y | Y | Y | Y | NOT USABLE | C of C does not meet 3.1 minimum |
| LOT-E8C520 | REQ-M1X8 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 1320 | 240 | 1080 | 0.88 | 950.4 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-E8C520 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 1320 | 240 | 1080 | 0.88 | 950.4 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
| LOT-E8C520 | REQ-A2F7 | Calder Overwing Hatch Hinge Set / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 1320 | 240 | 1080 | 0.88 | 950.4 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | Y | USABLE | Eligible if unallocated capacity remains |
Quote Feasibility
| Supplier Quote Feasibility Assessment | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Each quote is assessed against each exact-match requirement. Quote feasibility is controlled by approval, certification, origin, exact callout, and receipt date—not price or physical availability alone. | |||||||||||||||||||||
| Quote ID | Requirement ID | Program / Restriction | Alloy | Material Spec | Temper / Condition | Product Form | Quote Qty (lb) | Unit Price ($/lb) | Receipt | Quote Expiry | Source ID | Source Approval OK | Spec Family OK | Cert 3.1/3.2 OK | Origin OK | Exact Callout OK | Receipt Before Need-By | Packet-Period Feasibility | Current Quote Term | Selected? | Assessment / Reason |
| QTE-1A6E38 | REQ-F6B8 | Sable Emergency Egress Hinge Arm / DFARS | 6061 | AMS 4117 | T651 | Bar | 300 | 5.75 | 46246 | 46228 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-1A6E38 | REQ-G2J9 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS 4117 | T651 | Bar | 300 | 5.75 | 46246 | 46228 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-1E8C57 | REQ-K9P1 | Raven Cargo Door Actuation Hinge / DFARS | 4340 | AMS 6415 | Annealed | Bar | 650 | 5.2 | 46228 | 46215 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-1E8C57 | REQ-H7D5 | Calder Overwing Hatch Hinge Set / None | 4340 | AMS 6415 | Annealed | Bar | 650 | 5.2 | 46228 | 46215 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-1F7C93 | REQ-P2H6 | Tundra Cargo Door Stop Fitting / CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | 300 | 11.4 | 46235 | 46223 | SRC-3B7C19 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-1F7C93 | REQ-U4B8 | Calder Overwing Hatch Hinge Set / None | 17-4PH | AMS 5604 | H1075 | Bar | 300 | 11.4 | 46235 | 46223 | SRC-3B7C19 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-2A7E61 | REQ-M1X8 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 650 | 4.45 | 46246 | 46231 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-2A7E61 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 650 | 4.45 | 46246 | 46231 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-2A7E61 | REQ-A2F7 | Calder Overwing Hatch Hinge Set / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 650 | 4.45 | 46246 | 46231 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-2D7C64 | REQ-D7R4 | Meridian Cabin Door Latch Hinge / CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 400 | 7.6 | 46236 | 46222 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-2D7C64 | REQ-Y8K2 | Tundra Cargo Door Stop Fitting / CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 400 | 7.6 | 46236 | 46222 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-2F8C41 | REQ-W3F9 | Meridian Cabin Door Latch Hinge / CUST-EU | 15-5PH | AMS 5659 | H1025 | Bar | 300 | 9.85 | 46243 | 46226 | SRC-3B7C19 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-2F8C41 | REQ-W9A3 | Calder Overwing Hatch Hinge Set / None | 15-5PH | AMS 5659 | H1025 | Bar | 300 | 9.85 | 46243 | 46226 | SRC-3B7C19 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-3A9F18 | REQ-X5M3 | Raven Cargo Door Actuation Hinge / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 900 | 11.75 | 46240 | 46223 | SRC-3B7C19 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-3A9F18 | REQ-T2C7 | Sable Emergency Egress Hinge Arm / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 900 | 11.75 | 46240 | 46223 | SRC-3B7C19 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-3A9F18 | REQ-V1D9 | Tundra Cargo Door Stop Fitting / CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 900 | 11.75 | 46240 | 46223 | SRC-3B7C19 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-3D9B16 | REQ-J5G7 | Tundra Cargo Door Stop Fitting / CUST-EU | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 400 | 9.15 | 46232 | 46223 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-3D9B16 | REQ-E9C1 | Calder Overwing Hatch Hinge Set / None | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 400 | 9.15 | 46232 | 46223 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-3F7D92 | REQ-F6B8 | Sable Emergency Egress Hinge Arm / DFARS | 6061 | AMS 4117 | T651 | Bar | 250 | 5.9 | 46242 | 46227 | SRC-7B2F60 | Y | N | Y | Y | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: source not approved for spec family |
| QTE-3F7D92 | REQ-G2J9 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS 4117 | T651 | Bar | 250 | 5.9 | 46242 | 46227 | SRC-7B2F60 | Y | N | Y | Y | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: source not approved for spec family |
| QTE-4C8F12 | REQ-R7W2 | Meridian Cabin Door Latch Hinge / CUST-EU | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 400 | 8.95 | 46235 | 46221 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-4C8F12 | REQ-S6P3 | Halcyon Service Door Hinge Bracket / None | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 400 | 8.95 | 46235 | 46221 | SRC-7B2F60 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-4E9A72 | REQ-C9T1 | Raven Cargo Door Actuation Hinge / DFARS | 300M | AMS 6419 | Annealed | Bar | 300 | 9.55 | 46222 | 46212 | SRC-C2F9A7 | Y | Y | Y | N | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: China melt violates DFARS |
| QTE-5B9E41 | REQ-N3K4 | Halcyon Service Door Hinge Bracket / None | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 350 | 6.65 | 46293 | 46273 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | OPEN | N | Feasible alternative; not selected |
| QTE-5D8B72 | REQ-X5M3 | Raven Cargo Door Actuation Hinge / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 700 | 12.4 | 46237 | 46225 | SRC-E5C913 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-5D8B72 | REQ-T2C7 | Sable Emergency Egress Hinge Arm / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 700 | 12.4 | 46237 | 46225 | SRC-E5C913 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-5D8B72 | REQ-V1D9 | Tundra Cargo Door Stop Fitting / CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 700 | 12.4 | 46237 | 46225 | SRC-E5C913 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-5F1B83 | REQ-M1X8 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 800 | 4.3 | 46259 | 46235 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-5F1B83 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 800 | 4.3 | 46259 | 46235 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-5F1B83 | REQ-A2F7 | Calder Overwing Hatch Hinge Set / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 800 | 4.3 | 46259 | 46235 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-6A2D58 | REQ-P2H6 | Tundra Cargo Door Stop Fitting / CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | 350 | 10.9 | 46238 | 46224 | SRC-6E3F88 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-6A2D58 | REQ-U4B8 | Calder Overwing Hatch Hinge Set / None | 17-4PH | AMS 5604 | H1075 | Bar | 350 | 10.9 | 46238 | 46224 | SRC-6E3F88 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-6D1B84 | REQ-L8Q4 | Sable Emergency Egress Hinge Arm / DFARS | 4340 | AMS 6359 | Norm | Plate | 450 | 6.9 | 46260 | 46239 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-6D1B84 | REQ-Z4V2 | Halcyon Service Door Hinge Bracket / None | 4340 | AMS 6359 | Norm | Plate | 450 | 6.9 | 46260 | 46239 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-6F1A93 | REQ-X5M3 | Raven Cargo Door Actuation Hinge / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 600 | 10.2 | 46229 | 46222 | SRC-B9D472 | N | Y | Y | Y | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: source status Conditional |
| QTE-6F1A93 | REQ-T2C7 | Sable Emergency Egress Hinge Arm / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 600 | 10.2 | 46229 | 46222 | SRC-B9D472 | N | Y | Y | Y | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: source status Conditional |
| QTE-6F1A93 | REQ-V1D9 | Tundra Cargo Door Stop Fitting / CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 600 | 10.2 | 46229 | 46222 | SRC-B9D472 | N | Y | Y | Y | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: source status Conditional |
| QTE-7C3A95 | REQ-N3K4 | Halcyon Service Door Hinge Bracket / None | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 400 | 6.4 | 46287 | 46270 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | FEASIBLE | OPEN | N | Feasible alternative; not selected |
| QTE-7D2B40 | REQ-H4A2 | Raven Cargo Door Actuation Hinge / DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 800 | 6.85 | 46225 | 46213 | SRC-7A6D52 | Y | Y | Y | N | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: China melt violates DFARS |
| QTE-7D2B40 | REQ-B6N3 | Sable Emergency Egress Hinge Arm / DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 800 | 6.85 | 46225 | 46213 | SRC-7A6D52 | Y | Y | Y | N | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: China melt violates DFARS |
| QTE-7E2A85 | REQ-P2H6 | Tundra Cargo Door Stop Fitting / CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | 250 | 11.1 | 46249 | 46226 | SRC-E5C913 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-7E2A85 | REQ-U4B8 | Calder Overwing Hatch Hinge Set / None | 17-4PH | AMS 5604 | H1075 | Bar | 250 | 11.1 | 46249 | 46226 | SRC-E5C913 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-8A1D63 | REQ-W3F9 | Meridian Cabin Door Latch Hinge / CUST-EU | 15-5PH | AMS 5659 | H1025 | Bar | 350 | 7.4 | 46230 | 46220 | SRC-7A6D52 | Y | Y | Y | N | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: China melt violates CUST-EU |
| QTE-8A1D63 | REQ-W9A3 | Calder Overwing Hatch Hinge Set / None | 15-5PH | AMS 5659 | H1025 | Bar | 350 | 7.4 | 46230 | 46220 | SRC-7A6D52 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-8B3F19 | REQ-C9T1 | Raven Cargo Door Actuation Hinge / DFARS | 300M | AMS 6419 | Annealed | Bar | 250 | 14.2 | 46229 | 46217 | SRC-58E1B3 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-8C3D49 | REQ-M1X8 | Meridian Cabin Door Latch Hinge / CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 900 | 4.15 | 46234 | 46224 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-8C3D49 | REQ-Q8L5 | Halcyon Service Door Hinge Bracket / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 900 | 4.15 | 46234 | 46224 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-8C3D49 | REQ-A2F7 | Calder Overwing Hatch Hinge Set / None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 900 | 4.15 | 46234 | 46224 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-9A2E57 | REQ-L8Q4 | Sable Emergency Egress Hinge Arm / DFARS | 4340 | AMS 6359 | Norm | Plate | 500 | 5.45 | 46252 | 46236 | SRC-C2F9A7 | Y | Y | Y | N | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: China melt violates DFARS |
| QTE-9A2E57 | REQ-Z4V2 | Halcyon Service Door Hinge Bracket / None | 4340 | AMS 6359 | Norm | Plate | 500 | 5.45 | 46252 | 46236 | SRC-C2F9A7 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
| QTE-9B4F27 | REQ-D7R4 | Meridian Cabin Door Latch Hinge / CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 350 | 7.85 | 46227 | 46218 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-9B4F27 | REQ-Y8K2 | Tundra Cargo Door Stop Fitting / CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 350 | 7.85 | 46227 | 46218 | SRC-D14E8B | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-9C4E27 | REQ-X5M3 | Raven Cargo Door Actuation Hinge / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 1000 | 8.1 | 46231 | 46221 | SRC-2D8B96 | N | Y | Y | N | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: source status Not Approved; Russia melt violates DFARS |
| QTE-9C4E27 | REQ-T2C7 | Sable Emergency Egress Hinge Arm / DFARS | 15-5PH | AMS 5862 | Cond A | Plate | 1000 | 8.1 | 46231 | 46221 | SRC-2D8B96 | N | Y | Y | N | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: source status Not Approved; Russia melt violates DFARS |
| QTE-9C4E27 | REQ-V1D9 | Tundra Cargo Door Stop Fitting / CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | 1000 | 8.1 | 46231 | 46221 | SRC-2D8B96 | N | Y | Y | N | Y | Y | NOT FEASIBLE | EXPIRED | N | Reject: source status Not Approved; Russia melt violates CUST-EU |
| QTE-9E4B27 | REQ-R7W2 | Meridian Cabin Door Latch Hinge / CUST-EU | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 500 | 8.7 | 46238 | 46223 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | N | Feasible alternative; not selected |
| QTE-9E4B27 | REQ-S6P3 | Halcyon Service Door Hinge Bracket / None | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 500 | 8.7 | 46238 | 46223 | SRC-9F2A41 | Y | Y | Y | Y | Y | Y | FEASIBLE | EXPIRED | Y | SELECTED—refresh/requote before PO |
Alternatives & Esc.
| Rejected Alternatives and Required Escalations | |||||
|---|---|---|---|---|---|
| Compliance gates are authoritative. The items below must not be converted into planned coverage without the documented disposition or a newly valid quotation. | |||||
| Alternative / Lot / Quote | Affected Requirement(s) | Why It Cannot Be Used / Why Not Selected | Controlling Source Fact | Disposition | |
| LOT-5C9A16; QTE-7D2B40 | REQ-H4A2, REQ-B6N3 | China-melt 7075-T7351 is physically present/low priced but ineligible for DFARS. | AMSL: SRC-7A6D52 non-qualifying China; program schedule DFARS. | Do not allocate or buy for Raven/Sable. | |
| LOT-2B7E54; QTE-4E9A72 | REQ-C9T1 | China-melt 300M fails Raven DFARS despite 3.1 and lower price. | AMSL origin / program schedule. | Use only qualifying USA quote capacity. | |
| LOT-B3E7C0; LOT-8F4D17 | 15-5PH plate / 17-4PH bar requirements | Open MRB/receiving-inspection holds make stock ineligible. | Inventory snapshot hold status; ENG-MSP §2. | No planned coverage; MRB/QMS disposition required before future use. | |
| LOT-D6B821; LOT-4A8D62; QTE-B6D2A9 | 4340 bar; 7075-T651 plate | C of C only does not satisfy 3.1 minimum. | Inventory/quote cert field; ENG-MSP §2. | Reject; do not use for certified production. | |
| LOT-1F9D63 | 6061 plate requirements | Partial traceability and a suspended source. | Inventory traceability; AMSL SRC-A47C21 suspended. | Reject; no allocation. | |
| LOT-4D1A95; QTE-6F1A93 | 15-5PH plate requirements | Conditional source is ineligible for new commitments. | AMSL SRC-B9D472 conditional; ENG-MSP §3. | Reject for current plan. | |
| LOT-1D6B43; QTE-9C4E27 | 15-5PH plate requirements | Russia melt and Not Approved source. | AMSL SRC-2D8B96; DFARS/CUST-EU restrictions. | Reject. | |
| QTE-3F7D92 | REQ-G2J9 | Great Lakes is not approved for AMS 4117 even though quote has 3.1 and USA origin. | AMSL approved spec families omit AMS 4117. | Reject; Cascade quote is selected. | |
| QTE-F1C8A6 | REQ-H4A2 | Published receipt 2026-08-14 is after Raven 2026-08-10 need-by. | Quote receipt / demand forecast. | Not a Raven resolution; combined Cascade quote selected. | |
| QTE-9A2E57 | REQ-L8Q4 | China melt cannot support DFARS Sable, though it can support unrestricted Halcyon. | Program schedule restriction. | Allocate only to REQ-Z4V2. | |
| T651 / T7351 / form changes | All related aluminum requirements | No temper-family or product-form interchange is enumerated in policy. | ENG-MSP §4. | No substitution proposed. | |
| Escalation | Severity | Affected Requirement(s) | Required Action / Owner | Basis / Timing | Do Not Assume |
| ESC-01 — Expired quote terms | Critical | All requirements with selected quote coverage | Sourcing: obtain reissued written quote / reconfirm exact quantity, price, receipt, 3.1 certificate, melt country, and current approval before PO. Do not release from expired terms. | All selected quote expiries are before 2026-08-20. | No quoted capacity, price, or delivery date remains committed. |
| ESC-02 — Passed need-bys / stale snapshot | Critical | All Raven lines; any line whose need-by has passed | PMO + Materials + Quality: verify actual floor/WMS/QMS condition, current reservations, and whether recovery is required. | Packet schedule/inventory dates are June; several need-bys are before review date. | Do not treat June snapshot or historical quote receipt as present availability. |
| ESC-03 — Sable 4340 plate | Critical | REQ-L8Q4 | PMO / Sourcing / MRB: decide whether tentative line is firm; revalidate a compliant source. If still needed, raise delivery risk immediately. | QTE-6D1B84 published receipt is 2026-08-26 vs 2026-08-28 need-by; now expired. | No expedite, waiver, or alternative supplier is assumed. |
| ESC-04 — Quality-held inventory | High | 15-5PH plate and 17-4PH bar demand | Quality/MRB: disposition held lots independently; they are not in the plan. | LOT-B3E7C0 and LOT-8F4D17 are on hold. | A hold clearance is not assumed. |
| ESC-05 — Priority protection | High | Contested 4340 bar, 7075 extrusion, 6061 bar, 17-4PH bar | PMO: preserve allocations to higher-priority Raven/Sable/Tundra; Calder bears documented residual purchases unless PMO formally changes priorities. | Program schedule §4 gives lower rank first claim. | No reallocation of existing reservations or priority change is assumed. |
| ESC-06 — Tentative MRP lines | Medium | REQ-L8Q4, REQ-G2J9, REQ-Y8K2, REQ-S6P3, REQ-U4B8 | Materials Planning / PMO: firm or cancel before accepting material beyond the allocation target; retain no compliance exception. | Demand forecast MRP Firmed = Tentative. | Tentative status does not authorize use of restricted material. |
Methodology
| Methodology and Source Controls | |||
|---|---|---|---|
| Use this sheet to understand the authoritative decision sequence and the limitations of the packet-period recommendation. | |||
| Step | Decision Rule Applied | Source / Rule | Effect in This Analysis |
| 1 | Match alloy, material specification, temper/condition, and product form exactly. No substitution is used unless expressly allowed. | ENG-MSP §1 and §4; demand forecast README. | All planned coverage is exact callout match; T651 and T7351 remain separate; no form change. |
| 2 | Require 3.1/3.2 test report, Full traceability, and no open quality hold. | ENG-MSP §2; inventory/quote fields. | C of C-only, partial-trace, and held lots/quotes are excluded. |
| 3 | Require Approved status and approved specification family on AMSL; conditional/suspended/not approved sources are ineligible for new commitments. | ENG-MSP §3; AMSL README. | Conditional Lone Star, suspended Meridian, Not Approved Volga, and Great Lakes AMS 4117 mismatch are rejected. |
| 4 | Apply program country restrictions after source/cert check. | Program Priority & Build Schedule §3; ENG-MSP §3. | DFARS excludes China/Russia; CUST-EU excludes China/Russia; unrestricted Halcyon/Calder can use otherwise compliant China-origin material. |
| 5 | Calculate inventory usable quantity as (on hand – existing allocation) × documented yield factor. | ENG-MSP §5; inventory README. | Only yield-adjusted free capacity is allocated; existing reservations are not touched. |
| 6 | Evaluate quote quantity against net usable demand; require quoted receipt before need-by. No undocumented expedite is assumed. | ENG-MSP §§5–6; quote README. | Packet-date feasibility is shown separately from current term status. Sable 4340 plate is flagged marginal. |
| 7 | Allocate insufficient eligible inventory to lower priority rank first; lower-ranked residual is new purchase or escalation. | Program schedule §4. | Raven/Sable/Tundra are protected ahead of Calder in contested pools. |
| 8 | Do not treat historical quotes or June snapshots as live execution evidence. | Quote expiry field; program/inventory source dates; review date. | All selected terms require refresh/revalidation and current WMS/QMS confirmation. |
Source Demand
| Source Data — Material Demand Forecast | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Verbatim data from material_demand_forecast.xlsx / Demand Forecast. Source: MRP-2026-0619-R2. | |||||||||||
| 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 |
Source Inventory
| Source Data — Inventory Lot & Certification Snapshot | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Verbatim data from inventory_lot_cert_snapshot.xlsx / Lot Snapshot. Source: WMS-EXP-20260620-0741 joined to QMS. | ||||||||||||||||
| 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 |
Source Sources
| Source Data — Approved Material Source List | ||||||||
|---|---|---|---|---|---|---|---|---|
| Verbatim data from approved_material_source_list.xlsx / Source List. Controlled document QE-AMSL Rev N, effective 2026-06-01. | ||||||||
| 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 |
Source Quotes
| Source Data — Supplier Quote & Lead-Time Matrix | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Verbatim data from supplier_quote_leadtime_matrix.xlsx / Quote Matrix. Extended Cost is recalculated as quoted quantity × unit price. | ||||||||||||||||
| 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 |
Source Programs
| Source Data — Program Priority & Build Schedule | ||||||
|---|---|---|---|---|---|---|
| Transcribed from program_priority_build_schedule.docx, issued 2026-06-19. The ranking governs contested eligible material allocation. | ||||||
| Program ID | Program / Assembly | Customer | Priority Rank | Build Start | Restriction | Restriction Detail |
| PRG-RAVEN | Raven Cargo Door Actuation Hinge | Lockmar Defense Systems | 1 | 46251 | DFARS | USA or qualifying-country melt only; China/Russia are ineligible. |
| PRG-SABLE | Sable Emergency Egress Hinge Arm | Lockmar Defense Systems | 2 | 46265 | DFARS | USA or qualifying-country melt only; China/Russia are ineligible. |
| PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Aerolux Commercial | 3 | 46293 | CUST-EU | China- and Russia-melt material is prohibited. |
| PRG-TUNDRA | Tundra Cargo Door Stop Fitting | Northwind Regional | 4 | 46314 | CUST-EU | China- and Russia-melt material is prohibited. |
| PRG-HALCYON | Halcyon Service Door Hinge Bracket | Aerolux Commercial | 5 | 46335 | None | Standard AMSL approval, certification, traceability, and hold rules apply. |
| PRG-CALDER | Calder Overwing Hatch Hinge Set | Northwind Regional | 6 | 46349 | None | Standard AMSL approval, certification, traceability, and hold rules apply. |
MATERIAL SOURCING RECOMMENDATION
2026 Q3 Door and Hinge Mechanism Build Wave
To
From
Review date
Decision basis
Sourcing, Production, Quality, MRB, PMO
Material Sourcing Review
20 August 2026
Controlled packet: program release 19 Jun; inventory 20 Jun; AMSL effective 1 Jun; quotes received 12–19 Jun.
Recommendation
Reserve only the compliant inventory allocations and use the twelve selected quotations only as packet-period sourcing candidates. The plan mathematically covers all 26 forecast requirements with exact-callout material; it does not authorize execution from the June snapshot or expired terms.
Decision
Recommendation
Inventory
Reserve 5,857.25 lb of policy-compliant, yield-adjusted inventory as shown in the workbook. Do not disturb existing WMS allocations.
Supplier quotes
Do not issue a PO from any selected quote as written. Every selected term expired before the 20 Aug review date. Sourcing must obtain a written refresh/requote and reconfirm receipt, certification, source approval, and melt origin.
Substitution
None proposed. All planned coverage matches alloy, specification, temper/condition, and form exactly. No T651/T7351, plate/bar/extrusion, or steel-condition interchange is assumed.
Priority
Keep higher-priority Raven, Sable, and Tundra inventory allocations ahead of lower-ranked programs. Calder carries the documented residual buys on contested pools.
Packet-period coverage and current execution status
Metric
Result
Interpretation
Forecast demand
8,960.00 usable lb
All 26 released/tentative forecast lines.
Eligible inventory allocated
5,857.25 usable lb
Net of existing allocations and documented lot yield; compliance-screened.
Selected quote coverage
3,102.75 lb
Exact-callout quote capacity assigned to the residual requirements.
Modeled quote target
3,621.50 lb / $32,288.42
Greater of allocation coverage and stated MOQ. This is not a committed buy; no partial-order confirmation or rounding rule is documented.
Execution gate
0 selected terms open
Published quote terms have expired; several Raven need-by dates have passed.
The “covered” conclusion is a sourcing-plan calculation against the packet’s dates. As of the review date, it must be converted into a current execution assessment through WMS/QMS verification and renewed supplier commitments.
Priority allocation by program
Program / rank
Restriction
Demand lb
Inventory lb
Quote lb
Recommended program action
Raven / 1
DFARS
2,027.00
1,525.60
501.40
Need-bys passed; verify current material/WIP and refresh quote terms.
Sable / 2
DFARS
1,218.00
339.20
878.80
Protect priority; 4340 plate path is marginal and line is tentative.
Meridian / 3
CUST-EU
1,628.00
1,252.70
375.30
China H1025 bar is excluded; reserve plate and revalidate exact quotes.
Tundra / 4
CUST-EU
1,309.00
739.00
570.00
Inventory covers extrusion/17-4; revalidate plate/extrusion quote support.
Halcyon / 5
None
1,660.00
1,201.50
458.50
China 4340 plate is acceptable only here, not for Sable.
Calder / 6
None
1,118.00
799.25
318.75
Lower-priority program absorbs documented residual buys.
Allocation logic
Higher-priority requirements are assigned eligible inventory first where the same material pool is insufficient for all demand. The plan applies that rule to 4340 bar (Raven before Calder), 7075 extrusion (Tundra before Calder), 6061 bar (Sable before Meridian), 2024 extrusion (Meridian before Tundra), 15-5PH plate (Raven before Sable/Tundra), and 17-4PH bar (Tundra before Calder).
The allocation does not reassign any pounds already reserved in the inventory snapshot. Every inventory allocation is after that reservation and the applicable documented yield factor.
Selected quote plan
Selection is compliance-first. The target quantity equals the coverage needed from each selected quote, increased only to the stated MOQ where necessary; it remains subject to written revalidation because the packet does not state that partial quantities are currently orderable.
Quote
Planned use
Cov. lb
Target PO lb
$ / lb
Modeled spend
Current term
QTE-A3F91C
7075-T7351 plate: Raven + Sable
593.40
593.40
$9.40
$5,577.96
Expired
QTE-8B3F19
300M bar: Raven
176.00
176.00
$14.20
$2,499.20
Expired
QTE-3A9F18
15-5PH Cond A plate: Sable + Tundra
680.80
680.80
$11.75
$7,999.40
Expired
QTE-2D7C64
2024 extrusion: Meridian + Tundra
236.10
236.10
$7.60
$1,794.36
Expired
QTE-1A6E38
6061 AMS 4117 bar: Meridian
154.20
154.20
$5.75
$886.65
Expired
QTE-6D1B84
4340 plate: Sable
287.00
287.00
$6.90
$1,980.30
Expired / marginal
QTE-9A2E57
4340 plate: Halcyon only
389.00
389.00
$5.45
$2,120.05
Expired
QTE-2F8C41
15-5PH H1025 bar: Meridian
198.00
198.00
$9.85
$1,950.30
Expired
QTE-9E4B27
7075-T651 plate: Halcyon
69.50
250.00
$8.70
$2,175.00
Expired / MOQ
QTE-C1E7B4
7075 extrusion: Calder
1.75
250.00
$8.90
$2,225.00
Expired / MOQ
QTE-7E2A85
17-4PH H1075 bar: Calder
157.00
157.00
$11.10
$1,742.70
Expired
QTE-D9F3B1
4340 bar: Calder
160.00
250.00
$5.35
$1,337.50
Expired / MOQ
Cost and lead-time tradeoffs
Among compliant alternatives, the selection uses cost only after compliance and published date feasibility. Examples: the USA 300M quote is selected over lower-priced China material for Raven; France 15-5PH plate is selected because it is qualifying and lower-priced than the alternative at the required coverage; and the 4340 plate path for Sable remains a critical risk because the only selected DFARS-compliant published receipt is 26 Aug against a 28 Aug need-by.
The three MOQ-driven lines—QTE-9E4B27, QTE-C1E7B4, and QTE-D9F3B1—create 518.75 lb of unassigned modeled remainder. That remainder is not allocated to a future program in this plan.
Compliance exclusions that govern the plan
Candidate
Why it is not coverage
Required disposition
China 7075-T7351 stock / QTE-7D2B40
Physically available and low priced, but China melt is ineligible for DFARS Raven/Sable.
Do not allocate or buy for Lockmar programs.
China 300M stock / QTE-4E9A72
Fails Raven DFARS origin restriction despite 3.1 paperwork.
Use only qualifying USA quote capacity.
C of C lots and QTE-B6D2A9
C of C lacks the required reported test results; it is not a 3.1 substitute.
Reject for certified hardware.
LOT-B3E7C0 and LOT-8F4D17
Open MRB/receiving-inspection hold.
No planned coverage until formal quality disposition.
LOT-1F9D63 / conditional or suspended sources
Partial traceability, conditional status, or suspended status prevents new commitment.
Reject; no assumption of correction.
QTE-3F7D92 (Great Lakes 6061 bar)
Great Lakes is not approved for AMS 4117, even though origin/cert appear acceptable.
Reject; use Cascade only after quote refresh.
China 4340 plate QTE-9A2E57
Permissible for unrestricted Halcyon, but prohibited for DFARS Sable.
Keep allocation exclusively on REQ-Z4V2.
These exclusions are not commercial preferences. They follow the engineering substitution policy, AMSL, and program contractual restrictions and therefore override price, apparent physical availability, or supplier promises.
Required escalations and handoff
Immediate actions
Sourcing: refresh/requote all twelve selected lines and obtain current written confirmation of amount, price, receipt date, 3.1 certification, melt origin, and source approval before any PO release.
PMO, Materials, and Quality: reconcile the June WMS/QMS snapshot to current physical and floor status. Raven need-bys are already passed on the review date; historical availability is not proof of recovery.
PMO / Sourcing / MRB: escalate REQ-L8Q4 immediately. It is tentative, and its only selected DFARS-compliant published quote was two calendar days ahead of need-by and has expired.
Quality/MRB: independently disposition LOT-B3E7C0 and LOT-8F4D17 if desired for future supply; neither lot is used in this recommendation.
Materials Planning / PMO: firm or cancel the tentative quote-supported lines before accepting material above the modeled allocation target. Tentative status does not relax any compliance constraint.
Source basis and boundary of recommendation
This recommendation relies only on 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 supplied in the packet. It assumes no undocumented alternate alloy, temper, form, source, waiver, certification correction, capacity, expedite, yield change, or allocation change.
The supporting workbook provides requirement-level coverage, lot usability, quote feasibility, allocation transactions, selected purchase targets, rejected alternatives, escalations, methodology, and source-data tabs.
User prompt → 36 turns · 25 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 source packet against the documented certification and sourcing constraints, then create both the recomm…
I’ll review the source packet against the documented certification and sourcing constraints, then create both the recommendation memo and an auditable analysis workbook in
/workspace/output/. I’m using the document and spreadsheet workflows because the requested deliverables are.docxand.xlsxfiles.7Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await Promise.all([ tools.exec_command({"cmd":"sed -n '1,240p' /root/.agents/skills/docx/SKILL.md","yield_time_ms":10000,"max_output_tokens":30000}), tools.exec_command({"cmd":"sed -n '1,260p' /root/.agents/skills/xlsx/SKILL.md","yield_time_ms":10000,"max_output_tokens":30000}), ]); text(r.map(x=>x.output).join("\n\n--- XLSX SKILL ---\n\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,340 more characters of output in the raw trajectory.
8Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await Promise.all([ tools.exec_command({"cmd":"sed -n '241,520p' /root/.agents/skills/docx/SKILL.md","yield_time_ms":10000,"max_output_tokens":30000}), tools.exec_command({"cmd":"sed -n '261,620p' /root/.agents/skills/xlsx/SKILL.md","yield_time_ms":10000,"max_output_tokens":30000}), ]); text(r.map(x=>x.output).join("\n\n--- XLSX SKILL CONT. ---\n\n"));Output
Script completed Wall time 0.1 seconds Output: 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", })]}) ``` ### Footnotes ```javascript const doc = new Document({ footnotes: { 1: { chi… 10,276 more characters of output in the raw trajectory.
9Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await Promise.all([ tools.exec_command({"cmd":"wc -l /root/.agents/skills/docx/SKILL.md /root/.agents/skills/xlsx/SKILL.md && sed -n '521,1040p' /root/.agents/skills/docx/SKILL.md","yield_time_ms":10000,"max_output_tokens":30000}), tools.exec_command({"cmd":"sed -n '621,1040p' /root/.agents/skills/xlsx/SKILL.md","yield_time_ms":10000,"max_output_tokens":30000}), ]); text(r.map(x=>x.output).join("\n\n--- XLSX SKILL FINAL ---\n\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 ```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:rS
… 1,459 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":"pwd && rg --files -g '!output/**' /workspace | sed -n '1,240p'","yield_time_ms":10000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: /workspace /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 contains four spreadsheets, one Word schedule, and one PDF policy. I’ll extract each source in its native for…
The packet contains four spreadsheets, one Word schedule, and one PDF policy. I’ll extract each source in its native form and use the policy as the controlling reference for any potential substitution.
12Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"sed -n '1,360p' /root/.agents/skills/pdf/SKILL.md","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.
13Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await Promise.all([ tools.exec_command({"cmd":"python3 -c \"from openpyxl import load_workbook; from pathlib import Path\nfor p in sorted(Path('/workspace/data').glob('*.xlsx')):\n print('\\\\n###',p.name)\n wb=load_workbook(p,data_only=False,read_only=True)\n print('SHEETS:',wb.sheetnames)\n for ws in wb.worksheets:\n print('\\\\n--',ws.title, 'rows',ws.max_row,'cols',ws.max_column)\n for row in ws.iter_rows(values_only=True): print(' | '.join('' if v is None else str(v) for v in row))\n\"","yield_time_ms":10000,"max_output_tokens":60000}),… 440 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.9 seconds Output: ### approved_material_source_list.xlsx SHEETS: ['Source List', 'README'] -- Source List rows 13 cols 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 Alloys Co | Mill | AMS-QQ-A-250, AMS 5659 | China | Non-qual
… 30,435 more characters of output in the raw trajectory.
14Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await Promise.all([ tools.exec_command({"cmd":"python3 -c \"from docx import Document\np='/workspace/data/program_priority_build_schedule.docx'\nd=Document(p)\nfor i,para in enumerate(d.paragraphs):\n t=para.text.strip()\n if t: print(f'P{i+1}: {t}')\nfor ti,t in enumerate(d.tables,1):\n print(f'\\\\nTABLE {ti} rows={len(t.rows)} cols={len(t.columns)}')\n for row in t.rows: print(' | '.join(c.text.replace('\\\\n',' / ') for c in row.cells))\n\"","yield_time_ms":10000,"max_output_tokens":30000}), tools.exec_command({"cmd":"unzip -p /work… 278 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.3 seconds Output: P1: Program Priority & Build Schedule P2: 2026 Q3 Door/Hinge Mechanism Build Wave — Production Control Release PC-2026-0618 P3: Issued by: Production Control & Program Management Office (PMO). Distribution: Sourcing, Materials Planning, Quality, MRB. Status as of 2026-06-19. P4: 1. Purpose P5: 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. P6: 2. Program Priority Ranking and Build Commitments P7: Note: build start is the firs
… 3,201 more characters of output in the raw trajectory.
15I’ve extracted the governing rules and schedule. The key distinction is clear: several physically ample lots and low-pri…
I’ve extracted the governing rules and schedule. The key distinction is clear: several physically ample lots and low-price quotes are unusable because of non-qualifying melt origin, C-of-C-only paperwork, an open quality hold, incomplete traceability, or a conditional/not-approved source. I’ll keep those visible as rejected alternatives rather than treating them as coverage.
16Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await Promise.all([ tools.exec_command({"cmd":"find /workspace/output -maxdepth 2 -type f -printf '%p\\n' 2>/dev/null || true && node -e \"try{console.log(require.resolve('docx'))}catch(e){console.error('DOCX_NOT_FOUND');process.exitCode=1}\" && npm root -g","yield_time_ms":10000,"max_output_tokens":30000}), tools.exec_command({"cmd":"find / -path '*scripts/recalc.py' -o -path '*scripts/office/validate.py' 2>/dev/null | sed -n '1,100p'","yield_time_ms":10000,"max_output_tokens":30000}), tools.exec_command({"cmd":"python3 -c \"import openp… 224 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.7 seconds Output: DOCX_NOT_FOUND --- NEXT CHECK --- /root/.agents/skills/docx/scripts/office/validate.py /root/.agents/skills/xlsx/scripts/office/validate.py /root/.agents/skills/xlsx/scripts/recalc.py /harbor/skills/docx/scripts/office/validate.py /harbor/skills/xlsx/scripts/office/validate.py /harbor/skills/xlsx/scripts/recalc.py --- NEXT CHECK --- openpyxl 3.1.5 python-docx 1.2.0
17The packet-period allocation closes all 26 forecast lines mathematically with 5,857.25 lb of eligible inventory and 3,10…
The packet-period allocation closes all 26 forecast lines mathematically with 5,857.25 lb of eligible inventory and 3,102.75 lb of selected quote coverage. But this is not an executable “all clear”: the selected quote terms have expired by the current review date, several early need-by dates have passed, and one Sable steel-plate path is only two calendar days ahead of need-by on the published schedule. I’ll make that distinction explicit in both deliverables.
18Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await Promise.all([ tools.exec_command({"cmd":"npm install -g docx","yield_time_ms":30000,"max_output_tokens":30000}), tools.exec_command({"cmd":"command -v libreoffice || command -v soffice || true; node --version; npm --version","yield_time_ms":10000,"max_output_tokens":30000}), ]); text(r.map(x=>x.output).join("\n\n--- ENVIRONMENT ---\n\n"));Output
Script completed Wall time 1.8 seconds Output: added 22 packages in 2s 1 package is looking for funding run `npm fund` for details --- ENVIRONMENT --- /usr/bin/libreoffice v22.23.2 10.9.8
19Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"npm root -g && node -e \"console.log(require.resolve('/usr/local/lib/node_modules/docx'))\"","yield_time_ms":10000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 0.2 seconds Output: /root/.nvm/versions/node/v22.23.2/lib/node_modules node:internal/modules/cjs/loader:1433 throw err; ^ Error: Cannot find module '/usr/local/lib/node_modules/docx' Require stack: - /workspace/[eval] at Function._resolveFilename (node:internal/modules/cjs/loader:1430:15) at Function.resolve (node:internal/modules/helpers:157:19) at [eval]:1:21 at runScriptInThisContext (node:internal/vm:209:10) at node:internal/process/execution:446:12 at [eval]-wrapper:6:24 at runScriptInContext (node:internal/process/execution:444:60) at evalFunction (node:internal/process/execution:279:30) at evalTypeScript (node:internal/process/execution:291:3) at node:internal/main/eval_string:74:3 { code: 'MODULE_NOT_FOUND', requireStack: [ '/workspace/[eval]' ] } Node.js v22.23.220exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Add File: /workspace/build_material_workbook.py\n+from pathlib import Path\n+from datetime import date, datetime\n+from collections import defaultdict\n+from copy import copy\n+\n+from openpyxl import Workbook, load_workbook\n+from openpyxl.styles import Font, PatternFill, Border, Side, Alignment\n+from openpyxl.formatting.rule import FormulaRule\n+from openpyxl.utils import get_column_letter\n+from openpyxl.comments import Comment\n+\n+\n+ROOT = Path('/workspace')\n+DATA = ROOT / 'data'\n+OUT = ROOT / 'output'\n+OUT.mkdir(exist_o
Arguments
const patch = "*** Begin Patch\n*** Add File: /workspace/build_material_workbook.py\n+from pathlib import Path\n+from datetime import date, datetime\n+from collections import defaultdict\n+from copy import copy\n+\n+from openpyxl import Workbook, load_workbook\n+from openpyxl.styles import Font, PatternFill, Border, Side, Alignment\n+from openpyxl.formatting.rule import FormulaRule\n+from openpyxl.utils import get_column_letter\n+from openpyxl.comments import Comment\n+\n+\n+ROOT = Path('/workspace')\n+DATA = ROOT / 'data'\n+OUT = ROOT / 'output'\n+OUT.mkdir(exist_o… 58,873 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}21Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python3 -m py_compile /workspace/build_material_workbook.py && python3 /workspace/build_material_workbook.py","yield_time_ms":30000,"max_output_tokens":50000}); text(r.output);Output
Script completed Wall time 1.7 seconds Output: /workspace/output/material_sourcing_analysis_workbook.xlsx candidate inventory assessments: 54 candidate quote assessments: 67
22Shell1
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","yield_time_ms":30000,"max_output_tokens":50000}); text(r.output);Output
Script completed Wall time 3.3 seconds Output: status: success total_errors: 0 error_summary: {} total_formulas: 56323Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"python3 -c \"from openpyxl import load_workbook\np='/workspace/output/material_sourcing_analysis_workbook.xlsx'\nwb=load_workbook(p,data_only=True)\nfor wsname,cells in {'Executive Summary':['B7','B8','B9','B10','B11','B12','B13'], 'Purchase Plan':['G5','H5','J5','M5','G16','H16','J16','M16'], 'Requirement Coverage':['M5','N5','O5','P5','Q5','R5','M30','N30','O30','P30']}.items():\n ws=wb[wsname]; print(wsname)\n for cell in cells: print(cell,repr(ws[cell].value))\nprint('sheets',wb.sheetnames)\n\"","yield_time_ms":10000,"m… 46 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.6 seconds Output: Executive Summary B7 8960 B8 5857.25 B9 3102.75 B10 26 B11 3621.5 B12 32288.42 B13 0 Purchase Plan G5 593.4 H5 593.4 J5 5577.96 M5 'EXPIRED' G16 160 H16 250 J16 1337.5 M16 'EXPIRED' Requirement Coverage M5 516.6 N5 325.4 O5 842 P5 0 Q5 'COVERED—INVENTORY + SELECTED QUOTE' R5 'NEED-BY PASSED—PMO ESCALATION' M30 147 N30 0 O30 147 P30 0 sheets ['Executive Summary', 'Requirement Coverage', 'Allocation Plan', 'Purchase Plan', 'Inventory Usability', 'Quote Feasibility', 'Alternatives & Esc.', 'Methodology', 'Source Demand', 'Source Inventory', 'Source Sources', 'Source Quotes', 'Source Programs']
24Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"node -e \"console.log(require.resolve('/root/.nvm/versions/node/v22.23.2/lib/node_modules/docx'))\"","yield_time_ms":10000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: /root/.nvm/versions/node/v22.23.2/lib/node_modules/docx/dist/index.umd.cjs
25exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Add File: /workspace/build_material_memo.js\n+const fs = require('fs');\n+const {\n+ Document, Packer, Paragraph, TextRun, Table, TableRow, TableCell,\n+ WidthType, AlignmentType, BorderStyle, ShadingType, Header, Footer,\n+ PageNumber, HeadingLevel, LevelFormat, VerticalAlign, PageBreak,\n+} = require('/root/.nvm/versions/node/v22.23.2/lib/node_modules/docx');\n+\n+const out = '/workspace/output/material_sourcing_recommendation_memo.docx';\n+const navy = '1F4E78';\n+const blue = '2F75B5';\n+const lightBlue = 'D9EAF7';\n+const gree
Arguments
const patch = "*** Begin Patch\n*** Add File: /workspace/build_material_memo.js\n+const fs = require('fs');\n+const {\n+ Document, Packer, Paragraph, TextRun, Table, TableRow, TableCell,\n+ WidthType, AlignmentType, BorderStyle, ShadingType, Header, Footer,\n+ PageNumber, HeadingLevel, LevelFormat, VerticalAlign, PageBreak,\n+} = require('/root/.nvm/versions/node/v22.23.2/lib/node_modules/docx');\n+\n+const out = '/workspace/output/material_sourcing_recommendation_memo.docx';\n+const navy = '1F4E78';\n+const blue = '2F75B5';\n+const lightBlue = 'D9EAF7';\n+const gree… 17,491 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}26Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"node /workspace/build_material_memo.js && ls -lh /workspace/output/material_sourcing_recommendation_memo.docx && python /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx","yield_time_ms":30000,"max_output_tokens":50000}); text(r.output);Output
Script completed Wall time 1.4 seconds Output: -rw-r--r-- 1 root root 18K Aug 20 17:29 /workspace/output/material_sourcing_recommendation_memo.docx Paragraphs: 0 → 220 (+220) All validations PASSED!
27Both deliverables are now built. I’m doing a final rendering and calculation check so the memo’s tables remain readable…
Both deliverables are now built. I’m doing a final rendering and calculation check so the memo’s tables remain readable and the workbook has no formula errors before handoff.
28Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"render_dir=$(mktemp -d) && libreoffice --headless --convert-to pdf --outdir \"$render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx >/tmp/memo_convert.log 2>&1 && pdfinfo \"$render_dir/material_sourcing_recommendation_memo.pdf\" | rg 'Pages|Page size' && pdftotext -layout \"$render_dir/material_sourcing_recommendation_memo.pdf\" - | sed -n '1,260p' && printf '%s' \"$render_dir\"","yield_time_ms":30000,"max_output_tokens":50000}); text(r.output);Output
Script completed Wall time 1.0 seconds Output: Pages: 5 Page size: 612 x 792 pts (letter) AEROSTRUCTURE MECHANISMS DIVISION | MATERIAL SOURCING REVIEW MATERIAL SOURCING RECOMMENDATION 2026 Q3 Door and Hinge Mechanism Build Wave To From Review date Decision basis Sourcing, Production, Material Sourcing 20 August 2026 Controlled packet: program release 19 Jun; Quality, MRB, PMO Review inventory 20 Jun; AMSL effective 1 Jun; quotes received 12–19 Jun. Recommendation Reserve only the compliant inventory allocations and use the twelve selected quotations only as packet-period sourcing candidates. The plan mathematically covers all 26 forecast requirements wit… 11,717 more characters of output in the raw trajectory.
29exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n- makeTable(['Quote', 'Planned use', 'Coverage lb', 'Target PO lb', '$ / lb', 'Modeled spend', 'Current term'], quoteRows.map(row => row.map((value, index) => ({ text: value, fill: index === 6 ? red : undefined }))), [1150, 2890, 850, 850, 650, 1050, 2640], { banded: true, size: 14 }),\n+ makeTable(['Quote', 'Planned use', 'Coverage lb', 'Target PO lb', '$ / lb', 'Modeled spend', 'Current term'], quoteRows.map(row => row.map((value, index) => ({ text: value, fill: index === 6 ? red
Arguments
const patch = "*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n- makeTable(['Quote', 'Planned use', 'Coverage lb', 'Target PO lb', '$ / lb', 'Modeled spend', 'Current term'], quoteRows.map(row => row.map((value, index) => ({ text: value, fill: index === 6 ? red : undefined }))), [1150, 2890, 850, 850, 650, 1050, 2640], { banded: true, size: 14 }),\n+ makeTable(['Quote', 'Planned use', 'Coverage lb', 'Target PO lb', '$ / lb', 'Modeled spend', 'Current term'], quoteRows.map(row => row.map((value, index) => ({ text: value, fill: index === 6 ? red… 207 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}30Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"node /workspace/build_material_memo.js && python /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx && render_dir=$(mktemp -d) && libreoffice --headless --convert-to pdf --outdir \"$render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx >/tmp/memo_convert2.log 2>&1 && pdftotext -layout \"$render_dir/material_sourcing_recommendation_memo.pdf\" - | sed -n '90,175p'","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 2.1 seconds Output: Paragraphs: 0 → 220 (+220) All validations PASSED! Internal decision support | Page 2 AEROSTRUCTURE MECHANISMS DIVISION | MATERIAL SOURCING REVIEW Selected quote plan Selection is compliance-first. The target quantity equals the coverage needed from each selected quote, increased only to the stated MOQ where necessary; it remains subject to written revalidation because the packet does not state that partial quantities are currently orderable. Covera Target Modeled Quote Planned use $ / lb Current term ge lb PO lb spend QTE-A3F91C 7075-T7351 plate: Raven + Sable 593.… 4,198 more characters of output in the raw trajectory.
31Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"preview_dir=$(mktemp -d) && libreoffice --headless --convert-to pdf --outdir \"$preview_dir\" /workspace/output/material_sourcing_recommendation_memo.docx >/tmp/memo_preview.log 2>&1 && pdftoppm -f 3 -l 3 -png -r 140 \"$preview_dir/material_sourcing_recommendation_memo.pdf\" \"$preview_dir/page\" >/tmp/memo_preview_ppm.log 2>&1 && find \"$preview_dir\" -maxdepth 1 -type f -name 'page*.png' -printf '%p\\n'","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 1.2 seconds Output: /tmp/tmp.TVxD16keU4/page-3.png
32exec1
Tool execution only — no assistant text
execconst r = await tools.view_image({"path":"/tmp/tmp.TVxD16keU4/page-3.png","detail":"high"}); image(r.image_url, r.detail);
Arguments
const r = await tools.view_image({"path":"/tmp/tmp.TVxD16keU4/page-3.png","detail":"high"}); image(r.image_url, r.detail);Output
Script completed Wall time 0.0 seconds Output:
… 329,484 more characters of output in the raw trajectory.
33exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n- makeTable(['Quote', 'Planned use', 'Coverage lb', 'Target PO lb', '$ / lb', 'Modeled spend', 'Current term'], quoteRows.map(row => row.map((value, index) => ({ text: value, fill: index === 6 ? red : undefined }))), [1150, 2690, 850, 850, 900, 1050, 2590], { banded: true, size: 14 }),\n+ makeTable(['Quote', 'Planned use', 'Cov. lb', 'Target PO lb', '$ / lb', 'Modeled spend', 'Current term'], quoteRows.map(row => row.map((value, index) => ({ text: value, fill: index === 6 ? red : un
Arguments
const patch = "*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n- makeTable(['Quote', 'Planned use', 'Coverage lb', 'Target PO lb', '$ / lb', 'Modeled spend', 'Current term'], quoteRows.map(row => row.map((value, index) => ({ text: value, fill: index === 6 ? red : undefined }))), [1150, 2690, 850, 850, 900, 1050, 2590], { banded: true, size: 14 }),\n+ makeTable(['Quote', 'Planned use', 'Cov. lb', 'Target PO lb', '$ / lb', 'Modeled spend', 'Current term'], quoteRows.map(row => row.map((value, index) => ({ text: value, fill: index === 6 ? red : un… 203 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}34Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await Promise.all([ tools.exec_command({"cmd":"node /workspace/build_material_memo.js && python /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx && ls -lh /workspace/output/material_sourcing_recommendation_memo.docx","yield_time_ms":30000,"max_output_tokens":30000}), tools.exec_command({"cmd":"python /root/.agents/skills/xlsx/scripts/recalc.py /workspace/output/material_sourcing_analysis_workbook.xlsx 60 && ls -lh /workspace/output/material_sourcing_analysis_workbook.xlsx","yield_time_ms":3… 119 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 2.1 seconds Output: Paragraphs: 0 → 220 (+220) All validations PASSED! -rw-r--r-- 1 root root 18K Aug 20 17:30 /workspace/output/material_sourcing_recommendation_memo.docx --- WORKBOOK VALIDATION --- { "status": "success", "total_errors": 0, "error_summary": {}, "total_formulas": 563 } -rw-r--r-- 1 root root 77K Aug 20 17:30 /workspace/output/material_sourcing_analysis_workbook.xlsx35Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({"cmd":"find /workspace/output -maxdepth 1 -type f -printf '%f %s bytes\\n' | sort && python3 -c \"from openpyxl import load_workbook\np='/workspace/output/material_sourcing_analysis_workbook.xlsx'\nwb=load_workbook(p,data_only=True)\nws=wb['Requirement Coverage']\nprint('Coverage balance nonzero:', [(ws.cell(r,1).value,ws.cell(r,16).value) for r in range(5,31) if abs((ws.cell(r,16).value or 0))>1e-9])\nprint('Selected quote terms:', [wb['Purchase Plan'].cell(r,13).value for r in range(5,17)])\n\"","yield_time_ms":10000,"max_outpu… 38 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.6 seconds Output: material_sourcing_analysis_workbook.xlsx 78228 bytes material_sourcing_recommendation_memo.docx 17782 bytes Coverage balance nonzero: [] Selected quote terms: ['EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED', 'EXPIRED']
36Completed and validated both deliverables: - [Recommendation memo](/workspace/output/material_sourcing_recommendation_me…
Completed and validated both deliverables:
- Recommendation memo
- Supporting analysis workbook
Key outcome: the packet-period plan covers all 26 requirements with 5,857.25 lb of compliant inventory and 3,102.75 lb of selected quote coverage. However, all 12 selected quote terms are expired as of 2026-08-20, so they require revalidation/requote before any PO; Raven’s passed need-bys and Sable’s marginal 4340 plate path are escalated. The workbook is formula-checked with zero errors.
2 failure modes across 2 verifier failures
1Decision 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.
2Escalation 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.