Create a break-even analysis chart or table based off of
the information given.
Table 1.
|
Costs per month one 8000 line two lines 1300 |
Cars washed per hour |
Hours Op per month |
Cars washed per month |
Cost per car $4 |
Selling price of wash $7 |
Total profit sell price – cost per car = # – cost per month |
|
8000 |
17 |
250 |
4250 |
17000 |
29750 |
4750 |
|
8000 |
18 |
250 |
4500 |
18000 |
31500 |
5500 |
|
8000 |
19 |
250 |
4750 |
19000 |
33250 |
6250 |
|
8000 |
20 |
250 |
5000 |
20000 |
35000 |
7000 |
|
13000 |
18 |
250 |
4500 |
18000 |
31500 |
500 |
|
13000 |
20 |
250 |
5000 |
20000 |
35000 |
2000 |
|
13000 |
22 |
250 |
5500 |
22000 |
38500 |
3500 |
|
13000 |
24 |
250 |
6000 |
24000 |
42000 |
5000 |
Table 2.
|
Costs per month one line 8000 and two lines 13000 |
Cars washed per hour |
Hours Op per month |
Cars washed per month |
Cost per car $2 |
Selling price of wash $9 |
Total profit sell price – cost per car = # – cost per month |
|
8000 |
17 |
250 |
4250 |
8500 |
38250 |
21750 |
|
8000 |
18 |
250 |
4500 |
9000 |
40500 |
23500 |
|
8000 |
19 |
250 |
4750 |
9500 |
42750 |
25250 |
|
8000 |
20 |
250 |
5000 |
10000 |
45000 |
27000 |
|
13000 |
18 |
250 |
4500 |
9000 |
40500 |
18500 |
|
13000 |
20 |
250 |
5000 |
10000 |
45000 |
22000 |
|
13000 |
22 |
250 |
5500 |
11000 |
49500 |
25500 |
|
13000 |
24 |
250 |
6000 |
12000 |
54000 |
29000 |





