Please enable JavaScript.
Coggle requires JavaScript to display documents.
Car Hire spreadsheet mind map - Coggle Diagram
Car Hire spreadsheet
mind map
work
data about the customers
if they have driving license so if they can drive the car
how many days he rented it to collect money
name and surname of the customer
information about the car
if it been given extra items
what the type of car it is
target audience
jamal to see
the clientsdo not see
the staff to see
calculation
the total income generated in the month from car hire if the discount of 25% is given
the total number of bookings for customers who do not hold a UK driving license
the total number of bookings for each car type that include one or more additional items with the car hire
the number of bookings made by customers for each car type hired
the total income generated from each car type hired
the total number of days each car type is hired
the total number of bookings for customers who hold a UK driving license
components
car hire summary
overview of every car
every detail about the cost of a car like type or reservation date
car details
every car type specific information
details of car license number or where it made
reservation date
help to know the start and the end dates for each car hired
avoid conflicts when they overlap another reservation
cost breakdown
the cost of each car type
additional items fees, insurance, rental fees
Payment tracker
track the states of each car payment
prevent misunderstanding and ensure timely payment
extra
have extra copy of all the data in the real world
utilize formulas to make sure its correct
regularly update the spread sheet
Benefits
help on tracking multiple cars for many reasons
give information easily to the organization
spreadsheet main front
