Assessment Task 3 – Individual Assignment

Assessment Task 3 – Individual Assignment 

This is an individual task. It accounts for 30% of your total mark. Ongoing submissions (via course site) from Week 1 to Week 11.

Purpose 

This assignment assesses your ability to calculate and interpret data (analytical skills) plus how this may feed into management plans or strategies (interpretation of analytical results). 

Take 

carful note of the marks allocated for each part as a guide to the effort required to provide a sufficient answer that part. Task It is Question – Answer style assignment. You are expected to supply a professional report as would be expected in the workplace. A 10% penalty (reducing the overall mark) will be applied where answers are difficult to access or identify due to poor presentation related to either stylistic or technical reasons.

Instructions

 - Choose to answer any two questions (from a choice of five).

 - Word limit. 500-700 words for each question. 

- Format is open – you may submit using MS Excel (preferred), MS Word

, – or use both (or other similar software). 

- Each question contributes 15% towards assessment

. - Submit online at the course site. 

 - Multiple files are allowed (e.g., MS Excel file and MS Word file). It is recommended that you use MS Excel exclusively—though take care to make the final answer to each part obvious to the marker. 

- Mark clearly the question and part attempted 

- Include your name and student ID in the name of the files as well as in the first page of the files, e.g. Jane Citizen 20212021. 

- Pay attention to the weight of parts within questions

. - Penalty will apply for late submission: 10% of the marks for this task for each delay in submission of a day (weekend included).

Question 1 

The Endless Point Rest is a popular and friendly family coastal resort. The resort consists of 122 self contained family style units and 24 hour reception. The pricing policy follows a fixed low rack rate; the same price on every room. This strategy keeps the guest rolling in and makes the resort the envy of other local accommodation providers as these establishments are rarely more than half full. The friendly owners of Endless Point Rest, known as Ma and Pa, have a policy of not charging no shows. As Ma says “if they can’t come then we got no right to take away their hard earned money and anyway, we want to see them next time.” Just today, Ma and Pa’s son Emmet has returned home after completing his business degree. He sits Ma and Pa down. “Ma and Pa, we don’t have to be losing money – we’re fully booked every night of the year – and don’t you see that a no show means the room is lost?” Emmet’s eyes light up. “I can do some calculations and work out a plan – but we need to overbook!” “I don’t know Emmet” says Pa, “we still got the room for the next night but I can’t build another one in just a few hours if too many families show up. And that old tent with holes we used to use for emergencies just aint so popular anymore. ” “Leave that to me” replies Emmet. Emmet’s research has profiled no shows based on a year (365 days) of records:

Booking no shows (# rooms)          Nights 

0                                                              20

 1                                                             53

 2                                                              65 

3                                                               74

 4                                                              49 

5                                                               36

 6                                                              23 

7                                                               15 

8                                                               11

 9                                                                7

 10                                                              6 

11                                                               4 

12                                                               2

Emmet has estimates that every no show is a loss if $73 per room per night. So he makes a deal with BillyBob, the manager of Lucky Zest resort. “Billy-Bob, take our walks and we’ll pay the charge. I know your rack rate is $230 a night – what about we pay you $90 a room per night for getting our free business? We’ll never walk more than 12 to you any one night.” Billy-Bob knows a good deal when he hears it. “Ok, covers our variable costs easy – and we always got rooms - you’ve got a contract.” Emmet knows the loss from a walk is more than just paying the cost of Billy-Bob’s resort room. Even though the walked customer will have already paid The Endless Point Rest $97 (for the unavailable room), Emmet estimates the additional cost (loss of good will, loss of additional services) to be $110 per walked guest.

complete case study is attached below