Premium Essay

Target Profit and Break Even Analysis

In:

Submitted By hoangduongmba
Words 329
Pages 2
Cost Structure;

Target Profit and Break Even Analysis

Question 1: Compute Pittman Company’s break-even point in sales dollars for next year assuming:

a. The agents’ commission remains unchanged at 15%

$12,000,000 in sales is needed to break even while employing an outside sales force with commissions of 15% of sales.

b. The agents’ commission rate is increased to 20%

$13,714,286 in sales is needed to break even while employing an outside sales force with commissions of 20% of sales.

c. The company employs its own sales force.

$15,000,000 in sales is needed to break even while employing the company's own sales force with commissions of 7.5% of sales.

Before Pittman Company’s break-even point in sales can be determined, we must initially “reformat” the provided Budgeted Income Statement for the Year Ended December 31 (for the next year) to reflect a Contribution Income Statement format. The reason for this application is to separate the Variable and Fixed costs associated in selling telecommunications equipment to derive pertinent data needed to determine break even sales. The restructuring of each Income Statement may be found in Appendix A of this report.

Reformatting the Income Statement allows us to determine first, the Contribution Margin. The Contribution Margin is significant in determining Break-even point whether by the number of units to break even or the number of sales dollars needed to break-even. After determining the Contribution Margin, we are able to divide Sales for the year into that number to yield our Contribution Margin Ratio. Separating the Variable and Fixed Costs in selling telecommunications equipment also will allow us to group all of our fixed costs together, total, and use that number to plug into our BEP$ formula.

Formulas have been outlined below in order for us to properly demonstrate how to

Similar Documents

Premium Essay

Target Profit and Break Even Analysis; Case 4-33; Managerial Accounting

...Target Profit And Break Even Analysis; Case 4-33; Managerial Accounting Case 4-33: Cost Structure; Target Profit and Break Even Analysis Question 1: Compute Pittman Company’s break-even point in sales dollars for next year assuming: a. The agents’ commission remains unchanged at 15% $12,000,000 in sales is needed to break even while employing an outside sales force with commissions of 15% of sales. b. The agents’ commission rate is increased to 20% $13,714,286 in sales is needed to break even while employing an outside sales force with commissions of 20% of sales. c. The company employs its own sales force. $15,000,000 in sales is needed to break even while employing the company's own sales force with commissions of 7.5% of sales. Before Pittman Company’s break-even point in sales can be determined, we must initially “reformat” the provided Budgeted Income Statement for the Year Ended December 31 (for the next year) to reflect a Contribution Income Statement format. The reason for this application is to separate the Variable and Fixed costs associated in selling telecommunications equipment to derive pertinent data needed to determine break even sales. The restructuring of each Income Statement may be found in Appendix A of this report. Reformatting the Income Statement allows us to determine first, the Contribution Margin. The Contribution Margin is significant in determining Break-even point whether by the number of units to break even...

Words: 343 - Pages: 2

Premium Essay

Target Profit and Break Even Analysis; Case 4-33; Managerial Accounting

...Case 4-33: Cost Structure; Target Profit and Break Even Analysis Question 1: Compute Pittman Company’s break-even point in sales dollars for next year assuming: a. The agents’ commission remains unchanged at 15% $12,000,000 in sales is needed to break even while employing an outside sales force with commissions of 15% of sales. b. The agents’ commission rate is increased to 20% $13,714,286 in sales is needed to break even while employing an outside sales force with commissions of 20% of sales. c. The company employs its own sales force. $15,000,000 in sales is needed to break even while employing the company's own sales force with commissions of 7.5% of sales. Before Pittman Company’s break-even point in sales can be determined, we must initially “reformat” the provided Budgeted Income Statement for the Year Ended December 31 (for the next year) to reflect a Contribution Income Statement format. The reason for this application is to separate the Variable and Fixed costs associated in selling telecommunications equipment to derive pertinent data needed to determine break even sales. The restructuring of each Income Statement may be found in Appendix A of this report. Reformatting the Income Statement allows us to determine first, the Contribution Margin. The Contribution Margin is significant in determining Break-even point whether by the number of units to break even or the number of sales dollars needed to break-even. After determining the Contribution...

