Results 1 to 9 of 9

calculating price depending on quantity

Threaded View

impresslb calculating price depending... 09-18-2011, 11:48 AM
arthurbr Re: Help Cant get this simple... 09-18-2011, 11:58 AM
impresslb Re: Help Cant get this simple... 09-18-2011, 12:01 PM
TMS Re: calculating price... 09-18-2011, 12:03 PM
impresslb Re: calculating price... 09-18-2011, 12:06 PM
TMS Re: calculating price... 09-18-2011, 12:10 PM
Alf Re: calculating price... 09-18-2011, 01:16 PM
TMS Re: calculating price... 09-18-2011, 02:33 PM
impresslb Re: Help Cant get this simple... 09-18-2011, 11:56 AM
  1. #1
    Registered User
    Join Date
    03-28-2011
    Location
    Lebanon
    MS-Off Ver
    Excel 2007
    Posts
    9

    Question calculating price depending on quantity

    I am trying to use excel to estimate the price for printing for our small print shop.

    We charge per 1000 sheets , and the charge per sheet will depend on how many thousands of sheets we are printing.

    depending on the size etc... we have managed to calculate how many sheets need to be purchased and how many sheets need to be printed. But now we have a large excel file that has all the quantities of sheets that need to be printed for all the different sizes of jobs.

    Now all we want is to make a formula thats says : if the number of sheets to be printed is 0 to 1000 sheets , then the cost per thousand is $60 usd , so anything less than 1000 sheets even if its 10 sheets will be charged at $60 .

    from 1000 to 2000 the cost per 1000 is $35 , so 2000 sheets is $70

    here is the entire sheet:
    zero to 1000 $60.00 /1000
    2000 $35.00 /1000
    3000 $26.80 all below is per thousand
    4000 $24.00
    5000 $24.00
    6000 $24.00
    7000 $24.00
    8000 $24.00
    9000 $24.00
    10000 $24.00
    15000 $20.00
    20000 $16.00
    25000 $16.00
    50000 $16.00
    100000 $14.00

    I tried doing a look up table that looks like this :
    =LOOKUP(J44,{0,1000,2000,3000,4000,5000,6000,7000,8000,9000,10000,15000,2000,25000,50000},{15,8.75,7.5,7,7,7,7,7,7,6,5,4,4,4})

    (dont look at the values on the second part the USD amounts are not right but i was talking about the idea.

    I just feel there must me an easier way.....please help.

    I also want to make sure also that there is no usd value less than $60 , cause that is our minimum price no matter how small the print job us.
    Last edited by impresslb; 09-18-2011 at 12:00 PM. Reason: wrog title

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