Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

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?

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M92248117

Have any Question?


Related Questions in Basic Finance

A work-at-home opportunity is available in which you will

A work-at-home opportunity is available in which you will receive 3 percent of the sales for customers you refer to the company. The cost of your "franchise fee" is $600. How much would your customers have to buy to cove ...

Ebeneezer scrooge jasper currently manages a 500000

Ebeneezer Scrooge Jasper currently manages a $500,000 portfolio. He is expecting to receive an additional $250,000 from a new client. The existing portfolio has a required return of 10.75 percent. The risk-free rate is 4 ...

Are us executives paid too much particularly compared to

Are U.S. Executives paid too much particularly compared to the average worker in their organization?

What are the possible downsides of momentum investing is it

What are the possible downsides of momentum investing? Is it worth it do utilise this approach?

Your division is considering two facility investment

Your division is considering two facility investment projects, each of which requires an upfront expenditure of $15 million. You estimated that the investments will produce the following net cash flows: Year Project A Pr ...

Assignment - custom cabinets inc case answer the following

Assignment - Custom Cabinets, Inc. CASE Answer the following questions. 1. Should there be additional overtime, and if so, how much? 2. Should additional laminate be purchased, and if so, how much? 3. Should additional w ...

What is net present value in terms of evaluating a project

What is Net Present Value in terms of evaluating a project? What is better NPV or Internal Rate of Return when evaluating?

Betsy ross owns 921 shares in the hanson fabrics company

Betsy Ross owns 921 shares in the Hanson Fabrics Company. There are 16 directors to be elected, and 32,500 shares outstanding. The firm has adopted cumulative voting. a. How many total votes can be cast? (Do not round in ...

You are the project manager assigned to build and design a

You are the project manager assigned to build and design a parking garage. What might be an example of a lead you encounter when scheduling work activities?

If the rate of inflation is 43 what nominal interest rate

If the rate of inflation is 4.3%?, what nominal interest rate is necessary for you to earn a 2.8 %real interest rate on your? investment? ?(Note: Be careful not to round any intermediate steps less than six decimal? plac ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As