Concept explainers
Missing Data; Basic CVP Concepts L06−1, L06−9
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.)
a. Assume that only one product is being sold in each of the four following case situations:
b. Assume that more than one product is being sold in each of the four following case situations:
Cost volume profit analysis: Cost volume profit analysis measures the effect on income of a company with the alteration of cost and volume of sales.
The missing amount in the table.
Answer to Problem 11E
Solution:
a) Assuming that only one product is being sold in each of the following case situations:
Case | Units Sold | Sales | Variable
Expenses | Contribution
Margin per Unit | Fixed Expenses | Net Operating Income(loss) |
1 | 15,000 | $180,000 | $120,000 | $4 | $50,000 | $10,000 |
2 | 4,000 | $100,000 | $60,000 | $10 | $32,000 | $8,000 |
3 | 10,000 | $200,000 | $70,000 | $13 | $118,000 | $12,000 |
4 | 6,000 | $300,000 | $210,000 | $15 | $100,000 | ($10,000) |
Case 1
Contribution format income statement | ||
Total | Per Unit | |
Sales (15,000 units) | $180,000 | $12.00 |
Variable expenses | $120,000 | $8.00 |
Contribution Margin | $60,000 | $4.00 |
Fixed expenses | $50,000 | |
Net operating income | $10,000 |
Case 2
Contribution format income statement | ||
Total | Per Unit | |
Sales (4,000 units) | $100,000 | $25.00 |
Variable expenses | $60,000 | $15.00 |
Contribution Margin | $40,000 | $10.00 |
Fixed expenses | $32,000 | |
Net operating income | $8,000 |
Case 3
Contribution format income statement | ||
Total | Per Unit | |
Sales (10,000 units) | $200,000 | $20.00 |
Variable expenses | $70,000 | $7.00 |
Contribution Margin | $130,000 | $13.00 |
Fixed expenses | $118,000 | |
Net operating income | $12,000 |
Case 4
Contribution format income statement | ||
Total | Per Unit | |
Sales (6,000 units) | $300,000 | $50.00 |
Variable expenses | $210,000 | $35.00 |
Contribution Margin | $90,000 | $15.00 |
Fixed expenses | $100,000 | |
Net operating income | ($10,000) |
b) Assuming that more than one product is being sold in each of the four case situations:
Case | Sales | Variable Expenses | Average
Contribution Margin Ratio | Fixed
Expenses | Net Operating
Income (loss) |
1 | $500,000 | $400,000 | 20% | $93,000 | $7,000 |
2 | $400,000 | $260,000 | 35% | $100,000 | $40,000 |
3 | $250,000 | $100,000 | 60% | $130,000 | $20,000 |
4 | $600,000 | $420,000 | 30% | $185,000 | ($5,000) |
Case 1
Contribution format income statement | |
Amounts | |
Sales | $500,000 |
Variable expenses | $400,000 |
Contribution Margin | $100,000 |
Fixed expenses | $93,000 |
Net operating income | $7,000 |
Contribution format income statement | |
Amounts | |
Sales | $400,000 |
Variable expenses | $260,000 |
Contribution Margin | $140,000 |
Fixed expenses | $100,000 |
Net operating income | $40,000 |
Case 3
Contribution format income statement | |
Amounts | |
Sales | $250,000 |
Variable expenses | $100,000 |
Contribution Margin | $150,000 |
Fixed expenses | $130,000 |
Net operating income | $20,000 |
Case 4
Contribution format income statement | |
Amounts | |
Sales | $600,000 |
Variable expenses | $420,000 |
Contribution Margin | $180,000 |
Fixed expenses | $185,000 |
Net operating income | ($5,000) |
Explanation of Solution
A contribution margin is calculated by deducting the variable expenses from the sales revenue. So, if the variable expense is missing, the contribution margin is deducted from the sales revenue and goes same in case of units. The net operating income is calculated by deducting the fixed expenses from the contribution margin. So, if the fixed expenses are missing, the operating income is deducted from the contribution margin. The contribution margin ratio is calculated by dividing the contribution margin by sales revenue. So, if the sales revenue is missing, it can be ascertained by dividing the contribution margin by the contribution margin ratio and if the contribution margin is missing, it is calculated by multiplying the contribution margin with the contribution margin ratio.
Given: a) Assume that only one product is being sold in each of the following case situations:
Case | Units Sold | Sales | Variable
Expenses | Contribution
Margin per Unit | Fixed Expenses | Net Operating Income(loss) |
1 | 15,000 | $180,000 | $120,000 | ? | $50,000 | ? |
2 | ? | $100,000 | ? | $10 | $32,000 | $8,000 |
3 | 10,000 | ? | $70,000 | $13 | ? | $12,000 |
4 | 6,000 | $300,000 | ? | ? | $100,000 | ($10,000) |
b) Assume that more than one product is being sold in each of the four case situations:
Case | Sales | Variable Expenses | Average
Contribution Margin Ratio | Fixed
Expenses | Net Operating
Income (loss) |
1 | $500,000 | ? | 20% | ? | $7,000 |
2 | $400,000 | $260,000 | ? | $100,000 | ? |
3 | ? | ? | 60% | $130,000 | $20,000 |
4 | $600,000 | $420,000 | ? | ? | ($5,000) |
The cost volume profit analysis aims determining an outcome of changes in the various variables of operations. A cost is the expenses incurred on the products which are being sold and the volume is the quantity of the products which is going to be sold. The profit is the difference between the cost incurred and sales revenue of a company. An analysis of cost volume profit helps in predicting or forecasting the various consequences of various decisions.
Want to see more full solutions like this?
Chapter 6 Solutions
INTRO TO MANAGERIAL ACCT-CONNECT ACCESS
Additional Business Textbook Solutions
Fundamentals Of Cost Accounting (6th Edition)
Financial Accounting
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Auditing And Assurance Services
Horngren's Accounting (11th Edition)
- The line that begins at the origin on a CVP graph represents total expenses. total fixed expenses. total sales revenues. both the total expenses and the total sales revenues. Which of the following best describes the concept of a "constraint?" Expected future costs that differ among alternatives. None of the items in this list of answers. A benefit foregone by choosing one alternative course over another. The distribution of all products to be sold.arrow_forwardWhich of the following is a true statement? O The mark-up is designed to cover all non-product costs, such as labor, utilities, supplies, interest expense, taxes, and also to provide the desired profit. Everything else being the same, the multiple for the ingredient mark-up approach to pricing will be smaller than the multiple for the prime ingredient mark-up approach. In the ingredient mark-up approach to pricing, the multiple is determined by dividing 1 by the desired product cost percentage. O All of the above. Only a. and c. above. QUESTION 21 The Hotel is located on Jeju Island, Korea, a popular honeymoon destination area. For two weeks every spring, thousands of newlyweds travel to the area for fun and relaxation. Which of the following yield management tactics would make sense for pricing rooms during these two weeks? O Refuse reservations for one-night stays. O Sell all rooms at the same rates during these two weeks. Require a three-day minimum stay at the quoted rate for each…arrow_forwardFill in the Blank Question The contribution margin as a percentage of sales is referred to as the contribution margin or CM Need help? Review these concept resources. Read About the Concept I (Enter only one word per blank) 4)arrow_forward
- Dorsey Company manufactures three products from a common input in a joint processing operation. Joint processing costs up to the split-off point total $340,000 per quarter. For financial reporting purposes, the company allocates these costs to the joint products on the basis of their relative sales value at the split-off point. Unit selling prices and total output at the split-off point are as follows: Product Selling Price A B C Product A $18.00 per pound. $ 12.00 per pound $24.00 per gallon Each product can be processed further after the split-off point. Additional processing requires no special facilities. The additional processing costs (per quarter) and unit selling prices after further processing are given below: B C Additional Processing Costs $ 66,090 $ 94,655 $ 39,460 Quarterly Output 12,600 pounds 19,700 pounds 3,800 gallons Selling Price $ 22.90 per pound $17.90 per pound $31.90 per gallon Required: 1. What is the financial advantage (disadvantage) of further processing each…arrow_forwardHW 8. Please complete all requirements :)arrow_forwardSee questions 6A-6C in image Question 6D: Using the residual income approach, if you were in Dell Havasi’s position, would you accept or reject the new product line?arrow_forward
- Which of the following statements is true? OA. When a large proportion of income is spent on a product or service, the more elastic the supply will be. Percentage change in price OB Elasticity of supply Percentage change in quantity supplied OC. Products or services in which inputs are readily available have a more elastic supply. OD. None of the above is true. hand written otherwise skiparrow_forwardPlease answer 11.2 and 11.3arrow_forwardWhich of the following is NOT true regarding an income statement organized according to thecontribution margin approach? Question 6 options: The contribution margin income statement is organized by cost behavior. Operating income will always be the same as operating income in a traditional income statement regardless of changes in inventory levels. All fixed costs, including fixed MOH, are expensed below the contribution margin line. The contribution margin is equal to sales revenue minus variable expenses.arrow_forward
- please fix my excel worksheet and answer this questions as well please as soon as possible: In addition possibly answer this too if possible: c-2. If your recommendation in part (c-1) is followed, what would be the company’s overall profit?arrow_forwardPlease answer part A thanksarrow_forward1. Distinguish between variable and fixed costs both on a per unit and total basis (graphs may be used to assist in explanation). 2. Identify any three (3) basic assumptions of CVP Analysis. 3. Briefly explain the term sales mix.arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College