Based on the data presented in the Unit VIII Spreadsheet Template in Excel (CM Breakeven tab): • Calculate the contribution margin (CM) for each of the three products sold at the cookie business. • Calculate the weighted average CM. • Calculate the breakeven point.

Based on the data presented in the Unit VIII Spreadsheet Template in Excel (CM Breakeven tab): • Calculate the contribution margin (CM) for each of the three products sold at the cookie business. • Calculate the weighted average CM. • Calculate the breakeven point.

Name: Part 1: Based on the data presented in the Unit VIII Spreadsheet Templ
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: Part 1: Based on the data presented in the Unit VIII Spreadsheet Template in Excel (CM Breakeven tab):• Calculate the contribution margin (CM) for each of the three products sold at the cookie business.• Calculate the weighted average CM.• Calculate

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter6: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 2BE: Contribution margin Waite Company sells 250,000 units at 120 per unit. Variable costs are 78 per...

See similar textbooks

Similar questions

Variable costingsales exceed production The beginning inventory is 52,800 units. All of the units that were manufactured during the period and 52,800 units of the beginning inventory were sold. The beginning inventory fixed manufacturing costs are 14.70 per unit, and variable manufacturing costs are 30 per unit. Determine (A) whether variable costing operating income is less than or greater than absorption costing operating income, and (B) the difference in variable costing and absorption costing operating income.
Understanding CVP relationships Calculate the missing amounts for each of thefollowing firms:Units Selling Variable Costs Contribution Fixed OperatingSold Price per Unit Margin Costs Income (Loss)Firm A 11,200 $24.00 ? $100,800 $41,300 ?Firm B 8,400 ? $18.20 ? 64,500 $32,940Firm C ? 7.30 4.20 10,850 ? (6,750)Firm D 4,720 ? 51.25 41,064 48,210 ?
Consider the following information: Contribution to Sales (C/S) Ratio = 25% Selling Price per unit = K70 Total Fixed Costs = K140,000 Required: Calculate Contribution per Unit Variable cost per Unit Break Even Point in Quantity and Sales value terms
Compute the missing amounts. (Enter the contribution margin ratio to nearest percent, X%.) A Sale price per unit $2,100 Variable costs per unit 840 Total fixed costs 1,045,800 Target profit 1,600,200 Calculate: Contribution margin per unit Contribution margin ratio % Required units to break even Required sales dollars to break even Required units to achieve target profit
Evaluate the quantity at which revenue equals to costs (break-even point). <use Goal seek> Assumptions: Fixed cost: 5000 Material costs per item: 2.25 Labor costs per item: 6.5 Shipping costs per 100 items: 200 Price per item: 12.99
Contribution Margin: Unit Amounts Consider the following information on four independent companies. A B C D Sales $10,000 $? $? $9,000 Less: Variable costs 8,000 11,700 9,750 ? Contribution margin $2,000 $7,800 $? $? Less: Fixed costs ? 4,500 ? 900 Operating income $1,000 $? $8,000 $2,850 Units sold ? 1,300 300 500 Price/Unit $4 $? $? $? Variable cost/Unit $? $9 $? $? Contribution margin/Unit $? $6 $? $? Contribution margin ratio ? ? 75% ? Break-even in units ? ? ? ?
Please answer quicklyX product; total sales quantity is 25, unit sales price is 1600 TL, unit variable expense is 1000 TL. (Total fixed expenses 120.000TL)What is the 'break-even point' of X according to uniform production? 2310143019
For each of the three independent situations below computes the missing amounts S/No. Sales Variable costs Contribution margin per unit Fixed costs Operating income Units sold 1 ? 120,000 20 ? 25,000 4,000 2 180,000 ? ? 45,000 30,000 5,000 3 600,000 ? 30 150,000 90,000 ?
The contribution margin income statementa. reports expenses based on cost behavior pattern rather than cost function.b. unitizes fixed costs.c. shows contribution margin rather than operating income as the bottom line.d. is sometimes used for financial reporting purposes.e. none of the above.Use the following information for Questions 9 and 10.O’Brien, Inc.’s, 2013 contribution margin income statement shows thefollowing:Sales @ $10 per unit . . . . . . . . . . . . . $ 160,000Less: Variable expense . . . . . . . . . . . (128,000)Contribution margin. . . . . . . . . . . . . . $ 32,000Less: Fixed expenses . . . . . . . . . . . . (44,000)Operating income (loss) . . . . . . . . . . . $ (12,000)
Use the data to prepare the cost statement and income statement by use the variable cost . The production capacity ( 8 000 )unit , the seal price ( 2000 ) to unit . Direct materials ( 176000) Direct wages ( 128000 ). Direct expenses ( 132000 ) Indirect expenses ( 132000 ). ( 100 000 v. , 32 000 f. ). Marketing cost v. ( 100 000 )D. Administration cost 60000 D. Indirect marketing f. ( 100 000). The balance of f. g. f. ( 2500 ) unit , and the balance of f. g. l. ( 1000 ) unit . The number of sales unit ( ? ) unit
Matamad Inc. Provides you with the following data on its operation for analysis:Unit selling priceP40Variable costs and expenses per unit.P30Fixed cost and expenses per annum.P48,000REQUIRED:a. Contribution margin per unitb. Contribution margin percentagec. BEP sales volume (units)d. BEP peso salese. Peso sales with desired income of P9,000f. Peso sales with desired income P13,000 after 32% income tax
Y product; total sales quantity is 25, unit sales price is 1600 TL, unit variable expense is 1000 TL. (Total fixed expenses 120.000TL)What is the 'break-even point' of Y according to uniform production? 2310143019