task_111Manufacturing
All trialsGPT-5.6 SolcodexTrial 04
Trial reward
GPT-5.6 SolFail
Trial 04 — 2nd of 4 by reward score. This model averages 74.5% across 4 trials on this task.
- 11/15Core verifiers passed
- 12/16All verifiers passed
- 4Core failed
- 47Turns
- 34Tool calls
- $4.38Cost
- 38.2mTime
- 74kOutput tokens
Missed 4 of 15 core — allocation_priority, traceability and cost_reconciliation and 1 more.
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_priorityLLMFail
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
Failure mode Allocation or Selection Plan Incorrect
Why it failedA contested inventory lot usable by two requirements is given to the lower-priority program while the higher-priority one is pushed to a new purchase.
Justification
Not all contested eligible lots are allocated highest-priority-first. In Inventory Usability, LOT-3A7C82 (6061 plate, 765.6 usable) is eligible for Meridian/ Halcyon/ Calder but allocates 726 to lower-priority Halcyon while higher-priority Meridian gets 0 from that lot; LOT-A1E9F4 likewise allocates 333 to lower-priority Calder while eligible higher-priority Meridian/Halcyon get 0. Although the 15-5PH 5862 and 4340 bar examples follow priority, these contested lot allocations violate the rubric.
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 audit pieces, but not the required single requirement-level view for at-risk lines. Requirement Plan/Allocation Detail show selected lots, applied PO and cost; Inventory Usability shows rejected lots with reasons; Quote Feasibility shows rejected/alternative quotes with reasons; PO Plan shows final order quantities/MOQ. For lines like REQ-H4A2, REQ-L8Q4, and REQ-E9C1, you must cross sheets to see rejected lots/quotes and the final PO quantity, so the required one-view per-requirement audit trail is not present.
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_reconciliationLLMFail
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
Failure mode Decision Reconciliation or Conclusion Wrong
Why it failedThe workbook states two or more conflicting headline committed-buy totals even though each one's own detail rows reconcile internally.
Justification
The workbook shows two different headline PO-spend totals rather than one authoritative committed-buy total: Protect-all PO spend = $32,288.42 and Firm-baseline PO spend = $25,229.41 (also repeated in PO Plan). Program/requirement assigned PO costs roll to $32,288.42, not the firm-baseline total, so the committed-cost chain is not single and consistent across the workbook. The PO Plan line math itself reconciles and shared quotes are combined once (e.g., QTE-A3F91C 593.4 lb and QTE-3A9F18 680.8 lb), but the single-total criterion fails.
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 is compliance-led (e.g., "Compliance first" and "Commercial choice last") and it does reject lower-cost noncompliant options such as QTE-7D2B40 (China-origin 7075-T7351, unusable for Raven/Sable DFARS demand) and the $4.95/lb Tri-State 4340 bar quote (rejected because it offers only C of C). However, it does not explicitly document the required lowest-price Russia-melt 15-5PH quote (~$8.10/lb) with its material/price and unusability reason; references to Volga/Russia are not enough to satisfy that specific quote requirement.
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 Review — Decision Dashboard | |||||||
|---|---|---|---|---|---|---|---|
| Packet basis: program status 2026-06-19 and inventory snapshot 2026-06-20. No post-packet change is assumed. | |||||||
| Decision snapshot | |||||||
| Requirements | 26 | Net demand (usable lb) | 8960 | Requirements with shortfall | 0 | ||
| Inventory allocation (usable lb) | 5857.25 | Purchase applied (lb) | 3102.75 | Inventory-only requirements | 11 | ||
| Protect-all PO quantity (lb) | 3621.5 | MOQ / excess quantity (lb) | 518.75 | Selected quote lines | 12 | ||
| Protect-all PO spend | 32288.42 | Firm-baseline PO spend | 25229.41 | Tentative increment spend | 7059.01 | ||
| Program allocation and cost ownership | |||||||
| Program | Rank | Net Demand | Inventory | Purchase Applied | Shortfall | Assigned PO Spend | Decision Status |
| PRG-RAVEN | 1 | 2027 | 1525.6 | 501.4 | 0 | 5557.96 | COVERED |
| PRG-SABLE | 2 | 1218 | 339.2 | 878.8 | 0 | 8304.15 | COVERED — AT RISK |
| PRG-MERIDIAN | 3 | 1628 | 1252.7 | 375.3 | 0 | 3012.51 | COVERED — PMO GATE |
| PRG-TUNDRA | 4 | 1309 | 739 | 570 | 0 | 5813.55 | COVERED — PMO GATE |
| PRG-HALCYON | 5 | 1660 | 1201.5 | 458.5 | 0 | 4295.05 | COVERED — PMO GATE |
| PRG-CALDER | 6 | 1118 | 799.25 | 318.75 | 0 | 5305.2 | COVERED — PMO GATE |
| Leadership decisions and non-negotiable controls | |||||||
| 1 | Reserve inventory now | Lock the 5,857.25 usable-lb lot allocation in Allocation Detail. Existing allocations remain untouched; yield is not relaxed. | |||||
| 2 | Release firm baseline | Authorize $25,229.41 of firm-demand PO coverage before the listed quote expiries. | |||||
| 3 | Decide tentative coverage | Authorize or decline the $7,059.01 tentative increment; Sable REQ-L8Q4 requires immediate PMO/Quality escalation because the only compliant quote is two days early. | |||||
| 4 | Protect compliance barriers | Do not use C of C, partial-trace, held, Conditional/Suspended/Not Approved, or origin-restricted candidates even when cheaper or physically present. | |||||
| 5 | Accept or challenge MOQ economics | Protect-all orders create 518.75 lb of excess, driven by Calder and Halcyon residuals. No undocumented yield or allocation change is used to erase it. | |||||
| Workbook navigation | |||||||
| Requirement Plan | One row per MRP requirement; coverage, shortfall, assigned cost, risk, and action. | ||||||
| PO Plan | Selected quote-line releases, MOQ effect, firm baseline, tentative increment, cost, and gates. | ||||||
| Allocation Detail | Lot/quote-to-requirement allocation with capacity, yield, compliance, timing, and cost checks. | ||||||
| Inventory Usability | Every exact-match lot/requirement pair and the reason it is eligible or excluded. | ||||||
| Quote Feasibility | Every exact-match quote/requirement pair and its source, origin, cert, expiry, quantity, and timing tests. | ||||||
| Risks & Escalations / Alternatives | Required decisions, blocked material, and the documented alternatives considered. |
Demand Source
| Demand Source | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Material Demand Forecast — MRP-2026-0619-R2; planner D. Achebe; review wave 2026-Q3. Blue font = source hardcode; black = source formula. | |||||||||||
| 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 | 46244 | Y | Hinge arm machined-stock plate |
| REQ-K9P1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 4340 | AMS 6415 | Annealed | Bar | 615 | lb | 46239 | Y | Pivot pin bar, HT in house |
| REQ-C9T1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 300M | AMS 6419 | Annealed | Bar | 176 | lb | 46237 | Y | High-strength actuation pin bar |
| REQ-X5M3 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 15-5PH | AMS 5862 | Cond A | Plate | 394 | lb | 46246 | Y | Actuation backing plate |
| REQ-T2C7 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 15-5PH | AMS 5862 | Cond A | Plate | 430 | lb | 46258 | Y | Egress latch plate |
| REQ-B6N3 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 268 | lb | 46256 | Y | Egress arm gusset |
| REQ-F6B8 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 6061 | AMS 4117 | T651 | Bar | 233 | lb | 46260 | Y | Egress mechanism spacer bar |
| REQ-L8Q4 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 4340 | AMS 6359 | Norm | Plate | 287 | lb | 46262 | Tentative | Egress strike plate |
| REQ-M1X8 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 512 | lb | 46286 | Y | Latch housing plate |
| REQ-D7R4 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 347 | lb | 46283 | Y | Cabin door seal retainer extrusion |
| REQ-W3F9 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 15-5PH | AMS 5659 | H1025 | Bar | 198 | lb | 46279 | Y | Latch pawl bar |
| REQ-R7W2 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 412 | lb | 46277 | Y | Latch backing plate |
| REQ-G2J9 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 6061 | AMS 4117 | T651 | Bar | 159 | lb | 46281 | Tentative | Latch guide spacer bar |
| REQ-J5G7 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 455 | lb | 46307 | Y | Cargo door stop extrusion |
| REQ-P2H6 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 17-4PH | AMS 5604 | H1075 | Bar | 284 | lb | 46304 | Y | Stop fitting bar |
| REQ-V1D9 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 15-5PH | AMS 5862 | Cond A | Plate | 357 | lb | 46301 | Y | Stop fitting mounting plate |
| REQ-Y8K2 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 213 | lb | 46306 | Tentative | Stop seal retainer extrusion |
| REQ-Q8L5 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 726 | lb | 46328 | Y | Service door hinge bracket plate |
| REQ-Z4V2 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 4340 | AMS 6359 | Norm | Plate | 389 | lb | 46327 | Y | Bracket reinforcement plate |
| REQ-N3K4 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 301 | lb | 46331 | Y | Hinge shim plate stock |
| REQ-S6P3 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 244 | lb | 46330 | Tentative | Bracket cover plate |
| REQ-A2F7 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 333 | lb | 46342 | Y | Overwing hatch hinge plate |
| REQ-E9C1 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 271 | lb | 46340 | Y | Hatch hinge stop extrusion |
| REQ-U4B8 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 17-4PH | AMS 5604 | H1075 | Bar | 162 | lb | 46344 | Tentative | Hatch latch pin bar |
| REQ-H7D5 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 4340 | AMS 6415 | Annealed | Bar | 205 | lb | 46339 | Y | Hatch hinge pin bar |
| REQ-W9A3 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 15-5PH | AMS 5659 | H1025 | Bar | 147 | lb | 46343 | Tentative | Hatch pawl bar |
Inventory Source
| Inventory Source | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Inventory Lot & Certification Snapshot — WMS-EXP-20260620-0741 with QMS certification join. Blue font = source hardcode; black = source formula. | ||||||||||||||||
| 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 | 46108 | - | 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 | 46148 | - | 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 | 46127 | - | 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 | 46085 | - | 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 | 46130 | - | 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 | 46064 | - | 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 | 46057 | - | 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 | 46051 | - | 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 | 46099 | - | 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 | 46103 | - | 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 | 46142 | - | 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 | 46121 | - | 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 | 46114 | - | 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 | 46137 | - | 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 | 46079 | - | 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 | 46140 | - | 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 | 46165 | - | 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 | 46169 | - | 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 | 46090 | - | 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 | 46030 | - | 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 | 46153 | - | 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 | 46161 | - | 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 | 46144 | - | 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 | 46134 | - | 0.8 | Bar Cage B1 | Short bar lengths |
Quote Source
| Quote Source | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Supplier Quote & Lead-Time Matrix — RFQ responses received 2026-06-12 through 2026-06-19. Blue font = source hardcode; black = source formula. | ||||||||||||||||
| 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 | 46229 | 3.1 | USA | 150 | 46217 | Brunderman |
| QTE-7C3A95 | RFQ-4B9D52 | SRC-D14E8B | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 400 | 6.4 | 2560 | 18 | 46287 | 3.1 | USA | 200 | 46270 | Tri-State |
| QTE-3A9F18 | RFQ-2B7E55 | SRC-3B7C19 | 15-5PH | AMS 5862 | Cond A | Plate | 900 | 11.75 | 10575 | 33 | 46240 | 3.1 | France | 400 | 46223 | Ardenne; qualifying |
| QTE-F1C8A6 | RFQ-6C2A91 | SRC-7B2F60 | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 450 | 9.95 | 4477.5 | 34 | 46248 | 3.1 | USA | 250 | 46221 | Great Lakes; later dock |
| QTE-9C4E27 | RFQ-2B7E55 | SRC-2D8B96 | 15-5PH | AMS 5862 | Cond A | Plate | 1000 | 8.1 | 8100 | 24 | 46231 | 3.1 | Russia | 500 | 46221 | Volga; lowest price |
| QTE-2A7E61 | RFQ-4D8A12 | SRC-7B2F60 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 650 | 4.45 | 2892.5 | 28 | 46246 | 3.1 | USA | 300 | 46231 | Great Lakes |
| QTE-5F1B83 | RFQ-4D8A12 | SRC-9F2A41 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 800 | 4.3 | 3440 | 41 | 46259 | 3.1 | USA | 300 | 46235 | Cascade |
| QTE-1E8C57 | RFQ-9A4F22 | SRC-58E1B3 | 4340 | AMS 6415 | Annealed | Bar | 650 | 5.2 | 3380 | 22 | 46228 | 3.1 | USA | 300 | 46215 | Brunderman |
| QTE-8C3D49 | RFQ-4D8A12 | SRC-D14E8B | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 900 | 4.15 | 3735 | 16 | 46234 | 3.1 | USA | 300 | 46224 | Tri-State |
| QTE-7E2A85 | RFQ-3E8B27 | SRC-E5C913 | 17-4PH | AMS 5604 | H1075 | Bar | 250 | 11.1 | 2775 | 35 | 46249 | 3.1 | Slovenia | 150 | 46226 | Adriatic; later dock |
| QTE-9B4F27 | RFQ-7F1A38 | SRC-D14E8B | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 350 | 7.85 | 2747.5 | 18 | 46227 | 3.1 | USA | 200 | 46218 | Tri-State extrusion |
| QTE-7D2B40 | RFQ-6C2A91 | SRC-7A6D52 | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 800 | 6.85 | 5480 | 19 | 46225 | 3.1 | China | 400 | 46213 | Hangzhou; lowest price |
| QTE-3F7D92 | RFQ-2C7F49 | SRC-7B2F60 | 6061 | AMS 4117 | T651 | Bar | 250 | 5.9 | 1475 | 19 | 46242 | 3.1 | USA | 150 | 46227 | Great Lakes bar |
| QTE-A3F91C | RFQ-6C2A91 | SRC-9F2A41 | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 600 | 9.4 | 5640 | 26 | 46233 | 3.1 | USA | 250 | 46218 | Cascade direct |
| QTE-4C8F12 | RFQ-6F2C83 | SRC-7B2F60 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 400 | 8.95 | 3580 | 21 | 46235 | 3.1 | USA | 250 | 46221 | Great Lakes |
| QTE-6F1A93 | RFQ-2B7E55 | SRC-B9D472 | 15-5PH | AMS 5862 | Cond A | Plate | 600 | 10.2 | 6120 | 21 | 46229 | 3.1 | USA | 300 | 46222 | Lone Star; conditional source |
| QTE-1A6E38 | RFQ-2C7F49 | SRC-9F2A41 | 6061 | AMS 4117 | T651 | Bar | 300 | 5.75 | 1725 | 23 | 46246 | 3.1 | USA | 150 | 46228 | Cascade bar |
| QTE-8A1D63 | RFQ-8D3A19 | SRC-7A6D52 | 15-5PH | AMS 5659 | H1025 | Bar | 350 | 7.4 | 2590 | 22 | 46230 | 3.1 | China | 150 | 46220 | Hangzhou; cheaper |
| QTE-6D1B84 | RFQ-3C8F27 | SRC-58E1B3 | 4340 | AMS 6359 | Norm | Plate | 450 | 6.9 | 3105 | 30 | 46260 | 3.1 | USA | 250 | 46239 | Brunderman 4340 plate |
| QTE-6A2D58 | RFQ-3E8B27 | SRC-6E3F88 | 17-4PH | AMS 5604 | H1075 | Bar | 350 | 10.9 | 3815 | 31 | 46238 | 3.1 | South Korea | 200 | 46224 | Pohang |
| QTE-2F8C41 | RFQ-8D3A19 | SRC-3B7C19 | 15-5PH | AMS 5659 | H1025 | Bar | 300 | 9.85 | 2955 | 28 | 46243 | 3.1 | France | 150 | 46226 | Ardenne bar |
| QTE-5B9E41 | RFQ-4B9D52 | SRC-9F2A41 | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 350 | 6.65 | 2327.5 | 24 | 46293 | 3.1 | USA | 200 | 46273 | Cascade; later dock |
| QTE-4E9A72 | RFQ-1C9E44 | SRC-C2F9A7 | 300M | AMS 6419 | Annealed | Bar | 300 | 9.55 | 2865 | 20 | 46222 | 3.1 | China | 150 | 46212 | Yellow River; cheaper |
| QTE-C1E7B4 | RFQ-5A2F61 | SRC-9F2A41 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 500 | 8.9 | 4450 | 30 | 46237 | 3.1 | USA | 250 | 46225 | Cascade extrusion |
| QTE-2D7C64 | RFQ-7F1A38 | SRC-9F2A41 | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 400 | 7.6 | 3040 | 29 | 46236 | 3.1 | USA | 200 | 46222 | Cascade extrusion |
| QTE-1F7C93 | RFQ-3E8B27 | SRC-3B7C19 | 17-4PH | AMS 5604 | H1075 | Bar | 300 | 11.4 | 3420 | 26 | 46235 | 3.1 | France | 150 | 46223 | Ardenne |
| QTE-9A2E57 | RFQ-3C8F27 | SRC-C2F9A7 | 4340 | AMS 6359 | Norm | Plate | 500 | 5.45 | 2725 | 22 | 46252 | 3.1 | China | 250 | 46236 | Yellow River; cheaper |
| QTE-B6D2A9 | RFQ-9A4F22 | SRC-D14E8B | 4340 | AMS 6415 | Annealed | Bar | 700 | 4.95 | 3465 | 12 | 46218 | C of C | USA | 250 | 46211 | Tri-State; cofc only |
| QTE-5D8B72 | RFQ-2B7E55 | SRC-E5C913 | 15-5PH | AMS 5862 | Cond A | Plate | 700 | 12.4 | 8680 | 30 | 46237 | 3.1 | Slovenia | 300 | 46225 | Adriatic; qualifying |
| QTE-D9F3B1 | RFQ-9A4F22 | SRC-7B2F60 | 4340 | AMS 6415 | Annealed | Bar | 500 | 5.35 | 2675 | 20 | 46226 | 3.1 | USA | 250 | 46217 | Great Lakes bar |
| QTE-3D9B16 | RFQ-5A2F61 | SRC-7B2F60 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 400 | 9.15 | 3660 | 24 | 46232 | 3.1 | USA | 250 | 46223 | Great Lakes extrusion |
| QTE-9E4B27 | RFQ-6F2C83 | SRC-9F2A41 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 500 | 8.7 | 4350 | 25 | 46238 | 3.1 | USA | 250 | 46223 | Cascade |
AMSL Source
| AMSL Source | ||||||||
|---|---|---|---|---|---|---|---|---|
| Approved Material Source List — QE-AMSL Rev N, effective 2026-06-01. Blue font = source hardcode; black = source formula. | ||||||||
| 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 | 46477 | Aluminum plate/extrusion/bar |
| SRC-3B7C19 | Ardenne Steelworks SA | Mill | AMS 5862, AMS 5659, AMS 5604 | France | Qualifying (non-US) | Approved | 46387 | 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 | 46568 | Distributor; passes mill certs |
| SRC-7A6D52 | Hangzhou Precision Alloys Co | Mill | AMS-QQ-A-250, AMS 5659 | China | Non-qualifying | Approved | 46418 | Approved source; non-qualifying origin |
| SRC-C2F9A7 | Yellow River Specialty Steel | Mill | AMS 6359, AMS 6415, AMS 6419 | China | Non-qualifying | Approved | 46326 | Non-qualifying origin |
| SRC-58E1B3 | Brunderman Forge & Bar Inc | Mill | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | USA | Qualifying (USA) | Approved | 46660 | 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 | 46218 | Conditional pending requal audit |
| SRC-6E3F88 | Pohang Advanced Alloy | Mill | AMS 5604, AMS 5659 | South Korea | Qualifying (non-US) | Approved | 46446 | Qualifying country (KR) |
| SRC-A47C21 | Meridian Metal Service Center | Distributor | AMS-QQ-A-250, AMS-QQ-A-200 | USA | Qualifying (USA) | Suspended | 46173 | 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 | 46538 | 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 | 46630 | Aluminum + 4340 bar |
Program Source
| Program Source | |||||
|---|---|---|---|---|---|
| Program Priority & Build Schedule — PC-2026-0618, status 2026-06-19. Blue font = source hardcode; black = source formula. | |||||
| Program ID | Program / Assembly | Customer | Priority Rank | Build Start | Restriction |
| PRG-RAVEN | Raven Cargo Door Actuation Hinge | Lockmar Defense Systems | 1 | 46251 | DFARS |
| PRG-SABLE | Sable Emergency Egress Hinge Arm | Lockmar Defense Systems | 2 | 46265 | DFARS |
| PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Aerolux Commercial | 3 | 46293 | CUST-EU |
| PRG-TUNDRA | Tundra Cargo Door Stop Fitting | Northwind Regional | 4 | 46314 | CUST-EU |
| PRG-HALCYON | Halcyon Service Door Hinge Bracket | Aerolux Commercial | 5 | 46335 | None |
| PRG-CALDER | Calder Overwing Hatch Hinge Set | Northwind Regional | 6 | 46349 | None |
| Contractual restriction detail | |||||
| Code | Applies To | Restriction Detail | |||
| DFARS | PRG-RAVEN, PRG-SABLE (Lockmar Defense) | Specialty-metals clause DFARS 252.225-7008/7009 flows to these contracts. Steel and specialty alloys must be melted and manufactured in the United States or a qualifying country. Material of non-qualifying origin (including but not limited to People's Republic of China and Russian Federation melt) is not acceptable for these programs regardless of certificate quality. | |||
| CUST-EU | PRG-MERIDIAN, PRG-TUNDRA (Aerolux / Northwind) | Customer master agreement prohibits raw material melted in the People's Republic of China or the Russian Federation. Material melted in the United States or in European/allied qualifying countries (e.g., France, South Korea) is acceptable. This restriction is independent of, and stricter than, any commercial preference. | |||
| None | PRG-HALCYON, PRG-CALDER | No special country-of-origin restriction beyond standard approved-source requirements. Standard AMSL approval and certification rules still apply. |
Policy Rules
| Engineering and Sourcing Decision Rules | ||||
|---|---|---|---|---|
| Controlled basis: ENG-MSP Rev H, effective 2026-05-15; packet review basis 2026-06-20. | ||||
| Rule Area | Authoritative Requirement | Workbook Application | Source | Page / Section |
| Engineering match | Alloy, specification, temper/condition, and product form must match unless Section 4 expressly permits an allowance. | Exact four-field match; no substitutions invoked. | engineering_material_substitution_policy.pdf | p.1 §1, §4 |
| Certification | 3.1 mill test report (or 3.2) minimum; C of C is not acceptable. | C of C lots and quotes are excluded. | engineering_material_substitution_policy.pdf | p.1 §2 |
| Traceability | Heat/cast identity must be fully traceable end-to-end. | Any traceability status other than Full is excluded. | engineering_material_substitution_policy.pdf | p.1 §2 |
| Quality hold | Material under open quality hold or MRB is ineligible until cleared. | Open-hold lots receive zero planned allocation. | engineering_material_substitution_policy.pdf | p.1 §2 |
| Approved source | Source must be Approved for the applicable specification family; Conditional, Suspended, and Not Approved are ineligible for new commitments. | Status and spec-family checks join to QE-AMSL Rev N. | engineering_material_substitution_policy.pdf / approved_material_source_list.xlsx | p.1 §3 / README |
| Origin | DFARS programs require qualifying origin; CUST-EU bars China/Russia; unrestricted programs still require approved source. | Origin test varies by program restriction code. | program_priority_build_schedule.docx / engineering_material_substitution_policy.pdf | §3 / p.1 §3 |
| Yield | Usable on-hand = (on hand − allocated) × lot yield factor. | All inventory coverage uses the formula; allocated pounds are not changed. | engineering_material_substitution_policy.pdf | p.2 §5 |
| Quoted quantity | Quoted quantity is compared directly with net usable demand, subject to MOQ; no purchase yield assumption is authorized. | PO order = max(applied requirement quantity, MOQ), capped at quoted quantity. | engineering_material_substitution_policy.pdf | p.2 §5 |
| Lead time | Quoted dock must precede need-by; on/after need-by does not resolve schedule. No undocumented expedite. | Days early = need-by − quoted receipt; nonpositive is late. | engineering_material_substitution_policy.pdf | p.2 §6 |
| Priority | When compliant inventory is contested, lower rank number receives allocation first. | Raven → Sable → Meridian → Tundra → Halcyon → Calder. | program_priority_build_schedule.docx | §2, §4 |
Inventory Usability
| Inventory-Lot Usability by Requirement | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Only exact callout matches are listed. Usability still requires certification, traceability, hold, source/spec, and program-origin passes. | |||||||||||||||||||||||||||
| Lot ID | Requirement ID | Program ID | Priority | Restriction | Alloy | Material Spec | Condition | Form | Source ID | Source Status | Approved Families | Melt Country | Origin Pass | Cert Type | Cert Pass | Traceability | Trace Pass | Hold Status | Hold Pass | Gross Available (lb) | Yield Factor | Yield-Adjusted Qty (lb) | Source/Spec Pass | Lot Usability | Exclusion Reason | Planned Allocation (usable lb) | Lot Remaining (usable lb) |
| LOT-C7A340 | REQ-W3F9 | PRG-MERIDIAN | 3 | CUST-EU | 15-5PH | AMS 5659 | H1025 | Bar | SRC-7A6D52 | Approved | AMS-QQ-A-250, AMS 5659 | China | N | 3.1 | Y | Full | Y | None | Y | 300 | 0.84 | 252 | Y | Ineligible | Origin restriction; | 0 | 105 |
| LOT-C7A340 | REQ-W9A3 | PRG-CALDER | 6 | None | 15-5PH | AMS 5659 | H1025 | Bar | SRC-7A6D52 | Approved | AMS-QQ-A-250, AMS 5659 | China | Y | 3.1 | Y | Full | Y | None | Y | 300 | 0.84 | 252 | Y | Eligible | 147 | 105 | |
| LOT-3E8C71 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 4340 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | USA | Y | 3.1 | Y | Full | Y | None | Y | 520 | 0.8 | 416 | Y | Eligible | 416 | 0 | |
| LOT-3E8C71 | REQ-H7D5 | PRG-CALDER | 6 | None | 4340 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | USA | Y | 3.1 | Y | Full | Y | None | Y | 520 | 0.8 | 416 | Y | Eligible | 0 | 0 | |
| LOT-8D4B19 | REQ-J5G7 | PRG-TUNDRA | 4 | CUST-EU | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 505 | 0.77 | 388.85 | Y | Eligible | 388.85 | 0 | |
| LOT-8D4B19 | REQ-E9C1 | PRG-CALDER | 6 | None | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 505 | 0.77 | 388.85 | Y | Eligible | 0 | 0 | |
| LOT-2C9E14 | REQ-R7W2 | PRG-MERIDIAN | 3 | CUST-EU | 7075 | AMS-QQ-A-250/12 | T651 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 690 | 0.85 | 586.5 | Y | Eligible | 412 | 0 | |
| LOT-2C9E14 | REQ-S6P3 | PRG-HALCYON | 5 | None | 7075 | AMS-QQ-A-250/12 | T651 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 690 | 0.85 | 586.5 | Y | Eligible | 174.5 | 0 | |
| LOT-3A7C82 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | USA | Y | 3.1 | Y | Full | Y | None | Y | 880 | 0.87 | 765.6 | Y | Eligible | 0 | 39.6 | |
| LOT-3A7C82 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | USA | Y | 3.1 | Y | Full | Y | None | Y | 880 | 0.87 | 765.6 | Y | Eligible | 726 | 39.6 | |
| LOT-3A7C82 | REQ-A2F7 | PRG-CALDER | 6 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | USA | Y | 3.1 | Y | Full | Y | None | Y | 880 | 0.87 | 765.6 | Y | Eligible | 0 | 39.6 | |
| LOT-7F3A2B | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 630 | 0.82 | 516.6 | Y | Eligible | 516.6 | 0 | |
| LOT-7F3A2B | REQ-B6N3 | PRG-SABLE | 2 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 630 | 0.82 | 516.6 | Y | Eligible | 0 | 0 | |
| LOT-A1E9F4 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | USA | Y | 3.1 | Y | Full | Y | None | Y | 680 | 0.87 | 591.6 | Y | Eligible | 0 | 258.6 | |
| LOT-A1E9F4 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | USA | Y | 3.1 | Y | Full | Y | None | Y | 680 | 0.87 | 591.6 | Y | Eligible | 0 | 258.6 | |
| LOT-A1E9F4 | REQ-A2F7 | PRG-CALDER | 6 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | USA | Y | 3.1 | Y | Full | Y | None | Y | 680 | 0.87 | 591.6 | Y | Eligible | 333 | 258.6 | |
| LOT-D6B821 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 4340 | AMS 6415 | Annealed | Bar | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | USA | Y | C of C | N | Full | Y | None | Y | 760 | 0.78 | 592.8 | Y | Ineligible | Certification; | 0 | 592.8 |
| LOT-D6B821 | REQ-H7D5 | PRG-CALDER | 6 | None | 4340 | AMS 6415 | Annealed | Bar | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | USA | Y | C of C | N | Full | Y | None | Y | 760 | 0.78 | 592.8 | Y | Ineligible | Certification; | 0 | 592.8 |
| LOT-E8C520 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 1080 | 0.88 | 950.4 | Y | Eligible | 512 | 438.4 | |
| LOT-E8C520 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 1080 | 0.88 | 950.4 | Y | Eligible | 0 | 438.4 | |
| LOT-E8C520 | REQ-A2F7 | PRG-CALDER | 6 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 1080 | 0.88 | 950.4 | Y | Eligible | 0 | 438.4 | |
| LOT-9C5F28 | REQ-N3K4 | PRG-HALCYON | 5 | None | 2024 | AMS-QQ-A-250/4 | T351 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 465 | 0.83 | 385.95 | Y | Eligible | 301 | 84.95 | |
| LOT-5C9A16 | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-7A6D52 | Approved | AMS-QQ-A-250, AMS 5659 | China | N | 3.1 | Y | Full | Y | None | Y | 920 | 0.8 | 736 | Y | Ineligible | Origin restriction; | 0 | 736 |
| LOT-5C9A16 | REQ-B6N3 | PRG-SABLE | 2 | DFARS | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-7A6D52 | Approved | AMS-QQ-A-250, AMS 5659 | China | N | 3.1 | Y | Full | Y | None | Y | 920 | 0.8 | 736 | Y | Ineligible | Origin restriction; | 0 | 736 |
| LOT-7E1C95 | REQ-F6B8 | PRG-SABLE | 2 | DFARS | 6061 | AMS 4117 | T651 | Bar | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 290 | 0.82 | 237.8 | Y | Eligible | 233 | 0 | |
| LOT-7E1C95 | REQ-G2J9 | PRG-MERIDIAN | 3 | CUST-EU | 6061 | AMS 4117 | T651 | Bar | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 290 | 0.82 | 237.8 | Y | Eligible | 4.8 | 0 | |
| LOT-5B2E88 | REQ-D7R4 | PRG-MERIDIAN | 3 | CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 410 | 0.79 | 323.9 | Y | Eligible | 323.9 | 0 | |
| LOT-5B2E88 | REQ-Y8K2 | PRG-TUNDRA | 4 | CUST-EU | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | USA | Y | 3.1 | Y | Full | Y | None | Y | 410 | 0.79 | 323.9 | Y | Eligible | 0 | 0 | |
| LOT-2E6B95 | REQ-J5G7 | PRG-TUNDRA | 4 | CUST-EU | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | USA | Y | 3.1 | Y | Full | Y | None | Y | 430 | 0.78 | 335.4 | Y | Eligible | 66.15 | 0 | |
| LOT-2E6B95 | REQ-E9C1 | PRG-CALDER | 6 | None | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | USA | Y | 3.1 | Y | Full | Y | None | Y | 430 | 0.78 | 335.4 | Y | Eligible | 269.25 | 0 | |
| LOT-B3E7C0 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | France | Y | 3.1 | Y | Full | Y | Quality Hold - MRB | N | 1180 | 0.83 | 979.4 | Y | Ineligible | Open hold; | 0 | 979.4 |
| LOT-B3E7C0 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | France | Y | 3.1 | Y | Full | Y | Quality Hold - MRB | N | 1180 | 0.83 | 979.4 | Y | Ineligible | Open hold; | 0 | 979.4 |
| LOT-B3E7C0 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | France | Y | 3.1 | Y | Full | Y | Quality Hold - MRB | N | 1180 | 0.83 | 979.4 | Y | Ineligible | Open hold; | 0 | 979.4 |
| LOT-2B7E54 | REQ-C9T1 | PRG-RAVEN | 1 | DFARS | 300M | AMS 6419 | Annealed | Bar | SRC-C2F9A7 | Approved | AMS 6359, AMS 6415, AMS 6419 | China | N | 3.1 | Y | Full | Y | None | Y | 290 | 0.74 | 214.6 | Y | Ineligible | Origin restriction; | 0 | 214.6 |
| LOT-8F4D17 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | France | Y | 3.1 | Y | Full | Y | Quality Hold - Recv Insp | N | 250 | 0.85 | 212.5 | Y | Ineligible | Open hold; | 0 | 212.5 |
| LOT-8F4D17 | REQ-U4B8 | PRG-CALDER | 6 | None | 17-4PH | AMS 5604 | H1075 | Bar | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | France | Y | 3.1 | Y | Full | Y | Quality Hold - Recv Insp | N | 250 | 0.85 | 212.5 | Y | Ineligible | Open hold; | 0 | 212.5 |
| LOT-1D6B43 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | SRC-2D8B96 | Not Approved | AMS 5862, AMS 6359 | Russia | N | 3.1 | Y | Full | Y | None | Y | 800 | 0.83 | 664 | N | Ineligible | Origin restriction; Source status/spec family; | 0 | 664 |
| LOT-1D6B43 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | SRC-2D8B96 | Not Approved | AMS 5862, AMS 6359 | Russia | N | 3.1 | Y | Full | Y | None | Y | 800 | 0.83 | 664 | N | Ineligible | Origin restriction; Source status/spec family; | 0 | 664 |
| LOT-1D6B43 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | SRC-2D8B96 | Not Approved | AMS 5862, AMS 6359 | Russia | N | 3.1 | Y | Full | Y | None | Y | 800 | 0.83 | 664 | N | Ineligible | Origin restriction; Source status/spec family; | 0 | 664 |
| LOT-6F2A87 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | 17-4PH | AMS 5604 | H1075 | Bar | SRC-6E3F88 | Approved | AMS 5604, AMS 5659 | South Korea | Y | 3.1 | Y | Full | Y | None | Y | 340 | 0.85 | 289 | Y | Eligible | 284 | 0 | |
| LOT-6F2A87 | REQ-U4B8 | PRG-CALDER | 6 | None | 17-4PH | AMS 5604 | H1075 | Bar | SRC-6E3F88 | Approved | AMS 5604, AMS 5659 | South Korea | Y | 3.1 | Y | Full | Y | None | Y | 340 | 0.85 | 289 | Y | Eligible | 5 | 0 | |
| LOT-1F9D63 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-A47C21 | Suspended | AMS-QQ-A-250, AMS-QQ-A-200 | USA | Y | 3.1 | Y | Partial - heat not traceable | N | None | Y | 760 | 0.86 | 653.6 | N | Ineligible | Traceability; Source status/spec family; | 0 | 653.6 |
| LOT-1F9D63 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-A47C21 | Suspended | AMS-QQ-A-250, AMS-QQ-A-200 | USA | Y | 3.1 | Y | Partial - heat not traceable | N | None | Y | 760 | 0.86 | 653.6 | N | Ineligible | Traceability; Source status/spec family; | 0 | 653.6 |
| LOT-1F9D63 | REQ-A2F7 | PRG-CALDER | 6 | None | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-A47C21 | Suspended | AMS-QQ-A-250, AMS-QQ-A-200 | USA | Y | 3.1 | Y | Partial - heat not traceable | N | None | Y | 760 | 0.86 | 653.6 | N | Ineligible | Traceability; Source status/spec family; | 0 | 653.6 |
| LOT-4A8D62 | REQ-R7W2 | PRG-MERIDIAN | 3 | CUST-EU | 7075 | AMS-QQ-A-250/12 | T651 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | USA | Y | C of C | N | Full | Y | None | Y | 700 | 0.84 | 588 | Y | Ineligible | Certification; | 0 | 588 |
| LOT-4A8D62 | REQ-S6P3 | PRG-HALCYON | 5 | None | 7075 | AMS-QQ-A-250/12 | T651 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | USA | Y | C of C | N | Full | Y | None | Y | 700 | 0.84 | 588 | Y | Ineligible | Certification; | 0 | 588 |
| LOT-4D1A95 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | SRC-B9D472 | Conditional | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117, AMS 5862 | USA | Y | 3.1 | Y | Full | Y | None | Y | 540 | 0.81 | 437.4 | N | Ineligible | Source status/spec family; | 0 | 437.4 |
| LOT-4D1A95 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | SRC-B9D472 | Conditional | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117, AMS 5862 | USA | Y | 3.1 | Y | Full | Y | None | Y | 540 | 0.81 | 437.4 | N | Ineligible | Source status/spec family; | 0 | 437.4 |
| LOT-4D1A95 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | SRC-B9D472 | Conditional | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117, AMS 5862 | USA | Y | 3.1 | Y | Full | Y | None | Y | 540 | 0.81 | 437.4 | N | Ineligible | Source status/spec family; | 0 | 437.4 |
| LOT-6B2F39 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | SRC-E5C913 | Approved | AMS 5862, AMS 5659, AMS 5604 | Slovenia | Y | 3.1 | Y | Full | Y | None | Y | 610 | 0.82 | 500.2 | Y | Eligible | 394 | 0 | |
| LOT-6B2F39 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 15-5PH | AMS 5862 | Cond A | Plate | SRC-E5C913 | Approved | AMS 5862, AMS 5659, AMS 5604 | Slovenia | Y | 3.1 | Y | Full | Y | None | Y | 610 | 0.82 | 500.2 | Y | Eligible | 106.2 | 0 | |
| LOT-6B2F39 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 15-5PH | AMS 5862 | Cond A | Plate | SRC-E5C913 | Approved | AMS 5862, AMS 5659, AMS 5604 | Slovenia | Y | 3.1 | Y | Full | Y | None | Y | 610 | 0.82 | 500.2 | Y | Eligible | 0 | 0 | |
| LOT-9A4F37 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 4340 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | USA | Y | 3.1 | Y | Full | Y | None | Y | 305 | 0.8 | 244 | Y | Eligible | 199 | 0 | |
| LOT-9A4F37 | REQ-H7D5 | PRG-CALDER | 6 | None | 4340 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | USA | Y | 3.1 | Y | Full | Y | None | Y | 305 | 0.8 | 244 | Y | Eligible | 45 | 0 |
Quote Feasibility
| Supplier Quote Feasibility by Requirement | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Every exact-callout quote/requirement pairing is tested against source/spec approval, program origin, certification, packet-date validity, and need-by timing. | ||||||||||||||||||||||||||||||||
| Quote ID | Requirement ID | Program ID | Priority | Restriction | MRP | Alloy | Material Spec | Condition | Form | Source ID | Source Status | Approved Families | Source/Spec Pass | Melt Country | Origin Pass | Cert Offered | Cert Pass | Quoted Qty (lb) | MOQ (lb) | Unit Price ($/lb) | Receipt Date | Need-By Date | Days Early | Quote Expiry | Valid at Packet Date | Full Requirement Cover? | Compliance | Schedule | Overall Feasibility | Reason / Tradeoff | Planned Applied (lb) | Quote Remaining (lb) |
| QTE-8B3F19 | REQ-C9T1 | PRG-RAVEN | 1 | DFARS | Y | 300M | AMS 6419 | Annealed | Bar | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | Y | USA | Y | 3.1 | Y | 250 | 150 | 14.2 | 46229 | 46237 | 8 | 46217 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 176 | 74 |
| QTE-7C3A95 | REQ-N3K4 | PRG-HALCYON | 5 | None | Y | 2024 | AMS-QQ-A-250/4 | T351 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Y | USA | Y | 3.1 | Y | 400 | 200 | 6.4 | 46287 | 46331 | 44 | 46270 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 400 |
| QTE-3A9F18 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | France | Y | 3.1 | Y | 900 | 400 | 11.75 | 46240 | 46246 | 6 | 46223 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 219.2 |
| QTE-3A9F18 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | France | Y | 3.1 | Y | 900 | 400 | 11.75 | 46240 | 46258 | 18 | 46223 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 323.8 | 219.2 |
| QTE-3A9F18 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | France | Y | 3.1 | Y | 900 | 400 | 11.75 | 46240 | 46301 | 61 | 46223 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 357 | 219.2 |
| QTE-F1C8A6 | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Y | USA | Y | 3.1 | Y | 450 | 250 | 9.95 | 46248 | 46244 | -4 | 46221 | Y | N | Compliant | Late | Eligible but late | Receipt on/after need-by | 0 | 450 |
| QTE-F1C8A6 | REQ-B6N3 | PRG-SABLE | 2 | DFARS | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Y | USA | Y | 3.1 | Y | 450 | 250 | 9.95 | 46248 | 46256 | 8 | 46221 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 450 |
| QTE-9C4E27 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-2D8B96 | Not Approved | AMS 5862, AMS 6359 | N | Russia | N | 3.1 | Y | 1000 | 500 | 8.1 | 46231 | 46246 | 15 | 46221 | Y | Y | Ineligible | On-time | Ineligible | Source status/spec family; Origin restriction; | 0 | 1000 |
| QTE-9C4E27 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-2D8B96 | Not Approved | AMS 5862, AMS 6359 | N | Russia | N | 3.1 | Y | 1000 | 500 | 8.1 | 46231 | 46258 | 27 | 46221 | Y | Y | Ineligible | On-time | Ineligible | Source status/spec family; Origin restriction; | 0 | 1000 |
| QTE-9C4E27 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-2D8B96 | Not Approved | AMS 5862, AMS 6359 | N | Russia | N | 3.1 | Y | 1000 | 500 | 8.1 | 46231 | 46301 | 70 | 46221 | Y | Y | Ineligible | On-time | Ineligible | Source status/spec family; Origin restriction; | 0 | 1000 |
| QTE-2A7E61 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Y | USA | Y | 3.1 | Y | 650 | 300 | 4.45 | 46246 | 46286 | 40 | 46231 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 650 |
| QTE-2A7E61 | REQ-Q8L5 | PRG-HALCYON | 5 | None | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Y | USA | Y | 3.1 | Y | 650 | 300 | 4.45 | 46246 | 46328 | 82 | 46231 | Y | N | Compliant | On-time | Eligible & on-time | Partial coverage only | 0 | 650 |
| QTE-2A7E61 | REQ-A2F7 | PRG-CALDER | 6 | None | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Y | USA | Y | 3.1 | Y | 650 | 300 | 4.45 | 46246 | 46342 | 96 | 46231 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 650 |
| QTE-5F1B83 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 800 | 300 | 4.3 | 46259 | 46286 | 27 | 46235 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 800 |
| QTE-5F1B83 | REQ-Q8L5 | PRG-HALCYON | 5 | None | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 800 | 300 | 4.3 | 46259 | 46328 | 69 | 46235 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 800 |
| QTE-5F1B83 | REQ-A2F7 | PRG-CALDER | 6 | None | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 800 | 300 | 4.3 | 46259 | 46342 | 83 | 46235 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 800 |
| QTE-1E8C57 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | Y | 4340 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | Y | USA | Y | 3.1 | Y | 650 | 300 | 5.2 | 46228 | 46239 | 11 | 46215 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 650 |
| QTE-1E8C57 | REQ-H7D5 | PRG-CALDER | 6 | None | Y | 4340 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | Y | USA | Y | 3.1 | Y | 650 | 300 | 5.2 | 46228 | 46339 | 111 | 46215 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 650 |
| QTE-8C3D49 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Y | USA | Y | 3.1 | Y | 900 | 300 | 4.15 | 46234 | 46286 | 52 | 46224 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 900 |
| QTE-8C3D49 | REQ-Q8L5 | PRG-HALCYON | 5 | None | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Y | USA | Y | 3.1 | Y | 900 | 300 | 4.15 | 46234 | 46328 | 94 | 46224 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 900 |
| QTE-8C3D49 | REQ-A2F7 | PRG-CALDER | 6 | None | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Y | USA | Y | 3.1 | Y | 900 | 300 | 4.15 | 46234 | 46342 | 108 | 46224 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 900 |
| QTE-7E2A85 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | Y | 17-4PH | AMS 5604 | H1075 | Bar | SRC-E5C913 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | Slovenia | Y | 3.1 | Y | 250 | 150 | 11.1 | 46249 | 46304 | 55 | 46226 | Y | N | Compliant | On-time | Eligible & on-time | Partial coverage only | 0 | 93 |
| QTE-7E2A85 | REQ-U4B8 | PRG-CALDER | 6 | None | Tentative | 17-4PH | AMS 5604 | H1075 | Bar | SRC-E5C913 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | Slovenia | Y | 3.1 | Y | 250 | 150 | 11.1 | 46249 | 46344 | 95 | 46226 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 157 | 93 |
| QTE-9B4F27 | REQ-D7R4 | PRG-MERIDIAN | 3 | CUST-EU | Y | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Y | USA | Y | 3.1 | Y | 350 | 200 | 7.85 | 46227 | 46283 | 56 | 46218 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 350 |
| QTE-9B4F27 | REQ-Y8K2 | PRG-TUNDRA | 4 | CUST-EU | Tentative | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Y | USA | Y | 3.1 | Y | 350 | 200 | 7.85 | 46227 | 46306 | 79 | 46218 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 350 |
| QTE-7D2B40 | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-7A6D52 | Approved | AMS-QQ-A-250, AMS 5659 | Y | China | N | 3.1 | Y | 800 | 400 | 6.85 | 46225 | 46244 | 19 | 46213 | Y | N | Ineligible | On-time | Ineligible | Origin restriction; | 0 | 800 |
| QTE-7D2B40 | REQ-B6N3 | PRG-SABLE | 2 | DFARS | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-7A6D52 | Approved | AMS-QQ-A-250, AMS 5659 | Y | China | N | 3.1 | Y | 800 | 400 | 6.85 | 46225 | 46256 | 31 | 46213 | Y | Y | Ineligible | On-time | Ineligible | Origin restriction; | 0 | 800 |
| QTE-3F7D92 | REQ-F6B8 | PRG-SABLE | 2 | DFARS | Y | 6061 | AMS 4117 | T651 | Bar | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | N | USA | Y | 3.1 | Y | 250 | 150 | 5.9 | 46242 | 46260 | 18 | 46227 | Y | Y | Ineligible | On-time | Ineligible | Source status/spec family; | 0 | 250 |
| QTE-3F7D92 | REQ-G2J9 | PRG-MERIDIAN | 3 | CUST-EU | Tentative | 6061 | AMS 4117 | T651 | Bar | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | N | USA | Y | 3.1 | Y | 250 | 150 | 5.9 | 46242 | 46281 | 39 | 46227 | Y | Y | Ineligible | On-time | Ineligible | Source status/spec family; | 0 | 250 |
| QTE-A3F91C | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 600 | 250 | 9.4 | 46233 | 46244 | 11 | 46218 | Y | N | Compliant | On-time | Eligible & on-time | Partial coverage only | 325.4 | 6.60000000000002 |
| QTE-A3F91C | REQ-B6N3 | PRG-SABLE | 2 | DFARS | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 600 | 250 | 9.4 | 46233 | 46256 | 23 | 46218 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 268 | 6.60000000000002 |
| QTE-4C8F12 | REQ-R7W2 | PRG-MERIDIAN | 3 | CUST-EU | Y | 7075 | AMS-QQ-A-250/12 | T651 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Y | USA | Y | 3.1 | Y | 400 | 250 | 8.95 | 46235 | 46277 | 42 | 46221 | Y | N | Compliant | On-time | Eligible & on-time | Partial coverage only | 0 | 400 |
| QTE-4C8F12 | REQ-S6P3 | PRG-HALCYON | 5 | None | Tentative | 7075 | AMS-QQ-A-250/12 | T651 | Plate | SRC-7B2F60 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Y | USA | Y | 3.1 | Y | 400 | 250 | 8.95 | 46235 | 46330 | 95 | 46221 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 400 |
| QTE-6F1A93 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-B9D472 | Conditional | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117, AMS 5862 | N | USA | Y | 3.1 | Y | 600 | 300 | 10.2 | 46229 | 46246 | 17 | 46222 | Y | Y | Ineligible | On-time | Ineligible | Source status/spec family; | 0 | 600 |
| QTE-6F1A93 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-B9D472 | Conditional | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117, AMS 5862 | N | USA | Y | 3.1 | Y | 600 | 300 | 10.2 | 46229 | 46258 | 29 | 46222 | Y | Y | Ineligible | On-time | Ineligible | Source status/spec family; | 0 | 600 |
| QTE-6F1A93 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | Y | 15-5PH | AMS 5862 | Cond A | Plate | SRC-B9D472 | Conditional | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117, AMS 5862 | N | USA | Y | 3.1 | Y | 600 | 300 | 10.2 | 46229 | 46301 | 72 | 46222 | Y | Y | Ineligible | On-time | Ineligible | Source status/spec family; | 0 | 600 |
| QTE-1A6E38 | REQ-F6B8 | PRG-SABLE | 2 | DFARS | Y | 6061 | AMS 4117 | T651 | Bar | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 300 | 150 | 5.75 | 46246 | 46260 | 14 | 46228 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 145.8 |
| QTE-1A6E38 | REQ-G2J9 | PRG-MERIDIAN | 3 | CUST-EU | Tentative | 6061 | AMS 4117 | T651 | Bar | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 300 | 150 | 5.75 | 46246 | 46281 | 35 | 46228 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 154.2 | 145.8 |
| QTE-8A1D63 | REQ-W3F9 | PRG-MERIDIAN | 3 | CUST-EU | Y | 15-5PH | AMS 5659 | H1025 | Bar | SRC-7A6D52 | Approved | AMS-QQ-A-250, AMS 5659 | Y | China | N | 3.1 | Y | 350 | 150 | 7.4 | 46230 | 46279 | 49 | 46220 | Y | Y | Ineligible | On-time | Ineligible | Origin restriction; | 0 | 350 |
| QTE-8A1D63 | REQ-W9A3 | PRG-CALDER | 6 | None | Tentative | 15-5PH | AMS 5659 | H1025 | Bar | SRC-7A6D52 | Approved | AMS-QQ-A-250, AMS 5659 | Y | China | Y | 3.1 | Y | 350 | 150 | 7.4 | 46230 | 46343 | 113 | 46220 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 350 |
| QTE-6D1B84 | REQ-L8Q4 | PRG-SABLE | 2 | DFARS | Tentative | 4340 | AMS 6359 | Norm | Plate | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | Y | USA | Y | 3.1 | Y | 450 | 250 | 6.9 | 46260 | 46262 | 2 | 46239 | Y | Y | Compliant | On-time | Eligible – tight margin | Compliant but only 2 days early | 287 | 163 |
| QTE-6D1B84 | REQ-Z4V2 | PRG-HALCYON | 5 | None | Y | 4340 | AMS 6359 | Norm | Plate | SRC-58E1B3 | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | Y | USA | Y | 3.1 | Y | 450 | 250 | 6.9 | 46260 | 46327 | 67 | 46239 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 163 |
| QTE-6A2D58 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | Y | 17-4PH | AMS 5604 | H1075 | Bar | SRC-6E3F88 | Approved | AMS 5604, AMS 5659 | Y | South Korea | Y | 3.1 | Y | 350 | 200 | 10.9 | 46238 | 46304 | 66 | 46224 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 350 |
| QTE-6A2D58 | REQ-U4B8 | PRG-CALDER | 6 | None | Tentative | 17-4PH | AMS 5604 | H1075 | Bar | SRC-6E3F88 | Approved | AMS 5604, AMS 5659 | Y | South Korea | Y | 3.1 | Y | 350 | 200 | 10.9 | 46238 | 46344 | 106 | 46224 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 350 |
| QTE-2F8C41 | REQ-W3F9 | PRG-MERIDIAN | 3 | CUST-EU | Y | 15-5PH | AMS 5659 | H1025 | Bar | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | France | Y | 3.1 | Y | 300 | 150 | 9.85 | 46243 | 46279 | 36 | 46226 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 198 | 102 |
| QTE-2F8C41 | REQ-W9A3 | PRG-CALDER | 6 | None | Tentative | 15-5PH | AMS 5659 | H1025 | Bar | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | France | Y | 3.1 | Y | 300 | 150 | 9.85 | 46243 | 46343 | 100 | 46226 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 102 |
| QTE-5B9E41 | REQ-N3K4 | PRG-HALCYON | 5 | None | Y | 2024 | AMS-QQ-A-250/4 | T351 | Plate | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 350 | 200 | 6.65 | 46293 | 46331 | 38 | 46273 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 350 |
| QTE-4E9A72 | REQ-C9T1 | PRG-RAVEN | 1 | DFARS | Y | 300M | AMS 6419 | Annealed | Bar | SRC-C2F9A7 | Approved | AMS 6359, AMS 6415, AMS 6419 | Y | China | N | 3.1 | Y | 300 | 150 | 9.55 | 46222 | 46237 | 15 | 46212 | Y | Y | Ineligible | On-time | Ineligible | Origin restriction; | 0 | 300 |
| QTE-C1E7B4 | REQ-J5G7 | PRG-TUNDRA | 4 | CUST-EU | Y | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 500 | 250 | 8.9 | 46237 | 46307 | 70 | 46225 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 498.25 |
| QTE-C1E7B4 | REQ-E9C1 | PRG-CALDER | 6 | None | Y | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 500 | 250 | 8.9 | 46237 | 46340 | 103 | 46225 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 1.75 | 498.25 |
| QTE-2D7C64 | REQ-D7R4 | PRG-MERIDIAN | 3 | CUST-EU | Y | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 400 | 200 | 7.6 | 46236 | 46283 | 47 | 46222 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 23.1 | 163.9 |
| QTE-2D7C64 | REQ-Y8K2 | PRG-TUNDRA | 4 | CUST-EU | Tentative | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | SRC-9F2A41 | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Y | USA | Y | 3.1 | Y | 400 | 200 | 7.6 | 46236 | 46306 | 70 | 46222 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 213 | 163.9 |
| QTE-1F7C93 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | Y | 17-4PH | AMS 5604 | H1075 | Bar | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | France | Y | 3.1 | Y | 300 | 150 | 11.4 | 46235 | 46304 | 69 | 46223 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 300 |
| QTE-1F7C93 | REQ-U4B8 | PRG-CALDER | 6 | None | Tentative | 17-4PH | AMS 5604 | H1075 | Bar | SRC-3B7C19 | Approved | AMS 5862, AMS 5659, AMS 5604 | Y | France | Y | 3.1 | Y | 300 | 150 | 11.4 | 46235 | 46344 | 109 | 46223 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 0 | 300 |
| QTE-9A2E57 | REQ-L8Q4 | PRG-SABLE | 2 | DFARS | Tentative | 4340 | AMS 6359 | Norm | Plate | SRC-C2F9A7 | Approved | AMS 6359, AMS 6415, AMS 6419 | Y | China | N | 3.1 | Y | 500 | 250 | 5.45 | 46252 | 46262 | 10 | 46236 | Y | Y | Ineligible | On-time | Ineligible | Origin restriction; | 0 | 111 |
| QTE-9A2E57 | REQ-Z4V2 | PRG-HALCYON | 5 | None | Y | 4340 | AMS 6359 | Norm | Plate | SRC-C2F9A7 | Approved | AMS 6359, AMS 6415, AMS 6419 | Y | China | Y | 3.1 | Y | 500 | 250 | 5.45 | 46252 | 46327 | 75 | 46236 | Y | Y | Compliant | On-time | Eligible & on-time | Compliant full-quantity candidate | 389 | 111 |
| QTE-B6D2A9 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | Y | 4340 | AMS 6415 | Annealed | Bar | SRC-D14E8B | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Y | USA | Y | C of C | N | 700 | 250 | 4.95 | 46218 | 46239 | 21 | 46211 | Y | Y | Ineligible | On-time | Ineligible | Certification; | 0 | 700 |
Allocation Detail
| Planned Inventory and Purchase Allocation | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Blue quantity cells are the recommended allocation decision. Formulas verify yield, source capacity, compliance, timing, and cost. | |||||||||||||||||||
| Allocation ID | Requirement ID | Program ID | MRP | Source Type | Lot / Quote ID | Material Callout | Planned Usable Applied (lb) | Yield Factor | Gross Reserve / Applied (lb) | Source Capacity (usable/quoted lb) | Capacity Remaining (lb) | Eligibility Check | Unit Price ($/lb) | Applied Cost ($) | Need-By | Receipt Date | Days Early | Priority | Allocation Rationale |
| A001 | REQ-H4A2 | PRG-RAVEN | Y | Inventory | LOT-7F3A2B | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 516.6 | 0.82 | 630 | 516.6 | 0 | PASS | 0 | 0 | 46244 | 1 | Allocate all eligible T7351 yield to highest-priority Raven. | ||
| A002 | REQ-H4A2 | PRG-RAVEN | Y | Purchase | QTE-A3F91C | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 325.4 | 1 | 325.4 | 600 | 6.60000000000002 | PASS | 9.4 | 3058.76 | 46244 | 46233 | 11 | 1 | Cascade quote shared with Sable; 11-day Raven receipt margin. |
| A003 | REQ-K9P1 | PRG-RAVEN | Y | Inventory | LOT-3E8C71 | 4340 | AMS 6415 | Annealed | Bar | 416 | 0.8 | 520 | 416 | 0 | PASS | 0 | 0 | 46239 | 1 | Use full yield-adjusted lot. | ||
| A004 | REQ-K9P1 | PRG-RAVEN | Y | Inventory | LOT-9A4F37 | 4340 | AMS 6415 | Annealed | Bar | 199 | 0.8 | 248.75 | 244 | 0 | PASS | 0 | 0 | 46239 | 1 | Complete Raven before lower-priority Calder. | ||
| A005 | REQ-C9T1 | PRG-RAVEN | Y | Purchase | QTE-8B3F19 | 300M | AMS 6419 | Annealed | Bar | 176 | 1 | 176 | 250 | 74 | PASS | 14.2 | 2499.2 | 46237 | 46229 | 8 | 1 | Only compliant quoted 300M source for DFARS Raven; 8-day margin. |
| A006 | REQ-X5M3 | PRG-RAVEN | Y | Inventory | LOT-6B2F39 | 15-5PH | AMS 5862 | Cond A | Plate | 394 | 0.82 | 480.487804878049 | 500.2 | 0 | PASS | 0 | 0 | 46246 | 1 | Qualifying Slovenia origin; highest-priority use. | ||
| A007 | REQ-T2C7 | PRG-SABLE | Y | Inventory | LOT-6B2F39 | 15-5PH | AMS 5862 | Cond A | Plate | 106.2 | 0.82 | 129.512195121951 | 500.2 | 0 | PASS | 0 | 0 | 46258 | 2 | Remainder after Raven priority allocation. | ||
| A008 | REQ-T2C7 | PRG-SABLE | Y | Purchase | QTE-3A9F18 | 15-5PH | AMS 5862 | Cond A | Plate | 323.8 | 1 | 323.8 | 900 | 219.2 | PASS | 11.75 | 3804.65 | 46258 | 46240 | 18 | 2 | Compliant Ardenne quote; shared with Tundra. |
| A009 | REQ-B6N3 | PRG-SABLE | Y | Purchase | QTE-A3F91C | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 268 | 1 | 268 | 600 | 6.60000000000002 | PASS | 9.4 | 2519.2 | 46256 | 46233 | 23 | 2 | Cascade qualifying quote; 23-day margin. |
| A010 | REQ-F6B8 | PRG-SABLE | Y | Inventory | LOT-7E1C95 | 6061 | AMS 4117 | T651 | Bar | 233 | 0.82 | 284.146341463415 | 237.8 | 0 | PASS | 0 | 0 | 46260 | 2 | Priority allocation to Sable. | ||
| A011 | REQ-L8Q4 | PRG-SABLE | Tentative | Purchase | QTE-6D1B84 | 4340 | AMS 6359 | Norm | Plate | 287 | 1 | 287 | 450 | 163 | PASS | 6.9 | 1980.3 | 46262 | 46260 | 2 | 2 | Compliant USA quote; only 2 days before need-by. |
| A012 | REQ-M1X8 | PRG-MERIDIAN | Y | Inventory | LOT-E8C520 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 512 | 0.88 | 581.818181818182 | 950.4 | 438.4 | PASS | 0 | 0 | 46286 | 3 | Dedicated compliant USA plate lot. | ||
| A013 | REQ-D7R4 | PRG-MERIDIAN | Y | Inventory | LOT-5B2E88 | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 323.9 | 0.79 | 410 | 323.9 | 0 | PASS | 0 | 0 | 46283 | 3 | Use full yield-adjusted extrusion lot. | ||
| A014 | REQ-D7R4 | PRG-MERIDIAN | Y | Purchase | QTE-2D7C64 | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 23.1 | 1 | 23.1 | 400 | 163.9 | PASS | 7.6 | 175.56 | 46283 | 46236 | 47 | 3 | Cascade quote shared with Tundra; firm-demand residual. |
| A015 | REQ-W3F9 | PRG-MERIDIAN | Y | Purchase | QTE-2F8C41 | 15-5PH | AMS 5659 | H1025 | Bar | 198 | 1 | 198 | 300 | 102 | PASS | 9.85 | 1950.3 | 46279 | 46243 | 36 | 3 | France origin accepted under CUST-EU. |
| A016 | REQ-R7W2 | PRG-MERIDIAN | Y | Inventory | LOT-2C9E14 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 412 | 0.85 | 484.705882352941 | 586.5 | 0 | PASS | 0 | 0 | 46277 | 3 | Priority allocation to Meridian. | ||
| A017 | REQ-G2J9 | PRG-MERIDIAN | Tentative | Inventory | LOT-7E1C95 | 6061 | AMS 4117 | T651 | Bar | 4.8 | 0.82 | 5.85365853658537 | 237.8 | 0 | PASS | 0 | 0 | 46281 | 3 | Remainder after Sable priority allocation. | ||
| A018 | REQ-G2J9 | PRG-MERIDIAN | Tentative | Purchase | QTE-1A6E38 | 6061 | AMS 4117 | T651 | Bar | 154.2 | 1 | 154.2 | 300 | 145.8 | PASS | 5.75 | 886.65 | 46281 | 46246 | 35 | 3 | Only approved-source AMS 4117 quote; tentative gate. |
| A019 | REQ-J5G7 | PRG-TUNDRA | Y | Inventory | LOT-8D4B19 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 388.85 | 0.77 | 505 | 388.85 | 0 | PASS | 0 | 0 | 46307 | 4 | Use full yield-adjusted lot. | ||
| A020 | REQ-J5G7 | PRG-TUNDRA | Y | Inventory | LOT-2E6B95 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 66.15 | 0.78 | 84.8076923076923 | 335.4 | 0 | PASS | 0 | 0 | 46307 | 4 | Complete Tundra before Calder. | ||
| A021 | REQ-P2H6 | PRG-TUNDRA | Y | Inventory | LOT-6F2A87 | 17-4PH | AMS 5604 | H1075 | Bar | 284 | 0.85 | 334.117647058824 | 289 | 0 | PASS | 0 | 0 | 46304 | 4 | Priority allocation to Tundra. | ||
| A022 | REQ-V1D9 | PRG-TUNDRA | Y | Purchase | QTE-3A9F18 | 15-5PH | AMS 5862 | Cond A | Plate | 357 | 1 | 357 | 900 | 219.2 | PASS | 11.75 | 4194.75 | 46301 | 46240 | 61 | 4 | Residual Ardenne quote capacity; compliant for CUST-EU. |
| A023 | REQ-Y8K2 | PRG-TUNDRA | Tentative | Purchase | QTE-2D7C64 | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 213 | 1 | 213 | 400 | 163.9 | PASS | 7.6 | 1618.8 | 46306 | 46236 | 70 | 4 | Shared Cascade quote; tentative gate. |
| A024 | REQ-Q8L5 | PRG-HALCYON | Y | Inventory | LOT-3A7C82 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 726 | 0.87 | 834.48275862069 | 765.6 | 39.6 | PASS | 0 | 0 | 46328 | 5 | Compliant USA plate lot. | ||
| A025 | REQ-Z4V2 | PRG-HALCYON | Y | Purchase | QTE-9A2E57 | 4340 | AMS 6359 | Norm | Plate | 389 | 1 | 389 | 500 | 111 | PASS | 5.45 | 2120.05 | 46327 | 46252 | 75 | 5 | China origin allowed for unrestricted Halcyon; approved source/spec. |
| A026 | REQ-N3K4 | PRG-HALCYON | Y | Inventory | LOT-9C5F28 | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 301 | 0.83 | 362.650602409639 | 385.95 | 84.95 | PASS | 0 | 0 | 46331 | 5 | Compliant inventory covers full requirement. | ||
| A027 | REQ-S6P3 | PRG-HALCYON | Tentative | Inventory | LOT-2C9E14 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 174.5 | 0.85 | 205.294117647059 | 586.5 | 0 | PASS | 0 | 0 | 46330 | 5 | Remainder after Meridian priority allocation. | ||
| A028 | REQ-S6P3 | PRG-HALCYON | Tentative | Purchase | QTE-9E4B27 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 69.5 | 1 | 69.5 | 500 | 430.5 | PASS | 8.7 | 604.65 | 46330 | 46238 | 92 | 5 | 250-lb MOQ; tentative Halcyon gate. |
| A029 | REQ-A2F7 | PRG-CALDER | Y | Inventory | LOT-A1E9F4 | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 333 | 0.87 | 382.758620689655 | 591.6 | 258.6 | PASS | 0 | 0 | 46342 | 6 | Compliant inventory covers full requirement. | ||
| A030 | REQ-E9C1 | PRG-CALDER | Y | Inventory | LOT-2E6B95 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 269.25 | 0.78 | 345.192307692308 | 335.4 | 0 | PASS | 0 | 0 | 46340 | 6 | Remainder after Tundra priority allocation. | ||
| A031 | REQ-E9C1 | PRG-CALDER | Y | Purchase | QTE-C1E7B4 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 1.75 | 1 | 1.75 | 500 | 498.25 | PASS | 8.9 | 15.575 | 46340 | 46237 | 103 | 6 | Yield shortfall triggers 250-lb MOQ. |
| A032 | REQ-U4B8 | PRG-CALDER | Tentative | Inventory | LOT-6F2A87 | 17-4PH | AMS 5604 | H1075 | Bar | 5 | 0.85 | 5.88235294117647 | 289 | 0 | PASS | 0 | 0 | 46344 | 6 | Remainder after Tundra priority allocation. | ||
| A033 | REQ-U4B8 | PRG-CALDER | Tentative | Purchase | QTE-7E2A85 | 17-4PH | AMS 5604 | H1075 | Bar | 157 | 1 | 157 | 250 | 93 | PASS | 11.1 | 1742.7 | 46344 | 46249 | 95 | 6 | Adriatic minimizes total spend at residual quantity; tentative gate. |
| A034 | REQ-H7D5 | PRG-CALDER | Y | Inventory | LOT-9A4F37 | 4340 | AMS 6415 | Annealed | Bar | 45 | 0.8 | 56.25 | 244 | 0 | PASS | 0 | 0 | 46339 | 6 | Remainder after Raven priority allocation. | ||
| A035 | REQ-H7D5 | PRG-CALDER | Y | Purchase | QTE-D9F3B1 | 4340 | AMS 6415 | Annealed | Bar | 160 | 1 | 160 | 500 | 340 | PASS | 5.35 | 856 | 46339 | 46226 | 113 | 6 | Great Lakes 250-lb MOQ is lower total spend than 300-lb alternative. |
| A036 | REQ-W9A3 | PRG-CALDER | Tentative | Inventory | LOT-C7A340 | 15-5PH | AMS 5659 | H1025 | Bar | 147 | 0.84 | 175 | 252 | 105 | PASS | 0 | 0 | 46343 | 6 | China origin permitted for unrestricted Calder; source/spec approved. |
PO Plan
| Recommended Supplier Purchase Plan | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Protect-all scenario covers firm and tentative requirements. Firm baseline excludes tentative-only releases and uses MOQ where a firm residual exists. | ||||||||||||||||||||||
| Quote ID | Source ID | Source Name | Material Callout | Quoted Qty (lb) | MOQ (lb) | Unit Price ($/lb) | Quote Expiry | Receipt Date | Applied — All Requirements (lb) | Applied — Firm Only (lb) | Firm Baseline Order (lb) | Protect-All Order (lb) | Tentative Increment (lb) | MOQ / Excess (lb) | Protect-All Cost ($) | Firm Baseline Cost ($) | Tentative Increment Cost ($) | Capacity Check | Excess Cost Owner Req | Release Gate | Requirements Served | Selection Rationale |
| QTE-D9F3B1 | SRC-7B2F60 | Great Lakes Plate & Bar Co | 4340 | AMS 6415 | Annealed | Bar | 500 | 250 | 5.35 | 46217 | 46226 | 160 | 160 | 250 | 250 | 0 | 90 | 1337.5 | 1337.5 | 0 | PASS | REQ-H7D5 | Release now — firm Calder demand; MOQ economics | REQ-H7D5 | 250-lb MOQ yields lower total spend than Brunderman's 300-lb MOQ; C-of-C alternative rejected. |
| QTE-8B3F19 | SRC-58E1B3 | Brunderman Forge & Bar Inc | 300M | AMS 6419 | Annealed | Bar | 250 | 150 | 14.2 | 46217 | 46229 | 176 | 176 | 176 | 176 | 0 | 0 | 2499.2 | 2499.2 | 0 | PASS | 638 | REQ-C9T1 | Only qualifying, approved, 3.1 300M quote for Raven. | |
| QTE-A3F91C | SRC-9F2A41 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 600 | 250 | 9.4 | 46218 | 46233 | 593.4 | 593.4 | 593.4 | 593.4 | 0 | 0 | 5577.96 | 5577.96 | 0 | PASS | 640 | REQ-H4A2, REQ-B6N3 | Lowest-cost qualifying T7351 quote that is on time for Raven; 593.4 of 600 lb used. | |
| QTE-2D7C64 | SRC-9F2A41 | Cascade Rolled Products LLC | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 400 | 200 | 7.6 | 46222 | 46236 | 236.1 | 23.1 | 200 | 236.1 | 36.1 | 0 | 1794.36 | 1520 | 274.36 | PASS | 643 | REQ-D7R4, REQ-Y8K2 | Lower unit price than Tri-State; ample timing margin. | |
| QTE-3A9F18 | SRC-3B7C19 | Ardenne Steelworks SA | 15-5PH | AMS 5862 | Cond A | Plate | 900 | 400 | 11.75 | 46223 | 46240 | 680.8 | 680.8 | 680.8 | 680.8 | 0 | 0 | 7999.4 | 7999.4 | 0 | PASS | 646 | REQ-T2C7, REQ-V1D9 | Lower unit cost than compliant Adriatic alternative; receipt remains before both need-by dates. | |
| QTE-9E4B27 | SRC-9F2A41 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 500 | 250 | 8.7 | 46223 | 46238 | 69.5 | 0 | 0 | 250 | 250 | 180.5 | 2175 | 0 | 2175 | PASS | REQ-S6P3 | PMO firming gate — tentative Halcyon demand | REQ-S6P3 | Lower cost than Great Lakes; MOQ creates 180.5 lb excess. |
| QTE-7E2A85 | SRC-E5C913 | Adriatic Aero Alloys d.o.o. | 17-4PH | AMS 5604 | H1075 | Bar | 250 | 150 | 11.1 | 46226 | 46249 | 157 | 0 | 0 | 157 | 157 | 0 | 1742.7 | 0 | 1742.7 | PASS | 651 | REQ-U4B8 | For 157-lb residual, 150-lb MOQ yields lower total spend than Pohang's 200-lb MOQ or Ardenne's higher unit price. | |
| QTE-1A6E38 | SRC-9F2A41 | Cascade Rolled Products LLC | 6061 | AMS 4117 | T651 | Bar | 300 | 150 | 5.75 | 46228 | 46246 | 154.2 | 0 | 0 | 154.2 | 154.2 | 0 | 886.65 | 0 | 886.65 | PASS | 653 | REQ-G2J9 | Cascade is approved for AMS 4117; Great Lakes quote is not approved for this family. | |
| QTE-9A2E57 | SRC-C2F9A7 | Yellow River Specialty Steel | 4340 | AMS 6359 | Norm | Plate | 500 | 250 | 5.45 | 46236 | 46252 | 389 | 389 | 389 | 389 | 0 | 0 | 2120.05 | 2120.05 | 0 | PASS | 655 | REQ-Z4V2 | Lowest cost; non-qualifying origin is allowed because Halcyon has no special origin restriction. | |
| QTE-6D1B84 | SRC-58E1B3 | Brunderman Forge & Bar Inc | 4340 | AMS 6359 | Norm | Plate | 450 | 250 | 6.9 | 46239 | 46260 | 287 | 0 | 0 | 287 | 287 | 0 | 1980.3 | 0 | 1980.3 | PASS | 657 | REQ-L8Q4 | Only compliant DFARS option; 2-day margin requires escalation. | |
| QTE-C1E7B4 | SRC-9F2A41 | Cascade Rolled Products LLC | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 500 | 250 | 8.9 | 46225 | 46237 | 1.75 | 1.75 | 250 | 250 | 0 | 248.25 | 2225 | 2225 | 0 | PASS | REQ-E9C1 | Release now — firm Calder demand; MOQ economics | REQ-E9C1 | Lower cost than Great Lakes; 1.75 lb residual triggers 250-lb MOQ. |
| QTE-2F8C41 | SRC-3B7C19 | Ardenne Steelworks SA | 15-5PH | AMS 5659 | H1025 | Bar | 300 | 150 | 9.85 | 46226 | 46243 | 198 | 198 | 198 | 198 | 0 | 0 | 1950.3 | 1950.3 | 0 | PASS | 660 | REQ-W3F9 | Qualifying France origin; Hangzhou alternative fails Meridian CUST-EU restriction. | |
| TOTAL | 5450 | 3102.75 | 2222.05 | 2737.2 | 3621.5 | 884.3 | 518.75 | 32288.42 | 25229.41 | 7059.01 |
Requirement Plan
| Requirement-Level Material Coverage Plan | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Priority-first allocation; all inventory is yield-adjusted and all purchase quantities are tied to compliant, on-time quote lines. | |||||||||||||||||||
| Requirement ID | Priority | Program ID | Program Name | MRP | Alloy | Material Spec | Condition | Form | Need-By | Net Required (usable lb) | Planned Inventory (usable lb) | Planned Purchase Applied (lb) | Total Coverage (lb) | Shortfall (lb) | Coverage Status | Assigned PO Cost ($) | Risk / Gate | Recommended Action | Source Basis |
| REQ-H4A2 | 1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 46244 | 842 | 516.6 | 325.4 | 842 | 0 | Covered — Inventory + PO | 3058.76 | WATCH — shared quote uses 593.4 of 600 lb | Reserve LOT-7F3A2B: 516.60 lb; Apply PO QTE-A3F91C: 325.40 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-K9P1 | 1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | Y | 4340 | AMS 6415 | Annealed | Bar | 46239 | 615 | 615 | 0 | 615 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-3E8C71: 416.00 lb; Reserve LOT-9A4F37: 199.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-C9T1 | 1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | Y | 300M | AMS 6419 | Annealed | Bar | 46237 | 176 | 0 | 176 | 176 | 0 | Covered — Inventory + PO | 2499.2 | WATCH — 8-day receipt margin; DFARS | Apply PO QTE-8B3F19: 176.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-X5M3 | 1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46246 | 394 | 394 | 0 | 394 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-6B2F39: 394.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-T2C7 | 2 | PRG-SABLE | Sable Emergency Egress Hinge Arm | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46258 | 430 | 106.2 | 323.8 | 430 | 0 | Covered — Inventory + PO | 3804.65 | Normal | Reserve LOT-6B2F39: 106.20 lb; Apply PO QTE-3A9F18: 323.80 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-B6N3 | 2 | PRG-SABLE | Sable Emergency Egress Hinge Arm | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 46256 | 268 | 0 | 268 | 268 | 0 | Covered — Inventory + PO | 2519.2 | Normal | Apply PO QTE-A3F91C: 268.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-F6B8 | 2 | PRG-SABLE | Sable Emergency Egress Hinge Arm | Y | 6061 | AMS 4117 | T651 | Bar | 46260 | 233 | 233 | 0 | 233 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-7E1C95: 233.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-L8Q4 | 2 | PRG-SABLE | Sable Emergency Egress Hinge Arm | Tentative | 4340 | AMS 6359 | Norm | Plate | 46262 | 287 | 0 | 287 | 287 | 0 | Covered — PMO gate | 1980.3 | AT RISK — 2-day receipt margin; tentative | Apply PO QTE-6D1B84: 287.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-M1X8 | 3 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46286 | 512 | 512 | 0 | 512 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-E8C520: 512.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-D7R4 | 3 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Y | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 46283 | 347 | 323.9 | 23.1 | 347 | 0 | Covered — Inventory + PO | 175.56 | Normal | Reserve LOT-5B2E88: 323.90 lb; Apply PO QTE-2D7C64: 23.10 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-W3F9 | 3 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Y | 15-5PH | AMS 5659 | H1025 | Bar | 46279 | 198 | 0 | 198 | 198 | 0 | Covered — Inventory + PO | 1950.3 | Normal | Apply PO QTE-2F8C41: 198.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-R7W2 | 3 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Y | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 46277 | 412 | 412 | 0 | 412 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-2C9E14: 412.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-G2J9 | 3 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Tentative | 6061 | AMS 4117 | T651 | Bar | 46281 | 159 | 4.8 | 154.2 | 159 | 0 | Covered — PMO gate | 886.65 | GATE — tentative demand | Reserve LOT-7E1C95: 4.80 lb; Apply PO QTE-1A6E38: 154.20 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-J5G7 | 4 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | Y | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 46307 | 455 | 455 | 0 | 455 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-8D4B19: 388.85 lb; Reserve LOT-2E6B95: 66.15 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-P2H6 | 4 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | Y | 17-4PH | AMS 5604 | H1075 | Bar | 46304 | 284 | 284 | 0 | 284 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-6F2A87: 284.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-V1D9 | 4 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46301 | 357 | 0 | 357 | 357 | 0 | Covered — Inventory + PO | 4194.75 | Normal | Apply PO QTE-3A9F18: 357.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-Y8K2 | 4 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | Tentative | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 46306 | 213 | 0 | 213 | 213 | 0 | Covered — PMO gate | 1618.8 | GATE — tentative demand | Apply PO QTE-2D7C64: 213.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-Q8L5 | 5 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46328 | 726 | 726 | 0 | 726 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-3A7C82: 726.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-Z4V2 | 5 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | Y | 4340 | AMS 6359 | Norm | Plate | 46327 | 389 | 0 | 389 | 389 | 0 | Covered — Inventory + PO | 2120.05 | Normal | Apply PO QTE-9A2E57: 389.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-N3K4 | 5 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | Y | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 46331 | 301 | 301 | 0 | 301 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-9C5F28: 301.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-S6P3 | 5 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | Tentative | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 46330 | 244 | 174.5 | 69.5 | 244 | 0 | Covered — PMO gate | 2175 | GATE/COST — tentative; 180.5 lb MOQ excess | Reserve LOT-2C9E14: 174.50 lb; Apply PO QTE-9E4B27: 69.50 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-A2F7 | 6 | PRG-CALDER | Calder Overwing Hatch Hinge Set | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46342 | 333 | 333 | 0 | 333 | 0 | Covered — Inventory | 0 | Normal | Reserve LOT-A1E9F4: 333.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-E9C1 | 6 | PRG-CALDER | Calder Overwing Hatch Hinge Set | Y | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 46340 | 271 | 269.25 | 1.75 | 271 | 0 | Covered — Inventory + PO | 2225 | COST — 1.75 lb residual drives 250 lb MOQ | Reserve LOT-2E6B95: 269.25 lb; Apply PO QTE-C1E7B4: 1.75 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-U4B8 | 6 | PRG-CALDER | Calder Overwing Hatch Hinge Set | Tentative | 17-4PH | AMS 5604 | H1075 | Bar | 46344 | 162 | 5 | 157 | 162 | 0 | Covered — PMO gate | 1742.7 | GATE — tentative demand | Reserve LOT-6F2A87: 5.00 lb; Apply PO QTE-7E2A85: 157.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-H7D5 | 6 | PRG-CALDER | Calder Overwing Hatch Hinge Set | Y | 4340 | AMS 6415 | Annealed | Bar | 46339 | 205 | 45 | 160 | 205 | 0 | Covered — Inventory + PO | 1337.5 | COST — 90 lb MOQ excess | Reserve LOT-9A4F37: 45.00 lb; Apply PO QTE-D9F3B1: 160.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
| REQ-W9A3 | 6 | PRG-CALDER | Calder Overwing Hatch Hinge Set | Tentative | 15-5PH | AMS 5659 | H1025 | Bar | 46343 | 147 | 147 | 0 | 147 | 0 | Covered — Inventory | 0 | GATE — tentative; inventory-only | Reserve LOT-C7A340: 147.00 lb | MRP-2026-0619-R2; allocation and quote checks in supporting tabs |
Risks & Escalations
| Material Risks, Compliance Blocks, and Escalations | |||||||
|---|---|---|---|---|---|---|---|
| No waiver, expedite, certification correction, source-status change, yield change, or hold release is assumed. | |||||||
| Severity | Scope | Issue | Packet Evidence | Required Decision / Escalation | Owner | Deadline / Gate | Plan Dependency |
| RED | REQ-L8Q4 / Sable | Only compliant 4340 plate quote docks two days before need-by; requirement is tentative. | QTE-6D1B84: USA, 3.1, approved AMS 6359; receipt 2026-08-26 vs need 2026-08-28. | PMO must firm the demand; Sourcing must release before expiry; Quality/Receiving must confirm the documented two-day window can be executed. No expedite assumed. | PMO / Sourcing / Quality | Quote expiry 2026-08-05 | Protect-all plan depends on this quote. |
| RED | Current execution caveat | The packet is a 2026-06-19/20 snapshot. It contains no later inventory, quote, receipt, or approval update. | Program release PC-2026-0618 and WMS snapshot WMS-EXP-20260620-0741. | Use this as the packet-basis decision. Any release after a listed quote expiry requires a refreshed controlled quote; do not assume validity beyond expiry. | Sourcing / PMO | Before any PO release | All purchase actions. |
| AMBER | REQ-C9T1 / Raven | Physically available China-origin 300M is DFARS-ineligible; selected quote has eight-day margin. | LOT-2B7E54: 214.60 yield-adjusted lb, China. QTE-8B3F19: receipt 2026-07-26 vs need 2026-08-03. | Release QTE-8B3F19 before expiry and retain DFARS origin/certification controls. | Sourcing / Program | Quote expiry 2026-07-14 | Raven schedule. |
| AMBER | REQ-H4A2 / REQ-B6N3 | Shared compliant T7351 quote uses 593.4 of 600 quoted lb; China stock and quote are origin-ineligible. | LOT-5C9A16: 736.00 yield-adjusted lb China; QTE-A3F91C: USA, 3.1, receipt 2026-07-30. | Release QTE-A3F91C before expiry and lock the stated Raven/Sable split; do not substitute T651 or China-origin material. | Sourcing / Planning | Quote expiry 2026-07-15 | Raven and Sable coverage. |
| AMBER | Tentative requirements | Protecting all tentative lines adds $7,059.01 above the firm-demand baseline. | REQ-L8Q4, REQ-G2J9, REQ-Y8K2, REQ-S6P3, REQ-U4B8 require quote spend; REQ-W9A3 is inventory-only. | PMO must decide whether to release tentative-only lines and the 36.1-lb QTE-2D7C64 increment before their quote expiries. | PMO / Finance / Sourcing | Earliest affected expiry 2026-07-19 | Protect-all spend and tentative coverage. |
| AMBER | Quality holds | Two otherwise matching lots are ineligible while holds remain open. | LOT-B3E7C0: 979.40 yield-adjusted lb, Quality Hold—MRB. LOT-8F4D17: 212.50 lb, Quality Hold—Receiving Inspection. | Quality/MRB may disposition the holds through controlled processes; plan assigns zero pounds until documented release. | Quality / MRB | No assumed clearance date | Not required for base plan, potential contingency only. |
| AMBER | Certification / traceability | C of C or partial traceability cannot support certified production. | LOT-D6B821 and LOT-4A8D62: C of C. LOT-1F9D63: partial heat traceability and suspended source. QTE-B6D2A9: C of C. | Quarantine from this plan; any correction requires controlled quality evidence not present in packet. | Quality | Before any allocation | Prevents false on-hand/quote coverage. |
| AMBER | Source status | Conditional, Suspended, and Not Approved sources are not eligible for new commitments. | Lone Star conditional; Meridian suspended; Volga not approved. Related lots/quotes are excluded. | Supplier Quality escalation only if leadership seeks future requalification; no status change is assumed here. | Supplier Quality | Outside current plan | Excluded alternatives. |
| AMBER | MOQ economics | Three small residuals create 518.75 lb of excess order quantity and concentrate $5,737.50 of PO spend. | REQ-E9C1: 1.75 lb applied / 250 lb PO. REQ-H7D5: 160 / 250. REQ-S6P3: 69.5 / 250. | Approve excess purchase or revisit the affected program commitments; yield and allocation changes are not authorized by the packet. | PMO / Sourcing / Finance | Before PO release | Calder/Halcyon cost. |
Alternatives
| Alternatives Considered | ||||
|---|---|---|---|---|
| Commercial attractiveness never overrides callout, certification, traceability, source status, origin, quantity, or lead-time rules. | ||||
| Material / Requirements | Preferred Plan | Alternatives Considered | Why Not Selected / Constraint | Compliance Conclusion |
| 7075 T7351 plate — REQ-H4A2, REQ-B6N3 | LOT-7F3A2B + QTE-A3F91C | LOT-5C9A16; QTE-7D2B40; QTE-F1C8A6 | Hangzhou lot/quote are China-origin and fail DFARS. Great Lakes docks after Raven need-by and costs more; it is feasible only for Sable. | Selected split is exact-callout, qualifying origin, 3.1, and on time for both programs. |
| 4340 AMS 6415 bar — REQ-K9P1, REQ-H7D5 | Eligible Brunderman lots; QTE-D9F3B1 for Calder residual | LOT-D6B821; QTE-B6D2A9; QTE-1E8C57 | Lot and Tri-State quote are C of C. Brunderman quote is compliant but 300-lb MOQ costs more than Great Lakes 250-lb MOQ. | Raven receives inventory first; Calder is bill-payer for residual/90-lb excess. |
| 300M bar — REQ-C9T1 | QTE-8B3F19 | LOT-2B7E54; QTE-4E9A72 | Both Yellow River candidates are China-origin and fail Raven DFARS despite lower cost/earlier availability. | Only selected quote is compliant and on time. |
| 15-5PH AMS 5862 plate — REQ-X5M3, REQ-T2C7, REQ-V1D9 | LOT-6B2F39 + QTE-3A9F18 | LOT-B3E7C0; LOT-1D6B43; LOT-4D1A95; QTE-9C4E27; QTE-6F1A93; QTE-5D8B72 | Open hold, Not Approved/Russia, or Conditional status block four candidates. Adriatic quote is compliant/earlier but higher price than Ardenne. | Priority split and Ardenne purchase cover all three without waiver. |
| 6061 AMS 4117 bar — REQ-F6B8, REQ-G2J9 | LOT-7E1C95 + QTE-1A6E38 | QTE-3F7D92 | Great Lakes is not approved for AMS 4117, even though its quote is earlier. | Sable inventory first; Cascade covers tentative Meridian residual. |
| 4340 AMS 6359 plate — REQ-L8Q4, REQ-Z4V2 | QTE-6D1B84 for Sable; QTE-9A2E57 for Halcyon | Use Yellow River for Sable; use Brunderman for both | China origin fails Sable DFARS but is allowed for unrestricted Halcyon. Using higher-cost USA material for Halcyon has no documented compliance benefit. | Program-specific origin split is compliant; Sable timing remains escalated. |
| 6061 plate — REQ-M1X8, REQ-Q8L5, REQ-A2F7 | Eligible on-hand lots only | QTE-2A7E61; QTE-5F1B83; QTE-8C3D49; LOT-1F9D63 | Eligible inventory supplies 2,307.60 usable lb vs 1,571 lb demand. Meridian lot is suspended/partially traceable. | No purchase required. |
| 2024 extrusion — REQ-D7R4, REQ-Y8K2 | LOT-5B2E88 + QTE-2D7C64 | QTE-9B4F27 | Tri-State is compliant and earlier but higher unit price; Cascade has ample date margin. | Meridian receives inventory first; shared PO covers residual and tentative Tundra. |
| 15-5PH AMS 5659 bar — REQ-W3F9, REQ-W9A3 | QTE-2F8C41 for Meridian; LOT-C7A340 for Calder | QTE-8A1D63 for Meridian | Hangzhou China origin fails Meridian CUST-EU but is permitted for unrestricted Calder. | Origin-specific split avoids unnecessary higher-cost purchase for Calder. |
| 7075 T651 plate — REQ-R7W2, REQ-S6P3 | LOT-2C9E14 + QTE-9E4B27 | LOT-4A8D62; QTE-4C8F12 | Tri-State lot is C of C. Great Lakes quote is compliant but costs more with the same MOQ. | Priority inventory plus Cascade MOQ covers both; T7351 is not substituted. |
| 7075 extrusion — REQ-J5G7, REQ-E9C1 | Eligible lots + QTE-C1E7B4 | QTE-3D9B16 | Great Lakes is compliant/earlier but higher unit price; both have 250-lb MOQ. | Yield creates a real 1.75-lb shortfall; Cascade is the lower-cost compliant fix. |
| 17-4PH bar — REQ-P2H6, REQ-U4B8 | LOT-6F2A87 + QTE-7E2A85 | LOT-8F4D17; QTE-6A2D58; QTE-1F7C93 | Ardenne lot is on receiving hold. Pohang has lower unit price but 200-lb MOQ; Ardenne quote has higher unit price. Adriatic minimizes total residual spend. | Tundra inventory first; tentative Calder purchase is gated. |
| 2024 plate — REQ-N3K4 | LOT-9C5F28 | QTE-7C3A95; QTE-5B9E41 | Inventory fully covers; buying creates unnecessary spend. | No purchase required. |
Material Sourcing Recommendation
2026 Q3 certified door and hinge mechanism build wave
To
Sourcing, Production, Quality, Materials Planning, and Program Leadership
From
Material Sourcing Review
Date
20 June 2026 — packet review basis
Subject
Compliant sourcing and priority allocation plan for aluminum and steel raw material
Decision requested. Lock the compliant inventory allocation, release the $25,229.41 firm-demand PO baseline before quote expiry, decide the $7,059.01 tentative-demand increment, and prohibit use of blocked lots/quotes unless a new controlled record changes their status.
Executive recommendation
Approve the packet-basis plan. All 26 requirements totaling 8,960.00 usable lb can be covered without an engineering substitution, customer waiver, undocumented expedite, certification correction, yield change, or reallocation of existing firm reservations. The plan reserves 5,857.25 usable lb of compliant on-hand inventory and applies 3,102.75 lb from compliant supplier quotes.
Because three residual shortages fall below supplier minimum orders, the protect-all release quantity is 3,621.50 lb, including 518.75 lb of MOQ-driven excess. Total protect-all spend is $32,288.42. The firm-demand baseline is $25,229.41; the remaining $7,059.01 protects tentative requirements and requires an explicit PMO decision.
26
requirements
5,857.25 lb
compliant inventory
$32,288.42
protect-all PO spend
0 lb
post-plan shortfall
Validity discipline. This recommendation is anchored to the packet’s 19–20 June 2026 status. The packet provides no evidence that a quote remains valid after its listed expiry or that inventory/quality status remains unchanged. Any later release requires a refreshed controlled quote and status revalidation; no replacement price, lead time, or expedite is assumed here.
Decision logic
Compliance first: exact alloy, specification, temper/condition, and product form; 3.1 or 3.2 certification; full traceability; no open hold; Approved source for the specification family; and program-allowed origin.
Quantity second: available inventory is reduced by existing allocations and the documented lot yield factor. Quoted quantity is compared directly with net usable demand, subject to MOQ, exactly as ENG-MSP Rev H directs.
Priority third: contested compliant stock is allocated Raven, Sable, Meridian, Tundra, Halcyon, then Calder. Lower-priority demand receives a purchase or the residual escalation.
Commercial choice last: price and lead time decide only among compliant candidates. No prohibited T651/T7351, plate/bar/extrusion, steel-spec, or alloy substitution is used.
Program allocation and commitment
The allocation preserves the documented program ranking. Assigned PO spend includes MOQ excess charged to the requirement that creates it.
Rank
Program
Demand (usable lb)
Inventory (usable lb)
Purchase applied (lb)
Assigned PO spend
Status / critical point
1
Raven
2,027.00
1,525.60
501.40
$5,557.96
Covered; release T7351 and 300M quotes. 300M margin is 8 days.
2
Sable
1,218.00
339.20
878.80
$8,304.15
Covered, but REQ-L8Q4 is tentative with a 2-day receipt margin.
3
Meridian
1,628.00
1,252.70
375.30
$3,012.51
Covered; PMO gate for tentative AMS 4117 bar.
4
Tundra
1,309.00
739.00
570.00
$5,813.55
Covered; PMO decides 36.10 lb increment for tentative extrusion.
5
Halcyon
1,660.00
1,201.50
458.50
$4,295.05
Covered; tentative T651 plate drives 180.50 lb MOQ excess.
6
Calder
1,118.00
799.25
318.75
$5,305.20
Covered; lowest-priority bill-payer for two MOQ residuals.
Leadership implication. Raven and Sable consume the eligible inventory first where demand competes. Calder absorbs the residual purchase/MOQ burden consistent with the schedule’s bill-payer guidance. This is a priority decision, not an assertion that lower-priority demand is less technically important.
Requirement-level sourcing plan
Quantities below are usable pounds applied to the requirement. PO order quantities may be higher where supplier MOQ applies; see the purchase table.
Program / Requirement
Engineering callout
Need-by / MRP
Compliant inventory allocation
Purchase applied
Result
Raven / REQ-H4A2
7075 / AMS-QQ-A-250/12 / T7351 / Plate
2026-08-10 / Firm
LOT-7F3A2B 516.60
QTE-A3F91C 325.40
Covered; shared quote has 6.60 lb headroom
Raven / REQ-K9P1
4340 / AMS 6415 / Annealed / Bar
2026-08-05 / Firm
LOT-3E8C71 416.00; LOT-9A4F37 199.00
—
Covered from compliant on-hand
Raven / REQ-C9T1
300M / AMS 6419 / Annealed / Bar
2026-08-03 / Firm
—
QTE-8B3F19 176.00
Covered; 8-day receipt margin
Raven / REQ-X5M3
15-5PH / AMS 5862 / Cond A / Plate
2026-08-12 / Firm
LOT-6B2F39 394.00
—
Covered from qualifying-origin on-hand
Sable / REQ-T2C7
15-5PH / AMS 5862 / Cond A / Plate
2026-08-24 / Firm
LOT-6B2F39 106.20
QTE-3A9F18 323.80
Covered; inventory follows Raven priority
Sable / REQ-B6N3
7075 / AMS-QQ-A-250/12 / T7351 / Plate
2026-08-22 / Firm
—
QTE-A3F91C 268.00
Covered by shared Cascade quote
Sable / REQ-F6B8
6061 / AMS 4117 / T651 / Bar
2026-08-26 / Firm
LOT-7E1C95 233.00
—
Covered from compliant on-hand
Sable / REQ-L8Q4
4340 / AMS 6359 / Norm / Plate
2026-08-28 / Tentative
—
QTE-6D1B84 287.00
AT RISK: only 2 days early; PMO gate
Meridian / REQ-M1X8
6061 / AMS-QQ-A-250/11 / T651 / Plate
2026-09-21 / Firm
LOT-E8C520 512.00
—
Covered from compliant on-hand
Meridian / REQ-D7R4
2024 / AMS-QQ-A-200/3 / T3511 / Extrusion
2026-09-18 / Firm
LOT-5B2E88 323.90
QTE-2D7C64 23.10
Covered; quote shared with Tundra
Meridian / REQ-W3F9
15-5PH / AMS 5659 / H1025 / Bar
2026-09-14 / Firm
—
QTE-2F8C41 198.00
Covered; France origin meets CUST-EU
Meridian / REQ-R7W2
7075 / AMS-QQ-A-250/12 / T651 / Plate
2026-09-12 / Firm
LOT-2C9E14 412.00
—
Covered; no T7351 substitution
Meridian / REQ-G2J9
6061 / AMS 4117 / T651 / Bar
2026-09-16 / Tentative
LOT-7E1C95 4.80
QTE-1A6E38 154.20
Covered subject to PMO firming gate
Tundra / REQ-J5G7
7075 / AMS-QQ-A-200/11 / T6511 / Extrusion
2026-10-12 / Firm
LOT-8D4B19 388.85; LOT-2E6B95 66.15
—
Covered; priority before Calder
Tundra / REQ-P2H6
17-4PH / AMS 5604 / H1075 / Bar
2026-10-09 / Firm
LOT-6F2A87 284.00
—
Covered; priority before Calder
Tundra / REQ-V1D9
15-5PH / AMS 5862 / Cond A / Plate
2026-10-06 / Firm
—
QTE-3A9F18 357.00
Covered by shared Ardenne quote
Tundra / REQ-Y8K2
2024 / AMS-QQ-A-200/3 / T3511 / Extrusion
2026-10-11 / Tentative
—
QTE-2D7C64 213.00
Covered subject to 36.10 lb PO increment
Halcyon / REQ-Q8L5
6061 / AMS-QQ-A-250/11 / T651 / Plate
2026-11-02 / Firm
LOT-3A7C82 726.00
—
Covered from compliant on-hand
Halcyon / REQ-Z4V2
4340 / AMS 6359 / Norm / Plate
2026-11-01 / Firm
—
QTE-9A2E57 389.00
Covered; China origin allowed for Halcyon
Halcyon / REQ-N3K4
2024 / AMS-QQ-A-250/4 / T351 / Plate
2026-11-05 / Firm
LOT-9C5F28 301.00
—
Covered from compliant on-hand
Halcyon / REQ-S6P3
7075 / AMS-QQ-A-250/12 / T651 / Plate
2026-11-04 / Tentative
LOT-2C9E14 174.50
QTE-9E4B27 69.50
PMO gate; 250 lb MOQ creates 180.50 excess
Calder / REQ-A2F7
6061 / AMS-QQ-A-250/11 / T651 / Plate
2026-11-16 / Firm
LOT-A1E9F4 333.00
—
Covered from compliant on-hand
Calder / REQ-E9C1
7075 / AMS-QQ-A-200/11 / T6511 / Extrusion
2026-11-14 / Firm
LOT-2E6B95 269.25
QTE-C1E7B4 1.75
Covered; 250 lb MOQ required
Calder / REQ-U4B8
17-4PH / AMS 5604 / H1075 / Bar
2026-11-18 / Tentative
LOT-6F2A87 5.00
QTE-7E2A85 157.00
Covered subject to PMO firming gate
Calder / REQ-H7D5
4340 / AMS 6415 / Annealed / Bar
2026-11-13 / Firm
LOT-9A4F37 45.00
QTE-D9F3B1 160.00
Covered; 250 lb MOQ creates 90 lb excess
Calder / REQ-W9A3
15-5PH / AMS 5659 / H1025 / Bar
2026-11-17 / Tentative
LOT-C7A340 147.00
—
Covered on hand; China permitted for Calder
Supplier actions and commercial tradeoffs
Release sequence is sorted by quote expiry. Protect-all order quantity equals the applied quantity or MOQ, whichever is greater, and never exceeds quoted quantity.
Quote
Source / material
Order lb
PO cost
Receipt / expiry
Requirements / release gate
QTE-D9F3B1
Great Lakes — 4340 AMS 6415 bar
250.00
$1,337.50
Dock 07-23 / Exp 07-14
REQ-H7D5; release firm; 90 lb excess
QTE-8B3F19
Brunderman — 300M AMS 6419 bar
176.00
$2,499.20
Dock 07-26 / Exp 07-14
REQ-C9T1; release firm; 8-day margin
QTE-A3F91C
Cascade — 7075 T7351 plate
593.40
$5,577.96
Dock 07-30 / Exp 07-15
REQ-H4A2 / REQ-B6N3; release firm
QTE-2D7C64
Cascade — 2024 T3511 extrusion
236.10
$1,794.36
Dock 08-02 / Exp 07-19
200 lb firm baseline; +36.10 lb PMO gate
QTE-3A9F18
Ardenne — 15-5PH Cond A plate
680.80
$7,999.40
Dock 08-06 / Exp 07-20
REQ-T2C7 / REQ-V1D9; release firm
QTE-9E4B27
Cascade — 7075 T651 plate
250.00
$2,175.00
Dock 08-04 / Exp 07-20
REQ-S6P3; tentative PMO gate
QTE-C1E7B4
Cascade — 7075 T6511 extrusion
250.00
$2,225.00
Dock 08-03 / Exp 07-22
REQ-E9C1; release firm; 248.25 lb excess
QTE-7E2A85
Adriatic — 17-4PH H1075 bar
157.00
$1,742.70
Dock 08-15 / Exp 07-23
REQ-U4B8; tentative PMO gate
QTE-2F8C41
Ardenne — 15-5PH H1025 bar
198.00
$1,950.30
Dock 08-09 / Exp 07-23
REQ-W3F9; release firm
QTE-1A6E38
Cascade — 6061 AMS 4117 bar
154.20
$886.65
Dock 08-12 / Exp 07-25
REQ-G2J9; tentative PMO gate
QTE-9A2E57
Yellow River — 4340 AMS 6359 plate
389.00
$2,120.05
Dock 08-18 / Exp 08-02
REQ-Z4V2; release firm; origin allowed
QTE-6D1B84
Brunderman — 4340 AMS 6359 plate
287.00
$1,980.30
Dock 08-26 / Exp 08-05
REQ-L8Q4; PMO/Quality escalation; 2 days
Why these quotes
Calder 4340 bar: Great Lakes at $5.35/lb is preferred over Brunderman at $5.20/lb because the 250-lb MOQ produces a $1,337.50 commitment versus $1,560.00 at the 300-lb Brunderman MOQ. The $4.95/lb Tri-State quote is rejected because it offers only C of C.
Calder 17-4PH bar: Adriatic at $11.10/lb and a 150-lb MOQ costs $1,742.70 for the 157-lb residual. Pohang’s lower $10.90/lb price requires 200 lb ($2,180.00), while Ardenne is $11.40/lb ($1,789.80).
15-5PH plate: Ardenne at $11.75/lb is selected over Adriatic at $12.40/lb. Its 6 August dock remains 18 days ahead of the earliest assigned Sable need-by and saves $442.52 on 680.80 lb.
4340 plate is split by program rule: DFARS Sable uses qualifying USA Brunderman material at $6.90/lb; unrestricted Halcyon may use approved Yellow River China-origin material at $5.45/lb. Applying Sable’s origin restriction to Halcyon would create cost without a documented compliance requirement.
Three MOQ effects create 518.75 lb excess: REQ-S6P3 180.50 lb, REQ-E9C1 248.25 lb, and REQ-H7D5 90.00 lb. The plan does not erase those quantities by changing yield or reallocating firm reservations.
Physically present but not usable for this plan
The following 5,078.30 yield-adjusted lb may look available arithmetically, but they cannot be planned against their current exact-match requirements. Held material could become eligible only after documented release; other lots may have future unrestricted uses. Neither possibility is credited here.
Lot
Material
Arithmetic usable lb
Current exclusion
LOT-5C9A16
7075 T7351 plate
736.00
China origin; its only current exact-match demands are Raven/Sable DFARS.
LOT-D6B821
4340 AMS 6415 bar
592.80
C of C only; 3.1/3.2 test report is mandatory.
LOT-B3E7C0
15-5PH Cond A plate
979.40
Open Quality Hold — MRB; excluded until controlled clearance.
LOT-2B7E54
300M AMS 6419 bar
214.60
China origin; Raven DFARS restriction blocks use.
LOT-8F4D17
17-4PH H1075 bar
212.50
Open receiving-inspection hold; no release date is documented.
LOT-1D6B43
15-5PH Cond A plate
664.00
Volga is Not Approved; Russia origin also conflicts with restricted programs.
LOT-1F9D63
6061 T651 plate
653.60
Meridian source is Suspended and heat traceability is partial.
LOT-4A8D62
7075 T651 plate
588.00
C of C only; certification does not meet ENG-MSP Rev H.
LOT-4D1A95
15-5PH Cond A plate
437.40
Lone Star is Conditional and ineligible for new commitments.
TOTAL
Yield-adjusted arithmetic quantity excluded
5,078.30
Physical presence does not establish certified-production usability.
Quoted alternatives rejected or limited
Origin: QTE-7D2B40 (7075 T7351) and QTE-4E9A72 (300M) are China-origin and cannot cover Raven/Sable DFARS demand. QTE-8A1D63 is China-origin and cannot cover Meridian CUST-EU demand.
Source status: QTE-9C4E27 is from Volga, a Not Approved source; QTE-6F1A93 is from Conditional Lone Star. Neither is eligible for a new commitment.
Certification: QTE-B6D2A9 offers only C of C and cannot support certified hardware.
Specification-family approval: QTE-3F7D92 matches the AMS 4117 callout commercially, but Great Lakes is not approved for AMS 4117. Cascade QTE-1A6E38 is selected.
Timing: QTE-F1C8A6 is compliant but docks 14 August, after Raven’s 10 August T7351 need-by. It could serve Sable, but Cascade QTE-A3F91C covers both high-priority residuals earlier and at a lower unit price.
Escalations and required ownership
Level
Scope
Required action
Owner
Gate
RED
Sable REQ-L8Q4
PMO must firm the tentative 4340 plate requirement. Sourcing must release QTE-6D1B84 before expiry. Quality/Receiving must confirm the documented two-day receipt-to-need window can be executed; no expedite is assumed.
PMO / Sourcing / Quality
Before 2026-08-05
RED
Packet-date validity
Before any PO release, confirm the quote is still within its listed expiry and revalidate the controlled inventory/AMSL status. The packet supplies no post-expiry promise.
Sourcing / Quality
At release
AMBER
Tentative-demand spend
32 more paragraphs not shown.
User prompt → 47 turns · 34 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’m using the spreadsheet and Word-document skills because the requested deliverables are an auditable analysis workbook…
I’m using the spreadsheet and Word-document skills because the requested deliverables are an auditable analysis workbook and a leadership memo. I’ll first inventory the source packet and read the skill instructions, then reconcile demand, compliance, allocations, yield, quotes, and schedule before generating and validating both files.
7Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const p = await tools.update_plan({plan:[ {step:"Inspect source packet and read spreadsheet/document skill instructions","status":"in_progress"}, {step:"Extract and reconcile demand, inventory, approvals, quotes, substitution rules, and priorities","status":"pending"}, {step:"Build and validate the sourcing analysis workbook","status":"pending"}, {step:"Draft and validate the recommendation memo","status":"pending"} ]}); const r = await tools.exec_command({cmd:"pwd && rg --files -g '!*output*' | sed -n '1,200p' && printf '\\n--- XLSX SKILL ---… 258 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.1 seconds Output: /workspace data/supplier_quote_leadtime_matrix.xlsx data/program_priority_build_schedule.docx data/material_demand_forecast.xlsx data/inventory_lot_cert_snapshot.xlsx data/engineering_material_substitution_policy.pdf data/approved_material_source_list.xlsx --- XLSX SKILL --- --- name: xlsx description: "Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like \"the xlsx in my downloads\") — and wants something done to it or produced fr
… 20,574 more characters of output in the raw trajectory.
8Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"printf '%s\\n' '--- XLSX SKILL CONTINUED ---' && sed -n '261,620p' /root/.agents/skills/xlsx/SKILL.md && printf '%s\\n' '--- DOCX SKILL CONTINUED ---' && sed -n '321,760p' /root/.agents/skills/docx/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: --- XLSX SKILL CONTINUED --- } } ``` ## Best Practices ### Library Selection - **pandas**: Best for data analysis, bulk operations, and simple data export - **openpyxl**: Best for complex formatting, formulas, and Excel-specific features ### Working with openpyxl - Cell indices are 1-based (row=1, column=1 refers to cell A1) - Use `data_only=True` to read calculated values: `load_workbook('file.xlsx', data_only=True)` - **Warning**: If opened with `data_only=True` and saved, formulas are replaced with values and permanently lost - For large files: Use `read_only=True` for reading or `write_only=True` for writing - Formulas are preserved but not evaluated - use scripts/recalc.py to update values ### Working with pandas - Specify data types to avoid inference issues: `pd.read_excel('file.xlsx', dtype={'id': str})` - For large files, read s… 10,560 more characters of output in the raw trajectory.
9The packet also includes the engineering substitution policy as a PDF, so I’m adding the PDF skill to extract and verify…
The packet also includes the engineering substitution policy as a PDF, so I’m adding the PDF skill to extract and verify that governing constraint before making any usability decision. This is important because a nominal material match cannot override an explicit substitution restriction.
10Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"sed -n '1,760p' /root/.agents/skills/pdf/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":30000}); 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.
11Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nfrom openpyxl import load_workbook\nfrom pathlib import Path\nfor path in sorted(Path('/workspace/data').glob('*.xlsx')):\n print(f'\\n===== {path.name} =====')\n wb=load_workbook(path, data_only=False, read_only=False)\n for ws in wb.worksheets:\n print(f'--- SHEET {ws.title!r} rows={ws.max_row} cols={ws.max_column} merged={list(ws.merged_cells.ranges)} ---')\n for row in ws.iter_rows():\n vals=[c.value for c in row]\n if any(v is not None for v in vals):\n… 823 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.1 seconds Output: ===== approved_material_source_list.xlsx ===== --- SHEET 'Source List' rows=13 cols=9 merged=[] --- 1: 'Source ID' | 'Source Name' | 'Source Type' | 'Approved Spec Families' | 'Melt Country' | 'Origin Qualifying Status' | 'Approval Status' | 'Approval Expiry' | 'Note' 2: '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' 3: '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)' 4: 'SRC-D14E8B' | 'Tri-State Metals Distribution' | 'Distributor' | 'AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359' | 'USA' | 'Qualifying (USA)' | 'Approved'
… 36,664 more characters of output in the raw trajectory.
12The packet is compact but deliberately adversarial: several lots and quotes look attractive until certification, source…
The packet is compact but deliberately adversarial: several lots and quotes look attractive until certification, source status, origin, allocation, or yield is applied. I’ve extracted the governing policy and am now reading the program schedule—including priority and customer-origin rules—before assigning any shared compliant stock.
13Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nfrom docx import Document\nfrom pathlib import Path\np=Path('/workspace/data/program_priority_build_schedule.docx')\nd=Document(p)\nprint('PARAGRAPHS')\nfor i,para in enumerate(d.paragraphs,1):\n if para.text.strip():\n print(f'P{i} [{para.style.name}]: {para.text}')\nprint('\\nTABLES')\nfor ti,t in enumerate(d.tables,1):\n print(f'--- TABLE {ti} rows={len(t.rows)} cols={len(t.columns)} ---')\n for ri,row in enumerate(t.rows,1):\n print(f'{ri}: ' + ' | '.join(cell.text.replace('\\n',' /… 320 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.3 seconds Output: Traceback (most recent call last): File "<stdin>", line 8, in <module> AttributeError: 'NoneType' object has no attribute 'name' PARAGRAPHS P1 [Heading 1]: Program Priority & Build Schedule
14Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nfrom docx import Document\np='/workspace/data/program_priority_build_schedule.docx'\nd=Document(p)\nprint('PARAGRAPHS')\nfor i,para in enumerate(d.paragraphs,1):\n if para.text.strip():\n style = para.style.name if para.style is not None else '(none)'\n print(f'P{i} [{style}]: {para.text}')\nprint('\\nTABLES')\nfor ti,t in enumerate(d.tables,1):\n print(f'--- TABLE {ti} rows={len(t.rows)} cols={len(t.columns)} ---')\n for ri,row in enumerate(t.rows,1):\n print(f'{ri}: ' + ' | '.joi… 441 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.3 seconds Output: PARAGRAPHS P1 [Heading 1]: Program Priority & Build Schedule P2 [(none)]: 2026 Q3 Door/Hinge Mechanism Build Wave — Production Control Release PC-2026-0618 P3 [(none)]: Issued by: Production Control & Program Management Office (PMO). Distribution: Sourcing, Materials Planning, Quality, MRB. Status as of 2026-06-19. P4 [(none)]: 1. Purpose P5 [(none)]: 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 [(none)]: 2. Program Prio
… 3,497 more characters of output in the raw trajectory.
15Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nlines=[('A3F91C',593.4,9.4),('8B3F19',176,14.2),('3A9F18',680.8,11.75),('1A6E38',154.2,5.75),('2D7C64',236.1,7.6),('2F8C41',198,9.85),('6D1B84',287,6.9),('9A2E57',389,5.45),('9E4B27',250,8.7),('C1E7B4',250,8.9),('7E2A85',157,11.1),('D9F3B1',250,5.35)]\nfor q,x,p in lines: print(q,x,p,round(x*p,2))\nprint('qty',sum(x for _,x,_ in lines),'cost',round(sum(x*p for _,x,p in lines),2))\nPY","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":2000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: A3F91C 593.4 9.4 5577.96 8B3F19 176 14.2 2499.2 3A9F18 680.8 11.75 7999.4 1A6E38 154.2 5.75 886.65 2D7C64 236.1 7.6 1794.36 2F8C41 198 9.85 1950.3 6D1B84 287 6.9 1980.3 9A2E57 389 5.45 2120.05 9E4B27 250 8.7 2175.0 C1E7B4 250 8.9 2225.0 7E2A85 157 11.1 1742.7 D9F3B1 250 5.35 1337.5 qty 3621.5 cost 32288.42
16Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nvals=[5577.96,2499.2,7999.4,1520,1950.3,2120.05,2225,1337.5]\nprint(sum(vals))\nprint(32288.42-sum(vals))\nPY","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":1000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: 25229.409999999996 7059.010000000002
17Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"command -v libreoffice || true\ncommand -v soffice || true\ncommand -v node || true\nnode -e \"try{console.log(require.resolve('docx'))}catch(e){console.log('docx module not found')}\"\nls -la /root/.agents/skills/xlsx/scripts 2>/dev/null || true\nls -la /root/.agents/skills/docx/scripts/office 2>/dev/null || true","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":5000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: /usr/bin/libreoffice /usr/bin/soffice /root/.nvm/versions/node/v22.23.2/bin/node docx module not found total 20 drwxr-xr-x 3 root root 4096 Aug 20 23:54 . drwxr-xr-x 3 root root 4096 Aug 20 23:54 .. drwxr-xr-x 5 root root 4096 Aug 20 23:54 office -rwxr-xr-x 1 root root 5782 Aug 20 23:54 recalc.py total 44 drwxr-xr-x 5 root root 4096 Aug 20 23:54 . drwxr-xr-x 4 root root 4096 Aug 20 23:54 .. drwxr-xr-x 2 root root 4096 Aug 20 23:54 helpers -rwxr-xr-x 1 root root 4991 Aug 20 23:54 pack.py drwxr-xr-x 6 root root 4096 Aug 20 23:54 schemas -rw-r--r-- 1 root root 5301 Aug 20 23:54 soffice.py -rwxr-xr-x 1 root root 4052 Aug 20 23:54 unpack.py -rwxr-xr-x 1 root root 3668 Aug 20 23:54 validate.py drwxr-xr-x 2 root root 4096 Aug 20 23:54 validators
18Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nfor s in ['AMS-QQ-A-250/','AMS-QQ-A-200/']:\n print(s,len(s))\nPY","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":1000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: AMS-QQ-A-250/ 13 AMS-QQ-A-200/ 13
19Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nvals=[736,592.8,979.4,214.6,212.5,664,653.6,588,437.4]\nprint(sum(vals))\nPY","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":1000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: 5078.299999999999
20exec1
Tool execution only — no assistant text
execconst r = await tools.update_plan({explanation:"All six packet sources are extracted. The governing rules require exact alloy/spec/condition/form, 3.1/3.2 certification, full traceability, no holds, current approved-source status, program-specific origin compliance, yield-adjusted inventory, and priority-first allocation; no substitutions are invoked.","plan":[{"step":"Inspect source packet and read spreadsheet/document skill instructions","status":"completed"},{"step":"Extract and reconcile demand, inventory, approvals, quotes, substitution rules, and priorities","s
Arguments
const r = await tools.update_plan({explanation:"All six packet sources are extracted. The governing rules require exact alloy/spec/condition/form, 3.1/3.2 certification, full traceability, no holds, current approved-source status, program-specific origin compliance, yield-adjusted inventory, and priority-first allocation; no substitutions are invoked.","plan":[{"step":"Inspect source packet and read spreadsheet/document skill instructions","status":"completed"},{"step":"Extract and reconcile demand, inventory, approvals, quotes, substitution rules, and priorities","s… 209 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}21userenvironment context · 2026-08-21 Etc/UTC /workspace
environment context
- current date
- 2026-08-21
- timezone
- Etc/UTC
- root
- /workspace
22The reconciliation is now complete on the packet’s stated 19–20 June 2026 review basis. The compliant plan covers all 26…
The reconciliation is now complete on the packet’s stated 19–20 June 2026 review basis. The compliant plan covers all 26 requirements, but only by preserving priority-first inventory allocations and using 12 quote lines; several physically available lots are excluded for origin, certification, traceability, hold, or source-status failures. I’m building the workbook so each decision traces back to a lot/quote and recalculates from formulas.
23exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Add File: build_material_workbook.py\n+from __future__ import annotations\n+\n+from collections import defaultdict\n+from datetime import date, datetime\n+from pathlib import Path\n+\n+from docx import Document\n+from openpyxl import Workbook, load_workbook\n+from openpyxl.comments import Comment\n+from openpyxl.formatting.rule import CellIsRule, FormulaRule\n+from openpyxl.styles import Alignment, Border, Font, PatternFill, Side\n+from openpyxl.utils import get_column_letter\n+\n+\n+ROOT = Path(\"/workspace\")\n+DATA = ROOT /
Arguments
const patch = "*** Begin Patch\n*** Add File: build_material_workbook.py\n+from __future__ import annotations\n+\n+from collections import defaultdict\n+from datetime import date, datetime\n+from pathlib import Path\n+\n+from docx import Document\n+from openpyxl import Workbook, load_workbook\n+from openpyxl.comments import Comment\n+from openpyxl.formatting.rule import CellIsRule, FormulaRule\n+from openpyxl.styles import Alignment, Border, Font, PatternFill, Side\n+from openpyxl.utils import get_column_letter\n+\n+\n+ROOT = Path(\"/workspace\")\n+DATA = ROOT /
… 73,519 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: {}24Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python build_material_workbook.py","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":10000}); text(r.output); if (r.exit_code) text(`EXIT ${r.exit_code}`);Output
Script completed Wall time 3.3 seconds Output: /workspace/output/material_sourcing_analysis_workbook.xlsx {'requirements': 26, 'inventory_applied': 5857.25, 'purchase_applied': 3102.75, 'selected_quotes': 12, 'protect_all_order_qty': 3621.4999999999995, 'protect_all_cost': 32288.42, 'firm_baseline_cost': 25229.41, 'tentative_increment_cost': 7059.01}25Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python /root/.agents/skills/xlsx/scripts/recalc.py output/material_sourcing_analysis_workbook.xlsx 60","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":20000}); text(r.output); if (r.exit_code) text(`EXIT ${r.exit_code}`);Output
Script completed Wall time 7.1 seconds Output: status: success total_errors: 0 error_summary: {} total_formulas: 473326Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nfrom openpyxl import load_workbook\np='output/material_sourcing_analysis_workbook.xlsx'\nwb=load_workbook(p,data_only=True)\nprint('Sheets:',wb.sheetnames)\nws=wb['Requirement Plan']\nprint('Requirement rows',ws.max_row)\nfor r in range(5,31):\n print(ws.cell(r,1).value, ws.cell(r,12).value, ws.cell(r,13).value, ws.cell(r,15).value, ws.cell(r,16).value, ws.cell(r,17).value)\nprint('shortfalls',sum((ws.cell(r,15).value or 0) for r in range(5,31)))\nwa=wb['Allocation Detail']\nprint('allocation failures',[wa.cell(… 1,145 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.6 seconds Output: Sheets: ['Executive Summary', 'Demand Source', 'Inventory Source', 'Quote Source', 'AMSL Source', 'Program Source', 'Policy Rules', 'Inventory Usability', 'Quote Feasibility', 'Allocation Detail', 'PO Plan', 'Requirement Plan', 'Risks & Escalations', 'Alternatives'] Requirement rows 30 REQ-H4A2 516.6 325.4 0 Covered — Inventory + PO 3058.76 REQ-K9P1 615 0 0 Covered — Inventory 0 REQ-C9T1 0 176 0 Covered — Inventory + PO 2499.2 REQ-X5M3 394 0 0 Covered — Inventory 0 REQ-T2C7 106.2 323.8 0 Covered — Inventory + PO 3804.65 REQ-B6N3 0 268 0 Covered — Inventory + PO 2519.2 REQ-F6B8 233 0 0 Covered — Inventory 0 REQ-L8Q4 0 287 0 Covered — PMO gate 1980.3 REQ-M1X8 512 0 0 Covered — Inventory 0 REQ-D7R4 323.9 23.1 0 Covered — Inventory + PO 175.56 REQ-W3F9 0 198 0 Covered — Inventory + PO 1950.3 REQ-R7W2 412 0 0 Covered — Inventory 0 REQ-G2J9 4.8 154.2 0 Covered
… 1,450 more characters of output in the raw trajectory.
27The workbook now recalculates cleanly with 4,733 formulas and zero formula errors. It confirms 5,857.25 usable lb from c…
The workbook now recalculates cleanly with 4,733 formulas and zero formula errors. It confirms 5,857.25 usable lb from compliant inventory, 3,102.75 lb applied from purchases, no residual mathematical shortfall, and $32,288.42 to protect all firm and tentative lines; $7,059.01 of that spend is gated by tentative demand. I’m moving to the leadership memo and will carry forward the quote-expiry and two-day Sable timing escalations explicitly.
28exec1
Tool execution only — no assistant text
execconst r = await tools.update_plan({explanation:"The packet-basis allocation is reconciled and asserted: every requirement is exactly covered, every selected lot/quote passes the documented rules, no lot/quote capacity is exceeded, and priority-first allocation is preserved.","plan":[{"step":"Inspect source packet and read spreadsheet/document skill instructions","status":"completed"},{"step":"Extract and reconcile demand, inventory, approvals, quotes, substitution rules, and priorities","status":"completed"},{"step":"Build and validate the sourcing analysis wor
Arguments
const r = await tools.update_plan({explanation:"The packet-basis allocation is reconciled and asserted: every requirement is exactly covered, every selected lot/quote passes the documented rules, no lot/quote capacity is exceeded, and priority-first allocation is preserved.","plan":[{"step":"Inspect source packet and read spreadsheet/document skill instructions","status":"completed"},{"step":"Extract and reconcile demand, inventory, approvals, quotes, substitution rules, and priorities","status":"completed"},{"step":"Build and validate the sourcing analysis wor… 394 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 4.0 seconds Output: added 22 packages in 4s 1 package is looking for funding run `npm fund` for details
29exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Add File: build_material_memo.js\n+const fs = require(\"fs\");\n+const {\n+ AlignmentType,\n+ BorderStyle,\n+ Document,\n+ Footer,\n+ Header,\n+ HeadingLevel,\n+ LevelFormat,\n+ PageNumber,\n+ Packer,\n+ Paragraph,\n+ ShadingType,\n+ TabStopPosition,\n+ TabStopType,\n+ Table,\n+ TableCell,\n+ TableLayoutType,\n+ TableRow,\n+ TextRun,\n+ VerticalAlign,\n+ WidthType,\n+} = require(\"/tmp/material-docx/node_modules/docx\");\n+\n+const OUTPUT = \"/workspace/output/material_sourcing_recommendation
Arguments
const patch = "*** Begin Patch\n*** Add File: build_material_memo.js\n+const fs = require(\"fs\");\n+const {\n+ AlignmentType,\n+ BorderStyle,\n+ Document,\n+ Footer,\n+ Header,\n+ HeadingLevel,\n+ LevelFormat,\n+ PageNumber,\n+ Packer,\n+ Paragraph,\n+ ShadingType,\n+ TabStopPosition,\n+ TabStopType,\n+ Table,\n+ TableCell,\n+ TableLayoutType,\n+ TableRow,\n+ TextRun,\n+ VerticalAlign,\n+ WidthType,\n+} = require(\"/tmp/material-docx/node_modules/docx\");\n+\n+const OUTPUT = \"/workspace/output/material_sourcing_recommendation… 33,315 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 build_material_memo.js","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":10000}); text(r.output); if (r.exit_code) text(`EXIT ${r.exit_code}`);Output
Script completed Wall time 0.4 seconds Output: /workspace/output/material_sourcing_recommendation_memo.docx
31Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python /root/.agents/skills/docx/scripts/office/validate.py output/material_sourcing_recommendation_memo.docx","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":10000}); text(r.output); if (r.exit_code) text(`EXIT ${r.exit_code}`);Output
Script completed Wall time 1.9 seconds Output: Paragraphs: 0 → 437 (+437) All validations PASSED!
32Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"rm -f /tmp/material_sourcing_recommendation_memo.pdf\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir /tmp output/material_sourcing_recommendation_memo.docx\npdfinfo /tmp/material_sourcing_recommendation_memo.pdf | sed -n '1,30p'\npdftotext -layout /tmp/material_sourcing_recommendation_memo.pdf /tmp/material_sourcing_recommendation_memo.txt\nwc -l /tmp/material_sourcing_recommendation_memo.txt\nsed -n '1,220p' /tmp/material_sourcing_recommendation_memo.txt","workdir":"/workspace","yie… 114 more characters of arguments in the raw trajectory.
Output
Script failed Wall time 0.0 seconds Output: Script error: exec_command failed for `/bin/bash -lc "rm -f /tmp/material_sourcing_recommendation_memo.pdf python /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir /tmp output/material_sourcing_recommendation_memo.docx pdfinfo /tmp/material_sourcing_recommendation_memo.pdf | sed -n '1,30p' pdftotext -layout /tmp/material_sourcing_recommendation_memo.pdf /tmp/material_sourcing_recommendation_memo.txt wc -l /tmp/material_sourcing_recommendation_memo.txt sed -n '1,220p' /tmp/material_sourcing_recommendation_memo.txt"`: CreateProcess { message: "Rejected(\"`/bin/bash -lc \\\"rm -f /tmp/material_sourcing_recommendation_memo.pdf\\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir /tmp output/material_sourcing_recommendation_memo.docx\\npdfinfo /tmp/material_sourcing_recommenda… 363 more characters of output in the raw trajectory.
33Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"review_dir=$(mktemp -d /tmp/material-memo-review.XXXXXX)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$review_dir\" output/material_sourcing_recommendation_memo.docx\npdfinfo \"$review_dir/material_sourcing_recommendation_memo.pdf\" | sed -n '1,30p'\npdftotext -layout \"$review_dir/material_sourcing_recommendation_memo.pdf\" \"$review_dir/material_sourcing_recommendation_memo.txt\"\nwc -l \"$review_dir/material_sourcing_recommendation_memo.txt\"\nsed -n '1,240p' \… 247 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.7 seconds Output: Warning: failed to launch javaldx - java may not function correctly convert /workspace/output/material_sourcing_recommendation_memo.docx as a Writer document -> /tmp/material-memo-review.apdivY/material_sourcing_recommendation_memo.pdf using filter : writer_pdf_Export Author: Un-named Creator: Writer Producer: LibreOffice 25.2.3.2 (X86_64) / LibreOffice Community CreationDate: Fri Aug 21 00:08:00 2026 UTC Custom Metadata: no Metadata Stream: yes Tagged: yes UserProperties: no Suspects: no Form: none JavaScript: no Pages: 6 Encrypted: no Page size: 612 x 792 pts (letter) Page rot: 0 File size: 231587 bytes Optimized: no PDF version: 1.7 365 /tmp/material-memo-review.apdivY/material_sourcing_recommendation_memo.txt MATERIAL SOURCING REVIEW
… 19,295 more characters of output in the raw trajectory.
34Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"pdftoppm -png -r 120 /tmp/material-memo-review.apdivY/material_sourcing_recommendation_memo.pdf /tmp/material-memo-review.apdivY/page >/dev/null 2>&1\nls -lh /tmp/material-memo-review.apdivY/page-*.png","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":3000}); text(r.output);Output
Script completed Wall time 2.2 seconds Output: -rw-r--r-- 1 root root 287K Aug 21 00:08 /tmp/material-memo-review.apdivY/page-1.png -rw-r--r-- 1 root root 135K Aug 21 00:08 /tmp/material-memo-review.apdivY/page-2.png -rw-r--r-- 1 root root 327K Aug 21 00:08 /tmp/material-memo-review.apdivY/page-3.png -rw-r--r-- 1 root root 276K Aug 21 00:08 /tmp/material-memo-review.apdivY/page-4.png -rw-r--r-- 1 root root 232K Aug 21 00:08 /tmp/material-memo-review.apdivY/page-5.png -rw-r--r-- 1 root root 290K Aug 21 00:08 /tmp/material-memo-review.apdivY/page-6.png
35exec1
Tool execution only — no assistant text
execconst imgs = [1,3,4,5,6]; for (const n of imgs) { const r = await tools.view_image({path:`/tmp/material-memo-review.apdivY/page-${n}.png`,detail:"original"}); text(`PAGE ${n}`); image(r.image_url); }
Arguments
const imgs = [1,3,4,5,6]; for (const n of imgs) { const r = await tools.view_image({path:`/tmp/material-memo-review.apdivY/page-${n}.png`,detail:"original"}); text(`PAGE ${n}`); image(r.image_url); }Output
Script completed Wall time 0.1 seconds Output: PAGE 1
… 1,925,238 more characters of output in the raw trajectory.
36exec1
Tool execution only — no assistant text
execconst r = await tools.view_image({path:"/tmp/material-memo-review.apdivY/page-2.png",detail:"original"}); image(r.image_url);
Arguments
const r = await tools.view_image({path:"/tmp/material-memo-review.apdivY/page-2.png",detail:"original"}); image(r.image_url);Output
Script completed Wall time 0.0 seconds Output:
… 182,652 more characters of output in the raw trajectory.
37exec1
Tool execution only — no assistant text
execconst patch = "*** Begin Patch\n*** Update File: build_material_memo.js\n@@\n- [500, 1400, 1150, 1150, 1150, 1250, 3624],\n+ [650, 1350, 1150, 1150, 1150, 1250, 3524],\n@@\n- [700, 1700, 4824, 1800, 1200],\n+ [900, 1650, 4674, 1800, 1200],\n*** End Patch"; text(await tools.apply_patch(patch));
Arguments
const patch = "*** Begin Patch\n*** Update File: build_material_memo.js\n@@\n- [500, 1400, 1150, 1150, 1150, 1250, 3624],\n+ [650, 1350, 1150, 1150, 1150, 1250, 3524],\n@@\n- [700, 1700, 4824, 1800, 1200],\n+ [900, 1650, 4674, 1800, 1200],\n*** End Patch"; text(await tools.apply_patch(patch));
Output
Script completed Wall time 0.0 seconds Output: {}38Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"node build_material_memo.js\npython /root/.agents/skills/docx/scripts/office/validate.py output/material_sourcing_recommendation_memo.docx","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":10000}); text(r.output); if (r.exit_code) text(`EXIT ${r.exit_code}`);Output
Script completed Wall time 2.1 seconds Output: /workspace/output/material_sourcing_recommendation_memo.docx Paragraphs: 0 → 437 (+437) All validations PASSED!
39Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"book_review_dir=$(mktemp -d /tmp/material-book-review.XXXXXX)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$book_review_dir\" output/material_sourcing_analysis_workbook.xlsx\npdfinfo \"$book_review_dir/material_sourcing_analysis_workbook.pdf\" | sed -n '1,30p'\npdftoppm -f 1 -l 1 -png -r 120 \"$book_review_dir/material_sourcing_analysis_workbook.pdf\" \"$book_review_dir/page\" >/dev/null 2>&1\nls -lh \"$book_review_dir\"\nprintf '%s\\n' \"$book_review_dir\""… 146 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 3.1 seconds Output: Warning: failed to launch javaldx - java may not function correctly convert /workspace/output/material_sourcing_analysis_workbook.xlsx as a Calc document -> /tmp/material-book-review.fgurEI/material_sourcing_analysis_workbook.pdf using filter : calc_pdf_Export Title: Material Sourcing Analysis Workbook Subject: 2026 Q3 certified door/hinge material sourcing review Author: Codex Creator: Calc Producer: LibreOffice 25.2.3.2 (X86_64) / LibreOffice Community CreationDate: Fri Aug 21 00:08:37 2026 UTC Custom Metadata: no Metadata Stream: yes Tagged: yes UserProperties: no Suspects: no Form: none JavaScript: no Pages: 14 Encrypted: no Page size: 792 x 612 pts (letter) Page rot: 0 File size: 1924250 bytes Optimized: no PDF version: 1.
… 188 more characters of output in the raw trajectory.
40exec1
Tool execution only — no assistant text
execconst r = await tools.view_image({path:"/tmp/material-book-review.fgurEI/page-01.png",detail:"original"}); image(r.image_url);
Arguments
const r = await tools.view_image({path:"/tmp/material-book-review.fgurEI/page-01.png",detail:"original"}); image(r.image_url);Output
Script completed Wall time 0.0 seconds Output:
… 240,040 more characters of output in the raw trajectory.
41Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"pdftoppm -f 10 -l 13 -png -r 120 /tmp/material-book-review.fgurEI/material_sourcing_analysis_workbook.pdf /tmp/material-book-review.fgurEI/detail >/dev/null 2>&1\nls -lh /tmp/material-book-review.fgurEI/detail-*.png","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":3000}); text(r.output);Output
Script completed Wall time 0.7 seconds Output: -rw-r--r-- 1 root root 153K Aug 21 00:08 /tmp/material-book-review.fgurEI/detail-10.png -rw-r--r-- 1 root root 62K Aug 21 00:08 /tmp/material-book-review.fgurEI/detail-11.png -rw-r--r-- 1 root root 101K Aug 21 00:08 /tmp/material-book-review.fgurEI/detail-12.png -rw-r--r-- 1 root root 75K Aug 21 00:08 /tmp/material-book-review.fgurEI/detail-13.png
42exec1
Tool execution only — no assistant text
execfor (const n of [10,11,12,13]) { const r=await tools.view_image({path:`/tmp/material-book-review.fgurEI/detail-${n}.png`,detail:"original"}); text(`PAGE ${n}`); image(r.image_url); }
Arguments
for (const n of [10,11,12,13]) { const r=await tools.view_image({path:`/tmp/material-book-review.fgurEI/detail-${n}.png`,detail:"original"}); text(`PAGE ${n}`); image(r.image_url); }Output
Script completed Wall time 0.1 seconds Output: PAGE 10
… 531,414 more characters of output in the raw trajectory.
43Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"memo_review2=$(mktemp -d /tmp/material-memo-final.XXXXXX)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$memo_review2\" output/material_sourcing_recommendation_memo.docx >/dev/null\npdfinfo \"$memo_review2/material_sourcing_recommendation_memo.pdf\" | rg '^(Pages|Page size|File size)'\npdftotext \"$memo_review2/material_sourcing_recommendation_memo.pdf\" - | rg -n 'Ran k|AMBE R|#REF!|#VALUE!|#NAME\\?|#DIV/0!' || true\nprintf '%s\\n' \"$memo_review2\"","workdir":"… 131 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.3 seconds Output: Warning: failed to launch javaldx - java may not function correctly Pages: 6 Page size: 612 x 792 pts (letter) File size: 231586 bytes /tmp/material-memo-final.5UzcDL
44Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"ls -lh output\nunzip -t output/material_sourcing_recommendation_memo.docx | tail -n 2\nunzip -t output/material_sourcing_analysis_workbook.xlsx | tail -n 2\npython - <<'PY'\nfrom openpyxl import load_workbook\np='output/material_sourcing_analysis_workbook.xlsx'\nwbv=load_workbook(p,data_only=True,read_only=True)\nchecks={\n 'requirements': wbv['Executive Summary']['B5'].value,\n 'net_demand': wbv['Executive Summary']['E5'].value,\n 'shortfall_count': wbv['Executive Summary']['H5'].value,\n 'inventory_applied': wbv['Executive Summar… 834 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.0 seconds Output: total 148K -rw-r--r-- 1 root root 121K Aug 21 00:04 material_sourcing_analysis_workbook.xlsx -rw-r--r-- 1 root root 23K Aug 21 00:08 material_sourcing_recommendation_memo.docx /bin/bash: line 2: unzip: command not found /bin/bash: line 3: unzip: command not found {'requirements': 26, 'net_demand': 8960, 'shortfall_count': 0, 'inventory_applied': 5857.25, 'purchase_applied': 3102.75, 'protect_all_po_qty': 3621.5, 'excess_qty': 518.75, 'protect_all_cost': 32288.42, 'firm_baseline_cost': 25229.41, 'tentative_increment_cost': 7059.01}45Both deliverables are complete and cross-checked. The workbook has zero formula errors and no negative lot/quote capacit…
Both deliverables are complete and cross-checked. The workbook has zero formula errors and no negative lot/quote capacity; the memo passes document validation and renders cleanly as a six-page US Letter document. The final recommendation is explicitly packet-dated so no expired quote, later inventory change, or undocumented status update is silently assumed.
46Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nfrom zipfile import ZipFile\nfor p in ['output/material_sourcing_analysis_workbook.xlsx','output/material_sourcing_recommendation_memo.docx']:\n with ZipFile(p) as z:\n bad=z.testzip()\n print(p, 'ZIP_OK' if bad is None else f'BAD:{bad}', len(z.namelist()))\nPY","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":2000}); const p = await tools.update_plan({explanation:"Both requested files are generated, formula/document validated, rendered for visual inspection, and reconciled to… 518 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.2 seconds Output: output/material_sourcing_analysis_workbook.xlsx ZIP_OK 58 output/material_sourcing_recommendation_memo.docx ZIP_OK 24 {}47Completed both deliverables: - [Recommendation memo](/workspace/output/material_sourcing_recommendation_memo.docx) - [An…
Completed both deliverables:
- Recommendation memo
- Analysis workbook
Packet-basis plan covers all 26 requirements with 5,857.25 lb compliant inventory and 12 selected quote lines. Protect-all PO spend is $32,288.42; the key escalation is Sable’s two-day receipt margin. Quote validity must be revalidated after listed expiries.
4 failure modes across 4 verifier failures
1Allocation or Selection Plan IncorrectView on Failure Modes ↗Reasoning and Computation1 failure
Description
After eligibility is established, does the artifact assign a scarce resource, facing, shelf position, assortment item, or appointment slot to the wrong recipient or produce the wrong required final set?
Failure evidence · per affected verifier
A contested inventory lot usable by two requirements is given to the lower-priority program while the higher-priority one is pushed to a new purchase.
2Decision Reconciliation or Conclusion WrongView on Failure Modes ↗Reasoning and Computation1 failure
Description
Do detailed rows support one result while another table, summary, recommendation, or action classification asserts a materially conflicting result?
Failure evidence · per affected verifier
The workbook states two or more conflicting headline committed-buy totals even though each one's own detail rows reconcile internally.
3Decision 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.
4Escalation 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.