This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Gross Margin Method
Gross Margin Method
Gross Profit Dollar Method
Gross Margin Percentage Method
Best Model
Budget Model
Units
Units
Parts
Parts
U+P
U+P
Tax
Tax
U+P+T
U+P+T
Included Services
Included Services
Labor
Labor
U+P+T+IS+L
COGS
U+P+T+IS+L
COGS
Desired Margin
Desired Margin
Selling Price
Selling Price
Commission
Commission
SP after Comm
SP after Comm
Buydown Rate
Buydown Rate
Final Selling Price
Final Selling Price
Gross Profit Dollar Difference
Gross Profit Per Man or Crew Hr/Day
Best Model
Budget Model
Units
Units
Parts
Parts
U+P
U+P
Tax
Tax
U+P+T
U+P+T
Included Services
Included Services
Labor
Labor
U+P+T+IS+L
COGS
U+P+T+IS+L
COGS
GP $ Requirement
hour or day
GP $ Requirement
hour or day
Selling Price
Selling Price
Commission
Commission
Buydown Rate
Buydown Rate
Selling Price
Selling Price
In this model the units of labor EQUAL the number of GP$'s multiplied by the cost of GP per unit.
Labor
x
=
GP Units
x
=
Selling Price = COGS + GP$'s +Commission + B/D rate