Reference no: EM131043545
Evaluating performance reports-
Printers Plus is a retailer of printers and ink cartridges. The printers carry a low profit margin and the ink cartridges a very high margin. Following is an aggregated budgeted performance plan for 20X5.
Spreadsheet
|
|
fx
|
|
|
A
|
B
|
C
|
D
|
E
|
F
|
1
|
Budgeted Performance Report All Stores
For The Year Ending December 31, 20X5
|
2
|
|
|
|
|
|
|
3
|
Sales:
|
|
|
|
|
|
4
|
Printers
|
$4,500,000
|
|
|
|
|
5
|
Cartridges
|
4,500,000
|
|
|
|
|
6
|
Total sales
|
$9,000,000
|
|
|
|
|
7
|
|
|
|
|
|
|
8
|
Less variable expenses:
|
|
|
|
|
|
9
|
Printers
|
$4,000,000
|
|
|
|
|
10
|
Cartridges
|
1,500,000
|
|
|
|
|
11
|
Total variable expenses
|
$5,500,000
|
|
|
|
|
12
|
|
|
|
|
|
|
13
|
Contribution margin
|
$3,500,000
|
|
|
|
|
14
|
Traceable fixed costs
|
1,550,000
|
|
|
|
|
15
|
Location margin
|
$1,950,000
|
|
|
|
|
16
|
Common fixed costs
|
1,400,000
|
|
|
|
|
17
|
Stores margin
|
$ 550,000
|
|
|
|
|
18
|
|
|
|
|
|
|
Although total sales met expectations for the year, management is upset that the targeted margins were not achieved. Following is the "store by store" actual performance report. Evaluate the detailed data and write a paragraph explaining the loss. If each store has a positive margin, as shown in the report on the fol- lowing page, why is management upset?
Spreadsheet
|
|
fx
|
|
|
A
|
B
|
C
|
D
|
E
|
1
|
Actual Performance Report All Stores
For The Year Ending December 31, 20X5
|
2
|
|
Store A
|
Store B
|
Store C
|
|
3
|
Sales:
|
|
|
|
|
4
|
Printers
|
$2,000,000
|
$2,500,000
|
$1,000,000
|
|
5
|
Cartridges
|
500,000
|
2,000,000
|
1,000,000
|
|
6
|
Total sales
|
$2,500,000
|
$4,500,000
|
$2,000,000
|
|
7
|
|
|
|
|
|
8
|
Less variable expenses:
|
|
|
|
|
9
|
Printers
|
$1,777,778
|
$2,222,222
|
$ 888,889
|
|
10
|
Cartridges
|
166,667
|
666,667
|
333,333
|
|
11
|
Total variable expenses
|
$1,944,444
|
$2,888,889
|
$1,222,222
|
|
12
|
|
|
|
|
|
13
|
Contribution margin
|
$ 555,556
|
$1,611,111
|
$ 777,778
|
|
14
|
Traceable fixed costs
|
450,000
|
600,000
|
500,000
|
|
15
|
Location margin
|
$ 105,556
|
$1,011,111
|
$ 277,778
|
|
16
|
|
|
|
|
|
Residual income-
Sherwin Corporation has three business segments: paint, wallpapers, and tools. The company's assumed cost of capital is 10%. Financial information about each segment follows:
Paint segment
|
Wallpaper segment
|
Tools segment
|
Segment operating income Invested capital
|
$ 650,000
6,500,000
|
$ 475,000
3,500,000
|
$ 900,000
7,500,000
|
|
|
|
|
|
(a) Prepare an analysis of residual income for each segment, and note which segment has the highest residual income.
Evaluating the elimination of a segment-
Samstrun Electronics Store has three major departments: computers, televisions, and appliances. The appliance department has been a consistent money loser, as typified by the following recent monthly operating report:
|
|
Total
|
Computers TVs Appliances
|
Sales
|
$2,550,000
2,100,000
$ 450,000
305,000
$ 145,000
|
$750,000 $1,200,000 $600,000
|
Variable expenses
|
600,000 1,000,000 500,000
|
Contribution margin
|
$150,000 $ 200,000 $100,000
|
Fixed expenses
|
100,000 80,000 125,000
|
Income (loss)
|
$ 50,000 $ 120,000 $( 25,000)
|
|
|
|
Management is considering a strategy to exit the appliance business. If this strategy is followed, the floor space currently dedicated to appliances will be used to expand the television showroom space. It is believed that television sales will increase by 40%.
Fixed expenses that can be eliminated by abandoning appliance sales include the salary of a service tech and the lease of a delivery van. The two components total $10,000 per month. The remaining fixed costs relate to facilities expenses and employees that will be diverted to television sales activities.
Evaluate the impact on total profitability of exiting the appliance sales market. How can overall profits be negatively impacted by abandoning an "unprofitable" product line?
Reported equity beta-what is the value of the firm
: You are going to value Sheldon’s Flag co. using the FCF model. After consulting various sources, you find that Sheldon has reported equity beta of 1.7. a debt-to equity ratio of .5, and a tax rate of 40%. Assume a risk-free rate of 6% and a market ri..
|
Increase the amount of debt in its capital structure
: Other things held constant, which of the following events would be most likely to encourage a firm to increase the amount of debt in its capital structure? Its sales are projected to become less stable in the future. Management believes that the firm..
|
Compute her total expenses and what should be her decision
: Stacie wants to buy a new car. She has the option of buying the car for $35,000 with no money down and 1% financing for three years or get a cash discount of $4,000. She car get financing at the local bank for 4% per year. Compute her total expenses ..
|
Money market account with an annual return
: You plan to deposit $2,100 per year for 6 years into a money market account with an annual return of 3%. You plan to make your first deposit one year from today. What amount will be in your account at the end of 6 years? You and your wife are making..
|
Prepare an analysis of residual income for each segment
: Sherwin Corporation has three business segments: paint, wallpapers, and tools. The company's assumed cost of capital is 10%. Financial information about each segment follows: Prepare an analysis of residual income for each segment, and note which s..
|
What will be your annual loan payments
: You need $20,000 to purchase a used car. Your wealthy uncle is willing to lend you the money as an amortized loan. He would like you to make annual payments for 6 years, with the first payment to be made one year from today. He requires a 9% annual r..
|
What is change in price bond will experience in dollars
: A 7.50 percent coupon bond with 13 years left to maturity is priced to offer a 8.2 percent yield to maturity. You believe that in one year, the yield to maturity will be 7.8 percent. What is the change in price the bond will experience in dollars?
|
Corporate bond-calculate the current rate
: The Wall Street Journal reports that the current rate on 9-year Treasury bonds is 5.90 percent, the rate on 16-year Treasury bonds is 6.30 percent, and the rate on a 16-year corporate bond issued by MHM Corp. is 7.45 percent. calculate the current ra..
|
Using the dividend capitalization model approach
: The following financial information is available on Rawls Manufacturing Company: Rawls can issue new common stock to net the company $44 per share. Determine the cost of internal equity capital using the dividend capitalization model approach. (compu..
|