So, I'm going over some of our financial reports at work and I feel the need to change the format I came up with a few years ago. I feel like I am trying to display too much information at one time. I'd also like to add comparisons for 1-year (last year vs this year), 5-year (last 5 average vs this year), and 10-year trends. We look at these reports weekly, as an overview of our performance for the year vs last year.
I'm not sure if I should try consolidating this information, or just leaving it as it is already. I spent a lot of time setting up these Excel sheets 5 years ago, but I'm not sure if this is really the best way to present all the information.
This is what my reports currently display, with each week on a new line:
YTD Total, Attendance, Box Office, Concession Gross, Average Ticket, Concession Per Cap, Payroll Hours, Payroll Dollars, Efficiency, along with last year-same week comparisons for nearly each category.
I'm currently inputting 5 variables, and resulting in a sheet that has almost 20 columns of information, for 52 weeks. Surely there has to be a cleaner way to do this?