Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

NOTE: ALL THE DATA (1,2,3) IS ATTACHED. REQUIRED: I NEED A BRIEF REPORT ON THE ABOVE GIVEN DATA AND THE ANALYSIS ON THE DATA. LENGTH

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

NOTE: ALL THE DATA (1,2,3) IS ATTACHED. REQUIRED: I NEED A BRIEF REPORT ON THE ABOVE GIVEN DATA AND THE ANALYSIS ON THE DATA.

LENGTH : 2 Pages

Assume you are an employee at Kuwait Towers and your manager has given you the 'Kuwait Towers' Data workbook. You and your team must Analyze the Excel Workbook 'Kuwait Towers' and write a report with your findings to the Manager in a 1- 2-page report following APA Format. You must also include the below: 1. From the First worksheet, 'Yearly Visitors,' there is a table showing the visitors per year for 2017,2018 & 2019. View the data, analyze the data, and explain your findings. Give reasons for the changes in number of visitors. (10 points) 2. In the second worksheet, 'Revenue Breakdown,' do you see any trends? Explain your findings. Also, think of new revenue opportunities? (10 points) 3. In the '2020 Data' sheet, you will find a 2020 data chart, copy the chart to your report document and explain the chart in your document. (10 points) Yearly Visitors Revenue Breakdown 2020 Data 8373 January February March April May June July August September October November December Total Revenue per year Visitor per year 2017 2018 8321 7133 5337 6543 6297 8537 7665 8970 6891 6606 8330 6556 8392 9034 6468 9061 6386 6882 8324 9638 7756 7700 9628 95033 89795 2019 6033 9693 5079 8768 9243 8153 8423 7443 8274 7384 9887 6376 94756 Maximum number of visitor Minimum number of visitor 9887 5079 KWD 380,132 KWD 359.180 KWD 379,024 Yearly Visitors Revenue Breakdown 2020 Data Revenue Breakdown for 2019 January February March April May June July August September October November December Tickets Restaurant Booking KWD 37,312 KWD 28,212 KWD 2,966 KWD 36,240 KWD 39,120 KWD 1,206 KWD 24,312 KWD 24,120 KWD 1,337 KWD 33,816 KWD 34,5121 KWD 1.272 KWD 33,940 KWD 21,312 KWD 2,133 KWD 31,640 KWD 36,024 KWD 2,488 KWD 30,512 KWD 21,480 KWD 2,223 KWD 32,112 KWD 35,724 KWD 1,136 KWD 37,916 KWD 23,100 KWD 1,846 KWD 34.068 KWD 33.120 KWD 2,063 KWD 24,340 KWD 28,224 KWD 1,304 KWD 23,612 KWD 22,812 KWD 1,757 Yearly Visitors Revenue Breakdown 2020 Data 2020 Data Actunt tot total sales in 2020 Data Predictions 5.000 Data Predictions Visitors 3.O KWD 4,000 KWD 710 KWD 2.130 KWD 2.40 546 KWD 1.6381 KWD 542 KWD 1.6261 KWD 2.168 851 KWD 2.553 KWD404 KWD 20331 KWD 3.100 981 KWD 2.949 KWD 1.932 k36 KWD 2.SON KWD1144 647 KWD 1941 KWD 2.588 733 KWD 2,199 KWD 2,9321 964 KWD 2.9521 KWD 3.936 759 KWD 2.2721 KWD 3.036 XIS KWD 2,4541 KWD 3.272 January February March April May June July August September October November December Actual total Sales in 2020 Manth Sales January KWD 2.959 February KWD 2419 March KWD 3.1551 April KWD 2.699 May KWD1,144 June KWD 2.154 July KWD 2.214 August KWD 2.2021 September KWD 2.720 October KWD 230 November KWD 2.165 December KWD 2471 4.000 3.000 2.000 1.000 0 Number of days April 1, 2020 - May 31, 2020 Number of days January 1, 2020 - December 31, 2020? Total number of days Kuwait Towers worked in 20207 165 305 Assume you are an employee at Kuwait Towers and your manager has given you the 'Kuwait Towers' Data workbook. You and your team must Analyze the Excel Workbook 'Kuwait Towers' and write a report with your findings to the Manager in a 1- 2-page report following APA Format. You must also include the below: 1. From the First worksheet, 'Yearly Visitors,' there is a table showing the visitors per year for 2017,2018 & 2019. View the data, analyze the data, and explain your findings. Give reasons for the changes in number of visitors. (10 points) 2. In the second worksheet, 'Revenue Breakdown,' do you see any trends? Explain your findings. Also, think of new revenue opportunities? (10 points) 3. In the '2020 Data' sheet, you will find a 2020 data chart, copy the chart to your report document and explain the chart in your document. (10 points) Yearly Visitors Revenue Breakdown 2020 Data 8373 January February March April May June July August September October November December Total Revenue per year Visitor per year 2017 2018 8321 7133 5337 6543 6297 8537 7665 8970 6891 6606 8330 6556 8392 9034 6468 9061 6386 6882 8324 9638 7756 7700 9628 95033 89795 2019 6033 9693 5079 8768 9243 8153 8423 7443 8274 7384 9887 6376 94756 Maximum number of visitor Minimum number of visitor 9887 5079 KWD 380,132 KWD 359.180 KWD 379,024 Yearly Visitors Revenue Breakdown 2020 Data Revenue Breakdown for 2019 January February March April May June July August September October November December Tickets Restaurant Booking KWD 37,312 KWD 28,212 KWD 2,966 KWD 36,240 KWD 39,120 KWD 1,206 KWD 24,312 KWD 24,120 KWD 1,337 KWD 33,816 KWD 34,5121 KWD 1.272 KWD 33,940 KWD 21,312 KWD 2,133 KWD 31,640 KWD 36,024 KWD 2,488 KWD 30,512 KWD 21,480 KWD 2,223 KWD 32,112 KWD 35,724 KWD 1,136 KWD 37,916 KWD 23,100 KWD 1,846 KWD 34.068 KWD 33.120 KWD 2,063 KWD 24,340 KWD 28,224 KWD 1,304 KWD 23,612 KWD 22,812 KWD 1,757 Yearly Visitors Revenue Breakdown 2020 Data 2020 Data Actunt tot total sales in 2020 Data Predictions 5.000 Data Predictions Visitors 3.O KWD 4,000 KWD 710 KWD 2.130 KWD 2.40 546 KWD 1.6381 KWD 542 KWD 1.6261 KWD 2.168 851 KWD 2.553 KWD404 KWD 20331 KWD 3.100 981 KWD 2.949 KWD 1.932 k36 KWD 2.SON KWD1144 647 KWD 1941 KWD 2.588 733 KWD 2,199 KWD 2,9321 964 KWD 2.9521 KWD 3.936 759 KWD 2.2721 KWD 3.036 XIS KWD 2,4541 KWD 3.272 January February March April May June July August September October November December Actual total Sales in 2020 Manth Sales January KWD 2.959 February KWD 2419 March KWD 3.1551 April KWD 2.699 May KWD1,144 June KWD 2.154 July KWD 2.214 August KWD 2.2021 September KWD 2.720 October KWD 230 November KWD 2.165 December KWD 2471 4.000 3.000 2.000 1.000 0 Number of days April 1, 2020 - May 31, 2020 Number of days January 1, 2020 - December 31, 2020? Total number of days Kuwait Towers worked in 20207 165 305

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Audit Committee Handbook

Authors: Louis Braiotta Jr.

4th Edition

0470226420, 978-0470226421

More Books

Students also viewed these Accounting questions