Format Analysis
Home Centers
Hi Profit
Home Ctr Under $3
Home Ctr
Home Ctr
Home Ctr
Home Center
Home Center
$3 - $4 Million
$4 - $8 Million
Over $8 Million
Million
Strategic Profit Model
Profit Margin Asset Turnover
8.4 2.3
18.0
4.3 2.1 9.0 1.3
9.1 2.5
7.6 2.2
10.1
2.8
2.5
Return On Assets (Pre-Tax %)
19.3
50.4
22.7
16.7
25.2
Financial Leverage
1.3
1.3
1.5
1.3
1.2
Return On Net Worth (Pre-Tax %)
25.1
65.5
11.7
34.0
21.7
30.2
Financial Ratios
Current Ratio Quick Ratio
5.5 2.0
5.9 2.0
11.6
5.8 2.1
5.5 2.0
4.8 2.0
4.4 7.4 4.7 0.3 8.8 5.3 5.5
Accounts Payable To Inventory (%) Accounts Payable Payout Period (Days)
14.4 12.8
11.6 13.2
13.8 13.2
16.1 13.6
18.8 13.2
Debt To Equity EBITDA (% Of Sales)
0.3 9.9 8.5
0.3
0.5
0.2 8.9 8.0
0.2
18.3 18.0 N/A
10.2
12.4 10.1 51.7
EBIT (% Of Sales)
9.3
Interest Coverage
28.3
11.6
63.1
Inventory Productivity
Inventory Turnover
3.9
6.2
3.5
3.9
3.7
5.2
Inventory Holding Period (Days)
93.8
58.9
110.7
94.7
98.7
69.6
Sales To Inventory Ratio
5.9
9.6
5.8
5.4
5.9
7.2
Gross Margin Return On Inventory (%)
191.8
283.5
232.0
162.2
191.9
200.6
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
12,000 462.90 152.90
12,000 853.50 316.50 110.80 132,057
8,500
10,135 357.50 122.10
12,154 528.20 165.50
17,002 799.30 292.00 110.80 143,253
220.90
75.00 49.30
81.00
73.30
99.30
78,698
51,437
66,064
101,916
Sales $ Per Transaction
62.40
88.00
37.90
58.30
55.20
99.10
Customers (% of sales)
DIY Customers
46.1 41.9 10.0
N/A N/A N/A N/A
57.5 32.5 10.0
50.0 29.8 19.2
46.0 39.0 10.0
30.4 62.4
Contractors
Commercial/Industrial Accounts
4.7 2.5
Other Customer Types
2.0
0.0
1.0
5.0
Total Sales
100.0
100.0
100.0
100.0
100.0
100.0
Business Hours
Monday Tuesday
10.5 10.5 10.5 10.5 10.5
10.5 10.5 10.5 10.5 10.5
10.0 10.0 10.0 10.0 10.0
10.0 10.0 10.0 10.0 10.0
11.0 11.0 10.5 11.0 11.0
10.0 10.0 10.0 10.0 10.0
Wednesday
Thursday
Friday
Saturday
9.0 0.0
9.0 7.0
9.0 0.0
8.3 0.0
9.0 0.0
9.0 4.0
Sunday
Total Hours Open Per Week
61.5
68.5
59.0
58.3
63.5
63.0
Employee Productivity
Number Of Full-Time Employees Number Of Part-Time Employees
15
27
9 3
8 5
17
37
5
5
6
6
Sales $ Per FTE Employee
304,906 96,826 43,266
N/A N/A N/A 16.7 42.5 N/A 5.80 N/A
261,617 81,626 35,872
285,067 74,110 38,832
313,586 127,482 67,325
442,206 119,505 44,438
Gross Profit $ Per FTE Employee Payroll $ Per FTE Employee
Payroll Expense (% Of Sales)
16.8 50.3
18.5 52.4
14.9 44.6
16.2 49.8
16.5 51.6
Personnel Productivity Ratio (%)
Wage $ Per Hour
20.80
17.20
18.70
32.40
21.40
Sales $ Per Payroll Dollar Sales $ Per Payroll Hour
6.40
6.20
7.00
6.10
6.90
146.60
125.80
137.10
150.80
212.60
28
Made with FlippingBook. PDF to flipbook with ease