Reference no: EM131136807
Case #1 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
C-V-P and BE analysis, multipleproduct
|
VX1
|
MX2
|
NX3
|
|
|
Sales volume (units)
|
$100,000
|
$200,000
|
$400,000
|
|
|
Unit selling price
|
$1.65
|
$1.50
|
$0.85
|
|
|
$VC unit
|
$1.25
|
$0.70
|
$0.25
|
|
|
|
|
|
|
NCP, Inc. is a manufacturer andseller of small, inexpensive plastic housings and connectors used by a varietyof small engine and controls device manufacturers. The CFO of NCP is concernedabout the profitability for one segment of their product line; in particularthree of NCP's most purchased plastic housings. These products are sold in avery competitive market, so the company has strong pricing pressure on theproduct lines.
The CFO is interested in abreak-even and segment analysis for these three products:
Additional data related tothese housings are as follows:
- Total fixed expenses are$400,000 per year
o $240,000 of these fixed expenses are common fixedexpenses consisting of administrative salaries, rent, and depreciation
- The company runs a leanmanufacturing system so there is no beginning or ending inventories, norwork-in-process inventory.
The CFO has asked for thefollowing:
1. A prepared contribution marginstatement for the overall product line comprised of the three products:
a.What is the break-even point is sales dollars?
b. What is the overallcontribution margin percentage for the product line?
2.What is the contribution margin (in $ and %) for each of the three products?
3.Given the current sales mix, what is the sales volume in units for each productat the overall break-even point?
4. An analysis of the fixedexpenses indicates that of the $400,000, $20,000 can be avoided if product VX1is dropped, $80,000 if MX2 is dropped, and $60,000 if NX3 is dropped.
a.Prepare a segment CM analysis statement showing the full product line and eachof the products:
b. What is the impact on netoperating income under each of the three options:
i.dropping VX1
ii. dropping MX2
Attached is the case file
- will need one Excel file to this assignment
- Correct accounting formats for statements/budgets are expected
- Formatting to include $ and % signs where indicated
- All statements and calculations to utlize Excel formula functions
- Format on printable pages, either portrait or landscape orientation
- Qualitative analysis, supported by your numerical analysis, is to be included in the spreadsheet.
- Prepare written analysis in Word
|
What is the purpose of the performance appraisal
: Describe strategy based performance management. How does it link to overall organization strategy and what are the phases (with descriptions of what is included in each phase)? What is the purpose of the performance appraisal? Describe why it is or i..
|
|
What is the ethical dilemma here
: Using the steps outlined in the decision-making models in your readings, select one ethical decision-making model and use the model to analyze the case provided.
|
|
Understanding of forward-looking metrics
: Based upon your understanding of forward-looking metrics, create a new forward-looking metric that is different from the ones identified in the chapter. Explain how it is forward-looking and how it should be used for strategy purposes.
|
|
Describe their marketing strategy and rear-view metrics
: Identify an organization that you believe is using rear-view metrics. Describe their marketing strategy and the rear-view metrics they are using to assess their strategy. Then explain how their use of these metrics is influencing (positively and/or n..
|
|
Inexpensive plastic housings and connectors
: NCP, Inc. is a manufacturer andseller of small, inexpensive plastic housings and connectors used by a varietyof small engine and controls device manufacturers. The CFO of NCP is concernedabout the profitability for one segment of their product lin..
|
|
Prepare a tax research memorandum
: Prepare a tax research memorandum to answer the questions raised by your client. State any assumptions you make. Is this settlement payment taxable for federal income tax purposes
|
|
Determine the impact that financing health insurance
: From the e-Activity, compare the key components inherent in the national health insurance financing systems of two (2) different countries.Determine the impact that financing health insurance has on the economy of each country that you selected. ..
|
|
Describe the tension found in galatian between law and grace
: Describe the tension found in Galatians between Law and Grace. What has an understanding of these two competing, mutually exclusive dependencies to do with ministering in the present culture?
|
|
Social services department
: You are the new manager of the Social Services Department of a small, 18-bed rural hospital within the Bright Road Health Care System. As a member of the ethics committee for the hospital, you have been asked by the CEO and CFO to contribute to an in..
|