Question
Required information [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. 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. 1. 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. 2. 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. AutoSave OFF Home Insert Draw Page Layout Calibri (Body) v Paste BI UV L17 : x ✓ fx A 1 Base Scenario 4 Assumption: Total Lawns Serviced Each Month Revenue 7 8 Costs 9 10 11 12 15 16 18 21 24 25 27 Lab_1_1_Data Formulas Data Review View Tell me 11 ν Α' Α' Wrap Text General A v Merge & Center $ % 588 Conditional Form Formatting as Ta B Scenario 1 Per Lawn 0 Scenario 2 Per Lawn E F ' J K Enhanced Scenario Monthly
Question image 1