Architekwiki
  • Home
  • WIKI
  • Start Here
  • Resources
  • Other
    • Reading List
    • Details
    • The 3 Aspects
    • About
    • Sign Up
    • Terms of Use
  • Ochre
    • Ochre
    • Ochre KB
    • Ochre FAQs
    • Ochre Help
  • Home
  • WIKI
  • Start Here
  • Resources
  • Other
    • Reading List
    • Details
    • The 3 Aspects
    • About
    • Sign Up
    • Terms of Use
  • Ochre
    • Ochre
    • Ochre KB
    • Ochre FAQs
    • Ochre Help

Architekwiki

A Resource For Architects
Subscribe

Categories

All
3 Aspects
Business Development
Communications
Concepts
Design
Detail
Estimating
Finances
Legal Issues
Management
Miscellaneous
Money
Ochre
People
Planning
Process
Projects
Records
Services
Specifications
Standards
Time
Tools

Archives

May 2022
April 2022
February 2022
November 2021
October 2021
September 2021
August 2021
June 2021
May 2021
February 2021
January 2021
December 2020
November 2020
October 2020
September 2020
August 2020
July 2020
June 2020
April 2020
March 2020
February 2020
January 2020
December 2019
November 2019
October 2019
September 2019
August 2019
July 2019
June 2019
May 2019
April 2019
March 2019
February 2019
January 2019
December 2018
November 2018
October 2018
September 2018
August 2018
July 2018
June 2018
May 2018
April 2018
March 2018
February 2018
January 2018
December 2017
November 2017
October 2017
September 2017
August 2017
July 2017
June 2017
May 2017
April 2017
March 2017
February 2017
January 2017
December 2016
November 2016
October 2016
September 2016
August 2016
July 2016
June 2016
May 2016
April 2016
March 2016
February 2016
January 2016
December 2015
November 2015
October 2015
September 2015
August 2015
July 2015
June 2015
May 2015
April 2015
March 2015
February 2015
January 2015
December 2014
November 2014
October 2014
September 2014
August 2014
July 2014
June 2014
May 2014
April 2014
March 2014
February 2014
January 2014
December 2013
November 2013
October 2013
September 2013
August 2013
July 2013
June 2013
May 2013
April 2013
March 2013
February 2013
January 2013
December 2012
November 2012
October 2012

THE PROJECT PROFITABILITY CALCULATION

2/13/2015

 
Picture
For over 20 years I had the benefit of having project profitability calculated for me by our (pricey) accounting software. You could choose from two methods. Method 1 was automatic (Yea!). Method 2 required periodic input (Boo!).

Method 1 was to let the software figure out overhead allocation each month. Completely automatic. Check the box and forget it. The downside was that the results often loaded up a project with an excessive overhead allocation. This might be due to a large annual expense falling due that month, say professional liability insurance. Method 1 was fully automatic – and useless.

Method 2 was to input an overhead allocation factor. This factor was used to allocate overhead per hour of time charged to the project. This method gave consistent results and they were accurate as long as your overhead factor was realistic. We knew how to calculate a realistic overhead factor, and you can see how here.


PROJECT PROFITABILITY

Why Determine Project Profitability 
I think there are several reasons for knowing your project profitability.
timely profitability calculations let you take corrective action when it is needed
identifies the ‘good’ projects and the ‘bad’ projects
lets you determine if a project is good/bad because of size, type, personnel
informs business development decisions without resorting to fantasies

How To Determine Project Profitability 
Determining Project Profitability is actually pretty simple. You allocate your overhead expenses based on the hours charged to the project. You simply multiply the Overhead Factor times the individual’s hourly pay rate. Then add this amount to the project expenses for each hour charged to the project instead of just the hourly pay rate. That is the key to calculating project profitability.

Sadly only the more elaborate and costly accounting systems have this functionality. Some versions of QuickBooks can be set up to do this, but it helps if you have a degree in accounting.

PROJECT PROFITABILITY 
I have developed the spreadsheet below as an aid in understanding the process or as a tool for making your own project profitability calculations. Download and customize PROJECT PROFITABILITY for your use. 


Project Profitability
PROJECT PROFITABILITY 


Instructions 
In this detail image of the spreadsheet, I have tagged the less obvious cells with a number. These are the explanations:

  1. The Description column holds any information that will help you make sense of the entry later. Make it as detailed as you want.
  2. The Income column is primarily design fees that you have billed. It is more helpful for your purposes of project profitability if you enter income as it is earned rather than received.
  3. Reimbursable Expense could be combined with Direct Expense for simplicity, but I think it is helpful to make the distinction.
  4. Direct Expense is anything spent because of the project – non-reimbursed consultants, reproduction, mileage, and so on.
  5. Labor and Overhead contains formulas, explained later.
  6. The TOTALS row adds up all the entries below. So the bottom line is actually the top line.
  7. P/L is your project profitability. Income less expenses and less labor and overhead.

Profitability Detail 1


This last detail image shows the following information:

8. The Labor and Overhead column holds formulas in the dark blue cells. The formula adds up the calculation of hours times overhead rates for each person.

9. The dollar amount below each ‘Person’ is their overhead rate calculated per this previous post.

10. Hours are input for each Person every payroll period or as often as you wish. 

Profitability Detail 2


If you are keeping project accounts now, this process shouldn’t add any significant time once you have it set up. On the other hand, MyCorbu does project profitability for you, available as a report at any time. MyCorbu uses your time entries and expense entries. No extra bookkeeping entries required.

Better, simpler, quicker bookkeeping. 
Picture
If you would like articles like this delivered to you by email, Sign Up here. 

Follow on Twitter @Architekwiki

###

Comments are closed.
    Resources

    Start Here

    tips

    Trello-PM

    FeeCalqs3

    Financial Model Workbook

    OFFPLAN

    Drywall Details

    Terms of Use
    Your use of Architekwiki is implicit agreement with the 
    ​
    Terms of Use.

    RSS Feed


    Archives

    May 2022
    April 2022
    February 2022
    November 2021
    October 2021
    September 2021
    August 2021
    June 2021
    May 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012

Picture

Picture
VISIT ARCHITEKWIKI'S RESOURCES
​
START HERE
ABOUT
SIGN UP
TERMS OF USE
Architekwiki | Architect's Resource | Greater Cincinnati | (859) 444-4560
© 2012-2022   Architekwiki​