On this page
PURPOSE
This page explains the methodologies, data sources, and calculations used to build the TechHub Dashboard. By documenting our approach, we aim to:
- Build trust with stakeholders through transparent practices.
- Enable informed decision-making by outlining the logic behind our metrics.
Questions or feedback? Email techhub@tamu.edu.
METHODOLOGY
Each metric below includes a plain-English summary, exact formula, variables, and notes/sources.
OPERATIONAL METRICS
Process speed
AVERAGE BUSINESS DAYS TO APPROVAL
Summary
We measure the time between when an order is placed and when it is approved in AggieBuy, counting only business days and excluding TAMU holidays. We then average that time across all standard orders.
Formula & Variables
Average = ( Σ round(T₂ − T₁) ) ÷ N
- T₁
- Order creation timestamp
- T₂
- Order approved timestamp
- N
- Number of standard orders
Process speed
AVERAGE BUSINESS DAYS TO FULFILL
Summary
We measure the time between approval in AggieBuy and when the TechHub team marks the order complete, counting only business days and excluding TAMU holidays. We then average across all standard orders.
Formula & Variables
Average = ( Σ round(T₃ − T₂) ) ÷ N
- T₂
- Order approved timestamp
- T₃
- Order fulfilled timestamp
- N
- Number of standard orders
Service level
ON-TIME DELIVERY RATE
Summary
Orders fulfilled within 5 business days of approval are considered “On Time.” The on-time rate is the share of standard orders that meet that target.
Formula & Variables
On-Time Rate = ( Σ Oᵢ ) ÷ N, where Oᵢ ∈ {0,1}
- Oᵢ
- 1 if order i fulfilled ≤ 5 business days after approval; else 0
- N
- Total number of standard orders
Efficiency
LABOR HOURS SAVED
Summary
Based on input from various Technology Services teams, we estimate TechHub reduces IT labor to acquire and provision technology by approximately 115 minutes for a single computer and 10 minutes for a single accessory. Because bulk purchases (≥10 of an identical item) are already more efficient for your team to handle, we estimate less time saved per item on these orders than on small orders.
Formula & Variables
Hours Saved = Σ [ (C × (115 if C ≤ 9 else 57.5)) + (A × (10 if A ≤ 9 else 5)) ] ÷ 60
- C
- Number of computers on an order
- A
- Number of accessories on an order
SALES METRICS
Sales
REVENUE
Summary
Total dollar value of orders submitted through the TechHub website.
Formula & Variables
Revenue = Σ Rᵢ
- Rᵢ
- Revenue for order i
SAVINGS METRICS
Cost avoidance
STANDARD TECHHUB SAVINGS
Summary
For each item sold, we compare TechHub’s price to the lowest available competitor price—either AggieBuy or online retail. If the competitor price is higher than TechHub’s, that difference counts as savings; if not, savings for that item are $0.
Formula & Variables
Savings = Σ max( min(Aᵢ, Rᵢ) − Tᵢ, 0 )
- Aᵢ
- AggieBuy price for item i (if available)
- Rᵢ
- Online retail price for item i (if available)
- Tᵢ
- TechHub price for item i
Cost avoidance
ALL-TIME UNIVERSITY SAVINGS
Summary
This metric includes all Standard TechHub Savings plus Custom Bulk Purchase Savings that occurred before the full launch of the TechHub eCommerce Platform. Custom Bulk Purchase Savings are calculated by comparing TechHub pricing of sold products against competitor pricing.
Formula & Variables
All-Time Savings = B + Σ max( min(Aᵢ, Rᵢ) − Tᵢ, 0 )
- B
- Custom Bulk Purchase savings (pre-launch aggregate)
- Aᵢ
- AggieBuy price for item i (if available)
- Rᵢ
- Online retail price for item i (if available)
- Tᵢ
- TechHub price for item i
DATA SOURCES
The following data sources power this dashboard. Updates from these systems are synced daily.
TECHHUB ECOMMERCE PLATFORM
- Sales — What has been purchased, when, by whom.
- Products — Category, commodity code, purchasing history.
INFLOW INVENTORY SOFTWARE (INTERNAL)
- Sales — Supplemental sales info (Requisition #, AggieBuy PO #, etc.).
- Vendors — HUB status, associated products, inventory purchases.
- Products — Cost history, current inventory levels, order history.
- Purchasing — All inventory purchasing details (cost, vendor, dates).
- Savings — Competitor pricing (AggieBuy and online retail) recorded for savings calculations.
AGGIEBUY
- Approval & Fulfillment Time — Timestamps across Requisition → P.O. → Invoicing stages.
- Savings — Monthly price checks for items we sell; lowest price recorded for comparison.
EXTERNAL SOURCES
- Savings — Monthly price checks for items we sell; lowest price recorded for comparison.
CONTRIBUTORS
DATA ANALYSTS
- Hank deVilleneuve
DATA ENGINEERS
- Jeff Phillips
- Hank deVilleneuve
PROJECT OWNERS
- Tom Wood
- Isaac Podolefsky
This page will be updated as new data sources and methodologies are incorporated into the dashboard.