Sinbad manufactures decorative iron railings. In preparing for next year's operations, management has developed the following estimates: (LO# 3) Units Total Per unit Sales 20,000 1,000,000 50 Variable Expenses 600,000 30 СМ 400,000 20 Total Fixed Expenses 110,000 Operating Profit 290,000 Required: EXCEL Compute the following items: a. Unit contribution margin. b. Contribution margin ratio. c. Break-even in units and dollar sales. d. Margin of safety in dollar amount and percentage. e. If the sales volume increases by 20% with no change in total fixed expenses, what will be the change in net operating income? Verify your answer f. If the per unit variable production costs increase by 15%, and if fixed selling and administrative expenses increase by 12%, what will be the new break-even point in dollar sales? g. if the company would like to achieve a profit of $90,000 next year, what would be the break-even point in units and dollar amount to earn that target? h. If monthly sales increase by $80,000 and there is no change in fixed expenses, by how much would you expect monthly net operating income to increase?

Sinbad manufactures decorative iron railings. In preparing for next year's operations, management has developed the following estimates: (LO# 3) Units Total Per unit Sales 20,000 1,000,000 50 Variable Expenses 600,000 30 СМ 400,000 20 Total Fixed Expenses 110,000 Operating Profit 290,000 Required: EXCEL Compute the following items: a. Unit contribution margin. b. Contribution margin ratio. c. Break-even in units and dollar sales. d. Margin of safety in dollar amount and percentage. e. If the sales volume increases by 20% with no change in total fixed expenses, what will be the change in net operating income? Verify your answer f. If the per unit variable production costs increase by 15%, and if fixed selling and administrative expenses increase by 12%, what will be the new break-even point in dollar sales? g. if the company would like to achieve a profit of $90,000 next year, what would be the break-even point in units and dollar amount to earn that target? h. If monthly sales increase by $80,000 and there is no change in fixed expenses, by how much would you expect monthly net operating income to increase?

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter3: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 9PB: Fire Company is a service firm with current service revenue of $900,000 and a 40% contribution...

See similar textbooks

Similar questions

