Question

Creative Canopies (CC) is a manufacturer of flexible canopies for athletic facilities. CC has contracts with 3 universities to install and maintain the canopies on their baseball field bleachers. The fields are essentially identical, so CC management has assumed that all costs would be equal for each customer. However, after missing budget predictions this year, the CFO decided to use ABC costing principles to evaluate the profitability of their customers. The cost accounting team has put together the following estimates regarding specific cost activities related to maintenance of the canopies:

Support Activity Driver Cost per Driver Unit
Major refinishes: Hours on jobs $55
Minor touchups: Number of visits $400
Communication: Number of calls $25
The universities are all out-of-state but relatively equidistant from the manufacturing plant, so per-trip travel costs are not considered to be significantly different. However, each university has different expectations regarding maintenance of the canopy, and CC has collected the following data for each customer:
University Hours (major) Visits (minor Calls
USD 100 7 12
USC 90 5 15
UCLA 120 6 9
(Assume that each of the three customers produces gross profits of $10,000).
Which customer is the least profitable?
A. USD
B. UCLA
C. USC

Answer 1

Creative Canopies (CC)

With gross profits of $10,000, the least profitable is:

B. UCLA

Step-by-step explanation:

a) Maintenance Costs of Canopies:

Support Activity Driver Cost per Driver Unit

Major refinishes: Hours on jobs $55

Minor touchups: Number of visits $400

Communication: Number of calls $25

b) Customer Data:

University Hours major Visits minor Calls=

USD 100 7 12

USC 90 5 15

UCLA 120 6 9

c) Calculation of the Cost of Canopy Maintenance for each customer:

University Hours Major Minor Major Minor Commun- Total

Visits Calls Refinishes Touchups ication

USD 100 7 12 $5,500 $2,800 $300 $8,600

USC 90 5 15 $4,950 $2,000 $375 $7,325

UCLA 120 6 9 $6,600 $2,400 $225 $9,225

d) Calculation of net income from each customer:

University Gross Profit Maintenance Cost Net Income

USD $10,000 $8,600 $1,600

USC $10,000 $7,325 $2,675

UCLA $10,000 $9,225 $775