8-12 PowerPoint slide. with min. of 150 words in notes sections per slide to explain each slide. PLEASE SEE INSTRUCTIONS ATTACHED.

Dashboard Report

National University

MGT 608

September 21, 2025

Dashboard Report

This document presents clear descriptions and supporting data tables for each dashboard chart. Each description states what the graphic shows, why it matters for operations and purchasing, and how to read the values. The tables reproduce the numbers that feed each visual so that the reader can verify every figure.

Annual Sales per Product

This column chart shows annual unit sales for six voice assistant products. It compares demand across items, allowing the team to prioritize production and purchasing. The add-on box with one gigabyte sells the most units, while the 512-megabyte box sells the fewest. The average daily sales values confirm the relative ranking and guide reorder timing. Because inventory policies follow demand variability and service goals, the visual helps set reorder timing and safety stock targets that balance cost with availability, which aligns with Barros et al. (2021), who state that well-dimensioned safety stock reduces procurement risk under uncertainty

Total Purchase Order Cost by SKU

This chart reports the purchase order cost for each stock-keeping unit during the year. It reveals where cash outlays concentrate and where negotiation and supplier risk control will yield the most significant savings. The four-gigabyte add-on box and the component have the highest total spend, while the 512-megabyte box has the lowest. Because high spend items also amplify risk, managers can pair this view with data-driven forecasting and service level rules to justify safety stock for critical parts (Demiray Kırmızı et al., 2024), and they can further use modern learning methods to refine demand signals for these specific items (Khedr, 2024)

Annual Quantity by SKU

This chart displays the annual unit quantities by SKU. It confirms demand concentration and helps align purchasing frequency with sales velocity. The one-gigabyte add-on box leads in units, while the five-hundred-twelve-megabyte box trails. Since safety stock depends on variability, service level, and lead time, this comparison supports a differentiated policy that protects high-volume items without overinvesting in slow movers (Barros et al., 2021).

Total Annual Expenditures by Cost Type

This bar chart summarizes categories of carrying cost for inventory. Capital cost dominates, followed by risk, storage, and inventory service costs. The pattern suggests that reducing average inventory will significantly reduce capital costs and that improved protection and demand accuracy will further mitigate risk costs. Moreover, targeted risk mitigation for obsolescence and stock out loss can complement capital reduction, which is consistent with research that links safety stock design to lower exposure under uncertain demand and supply (Demiray Kırmızı et al., 2024). Data-driven modeling can further quantify these tradeoffs for management review (Khedr, 2024).

Corporate Inventory Expenses Detail

This table and chart show inventory holding costs by category and expense line. The totals roll up to the annual holding cost and the holding cost rate. The result shows that the average inventory of four million four hundred fifty thousand dollars carries a yearly holding cost of nearly forty percent, which signals a strong opportunity for cycle stock and safety stock reduction.

Total Population by Region

This pie chart illustrates the distribution of the United States population by census region. The South contains the largest share of residents, followed by the West, then the Midwest, and the Northeast. Because demand for mass market products usually scales with population, this view helps allocate sales forecasts and inventory across regions.

Analysis Inputs for Service Level and Population

This sheet captures the chosen service level, the corresponding z value for safety stock, and the 2019 population totals by region used earlier in the project step. The entries support later calculations, such as economic order quantity and reorder point. Because service level directly determines safety stock, the display ensures that stakeholders agree on the target and understand its effect on reorder points. The approach follows best practice by Barros et al. (2021), which recommends explicit service goals and statistically grounded buffers to manage uncertainty in procurement and demand.

References