Words: 2588 - Pages: 11

Premium Essay

Case 5–33 Cost Structure; Break-Even and Target Profit Analysis

...FINAL PROJECT 12/17/2015 Case 5-33 Problem 1) a) Break-even point in dollar sales @ 15% commission fixed expenses/CM ratio = $4,800,000/.40 = $12,000,000 b) If the commission increases to 20%: $4,800,000/.35 = $13,714,286 c) If the company uses its own sales force: $7,125,000/.475 = $15,000,000 Problem 2) $ Sales to attain target = tgt income before taxes + fixed expenses CM ratio $1,600,000 + $4,800,000/0.35 = $18,285,714 Problem 3) x = total sales revenue .65x + $4,800,000 = .525x + $7,125,000 .125x = $2,325,000 X = $2,325,000 / .125 X = $18,600,000 Problem 4) Part a) CM 15% commission = $6,400,000 / income before taxes $1,600,000 = 4 Part b) 20% =$5,600,000 / $800,000 = 7 Part c) In-house sales force = $7,600,000 / $475,000 = 16 Problem 5) The company should continue to use the sales agents for at least one more year based on the fact that the use of the sales agents wouldn’t effect net income quite as much. Also, with the use of an in-house sales force, the company would have to reach sales of $18,600,000/year and this level wouldn’t be reached for at least one more year. Finally, the in-house sales force plan is highly leveraged, so when sales do reach $18.6 million, that leverage would assist the company quite a bit. So, at this point, till that 18.6 million sales goal is reached, the company should stay with the outside sales agents...

Words: 276 - Pages: 2

Premium Essay

Technology

...Chapter Three 3 Fundamentals of Cost-Volume-Profit Analysis Orientation P A R T 1 LEARNING OBJECTIVES Preparing and Organizing Yourself After reading this chapter, you should be able to: for Success in College L.O.1 Use cost-volume-profit (CVP) analysis to analyze decisions. L.O.2 Understand the effect of cost structure on decisions. L.O.3 Use Microsoft Excel to perform CVP analysis. L.O.4 Incorporate taxes, multiple products, and alternative cost structures into the CVP analysis. L.O.5 Understand the assumptions and limitations of CVP analysis. C H A P T E R S I N P A R T O N E 1 2 Making Yourself Successful in College Approaching College Reading and Developing a College-Level Vocabulary Approaching College Assignments: Reading Textbooks and Following Directions 3 ✓ Related Resources See pages 000 to 000 of the Annotated Instructor’s Edition for general suggestions related to the chapters in Part One. 1 cor50782_ch01_001-072.indd 1 10/5/09 11:09:2 P A R T I opened U-Develop because I love photography and I wanted to own my own business. I now get to spend most of my day working with employees and customers making sure that the photos they take are the best they can be. It also gives me a chance to encourage younger people who have an interest in photography, because I work with many of the school groups and after-school clubs here in town. That’s the fun part of the job. But I also have to think about the financial side of the business. I need a systematic way to understand...

Words: 16283 - Pages: 66

Premium Essay

Management Accounting

...DISCUSSION – ACCT2017 Question: Break-even analysis, the construction of break-even charts, and the related cost-volume- profit analysis is an area of accounting that provides management with relevant data. Discuss management’s use of this data for purposes of profit planning, policy formulation, and decision-making. It is essential to a business’s going concern that management executes proper profit planning, policy formulation and decision making. This is achieved with the help of tools such as cost-volume-profit (CVP) and break-even analysis. Break-even analysis determines the point at which revenue received equals the costs associated with receiving the revenue. Break-even analysis calculates what is known as a margin of safety, the amount that revenues exceed the break-even point. This is the amount that revenues can fall while still staying above the break-even point to ensure that profitability is maintained. The information used to determine and analyze the breakeven point includes fixed, variable and total costs and the associated sales revenues. A breakeven chart is a strategic tool used to plot the financial revenue of a business unit against time or sales to determine the point when sales output is equal to revenue generated. This is recognized as the breakeven point. It analyses the relationship between fixed and variable costs and to predict the effect on profitability of changes to those costs. The concept of CVP analysis examines the relationship among...

Words: 434 - Pages: 2

