Harrison Hotels is considering adding a spa to its current facility in order to improve the list

Question:

Harrison Hotels is considering adding a spa to its current facility in order to improve the list of amenities. Operating the spa would require a fixed cost of $25,000 per year. Variable cost is estimated at $35 per customer. The hotel wants to break even if 12,000 customers use the spa facility.

(a) Construct a spreadsheet model, assuming that selling price is an input to be specified by the user.

(b) Use Goal Seek to find the selling price for which the hotel will break even.


Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Operations Management

ISBN: 978-0470325049

4th edition

Authors: R. Dan Reid, Nada R. Sanders

Question Posted: