IDEA
Home : About Us : Contact Us : Sitemap
Our Approach Get Started SmartProducts Logistics Publications Links
Rethinking Supply Chains

Results Calculator

Charming Shoppes

This will be a flash chart

One-time Cash Produced $90
Net Profit Increase -465%
Additional Value
Present Value of the Change in Cash Flow $2581
The Change in Company Value $5440
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $2688 $2065 $2474 $2722 $2752
Cost of Sales 1301 1041 1327 1420 1891
Gross Margin 1387 1024 1147 1302 861
GM (%) 51.6% 49.6% 46.4% 47.8% 31.3%
Operating Expense 1102 1102 1402 1390 752
Net Profit 285 -78 -255 -88 109
Return on Sales 10.6% -3.8% -10.3% -3.2% 4.0%
Inventory 178 268 268 330 429
As a % of Sales 6.6% 13.0% 10.8% 12.1% 15.6%
Turns 7.3 3.9 5.0 4.3 4.4
Days of Inventory 50 94 74 85 83
Return on Inventory 160% -29% -95% -27% 25%
Charming Shoppes owns chains of stores that sell both large and small clothing for women.

Dick's Sportinig Goods

This will be a flash chart

One-time Cash Produced $3
Net Profit Increase 236%
Additional Value
Present Value of the Change in Cash Flow $2184
The Change in Company Value $5081
Financial Data in Millions of Dollars ($)
2010 with IDEA 2010 actual 2009 2008 2007
Sales $5370 $4413 $4130 $3888 $3114
Cost of Sales 3835 3196 2946 2730 2217
Gross Margin 1535 1217 1184 1158 897
GM (%) 28.6% 27.6% 28.7% 29.8% 28.8%
Operating Expense 1082 1082 1224 1007 784
Net Profit 453 135 -40 151 113
Return on Sales 8.4% 3.1% -1.0% 3.9% 3.6%
Inventory 893 896 855 887 641
As a % of Sales 16.6% 20.3% 20.7% 22.8% 20.6%
Turns 4.3 3.6 3.4 3.1 3.5
Days of Inventory 85 102 106 119 106
Return on Inventory 51% 15% -5% 17% 18%
Dick’s is a sporting goods retailer with over 400 stores in 40 states in the US.

The Forzani Group LTD

This will be a flash chart

One-time Cash Produced $60
Net Profit Increase 524%
Additional Value
Present Value of the Change in Cash Flow $1102
The Change in Company Value $2579
Financial Data in Millions of Dollars ($)
2010 with IDEA 2010 actual 2009 2008 2007
Sales $1682 $1358 $1347 $1331 $1264
Cost of Sales 1037 864 863 853 812
Gross Margin 645 494 484 478 452
GM (%) 38.3% 36.4% 35.9% 35.9% 35.8%
Operating Expense 464 465 455 431 417
Net Profit 181 29 29 47 35
Return on Sales 10.8% 2.1% 2.2% 3.5% 2.8%
Inventory 256 316 292 319 302
As a % of Sales 15.2% 23.3% 21.7% 24.0% 23.9%
Turns 4.1 2.7 3.0 2.7 2.7
Days of Inventory 90 133 123 137 136
Return on Inventory 71% 9% 10% 15% 12%
Forzani is Canada's largest chain of sporting goods retail stores

W W Grainger

This will be a flash chart

One-time Cash Produced $205
Net Profit Increase 120%
Additional Value
Present Value of the Change in Cash Flow $3742
The Change in Company Value $9783
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $7280 $6222 $6850 $6418 $5883
Cost of Sales 4166 3623 4021 3814 3530
Gross Margin 3114 2599 2829 2604 2353
GM (%) 42.8% 41.8% 41.3% 40.6% 40.0%
Operating Expense 2169 2169 2354 2184 1970
Net Profit 945 430 475 420 383
Return on Sales 13.0% 6.9% 6.9% 6.5% 6.5%
Inventory 685 890 1010 946 817
As a % of Sales 9.4% 14.3% 14.7% 14.7% 13.9%
Turns 6.1 4.1 4.0 4.0 4.3
Days of Inventory 60 90 92 91 84
Return on Inventory 138% 48% 47% 44% 47%
W W Granger is a national distributor of industrial supplies

Hanesbrands Inc.

This will be a flash chart

