TASK A1: Spreadsheet 1 You will oversee accommodations for Panorama Inc., a multi-national company that has inquired about accommodations at the hotel you work in for their annual retreat. Employees are expected to bring their respective families, and you will need to consider the number of guests for each room. Take into consideration the number of family members for each guest, and if a guest comes with no family, as per your supervisor, which rooming arrangements will allow the company to save money.

Below are the rates for each of the rooms:

ROOM TYPE	MAX OCCUPANCY	BEDS	PRICE
SUPERIOR QUEEN	2	1 (Queen)	$240
SUPERIOR TWIN ROOM	4	2 (Double beds)	$210
SINGLE ROOM	2	1 (Double beds)	$190
FAMILY ROOM	4	1 (Double) 2 (Single)	$190
GROUP	6	3 (Bunk beds)	$190

Below is the expected guest list forwarded by Panorama Inc.:

NAME	POSITION IN THE COMPANY	ADDITIONAL GUESTS PER EMPLOYEE
Aleeyah Abd-Al Rashid	Chief Executive Officer	NA
Ingrid Bergman	Chief Operating Officer	1 (adult)
Leon Wagner	Director of Marketing	3 (1 adult, 2 children)
Crispin Basilio	Marketing Manager	3 (2 adults, 1 child)
Anaisha Devi	Marketing Specialist	NA
Ishana Kumar	Marketing Specialist	NA
Kaia Sharma	Marketing Specialist	NA
Himari Takahashi	Marketing Specialist	NA
Sora Watanabe	Marketing Specialist	NA
Deniece Ackerman	Marketing Specialist	NA
Marcus Teodoro	Chief of Security	2 (1 adult, 1 child)
Maverick McKenna	Security Officer	NA

You will need to submit a report (SPREADSHEET 1) to your supervisor showing the following:

1. The total number of guests divided between adults and children.
2. Which rooms will be designated for each employee, and who among the employees with no expected companions will be staying together, considering your supervisor's instruction about prioritizing the lowest possible rate.
3. The total cost of the hotel accommodations per night, and per the duration of their stay (three days, two nights).

NOTE: Management hasauthorised the use of a group discount of 10% and is willing to provide an additional 10% discount if the total price of the stay exceeds $3000. This should also appear on your report.