Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 13th 08, 12:08 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 989
Default How do I do a job costing or profit per job for painter

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;

  #2   Report Post  
Old June 18th 08, 04:18 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 13
Default How do I do a job costing or profit per job for painter

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

"Mark" wrote:

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;



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
costing values hugoalegria Excel Discussion (Misc queries) 8 February 6th 08 11:50 PM
costing hugoalegria Excel Discussion (Misc queries) 2 January 30th 08 09:58 PM
Product costing Lakshminarayana[_2_] Excel Worksheet Functions 4 August 12th 07 02:38 PM
Product costing Lakshminarayana[_2_] Excel Worksheet Functions 0 August 11th 07 06:20 AM
job costing worksheet leapyrgrl Excel Worksheet Functions 4 August 8th 05 10:13 PM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017