Here is a formula for calculating square foot costs for standard base cabinets.
I used 65 as the square foot cost number, substitute your own.
The report will give you the (width,depth,height) of the cabinet.
It will also give you the total square foot costs of the cabinet including labor.
You can input the labor cost (per cabinet) via the accounting button under billing.
The @cost local variable overrides the cost info in the accounting section.
Same principles apply to wall cabinets
Change if matches (type,wall)
Material name = Base Cabinet
Include = yes
Units = each
Custom Formula
if matches(type, base, tall)
if matches(cabinet_shape,standard)
if not is_counter
@cost=(width*depth)*65
set_dimens(inches,inches,inches)
list(1,width,depth,height)
endif
endif
endif
Here is the formula for blind corner & diagonal cabinets
if matches(type,base,tall)
if not is_counter
if matches(cabinet_shape,blind)
@cost=(width*depth)+depth*(width-depth))*65
set_dimens(inches,inches,inches)
list(1,width,depth,height)
else
if matches(cabinet_shape,diagonal)
@cost=((width*depth)+(depth*(width-depth))+((width-depth)*(width-depth)/2))*65
set_dimens(inches,inches,inches)
list(1,width,depth,height)
endif
endif
endif
endif
