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

  What is the present value of the? winnings

Celine Dion just won a? "Name That? Tune" contest with a grand prize of ?$210,000. ? However, the contest stipulates that the winner will receive ?$80000 ?immediately, and the remainder divided equally at the end of each of the next 10 years. Assumin..

  Important determinant of meeting retirement goals

The text presents a mathematical relationship between present value and future value. What does this relationship suggest to potential investors as far as setting important priorities? What is the most important determinant of meeting retirement goal..

  Dividend paid this year on a share of common stock

The dividend paid this year on a share of common stock is $10. If dividends grow at a 5% rate for the foreseeable future, and the required rate of return is 10%, what is the value of the stock today?

  What rate of growth must be expected for spencer

Spencer Supplies's stock is currently selling for $60 per share. The firm is expected to earn $5.10 per share this year and to pay a year-end dividend of $3.70. If investors require a 8.5% return, what rate of growth must be expected for Spencer?

  What is its times-interest-earned ratio

Graser Trucking has $19 billion in assets, and its tax rate is 35%. Its basic earning power (BEP) ratio is 19%, and its return on assets (ROA) is 5%. What is its times-interest-earned (TIE) ratio?

  How many days are in the cash cycle

ABC Corp. currently has an inventory turnover of 9, a payables turnover of 7.76, and a receivables turnover of 13.55. How many days are in the cash cycle?

  What is the value of the levered firm

Using M&M propositions with corporate taxes and the following information, what is the value of the levered firm? NOI - $80,000; Corporate Taxes = 40%; the firm borrows $700,000 at a rate of 9%.

  Suppose that all investors expect that interest rates

Suppose that all investors expect that interest rates for the 4 years will be as follows: If you have just purchased a 4-year zero-coupon bond, what would be the expected rate of return on your investment in the first year if the implied forward rate..

  Use as the initial investment in fixed assets

Kenny, Inc., is looking at setting up a new manufacturing plant in South Park. The company bought some land six years ago for $7.5 million in anticipation of using it as a warehouse and distribution site, but the company has since decided to rent fac..

  The nominal return on your investment

You want to have $3 million in real dollars in an account when you retire in 40 years. The nominal return on your investment is 10 percent and the inflation rate is 4 percent. What real amount must you deposit each year to achieve your goal?

  What would risk-free rate have to be for two stocks

Stock Y has a beta of 1.4 and an expected return of 16.4 percent. Stock Z has a beta of 0.85 and an expected return of 12 percent. Required: What would the risk-free rate have to be for the two stocks to be correctly priced relative to each other?

  Distinguish between symptom and important analysis skill

Being able to distinguish between a symptom and a problem is an important analysis skill. Classify each of the following as a problem or a symptom. If it is a symptom, give two examples of a possible underlying problem. If it is a problem, give two e..

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