Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood Village Hall Spreadsheet - Coggle Diagram
Westwood Village Hall Spreadsheet
Target audience
All ages
Customers who have booked the hall.
House style
Brown and green colours
Bold title
Different than usual font
Client requirements
Have an easy interface for everybody
Show details about who has booked the hall for what date and time
Managers can add additional accessories/ items
Manager has to be able to put in and change hall bookings.
Be able to put in different types of booking
See how much each type of booking costs
User Interface
Easy to use for everybody
Only managers or authorise personnel can edit spreadsheet
Only people with a valid password can access the spreadsheet
Calculations required
Total number of bookings
Number of bookings per customer
Total number of bookings per type of booking
Total income from bookings
Total number of bookings including extra
Total income from extra
Total income at end of month
Total income from each customer for booking
Graphs
I will make a couple graphs for the calculations
The number of customers who ordered extras will be in a pie chart comperde to those who didn't
Income from bookings and extras will be in a bar chart
Total number of bookings per customer is a bar chart
Invoice
Easy to understand for the customer
Everything itemized but at the end with a total cost