Statistics

^{s}Goals: Allows you to edit the monthly goals. (Alt + G)

Print: Prints the statistics. (Alt + P)

Close: Closes the Statistics window. (Esc or Alt + C)

Help: Opens context sensitive help. (F1)
 ^{m}All Locations: Shows statistics from all locations. (Alt + A)

Manager: Allows access to secure items.

Previous: Moves to the previous month. (Alt + Left Arrow)

Next: Moves to the next month. (Alt + Right Arrow)

Chart: Opens the chart for the selected column. (Alt + H)
Back to Top
Statistics Summary
This section allows you to view a summary of all store's statistics based on the monthly goals. To open the Statistics Summary window, select
Company, Statistics (Alt + O, S) from the main dropdown menu and select the Summary tab.
 Store: Store location.
 ^{c}Sales: Sales percentage based on goal.
Formula: sales / ((sales goal / days in month) * days finished in month)
 Last Year: Last year sales for the given month.
 ^{c}Cars: Car count percentage based on goal.
Formula: car count / ((car count goal / days in month) * days finished in month)
 ^{c}Avg. Ticket: Sales divided by car count.
Formula: average ticket / (sales goal / car count goal)
 ^{c}Hours: Hours percentage based on goal.
Formula: hours / ((hours goal / days in month) * days finished in month)
 ^{c}Hrs. per R.O.: Hours count divided by car count.
Formula: (hours / car count) / hours per RO goal
 ^{c}Spiffs: Spiffs divided by spiffs goal.
Formula: spiff goal / ((spiffs goal / days in month) * days finished in month)
 ^{c}Score: Score based on sales percentage, car count percentage, hours count percentage, average ticket percentage and
last year sales percentage.
Formula: (sales percentage + car count percentage + average ticket percentage + hour count percentage + last year sales percentage) / 5
Formula (No data last year): (sales percentage + car count percentage + average ticket percentage + hour count percentage) / 4
 Recalculate: Recalculates the statistics for the selected month. (Alt + R)
 As of Yesterday: Recalculates as of yesterday. (Alt + Y)
 Now: Recalculates as of now. (Alt + N)
(Note: Accuracy may be affected on some calculations when recalculating before the end of the business day.)
Back to Top
Daily
This section allows you to view daily store's statistics based on the monthly goals. To open the Daily Statistics window, select
Company, Statistics (Alt + O, S) from the main dropdown menu and select the Daily tab.
 Store: Store location.
 Sales Goal: Sales goal per day.
Formula: sales goal / days finished in month
 ^{c}Sales Actual: Actual sales for the month.
Formula: sales / days finished in month
 Sales Needed: Sales needed each remaining day to make monthly sales goal.
Formula: (sales goal  sales) / remaining days in month
 Cars Goal: Car count goal per day.
Formula: car count goal / days finished in month
 ^{c}Cars Actual: Actual car count for the month.
Formula: car count / days finished in month
 Cars Needed: Cars needed each remaining day to make monthly car count goal.
Formula: (car count goal  car count) / remaining days in month
 Hours Goal: Hours count goal per day.
Formula: hours goal / days finished in month
 ^{c}Hours Actual: Actual hours count for the month.
Formula: hours / days finished in month
 Hrs. Needed: Hours needed each remaining day to make monthly hours count goal.
Formula: (hours goal  hours) / remaining days in month
Back to Top
Monthly Pace
This section allows you to view the store's monthly pace. To open the Monthly Pace window, select Company, Statistics
(Alt + O, S) from the main dropdown menu and select the Monthly Pace tab.
 Store: Store location.
 ^{c}Sales: Projected sales.
Formula: sales / ((sales goals / days in month) * days finished in month)
 Last Year: Last year sales for the given month.
 ^{c}Cars: Projected car count.
Formula: car count / ((car count goal / days in month) * days finished in month)
 ^{c}Avg. Ticket: Projected average ticket dollars.
Formula: average ticket / (sales goal / car count goal)
 ^{c}Hours: Projected hours.
Formula: hours / ((hours goal / days in month) * days finished in month)
 ^{c}Hrs. per R.O.: Projected hours per RO.
Formula: (hours / car count) / hours per RO goal
 ^{c}Spiffs: Projected spiffs count.
Formula: spiffs / ((spiffs / days in month) * days finished in month)
 ^{s}Net Income %: Projected net income percent.
Formula: (net sales  cost  overhead) / net sales
 ^{s}Net Income $: Projected net income dollars.
Formula: net sales  cost  overhead
Back to Top
Totals
This section allows you to view the statistic totals for all stores based the on monthly goals. To open the Statistic Totals window, select
Company, Statistics (Alt + O, S) from the main dropdown menu and select the Totals tab.
 Store: Districts & total company.
 Sales: Projected sales.
Formula: sales / ((sales goals / days in month) * days finished in month)
 Last Year: Last year sales for the given month.
 Cars: Projected car count.
Formula: car count / ((car count goal / days in month) * days finished in month)
 Avg. Ticket: Projected average ticket dollars.
Formula: average ticket / (sales goal / car count goal)
 Hours: Projected hours.
Formula: hours / ((hours goal / days in month) * days finished in month)
 Hrs. per R.O.: Projected hours per RO.
Formula: (hours / car count) / hours per RO goal
 Spiffs: Projected spiffs count.
Formula: spiffs / ((spiffs / days in month) * days finished in month)
 ^{s}Net Income %: Projected net income percent.
Formula: (net sales  cost  overhead) / net sales
 ^{s}Net Income $: Projected net income dollars.
Formula: net sales  cost  overhead
Back to Top
Store Statistics
This section allows you to view store statistics for the current month. To open the Store Statistics window, select Company, Statistics
(Alt + O, S) from the main dropdown menu and select the Store Statistics tab.
 Store: Store location.
 ^{c}Sales: Repair order subtotal minus discount dollars.
Formula: subtotal  discount
 Last Year: Last year sales.
 ^{c}Car Count: Number of repair orders.
 ^{c}Avgerage Ticket: Average R.O. dollars.
Formula: sales / car count
 ^{c}Hours: Total hours billed.
 ^{c}Hours per R.O.: Average hours billed per R.O.
Formula: hours / car count
 ^{c}Spiffs: Total number of spiffs.
 ^{c}E.L.R.: Effective labor rate.
Formula: labor dollars / hours
 ^{c}A.T.R.: Average technician rate.
Formula: technician rate total / technician rate count
 ^{c}L/P: Labor dollars divided by part dollars.
Formula: labor / parts
 ^{c}Net G.P.: Net gross profit percentage.
Formula: (sales  cost) / sales
 ^{c}G.P. Labor: Gross profit percentage for labor.
Formula: (labor sales  labor cost) / labor sales
 ^{c}Labor $: Labor sales.
 ^{c}G.P. Parts: Gross profit percentage for parts.
Formula: (part sales  part cost) / part sales
 ^{c}Parts $: Part sales.
 ^{c}G.P. Sublet: Gross profit percentage for sublet labor.
Formula: (sublet sales  sublet cost) / sublet sales
 ^{c}Sublet Labor $: Sublet labor sales.
 G.P. Sublet: Gross profit percentage minus sublet labor.
Formula: ((sales  sublet sales)  (cost  sublet cost)) / (sales  sublet sales)
 ^{c}G.P. Fluids: Gross profit percentage for fluids.
Formula: (fluid sales  fluid cost) / fluid sales
 ^{c}Fluids $: Fluid sales.
 ^{c}G.P. Tires: Gross profit percentage for tires.
Formula: (tire sales  tire cost) / tire sales
 ^{c}Tires $: Tire sales.
 G.P. Tires: Gross profit percentage minus tires.
Formula: ((sales  tire sales)  (cost  tire cost)) / (sales  tire sales)
 G.P. Sublet/Tire: Gross profit percentage minus sublet labor & tires.
Formula: ((sales  (sublet sales + tire sales))  (cost  (sublet cost + tire cost))) / (sales  (sublet sales + tire sales))
 Sublet + Tire %: Percentage of sublet & tire sales versus sales.
Formula: (sublet sales + tire sales) / sales
 G.P. Shop Supplies: Gross profit percentage for shop supplies.
Formula: (shop supply sales  shop supply cost) / shop supply sales
 Shop Supplies $: Shop supply sales.
 ^{c}Shop Supply %: Percentage of shop supply sales versus sales.
Formula: shop supply sales / sales
 G.P. Haz. Waste: Gross profit percentage for hazardous waste.
Formula: (haz. waste sales  haz. waste cost) / haz. waste sales
 Hazardous Waste $: Hazardous waste sales.
 ^{c}Hazardous Waste %: Percentage of hazardous waste sales versus sales.
Formula: hazardous waste sales / sales
 Haz. + Shop. %: Percentage of hazardous waste & shop supply sales versus sales.
Formula: (hazardous waste sales + shop supply sales) / sales
 G.P. Variable #1: Gross profit percentage for price variable #1.
Formula: (price variable #1 sales  price variable #1 cost) / price variable #1 sales
 Variable #1 $: Variable #1 sales.
 G.P. Variable #2: Gross profit percentage for price variable #2.
Formula: (price variable #2 sales  price variable #2 cost) / price variable #2 sales
 Variable #2 $: Variable #2 sales.
 G.P. Variable #3: Gross profit percentage for price variable #3.
Formula: (price variable #3 sales  price variable #3 cost) / price variable #3 sales
 Variable #3 $: Variable #3 sales.
 G.P. Other: Gross profit percentage for road hazard, state disposal, disposal fee, FET & the tire variable combined.
Formula: (other sales  other cost) / other sales
 Other $: Road hazard, state disposal, disposal fee, FET & the tire variable sales combined.
 Discount $: Total discount dollars.
 ^{c}Discount %: Percentage of discount versus sales.
Formula: discount / sales
 Tire Count: Number of tires sold.
 LOF Count: Number of LOF labors sold.
 Prevent Count: Number of Preventative Maintenance labors sold.
 Minor Count: Number of Minor Service labors sold.
 Major Count: Number of Major Service labors sold.
 Align Count: Number of Wheel Alignment labors sold.
 Flush Count: Number of Flushes labors sold.
 Goals: Allows you to compare against monthly goals.
 Deviation: Allows you to compare against deviation.
 Deviation %: Allows you to compare against deviation percent.
 Expand: Expands the top grid.
 Collapse: Collapses the top grid.
Back to Top
Deviation
This section allows you to view statistics deviation based on the monthly goals. To open the Statistics Deviation window, select
Company, Statistics (Alt + O, S) from the main dropdown menu and select the Store Deviation tab.
 Store: Store location.
 ^{c}Sales: Sales deviation.
Formula: sales  (sales goal / days in month) * days finished in month
 ^{c}Car Count: Car count deviation.
Formula: car count  (car count goal / days in month) * days finished in month
 ^{c}Avgerage Ticket: Average ticket deviation.
Formula: average ticket  average ticket goal
 ^{c}Hours: Hours deviation.
Formula: hours  (hours goal / days in month) * days finished in month
 ^{c}Hours per R.O.: Hours per RO deviation.
Formula: hours per RO  hours per RO goal
 ^{c}Spiffs: Spiffs deviation.
Formula: spiffs  (spiffs goal / days in month) * days finished in month
 ^{c}E.L.R.: ELR deviation.
Formula: ELR  ELR goal
 ^{c}A.T.R.: ATR deviation.
Formula: ATR  ATR goal
 ^{c}L/P: LP deviation.
Formula: LP  LP goal
 ^{c}Net G.P.: Net GP deviation.
Formula: net GP  net GP goal
 ^{c}G.P. Labor: GP labor deviation.
Formula: GP labor  GP labor goal
 ^{c}G.P. Parts: GP parts deviation.
Formula: GP parts  GP parts goal
 ^{c}G.P. Sublet: GP sublet labor deviation.
Formula: GP sublet labor  GP sublet labor goal
 ^{c}G.P. Fluids: GP fluids deviation.
Formula: GP fluids  GP fluids goal
 ^{c}G.P. Tires: GP tires deviation.
Formula: GP tires  GP tires goal
 ^{c}Shop Supply %: Shop supply percentage deviation.
Formula: shop supply %  shop supply % goal
 ^{c}Hazardous Waste %: Hazardous waste percentage deviation.
Formula: hazardous waste %  hazardous waste % goal
 ^{c}Discount %: Discount percentage deviation.
Formula: discount %  discount % goal
 Goals: Allows you to compare against monthly goals.
 Store Statistics: Allows you to compare against store statistics.
 Deviation %: Allows you to compare against deviation percent.
 Expand: Expands the top grid.
 Collapse: Collapses the top grid.
Back to Top
Deviation %
This section allows you to view statistics deviation percentages based on the monthly goals. To open the Store Deviation Percent window, select
Company, Statistics (Alt + O, S) from the main dropdown menu and select the Store Deviation Percent tab.
 Store: Store location.
 ^{c}Sales: Sales deviation percent.
Formula: sales / ((sales goal / days in month) * days finished in month)
 ^{c}Car Count: Car count deviation percent.
Formula: car count / ((car count goal / days in month) * days finished in month)
 ^{c}Avgerage Ticket: Average ticket deviation percent.
Formula: average ticket / (sales goal / car count goal)
 ^{c}Hours: Hours deviation percent.
Formula: hours / ((hours goal / days in month) * days finished in month)
 ^{c}Hours per R.O.: Hours per RO deviation percent.
Formula: (hours / car count) / hours per RO goal
 ^{c}Spiffs: Spiffs deviation percent.
Formula: spiffs / ((spiffs goal / days in month) * days finished in month)
 ^{c}E.L.R.: ELR deviation percent.
Formula: ELR / ELR goal
 ^{c}A.T.R.: ATR deviation percent.
Formula: ATR / ATR goal
 ^{c}L/P: LP deviation percent.
Formula: LP / LP goal
 ^{c}Net G.P.: Net GP deviation percent.
Formula: net GP / net GP goal
 ^{c}G.P. Labor: GP labor deviation percent.
Formula: GP labor / GP labor goal
 ^{c}G.P. Parts: GP parts deviation percent.
Formula: GP parts / GP parts goal
 ^{c}G.P. Sublet: GP sublet labor deviation percent.
Formula: GP sublet labor / GP sublet labor goal
 ^{c}G.P. Fluids: GP fluids deviation percent.
Formula: GP fluids / GP fluids goal
 ^{c}G.P. Tires: GP tires deviation percent.
Formula: GP tires / GP tires goal
 ^{c}Shop Supply %: Shop supply percentage deviation percent.
Formula: shop supply % / shop supply % goal
 ^{c}Hazardous Waste %: Hazardous waste percentage deviation percent.
Formula: hazardous waste % / hazardous waste % goal
 ^{c}Discount %: Discount percentage deviation percent.
Formula: discount % / discount % goal
 Goals: Allows you to compare against monthly goals.
 Store Statistics: Allows you to compare against store statistics.
 Deviation: Allows you to compare against deviation.
 Expand: Expands the top grid.
 Collapse: Collapses the top grid.
Back to Top
Service Writer
This section allows you to view service writer statistics for the current month. To open the Service Writer Statistics window, select Company,
Statistics (Alt + O, S) from the main dropdown menu and select the Service Writer Statistics tab.
 Store: Store location.
 Service Writer: Service writer.
 ^{c}Sales: Repair order subtotal minus discount dollars.
Formula: subtotal  discount
 ^{c}Car Count: Number of repair orders.
 ^{c}Avgerage Ticket: Average R.O. dollars.
Formula: sales / car count
 ^{c}Hours: Total hours billed.
 ^{c}Hours per R.O.: Average hours billed per R.O.
Formula: hours / car count
 ^{c}Spiffs: Total number of spiffs.
 ^{c}E.L.R.: Effective labor rate.
Formula: labor dollars / hours
 ^{c}A.T.R.: Average technician rate.
Formula: technician rate total / technician rate count
 ^{c}L/P: Labor dollars divided by part dollars.
Formula: labor / parts
 ^{c}Net G.P.: Net gross profit percentage.
Formula: (sales  cost) / sales
 ^{c}G.P. Labor: Gross profit percentage for labor.
Formula: (labor sales  labor cost) / labor sales
 ^{c}Labor $: Labor sales.
 ^{c}G.P. Parts: Gross profit percentage for parts.
Formula: (part sales  part cost) / part sales
 ^{c}Parts $: Part sales.
 ^{c}G.P. Sublet: Gross profit percentage for sublet labor.
Formula: (sublet sales  sublet cost) / sublet sales
 ^{c}Sublet Labor $: Sublet labor sales.
 G.P. Sublet: Gross profit percentage minus sublet labor.
Formula: ((sales  sublet sales)  (cost  sublet cost)) / (sales  sublet sales)
 ^{c}G.P. Fluids: Gross profit percentage for fluids.
Formula: (fluid sales  fluid cost) / fluid sales
 ^{c}Fluids $: Fluid sales.
 ^{c}G.P. Tires: Gross profit percentage for tires.
Formula: (tire sales  tire cost) / tire sales
 ^{c}Tires $: Tire sales.
 G.P. Tires: Gross profit percentage minus tires.
Formula: ((sales  tire sales)  (cost  tire cost)) / (sales  tire sales)
 G.P. Sublet/Tire: Gross profit percentage minus sublet labor & tires.
Formula: ((sales  (sublet sales + tire sales))  (cost  (sublet cost + tire cost))) / (sales  (sublet sales + tire sales))
 Sublet + Tire %: Percentage of sublet & tire sales versus sales.
Formula: (sublet sales + tire sales) / sales
 G.P. Shop Supplies: Gross profit percentage for shop supplies.
Formula: (shop supply sales  shop supply cost) / shop supply sales
 Shop Supplies $: Shop supply sales.
 ^{c}Shop Supply %: Percentage of shop supply sales versus sales.
Formula: shop supply sales / sales
 G.P. Haz. Waste: Gross profit percentage for hazardous waste.
Formula: (haz. waste sales  haz. waste cost) / haz. waste sales
 Hazardous Waste $: Hazardous waste sales.
 ^{c}Hazardous Waste %: Percentage of hazardous waste sales versus sales.
Formula: hazardous waste sales / sales
 Haz. + Shop. %: Percentage of hazardous waste & shop supply sales versus sales.
Formula: (hazardous waste sales + shop supply sales) / sales
 G.P. Variable #1: Gross profit percentage for price variable #1.
Formula: (price variable #1 sales  price variable #1 cost) / price variable #1 sales
 Variable #1 $: Variable #1 sales.
 G.P. Variable #2: Gross profit percentage for price variable #2.
Formula: (price variable #2 sales  price variable #2 cost) / price variable #2 sales
 Variable #2 $: Variable #2 sales.
 G.P. Variable #3: Gross profit percentage for price variable #3.
Formula: (price variable #3 sales  price variable #3 cost) / price variable #3 sales
 Variable #3 $: Variable #3 sales.
 G.P. Other: Gross profit percentage for road hazard, state disposal, disposal fee, FET & the tire variable combined.
Formula: (other sales  other cost) / other sales
 Other $: Road hazard, state disposal, disposal fee, FET & the tire variable sales combined.
 Discount $: Total discount dollars.
 ^{c}Discount %: Percentage of discount versus sales.
Formula: discount / sales
 Tire Count: Number of tires sold.
 LOF Count: Number of LOF labors sold.
 Prevent Count: Number of Preventative Maintenance labors sold.
 Minor Count: Number of Minor Service labors sold.
 Major Count: Number of Major Service labors sold.
 Align Count: Number of Wheel Alignment labors sold.
 Flush Count: Number of Flushes labors sold.
 Goals: Allows you to compare against monthly goals.
 Store Statistics: Allows you to compare against store statistics.
 Deviation: Allows you to compare against deviation.
 Deviation %: Allows you to compare against deviation percent.
 Expand: Expands the top grid.
 Collapse: Collapses the top grid.
Back to Top
Store Sales History
This section allows you to view store sales histories by dollar amount. To open the Store Sales History window, select Company, Statistics
(Alt + O, S) from the main dropdown menu and select the Store Sales History tab.
 Daily: Shows the store sales histories on a daily basis. (Alt + D)
 Weekly: Shows the store sales histories on a weekly basis. (Alt + W)
 Monthly: Shows the store sales histories on a monthly basis. (Alt + M)
^{c}Can create chart.
^{m}MultiLocation program only.
^{s}Area protected by security.
^{w}Web interface only.
See Also: Monthly Goals