Sourcing Operations Portfolio
Kenyon Woodley
Senior, Manufacturing & Supply Chain Management
Western Washington University  |  2026  |  Aerospace, Defense & Tech

I'm a senior at Western Washington University 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, but 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 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
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