Format Analysis
Conveni ence Hardware Stores
Conven-
High
Conv Hdwe Conv Hdwe Conv Hdwe Conv Hdwe
ience
Profit
Under
$800,000-
$1.25 - $2 Over $2
Hardware Conv Hdwe $800,000 $1.25 Million Million
Million
Strategic Profit Model
Profit Margin Asset Turnover
7.3 2.2
16.1
0.3 1.5 0.4 8.2 3.3 8.2 0.9 2.0 5.9 0.0 2.8 2.7 1.1
9.9 1.8
7.2 2.2
7.3 2.4
2.9
Return On Assets (Pre-Tax %)
16.1
46.7
17.8
15.8
17.5
Financial Leverage
1.4
1.3
1.6
1.2
1.4
Return On Net Worth (Pre-Tax %)
22.5
60.7
28.5
19.0
24.5
Financial Ratios
Current Ratio Quick Ratio
6.6 1.8 9.8
4.8 1.8
13.0
8.4 2.1 4.6 5.5 0.2 9.8 8.3
4.8 1.6
2.2 4.5 6.4 0.6
Accounts Payable To Inventory (%) Accounts Payable Payout Period (Days)
13.3 12.7
17.1 15.9
11.5
Debt To Equity EBITDA (% Of Sales)
0.3 9.2 8.3
0.3
0.4 9.0 7.5
16.4 16.1 95.4
13.1 11.6 17.3
EBIT (% Of Sales)
Interest Coverage
24.1
39.8
22.0
Inventory Productivity
Inventory Turnover
3.3
3.3
1.5
2.2
2.8
3.9
Inventory Holding Period (Days)
109.9
109.9
244.2
166.4
129.0
92.9
Sales To Inventory Ratio
5.2
5.6
2.7
3.7
4.4
6.6
Gross Margin Return On Inventory (%)
202.5
228.1
108.8
160.0
177.3
245.1
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
5,327
5,500
5,364
5,135
5,100
5,488
349.80 129.80
461.40 180.50
109.70
203.60
307.80 114.70
617.90 239.50
43.60 42.60
85.30 53.50
67.10
70.10
63.10
85.80
64,894
114,427
25,961
44,382
55,986
100,381
Sales $ Per Transaction
27.90
27.60
19.40
22.60
27.50
31.80
Customers (% of sales)
DIY Customers
75.0 15.0 10.0
70.0 20.0 10.0
78.0
66.0 14.0 20.0
69.2 20.0 10.8
76.2 13.8 10.0
Contractors
5.0
Commercial/Industrial Accounts
16.0
Other Customer Types
0.0
0.0
1.0
0.0
0.0
0.0
Total Sales
100.0
100.0
100.0
100.0
100.0
100.0
Business Hours
Monday Tuesday
10.0 10.0 10.0 10.0 10.0
11.0 11.0 11.0 11.0 11.0 10.0
10.0 10.0 10.0 10.0 10.0
10.0 10.0 10.0 10.0 10.0
10.5 10.5 10.5 10.5 10.5
10.3 10.0 10.3 10.3 10.5
Wednesday
Thursday
Friday
Saturday
9.0 5.0
8.5 0.0
8.5 5.0
9.5 4.5
9.5 6.5
Sunday
7.0
Total Hours Open Per Week
64.0
72.0
58.5
63.5
66.5
67.4
Employee Productivity
Number Of Full-Time Employees Number Of Part-Time Employees
4 3
4 2
3 2
3 3
4 3
8 3
Sales $ Per FTE Employee
218,818 88,561 40,019
417,242 113,778 41,398
141,194 69,799 38,030
216,453 85,951 41,707
212,205 88,538 37,699
271,552 97,422 40,451
Gross Profit $ Per FTE Employee Payroll $ Per FTE Employee
Payroll Expense (% Of Sales)
19.4 47.1
17.9 41.8
28.8 61.1
18.5 43.5
18.5 47.0
19.1 50.9
Personnel Productivity Ratio (%)
Wage $ Per Hour
19.20
19.90
18.30
20.10
18.10
19.40
Sales $ Per Payroll Dollar Sales $ Per Payroll Hour
5.40
6.50
3.60
5.60
5.70
5.40
105.20
200.60
67.90
104.10
102.00
130.60
16
Made with FlippingBook. PDF to flipbook with ease