How do I do a job costing or profit per job for painter

M

Mark

I am trying to find a spreadsheet template, so that I can put all my costs in
it including labour and get a profit/loss analysis per job I do. Eg Cost of
paint, labour ,staff, etc;
 
A

Andrew Ball

Mark,
If you create your first one as a new document and save it when you've
finished, then delete the data in the cells you wil be changing each time and
save it again as a template, you should be up and running.

Assuming you need columns "A" and "B" to enter your job references and
locations, and row 1 to put all your headings in, carry on as follows: -

Cell C2 - enter labour cost
Cell D2 - enter paint cost
Cell E2 - enter staff cost
Cell F2 - enter any other type of cost we haven't thought of yet (sales tax?)
Cell G2 - enter "=SUM(C2:F2)" without the quotes
Cell H2 - enter the sell cost or what you charged your customer

Format all these cells as "Currency", with or without £ or $ symbol
whichever you prefer.

Cell I2 - enter "(H2/G2)-1" and format the cell as "percentage" to as many
decimal places as you need

If you need something like weekly or monthly totals, you can "SUM" each
column the same way as the row in cell G2, if you need more or less rows
within the template, as long as you insert or delete them from within the
range of the formulae, the formulae will adjust themselves automatically (ie
don't wait till you've filled in the last row before inserting another if you
need it) or put the "SUM" at the top and use "=SUM(C3:C25,000)", you'd have
to be a busy painter to run out of room then!

Hope that's the sort of thing you were after.

Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top