Which interval of production volume does breakeven occur

Assignment Help Financial Management
Reference no: EM131322280

A company asked one of their analysis team to analyze and create models that help decide whether they should manufacture a particular product or outsource its production. The different components are given below.

Fixed Cost, FC = $25,000

Material Cost per Unit, MC = $2.15

Labor Cost per Unit, LC = $2.00

Outsourcing Cost per Unit, O = $4.50

A: Build a spreadsheet model and then construct a one-way data table with production volume as the column input and savings due to outsourcing as the output. Breakeven occurs when savings equal zero. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur?

B: Using the appropriate Excel tool, find the exact breakeven point.

Reference no: EM131322280

Questions Cloud

What is your value for the current share price now : Now suppose the company in (a) actually pays its annual dividend in equal quarterly installments; thus, the company has just paid a dividend of $0.90 per share, as it has for the previous three quarters. What is your value for the current share price..
Contest sponsors have to deposit in the escrow account : The super prize in a contest is $10 million. This prize will be paid out in equal yearly payments over the next 20 years. If the prize money is guaranteed by AAA bonds yielding 3%and is placed into an escrow account when the contest is announced 1 ye..
What is the present value of the annuity : What is the present value of the following annuity? $3,365 every half year at the beginning of the period for the next 12 years, discounted back to the present at 3.79 percent per year, compounded semiannually.
What is the value of the fund today : Your brother who is 6 years old, just received a trust fund that will be worth $22,000 when he is 21 years old. If the fund earns 0.11 interest compound annually. What is the value of the fund today?
Which interval of production volume does breakeven occur : A company asked one of their analysis team to analyze and create models that help decide whether they should manufacture a particular product or outsource its production. Build a spreadsheet model and then construct a one-way data table with producti..
Project for ultimate recreational tennis racket : You are evaluating a project for The Ultimate recreational tennis racket, guaranteed to correct that wimpy backhand. You estimate the sales price of The Ultimate to be $350 per unit and sales volume to be 1,000 units in year 1; 1,250 units in year 2;..
In order to develop an accurate static budget : In order to develop an accurate static budget you know you need to get some facts. You ask around to see what kind of information you can gather. This is what you find out: The center pays rent of $12,000 per month. The center has a number of full-ti..
Nonconstant growth-what is the value of stock today : Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it does not pay dividends. However, investors expect Computech to begin paying dividends, beginning with a dividend of $0.50 coming 3 years from toda..
Corporate value model : Assume that today is December 31, 2016, and that the following information applies to Abner Airlines: After-tax operating income [EBIT(1 - T)] for 2017 is expected to be $650 million. Using the corporate valuation model approach, what should be the c..

Reviews

Write a Review

Financial Management Questions & Answers

  Determine to what extent each item is included in her agi

Marcy Tucker received the following items this year. Determine to what extent each item is included in her AGI. a. A $25,000 cash gift from her parents. b. A $500 cash award from the local Chamber of Commerce for her winning entry in a contest to nam..

  Increase firms financial leverage

Which of the following would increase a firms financial leverage?

  Importance of communication in negotiation process

We have discussed the importance of communication in the negotiation process. We reviewed the concept of communication as a sender encoding a message to a receiver who decodes the message and then responds back to the sender

  Calculate the future value of the single cash flow

Calculate the future value of the single cash flow deposited today at the end of the deposit period if the interest is compounded annually at the rate specified.

  Defined-benefit plan or defined-contribution pension plan

As an employee, would you prefer to participate in a defined-benefit plan or a defined-contribution pension plan? Explain your answer, being explicit in considering the advantages and disadvantages of each plan, and which are most important to you.

  About the estate tax exemption

Abe and Jan are well to do and are concerned that the estate tax exemption of $10,500,000 (combined) will not be sufficient to avoid estate taxes. The have 3 married children and 7 grandchildren. They would like to give about $300,000 per year to the..

  Minimum monthly payment of the outstanding balance

How long will it take Kate to pay for her furniture set if she chooses to pay only the minimum monthly payment of 2% of the outstanding balance? Her furniture set cost $3,750 financed at 19 3/4% annual interest.

  Arrearages are unpaid preferred dividends

A convertible bond gives the bondholder the right to exchange their bonds for a preset number of shares of stock. A warrant is a security that is often sold with bonds but that can be detached (bought and sold separately) from the bond. Arrearages ar..

  Project costs of capital for new ventures with betas

CAPM and Cost of Capital. Suppose the Treasury bill rate is 4% and the market risk premium is 7%. (LO12-3) a. What are the project costs of capital for new ventures with betas of .75 and 1.75? b. Which of the following capital investments have positi..

  How much money will be in account at end of time period

You are going to save money for your son's education. You have decided to place $2,246 every half year at the end of the period into a savings account earning 10.34 percent per year, compounded semi-annually for the next 14 years. How much money will..

  With the growing popularity of casual surf print clothing

With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor la..

  Differences between deterministic and probabilistic models

Provide examples of decision problems you face frequently under the four different states of the decision environment. What are the primary differences between deterministic and probabilistic models?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd