Customer Margin: Can you tell me whats wrong with my calculation

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 Posts: 6,564, Reputation: 1474 Uber Member #2 Oct 16, 2009, 09:04 PM
You missed the custom design, but otherwise great work.
 payalmehta2984 Posts: 1, Reputation: 1 New Member #3 Feb 17, 2013, 04:57 PM
where does custom design go ?

Check out some similar questions!

What's wrong with me [ 14 Answers ]

What's wrong with me I have serious issues I have read peoples mind(not very often) I can understand what my dog and other animals want I know how most people interpret it but when it happens to me its more like a sence and mine are really random and are correct if can be proven (my dad is really...

How to correct wrong calculation [ 3 Answers ]

Ok, I have more than one case with child support, and I have no trouble with paying but it seems the more I try to keep them fair and correct the worse the problem gets, my first order was through a divorce and the amount was set. Well when the second order was being calculated we where sent to a...

My Partner And Me Have Been Having Sex For A Year Already But For 3 Months He Has Done It With Out A Condom And I Have Not Gotten Pregnant And We Really Want To Be Parents. What Is Wrong?:(

Hello, I am having trouble understanding how to calculate Profit margin when you are not provided Income from Operations. I understand that Profit Margins = Income from Operations / Sales When a company has sales of \$140,000, and Cost of goods Sold is \$83,000, Operating Expenses being...