Reference no: EM131087055
Accounting
CVP Project Data
For the Year Ended 12/31/16
Trump Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid a commission of 15% of selling price for all items sold.
Dr. Ben Carson, Trump's controller just prepared the company's budgeted income statement for next year as following:
|
TRUMP COMPANY
BUDGETED INCOME STATEMENT
FOR THE YEAR ENDED DECEMBER 31, 2016
|
|
SALES
|
|
$16,000,000
|
|
MANUFACTURING COSTS:
|
|
|
|
VARIABLE
|
$7,200,000
|
|
|
FIXED
|
2,340,000
|
9,540,000
|
|
GROSS MARGIN
|
|
6,460,000
|
|
SELLING & ADMIN COSTS:
|
|
|
|
COMMISSION TO AGENTS
|
2,400,000
|
|
|
FIXED MARKETING COSTS
|
120,000*
|
|
|
FIXED ADMIN COSTS
|
1,800,000
|
4,320,000
|
|
NET OPERATING INCOME
|
|
2,140,000
|
*primarily depreciation on storage facilities.
As Dr. Carson handed the statement to Donald Trump, Trump's president, he commented "I used the agents' 15% commission rate in completing the Budgeted Income Statement. But we've just learned that they refuse to handle selling our product next year unless we increase the commission rate to 20%."
Donald replied "How can they possibly defend a 20% commission rate? I say it's time we fire those guys and get our own sales force."
Dr. Carson said "We can hire our own sales staff and pay them 10% commission, along with a small salary. Of course, we would have to handle all promotion costs too. We figure our fixed costs would increase by $1,700,000 per year as follows:"
|
Sales manager
|
$ 200,000
|
|
Salespersons
|
400,000
|
|
Travel and Entertainment
|
400,000
|
|
Advertising
|
700,000
|
|
Total
|
$1,700,000
|
Required:
Using Excel worksheet, compute Trump's break-even point in sales dollars for next year assuming:
1. The agents' commission rate remains unchanged at 15%
2. The agents' commission rate is increased to 20%
3. The company employs its own sales force.
|
What is the return for the given portfolio
: Solve this using Excel and determine how much to invest in each of the two stocks. What is the return for this portfolio? What is the variance of this portfolio?
|
|
What is probability that the average time spent per customer
: If a random sample of 50 customers is selected from a population of 500 customers, what is the probability that the average time spent per customer will be at least 3 minutes
|
|
Comprehensive leadership plan for own style of leadership
: Develop a four- or five-page comprehensive leadership plan for your own style of leadership. Include strengths and weaknesses for yourself and how you will improve your leadership effectiveness moving forward.
|
|
What is the managerial view of business
: 1. What, in your view, makes a company "good" or "bad", particularly if you start with the idea that ethics is an important part of your evaluation? Why? 2. What is the managerial view of business? What is the stakeholder view? How do they differ?
|
|
Compute trumps break-even point in sales dollars
: Compute Trump's break-even point in sales dollars for next year assuming: The agents' commission rate remains unchanged at 15%.
|
|
Examine some of the it-supported customer services
: Access www.ups.com and www.fedex.com. Examine some of the IT-supported customer services and tools provided by the two companies. Compare and contrast the customer support provided on the two companies' Web sites.
|
|
Four-stages in the project planning process
: What are the four-stages in the project planning process? Identify and explain four (4) methods used for selecting projects.
|
|
Improve the bottom line companies
: Employment expense is usually the largest expense a company has. To improve the bottom line companies often try to cut costs. The labor cost is, quite naturally, a likely target for cutting.
|
|
F so that the resultant couple moment
: Two couples act on the beam as shown. Determine the magnitude of F so that the resultant couple moment is 300 lb . ft counterclockwise. Where on the beam does the resultant couple act?
|