Log in

View Full Version : Customer Margin: Can you tell me what's wrong with my calculation


dsmith60
Oct 16, 2009, 12:58 AM
Use activity-based costing system with the following activity cost pools and activity rates:


*Activity Cost Pool* - *Activity Rate*

Supporting manufacturing - $20 per direct labor-hour

Order processing - $196 per order

Custom designing - $269 per custom design

Customer service - $436 per customer

Management would like an analysis of the profitability of a particular customer, Eagle Wings, which has ordered the following products over the last 12 months:

Standard - Custom

Number of gliders - 14 - 2

Number of orders - 2 - 2

Number of custom designs - 0 - 2

Direct labor-hours per glider - 29.5 - 33

Selling price per glider - $1,650 - $2,400

Direct materials cost per glider - $442 - $584


The company's direct labor rate is $18 per hour.

Customer Margin(?):

THESE ARE MY CALCULATIONS

Sales:
- Standard = 14 x 1650 = 23100
- Custom = 2 x 2400 = 4800
- Total= 27900

FOR STANDARD MODELS


Direct Labor: 14 x 29.5 x 18= 7434
Direct Material: 442 x 14 = 6188
Order Processing: 196 x 2 = 392
Supporting Manufacturing: 20 x 29.5 x 14 = 8260

Total: (7434+6188+392+8260) = 22274

FOR Custom MODELS

Direct Labor: 2 x 33 x 18 = 1188
Direct Material: 584 x 2 = 1168
Order Processing: 196 x 2 = 392
Supporting Manufacturing: 20 x 33 x 2 = 1320

Total: (1188+1168+392+1320) = 4068

Customer Margin: 27900 - (22274+4068) - (436)
27900 - 26342 - 436 = 1122

morgaine300
Oct 16, 2009, 09:04 PM
You missed the custom design, but otherwise great work.

payalmehta2984
Feb 17, 2013, 05:57 PM
Where does custom design go ?