Determine profit for group booking

Reference no: EM131439363

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?

Reference no: EM131439363

Questions Cloud

What is approach to measure organizational effectiveness : ORG-812: What is the best approach to measure organizational effectiveness? Why? How would you determine structural deficiency if the organization was not effective?

Analyze the costs and benefits of each quality improvement : The mandate for improving the way in which health care is delivered was stimulated by the public outcry over the estimated 98,000 deaths because of medical errors each year, according to the Institute of Medicine in 1999. Since then, health care o..

What problems could arise when using open systems theory : ORG-812: Discuss what problems could arise when using Open Systems Theory. Given these problems, is it worth using Open Systems Theory in an organization?

Discuss the strengths and weaknesses of competitiveness : Discuss the strengths and weaknesses of competitiveness in the dominant economics of Asia (that is, China, Japan, India etc.) and the opportunities and threats that the competiveness of these economies pose for the less developed economies of the ..

Determine profit for group booking : 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, allowi..

Analyze the impact of the technology trend : Analyze the impact of the technology trend you selected - What impact does the trend have on the health care organization?

Why open systems theory is good for the organization : ORG-812: If Open Systems Theory is good for the organization, why are there organizations that are successful yet do not use Open Systems Theory?

Identify roles in health care related to quality improvement : The leader of a local health care organization, Cindy Janowski, has noticed leading organizations successfully implement Quality Improvement plans. Cindy wants to ensure her organization keeps current with those organizations' quality standards. S..

What is the most significant characteristic of organization : ORG-812: What is the most significant characteristic of an organization during the organizational life cycle? How might an organization know when they have moved from one cycle to the next?

User Account

All Pages