Question: The booking price for motivational seminar (held every week) is charged at $650 per booking, with maximum seats = 100. The total cost for arranging such a seminar comes to $35,000 per week. The manager offers 10% discount on group bookings, allowing 5 seats per group. On an average, he receives 2 to 10 (maximum allowed in a seminar) group booking orders. Construct a spreadsheet model to determine the profit all seats are booked, and none of which is group booking.
a. Use data tables to evaluate the profit for the specified range of booked group seats.
b. Suppose the manager is considering lowering or increasing the group booking discount by 5%. How will profit be affected?