Required Information Lab 1.1 Alternate: Assessing Profitability of a Mowing Business
[The following information applies to the questions displayed below.]
Lab Insight: Apply the same steps in Lab 1.1 to the Lab 1.1 Data.xlsx data set with two modifications. The same scenarios exist as before, with labor costing either $13/lawn or $25/lawn.
Assume that your mowing business will mow 350 lawns per month rather than 200 lawns per month. Also assume that the cost for advertising increases from $50 to $300 per month. Label these two new scenarios Scenario 3 (with labor costing $13/lawn) and Scenario 4 (with labor costing $25/lawn).
Specify the Question: What is the profit on each lawn if the mowing business mows 350 lawns per month? What is the business's total profit per month?
Required:
1. Assess whether this mowing business will be profitable if you mow 350 lawns per month.
2. Show a visualization of the change in monthly margin based on a range of labor costs per lawn.
Data: Lab 1.1 Data.xlsx
Analyze the Data: Refer to lab 1.1 in your text for additional instructions and steps.
Lab 1.1 Alternate: Analysis Questions
Note: Submit your answers for the following Analysis Questions in the text entry field below.
1. How did you get a monthly truck payment per lawn of $0.86?
2. How did you get a monthly maintenance charge per lawn of $0.29?
3. Given these changed assumptions, does it make sense to leave your job, in which you earn $4,000/month? Given the results of the analysis, what do you choose and why? Is there anything else that you should consider? Explain.