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

Architekwiki

A Resource For Architects
Click here to get good stuff in your inbox

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

    YouTube Channel

    Join The Mailing List

    Picture

    Terms of Use
    Your use of Architekwiki is implicit agreement with the 
    ​
    Terms of Use.
    Thank You for your donation

    x
    Get Good Stuff in Your Inbox
    Picture
    Subscribe

    RSS Feed


    Archives

    January 2023
    November 2022
    October 2022
    July 2022
    June 2022
    April 2022
    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

    Categories

    All
    Business Development
    Business Management
    Design
    Detail
    Miscellaneous
    Project Management
    Resources

Picture

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