A B D Lanai 85 $ Villager 95 $ Sunset 110 $ $ $ $ $ $ $ 110,000 $ 37,000 $ 5,000 $ 23,000 $ 13,500 $ 100,000 $ 22,000 $ 5,000 $ 23,000 $ 13,500 $ 100,000 29,000 5,000 23,000 13,500 1 2018 Royal Kona tour Information 2 Tour 3 Price per passenger 4 Fixed Costs (Annual) 5 Boat Depreciation 6 Boat Maintenance 7 Insurance 8 Share of Hotel Costs 9 Advertising 10 Variable Costs (per trip) 11 Fuel 12 Tour Guide Cost 13 Passenger Food 14 Docking Fees 15 Number of Trips per year 16 Mean Passengers per trip 17 Annual Profit 18 Added Trip Profit $ $ $ $ 325 130 400 200 $ 165 $ 225 $ 75 $ 251 29.8 280,368 $ 175 $ 100 $ 150 $ 95 $ 155 23.1 96,048 $ 212 32.2 399,144 $ Step-6: The boats do not all make the same number of trips per year. Therefore, the profit marginal profit if one trip was added. If you had enough demand to warrant an extra trip, then to make the most profit you should assign an added tour to the boat that makes the most profit per information calculated above will not necessarily tell you which boat would earn the most extra trip (marginal profit). So move down to cell A18 and enter "Added trip profit" Then in cells B18-D18 enter the profit per added trip. You can review the formula used in row 17 and think about how to modify this formula. In other words, figure out this function on your own . What was the Royal Kona's most profitable profit? Q2: how much is this marginal profit? What boat tour makes the most profit for Royal Kona in terms of an incremental trip, and in alen nrovides an important A B D Lanai 85 $ Villager 95 $ Sunset 110 $ $ $ $ $ $ $ 110,000 $ 37,000 $ 5,000 $ 23,000 $ 13,500 $ 100,000 $ 22,000 $ 5,000 $ 23,000 $ 13,500 $ 100,000 29,000 5,000 23,000 13,500 1 2018 Royal Kona tour Information 2 Tour 3 Price per passenger 4 Fixed Costs (Annual) 5 Boat Depreciation 6 Boat Maintenance 7 Insurance 8 Share of Hotel Costs 9 Advertising 10 Variable Costs (per trip) 11 Fuel 12 Tour Guide Cost 13 Passenger Food 14 Docking Fees 15 Number of Trips per year 16 Mean Passengers per trip 17 Annual Profit 18 Added Trip Profit $ $ $ $ 325 130 400 200 $ 165 $ 225 $ 75 $ 251 29.8 280,368 $ 175 $ 100 $ 150 $ 95 $ 155 23.1 96,048 $ 212 32.2 399,144 $ Step-6: The boats do not all make the same number of trips per year. Therefore, the profit marginal profit if one trip was added. If you had enough demand to warrant an extra trip, then to make the most profit you should assign an added tour to the boat that makes the most profit per information calculated above will not necessarily tell you which boat would earn the most extra trip (marginal profit). So move down to cell A18 and enter "Added trip profit" Then in cells B18-D18 enter the profit per added trip. You can review the formula used in row 17 and think about how to modify this formula. In other words, figure out this function on your own . What was the Royal Kona's most profitable profit? Q2: how much is this marginal profit? What boat tour makes the most profit for Royal Kona in terms of an incremental trip, and in alen nrovides an important