Ask Experts Questions for FREE Help !
Ask
    moonkhan209's Avatar
    moonkhan209 Posts: 42, Reputation: 1
    Junior Member
     
    #1

    Dec 3, 2009, 09:50 PM
    Utilization of a Constrained Resource
    The Walton Toy Company manufactures a line of dolls and a doll dress sewing kit. Demand for the dolls is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data:


    Product
    Demand Next year (units)
    Selling Price per Unit
    Direct Materials
    Direct Labor

    Debbie
    25,000
    $
    35
    $
    3.70
    $
    3.60

    Trish
    33,000
    $
    23
    $
    1.80
    $
    2.40

    Sarah
    37,000
    $
    22
    $
    4.10
    $
    7.20

    Mike
    51,000
    $
    20
    $
    2.20
    $
    6.60

    Sewing kit
    510,000
    $
    13
    $
    1.80
    $
    2.40


    --------------------------------------------------------------------------------

    The following additional information is available:


    a.
    The company's plant has a capacity of 152,550 direct labor-hours per year on a single-shift basis. The company's present employees and equipment can produce all five products.

    b.
    The direct labor rate of $12 per hour is expected to remain unchanged during the coming year.

    c.
    Fixed costs total $306,000 per year. Variable overhead costs are $3 per direct labor-hour.

    d.
    All of the company's nonmanufacturing costs are fixed.

    e.
    The company's finished goods inventory is negligible and can be ignored.


    Requirement 1:

    Determine the contribution margin per direct labor-hour expended on each product. Just give me an idea how to do it. PLEASE I AM VERY :confused::confused::confused:
    rehmanvohra's Avatar
    rehmanvohra Posts: 739, Reputation: 27
    Senior Member
     
    #2

    Dec 3, 2009, 10:39 PM

    I am sure you know that contribution margin is sales minus all variable costs. To calculate contribution per labor hour you need first to calculate the labor hour required for each product by dividing the labor cost per unit by the labor rate per hour. Now you can divide the contribution per unit by the labor hour required per unit of each product.
    moonkhan209's Avatar
    moonkhan209 Posts: 42, Reputation: 1
    Junior Member
     
    #3

    Dec 3, 2009, 11:33 PM
    Quote Originally Posted by rehmanvohra View Post
    I am sure you know that contribution margin is sales minus all variable costs. To calculate contribution per labor hour you need first to calculate the labor hour required for each product by dividing the labor cost per unit by the labor rate per hour. Now you can divide the contribution per unit by the labor hour required per unit of each product.
    I am still confused, Yes I subtract the Direct material: $3.70, Direct labor: $3.60, and Variable overhead: $3 from selling price per unit:$35. And I left with 24.7. As you said I divided $3.60 with $12 which is the rate of labor hour. I got 0.3, then I further divided 24.7 with 0.3 = 82.33 but my answer is still wrong. Can you explain by example. Thanks for your help:confused::confused:
    rehmanvohra's Avatar
    rehmanvohra Posts: 739, Reputation: 27
    Senior Member
     
    #4

    Dec 4, 2009, 10:12 AM

    You are on the right track. Please repeat the same process for all the products. Having done that you need to rank the products according to their respective contribution per labor hour. The highest will be produced first followed by the others in their rank order. Complete this process for further instructions.
    moonkhan209's Avatar
    moonkhan209 Posts: 42, Reputation: 1
    Junior Member
     
    #5

    Dec 5, 2009, 12:58 AM
    [:confused:

    But I don't know what mistake I am making for which I am still getting wrong answer?
    rehmanvohra's Avatar
    rehmanvohra Posts: 739, Reputation: 27
    Senior Member
     
    #6

    Dec 5, 2009, 05:44 AM

    I think the mistake lies in calculating variable overheads.

    Sales price $35
    Variable costs
    Direct Material 3.70
    Direct Labor 3.60
    Variable Overheads 0.90 (0.3 hrs x $3 per hour)
    Total Variable costs 8.20
    Contribution margin 26.80
    Labor hour per unit 0.3
    Contribution per labor hour 89.33
    moonkhan209's Avatar
    moonkhan209 Posts: 42, Reputation: 1
    Junior Member
     
    #7

    Dec 5, 2009, 04:00 PM
    Can I ask you one more favor, How can we calculate the total labor hours which are required which are required to produce the estimated units next year. The total estimated units are 656,000 and I divided it by the total CM Per hour which is 253.52 which is 2,587,567 total hours, but this is not right answer and my sources don't give any detail about how to calculate the total labor hours. Will appreciete your help. Thanks:confused:
    rehmanvohra's Avatar
    rehmanvohra Posts: 739, Reputation: 27
    Senior Member
     
    #8

    Dec 6, 2009, 05:06 AM

    Have you prepared the priority list I had mentioned? The next step is as follows:

    Total hours available 152,550
    Hours required for production of 1st Rank product
    Balance hours available for other products
    Hours required for production of 2nd Rank product
    Balance hours available for other products
    Hours required for production of 3rd Rank product
    ... and so on until you reach the least number of hours available.
    Calculate the units that can be produced for the next rank product by dividing the hours with the per unit labor hour required

    I just do not understand how you got to the figure of 253.52. This is of no use. You have to calculate CM pr labor hour for each product. You are not required to add them up.
    moonkhan209's Avatar
    moonkhan209 Posts: 42, Reputation: 1
    Junior Member
     
    #9

    Dec 6, 2009, 10:08 AM
    Thank you very much for your help, I figured it out

    Quote Originally Posted by rehmanvohra View Post
    have you prepared the priority list i had mentioned? The next step is as follows:

    Total hours available 152,550
    hours required for production of 1st rank product
    balance hours available for other products
    hours required for production of 2nd rank product
    balance hours available for other products
    hours required for production of 3rd rank product
    ..... And so on until you reach the least number of hours available.
    Calculate the units that can be produced for the next rank product by dividing the hours with the per unit labor hour required

    i just do not understand how you got to the figure of 253.52. This is of no use. You have to calculate cm pr labor hour for each product. You are not required to add them up.
    CA's Avatar
    CA Posts: 1, Reputation: 1
    New Member
     
    #10

    Dec 11, 2009, 11:24 PM

    For the Question above I would like to know - What is the highest price, in terms of a rate per hour, that Walton Toy Company would be willing to pay for additional capacity (that is, for added direct labor time)?
    rehmanvohra's Avatar
    rehmanvohra Posts: 739, Reputation: 27
    Senior Member
     
    #11

    Dec 12, 2009, 12:35 AM
    Quote Originally Posted by CA View Post
    For the Question above I would like to know - What is the highest price, in terms of a rate per hour, that Walton Toy Company would be willing to pay for additional capacity (that is, for added direct labor time)?
    I think your question appears to be out of place. If you have any specific problem please post your thread separately along with your own solution for guidance. The question deals with the limitation of the availability of labor and hence needs to maximize profits by utilization of the available resources.
    Johannla's Avatar
    Johannla Posts: 1, Reputation: 1
    New Member
     
    #12

    Apr 30, 2012, 01:00 AM
    Thanks a lot. This is very helpful..

    Walter,

Not your question? Ask your question View similar questions

 

Add your answer here.


Check out some similar questions!

Human resource [ 4 Answers ]

My manager is salaried. He had one day off to take his wife for a surgery. After that, two days, he came to work for half day. I paid him full for the two half days. But not paying his whole day off. He is objected not to be paid for the whole day off due to his salaried and he worked...

What is a non financial resource? [ 1 Answers ]

What is a non financial resource?

Utilization Issue [ 1 Answers ]

If I have a factory manufacturing widgets and the goal is to operate the factory at 64% (this allows for 20% growth and 16% contingency), if I have take 9% of the factory down for maintenance, does this 9% come out of growth, contingency, or off the top? For example, operating at 100% I produce...

Disc space utilization [ 4 Answers ]

Hi, I would like to monitor users about their server resource comsumption and utilization, are there any ways I can alert them? (especially what percentage of disc space they have left in the event of a minor or major disaster or data loss)


View more questions Search