One-time Cash Produced $304
Net Profit Increase 639%
Additional Value
Present Value of the Change in Cash Flow $2546
The Change in Company Value $4896
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $4611 $3891 $4249 $4475 $4473
Cost of Sales 3020 2626 2871 3034 2988
Gross Margin 1591 1265 1378 1441 1485
GM (%) 34.5% 32.5% 32.4% 32.2% 33.2%
Operating Expense 1214 1214 1251 1315 1163
Net Profit 377 51 127 126 322
Return on Sales 8.2% 1.3% 3.0% 2.8% 7.2%
Inventory 745 1049 1291 1117 1217
As a % of Sales 16.2% 27.0% 30.4% 25.0% 27.2%
Turns 4.1 2.5 2.2 2.7 2.5
Days of Inventory 90 146 164 134 149
Return on Inventory 51% 5% 10% 11% 26%
Hanesbrands is a major brand owner and producer of consumer apparel

DR Horton

This will be a flash chart

One-time Cash Produced $1467
Net Profit Increase -142%
Additional Value
Present Value of the Change in Cash Flow $6778
The Change in Company Value $5412
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $4725 $3604 $6646 $11296 $15051
Cost of Sales 4007 3539 5797 9155 11147
Gross Margin 718 65 849 2141 3904
GM (%) 15.2% 1.8% 12.8% 19.0% 25.9%
Operating Expense 490 610 3480 3092 1917
Net Profit 228 -545 -2631 -951 1987
Return on Sales 4.8% -15.1% -39.6% -8.4% 13.2%
Inventory 2196 3663 4683 9343 11343
As a % of Sales 46.5% 101.6% 70.5% 82.7% 75.4%
Turns 1.8 1.0 1.2 1.0 1.0
Days of Inventory 200 378 295 372 371
Return on Inventory 10% -15% -56% -10% 18%
DR Horton is one of the nation's largest homebuilders operating in 27 states

Intertape Polymer Group

This will be a flash chart

One-time Cash Produced $23
Net Profit Increase -264%
Additional Value
Present Value of the Change in Cash Flow $276
The Change in Company Value $368
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $755 $615 $737 $767 $812
Cost of Sales 640 533 659 651 694
Gross Margin 115 82 78 116 118
GM (%) 15.2% 13.3% 10.6% 15.1% 14.5%
Operating Expense 92 96 171 124 285
Net Profit 23 -14 -93 -8 -167
Return on Sales 3.0% -2.3% -12.6% -1.0% -20.6%
Inventory 56 79 91 99 75
As a % of Sales 7.4% 12.8% 12.3% 12.9% 9.2%
Turns 11.4 6.7 7.2 6.6 9.3
Days of Inventory 32 54 50 56 39
Return on Inventory 41% -18% -102% -8% -223%
Intertape is a manufacturer of fast moving packaging materials

Kohl's

This will be a flash chart

One-time Cash Produced $749
Net Profit Increase 242%
Additional Value
Present Value of the Change in Cash Flow $14308
The Change in Company Value $9901
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $20311 $17178 $16389 $16473 $15596
Cost of Sales 12401 10680 10334 10459 992
Gross Margin 7910 6498 6055 6014 14604
GM (%) 38.9% 37.8% 36.9% 36.5% 93.6%
Operating Expense 4519 5507 5170 4930 13495
Net Profit 3391 991 885 1084 1109
Return on Sales 16.7% 5.8% 5.4% 6.6% 7.1%
Inventory 2174 2923 2799 2856 2578
As a % of Sales 10.7% 17.0% 17.1% 17.3% 16.5%
Turns 5.7 3.7 3.7 3.7 0.4
Days of Inventory 64 100 99 100 949
Return on Inventory 156% 34% 32% 38% 43%
Kohl's is a major family oriented retailer of consumer goods

Kroger

This will be a flash chart

One-time Cash Produced $638
Net Profit Increase 4130%
Additional Value
Present Value of the Change in Cash Flow $20491
The Change in Company Value $46248
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $85519 $76733 $76148 $70336 $66111
Cost of Sales 64854 58958 58544 53711 50115
Gross Margin 20665 17775 17604 16625 15996
GM (%) 24.2% 23.2% 23.1% 23.6% 24.2%
Operating Expense 17704 17705 16355 15416 14881
Net Profit 2961 70 1249 1209 1115
Return on Sales 3.5% 0.1% 1.6% 1.7% 1.7%
Inventory 4264 4902 4905 4849 4609
As a % of Sales 5.0% 6.4% 6.4% 6.9% 7.0%
Turns 15.2 12.0 11.9 11.1 10.9
Days of Inventory 24 30 31 33 34
Return on Inventory 69% 1% 25% 25% 24%
The Kroger Company is a major grocery chain in the US also selling under various regional names

