excel
[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:
<ol>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.</ol>
Data: Lab 1.1 Data.xlsx
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.
Upload one Word or PDF document containing all of your screenshots for this Lab using the button below.
Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format.
<ol>Take a screenshot of the completed spreadsheet, paste it into a Word document named “Alt Lab 1.1 Excel Submission.docx”, and label the screenshot Submission 1.Take a screenshot of the scatterplot showing labor cost per lawn and monthly margin, paste it into the same Word document, and label the screenshot Submission 2.</ol>
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:
<ol>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.</ol>
Data: Lab 1.1 Data.xlsx
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 following questions based on the details computed.
Note: Round the margin and cost per lawn to 2 decimal places.
<span class="replace-with-component"></span>