Premium Essay

Accounting

...Chapter 11: Cost Behavior and Cost-Volume-Profit Analysis Chapter Contents Book Title: Survey of Accounting Printed By: Jean Mette (jeanlucmette@gmail.com) © 2015, 2013 Cengage Learning, Cengage Learning Chapter 11 Cot ehavior and Cot-Volume-Profit Anali Chapter Introduction 11-1 Cost Behavior 11-1a Variable Costs 11-1b Fixed Costs 11-1c Mixed Costs 11-1d Summary of Cost Behavior Concepts 11-2 Cost-Volume-Profit Relationships 11-2a Contribution Margin 11-2b Contribution Margin Ratio 11-2c Unit Contribution Margin 11-3 Mathematical Approach to Cost-Volume-Profit Analysis 11-3a Break-Even Point 11-3b Target Profit 11-4 Graphic Approach to Cost-Volume-Profit Analysis 11-4a Cost-Volume-Profit (Break-Even) Chart 11-4b Profit-Volume Chart 11-4c Use of Computers in Cost-Volume-Profit Analysis 11-4d Assumptions of Cost-Volume-Profit Analysis 11-5 Special Cost-Volume-Profit Relationships 11-5a Sales Mix Considerations 11-5b Operating Leverage 11-5c Margin of Safety 11-6 Chapter Review 11-6a Key Points 11-6b Key Terms 11-6c Illustrative Problem 11-6d Self-Examination Questions 11-6e Class Discussion Questions 11-6f Exercises 11-6g Problems 11-6h Cases Chapter 11: Cost Behavior and Cost-Volume-Profit Analysis Chapter Introduction Book Title: Survey of Accounting Printed By: Jean Mette (jeanlucmette@gmail.com) © 2015, 2013 Cengage Learning, Cengage Learning Chapter Introduction Learning Ojective After studying this chapter, you should...

Words: 14685 - Pages: 59

Premium Essay

Bill French

...Question 5 The Value of Break-even Analysis  Break-even analysis is a basic tool that can be used to determine the level of sales that is requiredfor the company to start earning a profit.  Helps understand and formulate the relationship between costs (fixed and variable), output and profit  Helps quickly observe profit levels at different outputs.  In a wide product range, the analysis helps to find out which products are performing well andwhich are leading to losses.  The technique can be used to set sales targets and/or prices to generate target profits  It is also versatile enough to include items like donations, wage increases, etc. that directly or indirectly affect costs. Conclusions and Recommendations We can conclude that the use of break-even point analysis is to give a measure of risk, not of profitability. Break-even point enables to assess the degree of risk of a company’s cost structure. A planning tool that useful to forecast financial needs.CVP analysis is not for discontinuing decisions. A negative/positive UCM is not the only relevantcriteria to decide whether or not to drop a product. CVP analysis is insufficient for discontinuingdecisions (outsourcing, change in the product portfolio, etc..) and need to know the nature of fixed costs(direct and indirect) and what are the direct avoidable versus indirect largely unavoidable cost.CVP analysis is not for comparing products. Basic UCMs usually do not tell us which...

Words: 328 - Pages: 2

Premium Essay

Cvp Analysis

...According to Azcentral.com (2014), “CVP analysis, or cost-volume-profit analysis, is used in managerial accounting to quickly calculate metrics that provide insight into the current and future performance of a business CVP analysis is very useful for all business, but small businesses benefit the most because it is mathematically simple” (para 1). CVP techniques can save managers a great deal of time without any loss of information. Some of CVP techniques that are affective and many business owners use these techniques frequently are break even analysis, target profit, and margin of safety. • Break –Even Analysis is one of the most common CVP analysis techniques because it allows business owners to conduct an analysis to determine the level of sales or unit sold that can result in zero profit. Although zero profit isn’t a goal of any business, knowing the level of sales results in break even analysis tells companies that they’ve made enough revenue to cover the company’s fixed expense. • Target Profit CVP Analysis is performed to determine the level of sales needed to make a target profit. Target profit also assumes fixed cost does not change and product sales stays the same so business owners want to be careful when using this analysis. • Margin of Safety analysis is used to determine the number of units, sales dollars or percentage of sales dollars. Margin of safety over time tells business owners that costs are increasing, sales are decreasing or both. The margin...

