Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 18, Problem 4R

The president of Poleski would like to know the effect that each of the following suggestions for improving performance would have on contribution margin per unit, sales needed to break even, and projected net income for next year. Each change should be considered independently. Reset the Data Section to its original values after each suggestion is analyzed. Fill in the table following the suggestions with the results of your analysis.

  1. a. The president suggests cutting the productʼs price. Since the market is relatively sensitive to price, “. . . a 10% cut in price ought to generate a 30% increase in sales (to 156,000 units). How can you lose?”
  2. b. The sales manager feels that putting all sales personnel on straight commission would help. This would eliminate $77,000 in fixed sales salaries expense. Variable sales commissions would increase to $2.00 per unit. This move would also increase sales volume by 30%.
  3. c. Poleskiʼs head of product engineering wants to redesign the package for the product. This will cut $1.00 per unit from direct materials and $0.50 per unit from direct labor, but will increase fixed factory overhead by $100,000 for additional depreciation on the new packaging machine. The package redesign would not affect sales volume.
  4. d. The firmʼs consumer marketing manager suggests undertaking a new advertising campaign on Facebook. This would cost $30,000 more than is currently planned for advertising but would be expected to increase sales volume by 30%.
  5. e. The production superintendent suggests raising quality and raising price. This will increase direct materials by $1.00 per unit, direct labor by $0.50 per unit, and fixed factory overhead by $110,000. With improved quality, “. . . raise the price to $18.50 and advertise the heck out of it. If you double your current planned advertising, Iʼll bet you can increase your sales volume by 30%.” Chapter 18, Problem 4R, The president of Poleski would like to know the effect that each of the following suggestions for
Blurred answer
Students have asked these similar questions
The Miramar Company is going to introduce one of three new products: a widget, a hummer, or a nimnot. The market conditions (favorable, stable, or unfavorable) will determine the profit or loss the company realizes, as shown in the following payoff table: a. Compute the expected value for each decision and select the best one. b. Develop the opportunity loss table and compute the expected opportunity loss for each product. c. Determine how much the firm would be willing to pay to a market research firm to gain better information about future market conditions.
Your team is conducting a CVP analysis for a new product. Different sales projections have different incomes. One member suggests picking numbers yielding favorable income because any estimate is “as good as any other.” Another member suggests dropping unfavorable data points for cost estimation. What do you do?
Maximus Steel plans to introduce one of three new products code-named: Wren, Hawk, and Nightingale. The marketing department indicated that the success of any product depends on the market conditions (Favorable, Neutral, or Unfavorable). The profit the company will earn also depends on the market conditions.  The table below shows the probability estimated for each market condition and the profits Maximus Steel will realize within those conditions: Product Code Market Conditions Favorable P = 0.2 Neutral P = 0.7 Unfavorable P = 0.1 Wren $120,000 $70,000 ($30,000) Hawk $60,000 $40,000 $20,000 Nightingale $35,000 $30,000 $30,000 Part 1 Instructions: Compute the expected value for each alternative. What is the best option for the company?
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Text book image
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Text book image
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Cost-Volume-Profit (CVP) Analysis and Break-Even Analysis Step-by-Step, by Mike Werner; Author: Accounting Step by Step;https://www.youtube.com/watch?v=D0MOfse9OWk;License: Standard Youtube License