Saved

Help

Lab Insight: Apply the same steps in Lab $1\mathrm{.}1$ to the Lab $1\mathrm{.}1$ Data.xIsx 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:

Assess whether this mowing business will be profitable if you mow $350$ lawns per month.

Show a visualization of the change in monthly margin based on a range of labor costs per lawn.

Data: Lab $1\mathrm{.}1$ Data.xIsx

Analyze the Data: Alternate Labs 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.

Answer the foll wing questions based on the details computed.

Note: Round the margin and cost per lawn to $2$ decimal places.

$\backslash$table$[[1.$ What is the total monthly margin for scenario $4?],[2.$ In scenario $3$ what is the expected number of lawns that will be mowed per week $($assuming $4$ weeks in a month$)?],[3.$ What is the margin per lawn for scenario $3?],[4.$ What is the cost per lawn in scenario $3$ of the other equipment?$],[5.$ What would be the total monthly margin of scenario $4$ if the number of lawns serviced were $250$ instead of $350?]]$