$!$

Required Information

Lab $1\mathrm{.}1$ Excel: Assessing Profitability of a Mowing Business

$[$The following information applies to the questions displayed below.$]$

Keywords: Practicing Excel SkIIIs, Profitability

Decislon$-$Making Context: A friend is retiring from a lawn$-$mowing business and Is asking if you would like to take over his business. He is not trying to make money on the sale of the business. Instead, he is concerned with $(1)$ taking care of his existing customers and $(2)$ having someone take over existing contracts on equipment he has purchased.

He currently mows $50$ lawns each week and charges $$\frac{50}{?}$ lawn. He mows lawns himself and has two people working for him. He supplies all equipment

Truck: He has one truck that he purchased. The amount he still owes on the truck is $$20,000,$ and the payment is $$\frac{300}{?}$ month.

Mowers: He has three new riding mowers. He owes $$3,000$ on each and he pays $$\frac{100}{m}$onth for each one.

Other Equipment: All other equipment is paid for and In good working order, and he is willing to sell all of it to you for $$2,000($and you think it will last $20$ mowing months$).$ He estimates it will cost $$100/$month for maintenance of the truck, mowers, and other equipment.

You have a degree in landscape architecture and design, and you have been the groundskeeper at a golf course for the last five years. You belleve with your knowledge and entrepreneurlal Ideas you could Improve greatly on his business model. In summary, your costs are

Truck payment: $$\frac{300}{?}$ month

Mowers: $$300/$month

Other equipment $$2,000$ to purchase now $($will last approximately $20$ months$)$

Chlef mower makes $$15/$hour$,$ staff worker makes $$10/$hour$.$ Each staff worker can mow $1$ lawn$/$hour$.($Average $$\frac{13}{?}$ lawn In Scenario $1$ or average $$25$ per lawn In Scenario $2.)$

$.$ Malntenance: $$\frac{100}{?}$ month

Insurance: $$\frac{300}{?}$ month

Fuel: $$3/$gallon; $1$ gallon Is sufficient to mow one lawn.

Supplies $($trimmer line, etc.$)$: $$1\mathrm{.}50/$lawn

Advertising: $$\frac{50}{?}$ month, but if you do $$\frac{300}{?}$ month advertising, you can potentially triple your volume of contracts.

Owner $($you$)$ will spend time doing quality control, marketing, and planning for the future.