Required information

$[$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 $$13$ per lawn or $$25$ 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 $$50$ to $$300$ per month. Label

these two new scenarios Scenario $3($with labor costing $$13$ per lawn$)$ and Scenario $4($with labor costing $$25$ 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

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.

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.

$1.$ What is the cost per lawn in scenario $4$ of the other equipment? $($round to two digits$)$

; $2.$ What is the cost per lawn in scenario $3$ of the monthly mower payment $($round to two digits$)?$

: $3.$ What is the cost per lawn in scenario $3$ of the monthly truck payment? $($round to two digits$)$

$4.$ What is the cost per lawn in scenario $3$ of the other equipment? $($round to two digits$)$

: $5.$ What is the margin per lawn for scenario $4?($round to two digits$)$