Please fill all required fields
RO Sales Mix What If Calculator.
LeanMaterialManagement.com
Contact us for More Information.
Back to Tools Page
Average RO$
Enter Data in Yellow Cells Only
Avg, # of RO/Month
Enter
Current values in the First Table
Category
Sales Mix %
GP%
Avg Sales/RO
GP$
%of Profit$
Body Labor
Paint Labor
Parts
P&M
Sublet
Other
< must = 100%
Overall GP %>
What IF Sales Mix is Changed
Category
Sales Mix %
GP%
Avg Sales/RO
GP$
%of Profit$
Delta $
Body Labor
Paint Labor
Parts
P&M
Sublet
Annual
Other
Change
< must = 100%
Overall GP %>
What IF GP% is Changed
Category
Sales Mix %
GP%
Avg Sales/RO
GP$
%of Profit$
Delta $
Body Labor
30.0%
Paint Labor
20.0%
Parts
36.0%
P&M
10.0%
Sublet
4.0%
Annual
Other
0.0%
Change
< must = 100%
Overall GP %>
Changes above are shown in
BOLD
on Excel version only not on Web version.
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.