Patrick C. answered 08/01/16
Tutor
5.0
(1,016)
Top 10% Wyzant tutor in Accounting, Economics, Finance, Excel and More
Total Hotel Charge = HotelA + HotelA1-500
$855 = HotelA * 9.5% + HotelA1-500 *7.5%
Using Excel Solver
Hotel 1 = $5,250
Hotel 2 = $4,750 (difference of 500)
Taxes 1 = $5,250 * 9.5% = $498.75
Taxes 2 = $4,750 * 7.5% = $356.25
Total Taxes = $855.00