Saturday, December 11, 2010

Softlist - Square Foot Cabinet Formulas

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