QUESTION IMAGE
Question
business expenses
small car - detailing business
a small car detailing business has the following details:
- the cost to detail each car is $15.00
- the fixed costs are $50.00 per month
- the total expense function is given by $e(q)=50 + 15q$ where $q$ is the number of cars detailed and $e(q)$ is the total expense.
the business owner wants to create a spreadsheet to calculate and track monthly expenses based on the number of cars detailed. the spreadsheet has this configuration
| a | b |
|---|---|
| 2 | 0 |
| 3 | 1 |
| 4 | 2 |
| 5 | 3 |
| 6 | 4 |
| 7 | 5 |
| 8 | 6 |
| 9 | 7 |
| 10 | 8 |
to fill out the total expenses column, the business owner needs to input the formula for calculating total expenses in each cell from b2 to b10.
which formula should be entered in cell b2 and dragged down to cell b10 to correctly calculate the total expenses?
$=50 + 15*a2$
$=50*a2 + 15*a1$
$=50*a2+15$
$=50 + 15*a1$
Step1: Identify the cost - structure formula
The total expense formula is $E(q)=50 + 15q$, where $q$ is the number of cars detailed. In the spreadsheet, the number of cars detailed is in column A. For row 2, the number of cars detailed is in cell A2.
Step2: Substitute into the formula
We substitute the value in cell A2 for $q$ in the total - expense formula. So the formula in cell B2 should be $=50+15*A2$.
Snap & solve any problem in the app
Get step-by-step solutions on Sovi AI
Photo-based solutions with guided steps
Explore more problems and detailed explanations
$=50 + 15*A2$