Wingler Communications Corporation (WCC) produces premium stereo headphones that sell for $28.60 per set, and this year's sales are expected to be 440,000 units. Variable production costs for the expected sales under present production methods are estimated at $10,400,000, and fixed production (operating) costs at present are $1,560,000. WCC has $4,800,000 of debt outstanding at an interest rate of 9%. There are 240,000 shares of common stock outstanding, and there is no preferred stock. The dividend payout ratio is 70%, and WCC is in the 25% federal-plus-state tax bracket. WCC is a small company with average sales of $25 million or less during the past 3 years, so it is exempt from the interest deduction limitation.
The company is considering investing $7,200,000 in new equipment. Sales would not increase, but variable costs per unit would decline by 20%. Also, fixed operating costs would increase from $1,560,000 to $1,800,000. WCC could raise the required capital by borrowing $7,200,000 at 10% or by selling 240,000 additional shares of common stock at $30 per share.
In: Finance
Walthman Industries Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended December 31 are as follows:
| Salesperson | Total Sales | Variable Cost of Goods Sold | Variable Selling Expenses | |||||
| Case | $366,000 | $161,040 | $54,900 | |||||
| Dix | 528,000 | 300,960 | 68,640 | |||||
| Johnson | 581,000 | 313,740 | 92,960 | |||||
| LaFave | 448,000 | 255,360 | 58,240 | |||||
| Orcas | 389,000 | 140,040 | 62,240 | |||||
| Sussman | 323,000 | 171,190 | 54,910 | |||||
| Willbond | 422,000 | 143,480 | 75,960 | |||||
Required:
1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. Round percents to the nearest whole number. Enter all amounts as positive numbers.
| Waltham Industries Inc. | ||||
| Salespersons' Analysis | ||||
| For the Year Ended December 31 | ||||
| Salesperson | Contribution Margin | Variable Cost of Goods Sold as a Percent of Sales |
Variable Selling Expenses as a Percent of Sales |
Contribution Margin Ratio |
| Case | $ | % | % | % |
| Dix | % | % | % | |
| Johnson | % | % | % | |
| LaFave | % | % | % | |
| Orcas | % | % | % | |
| Sussman | % | % | % | |
| Willbond | % | % | % | |
Feedback
Calculate:
Column 1: Contribution margin = Total sales – (Variable cost of goods sold + Variable selling expenses)
Column 2: Variable cost of goods sold as a percent of sales = Variable cost of goods sold/Total sales
Column 3: Variable selling expenses as a percent of sales = Variable selling expenses/Total sales
Column 4: Contribution margin ratio = Contribution margin/Total sales
2. Which salesperson generated the highest contribution margin ratio for the year?
Feedback
2. The salesperson who generated the highest contribution margin ratio for the year, probably sells a favorable mix of product that has high manufacturing margins as a percent of sales.
3. Identify the factors other than contribution margin that should be considered in evaluating the performance of salespersons.
In: Accounting
|
Company X is trying to estimate future inspection fees based on prior experience. You (the accountant) requested and gathered from various managers the number of orders received each week, |
||||||||||||
|
the average weight of each order, and the average cost of each order. You then compared this data to the actual inspection fees incurred. The data is summarized below: |
||||||||||||
| Week | Inspection Fees | # orders received | Size of order (lbs) | Cost of order | ||||||||
| Week 1 | $57,600 | 219,379 | 889,114 | $25,847 | ||||||||
| Week 2 | $36,500 | 126,965 | 320,181 | $12,748 | ||||||||
| Week 3 | $40,500 | 197,583 | 700,000 | $43,910 | ||||||||
| Week 4 | $47,200 | 231,072 | 539,044 | $9,421 | ||||||||
| Week 5 | $54,700 | 255,388 | 677,425 | $20,382 | ||||||||
| Week 6 | $56,500 | 142,072 | 396,396 | $16,329 | ||||||||
| Week 7 | $39,500 | 151,618 | 468,812 | $11,097 | ||||||||
| Week 8 | $30,400 | 90,306 | 267,177 | $10,190 | ||||||||
| Week 9 | $20,000 | 72,718 | 187,030 | $6,082 | ||||||||
| Week 10 | $50,000 | 123,008 | 466,636 | $16,723 | ||||||||
| Week 11 | $30,000 | 126,341 | 135,045 | $2,932 | ||||||||
| Week 12 | $20,000 | 41,988 | 204,808 | $4,202 | ||||||||
| Week 13 | $42,900 | 155,783 | 576,713 | $9,420 | ||||||||
| Week 14 | $55,300 | 266,358 | 603,139 | $19,635 | ||||||||
| Week 15 | $28,000 | 46,367 | 211,147 | $9,319 | ||||||||
| Total | $609,100 | 2,246,946 | 6,642,667 | $218,237 | ||||||||
| Per Week | 40607 | 149796 | 442844 | $14,549 |
|
Regression |
|||||||||||||||||||||||||||||||||||||
| You take your estimate for Week 16 to the boss and he/she seemed skeptical of the results. The boss sends you back to do some more work. You decide to use regression. | |||||||||||||||||||||||||||||||||||||
| Run regression analysis for the two most promising variables. Compare the coefficient of determination for each. | |||||||||||||||||||||||||||||||||||||
| Which one has the highest coefficient of determination? Construct a cost equation. | |||||||||||||||||||||||||||||||||||||
|
Independent variable with the highest coefficient of determination is: |
|||||||||||||||||||||||||||||||||||||
|
New Cost equation is:
|
|||||||||||||||||||||||||||||||||||||
In: Statistics and Probability
The distribution of the number of viewers for the American Idol television show follows a normal distribution with a mean of 26 million with a standard deviation of 8 million. What is the probability next week's show will: a. Have between 30 and 37 million viewers? (Round z-score computation to 2 decimal places and your final answer to 4 decimal places.) b. Have at least 21 million viewers? (Round z-score computation to 2 decimal places and your final answer to 4 decimal places.) c. Exceed 49 million viewers? (Round z-score computation to 2 decimal places and your final answer to 4 decimal places.)
In: Statistics and Probability
1. Say you pick integers from the set {1,2,...,20} eight times with replacement (i.e. you can pick the same number multiple times). What is the probability that exactly half your choices are prime numbers?
2. Suppose you roll three fair, six-sided dice. Let X denote the sum of the three dice.
-Find P(X = 5), P(X >= 16), and P(X is even).
-Compute E[X].
-Let A be the event that X >= E[X], B the event that X is a multiple of 3, and C the event that the first die is a 6. Are A and B independent? What about B and C?
Please explain !
In: Statistics and Probability
Urn problem One jar contains 8 white marbles and 12 black marbles. We offer you the following three games. For each game, identify the probability law(distribution) that will follow the number of points you will earn, the expected value and its Standard deviation.
A) You draw ten marbles and earn one point for each white ball drawn. (with replacement)
B)You draw ten marbles and earn one point for each white ball drawn. (Without replacement)
C) You draw marbles (with replacement) until you draw a black one and earn ten points for each white marble drawn.
In: Statistics and Probability
The manufacturer of a new line of ink-jet printers would like to include as part of its advertising the number of pages a user can expect from a print cartridge. The results from a sample of 14 cartridges can be found in the Excel test data file. Numbers are
| 1924 |
| 1518 |
| 1641 |
| 2358 |
| 1305 |
| 1272 |
| 2207 |
| 1580 |
| 1958 |
| 1069 |
| 1207 |
| 1453 |
| 1940 |
| 1331 |
In: Statistics and Probability
____________________________________________________________
____________________________________________________________
| Page Count |
| 1991 |
| 1604 |
| 1355 |
| 2207 |
| 1496 |
| 2164 |
| 1792 |
| 2249 |
| 1300 |
| 1702 |
| 1351 |
| 1464 |
| 1606 |
| 1419 |
In: Statistics and Probability
You read an article saying that the average person believes you should wait two years before
marrying a significant other. You want to test the theory that the average college student believes
it should be longer than 2 years. Assume that
σ
= 16
months.
(a.) From the data collected in class, we found that from 77 people who answered the question, the
average number of months people gave was 26.6234. Test your hypothesis at the 5% significance
level.
(b.) If the true average among college students is 30 months, what is the probability you’ll make a
type II error given a sample size of 77?
In: Statistics and Probability
The distribution of the number of viewers for the American Idol television show follows a normal distribution with a mean of 32 million with a standard deviation of 6 million.
What is the probability next week's show will:
Have between 38 and 44 million viewers? (Round your z-score computation to 2 decimal places and final answer to 4 decimal places.)
Have at least 23 million viewers? (Round your z-score computation to 2 decimal places and final answer to 4 decimal places.)
Exceed 47 million viewers? (Round your z-score computation to 2 decimal places and final answer to 4 decimal places.)
In: Statistics and Probability