The booking price for motivational seminar (held every week) is charged at $650 per booking, with maximum
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?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answered By
PRINCE PANDEY
I am Indian Chartered Accounting having a strong hold in the subjects of Accounting, IFRS Reporting, Indian
Taxation, Cost Accounting, Auditing. I have vast experience of teaching a student with easy way problem-solving approach.
1+ Reviews
10+ Question Solved
Related Book For 
Question Posted:
