1

# Cost-Volume-Profit Analysis and Decision-Making In order to recover from the recent operating losses that the Biggie Widget Company has experienced, management has made some tentative new decisions and believes that the use of CVP analysis will be usef

## Question

###### Cost-Volume-Profit Analysis and Decision-Making In order to recover from the recent operating losses that the Biggie Widget Company has experienced, management has made some tentative new decisions and believes that the use of CVP analysis will be usef
Cost-Volume-Profit Analysis and Decision-Making

In order to recover from the recent operating losses that the Biggie Widget Company has experienced, management has made some tentative new decisions and believes that the use of CVP analysis will be useful when evaluating these decisions.

Recall that current selling price for widgets is \$200 per unit and that total assets reported on the balance sheet were valued at \$6,786,651. Total Costs (TC) can be estimated based on product quantity (Q) using the following linear cost function:

TC = 104 Q + 1,300,000

I. Based on this information, determine each to the following
1. Unit contribution margin
2. Contribution margin ratio
3. Breakeven point

II. Determine the quantity of product that must be produced and sold in order to achieve an income equal to:

1. \$140,000?

2. 10% of total assets?

III. Complete the following table:
Sales Quantity Revenue Variable Cost Fixed Costs Total Costs Operating income
5,000 units 1,000,000 520,000 1,300,000 1,820,000 2,820,000
10,000 units 2,000,000 1,040,000 1,300,000 2,340,000 4,340,000
15,000 units 3,000,000 1,560,000 1,300,000 2,860,000 5,860,000
20,000 units 4,000,000 2,080,000 1,300,000 3,380,000 7,380,000
30,000 units 6,000,000 3,120,000 1,300,000 4,420,000 10,420,000

IV. List the major assumptions of CVP analysis.

V. Prepare a contribution margin income statement based on April’s EXPECTED production quantity of 15,000 units of product. (This is the Base Case referred to later in this assignment.)

VI. Determine the Operating Leverage Index for this Base Case.

For several months, Biggie Widget Company has exhibited poor profit performance and has incurred net operating losses or low operating profits. Realizing that the company cannot continue to sustain this poor performance, management has proposed the following five changes and is considering whether to implement one or more of these changes in April.

Proposal A: Increase selling price from \$200 per unit to \$220 per unit (assume unit variable costs do not change).

Proposal B: Decrease the number of sales people from 135 to 90 while increasing their base salary from \$3,000 per month to \$3,500 per month, thereby decreasing total Sales People's Salaries from \$405,000 to \$315,000.

Proposal C: Increase advertising by \$50,000 per month.

Proposal D: Certify a substitute for Material X called Material X2 which can be purchased for \$3.50 per unit instead of \$6.90, the current cost of Material X plus related freight. NOTE: The Company’s product requires four units of Material X (and X2).

Proposal E: Increase the rate for Sales People's Commissions from 12% to 16%.

Details related to the estimates of fixed and variable costs (excluding income taxes) based on the analysis of March data are:
Fixed Costs: . Unit Variable Costs: .
Sales People's Salaries \$ 405,000 Sales People's Commissions \$ 24.00
Advertising 297,200 Material X (4 units @ \$6.90) 27.60
Other Fixed 598,800 Other Variable 52.40
Total Fixed Costs \$1,300,000 Total Unit Variable Costs \$104.00

Required:
1. For each proposal above, specify the new profit function that would result from implementing the proposal (the first is completed for you) and determine the new quantity needed to achieve the target profit, which is the same amount of profit as in the BASE CASE above.
New Profit Function Quantity Needed to Achieve Target Profit
A.
B.
C.
D.
E.

2. In general terms, describe how operating income changes as a result of increases and decreases in
A. Selling price.
B. Variable cost per unit.
C. Fixed costs.

A. Selling price, CVP affect the number of unit sold to breakeven point. Selling price per unit if to high BEP would be difficult to meet.

B. Variable cost per unit is -number of unit sold, total variable cost are unit variable cost time number of unit sold. Price X number of units; Variable cost per unit X no. of unit minus total fix cost C. Fixed costs are constant to relevant range. The total contribution margin is, number Unit sold and Contribution margin per unit. If price drop then contribution margin changes.

3. Assume that ALL five of the proposed decisions are implemented and that management wants to attain a target pre-tax profit of \$140,000.

A. What is the new profit function? (HINT: Remember that sales commissions are determined as a percent of sales and that the unit selling price is changing.)

B. What is the dollar amount of the contribution margin per unit?

