Quality Dashboard
Start Date
End Date
Product
Category
Suppliers
Regions
Loss due to defects

$ 4224,467 ▲

vs prev = 25.2K (-10%)

Defect rate

10% ▲

vs prev = 25.2K (-10%)

Rate of Return (Inbound)

14.7% ▲

vs prev = 25.2K (-10%)

Rate of Rejection (Outbound)

22.4% ▲

vs prev = 25.2K (-10%)

Compliant Frequency

2234 ▲

vs prev = 25.2K (-10%)

Loss due to defects by Products
Select Metric
Loss due to defects by Suppliers
Select Metric
State-Wise Loss due to defects
Trend of Loss due to defects
Trend of Defect Rate
Trend of ROR Inbound
Trend of ROR Outbound
Trend of Complaint Frequency
Start Date
End Date
Product
Category
Suppliers
Regions
Loss due to defects

$ 4224,467 ▲

vs prev = 25.2K (-10%)

Defect rate

10% ▲

vs prev = 25.2K (-10%)

Rate of Return (Inbound)

14.7% ▲

vs prev = 25.2K (-10%)

Rate of Rejection (Outbound)

22.4% ▲

vs prev = 25.2K (-10%)

Compliant Frequency

2234 ▲

vs prev = 25.2K (-10%)

Loss Incurred by suppliers
Defect Type
Defect Type distribution
Distribution of Issues and Remarks
Suppliers Summary for the Product
Supplier Quantity Sampling Rate Defects % High Impact defect % ROR Inbound ROR Outbound Loss Incurred Expenditure
Supplier 1 234,345 1,000 14% 14% 14% data $234,345 $500,000
Supplier 2 234,345 1,000 14% 14% 14% 14% $234,345 $500,000
Supplier 3 234,345 1,000 14% 14% 14% 14% $234,345 $500,000
Supplier 4 234,345 1,000 14% 14% 14% 14% $234,345 $500,000
Supplier 5 234,345 1,000 14% 14% 14% 14% $234,345 $500,000
Start Date
End Date
Category
Product
Suppliers
Regions
Loss due to defects

$ 4224,456 ▲

vs prev = 25.2K (-10%)

High Impact Defects Loss

$ 2223,456 ▲

vs prev = 25.2K (-10%)

Quality Score

93 ▲

vs prev = 25.2K (-10%)

Rate of Return (Inbound)

14.7% ▼

vs prev = 25.2K (+2.5%)

Rate of Return (Outbound)

13.8% ▲

vs prev = 25.2K (-10%)

Defect Type distribution
Defect Type Distribution
Product Defect Type Count Loss Incurred ROR Inbound Defect Rate Recall needed?
Product 1 High Impact 1,000 $ 1200 19% Yes Yes
  Medium Impact 1,000 $ 1200 19% Yes Yes
  Low Impact 1,000 $ 1200 19% No No
Product 2 Medium Impact 1,000 $ 1200 19% 43% 43%
  Low Impact 1,000 $ 1200 19% 43% 43%
Defect Rate trends
Bottom Suppliers by Defect Rate
Supplier Quantity Loss due to defects Defects % High Impact % ROR Inbound ROR Outbound
Supplier 1 234,345 $234,345 14% 2% 25% 25%
Supplier 2 234,345 $234,345 14% 2% 25% 25%
Supplier 3 234,345 $234,345 14% 2% 25% 25%
Supplier 4 234,345 $234,345 14% 2% 25% 25%
Supplier 5 234,345 $234,345 14% 2% 25% 25%
Stock Analysis
Select Category
Most Viewed Products

65.5M ▲

vs prev = 52.8M (21.86%)

Most Viewed
Sub Category
Product No of Views
Plaid Track Pants 9524
Dress Pants 8657
Track Pants 7892
Least Viewed Products

34.25M ▲

vs prev = 28.42M (17.56%)

Least Viewed
Sub Category
Product No of Views
Classic Pants 658
Si-Pants 543
Skinny Pants 521
Products Not Viewed

11.57M ▲

vs prev = 9.23M (18.23%)

High Inventory
Sub Category
Product Inventory
Cotton Sweatpants 2785
Tweed Trousers 2456
Comfort-Fit Wood Trousers 2142
In Stock

112.54M ▲

vs prev = 95.32M (17.25%)

Bottom Sales
Sub Category
Product Avg Daily Sales
Flannel Pants 1
Jogger Jeans 2
Regular Fit-Wool 3
Running Out Of Stock

42.654M ▲

vs prev = 40.11M (5.12%)

Top Sales
Sub Category
Product Avg Daily Sales
Fleece Sweatpants 241
Cotton Sweatpants 98
Plaid Wool Track Pants 86
Out Of Stock

14.984M ▲

vs prev = 11.25M (25.41%)

