You are in charge of a small hotel and you have an idea to create a new revenue stream for the owners of the hotel by converting the unused roof into a roof garden serving cocktails and finger food and also offering DJ music. You need to organise your ideas and facts into a mini business plan to present to the owners. To achieve this task you need to employ your MS-OFFICE skills.
Data:
- The roof garden service will run between 1st of May and 30th of September
- You will need one bar-person and two waiters and they will cost you €150 each per night.
- The DJ with all his PA equipment will charge you €200 per night
- The average cost for finger food and drinks will be €15 per guest
- The capacity of the roof garden is 200 customers
- You cannot sell higher (mark-up) than 50% from cost price
- You will need to spend €15,000 to properly decorate and furnish the roof garden
TASK 1: MS-WORD
Design an invitation and Mail-Merge it to the hotel’s best 200 customers (included file). The invitation concerns the inaugural party for your recently renovated Roof Garden.
- Overall design of the invitation. (5marks)
- Use text boxes, insert headings, add tables and create columns and borders. (5marks)
- Your own photos and images from the clip art library can be used. (3marks)
- Word art can be used to add colourful flair. (3marks)
- MS-Word Mail Merge. (4marks)
TASK 1 Total marks: 20
TASK 2: MS-EXCEL
Design a spreadsheet to calculate expenses and revenues for your roof garden service for the period of operation. Calculate the combination of the average number of customers per night and the appropriate mark-up, so that the investor will get his investment back in one season: (15marks)
Create appropriate chart (s) depicting expenses and revenues for the period of operation. (5marks)
TASK 2 Total marks: 20
TASK 3: MS-ACCESS 2007
You must create a CUSTOMERS table featuring all the necessary fields of your existing customers, so that you can send them invitations, offers and special deals. Populate your database with 10 fictitious customers. (5marks)
Create:
- A form to enter customer data (5marks)
- A query of all your customers (5marks)
- A report of all your customers (5marks)
TASK 3 Total marks: 20
TASK 4: MS-POWERPOINT
Design a PowerPoint presentation with no more than 12 slides to communicate to the owners of the hotel the feasibility and the benefits of your roof garden idea incorporating content from TASKS 1, 2 and 3 above so that they will hopefully finance it. (20marks)
TASK 4 Total marks: 20
TASK 5: OVERALL ASSIGNMENT
In this MS-WORD file you must analyse and describe how you tackled Tasks 1-4 (above). Describe your assumptions and choices and document your decisions. (20marks)
TASK 5 Total marks: 20
Do you need help with this assignment or any other? We got you! Place your order and leave the rest to our experts.