Attached is my current job costing report for use when closing out a job. I would like to add a BREAK% to my report for when a project has 2 categories. For example some projects include both painting and wallpaper services for a customer. I want to be able to break down the labor total into what percent each job is.
Project example 1:
Project 344 Wilfred Ave.
Labor Total: $5566
BREAK% for Painting= 1355/5566= 24%
BREAK% for Wallpaper= 4211/5566= 76%
I still would like a spot to enter labor total in the original scope row, but would like 2/3 rows inserted below Original scope where I can add a break% if needed. Some of my jobs wouldn’t need a BREAK% as they are only painting jobs.