+ Reply to Thread
Results 1 to 5 of 5

How To Make A Pricing Curve

  1. #1
    Registered User
    Join Date
    08-18-2010
    Location
    Central California, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    How To Make A Pricing Curve

    Hi, I'm wondering if anyone can help me with this as I'm stuck. I'm trying to make a pricing chart.
    I would like 1 unit to cost $30, and 1k units to cost $6500, and then have some adjustable formula which would basically draw in the curve and price values at each unit in between. That way I could have a set price for any amount of units. I could put in more points to use as reference for the bell curve formula, like 500 units costs $3,750, 100 units costs $1,000, 50 units costs $600 etc.

    I have been trying, but haven't really been able to figure this out. Any help is greatly appreciated
    Thanks
    Last edited by quinnGoes; 08-18-2010 at 11:11 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How TO Make A Pricing Bell Curve

    Welcome to the forum.

    Pardon? Pricing by quantity would never follow a bell curve, more like a decreasing exponential.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    08-18-2010
    Location
    Central California, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How To Make A Pricing Curve

    Quote Originally Posted by shg View Post
    Welcome to the forum.

    Pardon? Pricing by quantity would never follow a bell curve, more like a decreasing exponential.
    Thanks, and sorry I didn't mean bell curve at all, just a curve.

  4. #4
    Registered User
    Join Date
    08-18-2010
    Location
    Denver, CO
    MS-Off Ver
    Excel/Access 2010
    Posts
    8

    Re: How To Make A Pricing Curve

    One way to do unit pricing:

    Set constants in these cells:
    B2=30 (Price to buy 1 unit)
    B3=20 (Minimum price)
    B4=0.01 (Discount factor)
    B5=500 (Number of units)

    You can figure out unit price by this:
    B6=MAX(B3,B2-(B5*B4))

    and total price by this:
    B7=B5*B6

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How To Make A Pricing Curve

    Here's an example of an exponential pricing model.

    First is the price for the first article.

    Last is the unit price you'd charge for a zillion.

    k is the factor that controls how fast the price decreases (0 to 1)

    Please Login or Register  to view this content.
    The formula in B6 and copied across and down is

    = Last + (First - Last) * B$3 ^ ($A6 - 1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1