Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Green Lawns provides yard service and maintenance for homes in the Mount Vernon, Ohio area. Gary Taylor manages the accounts for Green Lawns and wants

Green Lawns provides yard service and maintenance for homes in the Mount Vernon, Ohio area. Gary Taylor manages the accounts for Green Lawns and wants to use Excel to record monthly service calls made by the company. Gary provides you with the data of a list of service calls made in the month of August 2012.

The first column contains the customer's name. The second column is the last Service Date. The third column is the Base Fee charged for this customer (a setup fee). The fourth column is the number of Service Person Hours on the service call (for example, 2 people working 3 hours results in 6 Service Person Hours). The fifth column is the Hourly Rate. In the next column, you must compute the Total Cost (without tax) charged by Green Lawns to each customer.

The Total Cost (without tax) is computed as the Base Fee plus the Number of Service Person Hours multiplied by the Hourly Rate.

Enter an appropriate formula in the blue cells of Column F to compute the Total Cost (without tax) charged to each customer. Start by entering the formula in the first row, and then copy it down for all the Service Calls.

The total cost (without tax) for Brian Black, the 14th customer in the table (row 21), is:

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: J. David Spiceland, Wayne Thomas, Don Herrmann

2nd Edition

0078110823, 9780078110825

More Books

Students also viewed these General Management questions

Question

Identify the federal laws affecting equal employment opportunity.

Answered: 1 week ago

Question

Identify the elements of the dynamic HRM environment.

Answered: 1 week ago

Question

Discuss attempts at legislating ethics.

Answered: 1 week ago