Erosion costs. Heavenly Cookie Company reports the following annual sales and costs for its current product line: Click on this icon a to download the data from this table Chocolate Snicker- Peanut Lemon Cream- Chip doodle Butter Drop Filled Volume 251,000 205,000 142,000 83,000 98,000 S0.57 Price $0.40 $0.49 $0.52 $0.47 Cost $0.24 $0.20 $0.17 $0.22 $0.30 Heavenly is thinking of adding Mississippi Mud brownies to the product line. The ultra-rich brownies would sell for $0.97 a piece and cost $0.85 to produce. The forecasted brownie volume is 222,000 per year. Introduction of brownies, however, will reduce cookie sales by 186,000, with the following drops in sales per cookie: 100,000 in chocolate chip, 39,000 in snickerdoodle, 28,000 in peanut butter, 9,000 in lemon drop, and 10,000 in cream-filled. What is the erosion cost of introducing the brownies? What is the net change in annual margin if Mississippi Mud brownies are added to the product line?

Erosion costs. Heavenly Cookie Company reports the following annual sales and costs for its current product line: Click on this icon a to download the data from this table Chocolate Snicker- Peanut Lemon Cream- Chip doodle Butter Drop Filled Volume 251,000 205,000 142,000 83,000 98,000 S0.57 Price $0.40 $0.49 $0.52 $0.47 Cost $0.24 $0.20 $0.17 $0.22 $0.30 Heavenly is thinking of adding Mississippi Mud brownies to the product line. The ultra-rich brownies would sell for $0.97 a piece and cost $0.85 to produce. The forecasted brownie volume is 222,000 per year. Introduction of brownies, however, will reduce cookie sales by 186,000, with the following drops in sales per cookie: 100,000 in chocolate chip, 39,000 in snickerdoodle, 28,000 in peanut butter, 9,000 in lemon drop, and 10,000 in cream-filled. What is the erosion cost of introducing the brownies? What is the net change in annual margin if Mississippi Mud brownies are added to the product line?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Windows is a small company that installs windows. Its cost structure is as follows: LOADING... (Click the icon to view the cost structure.) Traylor Windows' breakeven revenues is $1,870,000 and breakeven units is 3,400. Calculate the margin of safety in units and dollars and the margin of safety percentage if Traylor Windows expects to sell 3,600 windows in the year. Begin with calculating the margin of safety in dollars. Determine the formula to calculate the margin of safety in dollars. Then, enter the amounts and calculate the margin of safety in dollars. Budgeted revenue - Breakeven revenue = Margin of safety in dollars - = Next, determine the formula, enter the amounts, and calculate the margin of safety in units. Budgeted units - Breakeven units = Margin of safety in units - = Finally, calculate the margin of safety percentage if…
On the Data Tables - Student tab in your Excel spreadsheet, update the given information section of the Income Statement for Hello Company with the data below: Income Statement Product A Product B Product C Max Capacity Units 42,000 7,000 3,000 52,000 Price per unit $ 11.00 $ 8.00 $ 60.00 Variable expense per unit $ 4.00 $ 2.00 $ 20.00 Total Fixed Costs $ 20,000 $ 40,000 $ 10,000 Required: 2. Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product based on the following scenarios. (Hint: Don't forget that the warehouse can only hold up to 52,000 units.) Scenario 1: Pete wants to find the mix of units that will result in the highest overall Operating Income, perform this analysis using a two variable data table. Product A can vary between 39,000 units and a maximum of 44,000 units. Product B can vary between 5,000 units…
A small company manufactures a certain item and sells it online. The company has a business model where the cost, C in dollars, to make x items is given by the equation C = 20/3 x + 50. The revenue R , in dollars , made by selling x items is given by the equation R = 10x. How many items must the company sell in order for the cost to equal their revenue?
Onawa Ltd manufactures a top-selling electronic spreadsheet product called Cell 123. Onawa is aboutto release version 8. It divides its customers into 2 groups: new customers and upgrade customers(those who previously purchased Cell 123, version 7 or earlier versions). Although the same physicalproduct is provided to each customer group, sizeable differences exist in selling prices and variablemarketing costs New customers Upgrade customers N$ N$ Selling price 210 120 Variable costs: Manufacturing (25) (25) Marketing (65) (15) The fixed costs of Cell 8 are N514 000 000. The planned ratio of new customers to upgrade customers isexpected to be 6:4 respectively requirement:a) Calculate Onawa Ltd individual break-even point both in units and sales revenue, assuming thatthe customers will come as planned.b) Ifthe planned sales mix is attained, calculate the operating income when 200 000 units are sold.c) The CVP analysis as any management tool has some limitations.…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Exhibit 1: Assumptions (Both Products) Product #1: Launch-it Sales price per unit $ 10.00 Variable costs per unit: $ 4.00 Monthly volume 240 Product #2: Treat-time Sales price per unit $ 30.00 Variable costs per unit: $ 14.00 Monthly volume 160 Total fixed costs per month $ 1,500.00 Target profit per month $ 8,000.00 Margin of Safety (in $) Margin of Safety % Degree of Operating Leverage Expected % change in operating income (%)
Using Excel for cost-volume-profit (CVP) analysis Download an Excel temp/ate for this problem online in MyAccountingLab or at http://www.pearsonhigheredcom/Horngren. The Oceanside Garden Nursery buys flowering plants in tour-inch pots for $1.00 each and sells them for $2.50 each. Management budgets monthly fixed costs of $2,100 for sales volumes between 0 and 5,000 plants. Requirements Use the contribution margin approach to compute the company’s monthly breakeven point in units. Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $5,000. Prepare a graph of the company’s CVP relationships. Include the sales revenue line, the fixed cost line, and the total cost line. Create a chart title and label the axes.
A local furniture company has estimated the following components for a new product. (in pesos) Fixed cost = 50,000Material cost per unit = 2.15Labor cost per unit = 2.00Revenue per unit = 7.50 Using spreadsheet, find the exact breakeven point. Attach excel solution. Group of answer choices 15, 380 units 14,875 units 14,925 units 15,030 units No choice given
Skip Consulting helped Schmidt Roofers put various cost saving techniques into place. Thecontract specifies that Skip will receive a flat fee of $70,000 and an additional $19,000 if Schmidtattains a target amount of cost savings. Skip estimates a 20% chance that Schmidt will reach thetarget for cost savings. Assuming that Skip uses the expected-value approach, what is thetransaction price for this product?a. $19,000b. $70,000c. $73,800d. $89,000
The controller for the Lillian Corporation created an Excel worksheet that included a profit calculation. The worksheet also contained a data table created using the What-if analysis tool to analyze the sales price, volume, and profit related to the graphics card the company manufactures. The worksheets are pictured next. Profit calculation 2 Sales price per unit $50 3 Less: Variable cost per unit $20 4 Contribution margin per unit $30 5 × Volume 700 6 Total contribution margin $21,000 7 Less: Fixed expenses $12,000 8 Operating income $9,000 9 10 Monthly target profit (minimum) $9,999 Data table 2 $9,000 $45 $50 $55 $60 $65 $70 3 900 $10,500 $15,000 $19,500 $24,000 $28,500 $33,000 4 850 $9,250 $13,500 $17,750 $22,000 $26,250 $30,500 5 800 $8,000 $12,000 $16,000 $20,000 $24,000 $28,000 6 750…
The controller for the Lillian Corporation created an Excel worksheet that included a profit calculation. The worksheet also contained a data table created using the What-if analysis tool to analyze the sales price, volume, and profit related to the graphics card the company manufactures. The worksheets are pictured next. Profit calculation 2 Sales price per unit $50 3 Less: Variable cost per unit $20 4 Contribution margin per unit $30 5 × Volume 700 6 Total contribution margin $21,000 7 Less: Fixed expenses $12,000 8 Operating income $9,000 9 10 Monthly target profit (minimum) $9,999 Data table 2 $9,000 $45 $50 $55 $60 $65 $70 3 900 $10,500 $15,000 $19,500 $24,000 $28,500 $33,000 4 850 $9,250 $13,500 $17,750 $22,000 $26,250 $30,500 5 800 $8,000 $12,000 $16,000 $20,000 $24,000 $28,000 6 750…
PLEASE INCLUDE THE EXCEL FORMULAS!! Thanks!! Please don't forget to check your worksheet by changing the units sold in the Data to 6,000 for Year 2 before submitting the response to my question. The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn’t, check cell C41. The formula in this cell should be =IF(C26<C27,C26*C36+(C27-C26)*B36,C27*C36).] If your worksheet is operating properly, the net operating income under both absorption costing and variable costing should be $(34,000) for Year 2. That is, the loss in Year 2 is $34,000 under both methods. If you do not get these answers, find the errors in your worksheet and correct them. Assume that the units produced in year 2 were sold first. If someone can help I will give a thumbs up. Thanks for the help! :)
Staley Co. manufactures computer monitors. The following is a summary of its basic cost and revenue data: PerUnit Percent Sales price $ 460 100.00 Variable costs 237 51.52 Unit contribution margin $ 223 48.48 Assume that Staley Co. is currently selling 590 computer monitors per month and monthly fixed costs are $79,800.Staley Co.'s margin of safety ratio (MOS%) if 590 units are sold would be (round intermediate calculation up to nearest whole number of units):