Jun 8 • SQL and SOP Vault
Basic Variable Cost Per Unit By Order
SELECT
o.order_id,
o.order_date,
c.client_name,
COUNT(oi.sku) AS sku_count,
SUM(oi.quantity) AS total_units,
SUM(oi.item_cost + oi.labor_cost + oi.packaging_cost + oi.carrier_cost) AS total_cost,
ROUND(SUM(oi.item_cost + oi.labor_cost + oi.packaging_cost + oi.carrier_cost) / SUM(oi.quantity), 2) AS cpu,
CASE
WHEN o.order_date BETWEEN '2024-11-01' AND '2025-01-15' THEN 'Peak'
ELSE 'Off-Peak'
END AS season
FROM
orders o
JOIN
order_items oi ON o.order_id = oi.order_id
JOIN
clients c ON o.client_id = c.client_id
GROUP BY
o.order_id, o.order_date, c.client_name, o.channel
ORDER BY
cpu DESC;
0
0 comments
Basic Variable Cost Per Unit By Order
powered by
skool.com/the-fulfillment-files-2761
Unlock fulfillment strategies that top warehouses use and get access to hidden methods that slash costs, boost throughput, and deliver results—fast.
Suggested communities
Powered by