logo

Crowdly

Based on the final spreadsheet in Lab 1.1 Excel, Assessing Profitability of a M...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Based on the final spreadsheet in Lab 1.1 Excel, Assessing Profitability of a Mowing Business, what is the reason for the difference between Scenario 1 and Scenario 2?

The items are listed in the first column and the values for scenario 1 and scenario 2 are listed in columns 3 and 4. Monthly values are listed in column 2 from row 10. The row entries are as follows: Row 1: Base Scenario, scenario 1 per lawn, and scenario 2 per lawn. Row 4: Assumption: Total Lawns Serviced Each Month, 200, and 200. Row 6: Revenue, 50 dollars, and 50 dollars. Costs are listed from rows 10 through 19. Monthly values are shown in the second column. Row 10: Truck, 300, 1.50, and 1.50. Row 11: Mowers, 300, 1.50, and 1.50. Row 12: Other equipment, 100, 0.50, and 0.50. Row 13: Labor (Average 13 dollars per yard or 25 dollars per yard), blank, 13.00, and 25.00. Row 14: Maintenance, 100, 0.50, and 0.50. Row 15: Insurance, 300, 1.50, and 1.50. Row 16: Fuel, blank, 3.00, and 3.00. Row 17: Supplies, blank, 1.50, and 1.50. Row 18: Advertising, 50, 0.25, and 0.25. Row 19: Cost per lawn, 23.25, and 35.25. Row 21: Margin per lawn, 26.75, and 14.75. Row 23: Total monthly margin, 5350.00, and 2950.00.

More questions like this

Want instant access to all verified answers on moodle.polytechnic.bh?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!