Michaels

This will be a flash chart

One-time Cash Produced $350
Net Profit Increase -8520%
Additional Value
Present Value of the Change in Cash Flow $3274
The Change in Company Value $6386
Financial Data in Millions of Dollars ($)
2008 with IDEA 2008 actual 2007 2006 2005
Sales $4729 $3817 $3862 $3665 $3676
Cost of Sales 2917 2431 2383 2364 2288
Gross Margin 1812 1386 1479 1301 1388
GM (%) 38.3% 36.3% 38.3% 35.5% 37.8%
Operating Expense 1391 1391 1511 1260 1167
Net Profit 421 -5 -32 41 221
Return on Sales 8.9% -0.1% -0.8% 1.1% 6.0%
Inventory 550 900 845 848 784
As a % of Sales 11.6% 23.6% 21.9% 23.1% 21.3%
Turns 5.3 2.7 2.8 2.8 2.9
Days of Inventory 69 135 129 131 125
Return on Inventory 77% -1% -4% 5% 28%
Michaels Stores is the nation's largest retail chain selling Arts and Craft Supplies

Polo Ralph Lauren

This will be a flash chart

One-time Cash Produced $107
Net Profit Increase 126%
Additional Value
Present Value of the Change in Cash Flow $3817
The Change in Company Value $12421
Financial Data in Millions of Dollars ($)
2010 with IDEA 2010 (Estimate) 2009 2008 2007
Sales $5670 $4917 $5019 $4880 $4295
Cost of Sales 2345 2132 2288 2242 1959
Gross Margin 3325 2785 2731 2638 2336
GM (%) 58.6% 56.6% 54.4% 54.1% 54.4%
Operating Expense 2355 2355 2325 2218 1935
Net Profit 970 430 406 420 401
Return on Sales 17.1% 8.7% 8.1% 8.6% 9.3%
Inventory 418 525 825 515 527
As a % of Sales 7.4% 10.7% 16.4% 10.6% 12.3%
Turns 5.6 4.1 2.8 4.4 3.7
Days of Inventory 65 90 132 84 98
Return on Inventory 232% 82% 49% 82% 76%
Ralph Lauren is a global brand of lifestyle products, including apparel, accessories, fragrances and home furnishing

TESSCO Technologies

This will be a flash chart

One-time Cash Produced $7
Net Profit Increase 311%
Additional Value
Present Value of the Change in Cash Flow $197
The Change in Company Value $444
Financial Data in Millions of Dollars ($)
2010 with IDEA 2010 actual 2009 2008 2007
Sales $590 $522 $483 $521 $492
Cost of Sales 439 399 361 404 371
Gross Margin 151 123 122 117 121
GM (%) 25.6% 23.6% 25.3% 22.5% 24.6%
Operating Expense 114 114 116 112 114
Net Profit 37 9 6 5 7
Return on Sales 6.3% 1.7% 1.2% 1.0% 1.4%
Inventory 38 45 37 49 37
As a % of Sales 6.4% 8.6% 7.7% 9.4% 7.5%
Turns 11.6 8.9 9.8 8.2 10.0
Days of Inventory 32 41 37 44 36
Return on Inventory 97% 20% 16% 10% 19%
TESSCO is a major distributor of electronic products used by companies in the cellular, wireless and network industries.

Saks

This will be a flash chart

One-time Cash Produced $155
Net Profit Increase -603%
Additional Value
Present Value of the Change in Cash Flow $2558
The Change in Company Value $2254
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $3315 $2632 $3043 $3237 $2888
Cost of Sales 2002 1668 2062 1972 1780
Gross Margin 1313 964 981 1265 1108
GM (%) 39.6% 36.6% 32.2% 39.1% 38.4%
Operating Expense 1021 1022 1140 1221 1112
Net Profit 292 -58 -159 44 -4
Return on Sales 8.8% -2.2% -5.2% 1.4% -0.1%
Inventory 494 649 729 857 785
As a % of Sales 14.9% 24.7% 24.0% 26.5% 27.2%
Turns 4.1 2.6 2.8 2.3 2.3
Days of Inventory 90 142 129 159 161
Return on Inventory 59% -9% -22% 5% -1%
Saks is a major US retailer

