Sourcing Operations Portfolio
Kenyon Woodley
BS Manufacturing & Supply Chain Management
WWU  |  Graduating June 2026  |  Aerospace, Defense & Tech

I build sourcing and operations tools that solve workflow problems in manufacturing environments. I'm a senior at WWU studying manufacturing and supply chain management, with experience across sourcing, operations, and manufacturing workflows. I built this portfolio to show how I approach ambiguous operational problems: I break them down, structure the decision logic, and turn them into usable systems.

Most of these projects are grounded in workflow opportunities I observed firsthand during internships and applied work, especially in sourcing and manufacturing environments. The broader point is bigger than procurement alone. This portfolio is about how I think and build: identifying operational bottlenecks, defining the logic behind better decisions, and creating systems that are practical enough to actually be used.

Sourcing Operations Portfolio 4 of 5 Complete
Part Prioritization Complete
RFQ Tracker Complete
Should-Cost Model Complete
Supplier Scorecard Complete
Make vs. Buy Planned

Each tool addresses a distinct sourcing decision problem. Together they form a system, moving from triage to execution to cost analysis to supplier evaluation.

01
Excel — Scoring Engine
Part Prioritization Framework
Solves the triage problem: given a portfolio of 50-100 parts, which ones actually need attention first? A weighted scoring engine ranks parts across production impact, supply risk, cost exposure, and instability into defensible action categories. Outputs a ranked list with plain-language AI reason codes, ready for leadership review.
Excel Claude AI 60-Part Dataset V2
02
Excel — Lifecycle Tracker
Aerospace RFQ Tracker
Solves the visibility problem: RFQs disappear into inboxes and nobody knows what's overdue. A 10-tab, 27-column workbook tracks the full lifecycle from issuance through award, surfacing cycle time, compliance rates, savings against target, and supplier response patterns. No macros, no VBA, built for audit-ready aerospace sourcing.
Excel 60-RFQ Dataset V4
03
Python + Streamlit — Cost Engine
Parametric Should-Cost Model V2
Solves the negotiation problem: without an independent cost estimate, every supplier quote is a number you can't challenge. A Python engine produces a three-scenario price band (low / mid / high) for machined parts from parametric inputs. V2 adds STEP geometry ingestion, buy-to-fly derivation, AI narrative layer, and a live browser UI. Excel export included.
Python cadquery Streamlit Excel Live
04
Live
Supplier Performance & Risk Scorecard
A two-layer scoring engine for evaluating suppliers across delivery, quality, responsiveness, risk, and compliance. Built for aerospace and defense sourcing with deterministic scoring, compliance hard flags, and an AI narrative layer.
Python Streamlit Claude API
05
In Development
Make vs. Buy Decision Framework
A structured decision framework for evaluating insourcing vs. outsourcing trade-offs across cost, capacity, risk, and strategic fit. Built for sourcing teams presenting recommendations to operations leadership.
Excel Planned