00:01
Hello, so let's solve this problem that we're given here.
00:03
We have some given information.
00:06
The initial cost difference, car a costs $500 more than car b.
00:09
We have the fuel consumption of both cars, 0 .04 and 0 .06.
00:14
The fuel cost is $8 .70.
00:16
The lifetime of both cars is $8, and the range of use per year is from 0 to 4 ,000 miles.
00:22
There's an increment of 200 miles per range.
00:27
So, or excuse me, per year.
00:29
So first of all, we need to look for the break -even point.
00:33
So at the break -even point, the total cost for both cars is the same.
00:36
This includes the initial cost difference and the fuel cost over eight years.
00:40
So let's look at the fuel cost per mile.
00:47
Car a, so we'll just write a and b for both cars.
00:51
Car a is 0 .04 times 1 .7, which is equal to $0 .068 dollars per mile.
00:59
So actually, we'll just write it like this, dollars per mile.
01:04
And car b is 0 .06 times 1 .7 is equal to $0 .102 dollars per mile.
01:13
Now we can look at the annual fuel cost.
01:16
We can move this up here.
01:24
Car a again and b, we have 0 .068 times the miles per year.
01:34
And then 0 .102 times the miles per year, and then the fuel cost over eight years.
01:45
So what i mean miles per year is that there is an increment of 200 miles, so there's 20 different calculations for the annual fuel cost, because we're going to start at zero, and we're moving up to 4 ,000.
01:56
At the end of all the calculations that i'll break down, we'll write a graph with all the calculations that we have, and you can plug that in exactly.
02:05
Same chart into excel and just and then put it into an xy scatter chart with some smooth lines for cart a and b...