Maria has a popular B&B in the Orkney Islands and opens 8 months in a year (March-October). Maria has noticed that the number of rooms do not satisfy the increasing demand. The B&B has 30 rooms, with average revenue per occupied room of £45. The actual occupancy is as follows:
March |
April |
May |
June |
July |
August |
September |
October |
70% |
80% |
90% |
100% |
100% |
100% |
95% |
80% |
It has been estimated from records that in the months when the hotel is full the potential demand was greater by 30% in June, by 60% in July and August.
Maria is looking into building 3 extra rooms at a cost of £30,000 each. You have to prepare a financial report about the convenience of building which means engaging in construction, equipping the rooms and a full renovation (construction will take place in idle months –November to February-. Fixtures and fittings for each room are estimated at £5,000 and the renovation costs are £30,000. Maria does not give credit and only accepts cash payments.
The operating costs (in £) of running the B&B are as follows:
Cost (description) |
Total |
% fixed |
% variable |
Maria’s salary |
30,000 |
100% |
0% |
Permanent staff |
100,000 |
100% |
0% |
Casual staff (only Jun-July-Aug) |
(10% of sales of relevant months) |
0% |
100% |
Cost of goods sold (breakfast) |
(5% of sales) |
0% |
100% |
Annual rates |
15,000 |
100% |
0% |
Hotel supplies |
(8% of sales) |
0 |
100% |
Fixed Overheads |
30,000 |
100% |
0% |
Variable overheads |
10% of sales |
0 |
100% |
a) Critically evaluate new approaches to budgeting (10 marks).
b) Prepare a cash budget for the hotel after expansion. Expect yearly growth, starting in year 2 of 5% (increase in revenue). Spread all fixed costs evenly over 8 months. Assume that all costs will increase by 3% and revenue will increase by 5% (after Y2, second year after expansion). All purchases for the breakfast are made on credit one month in arrears. All overheads are paid one month in arrears. Annual rates are paid in two equal instalments April and September. Assume that opening cash balance is £ 2,000. (10 marks)
c) Calculate the contribution per room sold (10 marks)
d) Calculate the Break-even point in number of number of rooms sold. Assume that Break-even will be achieved in 3 years. Also assume that costs will increase 3% and revenues will increase 5% every year (see previous task). (10 marks)
e) Define margin of safety and calculate the margin of safety. (5 marks)
f) Calculate ARR, payback, discounted payback, IRR and NPV (3 years). (20 marks) Assuming a cost of capital of 9% and expected growth of 5% assess whether this is a good investment (5 marks). Total 25 marks
g) Define sensitivity analysis and discuss its importance (5 marks) Discuss the effect that a combined drop (sensitivity analysis) of 10% in demand plus an increase in inflation from 3% to 5% will have on payback, discounted payback, NPV and break-even point. Assume that construction costs will not change. Total 20 marks
h) Write a brief conclusion (5 marks)
I love it. It is done earlier than due time and I have time to add my own point. Use own word and well written.
MyAssignmenthelp.com boasts a team of talented and experienced thesis helper who are capable of providing best quality thesis help services. Our wide range of thesis writing services include assistance with writing and structuring top-quality thesis, help with research, topic selection help and editing and proofreading help. Students can get any of these services at cheap price. Despite charging cheap from student, our thesis writers never compromise with the quality. They efficiently answer students queries pertaining to can someone help me with my thesis paper.
Just share requirement and get customized Solution.
Orders
Overall Rating
Experts
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
Im certain very pleased with the work done.All my requirements were very in detail meet. Thank you
Australia
You wont believe who just got 93% on the first assignment i asked you guys to do for me. Keep up the good work guys. I'm definitely going to tell my friends
Australia
The outcome was very good and satisfactory.I am planning to submit more assignments in near future.
Australia
Work delivered as requested, ahead of the deadline. Fully referenced, could not have asked for more. Thanks guys & gals!
Australia