Costing spreadsheet
-
- Posts: 99
- Joined: Wed 01 Dec, 2010 8:31 pm
- Location: Oldham
- Organisation: raygreenphotography.co.uk
- Interests: photography, fell running, squash
Costing spreadsheet
Does anybody have a template for a spreadsheet to work out costings based on materials used and size of frame? I am aware that Wessex produce one at a cost of a few hundred quid. I will have a crack at doing one although my spreadsheet (excel) skills are not brilliant. I don't mind if you prefer to private message me.
- Jonny2morsos
- Posts: 2231
- Joined: Wed 12 Mar, 2008 10:28 pm
- Location: Lincs
- Organisation: Northborough Framing
- Interests: Fly Fishing, Photography and Real Ale.
- Location: Market Deeping
Re: Costing spreadsheet
You should be able to do one in Excel fairly easily. There are plenty of books around that guide you through simple exercises which you can adapt to suit your pricing.
You should not need much more than multiplication (product) and addition (sum) to get the figures you want to charge.
You should not need much more than multiplication (product) and addition (sum) to get the figures you want to charge.
- GeoSpectrum
- Posts: 2151
- Joined: Fri 01 Oct, 2010 11:49 am
- Location: Lincolnshire
- Organisation: Ashcraft Framing
- Interests: Family, x-country skiing, wine, art, Jazz
- Location: Gainsborough, Lincolnshire
- Contact:
Re: Costing spreadsheet
Before trying to make it work into a spread sheet, work it out on paper first. Once you understand the structure putting it into Excel is a bit easier and you will better understand the results as you will know what the results should be!
I spent a long time making a far too complicated spread sheet before deciding life is too short and bought a pricing program. I use the Wessex prog and find it very good.
I spent a long time making a far too complicated spread sheet before deciding life is too short and bought a pricing program. I use the Wessex prog and find it very good.
Alan Huntley
Ashcraft Framing
Bespoke Easels and Self-assembly tray frames
http://www.ashcraftframing.co.uk
Ashcraft Framing
Bespoke Easels and Self-assembly tray frames
http://www.ashcraftframing.co.uk