Tractor Supply Company

This will be a flash chart

One-time Cash Produced $101
Net Profit Increase 284%
Additional Value
Present Value of the Change in Cash Flow $2348
The Change in Company Value $5561
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $3966 $3207 $3008 $2703 $2370
Cost of Sales 2606 2172 2096 1851 1623
Gross Margin 1360 1035 912 852 747
GM (%) 34.3% 32.3% 30.3% 31.5% 31.5%
Operating Expense 918 920 830 756 656
Net Profit 442 115 82 96 91
Return on Sales 11.1% 3.6% 2.7% 3.6% 3.8%
Inventory 500 601 603 636 595
As a % of Sales 12.6% 18.7% 20.0% 23.5% 25.1%
Turns 5.2 3.6 3.5 2.9 2.7
Days of Inventory 70 101 105 125 134
Return on Inventory 88% 19% 14% 15% 15%
Tractor supply is a retail chain of farm and ranch stores in the US

Tupperware

This will be a flash chart

One-time Cash Produced $191
Net Profit Increase 121%
Additional Value
Present Value of the Change in Cash Flow $1562
The Change in Company Value $3821
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $2412 $2128 $2162 $1981 $1744
Cost of Sales 791 719 764 695 615
Gross Margin 1621 1409 1398 1286 1129
GM (%) 67.2% 66.2% 64.7% 64.9% 64.7%
Operating Expense 1234 1234 1237 1169 1035
Net Profit 387 175 161 117 94
Return on Sales 16.0% 8.2% 7.4% 5.9% 5.4%
Inventory 75 266 277 270 233
As a % of Sales 3.1% 12.5% 12.8% 13.6% 13.4%
Turns 10.5 2.7 2.8 2.6 2.6
Days of Inventory 35 135 132 142 138
Return on Inventory 516% 66% 58% 43% 40%
Tupperware is a major manufacturer and brand owner of consumer products

Walgreens

This will be a flash chart

One-time Cash Produced $2054
Net Profit Increase 73%
Additional Value
Present Value of the Change in Cash Flow $18331
The Change in Company Value $40288
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $69363 $63335 $59304 $53762 $47409
Cost of Sales 49380 45722 42391 38518 34240
Gross Margin 19983 17613 16913 15244 13169
GM (%) 28.8% 27.8% 28.5% 28.4% 27.8%
Operating Expense 14366 14366 13472 12094 10468
Net Profit 5617 3247 3441 3150 2701
Return on Sales 8.1% 5.1% 5.8% 5.9% 5.7%
Inventory 4735 6789 7149 6790 6050
As a % of Sales 6.8% 10.7% 12.1% 12.6% 12.8%
Turns 10.4 6.7 5.9 5.7 5.7
Days of Inventory 35 54 62 64 64
Return on Inventory 119% 48% 48% 46% 45%
Walgreen Co. is the largest drug store chain in the US

Zumiez, Inc.

This will be a flash chart

One-time Cash Produced $8
Net Profit Increase 385%
Additional Value
Present Value of the Change in Cash Flow $349
The Change in Company Value $745
Financial Data in Millions of Dollars ($)
2009 with IDEA 2009 actual 2008 2007 2006
Sales $511 $407 $409 $381 $206
Cost of Sales 328 273 274 244 133
Gross Margin 183 134 135 137 73
GM (%) 35.8% 32.9% 33.0% 36.0% 35.4%
Operating Expense 120 121 110 98 53
Net Profit 63 13 25 39 20
Return on Sales 12.3% 3.2% 6.1% 10.2% 9.7%
Inventory 43 51 52 49 42
As a % of Sales 8.4% 12.5% 12.7% 12.9% 20.4%
Turns 7.6 5.4 5.3 5.0 3.2
Days of Inventory 48 68 69 73 115
Return on Inventory 147% 25% 48% 80% 48%
Action Sports Apparel, Equipment and Accessories Retail Chain with 375 stores

Distributor L-1

This will be a flash chart

