Required information

Alternate Lab $1\mathrm{.}1$ Excel $-$ On Your Own: Assessing the Profitability of a Small Business

$[$The following information applies to the questions displayed below.$]$

Apply the same steps in Lab $1\mathrm{.}1$ to the Lab $1\mathrm{.}1$ Data.xlsx dataset with two modifications. The same scenarios exist as before, with labor costing either $\backslash (\backslash$$ $13\backslash )$ per lawn or $\backslash (\backslash$$ $25\backslash )$ per 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 $\backslash (\backslash$$ $50\backslash )$ to $\backslash (\backslash$$ $300\backslash )$ per month. Label these two new scenarios Scenario $3($with labor costing $\backslash (\backslash$$ $13\backslash )$ per lawn$)$ and Scenario $4($with labor costing $\backslash (\backslash$$ $25\backslash )$ per lawn$).$

Ask 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.

Master the Data

For this Alternate Lab you will use your completed file from Lab $1-1.$

Perform the Analysis

Alternate Labs $-$ On Your Own don't have step$-$by$-$step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab. Alternate Lab $1\mathrm{.}1$: $($Algo$)$ Excel: Assessment Questions

Answer the following questions based on the details provided.