In this exercise, you are going to take the answers you derived for DB 13.2 and use this information to cost out the work done for individual customers during the year. You will need the following worksheets:

• Database Problem 13.2 Solution

• Database Problem 13.3 Template

First, fill in all of the activity costs from your DB 13.2 solution worksheet onto your DB 13.3 Template worksheet. Now attach costs to customers and total these costs for each customer. Finally, calculate the profitability for each customer. Note that all service is under warranty for the first year of ownership, whether the car is new or used, so there is no service revenue to be reported.

REQUIRED:

a. Turn in your completed worksheet.

b. Which customer is the most profitable in absolute terms?

c. Which customer is most profitable in percentage terms?