Format Analysis
Core Hardware Stores
Hi Profit
Core Hdwe Core Hdwe Core Hdwe Core Hdwe
Core
Core
Under $1.5 $1.5 - $2.2 $2.2 - $5
Over $5 Million
Hardware Hardware
Million
Million
Million
Strategic Profit Model
Profit Margin Asset Turnover
9.6 2.3
15.2
7.0 1.6
9.6 2.1
10.1
10.3
2.9
2.5
2.8
Return On Assets (Pre-Tax %)
22.1
44.1
11.2
20.2
25.2
28.8
Financial Leverage
1.5
1.4
1.6
1.7
1.5
1.5
Return On Net Worth (Pre-Tax %)
33.1
61.7
17.9
34.3
37.8
43.2
Financial Ratios
Current Ratio Quick Ratio
6.9 2.2 9.2
7.1 2.5 8.7 8.8 0.3
9.2 1.6 4.0 8.1 0.3 9.7 7.5
7.8 2.1 7.8
6.8 2.3 9.8
5.5 1.9
Accounts Payable To Inventory (%) Accounts Payable Payout Period (Days)
14.1 15.0
12.2
12.4
11.3
Debt To Equity EBITDA (% Of Sales)
0.4
0.5
0.4
0.4
11.4 10.2 26.9
16.0 15.4 67.9
11.6 10.8 12.7
11.9 10.8 39.0
11.8 10.5 34.8
EBIT (% Of Sales)
Interest Coverage
13.4
Inventory Productivity
Inventory Turnover
3.2
3.5
1.8
2.6
3.5
4.3
Inventory Holding Period (Days)
115.3
102.9
207.8
138.4
104.2
85.0
Sales To Inventory Ratio
5.4
5.9
3.0
4.3
5.9
6.8
Gross Margin Return On Inventory (%)
213.9
249.9
121.3
168.0
239.3
252.4
Operating Productivity
Square Feet Of Retail Selling Space Sales $ Per Retail Square Foot Gross Profit $ Per Retail Square Foot Inventory $ Per Retail Square Foot Number Of Annual Sales Transactions
9,456
9,425
8,450
8,876
9,777
10,500 551.80 217.80
292.60 117.80
338.10 150.00
135.00
210.30
340.50 140.70
52.90 41.90
89.90 51.80
54.80
55.20
57.80
85.10
100,837
114,231
52,740
72,933
114,557
162,900
Sales $ Per Transaction
27.00
27.50
24.10
25.50
27.40
39.20
Customers (% of sales)
DIY Customers
84.5 10.0
89.0
80.0 10.0 10.0
88.5
84.0 10.0
85.0 10.0
Contractors
5.0 6.0 0.0
6.5 5.0 0.0
Commercial/Industrial Accounts
5.5 0.0
6.0 0.0
5.0 0.0
Other Customer Types
0.0
Total Sales
100.0
100.0
100.0
100.0
100.0
100.0
Business Hours
Monday Tuesday
11.0 11.0 11.0 11.0 11.0 10.0
11.5 11.5 11.5 11.5 11.5 10.0
10.3 10.3 10.3 10.3 10.3 10.0
10.5 10.5 10.5 10.5 10.5 10.0
11.0 11.0 11.0 11.0 11.0 10.0
11.0 11.0 11.0 11.0 11.0 10.0
Wednesday
Thursday
Friday
Saturday
Sunday
7.0
7.0
6.0
6.0
8.0
8.0
Total Hours Open Per Week
72.0
74.5
67.5
68.5
73.0
73.0
Employee Productivity
Number Of Full-Time Employees Number Of Part-Time Employees
6 6
7 6
4 4
5 4
8 6
14
7
Sales $ Per FTE Employee
237,778 96,038 37,933
246,473 102,723 36,221
148,279 58,279 28,053
221,366 87,545 33,992
244,375 100,039 38,307
292,007 114,620 45,539
Gross Profit $ Per FTE Employee Payroll $ Per FTE Employee
Payroll Expense (% Of Sales)
17.9 43.4
15.9 37.2
18.3 44.1
16.7 41.0
17.7 42.4
17.9 44.8
Personnel Productivity Ratio (%)
Wage $ Per Hour
18.20
17.40
13.50
16.30
18.40
21.90
Sales $ Per Payroll Dollar Sales $ Per Payroll Hour
5.80
6.20
4.90
6.10
5.70
6.10
114.30
118.50
71.30
106.40
117.50
140.40
20
Made with FlippingBook. PDF to flipbook with ease