Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Youre a manager for Mugone Bwino Bed and Breakfast Lodge which is involved in a major renovation that will have space for 100 standard hotel

Youre a manager for Mugone Bwino Bed and Breakfast Lodge which is involved in a major renovation that will have space for 100 standard hotel rooms. You are wondering whether some of that space should be used for luxury suite rooms, each of which would be twice the size of a standard room. For example, you could plan for 20 suites, in which case you would have remaining space for 60 standard rooms (100 2*20 = 60). Your overall construction costs wont be impacted by this decision, because a suite costs about twice as much to build as a normal lodge room. You predict being able to fetch K800/night and K1,269/night for standard and luxury rooms, respectively. Anticipated demand for... Standard rooms mean of 50, standard deviation of 10 Luxury suites mean of 20, standard deviation of 10 Note: you can upgrade a customer from standard luxury, if the better room is available. Occupied rooms incur the following nightly cost (for cleaning/upkeep/utilities): Standard rooms K250.50 Luxury suites K420 You estimate fixed costs (including amortized building costs and other overhead such as staff salaries) at K11,000 per night. Required: Two Models as follows; 1. Create a Deterministic Model for Mugone Bwino Bed and Breakfast Lodge (finance/profit/cost/capacity/whatever) that will provide a reflection of the possible expected performance of the Lodge for each night if all the Standard rooms and Luxury suits are taken. 2. Using the MAX, ROUND, NORMINV and RAND for both the Standard rooms and Luxury suits, create a Stochastic Model that will show the possible performance of the Mugone Bwino Bed and Breakfast Lodge for different occupancy for a night.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Routledge Handbook Of State Owned Enterprises

Authors: Luc Bernier, Massimo Florio, Philippe Bance

1st Edition

1138487694, 978-1138487697

More Books

Students also viewed these Finance questions

Question

Explain the various techniques of Management Development.

Answered: 1 week ago