Develop a spreadsheet model to show the total cost of ownership over three
years for the two cars you selected in task one. You also need to include
the costs of learning to drive
Include the following details
• Buying the cars
• Annual Servicing work on about (£150).
• Insurance (assume a full license 10,000 miles a year and accept a £300 pound access).
• Fuel cost for driving those 10,000 miles.
• Mot (assume £50).
• Road Tax (VED)
• Depreciation how much value does your car lose a year.
Learning to drive costs
• 15 Lessons
• Theory Test
• Driving Test
• Provisional License
Use the internet to find the most accurate data you can. Keep a detailed record of the websites where you get information from. The links below should help.
Use macros to automate the input, navigation and output from your spreadsheet.
Use charts to make the information easier to understand.
What you need for this assignment (9 marks)
Produce a test plan to test your spreadsheet. Use screenshots to demonstrate that your spreadsheet model passes the tests and to show its functionality.
Here is a sample test plan
To get into mark band 3 you will need macros looking up petrol prices and printing off your two cost breakdowns on a single sheet.
To get top marks you will need accurate data, an online data query getting live petrol prices and you will be using vlookups to get your road tax prices. You will also need screenshots of your spreadsheet annotated to show how the functions and formulas work.
What you need for your final report
You need the comparison of the breakdown of the costs for the two cars
You need the charts that you produced to present these costs.
Resources - these site/documents should help.
Confused.com online car iinsurance quotes comparison site. There are loads of others available too.
Deparmtnet of transport Emssions database CO2 emissions figures by make and model.
What car depreciation calculator work out depreciation costs for cars.
Petrol prices online online petrol costs.
This document contains Road tax (VED) costs for 2009/10