Reference no: EM131332449
Accounting Assignment
Project Data
Noble 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 12% of selling price for all items sold.
Randy, Noble's controller just prepared the company's budgeted income statement for next year as following:
|
NOBLE 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
|
1,920,000
|
|
|
FIXED MARKETING COSTS
|
120,000*
|
|
|
FIXED ADMIN COSTS
|
1,800,000
|
3,840,000
|
|
NET OPERATING INCOME
|
|
2,620,000
|
*primarily depreciation on storage facilities.
As Randy handed the statement to Mr. Noble, Noble Company's president, he commented "I used the agents' 12% 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 18%."
Mr. Noble replied "How can they possibly defend an 18% commission rate? I say it's time we fire those guys and get our own sales force."
Randy said "We can hire our own sales staff and pay them 8% 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,500,000 per year as follows:"
|
Sales manager
|
$ 200,000
|
|
Salespersons
|
400,000
|
|
Travel and Entertainment
|
200,000
|
|
Advertising
|
700,000
|
|
Total
|
$1,500,000
|
Required:
Using Excel worksheet, compute Noble's break-even point in sales dollars for next year assuming:
1. The agents' commission rate remains unchanged at 12%
2. The agents' commission rate is increased to 18%
3. The company employs its own sales force with 8% commission and $1,500,000 additional fixed cost.
|
Study quantitative or categorical
: (a) Can we conclude that 34% of all drivers have driven with a pet on their lap? (b) Explain why it is not appropriate to generalize these results to all drivers, or even to all drivers who visit cnn.com. What is the problem with this method of..
|
|
Discuss the world at war and the end of optimism
: You have this assignment in history about writing one page response to a movie and make a connection to what we learn in class Gandhi (1982) Dir: Richard Attenborough, With Ben Kingsley Richard Attenborough's hagiography of modern India's founder
|
|
Spread uniformly over five-year construction cycle
: In 2009, the average cost to construct a 150,000-barrel-a-day oil refinery was $2.4 billion (excluding any interest payments). This capital invest- ment is spread uniformly over a five-year construction cycle. If the cost of capital spent to build th..
|
|
Find the set of nash equilibria of the game
: Find the set of Nash equilibria of this game.- Prove that the set of correlated equilibria of this game is the convex hull of the set of Nash equilibria.
|
|
Compute nobles break-even point in sales dollars
: Using Excel worksheet, compute Noble's break-even point in sales dollars for next year assuming the agents' commission rate remains unchanged at 12%
|
|
When estimating future cash flows for investment project
: What challenges or difficulties you might face when estimating future cash flows for an investment project in reality and what you can do to overcome the obstacles?
|
|
Determines statistical significance at some fixed
: The term critical value is often used to refer to the value of a test statistic that determines statistical significance at some fixed α level for a test. For example, +1.96 are the critical values for a two-tailed z-test at α = 0.05.
|
|
Sale of new sound board used in recording studios
: Rolston Music Company is considering the sale of a new sound board used in recording studios. The new board would sell for $26,800, and the company expects to sell 1,530 per year. If the tax rate is 34 percent, what is the annual OCF for the project?
|
|
What is the probability you picked bag i
: This time, you pick a Bag at random, each of the two Bags being picked with probability ½, and you pick an object at random from the chosen Bag. Given the ball is black, what is the probability you picked Bag I?
|