Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood Car Hire - Coggle Diagram
Westwood Car Hire
Calculations needed
Total income generated from all car types hired
Number of bookings made by customers
Total number of days
Total number of bookings for customers with UK license
Total number of bookings for customers without UK license
Total number of bookings that include additional items
Total income generated in the month if 25% discount is given
what the client (Jamal) needs from the software
Store details about customers that hire the cars
An easy to use Human Computer Interface (HCI)
Reflect the logo/company style
Record cars hired and number of days
Record car type with code (C, E,F, L, M) using data validation
Needs appropriate security measures to assure no unauthorised people have access
System can only be accessed by authorised people using the password, WCH*25
Spread sheet formulas used
=SUM
=COUNTIF
=COUNTA
=VLOOKUP
=AVERAGE
=IF
cars available to hire
motorbikes
audi
jaguar
mercedes
vauxhall
Assets
Westwood car hire logo
Details of november bookings
Daily hire costs
Additional items cost
Discounts
Discount for customers who book for 3 days +
Receive 25% off total hire charge from day 3 onwards
Jamal needs to compare the income generated before and after the discount is applied
Jamal wants to see the effect on the income if price of hire for each car increases by £5
Design features
Follow the green theme of the logo
Sage green and black
I will use the shades of green in the title cells of each column
I will use black for the borders of the spread sheet
added costs
additional driver
childrens car seat