Question

In: Accounting

Cullumber Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...

Cullumber Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs.

Sales $1,750,000 Selling expenses—variable $113,000
Direct materials 460,000 Selling expenses—fixed 50,000
Direct labor 390,000 Administrative expenses—variable 27,000
Manufacturing overhead—variable 410,000 Administrative expenses—fixed 77,500
Manufacturing overhead—fixed 100,000
Prepare a CVP income statement for 2020 based on management’s estimates.

CULLUMBER COMPANY
CVP Income Statement (Estimated)

For the Year Ending December 31, 2020

Variable cost per bottle $
Contribution margin ratio %
Margin of safety ratio %
Required sales dollars $

Solutions

Expert Solution

1.

CVP income statement:

Cullumber Company

CVP Income Statement (Estimated)

For the Year Ending December 31, 2020

Sales

1750000

Less: Variable expenses:

Cost of goods sold (460000+390000+410000)

-1260000

Selling expenses               

-113000

Administrative expenses                       

-27000

Total variable expenses

-1400000

Contribution margin

350000

Less: Fixed expenses:

Cost of goods sold

-100000

Selling expenses    

-50000

Administrative expenses    

-77500

Total fixed expenses

-227500

Net income

122500

.

2.

Variable cost ratio = variable cost / sales * 100

Variable cost ratio = 1400000 / 1750000 * 100

Variable cost ratio = 80%

.

Variable cost per bottles = 0.50 * 0.80

Variable cost per bottles = $0.40 per bottle

.

3.

Contribution margin ratio = contribution margin / sales * 100

Contribution margin ratio = 350000 / 1750000 * 100

Contribution margin ratio = 20%

.

4.

break even sales = fixed cost / contribution margin ratio

break even sales = 227500 / 20%

break even sales = $1137500

.

Margin of safety ratio = sales revenue - breakeven sales / sales revenue

Margin of safety ratio = 1750000 - 1137500 / 1750000

Margin of safety ratio = 35%

.

Note: only 4 parts can be attempted at once. Post remaining question separately.


Related Solutions

Cullumber Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 60...
Cullumber Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 60 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,800,000 Selling expenses—variable $105,000 Direct materials 510,000 Selling expenses—fixed 62,000 Direct labor 390,000 Administrative expenses—variable 25,000 Manufacturing overhead—variable 410,000 Administrative expenses—fixed 96,000 Manufacturing overhead—fixed 130,000 Prepare a CVP income statement for 2020 based on management’s estimates. Calculate variable cost...
Monty Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Monty Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2017, management estimates the following revenues and costs. Sales $1,640,000 Selling expenses—variable $50,000 Direct materials 420,000 Selling expenses—fixed 70,000 Direct labor 350,000 Administrative expenses—variable 30,000 Manufacturing overhead—variable 380,000 Administrative expenses—fixed 48,000 Manufacturing overhead—fixed 208,250 1.Prepare a CVP income statement for 2017 based on management’s estimates. MONTY COMPANY CVP...
Blossom Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Blossom Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,950,000 Selling expenses—variable $67,000 Direct materials 550,000 Selling expenses—fixed 61,000 Direct labor 350,000 Administrative expenses—variable 28,000 Manufacturing overhead—variable 370,000 Administrative expenses—fixed 59,250 Manufacturing overhead—fixed 260,000 Correct answer iconYour answer is correct. Prepare a CVP income statement for 2020 based...
Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,800,000 Selling expenses—variable $70,000 Direct materials 430,000 Selling expenses—fixed 65,000 Direct labor 360,000 Administrative expenses—variable 20,000 Manufacturing overhead—variable 380,000 Administrative expenses—fixed 60,000 Manufacturing overhead—fixed 280,000 Prepare a CVP income statement for 2020 based on management’s estimates.    Calculate variable...
Wildhorse Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Wildhorse Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,750,000 Selling expenses—variable $108,000 Direct materials 450,000 Selling expenses—fixed 54,000 Direct labor 400,000 Administrative expenses—variable 22,000 Manufacturing overhead—variable 420,000 Administrative expenses—fixed 71,000 Manufacturing overhead—fixed 120,000 Compute the break-even point in (1) units and (2) dollars. (Round answers to 0...
Ivanhoe Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Ivanhoe Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,650,000 Selling expenses—variable $76,500 Direct materials 460,000 Selling expenses—fixed 51,000 Direct labor 330,000 Administrative expenses—variable 21,000 Manufacturing overhead—variable 350,000 Administrative expenses—fixed 99,000 Manufacturing overhead—fixed 180,000 Part 1 Partially correct answer iconYour answer is partially correct. Prepare a CVP income...
Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2017, management estimates the following revenues and costs. Sales $1,840,000 Selling expenses—variable $50,000 Direct materials 410,000 Selling expenses—fixed 45,000 Direct labor 350,000 Administrative expenses—variable 16,000 Manufacturing overhead—variable 370,000 Administrative expenses—fixed 60,000 Manufacturing overhead—fixed 365,750 A. Prepare a CVP income statement for 2017 based on management estimates. B. Calculate...
Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2017, management estimates the following revenues and costs. Sales $1,840,000 Selling expenses—variable $70,000 Direct materials 440,000 Selling expenses—fixed 55,000 Direct labor 300,000 Administrative expenses—variable 26,000 Manufacturing overhead—variable 360,000 Administrative expenses—fixed 46,000 Manufacturing overhead—fixed 511,500 Partially correct answer iconYour answer is partially correct. Prepare a CVP income statement for...
Sheridan Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50...
Sheridan Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. sales $2,000,000 Selling expenses—variable $212,000 Direct materials 480,000 Selling expenses—fixed 50,000 Direct labor 330,000 Administrative expenses—variable 28,000 Manufacturing overhead—variable 350,000 Administrative expenses—fixed 90,000 Manufacturing overhead—fixed 280,000 A) Compute the break-even point in (1) units and (2) dollars. (Round answers to...
Sheridan Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 60...
Sheridan Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 60 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,980,000 Selling expenses—variable $79,000 Direct materials 500,000 Selling expenses—fixed 56,000 Direct labor 380,000 Administrative expenses—variable 27,000 Manufacturing overhead—variable 400,000 Administrative expenses—fixed 179,500 Manufacturing overhead—fixed 210,000 Prepare a CVP income statement for 2020 based on management’s estimates. Calculate variable cost...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT