Northstar Sealants — Original D473 Practice Dataset
Synthetic educational case. This is not Endothon data and is not an official or previously evaluated WGU submission.
Scenario element Practice-case detail
Company Northstar Sealants, a fictional manufacturer of industrial construction sealants
Operating network One Ohio manufacturing plant and four third-party distribution centers serving nati
Business problem Service performance is below contract expectations while freight and inventory c
Assigned role Operations manager leading a data-informed network improvement project
Data period January 2024 through December 2025 (24 synthetic monthly observations)
Practice objective Demonstrate A1–A3 analysis and provide evidence for a B1a–B3b presentation
Practice-use notice
Use this package to study the analytical method, workbook organization, and presentation logic. Replace the fictional compan
completing your own work. No pass or evaluator outcome is guaranteed.
Method references
ASCM SCOR Digital Standard https://www.ascm.org/corporate-solutions/standards-tools/scor-ds/
Microsoft Power BI KPI guidance https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
Public D473 task-architecture reference https://gradevia.com/d473/
,mission.
Metric Management target Rationale
On-time delivery rate 95.0% Illustrative retailer service target
Freight cost per unit $6.00 Illustrative cost target
Annualized inventory carrying-cost rate 20.0% Illustrative internal target
Replace the fictional company, synthetic figures, targets, and recommendations with evidence from the official course materials when
Synthetic educational case. This is not Endothon data and is not an official or previously evaluated WGU submission.
Scenario element Practice-case detail
Company Northstar Sealants, a fictional manufacturer of industrial construction sealants
Operating network One Ohio manufacturing plant and four third-party distribution centers serving nati
Business problem Service performance is below contract expectations while freight and inventory c
Assigned role Operations manager leading a data-informed network improvement project
Data period January 2024 through December 2025 (24 synthetic monthly observations)
Practice objective Demonstrate A1–A3 analysis and provide evidence for a B1a–B3b presentation
Practice-use notice
Use this package to study the analytical method, workbook organization, and presentation logic. Replace the fictional compan
completing your own work. No pass or evaluator outcome is guaranteed.
Method references
ASCM SCOR Digital Standard https://www.ascm.org/corporate-solutions/standards-tools/scor-ds/
Microsoft Power BI KPI guidance https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
Public D473 task-architecture reference https://gradevia.com/d473/
,mission.
Metric Management target Rationale
On-time delivery rate 95.0% Illustrative retailer service target
Freight cost per unit $6.00 Illustrative cost target
Annualized inventory carrying-cost rate 20.0% Illustrative internal target
Replace the fictional company, synthetic figures, targets, and recommendations with evidence from the official course materials when