Top Sales
Sub Category
Product Avg Daily Sales
Waterproof Pants 245
Knitted Wool Pants 211
Small Joggers 189
Select Sub Category
Predicted Days Out Of Stock
Product Avg Daily Sales Replenished
Cotton Sweatpants 69 14
Fleece Sweatpants 87 13
Fullfillment Cycle Time Variance
Simulated Days Out Of Stock
Product Replenished
Cotton Sweatpants 14
Fleece Sweatpants 13
Pending Order
Start Date
End Date
Avg Order Age

25.47 Days ▲

vs prev = 25.2K (-10%)

OTIF

35% ▲

vs prev = 25.2K (-10%)

Order Fill Rate

35% ▲

vs prev = 25.2K (-10%)

Volume Fill Rate

35% ▲

vs prev = 25.2K (-10%)

Product Category
Product Code
Product Description
Location Code
Location Name
Channel
Supplier
Pending Order Details
Product Code PO. No. Po Date Source Location Target Location Source Location SOH Source Location SOHDays Cover Target Location SOH Order Age days
Code 1 001 09-04 Location 1 BMD 01 65 43 23 2,142
Stock Movement Recommendation
Product Code Product Description Source Location Target Location Source Location SOH Source Location SOHDays Cover Target Location SOH
Code 1 Description 1 Location 1 BMD 01 64 42 23
Code 2 Description 2 Location 2 BMD 01 64 42 23
Sales and Stock Details
Product Category Product Code Product Description Sales Units Sales Values SOH Qty SOH Value PO Qty Pending DaysLatest Order IT
Category 1 Code 1 Description 1 16 201,584 16 137,270 26 29 7,440
  Code 2 Description 2 16 201,584 16 137,270 26 29 7,440
New Requirements
Start Date
End Date
Category
Regions
Total Budget

$10,000

vs prev = 5,000 (100%)

Number Of Requests

50

vs prev = 75 (50%)

Requests Initiated

15

vs prev = 14 (7%)

Requests On Track

77%

vs prev = 79.5% (-2.5%)

Requests Fulfilled

50%

vs prev = 47.5% (+2.5%)

Progress distribution
Progress distribution
Delay distribution
Rqr No. Ack Date Budget ETD
REQ12A2 22/10/2020 $210,900 23 Days
REQ12A2 22/10/2020 $210,900 23 Days
REQ12A2 22/10/2020 $210,900 23 Days
REQ12A2 22/10/2020 $210,900 23 Days
REQ12A2 22/10/2020 $210,900 23 Days
Requirement Summary
Rqr No. Department Category Quantity Budget Specifics Status Remarks
REQ12A2 Department 1 Category 1 210,900 $210,900 20 CPUs Required with 4ghz boost with 8 cores each.
With a TPD of 90 W or lower		 PR Stage PR Stage took longer than usual.
REQ12A2 Department 1 Category 1 210,900 $210,900 20 CPUs Required with 4ghz boost with 8 cores each.
With a TPD of 90 W or lower		 PR Stage PR Stage took longer than usual.
REQ12A2 Department 1 Category 1 210,900 $210,900 20 CPUs Required with 4ghz boost with 8 cores each.
With a TPD of 90 W or lower		 PR Stage PR Stage took longer than usual.
Payment
Start Date
End Date
Suppliers
Category
Products
Regions
Count of Transactions

23,000 ▲

vs prev = 25.2K (-10%)

Avg Transaction Value

$23,000 ▲

vs prev = 25.2K (-10%)

Conversion Rate

97% ▲

vs prev = 25.2K (-10%)

Acc Payable Turnover

1.2% ▲

vs prev = 25.2K (-10%)

Trend Separated by Category
Separated On
Select Metric
Three Way Matching
Three Way Matching
Separated On
Discrepancy Summary
Invoice Code 1 PO Code GRN PO-GRN Delta% HeadPO-Invoice Delta% er5 Supplier Product PO-O
SHPA2SRT 23245A12 23245A12 12% 12% SUP1 PR12 Reason
SHPA2SRT 23245A12 23245A12 12% 12% SUP1 PR12 Reason
SHPA2SRT 23245A12 23245A12 12% 12% SUP1 PR12 Reason
Start Date
End Date
Suppliers
Category
Products
Regions
Pending Payments

345 ▲

vs prev = 25.2K (-10%)

Pending Payments

$223,000 ▲

vs prev = 25.2K (-10%)

Failed Payments

20 ▲

vs prev = 25.2K (-10%)

Payments Initiated

123 ▲

vs prev = 25.2K (-10%)

