Question

In: Accounting

Using cost-volume-profit formuas:E 20.8 Arrow products typically earns a contribution margin ratio of 25 percent and...

Using cost-volume-profit formuas:E 20.8 Arrow products typically earns a contribution margin ratio of 25 percent and has current fixed cost of $80,000. Arrow's general manger is considering spending an additional $20,000 to do one of the following : 1 start a new ad campaign that is expected to increase sales revenue by 5 percent. 2. license a new computerized ordering system that is expected to increase Arrow's contribution margin ratio to 30 percent. sales revenue for the coming year was initially forecast to equale $1,2000,000(that is without impleminting either of the above options). A. For each option, how much will projected operating income increase or decrease relative to initial prediction? B. By what percentage would sales revenue need to increase to make the ad campaign as attractive as the ordering system?

Solutions

Expert Solution

A.

Let us first calculate operating income under each of the options:

Increase/(Decrease) in operating income = Operating Income under new option - Operating Income under Initial Forecast

For Option 1 = 215,000 - 2,20,000

= -5,000 or 5,000 decrease

For Option 2 = 260,000 - 220,000

= 40,000 increase

B. In order to make the ad campaign as attractive as the ordering system, operating income under ad campaign should be equal to operating income under ordering system.

Therefore, required operating income = 260,000

By back calculation, required contribution margin = Operating income + Fixed Costs

= 260,000 + 100,000

= 360,000

Let required sales be Y

Threfore, Contribution Margin = Sales x Contribution Margin %

360,000 = Y x 25%

or Y = 360,000 / 25%

or Y = 1,440,000

Therefore, required sales revenue = $1,440,000

Increase in sales revenue over initial forecast = 1,440,000 - 1,200,000

= $240,000   

% increase = 240,000 / 1,200,000 x 100

= 20%

Therefore, Sales revenue need to increase by 20% to make the ad campaign as attractive as the ordering system


Related Solutions

What do you understand by the term Cost-Volume-Profit Relationship. What is Contribution Margin (CM Ratio)? Discuss...
What do you understand by the term Cost-Volume-Profit Relationship. What is Contribution Margin (CM Ratio)? Discuss its importance in profit planning. Discuss the term, Break-even analysis and Margin of Safety. Analyze the usefulness of Operating Leverage in manufacturing organizations.
Cost-Volume-Profit Analysis: Analyze cost behavior in relation to changes in volume. Define contribution margin and its...
Cost-Volume-Profit Analysis: Analyze cost behavior in relation to changes in volume. Define contribution margin and its use in computing operating income. Discuss cost-volume-profit (CVP) analysis and how it is used as a decision too.
Is the break-even volume, in units, a) the ratio of fixed cost per unit contribution margin...
Is the break-even volume, in units, a) the ratio of fixed cost per unit contribution margin or b) the ratio of selling price per unit contribution margin? If the prevailing market interest rate increases, does the purchase price of an annuity decrease or increase? When calculating the future value of an annuity due, is the end date at the beginning or end of the last payment interval?
PA5-4 Predicting Cost Behavior, Calculating Contribution Margin and Contribution Margin Ratio, Calculating Profit [LO 5-1, 5-5]...
PA5-4 Predicting Cost Behavior, Calculating Contribution Margin and Contribution Margin Ratio, Calculating Profit [LO 5-1, 5-5] Presidio, Inc. produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio’s cost data table. (Round your Cost per Unit answers to 2 decimal places.) Bikes Produced and Sold 430 Units 870 Units 1606 Units Total costs Variable costs $137,600 Fixed costs per year Total costs $137,600 $0 $0 Cost per unit Variable cost per unit Fixed cost...
Backus, Inc., makes and sells many consumer products. The firm’s average contribution margin ratio is 25%....
Backus, Inc., makes and sells many consumer products. The firm’s average contribution margin ratio is 25%. Management is considering adding a new product that will require an additional $11,000 per month of fixed expenses and will have variable expenses of $5.5 per unit. Required: a. Calculate the selling price that will be required for the new product if it is to have a contribution margin ratio equal to 25%. (Round your answer to 2 decimal places.) b. Calculate the number...
If total fixed costs is $100,000, contribution per unit is $25 and the contribution margin ratio...
If total fixed costs is $100,000, contribution per unit is $25 and the contribution margin ratio is 40% and the company desired target profit of $25,000, what are the values of the followings (see page 97): a) Break-Even-Point in unit = _________________? b) Break-Even-Point in sales dollars________________________?
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT