{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title Page","Tab A ","Tab B","Tab C","Tab D","Tab F"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title Page","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Fixed Operations 2 - Service"]
[]
[null,null,"Financial Calculations and Formulas"]

{"sheet":"Tab A ","index":1,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,22,3,25],[2,2,2,6],[2,9,2,13],[2,16,2,20]]}
[]
[]
[null,null,"Service Department Sales And Gross  (Labor Only)              page  A-3",null,null,null,null,null,null,"Parts To Labor Ratios      page A-5",null,null,null,null,null,null,"Service Department Profit Centering     pageA-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed Absorption     page A-9"]
[null,null,"Category","Sales","Gross","Gross as % of Sales","%Sales Contribution",null,null,null,"Category","Parts Sales","Labor Sales","P/L Ratio",null,null,null,"Expense Category","Dollar Amount",null,null,null,null,null,null,null,null,"% Adj Ovhd Exp"]
[null,null,"Customer Car",null,null,{"$f":"IF(ISERROR(E6/D6),\"0%\",(E6/D6))","v":"0%"},{"$f":"IF(ISERROR(D6/$D$14),\"0%\",(D6/$D$14))","v":"0%"},null,null,null,"Customer Car",null,{"$f":"D6","v":0},{"$f":"IF(ISERROR(L6/M6),\"0.00\",(L6/M6))","v":"0.00"},null,null,null,"Department Gross",null,"% of Gross","Profile",null,null,null,"Parts Department Total Gross",null,null,{"$f":"IF(ISERROR(Z6/$Z$23),\"0.00%\",Z6/$Z$23)","v":"0.00%"}]
[null,null,"Customer Truck",null,null,{"$f":"IF(ISERROR(E7/D7),\"0%\",(E7/D7))","v":"0%"},{"$f":"IF(ISERROR(D7/$D$14),\"0%\",(D7/$D$14))","v":"0%"},null,null,null,"Customer Truck",null,0,{"$f":"IF(ISERROR(L7/M7),\"0.00\",(L7/M7))","v":"0.00"},null,null,null,"Variable Expense",null,{"$f":"IF(ISERROR(S7/$S$6),\"0.00%\",S7/$S$6)","v":"0.00%"}]
[null,null,"Customer Other",null,null,"0%","0%",null,null,null,"Customer Other",null,0,"0.00",null,null,null,"Selling Expense",null,"0.00%",null,null,null,null,"Service Department Total Gross",null,null,{"$f":"IF(ISERROR(Z8/$Z$23),\"0.00%\",Z8/$Z$23)","v":"0.00%"}]
[null,null,"Warranty",null,null,"0%","0%",null,null,null,"Warranty",null,0,"0.00",null,null,null,"Personnel Expense",null,"0.00%"]
[null,null,"Warranty Other",null,null,"0%","0%",null,null,null,"Warranty Other",null,0,"0.00",null,null,null,"Semi-Fixed Expense",null,"0.00%",null,null,null,null,"Body Shop Department Total Gross",null,null,{"$f":"IF(ISERROR(Z10/$Z$23),\"0.00%\",Z10/$Z$23)","v":"0.00%"}]
[null,null,"Internal",null,null,"0%","0%",null,null,null,"Internal ",null,0,"0.00",null,null,null,"Fixed Expense",null,"0.00%"]
[null,null,"NVI / Road Ready",null,null,"0%","0%",null,null,null,"Total",{"$f":"SUM(L6:L11)","v":0},{"$f":"SUM(M6:M11)","v":0},"0.00",null,null,null,"Unallocated Expense",null,"0.00%",null,null,null,null,"Total Fixed Gross Profit ",{"$f":"Z6+Z8+Z10","v":0}]
[null,null,"Adj. Cost Of Labor",null,null,"0%","0%",null,null,null,null,null,null,null,null,null,null,"Dealer's Salary",null,"0.00%"]
[null,null,"Total",{"$f":"SUM(D6:D13)","v":0},{"$f":"SUM(E6:E13)","v":0},{"$f":"IF(ISERROR(E14/D14),\"0.00%\",E14/D14)","v":"0.00%"},{"$f":"SUM(G6:G13)","v":0},null,null,null,null,null,null,null,null,null,null,"Total Expenses",{"$f":"SUM(S7:S13)","v":0},"0.00%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Profit",{"$f":"S6-S14","v":0},"0.00%",null,null,null,null,"Total Dealership Expense"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New & Used Sales Commission Expense     -"]
[null,null,null,null,null,null,null,null,null,null,"The Picture"]
[null,null,null,null,null,null,null,null,null,null,"Customer Pay Gross Profit %",null,{"$f":"E21","v":"0.00%"},null,null,null,null,null,null,null,null,null,null,null,"New & Used Policy Expense                         - "]
[null,null,"The Picture"]
[null,null,"Customer Pay Gross Profit %",null,{"$f":"IF(ISERROR((E6+E7+E8)/(D6+D7+D8)),\"0.00%\",(E6+E7+E8)/(D6+D7+D8))","v":"0.00%"},null,null,null,null,null,"Total Service Dept. G.P. %",null,{"$f":"F14","v":"0.00%"},null,null,null,null,"The Picture",null,null,null,null,null,null,"New & Used Get Ready / Delivery Expense  -"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer Pay Gross Profit %",null,{"$f":"M19","v":"0.00%"}]
[null,null,"Total Service Dept. G.P. %",null,{"$f":"F14","v":"0.00%"},null,null,null,null,null,"Parts / Labor Ratio (Cust. Pay Only) ",null,{"$f":"IF(ISERROR((L6+L7+L8)/(M6+M7+M8)),\"0.00\",(L6+L7+L8)/(M6+M7+M8))","v":"0.00"},null,null,null,null,null,null,null,null,null,null,null,"Adjusted Overhead Expense",{"$f":"Z15-Z17-Z19-Z21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Service Dept. G.P. %",null,{"$f":"M21","v":"0.00%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fixed Gross Profit ",{"$f":"Z12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parts / Labor Ratio (Cust. Pay Only) ",null,{"$f":"M23","v":"0.00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted Overhead Expense",{"$f":"Z23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Service Dept. Expenses",null,{"$f":"S14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Absorption Percentage",{"$f":"IF(ISERROR(Z25/Z27),\"0.00%\",(Z25/Z27))","v":"0.00%"},null,"Guideline 75%"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Picture"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer Pay Gross Profit %",{"$f":"E21","v":"0.00%"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Service Dept. G.P. %",{"$f":"M21","v":"0.00%"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parts / Labor Ratio (Cust. Pay Only) ",{"$f":"M23","v":"0.00"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Service Dept. Expenses",{"$f":"T28","v":0}]

{"sheet":"Tab B","index":2,"n_rows":44,"n_cols":46,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,2,43,3],[37,2,37,3],[39,2,39,3],[5,19,5,27],[5,29,5,35],[5,37,5,44],[18,37,18,39],[41,2,41,3],[4,2,4,8],[25,2,25,9],[33,2,33,3],[35,2,35,3],[5,12,5,17],[17,12,17,17]]}
[]
[]
[]
[]
[null,null,"NADA ACTUAL SERVICE ANALYSIS     page B-1",null,null,null,null,null,null,null,null,null,null,null,null,"page B-3",null,null,null,null,null,null,null,null,null,null,"page B-5",null,null,null,null,null,null,null,"page B-7",null,null,null,null,null,null,null,null,"page B-9"]
[null,null,"Performance",null,null,null,null,null,null,null,null,null,"FACILITY POTENTIAL",null,null,null,null,null,null,"NADA \"QUICK\" SERVICE  ANALYSIS",null,null,null,null,null,null,null,null,null,"OWNER BASE POTENTIAL",null,null,null,null,null,null,null,"PROFIT ON LABOR SALES"]
[null,null,null,"Labor Sales / Month",null,"Hourly Labor Rate",null,"Hours Billed",null,null,null,null,"Number of Bays"]
[null,null,"Customer Car*",{"$f":"'Tab A '!D6","v":0},"÷",null,"=",{"$f":"IF(ISERROR(D8/F8),\"0.00\",D8/F8)","v":"0.00"},null,null,null,null,null,"x",null,null,null,null,null,null,null,{"$f":"'Tab A '!D14","v":0},null,null,null,{"$f":"V8","v":0},null,null,null,null,null,"x",null,"=",{"$f":"AE8*AG8","v":0}]
[null,null,"Customer Truck*",{"$f":"'Tab A '!D7","v":0},"÷",null,"=","0.00",null,null,null,null,"Number of Days",null,null,null,null,null,null,null,null,"Labor Sales",null,null,null,"Labor Sales",null,null,null,null,"5 Year Owner Base ",null,"Annual Hours Purchased",null,"Market Potential / Hours",null,null,null,null,null,null,"Total Expenses"]
[null,null,"Customer Other*",{"$f":"'Tab A '!D8","v":0},"÷",null,"=","0.00",null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"divided by",null,"divided by",null,"divided by"]
[null,null,"Warranty",{"$f":"'Tab A '!D9+'Tab A '!D10","v":0},"÷",null,"=","0.00",null,null,null,null,"Number of Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI8","v":0},"x",{"$f":"V14","v":"0.00"},"=",{"$f":"AE11*AG11","v":0},null,null,null,null,{"$f":"'Tab A '!F14","v":"0.00%"},null,{"$f":"IF(AN11=\"0.00%\",\"0.00%\",AN11-0.1)","v":"0.00%"},null,{"$f":"IF(AN11=\"0.00%\",\"0.00%\",AN11-0.2)","v":"0.00%"}]
[null,null,"Internal",{"$f":"'Tab A '!D11","v":0},"÷",null,"=","0.00",null,null,null,null,null,"x",null,null,null,null,null,null,null,"Divided by Hours Billed",null,null,null,"-Labor Gross",null,null,null,null,"Market Potentail/ Hours",null,"Effective Labor Rate",null,"5 Yr. O.B Sales Potential",null,null,null,null,"Current Labor Gross Profit %",null,"Current Labor Gross Profit % Minus 10",null,"Current Labor Gross Profit % Minus 20"]
[null,null,"New Vehicle Prep",{"$f":"'Tab A '!D12","v":0},"÷",null,"=","0.00",null,null,null,null,"Effective Labor Rate"]
[null,null,"Total",{"$f":"SUM(D8:D13)","v":0},null,null,null,{"$f":"SUM(H8:H13)","v":0},null,null,null,null,null,"equals",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(V8/V11),\"0.00\", (V8/V11))","v":"0.00"},null,null,null,{"$f":"Z8-Z11","v":0},null,null,null,null,null,"x",null,"=",{"$f":"AE14*AG14","v":0},null,null,null,null,{"$f":"IF(ISERROR(AP8/AN11),\"$0.00\",(AP8/AN11))","v":"$0.00"},null,{"$f":"IF(ISERROR(AP8/AP11),\"0.00%\",(AP8/AP11))","v":"0.00%"},null,{"$f":"IF(ISERROR(AP8/AR11),\"0.00%\",AP8/AR11)","v":"0.00%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY POTENTIAL",null,{"$f":"N7*N9*N11*N13","v":0},null,null,null,null,null,null,"= OELR",null,null,null,"=Labor Cost",null,null,null,null,"Avg. Mos. Labor Sales (excluding internal PDI and NVI)",null,"Annualized",null,"Current Labor Sales Trend",null,null,null,null,"Sales to Breakeven",null,"Sales To Net 10%",null,"Sales To Net 20%"]
[null,null,"POTENTIAL"]
[null,null,null,{"$f":"D14","v":0},"÷",{"$f":"H14","v":0},"=",{"$f":"IF(ISERROR(D17/F17),\"$0.00\",D17/F17)","v":"$0.00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI14","v":0},"÷",{"$f":"AI11","v":0},"=",{"$f":"IF(ISERROR(AE17/AG17),\"0.00\"%,AE17/AG17)","v":0}]
[null,null,null,"Total labor sales for month",null,"Total hours billed",null,"Effective Labor Rate",null,null,null,null,"FACILITY UTILIZATION",null,null,null,null,null,null,null,null,null,null,{"$f":"Z14","v":0},null,null,null,null,null,null,"Labor Sales Trend",null,"5 Yr. O.B. Sales Potential",null,"Ouch",null,null,"The Picture"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Labor Sales",{"$f":"'Tab A '!D14","v":0},null,null,null,null,null,null,null,null,null,"Labor Cost",null,null,null,null,null,null,"*Note: The industry average of 35% is very poor performance.",null,null,null,null,null,null,"Customer Pay Gross Profit %",null,null,{"$f":"'Tab A '!E21","v":"0.00%"},null,"Customer Pay E.L.R.",null,null,{"$f":"F38","v":0}]
[null,null,null,null,"x",null,"x",null,"=",{"$f":"D20*F20*H20","v":0},null,null,null,"÷"]
[null,null,null,"# Service mechanical technicians",null,"# Hours/Day",null,"Working Days/Month",null,"Clock Hour Aval",null,null,"Facility Potential",{"$f":"O15","v":0},null,null,null,null,null,null,null,null,null,{"$f":"V11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Service Dept. G.P.%",null,null,{"$f":"'Tab A '!E23","v":"0.00%"},null,"Total (overall) E.L.R.",null,null,{"$f":"F42","v":"$0.00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"equals",null,null,null,null,null,null,null,null,null,"/ Hours Billed"]
[null,null,null,{"$f":"J20","v":0},"x",{"$f":"H17","v":"$0.00"},"=",{"$f":"D23*F23","v":0},null,null,null,null,"FACILITY UTILIZATION",null,{"$f":"IF(ISERROR(N19/N21),\"0.00%\",N19/N21)","v":"0.00%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parts / Labor Ratio (Cust Pay Only)",null,null,{"$f":"'Tab A '!T26:T26","v":"0.00"},null,"Warranty Labor Rate",null,null,{"$f":"F40","v":0}]
[null,null,null,"Clock Hours Available",null,"Effective Labor Rate",null,"Labor sales potential",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(X18/X21),\"$0.00\",X18/X21)","v":"$0.00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=Real Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Service Dept Expense",null,null,{"$f":"'Tab A '!$S$14","v":0},null,"Overall Tech Proficiency",null,null,{"$f":"F44","v":"0.00%"}]
[null,null,"How proficient are your technicians ?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours Per R.O (recap)",null,null,{"$f":"F34","v":0}]
[null,null,null,null,"÷",null,"=",{"$f":" IF(ISERROR(D28/F28),\"0.00%\",(D28/F28))","v":"0.00%"}]
[null,null,null,"Hours Produced",null,"Hours Available",null,"Tech Proficiency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"÷",0.3,"=",{"$f":"V29/X29","v":0},null,null,null,null,null,null,null,null,null,null,null,"Percent Of One Item R.O.'s",null,null,{"$f":"F36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Real Cost",null,null,null,"E.L.R. Needed to earn 70%"]
[]
[]
[]
[null,null,"Hours Per RO (Recap Sheet)"]
[]
[null,null,"Percent of One Item R.O.'s (Recap Sheet)"]
[]
[null,null,"Customer Pay Effective Labor Rate (Recap Sheet)"]
[]
[null,null,"Warranty Labor Rate (Recap Sheet)"]
[]
[null,null,"Total Overall Effective Labor Rate",null,null,{"$f":"H17","v":"$0.00"}]
[]
[null,null,"Overall Technician Proficiency",null,null,{"$f":"H28","v":"0.00%"}]

{"sheet":"Tab C","index":3,"n_rows":53,"n_cols":52,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,1,3,10],[8,3,8,4],[14,3,14,4],[18,4,28,4],[17,17,17,18],[14,14,14,18],[9,17,9,18],[17,14,17,15],[17,20,17,21],[20,14,20,16],[43,14,43,17],[31,14,31,18],[44,17,44,18],[34,14,34,15],[36,14,36,15],[38,14,38,15],[40,14,40,15],[52,17,52,18],[46,14,46,15],[48,14,48,15],[50,14,50,15],[52,14,52,15],[46,17,46,18],[48,17,48,18],[50,17,50,18],[6,47,6,52],[7,47,7,52],[15,17,15,18],[7,27,7,43],[11,28,11,30],[11,34,11,36],[11,41,11,43],[8,14,8,22],[11,14,11,15],[11,20,11,21],[9,20,9,21],[11,17,11,18]]}
[]
[]
[]
[null,"Technician Value   page C-7"]
[]
[null,"Calculate using daily available hours per technician",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"page C-32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exercise to See What Happens When You "]
[null,null,"Hours",null,null,"Days",null,"Labor Rate",null,"Sales Value",null,null,null,null,"STAFFING REQUIREMENTS",null,null,null,"page C-9",null,null,null,null,null,null,null,null,"Service Advisor Performance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase Your Hours Per Repair Order"]
[null,null,null,"X",null,null,"X",{"$f":"'Tab B'!H17","v":"$0.00"},"=",{"$f":"C9*F9*H9","v":0},null,null,null,"A.","Sales To Break Even"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Expenses for One Month",null,"¸","Current Gross Profit Percent",null,"=","Sales To Break Even",null,null,null,null,null,null,null,"How To Set Advisor Sales Objectives To:  Beak Even,  Net 10%, &  Net 20%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of customer R.O.'s for the month"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¸",{"$f":"'Tab B'!AN11","v":"0.00%"},null,"=",{"$f":"IF(ISERROR(O12/R12),\"$0.00\",O12/R12)","v":"$0.00"},null,null,null,null,null,null,null,"Break Even",null,null,null,null,null,"Net 10 %",null,null,null,null,null,null,"Net 20 %",null,null,null,null,null,null,"Multiply by .3 hours",null,null,"0.3 hours"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           "]
[null,null,"Sales Value",null,null,"Gross Margin",null,"Profit Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Department's Average Monthly Expenses",null,null,null,null,1,"Department's Average Monthly Expenses",null,{"$f":"AE14","v":0},null,null,null,1,"Department's Average Monthly Expenses",null,{"$f":"AK14","v":0},null,null,null,null,"Additional customer labor hours generated","=",null,{"$f":"AZ10*0.3","v":0}]
[null,null,null,"X",null,{"$f":"'Tab A '!F14","v":"0.00%"},"=",{"$f":"C15*F15","v":0},null,null,null,null,null,"B.","Sales To Generate 20% Net",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¸",null,null,null,null,null,null,"¸",null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Expenses for One Month",null,"¸","Current Gross Profit Percent (Minus 20)",null,"=","Sales To Generate 20% Net",null,null,null,null,null,null,2,"Divide by current labor gross profit % to break even","¸",{"$f":"'Tab A '!F14","v":"0.00%"},null,null,2,"Divide by current labor gross profit % minus 10 to net 10%",null,{"$f":"IF(AE16=\"0.00%\",\"0.00%\",AE16-0.1)","v":"0.00%"},null,null,null,2,"Divide by current labor gross profit % minus 20 to net 20%",null,{"$f":"IF(AK16=\"0.00%\",\"0.00%\",AK16-0.1)","v":"0.00%"},null,null,null,null,"Multiply by Customer Labor Rate",null,null,{"$f":"'Tab B'!$AT$19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=","  ",null,null,null,null,"=",null,null,null,null,null,null,"="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¸",{"$f":"IF(R12=\"0.00%\",\"0.00%\",R12-0.2)","v":"0.00%"},null,"=",{"$f":"IF(ISERROR(O18/R18),\"$0.00\",O18/R18)","v":"$0.00"},null,null,null,null,null,null,3,"Equals New Sales Objective",null,{"$f":"IF(ISERROR(AE14/AE16),\"$0.00\",AE14/AE16)","v":"$0.00"},null,null,3,"Equals New Sales Objective",null,{"$f":"IF(ISERROR(AK14/AK16),\"$0.00\",AK14/AK16)","v":"$0.00"},null,null,null,3,"Equals New Sales Objective",null,{"$f":"IF(ISERROR(AR14/AR16),\"$0.00\",AR14/AR16)","v":"$0.00"},null,null,null,null,"Equals additional Customer Labor Sales Generated","=",null,{"$f":"AZ14*AZ16","v":0}]
[null,null,{"$f":"H15","v":0},0.7,"proficiency",{"$f":"C19*0.7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¸",null,null,null,null,null,"¸",null,null,null,null,null,null,"¸",null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Number of Advisors",null,null,null,null,4,"Number of Advisors",null,{"$f":"AE20","v":0},null,null,null,4,"Number of Advisors",null,{"$f":"AK20","v":0},null,null,null,null,"Multiply by customer Labor Gross Profit %",null,null,{"$f":"'Tab A '!Z35","v":"0.00%"}]
[null,null,{"$f":"C19","v":0},0.8,null,{"$f":"C21*0.8","v":0},null,null,null,null,null,null,null,"C.","Technician Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,null,null,null,null,"=",null,null,null,null,null,null,"="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daily Work Hours","X","Average Proficiency Rate","X","Overall Effective Labor Rate","X","Work Days Per Month","=","Technician Value",null,null,null,null,5,"Equals Sales Objective per Advisor",null,{"$f":"IF(ISERROR(AE18/AE20),\"$0.00\",AE18/AE20)","v":"$0.00"},null,null,5,"Equals Sales Objective per Advisor",null,{"$f":"IF(ISERROR(AK18/AK20),\"$0.00\",AK18/AK20)","v":"$0.00"}," ",null,null,5,"Equals Sales Objective per Advisor",null,{"$f":"IF(ISERROR(AR18/AR20),\"$0.00\",AR18/AR20)","v":"$0.00"},null,null,null,null,"Equals additional Labor Gross Profit $ generated","=","(A)",{"$f":"AZ18*AZ20","v":0}]
[null,null,{"$f":"C21","v":0},0.9,null,{"$f":"C23*0.9","v":0},null,null,null,null,null,null,null,null,null,null,0.8,null,{"$f":"'Tab B'!AT21","v":"$0.00"},null,null,null,{"$f":"O23*Q23*S23*U23","v":0},null,null,null,null,null,null,"¸",null,null,null,null,null,"¸",null,null,null,null,null,null,"¸"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Number of work days per month",null,null,null,null,6,"Number of work days per month",null,{"$f":"AE24","v":0},null,null,null,6,"Number of work days per month",null,{"$f":"AK24","v":0}]
[null,null,{"$f":"C23","v":0},1,null,{"$f":"C25*1","v":0},null,null,null,null,null,null,null,null,{"$f":"O23","v":0},null,0.9,null,{"$f":"S23","v":"$0.00"},null,{"$f":"U23","v":0},null,{"$f":"O25*Q25*S25*U25","v":0},null,null,null,null,null,null,"=",null,null,null,null,null,"=",null,null,null,null,null,null,"="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Equals daily sales objective per advisor",null,{"$f":"IF(ISERROR(AE22/AE24),\"$0.00\",AE22/AE24)","v":"$0.00"},null,null,7,"Equals daily sales objective per advisor",null,{"$f":"IF(ISERROR(AK22/AK24),\"$0.00\",AK22/AK24)","v":"$0.00"},null,null,null,7,"Equals daily sales objective per advisor",null,{"$f":"IF(ISERROR(AR22/AR24),\"$0.00\",AR22/AR24)","v":"$0.00"}]
[null,null,{"$f":"C25","v":0},1.1000000000000001,null,{"$f":"C27*1.1","v":0},null,null,null,null,null,null,null,null,{"$f":"O23","v":0},null,1,null,{"$f":"S23","v":"$0.00"},null,{"$f":"U23","v":0},null,{"$f":"O27*Q27*S27*U27","v":0},null,null,null,null,null,null,"¸",null,null,null,null,null,"¸",null,null,null,null,null,null,"¸",null,null,null,null,null,"Divide Parts Sales R.O. by Labor Sales R.O. to calculate $ parts sales per 1$ of Labor Sales","=",null,{"$f":"'Tab A '!Z39","v":"0.00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Current overall effective labor rate",null,{"$f":"'Tab B'!$AT$21","v":"$0.00"},null,null,8,"Current overall effective labor rate",null,{"$f":"AE28","v":"$0.00"},null,null,null,8,"Current overall effective labor rate",null,{"$f":"AK28","v":"$0.00"}]
[null,null,{"$f":"C27","v":0},1.2,null,{"$f":"C29*1.2","v":0},null,null,null,null,null,null,null,null,{"$f":"O23","v":0},null,1.2,null,{"$f":"S23","v":"$0.00"},null,{"$f":"U23","v":0},null,{"$f":"O29*Q29*S29*U29","v":0},null,null,null,null,null,null,"=",null,null,null,null,null,"=",null,null,null,null,null,null,"=",null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Equals daily sales objective per advisor (FRH's)",null,{"$f":"IF(ISERROR(AE26/AE28),\"$0.00\",AE26/AE28)","v":"$0.00"},null,null,9,"Equals daily sales objective per advisor (FRH's)",null,{"$f":"IF(ISERROR(AK26/AK28),\"$0.00\",AK26/AK28)","v":"$0.00"},null,null,null,9,"Equals daily sales objective per advisor (FRH's)",null,{"$f":"IF(ISERROR(AR26/AR28),\"$0.00\",AR26/AR28)","v":"$0.00"},null,null,null,null,"Multiply by Customer Labor Sales",null,null,{"$f":"AZ18","v":0}]
[null,null,"Profit Value",null,null,"Adjusted Profit Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"D.","Staffing To Break Even",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales To Break Even",null,"¸",null,"Technician Value",null,"=",null,"Staffing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equals additional Customer Parts Sales generated",null,null,{"$f":"AZ27*AZ30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U12","v":"$0.00"},null,"¸",null,{"$f":"W23","v":0},"@ 80%","=",null,{"$f":"IF(ISERROR(O35/S35),\"0.0\",O35/S35)","v":"0.0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiply  by  Customer Parts Sales Gross Profit %"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O35","v":"$0.00"},null,"¸",null,{"$f":"W25","v":0},"@ 90%","=",null,{"$f":"IF(ISERROR(O37/S37),\"0.0\",O37/S37)","v":"0.0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equals additional Parts Gross Profit $ Generated","=","(B)",{"$f":"AZ34*AZ36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O37","v":"$0.00"},null,"¸",null,{"$f":"W27","v":0},"@ 100%","=",null,{"$f":"IF(ISERROR(O39/S39),\"0.0\",O39/S39)","v":"0.0"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O39","v":"$0.00"},null,"¸",null,{"$f":"W29","v":0},"@ 120%","=",null,{"$f":"IF(ISERROR(O41/S41),\"0.0\",O41/S41)","v":"0.0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Gross Profit from Labor (A) and Parts (B)","=",null,{"$f":"AZ38+AZ22","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"E.","Staffing To Generate 20% Net"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales To Generate 20% Net",null,"¸","Technician Value",null,null,"=",null,"Staffing"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U18","v":"$0.00"},null,"¸",{"$f":"W23","v":0},null,"@ 80%","=",null,{"$f":"IF(ISERROR(O47/R47),\"0.0\",O47/R47)","v":"0.0"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O47","v":"$0.00"},null,"¸",{"$f":"W25","v":0},null,"@ 90%","=",null,{"$f":"IF(ISERROR(O49/R49),\"0.0\",O49/R49)","v":"0.0"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O49","v":"$0.00"},null,"¸",{"$f":"W27","v":0},null,"@ 100%","=",null,{"$f":"IF(ISERROR(O51/R51),\"0.0\",O51/R51)","v":"0.0"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O51","v":"$0.00"},null,"¸",{"$f":"W29","v":0},null,"@ 120%","=",null,{"$f":"IF(ISERROR(O53/R53),\"0.0\",O53/R53)","v":"0.0"}]

{"sheet":"Tab D","index":4,"n_rows":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,2,1,10],[3,3,3,7],[5,3,5,4],[27,3,27,4],[1,15,1,24],[2,16,2,24],[3,16,3,20],[27,18,27,19],[27,21,27,22]]}
[]
[null,null,"Labor Rate Calculations",null,null,null,null,null,null,null,null,null,null,null,null,"Calculating Mark-Up"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Using the following formula, mark-up a part costing $6.72 to attain a 35%"]
[null,null,1,"Calculate the Labor Rate for the following operation.",null,null,null,null,null,null,null,null,null,null,null,null,"gross profit ( round to the nearest cent)"]
[]
[null,null,null,"A/C Charge and Check",null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,"=",null,{"$f":"(IF(ISBLANK(U6),\"0.00\",(Q6/(Q6-U6))))","v":"0.00"}]
[null,null,null,null,null,"Labor Price",120,null,null,null,null,null,null,null,null,null,1,null,null,null,"Desired Gross Profit percent ",null,null,"Mark-Up Factor"]
[null,null,null,null,null,"Units",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",null,{"$f":"X6","v":"0.00"},"=",null,{"$f":"U9*Q9","v":0}]
[null,null,null,null,"¸",null,"=",{"$f":"IF(ISERROR(D10/F10),\"$0.00\",D10/F10)","v":"$0.00"},null,null,null,null,null,null,null,null,"Part Cost",null,null,null,"Mark-Up Factor",null,null,"Retail Price"]
[null,null,null,"Price",null,"Units",null,"Labor Rate"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Calculate the \"Weighted Average\" price at a 40% Gross Profit for the following "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"parts (round to the nearest cent)"]
[]
[null,null,2,"Calculate the Effective Labor Rate for the following \"Repair\" operations.",null,null,null,null,null,null,null,null,null,null,null,null,"Item",null,"Cost",null,"Annual Turnover",null,null,"Total Cost"]
[]
[null,null,null,"Labor Operations",null,"Labor Price",null,"Labor Units",null,"Labor Rate",null,null,null,null,null,null,"Filter #1",null,4.3600000000000003,"X",112,"="]
[null,null,null,"Clean Fuel Injectors",null,117.6,"¸",1.2,"="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filter #2",null,4.01,"X",56,"="]
[null,null,null,"R&R Rear Hub Bearing.",null,96,"¸",0.8,"="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filter #3",null,3.56,"X",85,"="]
[null,null,null,"Replace Trans. Pan gasket",null,107.8,"¸",1.1000000000000001,"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filter #4",null,3.86,"X",202,"="]
[null,null,null,"R&R Headlight unit (1)",null,108,"¸",0.9,"="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filter #5",null,3.51,"X",36,"="]
[]
[null,null,null,"Total Price",null,null,"Total Units",null,null,null,null,null,null,null,null,null,null,null,"Total Items",null,{"$f":"U18+U20+U22+U24+U26","v":491},"Total Cost",null,{"$f":"X18+X20+X22+X24+X26","v":0}]
[]
[null,null,null,null,null,null,"¸",null,"=",{"$f":"IF(ISERROR(F30/H30),\"$0.00\",F30/H30)","v":"$0.00"}]
[null,null,null,null,null,"Total Price",null,"Total Units",null,"Effective Labor Rate ",null,null,null,null,null,null,{"$f":"X28","v":0},"¸",{"$f":"U28","v":491},"=",{"$f":"Q31/S31","v":0}]
[null,null,null,null,null,null,null,null,null,"(For This R.O.)",null,null,null,null,null,null,"Total Cost",null,"Total Items",null,"Weighted Average Cost"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U31","v":0},"X",null,"=",{"$f":"Q34*S34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted Average Cost",null,"Mark-Up Factor",null,"Weighted Average Price"]

{"sheet":"Tab F","index":5,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,2,4,5],[17,2,18,2],[29,2,30,2]]}
[]
[]
[]
[]
[null,null,"Cost Of A Come-Back"]
[]
[null,null,"Lost Customers"]
[]
[null,null,"Average Hours per R.O.","X"]
[]
[null,null,null,"=",{"$f":"E7*E9","v":0}]
[]
[null,null,"Effective Labor Rate","X",{"$f":"'Tab B'!AT21","v":"$0.00"}]
[]
[null,null,null,"=",{"$f":"E11*E13","v":0},"(A) Service Labor Sales"]
[]
[]
[null,null,"Service Department Gross Profit % (Excluding Sublet)","X",{"$f":"'Tab A '!E23","v":"0.00%"}]
[]
[]
[null,null,null,"=",{"$f":"E15*E18","v":0},"(B) Service Labor Gross"]
[]
[]
[null,null,"Service Labor Sales (A)",null,{"$f":"E15","v":0}]
[]
[null,null,"Parts / Labor Ratio","X",{"$f":"'Tab A '!N6","v":"0.00"}]
[]
[null,null,null,"=",{"$f":"E24*E26","v":0}]
[]
[null,null,"Parts Dept Gross Profit % R.O.Sales","X"]
[]
[null,null,null,"=",{"$f":"E28*E30","v":0},"(C) Service Parts Gross"]
[]
[null,null,null,null,null," "]
[null,null,"(B) Service Labor Gross",null,{"$f":"E21","v":0}]
[]
[null,null,"(C) Service Parts Gross","+",{"$f":"E32","v":0}]
[]
[null,null,"Lost Gross","=",{"$f":"E35+E37","v":0}]