task_111Manufacturing
All trialsGPT-5.6 SolcodexTrial 01
Trial reward
GPT-5.6 SolFail
Trial 01 — 1st of 4 by reward score. This model averages 74.5% across 4 trials on this task.
- 14/15Core verifiers passed
- 15/16All verifiers passed
- 1Core failed
- 51Turns
- 38Tool calls
- $5.16Cost
- 33.2mTime
- 79kOutput tokens
Missed 1 of 15 core — traceability.
core (15)
usable_quantityLLMPass
Why it mattersCoverage must be assessed on usable yield-adjusted quantity net of allocations, and the original attempt's central risk is treating gross or physically-present pounds as usable.
How to passChecks that the analysis workbook reports usable on-hand quantity using the formula (On Hand - Allocated) x Yield Factor for inventory lots rather than gross on-hand pounds.
Reads
country_of_originLLMPass
Why it mattersCountry-of-origin restrictions are binding contractual constraints, and the cheapest/fastest options for several critical lines are non-qualifying-origin material that must not be selected.
How to passChecks that material melted in China or Russia is excluded for the DFARS programs (Raven, Sable) and the CUST-EU programs (Meridian, Tundra) regardless of price or certificate quality.
Reads
cert_traceabilityLLMPass
Why it mattersEN 10204 3.1/3.2 certification and full traceability are minimum eligibility gates, and the original attempt risks accepting C-of-C or non-traceable material that is physically attractive.
How to passChecks that Certificate-of-Conformance-only lots/quotes and partial-traceability lots are excluded from certified-production coverage.
Reads
source_hold_statusLLMPass
Why it mattersApproved-source status and hold status are hard eligibility gates, and otherwise-attractive USA-origin material from these sources must not be planned against requirements.
How to passChecks that sources in Suspended, Conditional, or Not Approved status, and material under an open quality/MRB or receiving-inspection hold, are excluded from new commitments.
Reads
substitution_policyLLMPass
Why it mattersThe substitution policy is exhaustive and prohibits interchange (e.g., T651 vs T7351, /11 vs /12, bar vs plate vs extrusion), so a model must not silently treat near-match material as covering a callout.
How to passChecks that no alloy, temper/condition, product-form, or specification sub-spec substitution is applied beyond same-spec oversize/remnant cutdown.
Reads
allocation_priorityLLMPass
Why it mattersProgram-priority allocation is an explicit contention rule, and getting it wrong misassigns scarce compliant stock between competing programs.
How to passChecks that contested inventory lots usable by more than one requirement are allocated to the higher-priority (lower rank number) program first, with lower-priority shortfalls flowing to new purchase.
Reads
lead_time_feasibilityLLMPass
Why it mattersLead-time feasibility is an explicit gate, and the original attempt risks counting a compliant quote that docks on or after need-by as resolving a requirement on schedule.
How to passChecks that a supplier quote is treated as feasible only when its quoted dock/receipt date precedes the requirement need-by date.
Reads
requirement_coverageLLMPass
Why it mattersRequirement-level coverage classification is the core analytical output the task asks for and must be complete across all demand lines.
How to passChecks that the workbook classifies each of the 26 requirements into a coverage disposition (covered from compliant inventory, partial inventory plus buy, or full new purchase) at the requirement-ID level.
Reads
traceabilityLLMFail
Why it mattersRequirement-level traceability is an explicit auditability obligation and is exactly where a weaker solution omits the why-rejected evidence chain.
How to passChecks that for each at-risk requirement the workbook records the selected inventory lot(s) with usable quantity, the rejected lots with reasons, the selected quote, the rejected quote alternatives with reasons, the residual after inventory, and the resulting purchase quantity and cost.
Reads
Failure mode Decision Audit Trail Fragmented or Incomplete
Why it failedSelected lots, rejected alternatives, selected and rejected quotes, and purchase cost for an at-risk requirement each live on a different sheet instead of one joined view.
Justification
The workbook does not present a single per-requirement view that ties together selected lots, rejected matching lots with reasons, selected quote, rejected/alternative quotes with reasons, residual-after-inventory, and purchase quantity/cost. For example, 'Requirement Coverage' shows selected sources and cost (e.g., REQ-T2C7 lists LOT-6B2F39, QTE-3A9F18, 106.2 lb inventory, 323.8 lb purchase, $3804.65), but the rejected lots and quote alternatives with reasons for that same requirement appear only on separate 'Inventory-Req Tests' and 'Quote-Req Tests' sheets. Since the rejected-lot/rejected-quote evidence is not in one requirement-level audit view, the rubric is not fully satisfied.
residual_vs_moqLLMPass
Why it mattersConflating need with MOQ-inflated buy quantity was a defect in the earlier attempt and obscures both true demand and committed spend.
How to passChecks that requirement residual quantity is reported separately from the minimum-order-quantity-adjusted purchase quantity, with the excess identified.
Reads
cost_reconciliationLLMPass
Why it mattersA reconciled, self-consistent committed total was an explicit fix from the earlier attempt, where the memo and PO tab disagreed on the headline figure and shared lines risked double-charging.
How to passChecks that the workbook presents a single authoritative total committed new-buy cost with no conflicting totals and a cost chain that reconciles, with shared quote lines not double-counted.
Reads
escalation_languageLLMPass
Why it mattersClarifying escalation language so that 'every requirement has a feasible path' is not conflated with quality holds awaiting action was an explicit obligation from the earlier revision.
How to passChecks that the memo states there is no hard sourcing dead-end while separately listing quality/MRB/process escalations.
Reads
memo_recommendationLLMPass
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
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 - Executive Summary | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Packet-basis recommendation for the 2026 Q3 door/hinge mechanism build wave. All quantities are usable pounds unless labeled as PO/order quantity. | |||||||||
| Review as-of | 46193 | Decision posture | Compliance-first; exact callout; fixed allocations/yield; program priority | ||||||
| Coverage & Cost Metrics | Leadership Recommendation | ||||||||
| Total requirements | 26 | Residual shortage after plan (lb) | 0 | Release the eight quote lines supporting firm demand (including shared firm/tentative buys) before their stated expiries. | |||||
| Firm requirements | 20 | Compliant inventory applied (lb) | 5857.25 | Obtain immediate PMO/planner direction on Sable REQ-L8Q4: its only compliant quote has a 2-day dock-to-need margin. | |||||
| Tentative requirements | 6 | Purchase material applied (lb) | 3102.75 | Condition the three remaining tentative-only buys on planner confirmation; do not count them as secured until authorized. | |||||
| Inventory-only requirements | 11 | Recommended order quantity (lb) | 3621.5 | Maintain all certification, traceability, hold, source-status, and origin exclusions; no waiver or expedite is assumed. | |||||
| Purchase-dependent requirements | 15 | MOQ-driven purchase surplus (lb) | 518.75 | Approve MOQ overbuy explicitly: 518.75 lb is purchased above applied demand, driven by three sub-MOQ residuals. | |||||
| Coverable after recommended actions | 26 | Recommended PO cost | 32288.42 | ||||||
| Program Coverage Summary | |||||||||
| Program | Priority | Build Start | Restriction | Requirements | Net Demand (lb) | Inventory Applied (lb) | Purchase Applied (lb) | Residual (lb) | Program Status |
| PRG-RAVEN | 1 | 46251 | DFARS | 4 | 2027 | 1525.6 | 501.4 | 0 | COVERABLE - PO action required |
| PRG-SABLE | 2 | 46265 | DFARS | 4 | 1218 | 339.2 | 878.8 | 0 | COVERABLE - PO action required |
| PRG-MERIDIAN | 3 | 46293 | CUST-EU | 5 | 1628 | 1252.7 | 375.3 | 0 | COVERABLE - PO action required |
| PRG-TUNDRA | 4 | 46314 | CUST-EU | 4 | 1309 | 739 | 570 | 0 | COVERABLE - PO action required |
| PRG-HALCYON | 5 | 46335 | None | 4 | 1660 | 1201.5 | 458.5 | 0 | COVERABLE - PO action required |
| PRG-CALDER | 6 | 46349 | None | 5 | 1118 | 799.25 | 318.75 | 0 | COVERABLE - PO action required |
| Selected Quote Action Timeline | |||||||||
| Quote ID | Quote Expiry | Action Tier | Recommended Order Qty (lb) | PO Cost | Earliest Need-By | Schedule Margin | Plan Check | ||
| QTE-D9F3B1 | 46217 | Immediate - firm | 250 | 1337.5 | 46339 | 113 | PASS | ||
| QTE-8B3F19 | 46217 | Immediate - firm | 176 | 2499.2 | 46237 | 8 | PASS | ||
| QTE-A3F91C | 46218 | Immediate - firm | 593.4 | 5577.96 | 46244 | 11 | PASS | ||
| QTE-2D7C64 | 46222 | Immediate - firm/shared | 236.1 | 1794.36 | 46283 | 47 | PASS | ||
| QTE-3A9F18 | 46223 | Immediate - firm | 680.8 | 7999.4 | 46258 | 18 | PASS | ||
| QTE-9E4B27 | 46223 | Conditional - tentative | 250 | 2175 | 46330 | 92 | PASS | ||
| QTE-C1E7B4 | 46225 | Immediate - firm | 250 | 2225 | 46340 | 103 | PASS | ||
| QTE-7E2A85 | 46226 | Conditional - tentative | 157 | 1742.7 | 46344 | 95 | PASS | ||
| QTE-2F8C41 | 46226 | Immediate - firm | 198 | 1950.3 | 46279 | 36 | PASS | ||
| QTE-1A6E38 | 46228 | Conditional - tentative | 154.2 | 886.65 | 46281 | 35 | PASS | ||
| QTE-9A2E57 | 46236 | Immediate - firm | 389 | 2120.05 | 46327 | 75 | PASS | ||
| QTE-6D1B84 | 46239 | Priority decision - tentative | 287 | 1980.3 | 46262 | 2 | PASS |
Methodology
| Methodology & Control Basis | ||||
|---|---|---|---|---|
| Decision logic is fixed to the source-packet review snapshot; no current-date, substitution, waiver, expedite, certification correction, or yield assumption has been introduced. | ||||
| Review as-of date | 46193 | |||
| Decision basis | Inventory WMS extract 2026-06-20; MRP/PMO/RFQ/AMSL/policy releases dated 2026-05-15 through 2026-06-20. Quote activity is tested against this fixed cycle date. | |||
| Coverage basis | Inventory counts only after all compliance gates and documented yield; quotes count at ordered/applied quantity with MOQ tracked separately. | |||
| Gate | Pass rule | Authoritative source | Workbook evidence | No-assumption boundary |
| Callout | Alloy, specification, temper/condition, and product form must match exactly; no listed case uses a substitution. | Demand Forecast + ENG-MSP Rev H §1/§4 | Inventory-Req Tests; Quote-Req Tests | No alternate alloy, temper, spec, or form. |
| Certification | 3.1 or 3.2 only; C of C fails. | ENG-MSP Rev H §2 | Inventory Lot Review; Quote-Req Tests | No certificate correction or equivalence. |
| Traceability / hold | Full traceability and no open hold. | ENG-MSP Rev H §2 | Inventory Lot Review | No hold release or traceability repair. |
| Source | Approved status and approved specification family. | AMSL Rev N + ENG-MSP Rev H §3 | Inventory Lot Review; Quote-Req Tests | No conditional/suspended/not-approved commitment. |
| Origin | DFARS rejects non-qualifying origin; CUST-EU rejects China/Russia; None adds no special origin rule. | PMO PC-2026-0618 §3 + ENG-MSP Rev H §3 | Program Rules; pair tests | No customer waiver. |
| Inventory quantity | (On Hand - Allocated) × Yield Factor. | Inventory Snapshot README + ENG-MSP Rev H §5 | Inventory Lot Review | No allocation release or yield uplift. |
| Quote quantity / MOQ | Applied quantity may not exceed quoted quantity; PO quantity is MAX(applied, MOQ). | Quote Matrix README + ENG-MSP Rev H §5 | Purchase Plan | No extra capacity or MOQ exception. |
| Schedule | Receipt must be earlier than need-by; exact margin is shown in days. | ENG-MSP Rev H §6 | Quote-Req Tests; Purchase Plan | No undocumented expedite. |
| Priority | Eligible contested inventory goes to the lower numerical priority first. | PMO PC-2026-0618 §2/§4 | Allocation Detail | No undocumented allocation change. |
Demand Source
| Material Demand Forecast - Source Data | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Unmodified source fields from the attached MRP forecast; hardcoded source values are blue. | ||||||||||||
| 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 | Source Reference |
| 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 | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-K9P1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 4340 | AMS 6415 | Annealed | Bar | 615 | lb | 46239 | Y | Pivot pin bar, HT in house | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-C9T1 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 300M | AMS 6419 | Annealed | Bar | 176 | lb | 46237 | Y | High-strength actuation pin bar | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-X5M3 | PRG-RAVEN | Raven Cargo Door Actuation Hinge | 15-5PH | AMS 5862 | Cond A | Plate | 394 | lb | 46246 | Y | Actuation backing plate | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-T2C7 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 15-5PH | AMS 5862 | Cond A | Plate | 430 | lb | 46258 | Y | Egress latch plate | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-B6N3 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 268 | lb | 46256 | Y | Egress arm gusset | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-F6B8 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 6061 | AMS 4117 | T651 | Bar | 233 | lb | 46260 | Y | Egress mechanism spacer bar | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-L8Q4 | PRG-SABLE | Sable Emergency Egress Hinge Arm | 4340 | AMS 6359 | Norm | Plate | 287 | lb | 46262 | Tentative | Egress strike plate | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-M1X8 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 512 | lb | 46286 | Y | Latch housing plate | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| 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 | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-W3F9 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 15-5PH | AMS 5659 | H1025 | Bar | 198 | lb | 46279 | Y | Latch pawl bar | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-R7W2 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 412 | lb | 46277 | Y | Latch backing plate | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-G2J9 | PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | 6061 | AMS 4117 | T651 | Bar | 159 | lb | 46281 | Tentative | Latch guide spacer bar | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| 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 | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-P2H6 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 17-4PH | AMS 5604 | H1075 | Bar | 284 | lb | 46304 | Y | Stop fitting bar | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-V1D9 | PRG-TUNDRA | Tundra Cargo Door Stop Fitting | 15-5PH | AMS 5862 | Cond A | Plate | 357 | lb | 46301 | Y | Stop fitting mounting plate | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| 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 | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| 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 | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-Z4V2 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 4340 | AMS 6359 | Norm | Plate | 389 | lb | 46327 | Y | Bracket reinforcement plate | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| 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 | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-S6P3 | PRG-HALCYON | Halcyon Service Door Hinge Bracket | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 244 | lb | 46330 | Tentative | Bracket cover plate | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| 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 | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| 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 | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-U4B8 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 17-4PH | AMS 5604 | H1075 | Bar | 162 | lb | 46344 | Tentative | Hatch latch pin bar | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-H7D5 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 4340 | AMS 6415 | Annealed | Bar | 205 | lb | 46339 | Y | Hatch hinge pin bar | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
| REQ-W9A3 | PRG-CALDER | Calder Overwing Hatch Hinge Set | 15-5PH | AMS 5659 | H1025 | Bar | 147 | lb | 46343 | Tentative | Hatch pawl bar | material_demand_forecast.xlsx | Demand Forecast | MRP-2026-0619-R2 |
Inventory Source
| Inventory Lot & Certification Snapshot - Source Data | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Unmodified source fields from the attached WMS/QMS extract; hardcoded source values are blue. | |||||||||||||||||
| 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 | Source Reference |
| 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) | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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) | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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) | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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) | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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) | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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) | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
| 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 | inventory_lot_cert_snapshot.xlsx | Lot Snapshot | WMS-EXP-20260620-0741 |
AMSL Source
| Approved Material Source List - Source Data | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Controlled AMSL Rev N facts used for approval status, specification-family scope, and melt origin. | |||||||||
| Source ID | Source Name | Source Type | Approved Spec Families | Melt Country | Origin Qualifying Status | Approval Status | Approval Expiry | Note | Source Reference |
| 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 | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| SRC-3B7C19 | Ardenne Steelworks SA | Mill | AMS 5862, AMS 5659, AMS 5604 | France | Qualifying (non-US) | Approved | 46387 | PH stainless; qualifying country (FR) | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| 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 | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| SRC-7A6D52 | Hangzhou Precision Alloys Co | Mill | AMS-QQ-A-250, AMS 5659 | China | Non-qualifying | Approved | 46418 | Approved source; non-qualifying origin | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| SRC-C2F9A7 | Yellow River Specialty Steel | Mill | AMS 6359, AMS 6415, AMS 6419 | China | Non-qualifying | Approved | 46326 | Non-qualifying origin | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| SRC-58E1B3 | Brunderman Forge & Bar Inc | Mill | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | USA | Qualifying (USA) | Approved | 46660 | Steel bar/plate | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| 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 | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| SRC-6E3F88 | Pohang Advanced Alloy | Mill | AMS 5604, AMS 5659 | South Korea | Qualifying (non-US) | Approved | 46446 | Qualifying country (KR) | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| SRC-A47C21 | Meridian Metal Service Center | Distributor | AMS-QQ-A-250, AMS-QQ-A-200 | USA | Qualifying (USA) | Suspended | 46173 | Suspended after FOD finding | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| SRC-2D8B96 | Volga Forged Steel OAO | Mill | AMS 5862, AMS 6359 | Russia | Non-qualifying | Not Approved | - | Not on approved list for these programs | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| SRC-E5C913 | Adriatic Aero Alloys d.o.o. | Mill | AMS 5862, AMS 5659, AMS 5604 | Slovenia | Qualifying (non-US) | Approved | 46538 | Qualifying country (SI) | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
| 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 | approved_material_source_list.xlsx | Source List | QE-AMSL Rev N, effective 2026-06-01 |
Quote Source
| Supplier Quote & Lead-Time Matrix - Source Data | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RFQ responses compiled through 2026-06-19; quoted facts are not themselves a usability decision. | |||||||||||||||||
| 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 | Source Reference |
| QTE-8B3F19 | RFQ-1C9E44 | SRC-58E1B3 | 300M | AMS 6419 | Annealed | Bar | 250 | 14.2 | 3550 | 27 | 46229 | 3.1 | USA | 150 | 46217 | Brunderman | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| QTE-1E8C57 | RFQ-9A4F22 | SRC-58E1B3 | 4340 | AMS 6415 | Annealed | Bar | 650 | 5.2 | 3380 | 22 | 46228 | 3.1 | USA | 300 | 46215 | Brunderman | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| QTE-1A6E38 | RFQ-2C7F49 | SRC-9F2A41 | 6061 | AMS 4117 | T651 | Bar | 300 | 5.75 | 1725 | 23 | 46246 | 3.1 | USA | 150 | 46228 | Cascade bar | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| QTE-1F7C93 | RFQ-3E8B27 | SRC-3B7C19 | 17-4PH | AMS 5604 | H1075 | Bar | 300 | 11.4 | 3420 | 26 | 46235 | 3.1 | France | 150 | 46223 | Ardenne | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
| 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 | supplier_quote_leadtime_matrix.xlsx | Quote Matrix | RFQs received 2026-06-12 to 2026-06-19 |
Program Rules
| Program Priority & Contractual Sourcing Rules | |||||||
|---|---|---|---|---|---|---|---|
| Priority and origin rules transcribed from Production Control release PC-2026-0618; these are binding allocation gates. | |||||||
| Program ID | Program / Assembly | Customer | Priority Rank | Build Start | Restriction | Restriction Detail | Source Reference |
| PRG-RAVEN | Raven Cargo Door Actuation Hinge | Lockmar Defense Systems | 1 | 46251 | DFARS | Non-qualifying origin is ineligible; no reliance on China or Russia melt. | program_priority_build_schedule.docx | PC-2026-0618 §§2-4 |
| PRG-SABLE | Sable Emergency Egress Hinge Arm | Lockmar Defense Systems | 2 | 46265 | DFARS | Non-qualifying origin is ineligible; no reliance on China or Russia melt. | program_priority_build_schedule.docx | PC-2026-0618 §§2-4 |
| PRG-MERIDIAN | Meridian Cabin Door Latch Hinge | Aerolux Commercial | 3 | 46293 | CUST-EU | China- and Russia-melt raw material is prohibited. | program_priority_build_schedule.docx | PC-2026-0618 §§2-4 |
| PRG-TUNDRA | Tundra Cargo Door Stop Fitting | Northwind Regional | 4 | 46314 | CUST-EU | China- and Russia-melt raw material is prohibited. | program_priority_build_schedule.docx | PC-2026-0618 §§2-4 |
| PRG-HALCYON | Halcyon Service Door Hinge Bracket | Aerolux Commercial | 5 | 46335 | None | No special origin restriction beyond AMSL, certification, and traceability rules. | program_priority_build_schedule.docx | PC-2026-0618 §§2-4 |
| PRG-CALDER | Calder Overwing Hatch Hinge Set | Northwind Regional | 6 | 46349 | None | No special origin restriction beyond AMSL, certification, and traceability rules. | program_priority_build_schedule.docx | PC-2026-0618 §§2-4 |
Policy Rules
| Engineering Material Substitution Policy - Controlling Rules | ||
|---|---|---|
| Summary of ENG-MSP Rev H. The attached PDF remains authoritative; this sheet captures the gates applied in the analysis. | ||
| Rule Area | Controlling Rule | Source Reference |
| Authority | Only exact callouts or substitutions expressly listed in ENG-MSP Rev H may be used; undocumented substitutions require controlled deviation/MRB/customer acceptance. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Certification | Type 3.1 (or AMS-equivalent specific test results) is the minimum; Type 3.2 is acceptable; C of C alone is not acceptable. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Traceability | Heat/cast identity must be Full end-to-end; less than Full is ineligible. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Quality status | Material under any open quality hold or MRB tag is ineligible until cleared. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Approved source | Source must be Approved for the applicable specification family; Conditional, Suspended, and Not Approved are ineligible for new commitments. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Country of origin | DFARS programs reject non-qualifying origin; CUST-EU programs reject China and Russia melt; None programs retain standard AMSL rules. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Temper | 7075-T651 and 7075-T7351 are not interchangeable. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Product form | Plate, bar, and extrusion are not interchangeable. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Steel callouts | AMS 6415 bar and AMS 6359 plate are distinct; 300M AMS 6419 may not substitute for 4340. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Yield | Usable on-hand quantity = (On Hand - Allocated) × documented Yield Factor. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Quoted quantity | Quoted quantity is assessed against net usable demand, subject to MOQ; partial coverage leaves a documented residual. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Schedule | Quoted dock must precede need-by with margin; on/after need-by does not resolve schedule. No undocumented expedite is assumed. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
| Escalation | Any requirement lacking eligible inventory or a feasible compliant quote must go to MRB and the program office; contested inventory follows program priority. | engineering_material_substitution_policy.pdf | ENG-MSP Rev H |
Inventory Lot Review
| Inventory Lot Usability Review | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Base compliance excludes program-specific country rules; see Inventory-Req Tests for the final requirement-level origin decision. Yield-adjusted quantity is never counted when a compliance gate fails. | |||||||||||||||||||||||
| Lot ID | Alloy | Material Spec | Spec Family | Temper / Condition | Product Form | Source ID | On Hand Qty (lb) | Allocated Qty (lb) | Free Qty (lb) | Yield Factor | Yield-Adjusted Usable Qty (lb) | Hold Status | Cert Type | Traceability | Source Approval | Approved Spec Families | Origin Status | Melt Country | Approval Expiry | Base Compliance | Base Exclusion Reason | Listed Requirement Use | Recommendation |
| LOT-C7A340 | 15-5PH | AMS 5659 | AMS 5659 | H1025 | Bar | SRC-7A6D52 | 360 | 60 | 300 | 0.84 | 252 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS 5659 | Non-qualifying | China | 46418 | 1 | Base-compliant; program origin test required | REQ-W3F9 origin fail; REQ-W9A3 eligible | Reserve 147.00 usable lb for Calder only; China melt is barred for Meridian. |
| LOT-3E8C71 | 4340 | AMS 6415 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | 520 | 0 | 520 | 0.8 | 416 | None | 3.1 | Full | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | Qualifying (USA) | USA | 46660 | 1 | Base-compliant; program origin test required | REQ-K9P1; REQ-H7D5 | Allocate 416.00 usable lb to Raven first. |
| LOT-8D4B19 | 7075 | AMS-QQ-A-200/11 | AMS-QQ-A-200 | T6511 | Extrusion | SRC-9F2A41 | 600 | 95 | 505 | 0.77 | 388.85 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Qualifying (USA) | USA | 46477 | 1 | Base-compliant; program origin test required | REQ-J5G7; REQ-E9C1 | Allocate 388.85 usable lb to Tundra first. |
| LOT-2C9E14 | 7075 | AMS-QQ-A-250/12 | AMS-QQ-A-250 | T651 | Plate | SRC-9F2A41 | 690 | 0 | 690 | 0.85 | 586.5 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Qualifying (USA) | USA | 46477 | 1 | Base-compliant; program origin test required | REQ-R7W2; REQ-S6P3 | Allocate Meridian first, then remaining 174.50 usable lb to Halcyon. |
| LOT-3A7C82 | 6061 | AMS-QQ-A-250/11 | AMS-QQ-A-250 | T651 | Plate | SRC-7B2F60 | 880 | 0 | 880 | 0.87 | 765.6 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Qualifying (USA) | USA | 46630 | 1 | Base-compliant; program origin test required | REQ-M1X8; REQ-Q8L5; REQ-A2F7 | Use after LOT-E8C520; cover Halcyon residual and Calder. |
| LOT-7F3A2B | 7075 | AMS-QQ-A-250/12 | AMS-QQ-A-250 | T7351 | Plate | SRC-9F2A41 | 1040 | 410 | 630 | 0.82 | 516.6 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Qualifying (USA) | USA | 46477 | 1 | Base-compliant; program origin test required | REQ-H4A2; REQ-B6N3 | Allocate all 516.60 usable lb to Raven, the higher-priority DFARS program. |
| LOT-A1E9F4 | 6061 | AMS-QQ-A-250/11 | AMS-QQ-A-250 | T651 | Plate | SRC-D14E8B | 980 | 300 | 680 | 0.87 | 591.6 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Qualifying (USA) | USA | 46568 | 1 | Base-compliant; program origin test required | REQ-M1X8; REQ-Q8L5; REQ-A2F7 | Compliant buffer; leave unallocated because two other lots cover listed demand. |
| LOT-D6B821 | 4340 | AMS 6415 | AMS 6415 | Annealed | Bar | SRC-D14E8B | 880 | 120 | 760 | 0.78 | 592.8 | None | C of C | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Qualifying (USA) | USA | 46568 | 0 | Certification below 3.1 | REQ-K9P1; REQ-H7D5 | Exclude: C of C does not meet the 3.1 minimum. |
| LOT-E8C520 | 6061 | AMS-QQ-A-250/11 | AMS-QQ-A-250 | T651 | Plate | SRC-9F2A41 | 1320 | 240 | 1080 | 0.88 | 950.4 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Qualifying (USA) | USA | 46477 | 1 | Base-compliant; program origin test required | REQ-M1X8; REQ-Q8L5; REQ-A2F7 | Allocate Meridian first, then remaining 438.40 usable lb to Halcyon. |
| LOT-9C5F28 | 2024 | AMS-QQ-A-250/4 | AMS-QQ-A-250 | T351 | Plate | SRC-9F2A41 | 540 | 75 | 465 | 0.83 | 385.95 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Qualifying (USA) | USA | 46477 | 1 | Base-compliant; program origin test required | REQ-N3K4 | Allocate 301.00 usable lb to Halcyon; retain 84.95 usable lb. |
| LOT-5C9A16 | 7075 | AMS-QQ-A-250/12 | AMS-QQ-A-250 | T7351 | Plate | SRC-7A6D52 | 920 | 0 | 920 | 0.8 | 736 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS 5659 | Non-qualifying | China | 46418 | 1 | Base-compliant; program origin test required | REQ-H4A2; REQ-B6N3 origin fail | Exclude from Raven/Sable: China melt is non-qualifying. |
| LOT-7E1C95 | 6061 | AMS 4117 | AMS 4117 | T651 | Bar | SRC-9F2A41 | 330 | 40 | 290 | 0.82 | 237.8 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Qualifying (USA) | USA | 46477 | 1 | Base-compliant; program origin test required | REQ-F6B8; REQ-G2J9 | Allocate Sable first, then remaining 4.80 usable lb to Meridian. |
| LOT-5B2E88 | 2024 | AMS-QQ-A-200/3 | AMS-QQ-A-200 | T3511 | Extrusion | SRC-9F2A41 | 410 | 0 | 410 | 0.79 | 323.9 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117 | Qualifying (USA) | USA | 46477 | 1 | Base-compliant; program origin test required | REQ-D7R4; REQ-Y8K2 | Allocate all 323.90 usable lb to Meridian first. |
| LOT-2E6B95 | 7075 | AMS-QQ-A-200/11 | AMS-QQ-A-200 | T6511 | Extrusion | SRC-7B2F60 | 430 | 0 | 430 | 0.78 | 335.4 | None | 3.1 | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415 | Qualifying (USA) | USA | 46630 | 1 | Base-compliant; program origin test required | REQ-J5G7; REQ-E9C1 | After Tundra, allocate remaining 269.25 usable lb to Calder. |
| LOT-B3E7C0 | 15-5PH | AMS 5862 | AMS 5862 | Cond A | Plate | SRC-3B7C19 | 1180 | 0 | 1180 | 0.83 | 979.4 | Quality Hold - MRB | 3.1 | Full | Approved | AMS 5862, AMS 5659, AMS 5604 | Qualifying (non-US) | France | 46387 | 0 | Open hold | REQ-X5M3; REQ-T2C7; REQ-V1D9 | Exclude while Quality Hold - MRB remains open. |
| LOT-2B7E54 | 300M | AMS 6419 | AMS 6419 | Annealed | Bar | SRC-C2F9A7 | 290 | 0 | 290 | 0.74 | 214.6 | None | 3.1 | Full | Approved | AMS 6359, AMS 6415, AMS 6419 | Non-qualifying | China | 46326 | 1 | Base-compliant; program origin test required | REQ-C9T1 origin fail | Exclude from Raven: China melt is non-qualifying. |
| LOT-8F4D17 | 17-4PH | AMS 5604 | AMS 5604 | H1075 | Bar | SRC-3B7C19 | 250 | 0 | 250 | 0.85 | 212.5 | Quality Hold - Recv Insp | 3.1 | Full | Approved | AMS 5862, AMS 5659, AMS 5604 | Qualifying (non-US) | France | 46387 | 0 | Open hold | REQ-P2H6; REQ-U4B8 | Exclude until receiving-inspection hold is cleared; no clearance assumed. |
| LOT-1D6B43 | 15-5PH | AMS 5862 | AMS 5862 | Cond A | Plate | SRC-2D8B96 | 800 | 0 | 800 | 0.83 | 664 | None | 3.1 | Full | Not Approved | AMS 5862, AMS 6359 | Non-qualifying | Russia | - | 0 | Source status Not Approved | REQ-X5M3; REQ-T2C7; REQ-V1D9 | Exclude: source Not Approved; Russia melt also conflicts with restricted programs. |
| LOT-6F2A87 | 17-4PH | AMS 5604 | AMS 5604 | H1075 | Bar | SRC-6E3F88 | 470 | 130 | 340 | 0.85 | 289 | None | 3.1 | Full | Approved | AMS 5604, AMS 5659 | Qualifying (non-US) | South Korea | 46446 | 1 | Base-compliant; program origin test required | REQ-P2H6; REQ-U4B8 | Allocate Tundra first, then remaining 5.00 usable lb to Calder. |
| LOT-1F9D63 | 6061 | AMS-QQ-A-250/11 | AMS-QQ-A-250 | T651 | Plate | SRC-A47C21 | 760 | 0 | 760 | 0.86 | 653.6 | None | 3.1 | Partial - heat not traceable | Suspended | AMS-QQ-A-250, AMS-QQ-A-200 | Qualifying (USA) | USA | 46173 | 0 | Traceability not Full | REQ-M1X8; REQ-Q8L5; REQ-A2F7 | Exclude: source Suspended and heat traceability is not Full. |
| LOT-4A8D62 | 7075 | AMS-QQ-A-250/12 | AMS-QQ-A-250 | T651 | Plate | SRC-D14E8B | 700 | 0 | 700 | 0.84 | 588 | None | C of C | Full | Approved | AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359 | Qualifying (USA) | USA | 46568 | 0 | Certification below 3.1 | REQ-R7W2; REQ-S6P3 | Exclude: C of C does not meet the 3.1 minimum. |
| LOT-4D1A95 | 15-5PH | AMS 5862 | AMS 5862 | Cond A | Plate | SRC-B9D472 | 540 | 0 | 540 | 0.81 | 437.4 | None | 3.1 | Full | Conditional | AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117, AMS 5862 | Qualifying (USA) | USA | 46218 | 0 | Source status Conditional | REQ-X5M3; REQ-T2C7; REQ-V1D9 | Exclude: source is Conditional and ineligible for new commitments. |
| LOT-6B2F39 | 15-5PH | AMS 5862 | AMS 5862 | Cond A | Plate | SRC-E5C913 | 610 | 0 | 610 | 0.82 | 500.2 | None | 3.1 | Full | Approved | AMS 5862, AMS 5659, AMS 5604 | Qualifying (non-US) | Slovenia | 46538 | 1 | Base-compliant; program origin test required | REQ-X5M3; REQ-T2C7; REQ-V1D9 | Allocate Raven first, then remaining 106.20 usable lb to Sable. |
| LOT-9A4F37 | 4340 | AMS 6415 | AMS 6415 | Annealed | Bar | SRC-58E1B3 | 305 | 0 | 305 | 0.8 | 244 | None | 3.1 | Full | Approved | AMS 6415, AMS 6359, AMS 6419, AMS 5604 | Qualifying (USA) | USA | 46660 | 1 | Base-compliant; program origin test required | REQ-K9P1; REQ-H7D5 | Finish Raven coverage, then allocate remaining 45.00 usable lb to Calder. |
Inventory-Req Tests
| Inventory Lot-to-Requirement Compliance Tests | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Every exact-callout lot/requirement candidate is tested again for program-specific origin. A physical match is not an eligibility result. | ||||||||||||||
| Lot ID | Requirement ID | Program ID | Priority | Restriction | Exact Callout Match | Base Compliant | Melt Country | Origin Status | Origin Allowed | Eligible for Requirement | Eligible Usable Qty (lb) | Selected | Applied Qty (lb) | Evaluation |
| LOT-2B7E54 | REQ-C9T1 | PRG-RAVEN | 1 | DFARS | 1 | 1 | China | Non-qualifying | 0 | 0 | 0 | 0 | 0 | Origin not allowed for program |
| LOT-3E8C71 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 416 | 1 | 416 | Selected and allocated |
| LOT-9A4F37 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 244 | 1 | 199 | Selected and allocated |
| LOT-D6B821 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-5C9A16 | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | 1 | 1 | China | Non-qualifying | 0 | 0 | 0 | 0 | 0 | Origin not allowed for program |
| LOT-7F3A2B | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 516.6 | 1 | 516.6 | Selected and allocated |
| LOT-1D6B43 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 1 | 0 | Russia | Non-qualifying | 0 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-4D1A95 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-6B2F39 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 1 | 1 | Slovenia | Qualifying (non-US) | 1 | 1 | 500.2 | 1 | 394 | Selected and allocated |
| LOT-B3E7C0 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 1 | 0 | France | Qualifying (non-US) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-5C9A16 | REQ-B6N3 | PRG-SABLE | 2 | DFARS | 1 | 1 | China | Non-qualifying | 0 | 0 | 0 | 0 | 0 | Origin not allowed for program |
| LOT-7F3A2B | REQ-B6N3 | PRG-SABLE | 2 | DFARS | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 516.6 | 0 | 0 | Eligible alternative / not allocated |
| LOT-1D6B43 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 1 | 0 | Russia | Non-qualifying | 0 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-4D1A95 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-6B2F39 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 1 | 1 | Slovenia | Qualifying (non-US) | 1 | 1 | 500.2 | 1 | 106.2 | Selected and allocated |
| LOT-B3E7C0 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 1 | 0 | France | Qualifying (non-US) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-7E1C95 | REQ-F6B8 | PRG-SABLE | 2 | DFARS | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 237.8 | 1 | 233 | Selected and allocated |
| LOT-2C9E14 | REQ-R7W2 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 586.5 | 1 | 412 | Selected and allocated |
| LOT-4A8D62 | REQ-R7W2 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-C7A340 | REQ-W3F9 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 1 | China | Non-qualifying | 0 | 0 | 0 | 0 | 0 | Origin not allowed for program |
| LOT-7E1C95 | REQ-G2J9 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 237.8 | 1 | 4.79999999999998 | Selected and allocated |
| LOT-5B2E88 | REQ-D7R4 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 323.9 | 1 | 323.9 | Selected and allocated |
| LOT-1F9D63 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-3A7C82 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 765.6 | 0 | 0 | Eligible alternative / not allocated |
| LOT-A1E9F4 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 591.6 | 0 | 0 | Eligible alternative / not allocated |
| LOT-E8C520 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 950.4 | 1 | 512 | Selected and allocated |
| LOT-1D6B43 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 1 | 0 | Russia | Non-qualifying | 0 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-4D1A95 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-6B2F39 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 1 | 1 | Slovenia | Qualifying (non-US) | 1 | 1 | 500.2 | 0 | 0 | Eligible alternative / not allocated |
| LOT-B3E7C0 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 1 | 0 | France | Qualifying (non-US) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-6F2A87 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | 1 | 1 | South Korea | Qualifying (non-US) | 1 | 1 | 289 | 1 | 284 | Selected and allocated |
| LOT-8F4D17 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | 1 | 0 | France | Qualifying (non-US) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-5B2E88 | REQ-Y8K2 | PRG-TUNDRA | 4 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 323.9 | 0 | 0 | Eligible alternative / not allocated |
| LOT-2E6B95 | REQ-J5G7 | PRG-TUNDRA | 4 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 335.4 | 1 | 66.15 | Selected and allocated |
| LOT-8D4B19 | REQ-J5G7 | PRG-TUNDRA | 4 | CUST-EU | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 388.85 | 1 | 388.85 | Selected and allocated |
| LOT-1F9D63 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-3A7C82 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 765.6 | 1 | 287.6 | Selected and allocated |
| LOT-A1E9F4 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 591.6 | 0 | 0 | Eligible alternative / not allocated |
| LOT-E8C520 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 950.4 | 1 | 438.4 | Selected and allocated |
| LOT-2C9E14 | REQ-S6P3 | PRG-HALCYON | 5 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 586.5 | 1 | 174.5 | Selected and allocated |
| LOT-4A8D62 | REQ-S6P3 | PRG-HALCYON | 5 | None | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-9C5F28 | REQ-N3K4 | PRG-HALCYON | 5 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 385.95 | 1 | 301 | Selected and allocated |
| LOT-3E8C71 | REQ-H7D5 | PRG-CALDER | 6 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 416 | 0 | 0 | Eligible alternative / not allocated |
| LOT-9A4F37 | REQ-H7D5 | PRG-CALDER | 6 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 244 | 1 | 45 | Selected and allocated |
| LOT-D6B821 | REQ-H7D5 | PRG-CALDER | 6 | None | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-2E6B95 | REQ-E9C1 | PRG-CALDER | 6 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 335.4 | 1 | 269.25 | Selected and allocated |
| LOT-8D4B19 | REQ-E9C1 | PRG-CALDER | 6 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 388.85 | 0 | 0 | Eligible alternative / not allocated |
| LOT-1F9D63 | REQ-A2F7 | PRG-CALDER | 6 | None | 1 | 0 | USA | Qualifying (USA) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
| LOT-3A7C82 | REQ-A2F7 | PRG-CALDER | 6 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 765.6 | 1 | 333 | Selected and allocated |
| LOT-A1E9F4 | REQ-A2F7 | PRG-CALDER | 6 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 591.6 | 0 | 0 | Eligible alternative / not allocated |
| LOT-E8C520 | REQ-A2F7 | PRG-CALDER | 6 | None | 1 | 1 | USA | Qualifying (USA) | 1 | 1 | 950.4 | 0 | 0 | Eligible alternative / not allocated |
| LOT-C7A340 | REQ-W9A3 | PRG-CALDER | 6 | None | 1 | 1 | China | Non-qualifying | 1 | 1 | 252 | 1 | 147 | Selected and allocated |
| LOT-6F2A87 | REQ-U4B8 | PRG-CALDER | 6 | None | 1 | 1 | South Korea | Qualifying (non-US) | 1 | 1 | 289 | 1 | 5 | Selected and allocated |
| LOT-8F4D17 | REQ-U4B8 | PRG-CALDER | 6 | None | 1 | 0 | France | Qualifying (non-US) | 1 | 0 | 0 | 0 | 0 | Fails base certification/traceability/hold/source gate |
Quote-Req Tests
| Supplier Quote-to-Requirement Feasibility Tests | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Each exact-callout quote is evaluated by requirement because origin and schedule can make the same quote feasible for one program and unusable for another. | ||||||||||||||||||||||
| Quote ID | Requirement ID | Program ID | Priority | Restriction | Exact Callout Match | Source Status | Spec Family Approved | Cert Eligible | Melt Country | Origin Status | Origin Allowed | Receipt Date | Need-By Date | Schedule Margin (days) | Schedule Feasible | Quote Active at Review | Approval Valid Through Receipt | Compliance / Schedule Feasible | Quoted Qty (lb) | Coverage vs Full Requirement | Selected Applied Qty (lb) | Evaluation |
| QTE-4E9A72 | REQ-C9T1 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | China | Non-qualifying | 0 | 46222 | 46237 | 15 | 1 | 1 | 1 | 0 | 300 | Full requirement | 0 | Origin not allowed for program |
| QTE-8B3F19 | REQ-C9T1 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46229 | 46237 | 8 | 1 | 1 | 1 | 1 | 250 | Full requirement | 176 | Selected and applied |
| QTE-1E8C57 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46228 | 46239 | 11 | 1 | 1 | 1 | 1 | 650 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-B6D2A9 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 0 | USA | Qualifying (USA) | 1 | 46218 | 46239 | 21 | 1 | 1 | 1 | 0 | 700 | Full requirement | 0 | Certification below 3.1 |
| QTE-D9F3B1 | REQ-K9P1 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46226 | 46239 | 13 | 1 | 1 | 1 | 1 | 500 | Partial only | 0 | Feasible compliant alternative / not selected |
| QTE-7D2B40 | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | China | Non-qualifying | 0 | 46225 | 46244 | 19 | 1 | 1 | 1 | 0 | 800 | Partial only | 0 | Origin not allowed for program |
| QTE-A3F91C | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46233 | 46244 | 11 | 1 | 1 | 1 | 1 | 600 | Partial only | 325.4 | Selected and applied |
| QTE-F1C8A6 | REQ-H4A2 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46248 | 46244 | -4 | 0 | 1 | 1 | 0 | 450 | Partial only | 0 | Receipt on/after need-by |
| QTE-3A9F18 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | France | Qualifying (non-US) | 1 | 46240 | 46246 | 6 | 1 | 1 | 1 | 1 | 900 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-5D8B72 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 1 | Approved | 1 | 1 | Slovenia | Qualifying (non-US) | 1 | 46237 | 46246 | 9 | 1 | 1 | 1 | 1 | 700 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-6F1A93 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 1 | Conditional | 1 | 1 | USA | Qualifying (USA) | 1 | 46229 | 46246 | 17 | 1 | 1 | 0 | 0 | 600 | Full requirement | 0 | Source status Conditional |
| QTE-9C4E27 | REQ-X5M3 | PRG-RAVEN | 1 | DFARS | 1 | Not Approved | 1 | 1 | Russia | Non-qualifying | 0 | 46231 | 46246 | 15 | 1 | 1 | 0 | 0 | 1000 | Full requirement | 0 | Source status Not Approved |
| QTE-7D2B40 | REQ-B6N3 | PRG-SABLE | 2 | DFARS | 1 | Approved | 1 | 1 | China | Non-qualifying | 0 | 46225 | 46256 | 31 | 1 | 1 | 1 | 0 | 800 | Full requirement | 0 | Origin not allowed for program |
| QTE-A3F91C | REQ-B6N3 | PRG-SABLE | 2 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46233 | 46256 | 23 | 1 | 1 | 1 | 1 | 600 | Full requirement | 268 | Selected and applied |
| QTE-F1C8A6 | REQ-B6N3 | PRG-SABLE | 2 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46248 | 46256 | 8 | 1 | 1 | 1 | 1 | 450 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-3A9F18 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 1 | Approved | 1 | 1 | France | Qualifying (non-US) | 1 | 46240 | 46258 | 18 | 1 | 1 | 1 | 1 | 900 | Full requirement | 323.8 | Selected and applied |
| QTE-5D8B72 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 1 | Approved | 1 | 1 | Slovenia | Qualifying (non-US) | 1 | 46237 | 46258 | 21 | 1 | 1 | 1 | 1 | 700 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-6F1A93 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 1 | Conditional | 1 | 1 | USA | Qualifying (USA) | 1 | 46229 | 46258 | 29 | 1 | 1 | 0 | 0 | 600 | Full requirement | 0 | Source status Conditional |
| QTE-9C4E27 | REQ-T2C7 | PRG-SABLE | 2 | DFARS | 1 | Not Approved | 1 | 1 | Russia | Non-qualifying | 0 | 46231 | 46258 | 27 | 1 | 1 | 0 | 0 | 1000 | Full requirement | 0 | Source status Not Approved |
| QTE-1A6E38 | REQ-F6B8 | PRG-SABLE | 2 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46246 | 46260 | 14 | 1 | 1 | 1 | 1 | 300 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-3F7D92 | REQ-F6B8 | PRG-SABLE | 2 | DFARS | 1 | Approved | 0 | 1 | USA | Qualifying (USA) | 1 | 46242 | 46260 | 18 | 1 | 1 | 1 | 0 | 250 | Full requirement | 0 | Source not approved for spec family |
| QTE-6D1B84 | REQ-L8Q4 | PRG-SABLE | 2 | DFARS | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46260 | 46262 | 2 | 1 | 1 | 1 | 1 | 450 | Full requirement | 287 | Selected and applied |
| QTE-9A2E57 | REQ-L8Q4 | PRG-SABLE | 2 | DFARS | 1 | Approved | 1 | 1 | China | Non-qualifying | 0 | 46252 | 46262 | 10 | 1 | 1 | 1 | 0 | 500 | Full requirement | 0 | Origin not allowed for program |
| QTE-4C8F12 | REQ-R7W2 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46235 | 46277 | 42 | 1 | 1 | 1 | 1 | 400 | Partial only | 0 | Feasible compliant alternative / not selected |
| QTE-9E4B27 | REQ-R7W2 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46238 | 46277 | 39 | 1 | 1 | 1 | 1 | 500 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-2F8C41 | REQ-W3F9 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | France | Qualifying (non-US) | 1 | 46243 | 46279 | 36 | 1 | 1 | 1 | 1 | 300 | Full requirement | 198 | Selected and applied |
| QTE-8A1D63 | REQ-W3F9 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | China | Non-qualifying | 0 | 46230 | 46279 | 49 | 1 | 1 | 1 | 0 | 350 | Full requirement | 0 | Origin not allowed for program |
| QTE-1A6E38 | REQ-G2J9 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46246 | 46281 | 35 | 1 | 1 | 1 | 1 | 300 | Full requirement | 154.2 | Selected and applied |
| QTE-3F7D92 | REQ-G2J9 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 0 | 1 | USA | Qualifying (USA) | 1 | 46242 | 46281 | 39 | 1 | 1 | 1 | 0 | 250 | Full requirement | 0 | Source not approved for spec family |
| QTE-2D7C64 | REQ-D7R4 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46236 | 46283 | 47 | 1 | 1 | 1 | 1 | 400 | Full requirement | 23.1 | Selected and applied |
| QTE-9B4F27 | REQ-D7R4 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46227 | 46283 | 56 | 1 | 1 | 1 | 1 | 350 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-2A7E61 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46246 | 46286 | 40 | 1 | 1 | 1 | 1 | 650 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-5F1B83 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46259 | 46286 | 27 | 1 | 1 | 1 | 1 | 800 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-8C3D49 | REQ-M1X8 | PRG-MERIDIAN | 3 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46234 | 46286 | 52 | 1 | 1 | 1 | 1 | 900 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-3A9F18 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | France | Qualifying (non-US) | 1 | 46240 | 46301 | 61 | 1 | 1 | 1 | 1 | 900 | Full requirement | 357 | Selected and applied |
| QTE-5D8B72 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | Slovenia | Qualifying (non-US) | 1 | 46237 | 46301 | 64 | 1 | 1 | 1 | 1 | 700 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-6F1A93 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 1 | Conditional | 1 | 1 | USA | Qualifying (USA) | 1 | 46229 | 46301 | 72 | 1 | 1 | 0 | 0 | 600 | Full requirement | 0 | Source status Conditional |
| QTE-9C4E27 | REQ-V1D9 | PRG-TUNDRA | 4 | CUST-EU | 1 | Not Approved | 1 | 1 | Russia | Non-qualifying | 0 | 46231 | 46301 | 70 | 1 | 1 | 0 | 0 | 1000 | Full requirement | 0 | Source status Not Approved |
| QTE-1F7C93 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | France | Qualifying (non-US) | 1 | 46235 | 46304 | 69 | 1 | 1 | 1 | 1 | 300 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-6A2D58 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | South Korea | Qualifying (non-US) | 1 | 46238 | 46304 | 66 | 1 | 1 | 1 | 1 | 350 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-7E2A85 | REQ-P2H6 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | Slovenia | Qualifying (non-US) | 1 | 46249 | 46304 | 55 | 1 | 1 | 1 | 1 | 250 | Partial only | 0 | Feasible compliant alternative / not selected |
| QTE-2D7C64 | REQ-Y8K2 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46236 | 46306 | 70 | 1 | 1 | 1 | 1 | 400 | Full requirement | 213 | Selected and applied |
| QTE-9B4F27 | REQ-Y8K2 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46227 | 46306 | 79 | 1 | 1 | 1 | 1 | 350 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-3D9B16 | REQ-J5G7 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46232 | 46307 | 75 | 1 | 1 | 1 | 1 | 400 | Partial only | 0 | Feasible compliant alternative / not selected |
| QTE-C1E7B4 | REQ-J5G7 | PRG-TUNDRA | 4 | CUST-EU | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46237 | 46307 | 70 | 1 | 1 | 1 | 1 | 500 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-6D1B84 | REQ-Z4V2 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46260 | 46327 | 67 | 1 | 1 | 1 | 1 | 450 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-9A2E57 | REQ-Z4V2 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | China | Non-qualifying | 1 | 46252 | 46327 | 75 | 1 | 1 | 1 | 1 | 500 | Full requirement | 389 | Selected and applied |
| QTE-2A7E61 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46246 | 46328 | 82 | 1 | 1 | 1 | 1 | 650 | Partial only | 0 | Feasible compliant alternative / not selected |
| QTE-5F1B83 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46259 | 46328 | 69 | 1 | 1 | 1 | 1 | 800 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-8C3D49 | REQ-Q8L5 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46234 | 46328 | 94 | 1 | 1 | 1 | 1 | 900 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-4C8F12 | REQ-S6P3 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46235 | 46330 | 95 | 1 | 1 | 1 | 1 | 400 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-9E4B27 | REQ-S6P3 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46238 | 46330 | 92 | 1 | 1 | 1 | 1 | 500 | Full requirement | 69.5 | Selected and applied |
| QTE-5B9E41 | REQ-N3K4 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46293 | 46331 | 38 | 1 | 1 | 1 | 1 | 350 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-7C3A95 | REQ-N3K4 | PRG-HALCYON | 5 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46287 | 46331 | 44 | 1 | 1 | 1 | 1 | 400 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-1E8C57 | REQ-H7D5 | PRG-CALDER | 6 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46228 | 46339 | 111 | 1 | 1 | 1 | 1 | 650 | Full requirement | 0 | Feasible compliant alternative / not selected |
| QTE-B6D2A9 | REQ-H7D5 | PRG-CALDER | 6 | None | 1 | Approved | 1 | 0 | USA | Qualifying (USA) | 1 | 46218 | 46339 | 121 | 1 | 1 | 1 | 0 | 700 | Full requirement | 0 | Certification below 3.1 |
| QTE-D9F3B1 | REQ-H7D5 | PRG-CALDER | 6 | None | 1 | Approved | 1 | 1 | USA | Qualifying (USA) | 1 | 46226 | 46339 | 113 | 1 | 1 | 1 | 1 | 500 | Full requirement | 160 | Selected and applied |
Allocation Detail
| Recommended Allocation Detail | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Rows are sequenced so eligible inventory is consumed first and contested material follows program priority. Purchase allocations then close the exact residual; formulas prevent double allocation. | ||||||||||||||
| Source Type | Requirement ID | Source Lot / Quote ID | Program ID | Need-By Date | Requirement Qty (lb) | Source Available Qty (lb) | Prior Requirement Coverage (lb) | Applied Usable Qty (lb) | Remaining Requirement (lb) | Source Qty Remaining (lb) | Unit Price ($/lb) | Applied Purchase Cost ($) | Selection Basis | Compliance Check |
| Inventory | REQ-H4A2 | LOT-7F3A2B | PRG-RAVEN | 46244 | 842 | 516.6 | 0 | 516.6 | 325.4 | 0 | 0 | 0 | Only eligible T7351 lot; Raven priority 1. | PASS |
| Inventory | REQ-K9P1 | LOT-3E8C71 | PRG-RAVEN | 46239 | 615 | 416 | 0 | 416 | 199 | 0 | 0 | 0 | Use full compliant lot for Raven. | PASS |
| Inventory | REQ-K9P1 | LOT-9A4F37 | PRG-RAVEN | 46239 | 615 | 244 | 416 | 199 | 0 | 45 | 0 | 0 | Close Raven residual before lower-priority Calder. | PASS |
| Inventory | REQ-H7D5 | LOT-9A4F37 | PRG-CALDER | 46339 | 205 | 244 | 0 | 45 | 160 | 0 | 0 | 0 | Use remaining eligible 4340 bar after Raven. | PASS |
| Inventory | REQ-X5M3 | LOT-6B2F39 | PRG-RAVEN | 46246 | 394 | 500.2 | 0 | 394 | 0 | 106.2 | 0 | 0 | Raven priority 1. | PASS |
| Inventory | REQ-T2C7 | LOT-6B2F39 | PRG-SABLE | 46258 | 430 | 500.2 | 0 | 106.2 | 323.8 | 0 | 0 | 0 | Use remaining plate after Raven. | PASS |
| Inventory | REQ-F6B8 | LOT-7E1C95 | PRG-SABLE | 46260 | 233 | 237.8 | 0 | 233 | 0 | 4.79999999999998 | 0 | 0 | Sable priority 2. | PASS |
| Inventory | REQ-G2J9 | LOT-7E1C95 | PRG-MERIDIAN | 46281 | 159 | 237.8 | 0 | 4.79999999999998 | 154.2 | 0 | 0 | 0 | Use remainder after Sable. | PASS |
| Inventory | REQ-M1X8 | LOT-E8C520 | PRG-MERIDIAN | 46286 | 512 | 950.4 | 0 | 512 | 0 | 438.4 | 0 | 0 | Meridian priority 3. | PASS |
| Inventory | REQ-Q8L5 | LOT-E8C520 | PRG-HALCYON | 46328 | 726 | 950.4 | 0 | 438.4 | 287.6 | 0 | 0 | 0 | Use remainder after Meridian. | PASS |
| Inventory | REQ-Q8L5 | LOT-3A7C82 | PRG-HALCYON | 46328 | 726 | 765.6 | 438.4 | 287.6 | 0 | 478 | 0 | 0 | Close Halcyon residual. | PASS |
| Inventory | REQ-A2F7 | LOT-3A7C82 | PRG-CALDER | 46342 | 333 | 765.6 | 0 | 333 | 0 | 145 | 0 | 0 | Use remainder for Calder. | PASS |
| Inventory | REQ-D7R4 | LOT-5B2E88 | PRG-MERIDIAN | 46283 | 347 | 323.9 | 0 | 323.9 | 23.1 | 0 | 0 | 0 | Meridian priority 3 consumes eligible extrusion first. | PASS |
| Inventory | REQ-W9A3 | LOT-C7A340 | PRG-CALDER | 46343 | 147 | 252 | 0 | 147 | 0 | 105 | 0 | 0 | Eligible for Calder; barred for Meridian by origin. | PASS |
| Inventory | REQ-R7W2 | LOT-2C9E14 | PRG-MERIDIAN | 46277 | 412 | 586.5 | 0 | 412 | 0 | 174.5 | 0 | 0 | Meridian priority 3. | PASS |
| Inventory | REQ-S6P3 | LOT-2C9E14 | PRG-HALCYON | 46330 | 244 | 586.5 | 0 | 174.5 | 69.5 | 0 | 0 | 0 | Use remainder for Halcyon. | PASS |
| Inventory | REQ-J5G7 | LOT-8D4B19 | PRG-TUNDRA | 46307 | 455 | 388.85 | 0 | 388.85 | 66.15 | 0 | 0 | 0 | Tundra priority 4. | PASS |
| Inventory | REQ-J5G7 | LOT-2E6B95 | PRG-TUNDRA | 46307 | 455 | 335.4 | 388.85 | 66.15 | 0 | 269.25 | 0 | 0 | Close Tundra residual. | PASS |
| Inventory | REQ-E9C1 | LOT-2E6B95 | PRG-CALDER | 46340 | 271 | 335.4 | 0 | 269.25 | 1.74999999999994 | 0 | 0 | 0 | Use all remaining inventory before buying the 1.75 lb residual. | PASS |
| Inventory | REQ-P2H6 | LOT-6F2A87 | PRG-TUNDRA | 46304 | 284 | 289 | 0 | 284 | 0 | 5 | 0 | 0 | Tundra priority 4. | PASS |
| Inventory | REQ-U4B8 | LOT-6F2A87 | PRG-CALDER | 46344 | 162 | 289 | 0 | 5 | 157 | 0 | 0 | 0 | Use remainder for Calder. | PASS |
| Inventory | REQ-N3K4 | LOT-9C5F28 | PRG-HALCYON | 46331 | 301 | 385.95 | 0 | 301 | 0 | 84.95 | 0 | 0 | Exact compliant plate for Halcyon. | PASS |
| Purchase | REQ-H4A2 | QTE-A3F91C | PRG-RAVEN | 46244 | 842 | 600 | 516.6 | 325.4 | 0 | 274.6 | 9.4 | 3058.76 | Only compliant quote early enough for Raven T7351 residual. | PASS |
| Purchase | REQ-C9T1 | QTE-8B3F19 | PRG-RAVEN | 46237 | 176 | 250 | 0 | 176 | 0 | 74 | 14.2 | 2499.2 | Only compliant qualifying-origin 300M quote. | PASS |
| Purchase | REQ-T2C7 | QTE-3A9F18 | PRG-SABLE | 46258 | 430 | 900 | 106.2 | 323.8 | 0 | 576.2 | 11.75 | 3804.65 | Lowest-cost compliant qualifying-origin plate quote. | PASS |
| Purchase | REQ-B6N3 | QTE-A3F91C | PRG-SABLE | 46256 | 268 | 600 | 0 | 268 | 0 | 6.60000000000002 | 9.4 | 2519.2 | Use shared Cascade capacity after Raven. | PASS |
| Purchase | REQ-L8Q4 | QTE-6D1B84 | PRG-SABLE | 46262 | 287 | 450 | 0 | 287 | 0 | 163 | 6.9 | 1980.3 | Only compliant qualifying-origin quote; 2-day schedule margin. | PASS |
| Purchase | REQ-D7R4 | QTE-2D7C64 | PRG-MERIDIAN | 46283 | 347 | 400 | 323.9 | 23.1 | 0 | 376.9 | 7.6 | 175.56 | Lower unit cost than Tri-State; ample schedule margin. | PASS |
| Purchase | REQ-W3F9 | QTE-2F8C41 | PRG-MERIDIAN | 46279 | 198 | 300 | 0 | 198 | 0 | 102 | 9.85 | 1950.3 | Compliant qualifying-origin bar; China alternative is barred. | PASS |
| Purchase | REQ-G2J9 | QTE-1A6E38 | PRG-MERIDIAN | 46281 | 159 | 300 | 4.79999999999998 | 154.2 | 0 | 145.8 | 5.75 | 886.65 | Only source approved for AMS 4117 among quoted options. | PASS |
| Purchase | REQ-V1D9 | QTE-3A9F18 | PRG-TUNDRA | 46301 | 357 | 900 | 0 | 357 | 0 | 219.2 | 11.75 | 4194.75 | Use shared Ardenne capacity after Sable. | PASS |
| Purchase | REQ-Y8K2 | QTE-2D7C64 | PRG-TUNDRA | 46306 | 213 | 400 | 0 | 213 | 0 | 163.9 | 7.6 | 1618.8 | Use shared Cascade capacity after Meridian. | PASS |
| Purchase | REQ-Z4V2 | QTE-9A2E57 | PRG-HALCYON | 46327 | 389 | 500 | 0 | 389 | 0 | 111 | 5.45 | 2120.05 | Lowest compliant cost for Halcyon; no special origin restriction. | PASS |
| Purchase | REQ-S6P3 | QTE-9E4B27 | PRG-HALCYON | 46330 | 244 | 500 | 174.5 | 69.5 | 0 | 430.5 | 8.7 | 604.65 | Lower cost than Great Lakes; MOQ applies. | PASS |
| Purchase | REQ-E9C1 | QTE-C1E7B4 | PRG-CALDER | 46340 | 271 | 500 | 269.25 | 1.74999999999994 | 0 | 498.25 | 8.9 | 15.5749999999995 | Lower cost than Great Lakes; MOQ closes yield shortfall. | PASS |
| Purchase | REQ-U4B8 | QTE-7E2A85 | PRG-CALDER | 46344 | 162 | 250 | 5 | 157 | 0 | 93 | 11.1 | 1742.7 | Lowest total order cost at documented MOQs. | PASS |
| Purchase | REQ-H7D5 | QTE-D9F3B1 | PRG-CALDER | 46339 | 205 | 500 | 45 | 160 | 0 | 340 | 5.35 | 856 | Lowest total MOQ cost for 160 lb residual. | PASS |
Purchase Plan
| Recommended Supplier Quote Actions | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Recommended order quantity is MAX(applied requirement quantity, documented MOQ) and never exceeds quoted quantity. Applied quantity and purchase surplus are shown separately. | ||||||||||||||||||||
| Quote ID | Material / Callout | Supplier | Source Status | Melt Country | Cert | Quoted Receipt | Earliest Need-By | Schedule Margin (days) | Quote Expiry | Quoted Qty (lb) | MOQ (lb) | Applied Qty (lb) | Recommended Order Qty (lb) | Purchase Surplus (lb) | Unit Price ($/lb) | Recommended PO Cost ($) | Full Quoted Cost ($) | Action Tier | Recommendation | Plan Check |
| QTE-D9F3B1 | 4340 | AMS 6415 | Annealed | Bar | Great Lakes Plate & Bar Co | Approved | USA | 3.1 | 46226 | 46339 | 113 | 46217 | 500 | 250 | 160 | 250 | 90 | 5.35 | 1337.5 | 2675 | Immediate - firm | Release by expiry; 250 lb MOQ covers Calder 4340 residual. | PASS |
| QTE-8B3F19 | 300M | AMS 6419 | Annealed | Bar | Brunderman Forge & Bar Inc | Approved | USA | 3.1 | 46229 | 46237 | 8 | 46217 | 250 | 150 | 176 | 176 | 0 | 14.2 | 2499.2 | 3550 | Immediate - firm | Release by expiry for Raven 300M. | PASS |
| QTE-A3F91C | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | Cascade Rolled Products LLC | Approved | USA | 3.1 | 46233 | 46244 | 11 | 46218 | 600 | 250 | 593.4 | 593.4 | 0 | 9.4 | 5577.96 | 5640 | Immediate - firm | Shared Raven/Sable T7351 buy; receipt protects Raven. | PASS |
| QTE-2D7C64 | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | Cascade Rolled Products LLC | Approved | USA | 3.1 | 46236 | 46283 | 47 | 46222 | 400 | 200 | 236.1 | 236.1 | 0 | 7.6 | 1794.36 | 3040 | Immediate - firm/shared | Supports firm Meridian and tentative Tundra extrusion demand. | PASS |
| QTE-3A9F18 | 15-5PH | AMS 5862 | Cond A | Plate | Ardenne Steelworks SA | Approved | France | 3.1 | 46240 | 46258 | 18 | 46223 | 900 | 400 | 680.8 | 680.8 | 0 | 11.75 | 7999.4 | 10575 | Immediate - firm | Shared Sable/Tundra 15-5PH plate buy. | PASS |
| QTE-9E4B27 | 7075 | AMS-QQ-A-250/12 | T651 | Plate | Cascade Rolled Products LLC | Approved | USA | 3.1 | 46238 | 46330 | 92 | 46223 | 500 | 250 | 69.5 | 250 | 180.5 | 8.7 | 2175 | 4350 | Conditional - tentative | Release only if Halcyon REQ-S6P3 remains in scope; 250 lb MOQ. | PASS |
| QTE-C1E7B4 | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | Cascade Rolled Products LLC | Approved | USA | 3.1 | 46237 | 46340 | 103 | 46225 | 500 | 250 | 1.74999999999994 | 250 | 248.25 | 8.9 | 2225 | 4450 | Immediate - firm | 250 lb MOQ required to close a 1.75 lb Calder shortfall. | PASS |
| QTE-7E2A85 | 17-4PH | AMS 5604 | H1075 | Bar | Adriatic Aero Alloys d.o.o. | Approved | Slovenia | 3.1 | 46249 | 46344 | 95 | 46226 | 250 | 150 | 157 | 157 | 0 | 11.1 | 1742.7 | 2775 | Conditional - tentative | Release if Calder REQ-U4B8 remains in scope; held inventory is not counted. | PASS |
| QTE-2F8C41 | 15-5PH | AMS 5659 | H1025 | Bar | Ardenne Steelworks SA | Approved | France | 3.1 | 46243 | 46279 | 36 | 46226 | 300 | 150 | 198 | 198 | 0 | 9.85 | 1950.3 | 2955 | Immediate - firm | Release for Meridian 15-5PH bar. | PASS |
| QTE-1A6E38 | 6061 | AMS 4117 | T651 | Bar | Cascade Rolled Products LLC | Approved | USA | 3.1 | 46246 | 46281 | 35 | 46228 | 300 | 150 | 154.2 | 154.2 | 0 | 5.75 | 886.65 | 1725 | Conditional - tentative | Release if Meridian REQ-G2J9 remains in scope. | PASS |
| QTE-9A2E57 | 4340 | AMS 6359 | Norm | Plate | Yellow River Specialty Steel | Approved | China | 3.1 | 46252 | 46327 | 75 | 46236 | 500 | 250 | 389 | 389 | 0 | 5.45 | 2120.05 | 2725 | Immediate - firm | Use for Halcyon only; China origin is not acceptable for Sable. | PASS |
| QTE-6D1B84 | 4340 | AMS 6359 | Norm | Plate | Brunderman Forge & Bar Inc | Approved | USA | 3.1 | 46260 | 46262 | 2 | 46239 | 450 | 250 | 287 | 287 | 0 | 6.9 | 1980.3 | 3105 | Priority decision - tentative | Sable has only a 2-day receipt margin; planner/PMO decision required now. | PASS |
Requirement Coverage
| Requirement-Level Material Coverage | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Coverage uses only passing allocations from Allocation Detail. A zero residual means coverable if the stated quote actions and tentative-demand decisions are executed; it does not mean a PO has already been placed. | ||||||||||||||||||||
| Requirement ID | Program ID | Priority | MRP Firmed | Alloy | Material Spec | Temper / Condition | Product Form | Need-By Date | Net Required Qty (lb) | Compliant Inventory Applied (lb) | Selected Purchase Applied (lb) | Total Planned Coverage (lb) | Residual Shortage (lb) | Coverage Route | Selected Lots | Selected Quotes | Applied Purchase Cost ($) | Commitment Status | Recommended Action | Key Constraint / Risk |
| REQ-C9T1 | PRG-RAVEN | 1 | Y | 300M | AMS 6419 | Annealed | Bar | 46237 | 176 | 0 | 176 | 176 | 0 | Purchase only | - | QTE-8B3F19 | 2499.2 | PLAN COVERED - release selected quote | Buy 176.00 lb from Brunderman. | China-origin inventory and Yellow River quote are ineligible for Raven. |
| REQ-K9P1 | PRG-RAVEN | 1 | Y | 4340 | AMS 6415 | Annealed | Bar | 46239 | 615 | 615 | 0 | 615 | 0 | Inventory only | LOT-3E8C71; LOT-9A4F37 | - | 0 | COVERED - compliant inventory | Allocate 416.00 + 199.00 usable lb to Raven. | Do not use C-of-C lot/quote even though physically available or cheaper. |
| REQ-H4A2 | PRG-RAVEN | 1 | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 46244 | 842 | 516.6 | 325.4 | 842 | 0 | Mixed inventory + purchase | LOT-7F3A2B | QTE-A3F91C | 3058.76 | PLAN COVERED - release selected quote | Allocate 516.60 usable lb from LOT-7F3A2B; buy the 325.40 lb residual from Cascade. | China-origin LOT-5C9A16 and QTE-7D2B40 are not eligible for Raven; Great Lakes arrives after Raven need-by. |
| REQ-X5M3 | PRG-RAVEN | 1 | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46246 | 394 | 394 | 0 | 394 | 0 | Inventory only | LOT-6B2F39 | - | 0 | COVERED - compliant inventory | Allocate 394.00 usable lb from the approved Slovenia-melt lot. | Held, conditional, and not-approved plate cannot be counted. |
| REQ-B6N3 | PRG-SABLE | 2 | Y | 7075 | AMS-QQ-A-250/12 | T7351 | Plate | 46256 | 268 | 0 | 268 | 268 | 0 | Purchase only | - | QTE-A3F91C | 2519.2 | PLAN COVERED - release selected quote | Apply 268.00 lb from the Cascade T7351 purchase after Raven. | China melt is barred; Great Lakes is feasible for Sable but costs more and arrives later. |
| REQ-T2C7 | PRG-SABLE | 2 | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46258 | 430 | 106.2 | 323.8 | 430 | 0 | Mixed inventory + purchase | LOT-6B2F39 | QTE-3A9F18 | 3804.65 | PLAN COVERED - release selected quote | Use the 106.20 lb remainder after Raven; buy 323.80 lb from Ardenne. | Raven receives first claim under program priority. |
| REQ-F6B8 | PRG-SABLE | 2 | Y | 6061 | AMS 4117 | T651 | Bar | 46260 | 233 | 233 | 0 | 233 | 0 | Inventory only | LOT-7E1C95 | - | 0 | COVERED - compliant inventory | Allocate 233.00 usable lb to Sable. | Only 4.80 usable lb remains for Meridian. |
| REQ-L8Q4 | PRG-SABLE | 2 | Tentative | 4340 | AMS 6359 | Norm | Plate | 46262 | 287 | 0 | 287 | 287 | 0 | Purchase only | - | QTE-6D1B84 | 1980.3 | PLAN COVERED - planner/PO decision required | If the tentative line remains in scope, release 287.00 lb from Brunderman. | Only 2 calendar days separate quoted receipt and need-by; escalate schedule acceptance. China-origin alternative is ineligible. |
| REQ-R7W2 | PRG-MERIDIAN | 3 | Y | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 46277 | 412 | 412 | 0 | 412 | 0 | Inventory only | LOT-2C9E14 | - | 0 | COVERED - compliant inventory | Allocate 412.00 usable lb to Meridian. | T7351 is not an allowed substitute; C-of-C lot is excluded. |
| REQ-W3F9 | PRG-MERIDIAN | 3 | Y | 15-5PH | AMS 5659 | H1025 | Bar | 46279 | 198 | 0 | 198 | 198 | 0 | Purchase only | - | QTE-2F8C41 | 1950.3 | PLAN COVERED - release selected quote | Buy 198.00 lb from Ardenne. | China-melt on-hand and Hangzhou quote violate CUST-EU. |
| REQ-G2J9 | PRG-MERIDIAN | 3 | Tentative | 6061 | AMS 4117 | T651 | Bar | 46281 | 159 | 4.79999999999998 | 154.2 | 159 | 0 | Mixed inventory + purchase | LOT-7E1C95 | QTE-1A6E38 | 886.65 | PLAN COVERED - planner/PO decision required | Use 4.80 usable lb; if tentative demand is retained, buy 154.20 lb from Cascade. | Great Lakes quote is not approved for AMS 4117. |
| REQ-D7R4 | PRG-MERIDIAN | 3 | Y | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 46283 | 347 | 323.9 | 23.1 | 347 | 0 | Mixed inventory + purchase | LOT-5B2E88 | QTE-2D7C64 | 175.56 | PLAN COVERED - release selected quote | Use 323.90 usable lb; apply 23.10 lb of the Cascade purchase. | Shared purchase also covers Tundra's tentative line. |
| REQ-M1X8 | PRG-MERIDIAN | 3 | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46286 | 512 | 512 | 0 | 512 | 0 | Inventory only | LOT-E8C520 | - | 0 | COVERED - compliant inventory | Allocate 512.00 usable lb to Meridian. | Suspended/partially traceable LOT-1F9D63 is excluded. |
| REQ-V1D9 | PRG-TUNDRA | 4 | Y | 15-5PH | AMS 5862 | Cond A | Plate | 46301 | 357 | 0 | 357 | 357 | 0 | Purchase only | - | QTE-3A9F18 | 4194.75 | PLAN COVERED - release selected quote | Apply 357.00 lb from the Ardenne purchase after Sable. | Held and source-status-blocked stock is excluded. |
| REQ-P2H6 | PRG-TUNDRA | 4 | Y | 17-4PH | AMS 5604 | H1075 | Bar | 46304 | 284 | 284 | 0 | 284 | 0 | Inventory only | LOT-6F2A87 | - | 0 | COVERED - compliant inventory | Allocate 284.00 usable lb from the qualifying South Korea lot. | Receiving-inspection hold lot is not counted. |
| REQ-Y8K2 | PRG-TUNDRA | 4 | Tentative | 2024 | AMS-QQ-A-200/3 | T3511 | Extrusion | 46306 | 213 | 0 | 213 | 213 | 0 | Purchase only | - | QTE-2D7C64 | 1618.8 | PLAN COVERED - planner/PO decision required | Apply 213.00 lb from the shared Cascade purchase if tentative demand is retained. | The order already supports firm Meridian demand; 36.10 lb above the 200 lb MOQ completes Tundra coverage. |
| REQ-J5G7 | PRG-TUNDRA | 4 | Y | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 46307 | 455 | 455 | 0 | 455 | 0 | Inventory only | LOT-8D4B19; LOT-2E6B95 | - | 0 | COVERED - compliant inventory | Allocate 388.85 + 66.15 usable lb to Tundra. | Exact extrusion form and T6511 condition are mandatory. |
| REQ-Z4V2 | PRG-HALCYON | 5 | Y | 4340 | AMS 6359 | Norm | Plate | 46327 | 389 | 0 | 389 | 389 | 0 | Purchase only | - | QTE-9A2E57 | 2120.05 | PLAN COVERED - release selected quote | Buy 389.00 lb from Yellow River for Halcyon only. | China melt is allowed for Halcyon under the documented None restriction, but not for Sable. |
| REQ-Q8L5 | PRG-HALCYON | 5 | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46328 | 726 | 726 | 0 | 726 | 0 | Inventory only | LOT-E8C520; LOT-3A7C82 | - | 0 | COVERED - compliant inventory | Use 438.40 + 287.60 usable lb after Meridian. | Compliant inventory is sufficient; no quote action required. |
| REQ-S6P3 | PRG-HALCYON | 5 | Tentative | 7075 | AMS-QQ-A-250/12 | T651 | Plate | 46330 | 244 | 174.5 | 69.5 | 244 | 0 | Mixed inventory + purchase | LOT-2C9E14 | QTE-9E4B27 | 604.65 | PLAN COVERED - planner/PO decision required | Use the 174.50 lb remainder; if tentative demand is retained, order the 250 lb MOQ from Cascade. | Only 69.50 lb is applied, creating 180.50 lb purchase surplus. |
| REQ-N3K4 | PRG-HALCYON | 5 | Y | 2024 | AMS-QQ-A-250/4 | T351 | Plate | 46331 | 301 | 301 | 0 | 301 | 0 | Inventory only | LOT-9C5F28 | - | 0 | COVERED - compliant inventory | Allocate 301.00 usable lb; retain 84.95 usable lb. | No purchase required. |
| REQ-H7D5 | PRG-CALDER | 6 | Y | 4340 | AMS 6415 | Annealed | Bar | 46339 | 205 | 45 | 160 | 205 | 0 | Mixed inventory + purchase | LOT-9A4F37 | QTE-D9F3B1 | 856 | PLAN COVERED - release selected quote | Use the 45.00 lb remainder; order Great Lakes' 250 lb MOQ for the 160.00 lb residual. | The higher unit price has the lowest total MOQ cost; purchase surplus is 90.00 lb. |
| REQ-E9C1 | PRG-CALDER | 6 | Y | 7075 | AMS-QQ-A-200/11 | T6511 | Extrusion | 46340 | 271 | 269.25 | 1.74999999999994 | 271 | 0 | Mixed inventory + purchase | LOT-2E6B95 | QTE-C1E7B4 | 15.5749999999995 | PLAN COVERED - release selected quote | Use the remaining 269.25 usable lb; order the 250 lb MOQ to close the 1.75 lb yield shortfall. | No yield increase, allocation change, or rounding waiver is assumed; purchase surplus is 248.25 lb. |
| REQ-A2F7 | PRG-CALDER | 6 | Y | 6061 | AMS-QQ-A-250/11 | T651 | Plate | 46342 | 333 | 333 | 0 | 333 | 0 | Inventory only | LOT-3A7C82 | - | 0 | COVERED - compliant inventory | Allocate 333.00 usable lb after Halcyon. | Compliant inventory remains available. |
| REQ-W9A3 | PRG-CALDER | 6 | Tentative | 15-5PH | AMS 5659 | H1025 | Bar | 46343 | 147 | 147 | 0 | 147 | 0 | Inventory only | LOT-C7A340 | - | 0 | COVERED - compliant inventory | Reserve 147.00 usable lb for Calder. | China melt is acceptable only because Calder has no special origin restriction and the source/cert/traceability checks pass. |
| REQ-U4B8 | PRG-CALDER | 6 | Tentative | 17-4PH | AMS 5604 | H1075 | Bar | 46344 | 162 | 5 | 157 | 162 | 0 | Mixed inventory + purchase | LOT-6F2A87 | QTE-7E2A85 | 1742.7 | PLAN COVERED - planner/PO decision required | Use the 5.00 lb remainder; if tentative demand is retained, buy 157.00 lb from Adriatic. | Held LOT-8F4D17 is not counted; Adriatic minimizes total order cost among compliant quotes at the documented MOQs. |
Alternatives
| Material and Quote Alternatives Considered | |||||||
|---|---|---|---|---|---|---|---|
| Key physically available or commercially attractive alternatives are retained here so rejected options cannot be mistaken for usable coverage. | |||||||
| Candidate ID | Type | Material | Potential Requirement / Program | Decision | Compliance / Selection Reason | Cost / Lead-Time Tradeoff | Source Reference |
| LOT-5C9A16 | Inventory | 7075 T7351 plate | Raven / Sable | Rejected | 736.00 yield-adjusted lb is physically present but China melt is non-qualifying for both DFARS programs. | No cost advantage can override origin. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| LOT-D6B821 | Inventory | 4340 annealed bar | Raven / Calder | Rejected | C of C lacks the required mill test results. | 592.80 yield-adjusted lb cannot be counted. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| LOT-B3E7C0 | Inventory | 15-5PH Cond A plate | Raven / Sable / Tundra | Rejected pending MRB | Open Quality Hold - MRB. | 979.40 yield-adjusted lb remains unavailable unless documented clearance occurs. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| LOT-2B7E54 | Inventory | 300M annealed bar | Raven | Rejected | China melt conflicts with Raven DFARS restriction. | 214.60 yield-adjusted lb cannot be used. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| LOT-8F4D17 | Inventory | 17-4PH H1075 bar | Tundra / Calder | Rejected pending inspection | Open receiving-inspection hold. | 212.50 yield-adjusted lb is not counted. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| LOT-1D6B43 | Inventory | 15-5PH Cond A plate | Raven / Sable / Tundra | Rejected | Source is Not Approved; Russia melt also conflicts with restricted programs. | 664.00 yield-adjusted lb is unusable. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| LOT-1F9D63 | Inventory | 6061 T651 plate | Meridian / Halcyon / Calder | Rejected | Source is Suspended and traceability is partial / heat not traceable. | 653.60 yield-adjusted lb is unusable. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| LOT-4A8D62 | Inventory | 7075 T651 plate | Meridian / Halcyon | Rejected | C of C does not meet the 3.1 minimum. | 588.00 yield-adjusted lb cannot be counted. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| LOT-4D1A95 | Inventory | 15-5PH Cond A plate | Raven / Sable / Tundra | Rejected | Conditional source is ineligible for new commitments. | 437.40 yield-adjusted lb cannot be counted. | inventory_lot_cert_snapshot.xlsx + AMSL/policy/program rules |
| QTE-F1C8A6 | Quote | 7075 T7351 plate | Sable only | Not selected | Compliant for Sable but quoted receipt 2026-08-14 is after Raven's 2026-08-10 need-by. | $9.95/lb is also above selected Cascade at $9.40/lb. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-7D2B40 | Quote | 7075 T7351 plate | Raven / Sable | Rejected | China melt is non-qualifying for both DFARS programs. | Lowest price does not cure origin noncompliance. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-9C4E27 | Quote | 15-5PH Cond A plate | Raven / Sable / Tundra | Rejected | Volga is Not Approved and Russia melt is barred for restricted programs. | Lowest price is not usable. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-6F1A93 | Quote | 15-5PH Cond A plate | Raven / Sable / Tundra | Rejected | Lone Star is Conditional and ineligible for a new commitment. | Earlier receipt does not override source status. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-5D8B72 | Quote | 15-5PH Cond A plate | Raven / Sable / Tundra | Compliant alternative | Eligible qualifying-origin option but not selected. | $12.40/lb versus Ardenne $11.75/lb; 3 days earlier receipt is not required by the selected allocation. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-B6D2A9 | Quote | 4340 annealed bar | Raven / Calder | Rejected | C of C does not meet the 3.1 minimum. | Lower unit price cannot be used. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-4E9A72 | Quote | 300M annealed bar | Raven | Rejected | China melt is non-qualifying for Raven. | Cheaper and earlier, but noncompliant. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-3F7D92 | Quote | 6061 AMS 4117 bar | Sable / Meridian | Rejected | Great Lakes is not approved for the AMS 4117 specification family. | The material callout match alone is insufficient. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-8A1D63 | Quote | 15-5PH H1025 bar | Meridian / Calder | Not selected | China melt is barred for Meridian; Calder is covered by eligible on-hand stock. | Lower cost is irrelevant to Meridian compliance and unnecessary for Calder. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
| QTE-9A2E57 | Quote | 4340 normalized plate | Halcyon only | Selected with restriction | China melt is ineligible for Sable but acceptable for Halcyon under its documented None restriction. | $5.45/lb is the lowest compliant Halcyon option. | supplier_quote_leadtime_matrix.xlsx + AMSL/policy/program rules |
Escalations
| Required Escalations and Leadership Decisions | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| These items require an explicit owner or decision. Compliance exclusions remain authoritative while an issue is open. | |||||||||
| Escalation ID | Type | Applies To | Owner | Trigger / Issue | Required Action | Decision / Due Date | Plan Effect | Do Not Assume | Severity |
| E-01 | Schedule | REQ-L8Q4 / PRG-SABLE | PMO, Planning, Sourcing, Quality | Brunderman receipt is 2026-08-26, only 2 days before the 2026-08-28 need-by. | Confirm the tentative requirement and accept the documented 2-day inspection/processing window before committing; otherwise escalate as unresolved. | 46239 | Plan is only conditionally covered. | No expedite or later dock acceptance. | High |
| E-02 | Commercial | All 12 selected quote lines | Sourcing leadership | The coverage plan is not secured until quotes are released before their stated expiries. | Execute immediate lines and obtain planner/program authorization for tentative-only lines by each quote expiry. | 46217 | 15 requirements depend partly or fully on purchase action. | No quote extension, capacity hold, or price continuation. | High |
| E-03 | Quality hold | LOT-B3E7C0 | MRB / Quality | 15-5PH plate has an open MRB hold for surface pitting. | Maintain exclusion; disposition separately. The recommended purchase plan does not rely on clearance. | 847 | No hold clearance or waiver. | Medium | |
| E-04 | Receiving hold | LOT-8F4D17 | Receiving Inspection / Quality | 17-4PH bar is awaiting receiving inspection. | Maintain exclusion. If Calder tentative demand remains, use the selected compliant quote unless a documented release occurs before commitment. | 46226 | 212.50 yield-adjusted lb is excluded; Calder purchase remains conditional. | No automatic release from hold. | Medium |
| E-05 | Certification | LOT-D6B821; LOT-4A8D62; QTE-B6D2A9 | Quality and Sourcing | C of C-only material does not meet the 3.1 minimum. | Reject from certified-production planning and preserve the documented compliant alternatives. | 862 | No certificate correction or equivalence. | High | |
| E-06 | Source / traceability | LOT-1D6B43; LOT-1F9D63; LOT-4D1A95; related quotes | Supplier Quality / MRB | Not Approved, Suspended, Conditional, or less-than-Full traceability records are ineligible. | Keep excluded from new allocations; address supplier status separately from this sourcing plan. | 869 | No retroactive approval or traceability repair. | High | |
| E-07 | Country of origin | Raven, Sable, Meridian, Tundra restricted lines | Program Quality / Sourcing | Several China/Russia lots and low-price quotes match physically but violate DFARS or CUST-EU. | Maintain program-specific exclusions shown in the lot/quote tests. | 876 | No customer waiver or origin exception. | High | |
| E-08 | Planning authority | REQ-L8Q4; REQ-G2J9; REQ-Y8K2; REQ-S6P3; REQ-U4B8 | Materials Planning / Program offices | Five tentative requirements need purchase material; one shared order also supports a firm line. | Confirm whether each tentative line remains in scope before its selected quote expires; retain the workbook's conditional action labels. | 46222 | Full-cycle cost includes these lines; deferral creates uncovered forecast demand. | No automatic MRP firming. | Medium |
| E-09 | Yield / MOQ | REQ-H7D5; REQ-S6P3; REQ-E9C1 | Sourcing and program leadership | Documented yield creates residuals below supplier MOQs, including a 1.75 lb extrusion shortfall. | Approve the documented MOQ buys or accept the requirements as short; preserve purchase surplus for future eligible demand. | 46217 | 518.75 lb of purchase surplus and its cost are visible in Purchase Plan. | No yield uplift, rounding, or allocation change. | Medium |
MATERIAL SOURCING RECOMMENDATION
2026 Q3 Door / Hinge Mechanism Build Wave
To
Sourcing, Production, Quality, MRB, and Program Leadership
From
Material Sourcing Review
Date
20 June 2026 — source-packet review basis
Subject
Compliant allocation, supplier quote, and escalation plan for certified aerospace raw material
Decision at a glance
26 requirements
Inventory-only
Purchase-dependent
All 26 are coverable after the stated actions
11 requirements
15 requirements
Inventory applied
Recommended PO quantity
Full-cycle PO cost
5,857.25 lb
3,621.50 lb (518.75 lb surplus)
$32,288.42
Disposition: approve the documented compliant inventory allocations; release the eight firm/shared quote lines before expiry; obtain an immediate Sable decision on REQ-L8Q4; and condition the remaining three tentative-only buys on planner confirmation. No held, C-of-C-only, untraceable, unapproved, conditional, suspended, origin-restricted, or undocumented substitute material is counted.
Decision basis: the attached packet as of 20 June 2026. This is not a representation that a quoted price, capacity slot, or expiry remains valid outside that review cycle.
1. Executive recommendation
The recommended plan is compliance-first and priority-driven. It covers the 8,960.00 lb net usable forecast with 5,857.25 lb of compliant on-hand material and 3,102.75 lb applied from selected purchases. The purchase orders total 3,621.50 lb because three residuals fall below documented supplier minimums, creating 518.75 lb of purchase surplus.
Approve the inventory allocation sequence exactly as documented. Raven and Sable receive first claim on contested eligible lots; origin-specific eligibility is applied before priority, so China-melt stock is reserved only where the program rules permit it.
Release the eight quote lines supporting firm demand, including the shared Meridian/Tundra extrusion buy, before their stated expiries. This immediate tranche totals $25,503.77.
Decide Sable REQ-L8Q4 immediately. QTE-6D1B84 is compliant but serves a tentative requirement and docks only two calendar days before need-by. Its $1,980.30 commitment should proceed only with PMO/planner and Quality acceptance of that documented margin.
Condition three tentative-only buys—QTE-9E4B27, QTE-7E2A85, and QTE-1A6E38—on planner confirmation. Together they add $4,804.35. Tundra REQ-Y8K2 is tentative but rides the selected shared extrusion order.
Maintain every quality and compliance exclusion. Apparent stock, low price, or earlier receipt does not cure a C of C, hold, traceability gap, source-status failure, country restriction, temper mismatch, or form mismatch.
2. Program coverage and allocation outcome
Program
Rule
Demand
Inventory
Purchase
Residual
Status
Raven
DFARS
2,027.00
1,525.60
501.40
0.00
PO action required
Sable
DFARS
1,218.00
339.20
878.80
0.00
PO + urgent tentative decision
Meridian
CUST-EU
1,628.00
1,252.70
375.30
0.00
PO / planner action required
Tundra
CUST-EU
1,309.00
739.00
570.00
0.00
PO / planner action required
Halcyon
None
1,660.00
1,201.50
458.50
0.00
PO / planner action required
Calder
None
1,118.00
799.25
318.75
0.00
PO / planner action required
Total
-
8,960.00
5,857.25
3,102.75
0.00
Coverable after actions
All six programs are coverable in the model, but only after the selected commercial actions. A zero modeled residual therefore means “coverable under the recommendation,” not “already secured.”
Priority-sensitive inventory decisions
7075-T7351 plate: allocate all 516.60 usable lb of LOT-7F3A2B to Raven; use Cascade QTE-A3F91C for Raven’s 325.40 lb residual and all 268.00 lb of Sable demand. China-origin LOT-5C9A16 is not eligible for either DFARS program.
4340 AMS 6415 bar: allocate LOT-3E8C71’s 416.00 lb and 199.00 lb of LOT-9A4F37 to Raven; the remaining 45.00 lb goes to Calder, whose 160.00 lb residual triggers Great Lakes’ 250 lb MOQ.
15-5PH AMS 5862 Cond A plate: allocate 394.00 lb of LOT-6B2F39 to Raven and its 106.20 lb balance to Sable. Ardenne QTE-3A9F18 covers Sable’s 323.80 lb residual and Tundra’s 357.00 lb.
6061 AMS 4117 bar: allocate 233.00 lb to Sable first and 4.80 lb to Meridian; only Cascade is both quoted and approved for AMS 4117.
7075-T6511 extrusion: Tundra receives 455.00 lb first. The two eligible lots then leave Calder 1.75 lb short; that residual cannot be rounded away and causes a 250 lb MOQ purchase.
3. Supplier quote actions
The selected lines are exact material matches, offer 3.1 certification, originate from a source approved for the applicable specification family, satisfy the assigned program’s origin rule, and dock before need-by. Order quantity equals the applied quantity unless the documented MOQ is higher.
Quote
Material
Order lb
Receipt / margin
Expiry
PO cost
Action
QTE-D9F3B1
4340 AMS 6415 bar
250.00
07-23 / 113d
07-14
$1,337.50
Immediate - firm; 90.00 lb surplus
QTE-8B3F19
300M AMS 6419 bar
176.00
07-26 / 8d
07-14
$2,499.20
Immediate - Raven
QTE-A3F91C
7075-T7351 plate
593.40
07-30 / 11d
07-15
$5,577.96
Immediate - Raven/Sable
QTE-2D7C64
2024-T3511 extrusion
236.10
08-02 / 47d
07-19
$1,794.36
Immediate - shared firm/tentative
QTE-3A9F18
15-5PH Cond A plate
680.80
08-06 / 18d
07-20
$7,999.40
Immediate - Sable/Tundra
QTE-9E4B27
7075-T651 plate
250.00
08-04 / 92d
07-20
$2,175.00
Conditional - Halcyon tentative; 180.50 lb surplus
QTE-C1E7B4
7075-T6511 extrusion
250.00
08-03 / 103d
07-22
$2,225.00
Immediate - 1.75 lb Calder residual; 248.25 lb surplus
QTE-7E2A85
17-4PH H1075 bar
157.00
08-15 / 95d
07-23
$1,742.70
Conditional - Calder tentative
QTE-2F8C41
15-5PH H1025 bar
198.00
08-09 / 36d
07-23
$1,950.30
Immediate - Meridian
QTE-1A6E38
6061 AMS 4117 bar
154.20
08-12 / 35d
07-25
$886.65
Conditional - Meridian tentative
QTE-9A2E57
4340 AMS 6359 plate
389.00
08-18 / 75d
08-02
$2,120.05
Immediate - Halcyon only
QTE-6D1B84
4340 AMS 6359 plate
287.00
08-26 / 2d
08-05
$1,980.30
Urgent decision - Sable tentative
Total
12 quote lines
3,621.50
-
-
$32,288.42
518.75 lb purchase surplus
Receipt / margin shows the quoted dock date and calendar days to the earliest assigned need-by. The policy does not provide a numeric minimum margin; the two-day Sable window is therefore shown explicitly and escalated rather than silently deemed adequate.
Commercial tradeoffs
Cascade T7351 is selected over the cheaper Hangzhou line because China melt is ineligible for Raven/Sable; Great Lakes is higher-priced and misses Raven’s need-by.
Ardenne 15-5PH plate is selected over Volga and Lone Star because the latter fail source/origin rules; Adriatic is compliant but costs more at the required quantity.
Great Lakes 4340 bar has a higher unit price than Brunderman, but its 250 lb MOQ produces a lower total commitment than Brunderman’s 300 lb MOQ for Calder’s 160 lb residual.
Yellow River 4340 plate is selected only for Halcyon, whose restriction is None. The same China-melt quote is not usable for Sable.
Adriatic 17-4PH is selected for Calder because its 150 lb MOQ permits a 157 lb order; Pohang has a lower unit price but a 200 lb MOQ and therefore a higher total commitment.
MOQ-driven overbuy
Requirement
Applied purchase
MOQ order
Surplus
Reason
REQ-H7D5
160.00
250.00
90.00
4340 bar residual after Raven priority allocation
REQ-S6P3
69.50
250.00
180.50
Tentative 7075-T651 plate residual
REQ-E9C1
1.75
250.00
248.25
Yield-adjusted 7075 extrusion shortage
4. Compliance exclusions and rejected alternatives
The following examples are intentionally excluded from coverage even though they are physically present, lower-priced, earlier, or otherwise commercially attractive.
Candidate
Physical / commercial attraction
Authoritative exclusion
LOT-5C9A16
736.00 usable lb of 7075-T7351 plate
China melt; ineligible for the only listed T7351 demands, Raven and Sable.
LOT-D6B821
592.80 usable lb of 4340 bar
C of C only; no reported test results meeting 3.1.
LOT-B3E7C0
979.40 usable lb of 15-5PH plate
Open Quality Hold - MRB for surface pitting.
LOT-2B7E54
214.60 usable lb of 300M bar
China melt; ineligible for Raven.
LOT-8F4D17
212.50 usable lb of 17-4PH bar
Open receiving-inspection hold.
LOT-1D6B43
664.00 usable lb of 15-5PH plate
Volga is Not Approved; Russia melt also conflicts with restricted programs.
LOT-1F9D63
653.60 usable lb of 6061 plate
Source Suspended and heat traceability less than Full.
LOT-4A8D62
588.00 usable lb of 7075-T651 plate
C of C only.
LOT-4D1A95
437.40 usable lb of 15-5PH plate
Conditional source; ineligible for new commitments.
QTE-7D2B40
$6.85/lb T7351, 07-22 dock
China melt; unusable for Raven/Sable despite price and timing.
QTE-B6D2A9
$4.95/lb 4340 bar, 07-15 dock
C of C only; unusable for certified hardware.
QTE-3F7D92
Exact 6061 AMS 4117 bar callout
Great Lakes is not approved for AMS 4117.
QTE-4E9A72
$9.55/lb 300M, 07-19 dock
China melt; unusable for Raven.
QTE-9C4E27
$8.10/lb 15-5PH plate
Volga Not Approved and Russia melt.
QTE-6F1A93
Earlier 15-5PH plate dock
Lone Star is Conditional and ineligible for a new commitment.
No substitutions used
7075-T651 and 7075-T7351 remain separate. Neither is used to fill the other.
Plate, bar, and extrusion remain separate; no product-form interchange is used.
15-5PH and 17-4PH are used only in the called-out condition; Cond A is not treated as an H-condition.
AMS 6415 4340 bar, AMS 6359 4340 plate, and AMS 6419 300M remain distinct.
5. Required escalations and control actions
Priority
Issue / owner
Required control
Plan consequence
High
Sable REQ-L8Q4 — PMO, Planning, Sourcing, Quality
Confirm tentative demand and accept the 2-day dock-to-need window before QTE-6D1B84 is committed.
Without that decision, the requirement is not secured; no compliant qualifying-origin substitute is documented.
High
Selected quote expiries — Sourcing
Release immediate lines and authorize conditional lines by their exact expiries, beginning 07-14.
No price continuation, capacity hold, or quote extension is assumed.
High
C of C / source / traceability exclusions — Quality and Supplier Quality
Keep blocked lots and quotes out of certified-production allocations.
Physical availability does not become usable coverage.
High
Country-of-origin restrictions — Program Quality and Sourcing
Maintain requirement-level DFARS and CUST-EU screens.
Cheaper China/Russia alternatives remain unusable for restricted programs.
Medium
LOT-B3E7C0 and LOT-8F4D17 holds — MRB / Receiving Inspection
Disposition separately; do not plan against either lot while open.
The baseline purchase plan does not assume clearance.
Medium
Five purchase-dependent tentative requirements — Planning / Programs
Confirm REQ-L8Q4, REQ-G2J9, REQ-Y8K2, REQ-S6P3, and REQ-U4B8 before quote expiry.
Full-cycle cost includes them; deferral leaves forecast exposure.
Medium
MOQ overbuy — Sourcing / Programs
Approve 518.75 lb of documented surplus or accept the three residuals as shortages.
No yield uplift, rounding waiver, or allocation change is authorized.
6. Basis and limitations
This recommendation uses only the attached demand forecast, inventory/certification snapshot, AMSL, quote matrix, ENG-MSP Rev H, and PC-2026-0618 program schedule. It applies the packet’s fixed quantities, allocations, yield factors, dates, approvals, certificates, traceability records, hold status, origins, and program priorities.
No alternate alloy, temper, condition, form, or specification is introduced.
No engineering approval, MRB disposition, customer waiver, expedite, supplier capacity, certificate correction, yield change, or allocation release is assumed.
Quoted receipt is compared directly with need-by; schedule margins are shown rather than supplemented with an invented threshold.
The supporting workbook contains the complete lot-to-requirement and quote-to-requirement pass/fail tests, formulas, allocation sequence, alternatives, and escalation register.
Source packet
File
Controlled basis used
material_demand_forecast.xlsx
MRP-2026-0619-R2; 26 requirement lines and raw-material need-by dates
inventory_lot_cert_snapshot.xlsx
WMS-EXP-20260620-0741 joined to QMS lot records; allocations and yield
approved_material_source_list.xlsx
QE-AMSL Rev N, effective 2026-06-01
supplier_quote_leadtime_matrix.xlsx
RFQ responses received 2026-06-12 through 2026-06-19
engineering_material_substitution_policy.pdf
ENG-MSP Rev H, effective 2026-05-15
program_priority_build_schedule.docx
PC-2026-0618, status as of 2026-06-19
Appendix A — Requirement-level allocation plan
Raven — Priority 1 | DFARS | build start 2026-08-17
Requirement
Exact callout
Need
Inventory
Purchase
Route
Allocation / action
REQ-C9T1
300M | AMS 6419 | Annealed bar
08-03
-
176.00
PO
Brunderman QTE-8B3F19; China options rejected.
REQ-K9P1
4340 | AMS 6415 | Annealed bar
08-05
615.00
-
Inventory
LOT-3E8C71 416.00 + LOT-9A4F37 199.00.
REQ-H4A2
7075 | /12 | T7351 plate
08-10
516.60
325.40
Mixed
LOT-7F3A2B + Cascade QTE-A3F91C.
REQ-X5M3
15-5PH | AMS 5862 | Cond A plate
08-12
394.00
-
Inventory
LOT-6B2F39; held/status-blocked lots excluded.
Sable — Priority 2 | DFARS | build start 2026-08-31
Requirement
Exact callout
Need
Inventory
Purchase
Route
Allocation / action
REQ-B6N3
7075 | /12 | T7351 plate
08-22
-
268.00
PO
Shared Cascade QTE-A3F91C after Raven.
REQ-T2C7
15-5PH | AMS 5862 | Cond A plate
08-24
106.20
323.80
Mixed
LOT-6B2F39 remainder + Ardenne QTE-3A9F18.
REQ-F6B8
6061 | AMS 4117 | T651 bar
08-26
233.00
-
Inventory
LOT-7E1C95; Sable receives first claim.
REQ-L8Q4
164 more paragraphs not shown.
User prompt → 51 turns · 38 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 deliverables require an auditable requirement-level workb…
I’m using the spreadsheet and Word-document skills because the deliverables require an auditable requirement-level workbook and a polished leadership memo. I’ll first map the source packet and its governing constraints, then build and validate both files in
/workspace/output/.7exec1
Tool execution only — no assistant text
execconst p = await tools.update_plan({plan:[ {step:"Inspect the attached packet and read the document/spreadsheet skill instructions",status:"in_progress"}, {step:"Analyze demand, inventory/certifications, approved sources, quotes, substitution policy, and program priorities",status:"pending"}, {step:"Build and validate the sourcing analysis workbook",status:"pending"}, {step:"Draft and validate the recommendation memo",status:"pending"}, {step:"Cross-check both deliverables for consistency and hand off",status:"pending"} ]}); const r = await tools.e
Arguments
const p = await tools.update_plan({plan:[ {step:"Inspect the attached packet and read the document/spreadsheet skill instructions",status:"in_progress"}, {step:"Analyze demand, inventory/certifications, approved sources, quotes, substitution policy, and program priorities",status:"pending"}, {step:"Build and validate the sourcing analysis workbook",status:"pending"}, {step:"Draft and validate the recommendation memo",status:"pending"}, {step:"Cross-check both deliverables for consistency and hand off",status:"pending"} ]}); const r = await tools.e… 311 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.1 seconds Output: plan: {} files: chunk_id: dae71f wall_time_seconds: 0.000008951 exit_code: 0 original_token_count: 99 output: | /workspace /root/.agents/skills/docx/SKILL.md /root/.agents/skills/xlsx/SKILL.md /workspace/data/approved_material_source_list.xlsx /workspace/data/engineering_material_substitution_policy.pdf /workspace/data/inventory_lot_cert_snapshot.xlsx /workspace/data/material_demand_forecast.xlsx /workspace/data/program_priority_build_schedule.docx /workspace/data/supplier_quote_leadtime_matrix.xlsx8Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"sed -n '1,260p' /root/.agents/skills/xlsx/SKILL.md && sed -n '1,320p' /root/.agents/skills/docx/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":40000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: --- name: 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 from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python
… 20,266 more characters of output in the raw trajectory.
9Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"wc -l /root/.agents/skills/xlsx/SKILL.md /root/.agents/skills/docx/SKILL.md && sed -n '261,620p' /root/.agents/skills/xlsx/SKILL.md && sed -n '321,760p' /root/.agents/skills/docx/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":40000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: 291 /root/.agents/skills/xlsx/SKILL.md 590 /root/.agents/skills/docx/SKILL.md 881 total } } ``` ## 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_ex… 10,597 more characters of output in the raw trajectory.
10Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"cat /root/.agents/skills/xlsx/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: 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 from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python
… 10,972 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:"sed -n '1,300p' /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: --- name: docx description: "Use this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation." license: Proprietary. LICENSE.txt has complete t
… 9,513 more characters of output in the raw trajectory.
12Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"sed -n '301,590p' /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: }) // Dot leader (e.g., TOC-style) new Paragraph({ children: [ new TextRun("Introduction"), new TextRun({ children: [ new PositionalTab({ alignment: PositionalTabAlignment.RIGHT, relativeTo: PositionalTabRelativeTo.MARGIN, leader: PositionalTabLeader.DOT, }), "3", ]}), ], }) ``` ### Multi-Column Layouts ```javascript // Equal-width columns sections: [{ properties: { column: { count: 2, // number of columns space: 720, // gap between columns in DXA (720 = 0.5 inch) equalWidth: true, separate: true, // vertical line between columns }, }, children: [/* content flows naturally across columns */] }] // Custom-width columns (equalWidth must be false) sections: [{ properties: { column: { equalWidth: false,… 9,403 more characters of output in the raw trajectory.
13The packet also includes a governing substitution-policy PDF, so I’m adding the PDF skill to extract and verify that pol…
The packet also includes a governing substitution-policy PDF, so I’m adding the PDF skill to extract and verify that policy before making any usability or substitution judgments. Its constraints will be treated as controlling where commercial availability conflicts with certification or approval rules.
14Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"cat /root/.agents/skills/pdf/SKILL.md","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":40000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: --- name: pdf description: Use this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill. license: Proprietary. LICENSE.txt has complete terms --- # PDF Processing Guide ## Overview This guide covers essential PDF processing operations using Python libraries and command-line tools. For advanced features, JavaScript libraries, and detailed examples, see REFERENCE.md. If you need to fill out a PDF form, read FORMS.md and follow its instructions. ## Quick Start ```python from pypdf im
… 7,489 more characters of output in the raw trajectory.
15I’ve located six source files and am now reconciling them at the requirement/lot/quote level. I’m preserving exact ident…
I’ve located six source files and am now reconciling them at the requirement/lot/quote level. I’m preserving exact identifiers and will only count quantities after allocations and documented yield loss; “on hand” or “available” alone will not qualify material.
16Shell1
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 p in sorted(Path('/workspace/data').glob('*.xlsx')):\n print(f'FILE: {p.name}')\n wb = load_workbook(p, data_only=False, read_only=True)\n for ws in wb.worksheets:\n print(f' SHEET: {ws.title} rows={ws.max_row} cols={ws.max_column}')\n for row in ws.iter_rows(values_only=True):\n print(' ', tuple(row))\n print()\nPY\npandoc --track-changes=all /workspace/data/program_priority_build_schedule.docx -t plain\… 186 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.9 seconds Output: FILE: approved_material_source_list.xlsx SHEET: Source List rows=13 cols=9 ('Source ID', 'Source Name', 'Source Type', 'Approved Spec Families', 'Melt Country', 'Origin Qualifying Status', 'Approval Status', 'Approval Expiry', 'Note') ('SRC-9F2A41', 'Cascade Rolled Products LLC', 'Mill', 'AMS-QQ-A-250, AMS-QQ-A-200, AMS 4117', 'USA', 'Qualifying (USA)', 'Approved', '2027-03-31', 'Aluminum plate/extrusion/bar') ('SRC-3B7C19', 'Ardenne Steelworks SA', 'Mill', 'AMS 5862, AMS 5659, AMS 5604', 'France', 'Qualifying (non-US)', 'Approved', '2026-12-31', 'PH stainless; qualifying country (FR)') ('SRC-D14E8B', 'Tri-State Metals Distribution', 'Distributor', 'AMS-QQ-A-250, AMS-QQ-A-200, AMS 6415, AMS 6359', 'USA', 'Qualifying (USA)', 'Approved', '2027-06-30', 'Distributor; passes mill c… 34,999 more characters of output in the raw trajectory.
17Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"rg --files /root/.agents/skills/docx | sort | sed -n '1,200p' && rg --files /root/.agents/skills/xlsx | sort | sed -n '1,200p'","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":20000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: /root/.agents/skills/docx/LICENSE.txt /root/.agents/skills/docx/SKILL.md /root/.agents/skills/docx/scripts/__init__.py /root/.agents/skills/docx/scripts/accept_changes.py /root/.agents/skills/docx/scripts/comment.py /root/.agents/skills/docx/scripts/office/helpers/__init__.py /root/.agents/skills/docx/scripts/office/helpers/merge_runs.py /root/.agents/skills/docx/scripts/office/helpers/simplify_redlines.py /root/.agents/skills/docx/scripts/office/pack.py /root/.agents/skills/docx/scripts/office/schemas/ISO-IEC29500-4_2016/dml-chart.xsd /root/.agents/skills/docx/scripts/office/schemas/ISO-IEC29500-4_2016/dml-chartDrawing.xsd /root/.agents/skills/docx/scripts/office/schemas/ISO-IEC29500-4_2016/dml-diagram.xsd /root/.agents/skills/docx/scripts/office/schemas/ISO-IEC29500-4_2016/dml-lockedCanvas.xsd /root/.agents/skills/docx/scripts/office/schemas/ISO-IEC29500
… 8,176 more characters of output in the raw trajectory.
18Shell1
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 docx2txt || true\ncommand -v unzip || true","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":10000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: /usr/bin/libreoffice /usr/bin/soffice
19Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"review_tmp=$(mktemp -d)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to 'txt:Text' --outdir \"$review_tmp\" /workspace/data/program_priority_build_schedule.docx\nsed -n '1,260p' \"$review_tmp/program_priority_build_schedule.txt\"","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 2.7 seconds Output: Warning: failed to launch javaldx - java may not function correctly convert /workspace/data/program_priority_build_schedule.docx as a Writer document -> /tmp/tmp.NljItVtPke/program_priority_build_schedule.txt using filter : Text Program Priority & Build Schedule 2026 Q3 Door/Hinge Mechanism Build Wave — Production Control Release PC-2026-0618 Issued by: Production Control & Program Management Office (PMO). Distribution: Sourcing, Materials Planning, Quality, MRB. Status as of 2026-06-19. 1. Purpose This release fixes program priority ranking and committed build dates for the current review cycle. Where multiple programs compete for the same eligible material, allocation shall favor the higher-priority program (lower priority rank number). Contractual country-of-origin and specialty-metals restrictions stated in Section 3 are flowed from the customer contr
… 3,220 more characters of output in the raw trajectory.
20The controlling reconciliation is now clear: exact-callout, certification, traceability, source, origin, allocation, and…
The controlling reconciliation is now clear: exact-callout, certification, traceability, source, origin, allocation, and yield checks leave 11 requirements fully covered by inventory; the other 15 need some purchase action. Three small residuals also trigger minimum-order overbuy, so I’m separating “material applied to demand” from “PO quantity/cost” in the workbook.
21Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const d = await tools.exec_command({cmd:"mkdir -p /workspace/output","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":10000}); const p = await tools.apply_patch("*** Begin Patch\n*** Add File: /workspace/build_material_review.py\n+from pathlib import Path\n+from datetime import date, datetime\n+\n+from openpyxl import Workbook, load_workbook\n+from openpyxl.comments import Comment\n+from openpyxl.formatting.rule import FormulaRule\n+from openpyxl.styles import Alignment, Border, Font, PatternFill, Side\n+from openpyxl.worksheet.table import Table,… 84,838 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.1 seconds Output: mkdir: chunk_id: 1029db wall_time_seconds: 0.000017989 exit_code: 0 original_token_count: 0 output: "" patch: {}22Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python -m py_compile /workspace/build_material_review.py && python /workspace/build_material_review.py","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 2.3 seconds Output: /workspace/output/material_sourcing_analysis_workbook.xlsx
23Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python /root/.agents/skills/xlsx/scripts/recalc.py /workspace/output/material_sourcing_analysis_workbook.xlsx 120","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 4.7 seconds Output: status: success total_errors: 0 error_summary: {} total_formulas: 381624The workbook model is built and recalculated successfully with 3,816 formulas and zero Excel errors. I’m now auditing th…
The workbook model is built and recalculated successfully with 3,816 formulas and zero Excel errors. I’m now auditing the computed allocation sequence, program totals, selected quote quantities, and cross-sheet status flags before drafting the memo from the validated numbers.
25Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"python - <<'PY'\nfrom openpyxl import load_workbook\np='/workspace/output/material_sourcing_analysis_workbook.xlsx'\nwb=load_workbook(p,data_only=True,read_only=True)\nfor s, cols in [('Executive Summary',12),('Requirement Coverage',21),('Purchase Plan',21),('Allocation Detail',15),('Escalations',10)]:\n ws=wb[s]\n print('\\nSHEET',s,ws.max_row,ws.max_column)\n if s=='Executive Summary':\n for r in range(4,19):\n print(r,[ws.cell(r,c).value for c in range(1,13)])\n for r in range(21,28): print(r,[… 244 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.2 seconds Output: SHEET Executive Summary 43 12 4 ['Review as-of', datetime.datetime(2026, 6, 20, 0, 0), None, 'Decision posture', 'Compliance-first; exact callout; fixed allocations/yield; program priority', None, None, None, None, None, None, None] 5 [None, None, None, None, None, None, None, None, None, None, None, None] 6 ['Coverage & Cost Metrics', None, None, None, None, None, 'Leadership Recommendation', None, None, None, None, None] 7 ['Total requirements', 26, None, 'Residual shortage after plan (lb)', 0, None, 'Release the eight quote lines supporting firm demand (including shared firm/tentative buys) before their stated expiries.', None, None, None, None, None] 8 ['Firm requirements', 20, None, 'Compliant inventory applied (lb)', 5857.25, None, 'Obtain immediate PMO/planner direction on Sable REQ-L8Q4: its only compliant quote has a 2-day dock-to-n
… 30,092 more characters of output in the raw trajectory.
26Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"node -e \"console.log(require.resolve('docx'))\"","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":10000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: node:internal/modules/cjs/loader:1433 throw err; ^ Error: Cannot find module 'docx' Require stack: - /workspace/[eval] at Function._resolveFilename (node:internal/modules/cjs/loader:1430:15) at Function.resolve (node:internal/modules/helpers:157:19) at [eval]:1:21 at runScriptInThisContext (node:internal/vm:209:10) at node:internal/process/execution:446:12 at [eval]-wrapper:6:24 at runScriptInContext (node:internal/process/execution:444:60) at evalFunction (node:internal/process/execution:279:30) at evalTypeScript (node:internal/process/execution:291:3) at node:internal/main/eval_string:74:3 { code: 'MODULE_NOT_FOUND', requireStack: [ '/workspace/[eval]' ] } Node.js v22.23.227Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"npm install --prefix /tmp/material-review-docx docx","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 2.1 seconds Output: added 22 packages in 2s 1 package is looking for funding run `npm fund` for details
28exec1
Tool execution only — no assistant text
execconst p = await tools.apply_patch("*** Begin Patch\n*** Add File: /workspace/build_material_memo.js\n+const fs = require(\"fs\");\n+const {\n+ AlignmentType, BorderStyle, Document, Footer, Header, HeadingLevel,\n+ LevelFormat, PageBreak, PageNumber, Paragraph, Packer, ShadingType,\n+ Table, TableCell, TableLayoutType, TableRow, TextRun, VerticalAlign,\n+ WidthType\n+} = require(\"docx\");\n+\n+const OUT = \"/workspace/output/material_sourcing_recommendation_memo.docx\";\n+const W = 9360;\n+const C = {\n+ navy: \"1F4E78\", blue: \"5B9BD5\", pale:
Arguments
const p = await tools.apply_patch("*** Begin Patch\n*** Add File: /workspace/build_material_memo.js\n+const fs = require(\"fs\");\n+const {\n+ AlignmentType, BorderStyle, Document, Footer, Header, HeadingLevel,\n+ LevelFormat, PageBreak, PageNumber, Paragraph, Packer, ShadingType,\n+ Table, TableCell, TableLayoutType, TableRow, TextRun, VerticalAlign,\n+ WidthType\n+} = require(\"docx\");\n+\n+const OUT = \"/workspace/output/material_sourcing_recommendation_memo.docx\";\n+const W = 9360;\n+const C = {\n+ navy: \"1F4E78\", blue: \"5B9BD5\", pale:… 33,279 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: [object Object]
29Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"NODE_PATH=/tmp/material-review-docx/node_modules node /workspace/build_material_memo.js && python /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx","workdir":"/workspace","yield_time_ms":30000,"max_output_tokens":30000}); text(r.output);Output
Script completed Wall time 2.6 seconds Output: /workspace/output/material_sourcing_recommendation_memo.docx Paragraphs: 0 → 584 (+584) All validations PASSED!
30Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"render_dir=$(mktemp -d)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx\npdfinfo \"$render_dir/material_sourcing_recommendation_memo.pdf\" | sed -n '1,30p'\npdftoppm -png -r 90 \"$render_dir/material_sourcing_recommendation_memo.pdf\" \"$render_dir/page\" >/dev/null 2>&1\ncommand -v montage || true\nfind \"$render_dir\" -maxdepth 1 -type f -printf '%f %s bytes\\n' | sort | sed -n '1,80p'","… 100 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/tmp.ogBDema4x3/material_sourcing_recommendation_memo.pdf using filter : writer_pdf_Export Title: Material Sourcing Recommendation Memo Subject: 2026 Q3 certified door and hinge mechanism raw-material sourcing review Author: OpenAI Codex Creator: Writer Producer: LibreOffice 25.2.3.2 (X86_64) / LibreOffice Community CreationDate: Thu Aug 20 17:53:06 2026 UTC Custom Metadata: no Metadata Stream: yes Tagged: yes UserProperties: no Suspects: no Form: none JavaScript: no Pages: 7 Encrypted: no Page size: 612 x 792 pts (letter) Page rot: 0 File size: 178778 bytes Optimized: n
… 245 more characters of output in the raw trajectory.
31exec1
Tool execution only — no assistant text
execconst r = await tools.view_image({path:"/tmp/tmp.ogBDema4x3/page-1.png",detail:"original"}); image(r.image_url);
Arguments
const r = await tools.view_image({path:"/tmp/tmp.ogBDema4x3/page-1.png",detail:"original"}); image(r.image_url);Output
Script completed Wall time 0.0 seconds Output:
… 4,696 more characters of output in the raw trajectory.
32The first visual render caught a document-generation defect: the memo’s layout rendered, but its text runs were empty. I…
The first visual render caught a document-generation defect: the memo’s layout rendered, but its text runs were empty. I’m correcting that now and will revalidate and re-render every page before delivery.
33exec1
Tool execution only — no assistant text
execconst p = await tools.apply_patch("*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n function tr(text, options = {}) {\n- return new TextRun({ font: \"Arial\", size: options.size || 20, bold: !!options.bold,\n+ return new TextRun({ text, font: \"Arial\", size: options.size || 20, bold: !!options.bold,\n*** End Patch"); text(String(p));
Arguments
const p = await tools.apply_patch("*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n function tr(text, options = {}) {\n- return new TextRun({ font: \"Arial\", size: options.size || 20, bold: !!options.bold,\n+ return new TextRun({ text, font: \"Arial\", size: options.size || 20, bold: !!options.bold,\n*** End Patch"); text(String(p));Output
Script completed Wall time 0.0 seconds Output: [object Object]
34Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"NODE_PATH=/tmp/material-review-docx/node_modules node /workspace/build_material_memo.js\npython /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx\nrender_dir=$(mktemp -d)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx\npdfinfo \"$render_dir/material_sourcing_recommendation_memo.pdf\" | rg 'Pages|Page size|File size'\npdftoppm -png -r 100 \"… 297 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 5.7 seconds Output: /workspace/output/material_sourcing_recommendation_memo.docx Paragraphs: 0 → 584 (+584) All validations PASSED! Warning: failed to launch javaldx - java may not function correctly convert /workspace/output/material_sourcing_recommendation_memo.docx as a Writer document -> /tmp/tmp.RJ6yZa39Mk/material_sourcing_recommendation_memo.pdf using filter : writer_pdf_Export Pages: 9 Page size: 612 x 792 pts (letter) File size: 297000 bytes /tmp/tmp.RJ6yZa39Mk/page-1.png 127745 /tmp/tmp.RJ6yZa39Mk/page-2.png 295116 /tmp/tmp.RJ6yZa39Mk/page-3.png 15590 /tmp/tmp.RJ6yZa39Mk/page-4.png 253237 /tmp/tmp.RJ6yZa39Mk/page-5.png 28213 /tmp/tmp.RJ6yZa39Mk/page-6.png 178837 /tmp/tmp.RJ6yZa39Mk/page-7.png 244351 /tmp/tmp.RJ6yZa39Mk/page-8.png 172612 /tmp/tmp.RJ6yZa39Mk/page-9.png 159363
35exec1
Tool execution only — no assistant text
execconst paths = Array.from({length:9},(_,i)=>`/tmp/tmp.RJ6yZa39Mk/page-${i+1}.png`); const rs = await Promise.all(paths.map(path=>tools.view_image({path,detail:"high"}))); rs.forEach((r,i)=>{ text(`Page ${i+1}`); image(r.image_url); });
Arguments
const paths = Array.from({length:9},(_,i)=>`/tmp/tmp.RJ6yZa39Mk/page-${i+1}.png`); const rs = await Promise.all(paths.map(path=>tools.view_image({path,detail:"high"}))); rs.forEach((r,i)=>{ text(`Page ${i+1}`); image(r.image_url); });Output
Script completed Wall time 0.1 seconds Output: Page 1
… 1,966,970 more characters of output in the raw trajectory.
36Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"rg -n \"PageBreak|heading\\(\\\"[3456]|Appendix\" /workspace/build_material_memo.js","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":10000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: 4: LevelFormat, PageBreak, PageNumber, Paragraph, Packer, ShadingType, 200: para([new PageBreak()]) 222: para([new PageBreak()]) 226: heading("3. Supplier quote actions", 1), 245: para([new PageBreak()]) 249: heading("4. Compliance exclusions and rejected alternatives", 1), 273: para([new PageBreak()]) 277: heading("5. Required escalations and control actions", 1), 287: heading("6. Basis and limitations", 1), 302: para([new PageBreak()]) 305:children.push(heading("Appendix A — Requirement-level allocation plan", 1));37exec1
Tool execution only — no assistant text
execconst p = await tools.apply_patch("*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n- bullet(\"7075-T6511 extrusion: Tundra receives 455.00 lb first. The two eligible lots then leave Calder 1.75 lb short; that residual cannot be rounded away and causes a 250 lb MOQ purchase.\"),\n- para([new PageBreak()])\n+ bullet(\"7075-T6511 extrusion: Tundra receives 455.00 lb first. The two eligible lots then leave Calder 1.75 lb short; that residual cannot be rounded away and causes a 250 lb MOQ purchase.\")\n );\n \n children.push(\n- heading(\"3
Arguments
const p = await tools.apply_patch("*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n- bullet(\"7075-T6511 extrusion: Tundra receives 455.00 lb first. The two eligible lots then leave Calder 1.75 lb short; that residual cannot be rounded away and causes a 250 lb MOQ purchase.\"),\n- para([new PageBreak()])\n+ bullet(\"7075-T6511 extrusion: Tundra receives 455.00 lb first. The two eligible lots then leave Calder 1.75 lb short; that residual cannot be rounded away and causes a 250 lb MOQ purchase.\")\n );\n \n children.push(\n- heading(\"3… 1,584 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: [object Object]
38Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"NODE_PATH=/tmp/material-review-docx/node_modules node /workspace/build_material_memo.js\npython /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx\nrender_dir=$(mktemp -d)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx\npdfinfo \"$render_dir/material_sourcing_recommendation_memo.pdf\" | rg 'Pages|Page size|File size'\npdftoppm -png -r 90 \"$… 296 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 5.2 seconds Output: /workspace/output/material_sourcing_recommendation_memo.docx Paragraphs: 0 → 580 (+580) All validations PASSED! Warning: failed to launch javaldx - java may not function correctly convert /workspace/output/material_sourcing_recommendation_memo.docx as a Writer document -> /tmp/tmp.MYatQIyvoX/material_sourcing_recommendation_memo.pdf using filter : writer_pdf_Export Pages: 8 Page size: 612 x 792 pts (letter) File size: 296078 bytes /tmp/tmp.MYatQIyvoX/page-1.png 107231 /tmp/tmp.MYatQIyvoX/page-2.png 243945 /tmp/tmp.MYatQIyvoX/page-3.png 206147 /tmp/tmp.MYatQIyvoX/page-4.png 23792 /tmp/tmp.MYatQIyvoX/page-5.png 150914 /tmp/tmp.MYatQIyvoX/page-6.png 204299 /tmp/tmp.MYatQIyvoX/page-7.png 150487 /tmp/tmp.MYatQIyvoX/page-8.png 138325
39exec1
Tool execution only — no assistant text
execconst paths = [3,4,5,6,7,8].map(i=>`/tmp/tmp.MYatQIyvoX/page-${i}.png`); const rs = await Promise.all(paths.map(path=>tools.view_image({path,detail:"high"}))); rs.forEach((r,i)=>{ text(`Page ${i+3}`); image(r.image_url); });
Arguments
const paths = [3,4,5,6,7,8].map(i=>`/tmp/tmp.MYatQIyvoX/page-${i}.png`); const rs = await Promise.all(paths.map(path=>tools.view_image({path,detail:"high"}))); rs.forEach((r,i)=>{ text(`Page ${i+3}`); image(r.image_url); });Output
Script completed Wall time 0.0 seconds Output: Page 3
… 1,165,126 more characters of output in the raw trajectory.
40exec1
Tool execution only — no assistant text
execconst p = await tools.apply_patch("*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n makeTable([\"Requirement\", \"Applied purchase\", \"MOQ order\", \"Surplus\", \"Reason\"], [\n [\"REQ-H7D5\", \"160.00\", \"250.00\", \"90.00\", \"4340 bar residual after Raven priority allocation\"],\n [\"REQ-S6P3\", \"69.50\", \"250.00\", \"180.50\", \"Tentative 7075-T651 plate residual\"],\n- [\"REQ-E9C1\", \"1.75\", \"250.00\", \"248.25\", \"Yield-adjusted 7075 extrusion short
Arguments
const p = await tools.apply_patch("*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n makeTable([\"Requirement\", \"Applied purchase\", \"MOQ order\", \"Surplus\", \"Reason\"], [\n [\"REQ-H7D5\", \"160.00\", \"250.00\", \"90.00\", \"4340 bar residual after Raven priority allocation\"],\n [\"REQ-S6P3\", \"69.50\", \"250.00\", \"180.50\", \"Tentative 7075-T651 plate residual\"],\n- [\"REQ-E9C1\", \"1.75\", \"250.00\", \"248.25\", \"Yield-adjusted 7075 extrusion short… 1,061 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: [object Object]
41Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"NODE_PATH=/tmp/material-review-docx/node_modules node /workspace/build_material_memo.js\npython /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx\nrender_dir=$(mktemp -d)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx\npdfinfo \"$render_dir/material_sourcing_recommendation_memo.pdf\" | rg 'Pages|Page size|File size'\npdftoppm -png -f 3 -l 4 -… 308 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 4.1 seconds Output: /workspace/output/material_sourcing_recommendation_memo.docx Paragraphs: 0 → 576 (+576) All validations PASSED! Warning: failed to launch javaldx - java may not function correctly convert /workspace/output/material_sourcing_recommendation_memo.docx as a Writer document -> /tmp/tmp.JDqca0vpCV/material_sourcing_recommendation_memo.pdf using filter : writer_pdf_Export Pages: 8 Page size: 612 x 792 pts (letter) File size: 294173 bytes /tmp/tmp.JDqca0vpCV/check-3.png 206147 /tmp/tmp.JDqca0vpCV/check-4.png 21798
42exec1
Tool execution only — no assistant text
execconst r = await tools.view_image({path:"/tmp/tmp.JDqca0vpCV/check-4.png",detail:"original"}); image(r.image_url);
Arguments
const r = await tools.view_image({path:"/tmp/tmp.JDqca0vpCV/check-4.png",detail:"original"}); image(r.image_url);Output
Script completed Wall time 0.0 seconds Output:
… 28,232 more characters of output in the raw trajectory.
43exec1
Tool execution only — no assistant text
execconst p = await tools.apply_patch("*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n- ], [1400, 1300, 1200, 1100, 4360], { size: 14, boldCols: [0], alignments: [AlignmentType.LEFT, AlignmentType.RIGHT, AlignmentType.RIGHT, AlignmentType.RIGHT, AlignmentType.LEFT], rowFill: () => C.yellow }),\n- para([tr(\"Total: \", { bold: true, size: 16, color: C.navy }), tr(\"231.25 lb applied through 750.00 lb of MOQ orders, creating 518.75 lb of surplus. No yield uplift, rounding, or MOQ exception is assumed.\", { size: 16 })], { spacing: { before: 45, afte
Arguments
const p = await tools.apply_patch("*** Begin Patch\n*** Update File: /workspace/build_material_memo.js\n@@\n- ], [1400, 1300, 1200, 1100, 4360], { size: 14, boldCols: [0], alignments: [AlignmentType.LEFT, AlignmentType.RIGHT, AlignmentType.RIGHT, AlignmentType.RIGHT, AlignmentType.LEFT], rowFill: () => C.yellow }),\n- para([tr(\"Total: \", { bold: true, size: 16, color: C.navy }), tr(\"231.25 lb applied through 750.00 lb of MOQ orders, creating 518.75 lb of surplus. No yield uplift, rounding, or MOQ exception is assumed.\", { size: 16 })], { spacing: { before: 45, afte… 279 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: [object Object]
44Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"NODE_PATH=/tmp/material-review-docx/node_modules node /workspace/build_material_memo.js\npython /root/.agents/skills/docx/scripts/office/validate.py /workspace/output/material_sourcing_recommendation_memo.docx\nrender_dir=$(mktemp -d)\npython /root/.agents/skills/docx/scripts/office/soffice.py --headless --convert-to pdf --outdir \"$render_dir\" /workspace/output/material_sourcing_recommendation_memo.docx\npdfinfo \"$render_dir/material_sourcing_recommendation_memo.pdf\" | rg 'Pages|Page size|File size'\npdftoppm -png -r 80 \"$… 296 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 4.9 seconds Output: /workspace/output/material_sourcing_recommendation_memo.docx Paragraphs: 0 → 575 (+575) All validations PASSED! Warning: failed to launch javaldx - java may not function correctly convert /workspace/output/material_sourcing_recommendation_memo.docx as a Writer document -> /tmp/tmp.0R4CUEu4gX/material_sourcing_recommendation_memo.pdf using filter : writer_pdf_Export Pages: 7 Page size: 612 x 792 pts (letter) File size: 292908 bytes /tmp/tmp.0R4CUEu4gX/page-1.png 93098 /tmp/tmp.0R4CUEu4gX/page-2.png 195986 /tmp/tmp.0R4CUEu4gX/page-3.png 171073 /tmp/tmp.0R4CUEu4gX/page-4.png 130799 /tmp/tmp.0R4CUEu4gX/page-5.png 179598 /tmp/tmp.0R4CUEu4gX/page-6.png 129377 /tmp/tmp.0R4CUEu4gX/page-7.png 118541
45exec1
Tool execution only — no assistant text
execconst paths = [3,4,5,6,7].map(i=>`/tmp/tmp.0R4CUEu4gX/page-${i}.png`); const rs = await Promise.all(paths.map(path=>tools.view_image({path,detail:"high"}))); rs.forEach((r,i)=>{ text(`Page ${i+3}`); image(r.image_url); });
Arguments
const paths = [3,4,5,6,7].map(i=>`/tmp/tmp.0R4CUEu4gX/page-${i}.png`); const rs = await Promise.all(paths.map(path=>tools.view_image({path,detail:"high"}))); rs.forEach((r,i)=>{ text(`Page ${i+3}`); image(r.image_url); });Output
Script completed Wall time 0.1 seconds Output: Page 3
… 972,230 more characters of output in the raw trajectory.
46Both deliverables now reconcile to the same plan. The memo has been visually reviewed page by page after conversion, and…
Both deliverables now reconcile to the same plan. The memo has been visually reviewed page by page after conversion, and the workbook’s allocation, purchase, and compliance checks all pass with zero residual shortage under the stated actions. I’m doing the final file-integrity and output-folder check now.
47Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"set -e\nunzip -t /workspace/output/material_sourcing_recommendation_memo.docx >/tmp/material_memo_zipcheck.txt\nunzip -t /workspace/output/material_sourcing_analysis_workbook.xlsx >/tmp/material_workbook_zipcheck.txt\npython - <<'PY'\nfrom openpyxl import load_workbook\np='/workspace/output/material_sourcing_analysis_workbook.xlsx'\nwbv=load_workbook(p,data_only=True,read_only=True)\nreq=wbv['Requirement Coverage']\nresidual=sum((req.cell(r,14).value or 0) for r in range(5,31))\npp=wbv['Purchase Plan']\nchecks=[pp.cell(r,21).value f… 538 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.1 seconds Output: /bin/bash: line 2: unzip: command not found
48Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"set -e\npython -m zipfile -t /workspace/output/material_sourcing_recommendation_memo.docx\npython -m zipfile -t /workspace/output/material_sourcing_analysis_workbook.xlsx\npython - <<'PY'\nfrom openpyxl import load_workbook\np='/workspace/output/material_sourcing_analysis_workbook.xlsx'\nwbv=load_workbook(p,data_only=True,read_only=True)\nreq=wbv['Requirement Coverage']\nresidual=sum((req.cell(r,14).value or 0) for r in range(5,31))\npp=wbv['Purchase Plan']\nchecks=[pp.cell(r,21).value for r in range(5,17)]\nprint({'sheets':len(wbv… 396 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 1.1 seconds Output: Done testing Done testing {'sheets': 16, 'residual_shortage_lb': 0, 'purchase_plan_checks': ['PASS'], 'requirement_rows': 26, 'selected_quotes': 12} /bin/bash: line 14: file: command not found49Shell1
Tool execution only — no assistant text
Shellvia exec
Arguments
const r = await tools.exec_command({cmd:"ls -lh /workspace/output && stat -c '%n | %s bytes | modified %y' /workspace/output/material_sourcing_recommendation_memo.docx /workspace/output/material_sourcing_analysis_workbook.xlsx","workdir":"/workspace","yield_time_ms":10000,"max_output_tokens":10000}); text(r.output);Output
Script completed Wall time 0.1 seconds Output: total 160K -rw-r--r-- 1 root root 132K Aug 20 17:50 material_sourcing_analysis_workbook.xlsx -rw-r--r-- 1 root root 28K Aug 20 17:54 material_sourcing_recommendation_memo.docx /workspace/output/material_sourcing_recommendation_memo.docx | 28058 bytes | modified 2026-08-20 17:54:45.783109565 +0000 /workspace/output/material_sourcing_analysis_workbook.xlsx | 134318 bytes | modified 2026-08-20 17:50:11.539974863 +0000
50exec1
Tool execution only — no assistant text
execconst r = await tools.update_plan({explanation:"Completed the packet reconciliation, built both deliverables, recalculated and audited the workbook, and validated plus visually reviewed the memo.","plan":[ {step:"Inspect the attached packet and read the document/spreadsheet skill instructions",status:"completed"}, {step:"Analyze demand, inventory/certifications, approved sources, quotes, substitution policy, and program priorities",status:"completed"}, {step:"Build and validate the sourcing analysis workbook",status:"completed"}, {step:"Draft and validate
Arguments
const r = await tools.update_plan({explanation:"Completed the packet reconciliation, built both deliverables, recalculated and audited the workbook, and validated plus visually reviewed the memo.","plan":[ {step:"Inspect the attached packet and read the document/spreadsheet skill instructions",status:"completed"}, {step:"Analyze demand, inventory/certifications, approved sources, quotes, substitution policy, and program priorities",status:"completed"}, {step:"Build and validate the sourcing analysis workbook",status:"completed"}, {step:"Draft and validate… 171 more characters of arguments in the raw trajectory.
Output
Script completed Wall time 0.0 seconds Output: [object Object]
51Completed both deliverables: - [Recommendation memo](/workspace/output/material_sourcing_recommendation_memo.docx) - [An…
Completed both deliverables:
- Recommendation memo
- Analysis workbook
Key result: 11 requirements are inventory-covered; 15 require purchases. The full plan uses 12 quotes totaling $32,288.42 and is coverable with zero residual shortage, subject to documented quote and tentative-demand decisions. Workbook validation found zero formula errors.
1 failure mode across 1 verifier failures
1Decision Audit Trail Fragmented or IncompleteView on Failure Modes ↗Deliverable Completion and Structure1 failure
Description
Must a reviewer join separate sheets or infer unstated links to connect an item or requirement with its inputs, alternatives, decision, rationale, quantities, and resulting economics?
Failure evidence · per affected verifier
Selected lots, rejected alternatives, selected and rejected quotes, and purchase cost for an at-risk requirement each live on a different sheet instead of one joined view.