Excel Pricing Worksheet

Share tips and tricks regarding cut cutting, material handling, metal finishing, marketing, or anything you find helpful.
PMT Tim
Posts: 2
Joined: Thu Aug 12, 2021 1:32 pm

Re: Excel Pricing Worksheet

Post by PMT Tim » Thu Aug 12, 2021 4:00 pm

mdwalker wrote:
Fri Mar 15, 2013 11:11 am
I have noticed a lot of discussion on product pricing. Here is the original Excel pricing worksheet (with a few updates and modifications) that I posted a few years back. It has made the rounds through other forums and has been modified several times by other users. Feel free to use it and to modify it to suit your needs.

Danny
Plasma Pricing.PNG
when looking at your sheet you have a height and you have a width. In one example I seen there was a height number of 14.15 and they are using 14 ga material. I was wondering if you height is what we refer to as length? And is this worksheet figured as a per piece item?

PMT Tim
Posts: 2
Joined: Thu Aug 12, 2021 1:32 pm

Re: Excel Pricing Worksheet

Post by PMT Tim » Thu Aug 12, 2021 5:38 pm

when looking at your sheet you have a height and you have a width. In one example I seen there was a height number of 14.15 and they are using 14 ga material. I was wondering if you height is what we refer to as length? And is this worksheet figured as a per piece item?
Top

mdwalker
Elite Contributing Member
Elite Contributing Member
Posts: 502
Joined: Fri Nov 14, 2008 10:20 am

Re: Excel Pricing Worksheet

Post by mdwalker » Fri Aug 13, 2021 7:16 am

PMT Tim wrote:
Thu Aug 12, 2021 5:38 pm
when looking at your sheet you have a height and you have a width. In one example I seen there was a height number of 14.15 and they are using 14 ga material. I was wondering if you height is what we refer to as length? And is this worksheet figured as a per piece item?
Top
Yes, the height would be length. I think when I made the spreadsheet I was looking at the computer screen an wrote it as height and width instead of length and width and never thought to change it, lol. The worksheet can be per piece or for a whole group of nested parts depending on the information you input.
Danny Walker
Walker Manufacturing
www.walkermfg.net

User avatar
tinspark
Elite Contributing Member
Elite Contributing Member
Posts: 206
Joined: Wed May 30, 2018 4:28 pm

Re: Excel Pricing Worksheet

Post by tinspark » Fri Aug 13, 2021 12:29 pm

A little off topic, but, Its amazing what we were paying for sheets of metal back when this spreadsheet was created.
The days of cheap metal are over for the foreseeable future. A sheet of 1/4" plate was going for $5 per sq ft then. It is amazing to think what we were paying then... We are at around $18 per sq ft and up nowadays for the same sheet of 1/4" plate.
Doug,
4x4 GoTorch- expanded
Height Control/Advanced DesignEdge
Hypertherm 45XP-
+ myriads of shop toys **CAUTION**- "Does Not Play Well With Others" :)

Joe Jones
Posts: 582
Joined: Sat Oct 11, 2014 2:33 pm
Location: Franklin, KY., USA
Contact:

Re: Excel Pricing Worksheet

Post by Joe Jones » Fri Aug 27, 2021 12:44 pm

Yeah .... steel prices are out of sight now, along with lumber. Who could have guessed that a simple 2x4 stud would cost $10.00 in 2021?

Well, as with everything in Capitalism, the price is passed along to the consumer.

Joe

adbuch
Elite Contributing Member
Elite Contributing Member
Posts: 2501
Joined: Thu Sep 21, 2017 5:22 pm
Location: Tucson, Arizona
Contact:

Re: Excel Pricing Worksheet

Post by adbuch » Sat Aug 28, 2021 12:25 am

tinspark wrote:
Fri Aug 13, 2021 12:29 pm
A little off topic, but, Its amazing what we were paying for sheets of metal back when this spreadsheet was created.
The days of cheap metal are over for the foreseeable future. A sheet of 1/4" plate was going for $5 per sq ft then. It is amazing to think what we were paying then... We are at around $18 per sq ft and up nowadays for the same sheet of 1/4" plate.
Doug - I agree! Steel price have really "gone thru the roof". I am willing to absorb some of it, but I pass a portion of the increase along to my customers by raising my prices. I buy more round tubing and flat stock, but the increase per lb. is pretty much the same regardless.
David

Post Reply

Return to “Tech Tips From Other Members”

Industry Pros use FastCut CNC