Words: 257 - Pages: 2

Premium Essay

Cvp Analysis

...CHAPTER FIVE 5. INTRODUCTION TO COST VOLUME PROFIT (CVP) ANALYSIS Upon a successful completion of this chapter, you should be able to: ← distinguish between contribution margin and gross margin ← prepare and interpret a contribution income statement ← compute a break even point in total birrs and total units using the contribution margin approach and the equation approach ← Prepare a cost-volume –profit graph, and explain how it is used. ← Applying CVP analysis to determine the effect on profit of changes in fixed expenses, variable expenses, sales prices, and sales volume. ← Explain the role of cost structure and operating leverage in CVP analysis. ← List and discuss the key assumption of CVP analysis. ← compute the break even point and prepare a profit-volume graph for multiproduct enterprise ← explain the effects of sales mix on profit ← calculate sales volume in total birrs and total units to reach a target profit 1. INTRODUCTION Cost-volume-profit (CVP) analysis is one of the most powerful tool that help managers as they make decisions by facilitating quick estimation of net income at different levels of activity. In other words, it helps them to understand the interrelationship between cost, volume, and profit in an organization by focusing on interactions between the following five elements:...

Words: 10865 - Pages: 44

Premium Essay

Accounting

...Classification…………………………………………………………………2 Cost Volume Profit analysis……………………………………………………….2 Contribution Margin……………………………………………………………….2 Gross Margin and Contribution Margin…………………………………………...3 CVP Relationship in Graphic Form……………………………………………….3 CM Ratio. …………………………………………………………………………3 Application of CVP Concepts……………………………………………………..4 Importance of CM…………………………………………………………………4 Break-even Analysis………………………………………………………………4 Target Profit Analysis…………………………………………………………….5 The Margin of Safety……………………………………………………………..6 Degree of Operating Leverage…………………………………………………....6 Major Assumptions of CVP Analysis…………………………………………….7 Difference between Variable Costing and Absorption Costing………………………………………………………………7 Cost-Volume-Profit Relationship A. Cost Classification: 1. Variable Costs--variable costs are those costs that vary proportionately with changes in the level of activity (such as direct materials, direct labor, salesmen’s commissions, etc.) a) Relevant Range--even though variable cost per unit may vary throughout the entire range of possible activity, the variable cost per unit is assumed to remain constant over the range of activity over which the business expects to operate. 2. Fixed Costs--fixed costs are those costs that do not change with changes in the level of activity (such as depreciation, property taxes, executive salaries, etc.) a) Relevant Range-even though fixed costs may vary throughout the entire...

Words: 1268 - Pages: 6

Premium Essay

Cost Volume Profit Analysis

...information to be used by the managers to run the business more effectively. This information can be used in decision making, planning, and control. Management accounting is dealt with in another module of your course. Management Accounting is an integral part of management activity concerned with identifying, presenting and interpreting information used for the following: • Formulating strategy • Planning and controlling activities • Decision making • Optimising the uses of resources Key Definitions a) Cost unit- the cost of an item a product or service. This could be a single item, a batch, a contract what ever is appropriate for the organisation. b) Cost classification - to group costs for analysis and control purposes c) Cost centre - a function or location for which costs are ascertained dividing into production (primary) and service (secondary) areas. 1. THE...

Words: 2284 - Pages: 10

Premium Essay

Acc561 Week5 Dec-2012

...CVP Analysis and Presentation ACC/561 2012 Cost Volume Profit and Break-Even Analysis Break-Even Analysis-Volume-Analysis is a systematic method of examining the relationship between changes in volume (that is output) and changes in Sales Revenue, Express and Net Profit. As a model of these relationships, Break-Even Analysis simplifies the real-world conditions which a firm will face. The objective of Break-Even Analysis is to establish what will happen to the financial results if a specified level of activity or volume fluctuates. This information is vital to management, as one of the most important variables influencing total sales revenue, total costs and profits is output or volume. Break-Even Analysis is based on the relationship between sales revenue, costs and profit in the short run. The short run being a period in which the output of the firm is restricted to that available from current operating capacity in the short run, some inputs can be increased but others cannot. For example, additional supplies of materials and unskilled labor may be obtained at short notice, but it takes time to expand the capacity of the Plant and Machinery. Thus output is limited in the short run because Plant facilities cannot be expanded. It also takes time to reduce capacity, and therefore, in the short run, a firm must operate on a relative constant stock of production resources. Break-Even Analysis Assumptions It is essential that anyone preparing...

