What are the formulas that go in cells B43, B44, B49 to find the expected busine

Question

What are the formulas that go in cells B43, B44, B49 to find the expected business for rough yard work, lawn mowing and edging, and fall leaf clearing.

1 PHILLY LANDSCAPING 2017 3 CONSTANTS 4 Prices 5 Rough Yard Work perquare Foot 6 Gutterlig per Linear Foot 7 Power Washing per Square Foot 8 Lawn Mowing and Edging per Square Foot 9 Driveway Seal Coating per Square Foot 10Fl Leaf Clearing per Square Foot 11 Snow Removal per Square Foot 12 13 Costs 14 Average Cost of Labor and Materials 15 16 Customer Base 17 Customers 18 Average Lawn Surface (Sq Ft) 19 Average Power Washing Surface (Sq Ft) 20 Average Gutter Length (Linear Ft) 21 Average Snow Remoal Surface Sq Ft) 22 Average Driveway Seal Coating Surface(Sq Ft) 23 Average Fall Leaf Clearing Surface ISq Ft 24 25 Economic and Environmental Factors 26 Tax Rate 0.003 0.075 0.050 0.001 0.100 0.003 0.025 0.30 850 43,560 5,000 150 2,500 2,500 43,560 25%

Explanation / Answer

Here exoected bussiness means toal sq ft of all customers. This can be observed by seeing that B45=B17*B19 and B46=B17*B20

Similarly, B44=B17*B18 and B49=B17*B23

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.