Employee Performanc

Texas
Store241.xlsx

variable definitions

Store24

store ID Sales Profit MTenure CTenure Pop Comp Visibility PedCount Res Hours24
101 $ 1,060,294 $ 265,014 - 0 24.8 7,535 2.798 3 3 1 1
201 $ 1,619,874 $ 424,007 86.2 6.6 8,630 4.236 4 3 1 1
301 $ 1,099,921 $ 222,735 23.9 5.0 9,695 4.495 3 3 1 1
401 $ 1,053,860 $ 210,122 - 0 5.4 2,797 4.254 4 2 1 1
501 $ 1,227,841 $ 300,480 3.9 6.9 20,335 1.651 2 5 0 1
601 $ 1,703,140 $ 469,050 149.9 11.4 16,926 3.185 3 4 1 0
701 $ 1,809,256 $ 476,355 62.5 7.3 17,754 3.378 2 5 1 1
801 $ 1,378,482 $ 361,115 - 0 56.8 20,824 2.895 4 3 1 1
901 $ 2,113,089 $ 474,725 109.0 6.1 26,519 2.638 2 4 1 1
1001 $ 1,080,979 $ 278,625 31.5 23.2 16,381 2.271 4 3 1 0
1101 $ 1,583,446 $ 389,886 44.8 2.0 21,550 3.272 2 5 1 1
1201 $ 1,444,714 $ 329,020 278.0 6.6 11,160 4.904 4 4 1 0
1301 $ 857,843 $ 152,513 0.7 1.6 14,186 4.436 3 2 1 1
1401 $ 1,171,491 $ 261,571 87.4 3.0 6,898 4.233 4 2 1 1
1501 $ 1,005,627 $ 203,951 - 0 8.5 8,684 3.844 3 4 1 1
1601 $ 883,864 $ 196,277 23.7 4.7 6,872 3.345 3 3 1 0
1701 $ 1,095,695 $ 265,584 31.7 3.6 14,477 2.562 3 4 1 1
1801 $ 1,704,826 $ 394,039 240.0 33.8 3,807 3.995 5 3 1 1
1901 $ 1,127,332 $ 261,495 3.4 17.0 4,669 2.754 2 3 1 1
2001 $ 1,320,950 $ 269,235 65.1 5.9 15,377 4.148 3 2 1 1
2101 $ 1,237,518 $ 282,584 24.1 7.2 14,022 4.020 3 3 1 1
2201 $ 1,433,440 $ 367,036 18.4 26.0 8,280 4.464 4 3 1 1
2301 $ 1,351,972 $ 277,414 12.4 3.4 13,797 3.595 3 4 1 1
2401 $ 1,071,307 $ 267,354 44.8 3.4 9,069 3.281 2 3 1 0
2501 $ 1,282,886 $ 282,124 - 0 10.3 6,183 3.517 3 3 1 1
2601 $ 898,548 $ 211,912 0.7 20.4 9,999 4.178 3 2 1 1
2701 $ 985,862 $ 230,194 50.1 17.4 8,153 3.720 3 2 1 1
2801 $ 1,141,465 $ 273,036 23.9 17.0 14,673 3.193 3 4 1 0
2901 $ 924,782 $ 263,956 19.5 23.5 11,350 5.392 3 2 1 1
3001 $ 1,874,873 $ 333,607 73.3 23.4 1,116 3.578 3 2 1 1
3101 $ 993,597 $ 211,885 - 0 10.8 2,578 3.101 2 2 1 1
3201 $ 828,918 $ 149,033 36.1 6.6 9,697 4.641 3 3 1 0
3301 $ 1,369,092 $ 292,745 51.7 3.9 8,177 5.309 3 2 1 1
3401 $ 1,557,084 $ 382,199 29.2 19.7 10,923 2.361 4 4 1 1
3501 $ 1,443,230 $ 322,624 37.0 14.8 14,361 3.613 4 3 1 1
3601 $ 1,016,950 $ 219,292 41.6 20.9 3,218 3.929 3 2 1 1
3701 $ 1,202,917 $ 187,765 23.2 1.3 8,870 4.492 3 3 1 1
3801 $ 991,524 $ 203,184 15.6 1.6 6,557 4.226 3 2 1 1
3901 $ 979,361 $ 221,130 34.7 5.5 8,896 5.046 2 4 1 1
4001 $ 1,042,664 $ 222,913 122.8 16.8 2,521 11.128 3 4 1 1
4101 $ 744,211 $ 147,327 14.9 11.9 9,701 4.365 2 3 1 1
4201 $ 1,273,855 $ 264,072 2.5 86.1 2,106 3.231 3 2 1 1
4301 $ 1,296,711 $ 337,233 177.6 5.5 3,495 3.654 4 3 1 1
4401 $ 1,807,740 $ 439,781 182.2 114.2 20,624 3.629 3 4 0 1
4501 $ 1,602,362 $ 410,149 47.6 9.2 17,808 3.473 5 3 1 1
4601 $ 1,339,214 $ 315,780 6.2 5.3 9,285 3.144 4 3 1 1
4701 $ 1,665,657 $ 387,853 12.8 6.6 23,623 2.423 2 5 1 1
4801 $ 1,243,167 $ 284,169 31.5 8.2 8,491 4.849 3 2 1 1
4901 $ 983,296 $ 195,276 55.4 14.7 1,863 3.714 4 1 1 1
5001 $ 935,257 $ 251,013 12.8 16.1 14,653 1.752 3 4 1 0
5101 $ 1,027,035 $ 237,344 3.4 7.1 3,126 2.447 2 4 1 1
5201 $ 1,073,008 $ 169,201 24.1 3.4 14,859 6.585 3 3 1 1
5301 $ 1,355,684 $ 365,018 57.2 8.2 6,909 3.157 2 2 1 1
5401 $ 811,190 $ 159,792 6.7 3.9 3,747 3.756 3 2 1 1
5501 $ 925,744 $ 147,672 6.7 18.4 10,532 6.389 4 3 1 1
5601 $ 916,197 $ 189,235 4.8 2.7 13,740 4.597 2 3 1 0
5701 $ 699,306 $ 122,180 24.3 3.0 3,642 2.973 3 2 1 1
5801 $ 989,760 $ 227,601 4.6 4.1 8,477 3.994 4 2 1 1
5901 $ 1,334,898 $ 303,069 13.3 13.8 6,231 3.301 3 3 1 1
6001 $ 1,433,624 $ 356,071 33.5 6.4 8,845 2.720 3 4 1 1
6101 $ 716,589 $ 177,046 21.8 13.3 3,014 3.264 3 1 1 1
6201 $ 942,915 $ 202,641 12.2 6.9 9,820 4.201 3 4 1 0
6301 $ 1,045,264 $ 239,036 8.2 6.9 7,581 4.137 3 3 1 1
6401 $ 969,509 $ 221,157 - 0 0.9 17,110 2.379 4 3 1 1
6501 $ 1,349,972 $ 301,641 150.2 23.4 1,075 3.219 3 1 1 1
6601 $ 879,581 $ 146,058 115.2 3.9 1,046 6.570 2 3 1 1
6701 $ 1,228,052 $ 362,067 5.3 3.4 11,552 3.583 3 3 1 1
6801 $ 1,018,195 $ 236,339 17.4 2.3 9,018 3.505 4 2 1 1
6901 $ 1,574,290 $ 375,393 44.1 26.8 5,050 3.949 3 3 1 1
7001 $ 1,207,204 $ 254,203 14.9 3.9 19,809 3.122 3 4 1 0
7101 $ 977,566 $ 198,529 43.9 38.4 3,265 3.856 2 1 1 1
7201 $ 848,140 $ 196,772 126.5 27.4 3,151 3.681 2 1 1 1
7301 $ 1,115,450 $ 279,193 41.1 6.4 6,276 4.180 4 3 1 1
7401 $ 1,782,957 $ 518,998 171.1 29.5 10,913 2.320 3 4 1 0
7501 $ 1,321,870 $ 296,826 2.3 8.7 8,966 1.886 4 4 0 1

Dependent

Variable

Profit Profit for the last fiscal year in US Dollars before corporate overhead allocations, rent and depreciation

MTenure

Average manager tenure during the last fiscal year where tenure is defined as the number of months of

experience with Store24

CTenure

Average crew tenure during the last fiscal year where tenure is defined as the number of months of

experience with Store24

Comp Number of competitors per 10,000 people within a ½ mile radius

Pop Population within a ½ mile radius

Visibility 5-point rating of store visibility with 5 being the highest

PedCount 5-point rating of pedestrian foot traffic with 5 being the highest

Hours24 Indicator for open 24 hours or not

Res Indicator for located in residential vs. industrial area

Employee

Related

Factors

Site Related

Factors