Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood Car Hire - Coggle Diagram
Westwood Car Hire
Different types of cars available to hire
BMW
Mercades
Nissan
Range Rover
Discovery
Ford
the new comuter system needs to:
Store details about the customers who have hired a car
Follow the organisation house style/branding by reflecting the logo
Have an easy to use human computer interface
Allow Jamal and the staff to:
record the car type hird and the number of days it is hired
Record any extra items included with the car hire.
Record the car type hired code as C,E,F,L or M using data validation
Formulas
=COUNT
=IF
=VLOOKUP
=SUM
=COUNTIF
customers can include extra items with the car hire
a child seat
an additional driver
The extra items are charged per hire
House Style
Green
Circle shape logo
Requires a password
WCH*25
manage by Jamal
Customers hire a car for a minimum of one day
WCH is offering a discount for customers who book for 3 days or more
Recieve a discount of 25% off the total hire charge from day 3 onwards