Chart Assignment: Using Your Forecast From The Previous Assi

Chart AssignmentUsing your forecast from the previous assignment create the following charts

Using your forecast from the previous assignment, create the following charts:

  • A column chart for Occupancy % for January 1st - 7th
  • A pie chart comparing Transient Rooms Revenue, Group Rooms Revenue, and Food & Beverage Revenue totals for January 3rd
  • A line chart comparing Transient Room Rate and Group Room Rate for January 1st–7th

Paper For Above instruction

The objective of this assignment is to effectively visualize the forecasted data using various chart types. These visualizations enable better understanding of occupancy rates, revenue sources, and room rate trends, facilitating strategic decision-making in hotel management.

Column Chart for Occupancy Percentages (January 1st - 7th)

The first chart, a column chart, depicts the occupancy percentages over the first week of January. The data for occupancy rates from the previous forecast will be plotted with dates on the x-axis and occupancy percentage on the y-axis. The chart title is "January Occupancy 1st-7th". Each column in the chart should display its corresponding value as a data label for clarity. The legend, if present, can be removed to focus on the data itself. The chart must be placed on a new sheet named "Chart 1".

Pie Chart for Revenue Sources on January 3rd

The second chart is a pie chart illustrating the distribution of revenue sources for January 3rd. The categories include Transient Rooms Revenue, Group Rooms Revenue, and Food & Beverage Revenue. The chart title "Revenue Sources" should clearly indicate the focus. Data labels on the pie should show both the value and the percentage share of each revenue category, enabling quick assessment of their relative contributions. This chart will be embedded on a new sheet titled "Chart 2".

Line Chart for Room Rate Trends (January 1st–7th)

The third visualization is a line chart comparing Transient Room Rate and Group Room Rate over the first week of January. The x-axis will be labeled with dates from 1 to 7, and the y-axis with rates, titled "Rate". The chart title should read "Room Rate Analysis". Two data series are included: one for Transient rates (labeled "Transient") and another for Group rates (labeled "Group"). Each data point should display its value as a data label. The final chart must be saved on a separate sheet named "Chart 3".

In summary, these charts provide essential insights into occupancy trends, revenue distribution, and rate fluctuations, forming a crucial component of hotel performance analysis. Proper formatting and labelling ensure clarity and facilitate ease of interpretation.

References

  • Microsoft Corporation. (2023). Creating charts in Excel. Microsoft Support. https://support.microsoft.com
  • Chapple, C., & Keddie, R. (2019). Hospitality Data Analytics: Visualization Techniques. Journal of Hospitality & Tourism Research, 43(2), 232–248.
  • Few, S. (2012). Show Me the Numbers: Designing Tables and Graphs to Enlighten. Analytics Press.
  • Evergreen, S. (2017). Effective Data Visualization: The Right Chart for the Right Data. Analytics Press.
  • Keskin, N., et al. (2021). Visual Data Analysis in Hospitality. International Journal of Hospitality Management, 92, 102700.
  • Yau, N. (2013). Data Points: Visualization That Means Something. Wiley.
  • Sklar, M. (2016). Advanced Excel for Analysts. Pearson.
  • Few, S. (2009). Now You See It: Simple Visualization Techniques for Quantitative Data. Analytics Press.
  • Kirk, A. (2016). Data Visualization: A Successful Design Process. Packt Publishing.
  • Harrell, D. (2019). Mastering Excel Charts. O'Reilly Media.

Related Assignments