Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 402 Weeks Ago, 2 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Accounting Posted 04 Aug 2017 My Price 14.00

BE analysis, multipleproduct

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

  1. will need one Excel file to this assignment
  2. Correct accounting formats for statements/budgets are expected
  3. Formatting to include $ and % signs where indicated
  4. All statements and calculations to utlize Excel formula functions
  5. Format on printable pages, either portrait or landscape orientation
  6. Qualitative analysis, supported by your numerical analysis, is to be included in the spreadsheet.
  7. Prepare written analysis in Word

Answers

Maurice Tutor
(5)
Status NEW Posted 04 Aug 2017 11:08 PM My Price 14.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll

Not Rated(0)