I am attaching an Excel spreadsheet of data which I need to get some analysis and reporting carried out on please. Details are:
Spreadsheet "BegaAvisrentals for analysis" contains 5 worksheets of data showing hire car bookings by company for 5 financial years (July to June), each year is on a separate worksheet. Column B (Forward Date) should be used as the pick up date for the car hire booking, Column F should be used as the drop off day to return the car. Column H has the $ cost for each booking.
I need analysis and reporting to show me the following:
- Total cost for hire car usage per year (financial year as displayed on the worksheets)
- Total cost for hire car usage by each company per year e.g. spend with Avis and spend with Hertz
- Total cost for hire car usage each month for each year
- if possible I'd like to work out average cost for a hire car per day of use
Accuracy in the analysis is essential and I need to have all the data, analysis and reporting provided back to me.
PLEASE REVIEW THE ATTACHED FILE AND BE CERTAIN THAT YOU CAN DELIVER THE PROJECT AS PER YOUR PROPOSAL BEFORE YOU BID TO DO THE WORK. IF YOU YOU BID IN LESS THAN FIVE MINUTES, I WILL ASSUME THAT YOU HAVE NOT REVIEWED THE DATA AND WILL NOT AWARD YOU THE WORK. Thank you.