Trend Separated by Category
Separated On
Select Metric
Reason-wise bucketed
Reason Count Transaction Value % Discrepancy
Reason 1
30
14%
0%
Reason 2
49
26%
3.5%
Reason 3
39
8%
5%
Reason 3
17
50%
7.7%
Reason 3
18
36%
4.3%
Pending Payments Summary
Invoice Code PO Code Product Currency Delayed Discrepancy Payment Terms Reason
CA23Z13D CA23Z13D PR12A2 USD 3 Days $234,909 30 Days Reason XYZ
CA23Z13D CA23Z13D PR12A2 POUNDS 3 Days $234,909 30 Days Reason XYZ
CA23Z13D CA23Z13D PR12A2 EURO 3 Days $234,909 30 Days Reason XYZ
CA23Z13D CA23Z13D PR12A2 EURO 3 Days $234,909 30 Days Reason XYZ
CA23Z13D CA23Z13D PR12A2 EURO 3 Days $234,909 30 Days Reason XYZ
Purchase Order
Start Date
End Date
Products
Category
Suppliers
Regions
Purchase Orders Value

10K ▲

vs prev = 25.2K (-10%)

Maverick Purchase Orders Value

12K ▲

vs prev = 25.2K (-10%)

Average Payment Term

14K ▲

vs prev = 25.2K (-10%)

Loss due to Pending POs

16K ▲

vs prev = 25.2K (-10%)

POs Value
PO Value by Products
Based On
Type
Trend
Select Metric
Reason-wise bucketed
Value Bracket Count On Time and In Full Discount Payment Terms Revisied Payment Terms Working Capital Freed
$50 - $100k
49
data
3%
30
30
$340, 000
$50k - $100k
39
98
3.5%
15
35
$270, 000
$100k - $200k
6
95
4%
25
40
$320, 000
$200k - $300k
40
97
4.5%
30
45
$410, 000
$300k - $400k
18
94
5%
45
50
$350, 000
Start Date
End Date
Category
Products
Suppliers
Regions
Pending Maverick POs Value

$424, 456 ▲

vs prev = $424, 456 (-8.5%)

Strategic Pending POs Value

$324, 456 ▲

vs prev = $3, 224, 456 (-10%)

Loss due to Pending POs

$224, 456 ▲

vs prev = $320, 456 (-10%)

Average PR to PO Time

13.2 Days ▲

vs prev = 14.2 Days (-10%)

Distribution of Reasons
Trend
Select Metric
Pending Purchase Orders
PR Number Shipment Quantity Expenditure PR Placed Date Payment Terms Product Delay Reason
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
PR Number Shipment Quantity Expenditure PR Placed Date Payment Terms Product Delay Reason
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
23245A12 23245A12 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ
Start Date
End Date
Category
Products
Suppliers
Regions
Purchase Orders
Type
Time beyond TAT PR Number Product Shipment Quantity Expenditure PR Placed Date Status Priority Reason
S1 23245A12 A1 234,345 $124,457 09/22/2021 S1 High Reason XYZ
S1 23245A12 A1 234,345 $124,457 09/22/2021 S1 High Reason XYZ
S1 23245A12 A1 234,345 $124,457 09/22/2021 S1 High Reason XYZ
S1 23245A12 A1 234,345 $124,457 09/22/2021 S1 High Reason XYZ
S1 23245A12 A1 234,345 $124,457 09/22/2021 S1 High Reason XYZ
S1 23245A12 A1 234,345 $124,457 09/22/2021 S1 High Reason XYZ
Purchase Requisitions
PR Number Shipment Quantity Expenditure PR Placed Date Payment Terms Product Delay Reason Head
23245A12 234,345 $124,457 09/22/2021 17 Days A1 2 Days Reason XYZ data
23245A12 234,345 $124,457 09/22/2021 17 Days A2 4 Days Reason XYZ data
23245A12 234,345 $124,457 09/22/2021 17 Days A3 6 Days Reason XYZ data
23245A12 234,345 $124,457 09/22/2021 17 Days A4 7 Days Reason XYZ data
23245A12 234,345 $124,457 09/22/2021 17 Days A4 8 Days Reason XYZ data
23245A12 234,345 $124,457 09/22/2021 17 Days A5 9 Days Reason XYZ data
Sales Vs. Stock
Start Date
End Date
Product Category
Product Description
Product Code
Location Code
Location Name
Channel
Inventory Value

24.37B

Inventory Value %

8.963%

No. of Products

67

Average Daily Sales

24.37B

Products and stock movement summary
Product excess and short report
Product Category Product Code Product Description Stock level Category Item Movement Category Avg Daily Sales Excess Inventory Forcasted Daily Stocks Read SOH Qty SOH
Category 1 Code 1 Description 1 Short Stock Slow Moving 6 -224 11 274 6
Category 2 Code 2 Description 2 Excess Stock Fast Moving 6 63 11 274 6
Category 3 Code 3 Description 3 Short Stock Non Moving 6 63 11 274 6