Jump to content

Experimental Drink Package Calculator


Grenadyr

Recommended Posts

I made a spreadsheet to calculate my break even point for getting the Deluxe Beverage Package on an upcoming cruise.  It turned out to be pretty useful and I thought others might find it interesting.  So...  I made a site on Wix to host an online version of the calculator for anyone that might be interested.

DrinkCalc

DrinkCalc V.2  (Now prettier and hopefully easier to use.)

I'm open to feedback to improve it as needed.  Keep in mind the options for style are limited but I can tweak the math as much as I want.

Edited by Grenadyr
Added V.2 link
Link to comment
Share on other sites

This looks really good! Two minor comments:

  1. I know you said you're limited in how much control you have over layout, but is it possible to have the calculator panel just be entirely on the main page, instead of being embedded inside a scrolling pane? While it works fine on a desktop computer and a tablet, the current setup makes using the page very hard on a  smartphone -- I wasn't able to scroll the inner pane half the time, and tapping on a control lower down in the pane like "Bottled Water" or "Percent of time on ship in port days" would cause the panel to jump back to the top
  2. I think saying that 50% of a port day is spent on the ship is a little high, although I realize it's pretty variable depending on the hours the ship is in port, how popular the port is, etc.
    • Defaulting to 33% might be a better / more conservative estimate, since a lot of the time people will leave the ship right after breakfast and not be back until shortly before dinner
    • I do realize that if you stay up late enough, you really can spend about 50% of your day on board, but I would argue you're not drinking over that 50% the same amount you would be if you were on board for the "50%" between breakfast and dinner, just because you're likely to be tired out, more inclined to want water for a while, etc.

Really appreciate this! It helps figure out the "magic number" for when to buy a package or not!

Link to comment
Share on other sites

7 hours ago, JLMoran said:

This looks really good! Two minor comments:

  1. I know you said you're limited in how much control you have over layout, but is it possible to have the calculator panel just be entirely on the main page, instead of being embedded inside a scrolling pane? While it works fine on a desktop computer and a tablet, the current setup makes using the page very hard on a  smartphone -- I wasn't able to scroll the inner pane half the time, and tapping on a control lower down in the pane like "Bottled Water" or "Percent of time on ship in port days" would cause the panel to jump back to the top
  2. I think saying that 50% of a port day is spent on the ship is a little high, although I realize it's pretty variable depending on the hours the ship is in port, how popular the port is, etc.
    • Defaulting to 33% might be a better / more conservative estimate, since a lot of the time people will leave the ship right after breakfast and not be back until shortly before dinner
    • I do realize that if you stay up late enough, you really can spend about 50% of your day on board, but I would argue you're not drinking over that 50% the same amount you would be if you were on board for the "50%" between breakfast and dinner, just because you're likely to be tired out, more inclined to want water for a while, etc.

Really appreciate this! It helps figure out the "magic number" for when to buy a package or not!

The first one I can't do much about due the limitations in the service I'm using.  I'll need to find a more flexible standalone website builder that I can work with.  Maybe changing the input fields to the same style as the cruise length and port stays will make it easier to scroll.  I noticed that scrolling on my phone would routinely screw up the values I entered on the drink sliders.

The second one is done.  I changed the default to 33 and allowed selection of any whole number value between 0 and 100.

Link to comment
Share on other sites

5 hours ago, Momof4crazytocruise said:

Thanks for this. While I knew deep down I would find no challenge getting my money's worth - now it seems justifiable ?  Also, I drink too much evidently.

I know how you feel.  I'm not sure if I should be relieved or concerned that I should definitely get my monies worth buying the drink package.

Link to comment
Share on other sites

On 6/2/2019 at 7:33 AM, Cruzinfun said:

Thank you, this is really helpful and very simple!   

Glad it was helpful.  ?

On 6/2/2019 at 10:21 AM, janesta said:

Thanks - this is really nice.  One suggestion would be to tell you which package would be your best bet based on selections.  For me, the DBP is a no-brainer ?

DBP was a pretty easy choice for me as well.  I may break even but its more about not seeing dollar signs every time I get a drink, and being able to relax instead.

I thought about the the drink package selection and feel it strays too far away from "pure" math and would involve logic and decision making work.  I'm just a geek / mechanic not a real programmer so its probably beyond my ability to do in a useful fashion.  I have made a different version of the calculator via a different service that may be more streamlined, but have yet to deploy it.

Link to comment
Share on other sites

  • 4 weeks later...
  • 3 weeks later...

That's pretty good...I need to look more into those fresh squeezed OJ, premium coffees and milkshakes...I have been missing out!!!!

 

But for me..I know its worth it...its usually paid for the whole cruise on the first day...(on my 4 day cruises)..may take till end of day 2 to break even on my upcoming 7 day cruise.....:4_joy:

Link to comment
Share on other sites

  • 3 weeks later...

This is great - we are coming up on our 4th cruise and this is the first time we've decided to get the drink package.  I always do some rough calculating to try to justify or not justify buying the drink package but this far superior to what i typically do. Thanks for sharing - it certainly make me feel better knowing that I made the right choice on the upcoming cruise.

Link to comment
Share on other sites

  • 1 month later...

@Grenadyr, just had a thought about this calculator as I was using once again -- Is there a way to modify the program so that items like the Fresh-squeezed OJ (only available at breakfast) and specialty coffees (can argue most often bought in the morning, at least for the first one) are not "depreciated" in the spend-per-port-day calculation?

I'm just thinking that if someone expects to have a fresh OJ with breakfast every day, that would likely happen on port days as well as sea days. Likewise, if someone says they're only have one coffee a day then it's likely with or right after breakfast, and would be as likely to be bought on a port day as a sea day. Maybe the second coffee and higher still gets "depreciated" for port days, though. Same goes for bottled water -- people with the drink packages tend to always grab a bottle or two as they leave the ship to go into port, so they can stay hydrated through the day without having to buy any on land (if it's even available).

I don't know how much flexibility the calcapp site allows for things like that, but thought I'd mention it as it's always good to try and get as close to a real estimate as possible. It'd be especially useful for folks with the Refreshment package, since counting those drinks at full price on the port days helps better track how good the current price is vs. expected consumption.

Link to comment
Share on other sites

On 9/18/2019 at 6:25 PM, JLMoran said:

@Grenadyr, just had a thought about this calculator as I was using once again -- Is there a way to modify the program so that items like the Fresh-squeezed OJ (only available at breakfast) and specialty coffees (can argue most often bought in the morning, at least for the first one) are not "depreciated" in the spend-per-port-day calculation?

I'm just thinking that if someone expects to have a fresh OJ with breakfast every day, that would likely happen on port days as well as sea days. Likewise, if someone says they're only have one coffee a day then it's likely with or right after breakfast, and would be as likely to be bought on a port day as a sea day. Maybe the second coffee and higher still gets "depreciated" for port days, though. Same goes for bottled water -- people with the drink packages tend to always grab a bottle or two as they leave the ship to go into port, so they can stay hydrated through the day without having to buy any on land (if it's even available).

I don't know how much flexibility the calcapp site allows for things like that, but thought I'd mention it as it's always good to try and get as close to a real estimate as possible. It'd be especially useful for folks with the Refreshment package, since counting those drinks at full price on the port days helps better track how good the current price is vs. expected consumption.

@JLMoran , Good thought.  I'll have to think about that. Ultimately it would be easier if it was a selectable option but I'm at the limit for usable fields with the level of calcapp I subscribe to.  I might be able to rig something in the background calculations.  As it stands it would probably be a blanket removal of the depreciation for coffee, juice, and water.  That would be easily done without needing another field.

Link to comment
Share on other sites

Wow, great tool. I anecdotally thought that when you added in the non-alcoholic drinks one would normally have throughout the day, it wouldn't take very many cocktails to hit the break even point. For us that number looks to be about 3. Great to see that assumption validated to some degree. Thank you!

Link to comment
Share on other sites

  • 2 weeks later...
On ‎5‎/‎28‎/‎2019 at 8:32 PM, Grenadyr said:

I made a spreadsheet to calculate my break even point for getting the Deluxe Beverage Package on an upcoming cruise.  It turned out to be pretty useful and I thought others might find it interesting.  So...  I made a site on Wix to host an online version of the calculator for anyone that might be interested.

DrinkCalc

DrinkCalc V.2  (Now prettier and hopefully easier to use.)

I'm open to feedback to improve it as needed.  Keep in mind the options for style are limited but I can tweak the math as much as I want.

Do you have this app created in any sort of spreadsheet format or something you can share that can be downloaded an used offline?

Link to comment
Share on other sites

  • 2 weeks later...

@Grenadyr thanks for creating this calculator. My wife and I are about to book our first ever cruise. We have spoke with friends and co-workers that cruise and have cruised. Most say do not purchase the plan while some say it is worth it for the convenience alone. 

Is there a possibility to add spirits to your beverage selection area. If i use cocktail as a choice it skews the overall cost higher.  I assume the cost you use have the gratuity included?

Thanks again,

Steve

Link to comment
Share on other sites

3 hours ago, CruisingCrewser said:

@Grenadyr thanks for creating this calculator. My wife and I are about to book our first ever cruise. We have spoke with friends and co-workers that cruise and have cruised. Most say do not purchase the plan while some say it is worth it for the convenience alone. 

Is there a possibility to add spirits to your beverage selection area. If i use cocktail as a choice it skews the overall cost higher.  I assume the cost you use have the gratuity included?

Thanks again,

Steve

The Drink Calc does not factor in gratuities.   The drinks/cocktails/spirits onboard range from $11 to $13, while beer is about $7 to $8.   The drink calc is used to compare your drink cost vs the drink package price before gratuities since you would have to pay gratuities either way.

5 drinks a day/person usually pays for the package.  Plus you get bottled water,  fresh squeezed juice, soda, Specialty coffees, and I am sure I am missing other items.

Link to comment
Share on other sites

2 hours ago, CruisingCrewser said:

Is there a possibility to add spirits to your beverage selection area. If i use cocktail as a choice it skews the overall cost higher.

There is effectively no difference in price between getting a glass of bourbon neat or on the rocks, or getting a top-shelf margarita. Both will be charged the same amount, $12 ($13 on Q and O class).

The only time you'll see a price difference is if you're someone who enjoys super-premium whiskeys / bourbons / scotches; in that case, the bartender will give you a heads-up before pouring because that will cost more (sometimes by a very sizable amount).

Link to comment
Share on other sites

Hello Grenadyr

How up to date is your price list? and is it from every vessel?, (I am going on a transatlantic cruise in October on board Independence of the seas), and does it include service charge?

Will there be a discounted price offer, closer to the date, do you think?

Thank you in advance.

 

Link to comment
Share on other sites

  • 2 weeks later...

Darn, wish I had seen this before. I ended up making my own spreadsheet, so here's a few suggestions.

Since the Deluxe Drink Package may require you to buy multiple, you might add another row or 2 to include multiple adults in same cabin. My wife's drinking habits differ from mine such as I drink more premium coffee and she drinks more wine, so the extra columns allows me to see our realistic consumption. The second suggestion is to add the Gratuity amount. Maybe a field one can enter. I know the current is 18%, but that may change over time.

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...