Pricing Guide/Chart with variable pricing increases

Awesome! Thanks for your help.

One request before we move ahead. Can we make the minimum price of $84 for price per piece 200-10000? Then start the remaining quantities at 10001+.

That being said - the per piece price is $0.0084 per piece.

The subsequent cost breaks are as follows:
10,001 - 50,000 . . . . . $0.0084 + 10% discount
50,001 - 100,000 . . . . . $0.0084 + 20% discount
100,001 - 250,000 . . . . . $0.0084 + 30% discount
250,001 - 400,000 . . . . . $0.0084 + 40% discount
400,001 - 600,000 . . . . . $0.0084 + 50% discount

Just to confirm will I be able to go in and adjust that base price and those discounts?

Finished off the chart. Pretty sure everything is covered including your discount levels.

Any questions feel free let me know.

If this is what you need don't forget to mark thread as solved.

HSDesigns Sales Chart.xlsx

This is greatly appreciated and your part is 100% on the money. However, I need to adjust some of the pricing levels and discounts. Once I get a chance to fully review would you be willing to adjust or show me how to do it? For example, I overstated the quantity for which the minimum price is based on. Instead of 10000 it should be closer to 5000 and I need to reconfigure the discounts. I don't want to take advantage of your help so if you don't care to make the adjustments your assistance on tutoring me on how to make them myself would be appreciated.

Absolutely I can help. The discounts are super easy to adjust, just input any new discount variable for each pricing level into the dark blue cells beside the applicable level. Changing the pricing levels is a little more time consuming but can definitely be done. Just let me know.

Again, thank you. Your work on this has been great and exactly what I've asked for. However, after further analysis I have more information that should help complete this project. I overlooked a few details that you will need to complete the price guide.

We need to be able to create the pricing guide with these factors:
1. Cost per thousand (parts x units) at $18 per
2. Plus each unit cost of $0.04.
3. Each order has a set-up cost of $20, no matter what variation of units or parts of the order
4. The price guide/chart must use these factors, totals of "1" + "2" + "3" to calculate pricing
5. Any totals of "1" + "2" + "3" below $76 minimum should be increased to the minimum of $76

Hope this helps. Thanks in advance for any further assistance you can provide.

I don't understand what you mean by point number 2. So each unit is 4 cents regardless of how many parts there are in it? I guess I don't really understand at all. And I thought that the minimum was $84. Looking at this, it would seem that this an entirely new type of pricing scheme than what I had previously built for you, not just a modification to the previous pricing levels.

I apologize for any confusion. This is regarding the same pricing guide but as I mentioned I was unclear as to how to best describe the exact factors in calculating the pricing chart. I had to break it down on my end to better understand what I was looking for.

To answer your question, yes. Each unit will incur a $.04 charge, ie. 150 units will equate to $6 of the total price. In addition $0.018 per total pieces (pieces per unit x number of units). Finally this order as well would incur a $20 set-up fee. I did create a single line formula to calculate the basic pricing, I just don't have the skillset to apply to the chart I need, please see attached.PriceGuide.xlsx