Originally Posted by
controller1
From looking at the spreadsheet it appears the tax rate (informational only) is computed only utilizing the Total Spend less the sum of the base rates and ancillary spend. There are several things such as parking, spa treatments, mini-bars, etc that would be included in the Total Spend that would impact the calculation of the tax rate. I could see where the rate would turn "red" as you state yet not be a problem but only because there are other items other than Ancillary, Room Rates and Taxes in the Total Spend amount. Other than that I'm not sure the reason for the tax rate calculation since it appears the main purpose of the spreadsheet is to determine one's progress towards the $20,000 Ambassador requirement.
good point. My thought process was to add a data validation step. Like your total is 1000 and you accidentally key in 3 nights worth of room rate instead of 4, it would alert you of a data entry error.
maybe Tax rate isnt the right term.. Cost Variance perhaps?
thanks for the input!