Format Analysis
Super Hardware Stores
Hi Profit
Super
Super
Super
Super
Super
Super
Hdwe <$2.5 Hdwe $2.5- Hdwe $3.6-
Hdwe >$7
Hardware Hardware
Million
$3.6 Mil
$7 Mil
Million
Strategic Profit Model
Profit Margin Asset Turnover
10.4
15.6
9.3 2.1
8.6 2.3
11.4
10.5
2.3
2.9
2.4
2.5
Return On Assets (Pre-Tax %)
23.9
45.2
19.5
19.8
27.4
26.2
Financial Leverage
1.5
1.3
3.5
1.6
1.4
1.5
Return On Net Worth (Pre-Tax %)
35.8
58.8
68.2
31.7
38.4
39.3
Financial Ratios
Current Ratio Quick Ratio
5.3 1.6
6.7 2.2
4.8 0.8 9.5
4.6 1.4
6.7 2.1 9.6
3.6 1.4
Accounts Payable To Inventory (%) Accounts Payable Payout Period (Days)
13.4 14.7
12.1 13.4
16.2 19.5
20.8 17.3
16.6
12.4
Debt To Equity EBITDA (% Of Sales)
0.5
0.3
1.4
0.6
0.4
0.5
11.8 10.7 33.6
16.2 15.6 75.7
10.8
10.2
12.9 11.6 44.3
12.3 10.5 43.5
EBIT (% Of Sales)
9.7
8.7
Interest Coverage
13.7
28.9
Inventory Productivity
Inventory Turnover
3.3
3.6
2.1
2.9
3.3
4.4
Inventory Holding Period (Days)
110.3
101.6
171.8
127.0
109.0
83.8
Sales To Inventory Ratio
5.5
6.1
3.4
4.7
5.6
7.3
Gross Margin Return On Inventory (%)
213.5
254.2
138.8
185.1
223.3
301.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
16,717 267.50 108.80
16,500 284.50 120.40
15,000 140.90
13,144 220.70
17,061 282.20 117.00
24,282 441.50 165.20
54.10 41.30
91.30 45.20
50.30
47.30
51.80
58.90
146,801
155,575
79,599
116,772
155,906
244,501
Sales $ Per Transaction
30.70
30.50
27.20
25.20
31.20
38.00
Customers (% of sales)
DIY Customers
85.0 10.0
85.0 10.0
86.0 10.0
87.0
90.0
82.0 13.0
Contractors
7.5 5.5 0.0
5.0 5.0 0.0
Commercial/Industrial Accounts
5.0 0.0
5.0 0.0
4.0 0.0
5.0 0.0
Other Customer Types
Total Sales
100.0
100.0
100.0
100.0
100.0
100.0
Business Hours
Monday Tuesday
12.0 12.0 12.0 12.0 12.0 10.8
12.0 12.0 12.0 12.0 12.0 11.0
11.0 11.0 11.0 11.0 11.0 10.3
11.0 11.0 11.0 11.0 11.0 10.0
12.0 12.0 12.0 12.0 12.0 11.0
11.5 11.5 11.5 11.5 11.5 11.0
Wednesday
Thursday
Friday
Saturday
Sunday
8.0
8.0
7.0
8.0
8.0
9.0
Total Hours Open Per Week
78.8
79.0
72.3
73.0
79.0
77.5
Employee Productivity
Number Of Full-Time Employees Number Of Part-Time Employees
12 10
11 12
6 8
8 7
12 11
25 13
Sales $ Per FTE Employee
239,693 103,151 40,960
248,748 108,560 41,900
192,656 84,182 30,255
218,756 93,601 40,849
251,247 105,638 40,768
272,256 106,438 47,042
Gross Profit $ Per FTE Employee Payroll $ Per FTE Employee
Payroll Expense (% Of Sales)
16.4 40.7
14.4 34.8
14.9 38.0
18.1 43.5
16.4 40.7
17.1 43.7
Personnel Productivity Ratio (%)
Wage $ Per Hour
19.70
20.10
14.50
19.60
19.60
22.60
Sales $ Per Payroll Dollar Sales $ Per Payroll Hour
5.90
6.80
6.40
5.50
6.00
5.90
115.20
119.60
92.60
105.20
120.80
130.90
24
Made with FlippingBook. PDF to flipbook with ease