Question

In: Accounting

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 statement for 2020 based on management’s estimates.

IVANHOE COMPANY CVP Income Statement (Estimated) For the Year Ending December 31, 2020
select an income statement itemAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit		$enter a dollar amount
select an opening name for section oneAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit
select an income statement itemAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit	$enter a dollar amount
select an income statement itemAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit	enter a dollar amount
select an income statement itemAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit	enter a dollar amount
select a closing name for section oneAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit		enter a total amount for section one
select a summarirzing line for the first partAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit		enter a total amount for the first part
select an opening name for section twoAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit
select an income statement itemAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit	enter a dollar amount
select an income statement itemAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit	enter a dollar amount
select an income statement itemAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit	enter a dollar amount
select a closing name for section twoAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit		enter a total amount for section two
select a closing name for this statementAdministrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesNet Income/(Loss)SalesSelling ExpensesTotal Fixed ExpensesTotal Variable ExpensesVariable ExpensesGross Profit		$enter a total net income or loss amount

eTextbook and Media

Part 2

New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is incorrect.

Calculate variable cost per bottle. (Round variable cost per bottle to 3 decimal places, e.g. 0.251.)

Variable cost per bottle

$enter Variable cost per bottle in dollars rounded to 3 decimal places

eTextbook and Media

Part 3

New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is incorrect.

Compute the break-even point in (1) units and (2) dollars. (Round answers to 0 decimal places, e.g. 1,225.)

(1)		Compute the break-even point		enter the break-even point in units	units
(2)		Compute the break-even point		$enter the break-even point in dollars

eTextbook and Media

Part 4

New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is incorrect.

Compute the contribution margin ratio and the margin of safety ratio. (Round variable cost per bottle to 3 decimal places, e.g. 0.25 and final answers to 0 decimal places, e.g. 25%.)

Contribution margin ratio		enter the contribution margin ratio in percentages rounded to 0 decimal places	%
Margin of safety ratio		enter the Margin of safety ratio in percentages rounded to 0 decimal places	%

eTextbook and Media

Part 5

New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is incorrect.

Determine the sales dollars required to earn net income of $240,000. (Round answer to 0 decimal places, e.g. 1,225.)

Required sales dollars

$enter the Required sales dollars

Solutions

Expert Solution

Sales Revenue		$ 16,50,000
Less Variable Expenses
Direct Material	$ 4,60,000
Direct Labor	$ 3,30,000
Manufacturing Overhead	$ 3,50,000
Selling Expenses	$ 76,500
Administrative expenses	$ 21,000
Total Variable Expenses		$ 12,37,500
Contribution Margin		$ 4,12,500
Less Fixed Expenses
Manufacturing Overhead	$ 1,80,000
Selling Expenses	$ 51,000
Administrative expenses	$ 99,000
Total Fixed Expenses		$ 3,30,000
Operating Income		$ 82,500

No of units sold = $1650000 / $0.50 = 3300000

Variable Cost per unit = $1237500 / 3300000 = $0.375 per unit

Contribution Margin per unit = $0.50 - $0.375 = $0.125

Break Even Point (Units) = Fixed Cost / Contribution Margin per unit
= $330000 / $0.125 = 2640000 units

Break Even Point (Dollars) = 2640000 x $0.50 = $1320000

Contribution Margin Ratio = Contribution Margin / Sales x 100
= $412500 / $1650000 x 100 = 25%

Margin of Safety = Sales - Break Even
= $1650000 - $1320000 = $330000

Margin of Safety Ratio = Margin of safety / Sales x 100
= $330000 / $1650000 x 100 = 20%

Sales Dollars to earn desired income = (Fixed Cost + Desired Income) / Contribution Margin ratio
= ($330000 + $240000) / 25% = $2280000

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

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

Ivanhoe Company bottles and distributes B-Lite, a diet sot drink. The beverage is sold for 50 per cent theme for the estimates the following revenues and costs Sales $1,650,000 Selling expenses variable $76,500 Direct materials 460,000 Selling expenses-food 51.000 Direct labor 330,000 Administrative expenses variable Manufacturing overhead variable 350,000 Administrative expenses 9,000 Manufacturing overhead-fixed 180,000.Home edugen.wileyplus.com/edugen/lti/main.uni Return to t S Weygandt, Managerial Accounting, 8e Help System Announcements Prepare a CVP income statement for 2020 based on management's estimates. IVANHOE COMPANY...

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

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...

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...

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...

Subjects