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 3 of 5 Complete
Part Prioritization Complete
RFQ Tracker Complete
Should-Cost Model Complete
Supplier Scorecard Planned
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
In Development
Supplier Performance & Risk Scorecard
A structured scorecard for evaluating and ranking suppliers across delivery, quality, responsiveness, and risk. Designed for quarterly business reviews and strategic sourcing decisions.
Excel Planned
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