The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
Looking for someone who is good in Excel and business analysis.
You will be doing record keeping/data analysis for a small hotel/cottage. You will be given data sample of 50 customers to work with, to show that the spreadsheet works as intended
Part 1: Design a simple spreadsheet model for the revenue of the business - Input, Processing Output
Part 2: Implement the Spreadsheet Model
Using your IPO chart as a guide, create a workbook, containing separate worksheets for reference data, (cottages, costs and booking details) calculationsand a summary. Create a menu to navigate the workbook.
The first calculation should contain the following:
• Columns to record the following transaction details: Booking number,Days booked, Cottage name, Nightly rate, Total standard rate, Number of days at discounted rate (if any), Total discount, Total revenue
• Dynamic Linking for the transfer of data from the input sheet to the processing sheet
• Calculations for the nightly rate (vlookup formula)...
Sign in or Register to see more