Format Analysis
Core Hardware Stores
Rural Core
Suburban
Suburban
Urban
Fringe
Core
Core
Hardware
Core Hdwe
Hardware
Hardware
Strategic Profit Model
Profit Margin Asset Turnover
9.7 2.3
9.5 2.4
9.7 2.3
Insufficient
Sample
Return On Assets (Pre-Tax %)
22.3
22.8
22.3
Financial Leverage
1.5
1.5
1.5
Return On Net Worth (Pre-Tax %)
33.4
34.2
33.4
Financial Ratios
Current Ratio Quick Ratio
8.4 2.6 8.8 9.7 0.3
7.0 2.3 9.4
6.5 2.2 9.4
Accounts Payable To Inventory (%) Accounts Payable Payout Period (Days)
12.9
11.2
Debt To Equity EBITDA (% Of Sales)
0.5
0.4
11.7 10.8 14.8
10.9
11.5 10.3 31.2
EBIT (% Of Sales)
9.8
Interest Coverage
41.4
Inventory Productivity
Inventory Turnover
3.1
3.4
3.1
Inventory Holding Period (Days)
118.7
106.0
116.3
Sales To Inventory Ratio
5.0
5.5
5.4
Gross Margin Return On Inventory (%)
184.1
216.4
220.3
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
8,500
9,712
9,500
305.90 111.90
294.00 119.00
287.90 119.70
55.80
54.30
53.80
79,798
104,798
110,365
Sales $ Per Transaction
30.40
28.10
25.20
Customers (% of sales)
DIY Customers
79.0 15.0
82.0 10.0
89.5
Contractors
5.5 5.0 0.0
Commercial/Industrial Accounts
6.0 0.0
8.0 0.0
Other Customer Types
Total Sales
100.0
100.0
100.0
Business Hours
Monday Tuesday
10.0 10.0 10.0 10.0 10.0 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
5.0
7.0
8.0
Total Hours Open Per Week
65.0
72.0
73.0
Employee Productivity
Number Of Full-Time Employees Number Of Part-Time Employees
7 6
7 5
6 5
Sales $ Per FTE Employee
245,125 96,722 34,925
245,523 95,419 36,748
229,886 96,693 38,348
Gross Profit $ Per FTE Employee Payroll $ Per FTE Employee
Payroll Expense (% Of Sales)
16.1 40.4
17.0 42.2
19.0 45.1
Personnel Productivity Ratio (%)
Wage $ Per Hour
16.80
17.70
18.40
Sales $ Per Payroll Dollar Sales $ Per Payroll Hour
6.60
6.00
5.60
117.80
118.00
110.50
22
Made with FlippingBook. PDF to flipbook with ease