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 March 21, 2019, 10:58 pm 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