Reference no: EM131142031
Attach the answer as an Excel spreadsheet, no other form.
C-V-P and BE analysis, multiple product
NCP, Inc. is a manufacturer and seller of small, inexpensive plastic housings and connectors used by a variety of small engine and controls device manufacturers. The CFO of NCP is concerned about the profitability for one segment of their product line; in particular three of NCP's most purchased plastic housings. These products are sold in a very competitive market, so the company has strong pricing
pressure on the product lines.
The CFO is interested in a break-even and segment analysis for these three products:
Additional data related to these housings are as follows:
• Total fixed expenses are $400,000 per year
- $240,000 of these fixed expenses are common fixed expenses consisting of administrative salaries, rent, and depreciation
• The company runs a lean manufacturing system so there is no beginning or ending inventories, nor work-in-process inventory.
The CFO has asked for the following:
1. A prepared contribution margin statement for the overall product line comprised of the three products:
a. What is the break-even point is sales dollars?
b. What is the overall contribution 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 product at the overall break-even point?
4. An analysis of the fixed expenses indicates that of the $400,000, $20,000 can be avoided if product VX1 is 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 each of the products:
b. What is the impact on net operating income under each of the three options:
i. dropping VX1
ii. dropping MX2
iii. dropping VX3
5. The CFO is requesting a memo (minimum of 300, maximum 500 words) on your analysis of the current margin and profitability of these three products. In your memo include your recommendation on the three products comprising this product line based on your analysis. Recommendations may include pricing, cost, and sales stimulus activities. Include analysis data where appropriate to support your recommendation to the CFO.
What is the value of the option to wait if the applicable
: If you commence a project today, you will have initial costs of $16,000 and annual cash inflows of $9,900 for two years. If you wait until next year to start this project, your initial costs will increase to $17,500 and the annual cash inflow for eac..
|
Determine the total line inductance
: Determine the total line inductance in mH/m - Given the operating frequency to be 60 Hz, find the total inductive reactance of the line in Ω/km and in Ω/mi.
|
How will you know if technology improved student learning
: Standards and objectives for each activity, Basic steps of the activity, Benefits and challenges for the technology activity and Explanation of how the technology is integrated in the curriculu.
|
Find the gmr of a stranded conductor
: Find the GMR of a stranded conductor consisting of six outer strands surrounding and touching one central strand, all strands having the same radius r
|
What is the break-even point is sales dollars
: What is the break-even point is sales dollars? - What is the overall contribution margin percentage for the product line?
|
Determine the inductance
: Determine the inductance in H/m and the inductive reactance in Ω/km.
|
What is the value of the equity in this firm
: The company has a pure discount loan outstanding that matures in one year. The face value of the loan is $800,000. The risk-free rate of return is 5 percent and the inflation rate is 3.5 percent. What is the value of the equity in this firm?
|
Calculate national saving at each level of national income
: calculate national saving at each level of national income. What is the marginal propensity to consume in Consumerland? What is the marginal propensity to save? If national income rose to $2,000, what do you predict consumption and saving would be..
|
State that every that every flip of the coin is independent
: This statement should state that every that every flip of the coin is independent and for each flip for unbiased coin head and tail are unequal likely.
|