| Group Report: | Business Focus Forum | The Champions Group | |||||||||||||||||
|
Consolidation Report - Page 1 | ||||||||||||||||||
| Beginning Period: | 1/1/2003 |
|
|||||||||||||||||
| Ending Period: | 3/31/2003 | ||||||||||||||||||
| Provided By: AEII | |||||||||||||||||||
| Gross Profits | Target | Group | Line | B1675 | B2675 | B3675 | B4675 | B5675 | B6675 | B7675 | |||||||||
| Metal | 65.00% | 65.37% | 1 | 64.47% | 61.02% | 60.19% | 58.98% | 59.97% | 71.94% | 81.03% | |||||||||
| Paint | 65.00% | 66.59% | 2 | 69.00% | 60.32% | 62.98% | 58.79% | 57.47% | 100.00% | 57.57% | |||||||||
| Parts | 34.00% | 23.35% | 3 | 25.43% | 22.69% | 22.61% | 31.13% | 35.45% | 1.55% | 24.62% | |||||||||
| Paint/Material | 40.00% | 35.48% | 4 | 45.49% | 27.12% | 56.88% | 19.08% | 14.12% | 39.27% | 46.38% | |||||||||
| Sublet | 30.00% | 2.65% | 5 | 23.59% | -0.79% | 54.05% | 29.31% | -166.93% | 55.16% | 24.18% | |||||||||
| Towing | 10.00% | 39.21% | 6 | 45.41% | 15.61% | 16.66% | 42.84% | 84.64% | 0.76% | 68.57% | |||||||||
| Other | 30.00% | 32.30% | 7 | 44.64% | 21.76% | -65.11% | 52.43% | 48.87% | 92.03% | 31.50% | |||||||||
| Total Gross Profit | 47.65% | 44.58% | 8 | 45.42% | 41.75% | 41.99% | 42.48% | 40.93% | 45.84% | 53.67% | |||||||||
| Costs | |||||||||||||||||||
| Total Overhead % | 28.50% | 33.97% | 9 | 36.37% | 39.86% | 27.84% | 34.61% | 38.09% | 25.64% | 35.40% | |||||||||
| Indirect Labor % | 9.57% | 7.95% | 10 | 12.95% | 10.51% | 8.82% | 11.89% | 3.80% | 0.89% | 6.76% | |||||||||
| Total Sales $ | Not Available | 606,757 | 11 | 1,092,100 | 964,320 | 759,193 | 344,014 | 571,556 | 223,419 | 292,696 | |||||||||
| * Net Profit % | 25.15% | 10.61% | 12 | 9.05% | 1.89% | 14.14% | 7.87% | 2.85% | 20.20% | 18.27% | |||||||||
| Other KPIs | |||||||||||||||||||
| Average RO | 2,100.00 | 2,170.96 | 13 | 3,329.57 | 3,214.40 | 2,108.87 | 1,782.46 | 1,681.05 | 1,909.57 | 1,170.78 | |||||||||
| Total Dollars per Day | 1,250.00 | 952.15 | 14 | 1,444.58 | 1,020.44 | 1,095.52 | 780.08 | 838.06 | 886.59 | 599.79 | |||||||||
| Dollars per Sq Ft Daily | 1.00 | 0.93 | 15 | 2.34 | 0.82 | 0.60 | 0.96 | 0.61 | 0.78 | 0.40 | |||||||||
| Dollars per Stall Daily | 500.00 | 367.06 | 16 | 722.29 | 283.46 | 344.31 | 390.04 | 384.11 | 253.31 | 191.93 | |||||||||
| GP$ per Hour | Not Available | 437.77 | 17 | 787.28 | 608.63 | 532.60 | 289.98 | 397.21 | 162.58 | 286.11 | |||||||||
| Vehicles Per Day | Not Available | 4.31 | 18 | 5.21 | 4.76 | 5.71 | 3.06 | 5.48 | 1.86 | 4.10 | |||||||||
| Part to Repair Ratio | 100.00% | 111.13% | 19 | 101.81% | 91.06% | 118.59% | 118.90% | 167.37% | 105.09% | 75.06% | |||||||||
| Paint to Metal Ratio | 80.00% | 59.49% | 20 | 54.39% | 68.49% | 62.04% | 52.90% | 68.63% | 0.00% | 109.98% | |||||||||
| Bays/Techs | 1.50 | 2.80 | 21 | 2.00 | 3.60 | 3.18 | 2.00 | 2.18 | 3.50 | 3.13 | |||||||||
| Direct/Indirect | 2.00 | 1.85 | 22 | 1.00 | 1.50 | 1.00 | 1.75 | 3.67 | 2.00 | 2.00 | |||||||||
| Closing Ratio | 80.00% | 81.16% | 23 | 100.00% | 75.00% | 90.00% | 78.14% | 75.56% | 78.00% | 71.43% | |||||||||
| Comebacks | 2.00% | 1.30% | 24 | 0.00% | 2.00% | 1.39% | 1.04% | 1.76% | 1.71% | 1.20% | |||||||||
| CSI | 100.00% | 84.54% | 25 | 100.00% | 98.00% | 98.50% | 99.30% | 98.00% | 0.00% | 98.00% | |||||||||
| Efficiencies | |||||||||||||||||||
| Metal Hours | Not Available | 4183.54 | 26 | 8,006.23 | 5,812.77 | 4,864.89 | 3,739.94 | 3,413.04 | 847.58 | 2,600.35 | |||||||||
| Paint Hours | Not Available | 2485.51 | 27 | 4,354.26 | 3,978.11 | 3,531.66 | 1,417.38 | 2,111.46 | 678.03 | 1,327.70 | |||||||||
| Shop Efficiency | 175.00% | 110.16% | 28 | 163.50% | 98.67% | 127.54% | 146.18% | 85.27% | 60.54% | 89.44% | |||||||||
| Effective M/P Rate | Not Available | 46.15 | 29 | 65.40 | 50.32 | 48.46 | 52.63 | 34.11 | 36.32 | 35.77 | |||||||||
| Actual P/M Rate | Not Available | 21.32 | 30 | 17.09 | 31.75 | 25.48 | 11.11 | 18.11 | 26.24 | 19.44 | |||||||||
| Variance from Posted | 0.00% | -10.13% | 31 | -14.55% | 5.83% | 6.17% | -44.44% | -9.47% | -2.83% | -11.64% | |||||||||
| P/M Cost per Hour | 11.00 | 15.93 | 32 | 12.76 | 20.66 | 9.75 | 17.57 | 19.01 | 18.44 | 13.35 | |||||||||
| * Net Profit excludes all owner compensation and benefits | This Report is confidential and should not be distributed outside this Group | ||||||||||||||||||