C. What is the breakeven quantity?

D. What is the quantity of finished product that must be produced and sold to attain the target profit equal to:

1. \$140,000

2. 10% of total assets,

E. What is the total contribution margin when the target profit is equal to:

1. \$140,000

2. 10% of total assets,

F. What is the value of operating leverage when the target profit is equal to:

1. \$140,000

2. 10% of total assets,

#### Similar Solved Questions

##### Problem 19.23 find the direction and magnitude of the net electrostatic force exerted
Given that q = 14 mu C and d = 16 cm, find the direction and magnitude of the net electrostatic force exerted on the point charge q_1 in the figure.q1=+q---------q2=-2.0q----------q3=+3.0q...
##### Why is academic integrity important what penalties can apply yo brraches of academic integrity how does...
why is academic integrity important what penalties can apply yo brraches of academic integrity how does working with integrity improve your professional and personall success Qs Why is Academic Integrity important? what penalties can apply. to breaches of Gacademic integrity? How does coorking ...
##### What is the DeBroglie wavelength of an antineutrino with a kinetic energy of 1.8 MeV? Take...
What is the DeBroglie wavelength of an antineutrino with a kinetic energy of 1.8 MeV? Take the mass of the antineutrino to be 4.99E-37 kg. O 1.75 nm 2.88E-4 nm O 5.36E-16 nm O 8.45E-12 nm 1.24 nm...
##### Discuss the following (minimum 300 words): How various non-health outcomes are obtained via health promotion programs...
Discuss the following (minimum 300 words): How various non-health outcomes are obtained via health promotion programs and lifestyle behavior change interventions...
##### Herman Company has three products in its ending inventory. Specific per unit data at the end...
Herman Company has three products in its ending inventory. Specific per unit data at the end of the year for each of the products are as follows: Product 3 Cost Selling price Costs to sell Product 536 58 9 Product 2 \$106 168 7 2 118 26 Required: What unit values should Herman use for each of its pro...
##### 8. A parallel plate capacitor is square plates of side length 5.0cm that are spaced 2mm...
8. A parallel plate capacitor is square plates of side length 5.0cm that are spaced 2mm apart. The charge on each plate has a magnitude of 5uC. Calculate the field between the plates....
##### Billy’s Burgers (BB) is a franchisor that operates several corporate-owned restaurants as well as several franchised...
Billy’s Burgers (BB) is a franchisor that operates several corporate-owned restaurants as well as several franchised restaurants. The franchisees pay 3% of their sales revenues to BB in return for advertising and support. During the year, BB sold its corporate-owned stores to a franchisee. BB ...
##### What do you think would constitute an effective alternative dispute resolution system?
What do you think would constitute an effective alternative dispute resolution system?...
##### ISSUES IN DIVERSITY - CONFLICT AND NEGOTIATION SWIMMING IN CONFLICT    What do African American and...
ISSUES IN DIVERSITY - CONFLICT AND NEGOTIATION SWIMMING IN CONFLICT    What do African American and Hispanic summer camp children have in common with children from Huntingdon Valley, PA, on a warm summer day? They all want to swim! Rather than swim, however, the sixty-five predominately bl...
##### QUESTION 3 Pictured below is a positive charge q moving in a magnetic field B. What...
QUESTION 3 Pictured below is a positive charge q moving in a magnetic field B. What is the direction of the magnetic field that would make the force in the direction shown? O To the right O To the left O Into the page 0 out of the page O Up and to the right...
##### Need help The following informations available for sharika Company for 2016: Inventories January 1 December 31...
need help The following informations available for sharika Company for 2016: Inventories January 1 December 31 Materials \$401,160 \$501,450 Work in process 722,090 681,970 Finished goods 694,010 697,020 Advertising expense Depreciation expense-office equipment Depreciation expense-factory ...
##### Round 7,596,459,456 hundreds thousand
round 7,596,459,456hundredsthousand...
##### I need help with this
I need help with this. “What is Hamlet ‘about’?” and “What are its enduring themes and messages?”. The responses you provide do not have to be governed by the Values and Worldviews (Dialectic) approach. Substantiate your own ideas with evidence from the play. Than...
##### [2] 11. Y is a value which is drawn from a normal distribution with mean 2.5...
[2] 11. Y is a value which is drawn from a normal distribution with mean 2.5 and standard deviation 2.5. The probability that y is positive is: A. 0.1587 B. 0.5 C. 0.6587 D. 0.8413 E. none of the above...