Company A has current sales of $4,000,000 and a 45% contribution margin. Its fixed costs are $600,000. Company B is a service firm with current service revenue of $2,800,000 and a 15% contribution margin. Company Bs fixed costs are $375,000. Compute the degree of operating leverage for both companies. Which company will benefit most from a 15% increase in sales? Explain why.
The cost data for Evencoat Paint for the year 2019 is as follows: Using the high-low method, express the companys maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Predict the maintenance costs i190,000 gallons of paint are produced. Predict the maintenance costs if 81,000 gallons of paint are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between gallons of paint produced and equipment maintenance expenses.
Contribution margin, break-even sales, cost-volume-profit chart, margin of safety, and operating leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows: It is expected that 12,000 units will be sold at a price of 240 a unit. Maximum sales within the relevant range are 18,000 units. Instructions 1. Prepare an estimated income statement for 20Y7. 2. What is the expected contribution margin ratio? 3. Determine the break-even sales in units and dollars. 4. Construct a cost-volume-profit chart indicating the break-even sales. 5. What is the expected margin of safety in dollars and as a percentage of sales? (Round to one decimal place.) 6. Determine the operating leverage.
Fire Company is a service firm with current service revenue of $900,000 and a 40% contribution margin. Its fixed costs are $200,000. Ice Company has current sales of $420,000 and a 30% contribution margin. Its fixed costs are $90,000. What is the margin of safety for Fire and Ice? Compare the margin of safety in dollars between the two companies. Which is stronger? Compare the margin of safety in percentage between the two companies. Now which one is stronger? Compute the degree of operating leverage for both companies. Which company will benefit most from a 10% increase in sales? Explain why. Illustrate your findings in an Income Statement that is increased by 10%.
Markham Farms reports the following contribution margin income statement for the month of August. The company has the opportunity to purchase new machinery that will reduce its variable cost per unit by $2 but will increase fixed costs by 15%. Prepare a projected contribution margin income statement for Markham Farm assuming it purchases the new equipment. Assume sales level remains unchanged.
Katayama Company produces a variety of products. One division makes neoprene wetsuits. The divisions projected income statement for the coming year is as follows: Required: 1. Compute the contribution margin per unit, and calculate the break-even point in units. Repeat, using the contribution margin ratio. 2. The divisional manager has decided to increase the advertising budget by 140,000 and cut the average selling price to 200. These actions will increase sales revenues by 1 million. Will this improve the divisions financial situation? Prepare a new income statement to support your answer. 3. Suppose sales revenues exceed the estimated amount on the income statement by 612,000. Without preparing a new income statement, determine by how much profits are underestimated. 4. How many units must be sold to earn an after-tax profit of 1.254 million? Assume a tax rate of 34 percent. (Round your answer up to the next whole unit.) 5. Compute the margin of safety in dollars based on the given income statement. 6. Compute the operating leverage based on the given income statement. (Round to three significant digits.) If sales revenues are 20 percent greater than expected, what is the percentage increase in profits?
A company is spending 70,000 per year for inspecting, 60,000 per year for purchasing, and 56,000 per year for reworking products. What is a good estimate of non-value-added costs? a. 126,000 b. 70,000 c. 56,000 d. 130,000
Cost-Volume-Profit, Margin of Safety Victoria Company produces a single product. Last years income statement is as follows: Required: 1. Compute the break-even point in units and sales dollars calculated using the break-even units. 2. What was the margin of safety for Victoria last year in sales dollars? 3. Suppose that Victoria is considering an investment in new technology that will increase fixed cost by 250,000 per year but will lower variable costs to 45% of sales. Units sold will remain unchanged. Prepare a budgeted income statement assuming that Victoria makes this investment. What is the new break-even point in sales dollars, assuming that the investment is made?
Bolger and Co. manufactures large gaskets for the turbine industry. Bolgers per-unit sales price and variable costs for the current year are as follows: Bolgers total fixed costs aggregate to 360,000. Bolgers labor agreement is expiring at the end of the year, and management is concerned about the effects of a new labor agreement on its break-even point in units. The controller performed a sensitivity analysis to ascertain the estimated effect of a 10-per-unit direct labor increase and a 10,000 reduction in fixed costs. Based on these data, the break-even point would: a. decrease by 1,000 units. b. decrease by 125 units. c. increase by 375 units. d. increase by 500 units.
Faldo Company produces a single product. The projected income statement for the coming year, based on sales of 200,000 units, is as follows: Required: 1. Compute the unit contribution margin and the units that must be sold to break even. Suppose that 30,000 units are sold above the break-even point. What is the profit? 2. Compute the contribution margin ratio and the break-even point in dollars. Suppose that revenues are 200,000 greater than expected. What would the total profit be? 3. Compute the margin of safety in sales revenue. 4. Compute the operating leverage. Compute the new profit level if sales are 20 percent higher than expected. 5. How many units must be sold to earn a profit equal to 10 percent of sales? 6. Assume the income tax rate is 40 percent. How many units must be sold to earn an after-tax profit of 180,000?
The production of a new product required Zion Manufacturing Co. to lease additional plant facilities. Based on studies, the following data have been made available: Estimated annual sales24,000 units Selling expenses are expected to be 5% of sales, and net income is to amount to 2.00 per unit. Required: 1. Calculate the selling price per unit. (Hint: Let X equal the selling price and express selling expense as a percentage of X.) 2. Prepare an absorption costing income statement for the year ended December 31, 2016. 3. Calculate the break-even point expressed in dollars and in units, assuming that administrative expense and factory overhead are all fixed but other costs are fully variable.
The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include: Fixed costs (salaries, tools): 64,900 per year Variable costs (supplies): 1.35 per maintenance hour Estimated usage by: Actual usage by: Required: 1. Calculate a single charging rate for the Maintenance Department. 2. Use this rate to assign the costs of the Maintenance Department to the user departments based on actual usage. Calculate the total amount charged for maintenance for the year. 3. What if the Assembly Department used 4,000 maintenance hours in the year? How much would have been charged out to the three departments?