Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-16-2015, 12:52 AM
macropod's Avatar
macropod macropod is offline Cost for x amount of tokens. Windows 7 64bit Cost for x amount of tokens. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Given that you haven't even decided whether you want to keep unused tokens for a future trip, this isn't something Excel can solve. Even if you don't, it may sometimes be cheaper to buy more tokens than the exact number you need. There may also be more than one solution.

Your example of 200 tokens @ $19.99 each = $119.94 is certainly not the best you can do in that instance. You could even buy 1300 tokens for less (900 @ $74.99 + 200*2 @ $19.99 = $114.97) and, if you wanted 100 tokens for something else, that might be the way to go. Alternatively, there are at least two ways of getting exactly 1200 tokens for $105.96:
900 @ $74.99 + 200 @ $19.99 + 90 @ $9.49 + 10 @ $1.49
900 @ $74.99 + 200 @ $19.99 + 50*2 @ $5.49

PS: Instead of posting links to workbooks you've loaded elsewhere, you can attach files here, so people don't have to go looking elsewhere. That gives you a better chance of getting an answer. I've replaced your link with a workbook containing the same data.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating the cost of an investment lynchbro Excel 0 06-11-2015 08:26 AM
New Cost columns are not summing up. elvanaguven Project 3 11-08-2014 02:28 PM
Cost of Investment with assumptions lynchbro Excel 0 06-25-2014 04:07 PM
Cost for x amount of tokens. Cost Reporting 2013 Steve. Project 7 05-14-2014 06:28 AM
How to rename cost column ketanco Project 3 06-15-2012 03:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft