Anyone got a good pricing programme?

[Hobsoni]

pricing the materials or quoting for the job??

 

[i=p/u]

Well quoting at mo but 90% il get the job

 

[Paul117]

Email that list to a few wholesalers. Let them do the work for you and order from the cheapest/best value. Simples.

 

[shocking_eg]

This isn't a big job really

You should be able to quote it easy

 

[i=p/u]

Well il throw into 2 x wholesalers in morning or via email then wait.. Add on time which i guess 2 weeks 2 pair max 4k

 

[i=p/u]

Click mode sockets and switches, ge wiss isolators very likely

 

[Elmer BeFuddled]

I used to do Wedding Photography.

The pages inside the album and the size of photo could vary. So I made an excel script that gave me: number of pictures, number of pages (of a style), size of pictures, album cover, add vat, add 20% (for E&OE), then add 50% (my 'salary').

I'm trying to adapt at the moment but there's a lot of variables. Easier if you stick to certain type of kit.

What I'm saying is if I can do it, anyone can.

If I ever get it finished I'll stick it up. All you'll have to do is change the name of the item and the base price, it'll do the rest for you.

I'm omitting the salary bit. This is just for parts.

 

[i=p/u]

Well i was going to use tlc as a guide, but i know my wholesaler is way cheaper...

- - - Updated - - -

YEH SUPPOSE JUST EXCELL SHEET YOUVE GOT.LOL OR AM I READING IT WRONG/PROBABLY

 

[Geordie Spark]

I used to do Wedding Photography.

The pages inside the album and the size of photo could vary. So I made an excel script that gave me: number of pictures, number of pages (of a style), size of pictures, album cover, add vat, add 20% (for E&OE), then add 50% (my 'salary').

I'm trying to adapt at the moment but there's a lot of variables. Easier if you stick to certain type of kit.

What I'm saying is if I can do it, anyone can.

If I ever get it finished I'll stick it up. All you'll have to do is change the name of the item and the base price, it'll do the rest for you.

I'm omitting the salary bit. This is just for parts.

I did a similar thing with Exel when I had a Flightcase manufacturing company.

I just needed to enter the sizes of the case, choose what style of case it would be and what fittings it was going to have etc.

At the end, it produced the total price, the weight of the case, the time it had to be built in, all the cutting lists for the panels & aluminium framework and a parts list for the handles & catches etc.

If the job became live, it also deducted the stock used from the store and flagged-up any parts that were getting low in the store so I knew what I needed to re-order.

It took a while to create and perfect, but once it was working properly it do the job very nicely for over 10 years.

I was told early on that it would be better to use a database for the job, but I wasn't very good with databases at the time - and only slightly better with spreadsheets come to think of it......

 

[wildgoose]

Learn how to use Excel. It comes free with most new machines loaded with MS Office.

Not difficult to learn for a sparky because we regularly have to do basic calc's - some plumbers might struggle though!!!

 

[shocking_eg]

There's a program called Electrika

It's a massive database of all the electrical materials complete with trade prices

It contains its own excel looking page in which you can input materials by their part numbers and it will calculate the costs

You can even input labour into the quote

Electrical wholesalers sometimes use it. It's totally free and it updates very frequently with new products and prices

 

[timbobelfast]

Price up your materials and give them a day rate. That way you are covered if other trades hold you up.

You don't want to get stung on a job of this size.

 

[telectrix]

dunno what the irish labour force has come to. they built titanic in belfast in less time than this thread's been running.:auto:

 

[Elmer BeFuddled]

Find attached in the zip my Job Estimator Excel sheet.

It's very basic! Type in description, base price, quantity required. It'll then add 20% vat, 10% mark up and calculates the totals of each as you go along. I'm trying to figure out how to make it always round up to the nearest penny as if its 0.004p it rounds down to 0.000p. I'm sure the vatman doesn't do the same!!***



At the moment its only 25 lines long as it fits nicely onto an A4 sheet!

View attachment Job Estimator.zip

- - - Updated - - -

Any E&OE, find someone (Geordie?) who knows what they're doing with spread sheets!!!

- - - Updated Again!! - - -

*** Now rounds up the vat and 10% mark up to the 1p!