Reference no: EM131162141
Assignment
The new owners are evaluating the operating structure, and you have two possible alternatives. One alternative requires a high level of investment in fixed costs compared to the other alternative. Jorge, your supervisor, has assigned you the task of evaluating the two alternatives.
Assume that the company has no debt. Regardless of the alternative selected, market conditions will require the selling price of the product to be $3.45 per unit. The details for each alternative are given in the table.
Alternative 1 Alternative 2
Variable costs $2.20 $2.70
Fixed costs $80,000 $30,000
Total assets $350,000 $350,000
Jorge has asked you to provide detailed responses to the following questions:
• How does CVP analysis help management in the planning stage of a new business? How does CVP analysis assist the decision makers of an existing business?
• What is the break-even quantity for each of the investment alternatives, calculated using an algebraic approach? Complete the tables for each alternative using the Microsoft Excel Template given below and indicate the break-even points. Using Microsoft Excel, graph the relevant data, showing the break-even points and the profit levels for each alternative. Explain the differences between the two alternatives.
• What is the degree of operating leverage (DOL) for each alternative at 90,000 units?
• What is the significance of different DOLs using this example?
• What does the return on equity (ROE) ratio tell management? How is it used in the decision-making process?
• What is the ROE under each alternative at an output level of 124,000 for Alternative 1 and 60,000 for Alternative 2? (As the company has no debt, the formula for ROE becomes profit/assets. Use this formula.) Explain the reason for and significance of your answers.
• Which alternative would you recommend to the company? Explain the pros and cons of each alternative and the reasons for your selection.
The Microsoft Excel Template includes two Sheets, one for each alternative.
ALTERNATIVE 1
1
|
PRICE
|
QUANTITY SOLD
|
AVC
|
TR
|
TFC
|
TVC
|
TOTAL COST PROFIT
|
2
|
3.45
|
0
|
|
|
|
|
|
3
|
3.45
|
34,000
|
|
|
|
|
|
4
|
3.45
|
64,000
|
|
|
|
|
|
5
|
3.45
|
94,000
|
|
|
|
|
|
6
|
3.45
|
124,000
|
|
|
|
|
|
7
|
3.45
|
154,000
|
|
|
|
|
|
8
|
3.45
|
184, 000
|
|
|
|
|
|
9
|
3.45
|
214,000
|
|
|
|
|
|
10
|
3.45
|
244,000
|
|
|
|
|
|
11
|
3.45
|
274,000
|
|
|
|
|
|
12
|
3.45
|
304,000
|
|
|
|
|
|
ALTERNATIVE 2
1
|
PRICE
|
QUANTITY SOLD
|
TFC
|
TR
|
TVC
|
TC
|
PROFIT
|
AVC
|
2
|
3.45
|
0
|
|
|
|
|
|
|
3
|
3.45
|
40,000
|
|
|
|
|
|
|
4
|
3.45
|
60,000
|
|
|
|
|
|
|
5
|
3.45
|
90,000
|
|
|
|
|
|
|
6
|
3.45
|
120,000
|
|
|
|
|
|
|
7
|
3.45
|
150,000
|
|
|
|
|
|
|
8
|
3.45
|
180,000
|
|
|
|
|
|
|
9
|
3.45
|
210,000
|
|
|
|
|
|
|
10
|
3.45
|
240,000
|
|
|
|
|
|
|
11
|
3.45
|
270,000
|
|
|
|
|
|
|
12
|
3.45
|
300,000
|
|
|
|
|
|
|
13
|
3.45
|
330,000
|
|
|
|
|
|
|
Submission Details:
• Compile your calculations and graph in a Microsoft Excel spreadsheet.
New solid sphere of uniform density
: A small solid sphere of mass M0, of radius R0, and of uniform density ρ0is placed in a large bowl containing water. It floats and the level of the water in the dish is L. Given the information below, determine the possible effects on the water lev..
|
Changes in the discount rate are initiated by
: Assume total reserves are $1 million, checkable deposits are $5 million, and the reserve requirement is 10 percent. What are the excess reserves? If depositors withdraw their funds and create a shortage of reserves, bankers. Changes in the discount r..
|
What is the maximum amount in new loans
: If the entire amount of Hometown Bank's new loans is spent and the funds are deposited in Bank B, by how much can Bank B increase its loan making?
|
What is a breeder reactor
: What is a breeder reactor? (Please describe, in a couple of short paragraphs, what it does that is different from a typical power reactor; and, roughly, how it does it.) What are the advantages and dangers?
|
What is the significance of different dols using the example
: What is the significance of different DOLs using this example? What does the return on equity (ROE) ratio tell management? How is it used in the decision-making process?
|
Effects of exposure to substance
: What is special about iodine-131, as a radioactive isotope that can harm humans? And what is the simple way to defend oneself against the effects of exposure to this substance?
|
Evaluate current laws and policy governing mergers
: Research and analyse the acquisitions of BHS with specific reference to the opportunities and risks associated with this type of business planning.
|
Magnetic field strength experience
: A) What is the number of turns in the outer coil, such that the net magnetic field at the common center of the two coils is zero? B) What is the magnetic field strength experience by both? C) If the outer coil was the only coil what would be its m..
|
According to monetary theories of the business cycle
: The long-run average change in real GDP is known as. Measuring the intensity of the business cycle requires. According to monetary theories of the business cycle, fluctuations are
|