Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
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.
- 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?”
- 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%.
- 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. - 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%.
- 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%.”
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Earl Massey, director of marketing, wants to reduce the selling price of his company’s products by 15% to increase market share. He says, “I know this will reduce our gross profit rate, but the increased number of units sold will make up for the lost margin.” Before this action is taken, what other factors does the company need to consider?
In a strategy meeting, a manufacturing company’s president said, “If we raise the price of our product, the company’s break-even point will be lower.” Thefinancial vice president responded by saying, “Then we should raise our price. The company will be less likely to incur a loss.” Do you agree with the president? Why? Do you agree with the financial vice president? Why?
In attempting to achieve better results in the marketplace, management has been looking at changing the reward system for marketing, distribution and sales personnel. This would result in an increase in variable marketing and administrative costs by $2 per unit, and would reduce fixed marketing and distribution costs by $100,000: Calculate the number of units required to breakeven if management implemented the changes and Would you suggest that management pursue the changes? Explain By reference to the above data:How can a company effectively use CPV (Cost-Volume-Profit) analysis to make strategic decisions about its product pricing and production levels?
Chapter 18 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
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
- Boxer Production, Inc., is in the process of considering a flexible manufacturing system that will help the company react more swiftly to customer needs. The controller, Mick Morrell, estimated that the system will have a 10-year life and a required return of 10% with a net present value of negative $500,000. Nevertheless, he acknowledges that he did not quantify the potential sales increases that might result from this improvement on the issue of on-time delivery, because it was too difficult to quantify. If there is a general agreement that qualitative factors may offer an additional net cash flow of $150,000 per year, how should Boxer proceed with this Investment?arrow_forwardSouthland Corporation’s decision to produce a new line of recreational products resulted in the need to construct either a small plant or a large plant. The best selection of plant size depends on how the marketplace reacts to the new product line. To conduct an analysis, marketing management has decided to view the possible long-run demand as low, medium, or high. The following payoff table shows the projected profit in millions of dollars: What is the decision to be made, and what is the chance event for Southland’s problem? Construct a decision tree. Recommend a decision based on the use of the optimistic, conservative, and minimax regret approaches.arrow_forwardDanna Martin, president of Mays Electronics, was concerned about the end-of-the year marketing report that she had just received. According to Larry Savage, marketing manager, a price decrease for the coming year was again needed to maintain the companys annual sales volume of integrated circuit boards (CBs). This would make a bad situation worse. The current selling price of 18 per unit was producing a 2-per-unit profithalf the customary 4-per-unit profit. Foreign competitors kept reducing their prices. To match the latest reduction would reduce the price from 18 to 14. This would put the price below the cost to produce and sell it. How could these firms sell for such a low price? Determined to find out if there were problems with the companys operations, Danna decided to hire a consultant to evaluate the way in which the CBs were produced and sold. After two weeks, the consultant had identified the following activities and costs: The consultant indicated that some preliminary activity analysis shows that per-unit costs can be reduced by at least 7. Since the marketing manager had indicated that the market share (sales volume) for the boards could be increased by 50% if the price could be reduced to 12, Danna became quite excited. Required: 1. CONCEPTUAL CONNECTION What is activity-based management? What phases of activity analysis did the consultant provide? What else remains to be done? 2. CONCEPTUAL CONNECTION Identify as many nonvalue-added costs as possible. Compute the cost savings per unit that would be realized if these costs were eliminated. Was the consultant correct in the preliminary cost reduction assessment? Discuss actions that the company can take to reduce or eliminate the nonvalue-added activities. 3. Compute the unit cost required to maintain current market share, while earning a profit of 4 per unit. Now compute the unit cost required to expand sales by 50%, assuming a per-unit profit of 4. How much cost reduction would be required to achieve each unit cost? 4. Assume that further activity analysis revealed the following: switching to automated insertion would save 60,000 of engineering support and 90,000 of direct labor. Now, what is the total potential cost reduction per unit available from activity analysis? With these additional reductions, can Mays achieve the unit cost to maintain current sales? To increase it by 50%? What form of activity analysis is this: reduction, sharing, elimination, or selection? 5. CONCEPTUAL CONNECTION Calculate income based on current sales, prices, and costs. Then calculate the income by using a 14 price and a 12 price, assuming that the maximum cost reduction possible is achieved (including Requirement 4s reduction). What price should be selected?arrow_forward
- As a manager, you have to choose between two options for new production equipment. Machine A will increase fixed costs by a substantial margin but will produce greater sales volume at the current price. Machine B will only slightly increase fixed costs but will produce considerable savings on variable cost per unit. No additional sales are anticipated if Machine B is selected. What are the relative merits of both machines, and how could you go about analyzing which machine is the better investment for the company in terms of both net operating income and break-even?arrow_forwardWayne Johnson, president of Banshee Company, recently returned from a conference on quality and productivity. At the conference, he was told that many American firms have quality costs totaling 20 to 30 percent of sales. He, however, was skeptical about this statistic. But even if the quality gurus were right, he was sure that his companys quality costs were much lowerprobably less than 5 percent. On the other hand, if he was wrong, he would be passing up an opportunity to improve profits significantly and simultaneously strengthen his competitive position. The possibility was at least worth exploring. He knew that his company produced most of the information needed for quality cost reportingbut there never was a need to bother with any formal quality data gathering and analysis. This conference, however, had convinced him that a firms profitability can increase significantly by improving qualityprovided the potential for improvement exists. Thus, before committing the company to a quality improvement program, Wayne requested a preliminary estimate of the total quality costs currently being incurred. He also indicated that the costs should be classified into four categories: prevention, appraisal, internal failure, or external failure. He has asked you to prepare a summary of quality costs and to compare the total costs to sales and profits. To assist you in this task, the following information has been prepared from the past year, 20x5: a. Sales revenue, 15,000,000; net income, 1,500,000. b. During the year, customers returned 90,000 units needing repair. Repair cost averages 1 per unit. c. Four inspectors are employed, each earning an annual salary of 60,000. These four inspectors are involved only with final inspection (product acceptance). d. Total scrap is 150,000 units. Of this total, 60 percent is quality related. The cost of scrap is about 5 per unit. e. Each year, approximately 450,000 units are rejected in final inspection. Of these units, 80 percent can be recovered through rework. The cost of rework is 0.75 per unit. f. A customer cancelled an order that would have increased profits by 150,000. The customers reason for cancellation was poor product performance. g. The company employs three full-time employees in its complaint department. Each earns 40,500 a year. h. The company gave sales allowances totaling 45,000 due to substandard products being sent to the customer. i. The company requires all new employees to take its three-hour quality training program. The estimated annual cost of the program is 30,000. Required: 1. Prepare a simple quality cost report classifying costs by category. 2. Compute the quality cost-to-sales ratio. Also, compare the total quality costs with total profits. Should Wayne be concerned with the level of quality costs? 3. Prepare a pie chart for the quality costs. Discuss the distribution of quality costs among the four categories. Are they properly distributed? Explain. 4. Discuss how the company can improve its overall quality and at the same time reduce total quality costs. 5. By how much will profits increase if quality costs are reduced to 2.5 percent of sales?arrow_forwardHudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing, or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? What is the expected annual cost associated with that recommendation? Construct a risk profile for the optimal decision in part (a). What is the probability of the cost exceeding $700,000?arrow_forward
- The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.arrow_forwardBaghdad Company produces a single product. They have recently received the result of a market survey that indicates that they can increase the retail price of their product by 10% without losing customers or market share. All other costs will remain unchanged. If they enact the 10% price increase, what will be their new break-even point in units and dollars? Their most recent CVP analysis is:arrow_forwardThe following series of statements or phrases are associated with product life-cycle viewpoints. Identify whether each one is associated with the marketing, production, or customer viewpoint. Where possible, identify the particular characteristic being described. If the statement or phrase fits more than one viewpoint, label it as interactive. Explain the interaction. a. Sales are increasing at an increasing rate. b. The cost of maintaining the product after it is purchased. c. The product is losing market acceptance and sales are beginning to decrease. d. A design is chosen to minimize post-purchase costs. e. Ninety percent or more of the costs are committed during the development stage. f. The length of time that the product serves the needs of a customer. g. All the costs associated with a product for its entire life cycle. h. The time in which a product generates revenue for a company. i. Profits tend to reach peak levels during this stage. j. Customers have the lowest price sensitivity during this stage. k. Describes the general sales pattern of a product as it passes through distinct life-cycle stages. l. The concern is with product performance and price. m. Actions taken so that life-cycle profits are maximized. n. Emphasizes internal activities that are needed to develop, produce, market, and service products.arrow_forward
- Marchete Company produces a single product. They have recently received the results of a market survey that indicates that they can increase the retail price of their product by 8% without losing customers or market share. All other costs will remain unchanged. Their most recent CVP analysis is shown. If they enact the 8% price increase, what will be their new break-even point in units and dollars?arrow_forwardMoses Moonrocks Inc. has developed a balanced scorecard with a measure map that suggests that the number of erroneous shipments has a direct effect on operating profit. The company estimates that every shipment error leads to a reduction of revenue by 3,000 and increased costs of about 2,000. If the company has the following budgeted sales and costs for next month (without accounting for any possible shipping errors), determine how many shipping errors the company can afford to have and still break even:arrow_forwardThe president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firms leading product over the past eight years: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. c. What is the average cost increase that the firm has been realizing per year? d. Compute an estimate of the cost/unit for next year.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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