Words: 1150 - Pages: 5

Premium Essay

Bill French Write Up

...French Case 16-3 Introduction French, a staff accountant who was hired six months was well aware of his capabilities and took advantage of every opportunity that arose to try to educate those around him. Then, he was requested permission to make a presentation of some break-even data. The Duo-Products Corporation had not been making use of this type of analysis in its planning or review procedures. What French had done was to determine the level at which the company must operate in order to break even. He uses information given in past accounting records to construct his break even analysis without take into consideration with other department about the company operation. As per Bill French: “The company must be able at least to sell a sufficient volume of goods so that it will cover all the variable costs of producing and selling the goods. Further, it will not make a profit unless it covers the fixed cost as well. The level of operation at which total costs are just covered is the break-even volume. This should be the lower limit in all our planning.” Question 1 What are the assumptions implicit in Bill French’s determination of his company’s break-even point? 1. There was only one break-even point for the firm whether product by product or in total (he taking average of 3 products). Refer to the table below. | A | B | C | Aggregate | Sales at full capacity (units) | | | | 2,000,000 | Sales Volume (units) | 600 000 | 400 000 | 500 000 | 1 500 000 | Unit...

Words: 2105 - Pages: 9

Premium Essay

Student

...costs = income (These three equations are equivalent) The formula method means use the formula Breakeven or target profit point = (fixed cost + profit) / contribution margin per unit (or CM ratio for answer in dollars) EXERCISE 5-1  Preparing a Contribution Format Income Statement  [LO1] Required: Prepare a new contribution format income statement under each of the following conditions (consider each case independently): 1. |   | The sales volume increases by 50 units | 2. |   | The sales volume declines by 50 units | 3. |   | The sales volume is 7,000 units | EXERCISE 5-5  Changes in Variable Costs, Fixed Costs, Selling Price, and Volume  [LO4] Data for Herron Corporation are shown below: Fixed expenses are $75,000 per month and the company is selling 3,000 units per month. Required: 1. |   | The marketing manager believes that an $8,000 increase in the monthly advertising budget would increase monthly sales by $15,000. Should the advertising budget be increased? | 2. |   | Refer to the original data. Management is considering using higher-quality components that would increase the variable cost by $3 per unit. The marketing manager believes that the higher-quality product would increase sales by 15% per month. Should the higher-quality components be used? | EXERCISE 5-6  Compute the Level of Sales Required to Attain a Target Profit  [LO5] Liman Corporation has a single product whose selling price is $140 and whose variable expense is $60 per...

Words: 985 - Pages: 4

Premium Essay

Bill French

...Table of Contents Issues 1 Facts 1 Analysis 2 Conclusion/Recommendations 4 References/Bibliography 5 Issues 1. What are the assumptions implicit in Bill French’s determination of his company’s break-even point? 2. On the basis of French’s revised information, what does next year look like: a) What is the break-even point? b) What level of operations must be achieved to pay the extra dividend, ignoring union demands? c) What level of operations must be achieved to meet the union demands, ignoring bonus dividends? d) what level of operations must be achieved to meet both dividends and expected union requirements? 3. Can the break-even analysis help the company decide whether to alter the existing product emphasis? What can the company afford to invest for additional “C” capacity? 4. Why is the sum of the three break even analysis volume from Exhibit 3 not equal to the 1,100,000 units aggregate break-even volume? 5. Is this type of analysis of any value? For what can it be used? Facts Bill French was a staff accountant for six months at Duo-Products Corporation. As a staff accountant he was reported directly to the company’s controller Wes Davidson and performed routine analytical work for him. French was the invited to an informal manager’s meeting. However, French wanted to present certain break-even data during the meeting. As part of his presentation he used the following information: plan capacity of 2 million per year, past year’s level...

Words: 1457 - Pages: 6