Ask Experts Questions for FREE Help !
Ask
    dsmith60's Avatar
    dsmith60 Posts: 1, Reputation: 1
    New Member
     
    #1

    Oct 16, 2009, 12:58 AM
    Customer Margin: Can you tell me what's 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's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #2

    Oct 16, 2009, 09:04 PM

    You missed the custom design, but otherwise great work.
    payalmehta2984's Avatar
    payalmehta2984 Posts: 1, Reputation: 1
    New Member
     
    #3

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

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


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 sense 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...

I need some one to tell me what's wrong and if any thing is wrong [ 12 Answers ]

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?:(

Profit Margin calculation using Income from Operations [ 1 Answers ]

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...


View more questions Search