Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The www.hotelbooking.com.au is the most popular website for hotel's booking throughout Australia. You are provided with information on hotel booking for the month of September
The www.hotelbooking.com.au is the most popular website for hotel's booking throughout Australia. You are provided with information on hotel booking for the month of September 2019 to November 2019 (check-ins). Pricing is calculated as total tariff - less discounts (for members). The membership level determines the dicounts offered. You are the Junior Accountant and has been asked to complete the website booking summary and reports for the months of September, October and November 2019. You are required to: 1. Complete the Website Booking Summary (highlighted in yellow colour) - 5 marks 2. Complete the Management Report (highlighted in blue colour) - 5 Marks You must use relevant Excel functions for the tasks assigned. Do not calculate the required tasks manually. Use two decimal place where necessary. Note: If you check in a hotel on 1 September and you check out on 8 September, 7 nights tariff applies. Assumptions: 1. No extra charges such as use of mini bar/extra day charges were incurred. 2. All hotels are 3 or 4 star and above Delete Format Sort & Filter Find & Select II 1 Tas Website APL FAL OHRID Nebuntis Level 4 w.cat Discount 100 2 2 . Thal 624 MAM DI 110 21 1 BINS 9X/ 11. SIS os HIN 11 14 ... 789 Sara SOUS 9384 0 2 HAR TIL ZEM 1986 MU 16 25 CF SAS Me TOODE TOODE O 22 Paste BI U Merge & Centre v ,00 Conditional Format Cell Insert U Formatting as Table Styles 141 f D . N F S L2 U 13 Customer Detalles Namberly Details Website Beaking Summary Cuzne vien nors Lat Olly Mertentis leel Dhant Bag Gezne D Calter int Latine Wat nonin Check wenn Voor LA Chedet re deve 15 1 NE HU ... 1513 NA 1957 19 TRE YS CH 5142 NINNI SIRISI w uningan wah 5:33 M: 13 7.SIM 1. 30004 Dac GREEN wir Haas GT 201 Saute NEW Gala 25% II 20003 Datane 200CE Tris bare La 339 10 2 YdaOWE Fidan 25 Mones 2016 5:51 21 2 bers or 2 YR 122 12 5:23 3000 VRE70019 . nede 5:24 12192 22 . HNE LED MUS CU R?! 10000 Sone Cea, CATE yre, NEW WUD 2006 ware 2 20010 22 13 19 So Son NSW Chresto re 20091 5:13 361 he 2 Marcin Per Vibes Eder The VETAIL 1939 Lp . 5.55 30413 Mar Ya! wird The Meersens 5:14 : ASSIKE 27 2013 AM HUTS CLO AKU 2004 p. 10 ? 23 Milun NEW GOT 20026 2000! 1:33 M Wehen eine uc 10466 Sla Wine TE Herd 2:13 T 1dbier & lacra 5:72 an 4014 1 ad 2007 324 Ford with .ro TX ura 2006 TOT Saat The Andi 18 19 2001 W 5.8. PER 10400 Tende Carte st 08/14 Volg 395159 Y WEBS 5271 wwwy 441014 How SE 3284 1111 WHY 11 N 15 19 25 Sone Faths Gori CORTI 2010 Carters 13 5 Bar How 228 19 Gar:: Corts - 2 CLD ILME 20414 5:21 4 HER Raton It Fest 1113 243 19 wy to WE 53.2 Ver BOP Ime 10013 re VER 13 DEN 111 1957 19 Twitter Ys 5252 PICHA 13 14 1 Sone NANCY 1001 Wetens 2coac pana la 1 20 2 la Coop ME 5239 2014 Edite 2013 41 THEO TEST 31 2 __ PISU 5:32 19 pok 131714 12 210E 50" wac Fete Wii BRUNO FOI Pert IMCI LI acco 131 > Luan 3.25 CLD Tarta lo OVOGN 01 20001 El 143.2 45 rahlu Bant 2 Gdp WA 5:34 W IPPSA 2010 Volts... 41 SE LEURS ES th 2 3:33 TICIS LE ME TOR IMMI forte 43 20004 Sone NUR HV Na dan 12 DFELAG 22 2013 2001 Sore Price re de Una Adela EN 10 PICO In to sta 200 5211 2 Ali 12 TE 2 - Dunn SEN NEW 14 M 5221 2000 Vw 19 23a 19 15 Bar : HEN 5:33 PR LUS T! ANIME 3 w 12414 2 IPHY 2000 111 Sort 53 Del 223914 COAT SN LDLK 2000 20040 We bene SOT Craig _23 Ss 19 5233 Statens CD IPTCHA 20416 20041 Istane ocentes Fest TE om 12 HET 59.3 dan ME Part wa 15 24515 WH EP frame 3919 M: PILIH 23 20044 www & Sonie La LEX 21:4 Pety CHOOL N 20023 Carter 1 20043 22 Sep 19 Fra Llor Most W MEN.TG 3000 5913 Bea in its ner 22:2 Sri Goss WE 5:37 Tin 104T EXT Bu Hotel 29571 15 5:33 ond 2814 NI PYA KW LPNOO annan NP Mlayu 63 ECCE EPS 100 Sone Der CLD 20119 acco ons NACA 01 wa tanete 5:22 Ne CLD ENSE Here 20133 Mount Na SatWatanlar Hd 273519 TE +91 99519 5:57 HATI 15 W 5:33 PHI > F an Sone HOV Garre 1210 2 Arr CLD Eco 2001 Son Gata 1922 5 C 19 mie ENCIDO 2010 5.75 ConsHOT Cartet AB nas Ce: 19 CH 5:35 NAY Full W JIMI 322 SHE 72 114 |Hts HU PELTO Laura 73 wire had 361 FITORE Dalero KW 1920 20160 Carter Tradio 1922 LD 5272 . 2 10.10% INIC POC GOOD GC 119 Jan 10.SEX 1.1 un FE cuc ESPA : HANDISELLE WON DOOR SARIS org 500 ar in 1 SA 3.025 7.21 pa 4 UERIE 4.14 . BIL . S10E 1.CL 1.596 US cal TILNIE - R 4115 1.79 2 . HUN 2635 INC 9.00 2.15 CPH TH WORM WIE PER WEMA - 12 . 10 2 114.3 21 MIVEL 3/4 5.29 2 CHIC SER PIC 1142 CY 19010 2001 POOL ! _ cu 2 IN AIL MILIC #111 5.12 +7,9% 11.14 1.72 ILLES TEEPA 2 2 92000 Required (PART B) Management Report (1 mark) List down the answer of the following: 1. How many times each of the hotel was chosen by customer? The Orchid Ibis Hotel Holiday Inn (1 mark) 2. Total Sales revenue by each of the hotel The Orchid Ibis Hotel Holiday Inn (1 mark) 3. Average sales revenue by membership Status None Silver Platimum (2 marks) 4. Discuss, justify and illustrate two more functions that can be included, in a case like this, to help with decision making regarding (Choose any 2 points) Customers who are likely to default Employees who are putting in long hours Items that are providing outstanding returns A model to forecast demand for the next quarter. You can use any sample data for the purpose of illustration. The www.hotelbooking.com.au is the most popular website for hotel's booking throughout Australia. You are provided with information on hotel booking for the month of September 2019 to November 2019 (check-ins). Pricing is calculated as total tariff - less discounts (for members). The membership level determines the dicounts offered. You are the Junior Accountant and has been asked to complete the website booking summary and reports for the months of September, October and November 2019. You are required to: 1. Complete the Website Booking Summary (highlighted in yellow colour) - 5 marks 2. Complete the Management Report (highlighted in blue colour) - 5 Marks You must use relevant Excel functions for the tasks assigned. Do not calculate the required tasks manually. Use two decimal place where necessary. Note: If you check in a hotel on 1 September and you check out on 8 September, 7 nights tariff applies. Assumptions: 1. No extra charges such as use of mini bar/extra day charges were incurred. 2. All hotels are 3 or 4 star and above Delete Format Sort & Filter Find & Select II 1 Tas Website APL FAL OHRID Nebuntis Level 4 w.cat Discount 100 2 2 . Thal 624 MAM DI 110 21 1 BINS 9X/ 11. SIS os HIN 11 14 ... 789 Sara SOUS 9384 0 2 HAR TIL ZEM 1986 MU 16 25 CF SAS Me TOODE TOODE O 22 Paste BI U Merge & Centre v ,00 Conditional Format Cell Insert U Formatting as Table Styles 141 f D . N F S L2 U 13 Customer Detalles Namberly Details Website Beaking Summary Cuzne vien nors Lat Olly Mertentis leel Dhant Bag Gezne D Calter int Latine Wat nonin Check wenn Voor LA Chedet re deve 15 1 NE HU ... 1513 NA 1957 19 TRE YS CH 5142 NINNI SIRISI w uningan wah 5:33 M: 13 7.SIM 1. 30004 Dac GREEN wir Haas GT 201 Saute NEW Gala 25% II 20003 Datane 200CE Tris bare La 339 10 2 YdaOWE Fidan 25 Mones 2016 5:51 21 2 bers or 2 YR 122 12 5:23 3000 VRE70019 . nede 5:24 12192 22 . HNE LED MUS CU R?! 10000 Sone Cea, CATE yre, NEW WUD 2006 ware 2 20010 22 13 19 So Son NSW Chresto re 20091 5:13 361 he 2 Marcin Per Vibes Eder The VETAIL 1939 Lp . 5.55 30413 Mar Ya! wird The Meersens 5:14 : ASSIKE 27 2013 AM HUTS CLO AKU 2004 p. 10 ? 23 Milun NEW GOT 20026 2000! 1:33 M Wehen eine uc 10466 Sla Wine TE Herd 2:13 T 1dbier & lacra 5:72 an 4014 1 ad 2007 324 Ford with .ro TX ura 2006 TOT Saat The Andi 18 19 2001 W 5.8. PER 10400 Tende Carte st 08/14 Volg 395159 Y WEBS 5271 wwwy 441014 How SE 3284 1111 WHY 11 N 15 19 25 Sone Faths Gori CORTI 2010 Carters 13 5 Bar How 228 19 Gar:: Corts - 2 CLD ILME 20414 5:21 4 HER Raton It Fest 1113 243 19 wy to WE 53.2 Ver BOP Ime 10013 re VER 13 DEN 111 1957 19 Twitter Ys 5252 PICHA 13 14 1 Sone NANCY 1001 Wetens 2coac pana la 1 20 2 la Coop ME 5239 2014 Edite 2013 41 THEO TEST 31 2 __ PISU 5:32 19 pok 131714 12 210E 50" wac Fete Wii BRUNO FOI Pert IMCI LI acco 131 > Luan 3.25 CLD Tarta lo OVOGN 01 20001 El 143.2 45 rahlu Bant 2 Gdp WA 5:34 W IPPSA 2010 Volts... 41 SE LEURS ES th 2 3:33 TICIS LE ME TOR IMMI forte 43 20004 Sone NUR HV Na dan 12 DFELAG 22 2013 2001 Sore Price re de Una Adela EN 10 PICO In to sta 200 5211 2 Ali 12 TE 2 - Dunn SEN NEW 14 M 5221 2000 Vw 19 23a 19 15 Bar : HEN 5:33 PR LUS T! ANIME 3 w 12414 2 IPHY 2000 111 Sort 53 Del 223914 COAT SN LDLK 2000 20040 We bene SOT Craig _23 Ss 19 5233 Statens CD IPTCHA 20416 20041 Istane ocentes Fest TE om 12 HET 59.3 dan ME Part wa 15 24515 WH EP frame 3919 M: PILIH 23 20044 www & Sonie La LEX 21:4 Pety CHOOL N 20023 Carter 1 20043 22 Sep 19 Fra Llor Most W MEN.TG 3000 5913 Bea in its ner 22:2 Sri Goss WE 5:37 Tin 104T EXT Bu Hotel 29571 15 5:33 ond 2814 NI PYA KW LPNOO annan NP Mlayu 63 ECCE EPS 100 Sone Der CLD 20119 acco ons NACA 01 wa tanete 5:22 Ne CLD ENSE Here 20133 Mount Na SatWatanlar Hd 273519 TE +91 99519 5:57 HATI 15 W 5:33 PHI > F an Sone HOV Garre 1210 2 Arr CLD Eco 2001 Son Gata 1922 5 C 19 mie ENCIDO 2010 5.75 ConsHOT Cartet AB nas Ce: 19 CH 5:35 NAY Full W JIMI 322 SHE 72 114 |Hts HU PELTO Laura 73 wire had 361 FITORE Dalero KW 1920 20160 Carter Tradio 1922 LD 5272 . 2 10.10% INIC POC GOOD GC 119 Jan 10.SEX 1.1 un FE cuc ESPA : HANDISELLE WON DOOR SARIS org 500 ar in 1 SA 3.025 7.21 pa 4 UERIE 4.14 . BIL . S10E 1.CL 1.596 US cal TILNIE - R 4115 1.79 2 . HUN 2635 INC 9.00 2.15 CPH TH WORM WIE PER WEMA - 12 . 10 2 114.3 21 MIVEL 3/4 5.29 2 CHIC SER PIC 1142 CY 19010 2001 POOL ! _ cu 2 IN AIL MILIC #111 5.12 +7,9% 11.14 1.72 ILLES TEEPA 2 2 92000 Required (PART B) Management Report (1 mark) List down the answer of the following: 1. How many times each of the hotel was chosen by customer? The Orchid Ibis Hotel Holiday Inn (1 mark) 2. Total Sales revenue by each of the hotel The Orchid Ibis Hotel Holiday Inn (1 mark) 3. Average sales revenue by membership Status None Silver Platimum (2 marks) 4. Discuss, justify and illustrate two more functions that can be included, in a case like this, to help with decision making regarding (Choose any 2 points) Customers who are likely to default Employees who are putting in long hours Items that are providing outstanding returns A model to forecast demand for the next quarter. You can use any sample data for the purpose of illustration
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