Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started