<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545; min-height: 14.0px}span.s1 {text-decoration: underline}</style>Hello Mr.Excel Forum -
What an amazing forum! I have a question that is vexing me to the point of sleeplessness. I have a problem that I just cannot solve and need help!
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545; min-height: 14.0px}</style>
I am working on a problem trying to achieve the following outcome for a tour company that I own.
- The tour bus I use has 25 total seats.
- The prices for tickets are $44 for child and $54 for adult.
- The bus can be filled with any combination of of tickets (adult / child) as long as the max capacity is 25.
The issue is the following:
- Regardless of the combination of tickets purchased, the sum of the ticket costs will incur a -5.66% discount*
- The total after the sum, and the negation of the -5.66% discount, will then be subject to a +6% fee**
- The total price must end up as a whole number (no decimals).
* - The reason this has to happen is because the reservation software I use has a mandatory 6% service fee that gets passed to the customer during the checkout flow. This number (-5.66%) is changeable if necessary. The client I work for has a contract with their parent company that does not allow the ticket price to be anything different than the advertised price (ie..$54 and $44).
** - The reason for the 6% addition is because of the mandatory 6% fee that the reservation system charges. This number is changeable.
What I am trying to achieve:
- I need to find out every single ticket combination possible.
- I need to find out the total price for each ticket combination after the -5.66% discount + the 6% service fee.
- I need to identify which ticket combinations do not round to a whole number.
- I need to find out what % service fee (above or below the standard 6% fee) would bring the number to a whole number.
Thank you in advance to anyone who reads this and can help!
What an amazing forum! I have a question that is vexing me to the point of sleeplessness. I have a problem that I just cannot solve and need help!
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545; min-height: 14.0px}</style>
I am working on a problem trying to achieve the following outcome for a tour company that I own.
- The tour bus I use has 25 total seats.
- The prices for tickets are $44 for child and $54 for adult.
- The bus can be filled with any combination of of tickets (adult / child) as long as the max capacity is 25.
The issue is the following:
- Regardless of the combination of tickets purchased, the sum of the ticket costs will incur a -5.66% discount*
- The total after the sum, and the negation of the -5.66% discount, will then be subject to a +6% fee**
- The total price must end up as a whole number (no decimals).
* - The reason this has to happen is because the reservation software I use has a mandatory 6% service fee that gets passed to the customer during the checkout flow. This number (-5.66%) is changeable if necessary. The client I work for has a contract with their parent company that does not allow the ticket price to be anything different than the advertised price (ie..$54 and $44).
** - The reason for the 6% addition is because of the mandatory 6% fee that the reservation system charges. This number is changeable.
What I am trying to achieve:
- I need to find out every single ticket combination possible.
- I need to find out the total price for each ticket combination after the -5.66% discount + the 6% service fee.
- I need to identify which ticket combinations do not round to a whole number.
- I need to find out what % service fee (above or below the standard 6% fee) would bring the number to a whole number.
Thank you in advance to anyone who reads this and can help!
