Add BREAK% to account for total labor cost – Upwork

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 Cost
Painting: $1355
Wallpaper: $4211
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.

Budget: $15

Posted On: December 30, 2021 16:14 UTC
Category: Data Entry
Skills:Microsoft Excel, Data Entry, Financial Analysis

Country: United States

click to apply
Read More
All jobs |

Scroll to Top