One-time Cash Produced $3
Net Profit Increase 50%
Additional Value
Present Value of the Change in Cash Flow $21
The Change in Company Value $10
Financial Data in Millions of Dollars ($)
2010 with IDEA 2010 actual - - -
Sales $103 $94
Cost of Sales 74 68
Gross Margin 29 26
GM (%) 28.2% 27.7%
Operating Expense 20 20
Net Profit 9 6
Return on Sales 8.7% 6.4%
Inventory 8 11
As a % of Sales 7.8% 11.7%
Turns 9.3 6.2
Days of Inventory 39 59
Return on Inventory 113% 55%
Regional Disributor - Private Company

Distributor L-2

This will be a flash chart

One-time Cash Produced $5
Net Profit Increase 75%
Additional Value
Present Value of the Change in Cash Flow $25
The Change in Company Value $11
Financial Data in Millions of Dollars ($)
2010 with IDEA 2010 actual - - -
Sales $121 $110
Cost of Sales 91 83
Gross Margin 30 27
GM (%) 24.8% 24.5%
Operating Expense 23 23
Net Profit 7 4
Return on Sales 5.8% 3.6%
Inventory 12 17
As a % of Sales 9.9% 15.5%
Turns 7.6 4.9
Days of Inventory 48 75
Return on Inventory 58% 24%
Regional Distributor - Private Company

Distributor L-3

This will be a flash chart

One-time Cash Produced $2
Net Profit Increase -200%
Additional Value
Present Value of the Change in Cash Flow $16
The Change in Company Value $8
Financial Data in Millions of Dollars ($)
2010 with IDEA 2010 actual - - -
Sales $31 $24
Cost of Sales 24 19
Gross Margin 7 5
GM (%) 22.6% 20.8%
Operating Expense 6 6
Net Profit 1 -1
Return on Sales 3.2% -4.2%
Inventory 2 4
As a % of Sales 6.5% 16.7%
Turns 12.0 4.8
Days of Inventory 30 77
Return on Inventory 50% -25%
Regional Distributor - Private Company

Manufacturer D-1

This will be a flash chart

One-time Cash Produced $46
Net Profit Increase 103%
Additional Value
Present Value of the Change in Cash Flow $576
The Change in Company Value $1314
Financial Data in Millions of Dollars ($)
2010 with IDEA 2010 actual - - -
Sales $2139 $1900
Cost of Sales 1815 1650
Gross Margin 324 250
GM (%) 15.1% 13.2%
Operating Expense 172 175
Net Profit 152 75
Return on Sales 7.1% 3.9%
Inventory 134 180
As a % of Sales 6.3% 9.5%
Turns 13.5 9.2
Days of Inventory 27 40
Return on Inventory 113% 42%
This company is a heavy industrial manufacturer that makes-to stock in the US.

Distributor I-1

This will be a flash chart

One-time Cash Produced $1
Net Profit Increase 33%
Additional Value
Present Value of the Change in Cash Flow $8
The Change in Company Value $17
Financial Data in Millions of Dollars ($)
2011 with IDEA 2011 actual 2010 2009 2008
Sales $55 $50
Cost of Sales 44 40
Gross Margin 11 10
GM (%) 20.0% 20.0%
Operating Expense 7 7
Net Profit 4 3
Return on Sales 7.3% 6.0%
Inventory 4 5
As a % of Sales 7.3% 10.0%
Turns 11.0 8.0
Days of Inventory 33 46
Return on Inventory 100% 60%

Plexus Corporation

This will be a flash chart

One-time Cash Produced $83
Net Profit Increase 43%
Additional Value
Present Value of the Change in Cash Flow $356
The Change in Company Value $429
Financial Data in Millions of Dollars ($)
2011 with IDEA 2011 projected 2010 2009 2008
Sales $2344 $2208 $2013 $1617 $1842
Cost of Sales 2093 1993 1806 1462 1636
Gross Margin 251 215 207 155 206
GM (%) 10.7% 9.7% 10.3% 9.6% 11.2%
Operating Expense 119 123 117 109 122
Net Profit 132 92 90 46 84
Return on Sales 5.6% 4.2% 4.5% 2.8% 4.6%
Inventory 401 484 492 322 340
As a % of Sales 17.1% 21.9% 24.4% 19.9% 18.5%
Turns 5.2 4.1 3.7 4.5 4.8
Days of Inventory 70 89 99 80 76
Return on Inventory 33% 19% 18% 14% 25%
The Product Realization Company
Home : About Us : Contact Us : Sitemap :   IDEALLC 2008 Copyright