Larry's Lube Shop is a local oil change shop and they perform many oil & filter changes per week, and they are trying to estimate their costs at different operating levels. Complete the following sensitivity table of total and per unit costs using the costs provided. Calculate the "per unit" costs to 3 decimal places. Use the format in the Excel template file. The three levels of oil change sales: 200, 400, 600 Fixed costs per week = $3,000 Variable costs per oil change = $15.00
| Smokin' Joe's Sub Shop |
| Weekly - Oil & Filter Changes |
|
200 |
400 |
600 |
|
|
|
|
| Variable Cost |
|
|
|
| Fixed Cost |
|
|
|
| Total Cost |
|
|
|
|
|
|
|
| Variable cost / oil change |
|
|
|
| Fixed cost / oil change |
|
|
|
| Average Cost/ oil change |
|
|
|
|
|
|
|
|
|
|
|
| Variables |
|
|
| Fixed Cost |
$3,000 |
|
|
| Variable Cost |
$15.00 |
|
|