| CONSOLIDATED DAILY SALES for QUICK LUBE |
|
|
6/24/2007 |
|
Back Office Report |
Page 1 |
|
|
STORES INCLUDED for Month of 06/07
0001 18,19,20,21,22,23,24, , , , , , , ,
0002 18,19,20,21,22,23,24, , , , , , , ,
0003 18,19,20,21,22,23,24, , , , , , , ,
0004 18,19,20,21,22,23,24, , , , , , , ,
0005 18,19,20,21,22,23,24, , , , , , , ,
0006 18,19,20,21,22,23,24, , , , , , , ,
0007 18,19,20,21,22,23,24, , , , , , , ,
0009 18,19,20,21,22,23,24, , , , , , , ,
0010 18,19,20,21,22,23,24, , , , , , , ,
0011 18,19,20,21,22,23,24, , , , , , , ,
Code Description Units % Amount % / $
---- --------------------------- ----- ---- ----------- -----
1 FULL SERVICE OIL CHANGE____ 2,066 74% $59,893.34 39%
1 FULL SERVICE FLEET_________ 169 6% $4,899.31 3%
1 FULL SERVICE HIGH MILEAGE__ 148 5% $5,734.52 4%
1 FULL SERVICE MOBIL 1_______ 249 9% $14,937.51 10%
1 FULL SERVICE SEMI SYNTH____ 10 0% $489.90 0%
1 FULL SERVICE DRIVE CLEAN___ 36 1% $1,295.64 1%
1 FULL SERVICE SYNTHETIC_____ 47 2% $2,819.53 2%
2 AIR FILTER_________________ 476 17% $8,240.24 5%
4 BREATHER___________________ 39 1% $233.61 0%
5 PCV VALVE__________________ 87 3% $782.13 1%
6 WIPER BLADE________________ 280 10% $3,438.98 2%
7 SERPENTINE BELT____________ 17 1% $1,199.83 1%
8 FUEL SYSTEM SERVICE________ 123 4% $7,378.65 5%
8 THROTTLE BODY CLEANING_____ 27 1% $431.73 0%
9 COOLANT SYSTEM FLUSH_______ 51 2% $3,059.49 2%
9 EXTENDED LIFE FLUSH________ 12 0% $959.88 1%
9 EXTENDED LIFE RAD FLUSH____ 3 0% $299.97 0%
11 FRONT DIFFERENTIAL SVC_____ 9 0% $269.91 0%
11 REAR DIFFERENTIAL SVC______ 43 2% $1,289.57 1%
11 SYNTHETIC REAR DIFF SVC____ 15 1% $824.85 1%
12 MANUAL TRANS SERVICE_______ 8 0% $239.92 0%
13 TRANSFER CASE SERVICE______ 8 0% $239.92 0%
15 CHASSIS LUBE_______________ 1 0% $11.99 0%
16 DRAIN PLUG_________________ 24 1% $47.76 0%
17 RADIATOR CAP_______________ 34 1% $477.66 0%
20 OIL SYSTEM CLEANER_________ 518 18% $6,728.82 4%
20 DIESEL FUEL OIL CLEANER____ 4 0% $239.96 0%
20 STOP LEAK__________________ 36 1% $467.64 0%
21 FUEL FILTER________________ 86 3% $4,524.14 3%
25 SPECIAL TRANS FLUID________ 6 0% $80.00 0%
25 LIMITED SLIP ADDITIVE______ 16 1% $320.00 0%
26 TRANS FLUID EXCHANGE_______ 73 3% $6,569.27 4%
27 POWER STEERING FLUSH_______ 88 3% $4,399.12 3%
28 LIGHTS_____________________ 159 6% $1,176.41 1%
29 ENGINE TREATMENT___________ 8 0% $199.92 0%
30 GAS TREATMENT______________ 361 13% $3,606.39 2%
- - - Continued on Next Page - - -
| CONSOLIDATED DAILY SALES for QUICK LUBE |
|
|
6/24/2007 |
|
Back Office Report |
Page 2 |
|
|
Code Description Units % Amount % / $
---- --------------------------- ----- ---- ----------- -----
48 PACKAGE DISCOUNTS__________ 438 16% -$4,430.00 -3%
50 CABIN AIR FILTER___________ 39 1% $1,304.61 1%
55 MISC SALES_________________ 23 1% $161.95 0%
61 Extra Oil__________________ 1,329 47% $5,005.28 3%
61 EXTRA CHARGE -OIL FILTER___ 254 9% $2,422.33 2%
61 PREMIUM SYNTHETIC__________ 3 0% $60.00 0%
__________________
Sub Total $152,331.68
Base $15.00 Above Below Total
Cars : 2775 35 2810 - Coupons $1,537.62
Average : $54.81 $54.21
Aver-Coup: $53.75 $53.18 - Discounts $1,364.98
Materials: $43,885.83 29%
Full Services: 2,725 __________________
Net Sales $149,429.08
Ancillary Sales Average: $19.04
- - - Continued on Next Page - - -
| PROFIT CENTER SUMMARY REPORT |
|
|
6/24/2007 |
|
Back Office Report |
Page 3 |
|
|
Profit Center Cars Average Aver-Coup Materials Net Sales %
-------------- ---- ------- --------- --------- --------- ----
QUICK LUBE 2,810 $54.21 $53.18 $43,885.83 $149,429.08 100%
TUNE UP 0 $15.01 $0.00 0%
CAR WASH 0 $0.00 $0.00 0%
__________________
TOTAL $149,429.08
-( 0) Gift Cert $0.00
__________________
NET SALES $149,429.08
NEW CUSTOMERS 965 - 34%
REPEAT CUSTOMERS 1,846 - 66% + SALES TAX $9,994.53
_______ __________________
TOTAL CUSTOMERS 2,811 GROSS SALES $159,423.61
TIME OPENED : 8:50 AM -( 20) Payouts $766.64
TIME CLOSED : 5:02 PM -( 185) Fleets $9,815.08
# OF VOIDS : 22 __________________
CANCELS : 78 TOTAL RECEIPTS $148,841.89
LABOR for Total Hours Total Cost % of
Profit Center Hours /Car Cost /Car Net
------------- ------ ------- ---------- -------- -----
QUICK LUBE 3051.00 1.09 $25,526.26 $9.08 17.08%
TUNE UP 0.00 0.00 $0.00 $0.00 0.00%
CAR WASH 0.00 0.00 $0.00 $0.00 0.00%