Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood Car Hire Spreadsheet - Coggle Diagram
Westwood Car Hire Spreadsheet
User Requirements
To store details about the costumers and who hired a car
Follow the organisation house colour and branding
Have an easy to interface (HCI)
Record any extra items
Record the car type hired and number of day for
User Interface
A google sheet
That the can acsess
Style
House Colours
The style of the brand
Target Audience
Westwood Car Hire (WCH) is an organisation that customers can hire cars from. WCH is managed by Jamal. Jamal wants to introduce a new computer system using spreadsheet software to help manage the business
There is discounts for costumers to to 25% of if booking is longer than 3 days
Calaculations
the total number of bookings for each car type that include one or more additional items with
the car hire
the total number of bookings for customers who do not hold a UK driving licence
the total number of bookings for customers who hold a United Kingdom (UK) driving licence
the total number of days each car type is hired
the total income generated in the month from car hire if the discount of 25% is given.
the number of bookings made by customers for each car type hired
the total income generated from each car type hired
Graphs Needed
November_Bookings.csv
Extra_Item_Costs.csv
Westwood_Car_Hire_logo.jpg
Hire_Cost.cvs
WestwoodCH_Test_Plan.rtf
