Question

In: Accounting

CB Markets imports and sells small bear-shaped piñatas. In planning for the coming year, the company's...

CB Markets imports and sells small bear-shaped piñatas. In planning for the coming year, the company's owner is evaluating several scenarios. For each scenario under consideration, prepare a contribution margin income statement showing the anticipated operating income. Consider each scenario independently. Last year's income statement is as follows:

Total

Per Unit

Sales revenue

$600,000

$12.00

Variable expenses

 350,000

  7.00

Contribution margin

 250,000

$ 5.00

Fixed expenses

 175,000

Operating income

$ 75,000

Required

a.The sales price increases by 10% and sales volume decreases by 5%.

b.The sales price increases by 10% and variable cost per unit increases by 5%.

c.The sales price decreases by 10% and sales volume increases by 20%.

d.Fixed expenses increase by $20,000.

e.The sales price increases by 10%, variable cost per unit increases by 10%, fixed expenses increase by $25,000, and sales volume decreases by 10%.

Solutions

Expert Solution

Per Unit No of units Total
Sales revenue        12.00        50,000        600,000
Variable expenses          7.00        50,000        350,000
Contribution margin          5.00        250,000
Fixed expenses        175,000
Operating income          75,000
Scenario A
The sales price increases by 10% and sales volume decreases by 5%.
Per Unit No of units Total
Sales revenue        13.20        47,500        627,000
Variable expenses          7.00        47,500        332,500
Contribution margin          6.20        294,500
Fixed expenses        175,000
Operating income        119,500
Scenario B
The sales price increases by 10% and variable cost per unit increases by 5%.
Per Unit No of units Total
Sales revenue        13.20        50,000        660,000
Variable expenses          7.35        50,000        367,500
Contribution margin          5.85        292,500
Fixed expenses        175,000
Operating income        117,500
Scenario C
The sales price decreases by 10% and sales volume increases by 20%.
Per Unit No of units Total
Sales revenue        10.80        60,000        648,000
Variable expenses          7.00        60,000        420,000
Contribution margin          3.80        228,000
Fixed expenses        175,000
Operating income          53,000
Scenario D
.Fixed expenses increase by $20,000
Per Unit No of units Total
Sales revenue        12.00        50,000        600,000
Variable expenses          7.00        50,000        350,000
Contribution margin          5.00        250,000
Fixed expenses        195,000
Operating income          55,000
Scenario E
The sales price increases by 10%, variable cost per unit increases by 10%, fixed expenses increase by $25,000, and sales volume decreases by 10%.
Per Unit No of units Total
Sales revenue        13.20        45,000        594,000
Variable expenses          7.70        45,000        346,500
Contribution margin          5.50        247,500
Fixed expenses        200,000
Operating income          47,500

Related Solutions

The Fireside Credit Union is planning the allocation of funds for the coming year. The credit...
The Fireside Credit Union is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenue-producing investments together with annual rates of return are as follows: Type of loan/investment    Annual Rate of Return (%) Automobile loans 5 Furniture loans    15 Mortgage loans 6 Other Secured loans    12 Risk-free securities 2 Fireside will have...
Outback Outfitters sells recreational equipment. One of the company's products, a small camp stove, sells for...
Outback Outfitters sells recreational equipment. One of the company's products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove and fixed expenses associated with the stove total $175,000 per month. REQUIRED: 1. What is the break -even point in unit sales and in dollar sales? 2. If the variable expenses per stove increases as a percentage of the selling price, will it result in a higher or lower break - even point? (Assume that...
Outback Outfitters sells recreational equipment. One of the company's products, a small camp stove, sells for...
Outback Outfitters sells recreational equipment. One of the company's products, a small camp stove, sells for $50 per unit. The contribution margin per camp stove is 36% while the fixed expenses associated with the stove total $108,000 per month. At present, the company is selling 8,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. How many stoves would have to be...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. Based on the AFN equation, by how much would the AFN for the coming year change (indicate an increase or a decrease in AFN) if Safelight increased the dividend payout ratio from 20% to 25% and net profit margin decreased from 20% to 15%? All dollars are in millions....
In December 20.8, Finch Limited was planning its financial needs for the coming year. As a...
In December 20.8, Finch Limited was planning its financial needs for the coming year. As a first indication, the firm’s management required a pro forma Statement of Financial Position as at 31 December 20.9 to gauge the financial needs at that time. Estimated financial condition as at 31 December 20.8 was reflected in this Statement of Financial Position : ASSETS R Non-current assets    451 800 Property, plant and equipment    843 000 Accumulated depreciation   (434 600) Other non-current assets       43 400...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. Based on the AFN equation, by how much would the AFN for the coming year change (indicate an increase or a decrease in AFN) if Safelight increased the dividend payout ratio from 20% to 25% and net profit margin decreased from 20% to 15%? All dollars are in millions....
WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the...
WeHaul Trucking is planning its truck purchases for the coming year. It allocated $600,000 for the purchase of additional trucks, of which three sizes are available. A large truck costs $150,000 and will return the equivalent of $15,000 per year to profit. A medium-sized truck costs $90,000 and will return the equivalent of $12,000 per year. A small truck costs $50,000 and will return the equivalent of $9,000 per year. WeHaul has maintenance capacity to service either four large trucks,...
Company imports and sells bottles. At the beginning of the year 2018, the company had 900...
Company imports and sells bottles. At the beginning of the year 2018, the company had 900 bottles and the cost of goods was 2.700.000. The company does not use a perpetual inventory system. Purchase Sale Quantity Price/unit Quantity Price/unit February Purchase 600 3.100 Mars Sale 700 8.000 May Purchase 1.600 3.400 June Sale 900 9.500 July Sale 700 9.500 September Sale 600 9.800 October Purchase 500 3.500 A) Calculate the cost of ending inventory using FIFO, LIFO and weighted-average method....
(AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year....
(AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year. The firm is operating at full capacity. Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the payout ratio from the 10% that was used in the past to 65%, which the firm's investment bankers have recommended. Based on the AFN equation, by how much would the AFN for the coming year...
Zepol Company is planning to produce 600,000 power drills for the coming year. The company uses...
Zepol Company is planning to produce 600,000 power drills for the coming year. The company uses direct labor hours to assign overhead to products. Each drill requires 0.75 standard hour of labor for completion. The total budgeted overhead was $1,777,500. The total fixed overhead budgeted for the coming year is $832,500. Predetermined overhead rates are calculated using expected production, measured in direct labor hours. Actual results for the year are: Actual production (units) 594,000 Actual variable overhead $928,000 Actual direct...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT