Explore BrainMass

Explore BrainMass

    Relevant Cost Analysis - Outsourcing and Special Order

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Mayfield Software Case
    Mark Pelton works for Mayfield Software. As a vendor account manager (VAM), he is responsible for Mayfield's relationship with Nelson Electronics.
    Nelson Electronics manufactures an ergonomic keyboard. Mayfield Software designed the keyboard and markets it, but then outsourced the manufacturing to Nelson. In the past year, Mayfield purchased 83,400 keyboards at $55 per unit. Mayfield sells the keyboards for $64 wholesale and $79 retail.
    Mark is negotiating a new contract with Nelson. Mark is concerned about the low profit margin on the keyboards. He would like Nelson to lower its price. Nelson insists that it is only making a 10% profit and has provided cost information to support its assertion.
    Nelson Costs for Keyboards:
    Components $3,500,000
    Direct labor 300,000
    Depreciation of equipment 80,000
    Depreciation of building 60,000
    Supervisor salaries 80,000
    Advertising 50,000
    General and administrative 100,000
    Total costs $4,170,000
    Number of units 83,400
    Unit cost $50
    Markup at 10% is $55
    Mark has some additional information to help him in his negotiations. He knows that Nelson has some excess capacity. Production of the Mayfield keyboards does not mean that Nelson has to turn down business from other customers.
    Also, Mark knows that all costs other than components, direct labor, and supervisor salaries were allocated to the keyboard by Nelson on the basis of relative sales. Sales to Mayfield were $4,587,000, which is 12% of Nelson's total sales of $38,225,000. So, for example, Nelson allocated 12% of total advertising costs to the Mayfield keyboards, which means that the $50,000 in advertising cost is 12% of the total advertising cost of $416,667.
    In the coming year, Mayfield estimates that demand for its keyboard will be 100,000 units if the company maintains its current wholesale and retail prices.
    Mark would like Nelson to lower its price to $52 per keyboard. Analyze the information for Mark and prepare a briefing to assist his negotiations with Nelson.
    The Mayfield Software Deliverable - Fixed and Variable Costs
    First, separate the costs into fixed and variable.
    Then, use incremental analysis to look at the information from Nelson's perspective. How much money would Nelson make at $52 per keyboard if Mayfield orders 100,000 of them? Or, to put it another way, how much money will Nelson lose if it loses the Mayfield account?
    Mark is very busy. Create a cover memo that reminds him of the issues for his upcoming negotiations with Nelson. Then, present the current Nelson costs and profits. Finish with updated Nelson costs and profits assuming that the target price of $52 per keyboard is achieved.
    The deliverable is a Word document with a cover memo and then information on fixed costs, variable costs, and potential lost profit.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:07 am ad1c9bdddf

    Solution Preview

    Dear Student, this case requires what management accountants refer to as Incremental or Relevant information analysis. You must determine of all the information included in the case, which is relevant or irrelevant to the decision.
    Your First Step:
    Since cost behavior has an impact on cost relevance we will first decide which costs are variable and which are fixed. We will also calculate the Variable Costs per unit for use later.
    Total Variable Costs include:
    Components $3,500,000
    Direct labor 300,000

    Variable Costs per unit
    Components costs per unit = $3,500,000/83,400 = $41.97
    Direct labor cost per unit = $300,00/83,400 = $ 3.60
    Fixed Costs include:
    Depreciation of equipment 80,000
    Depreciation of building 60,000
    Supervisor salaries 80,000
    Advertising 50,000
    General and administrative 100,000
    Step Two - Analyze Nelson's Profits if it keeps the Account at the new price of $52 while selling 100,000 units.
    Income at New Selling price and increased sales units:
    Activity ...

    Solution Summary

    Here you are taught how to do analysis and make short-term financial decisions. You are taught the steps that you should take and how to use the information gathered to make the best possible decisions