Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started