Brookline Manufacturing provided the following monthly data for the last year. The management wants to estimate variable cost per unit and total fixed costs using the high-low method and then predict future costs at given activity levels. Month Units Sold Total Cost Jan 180,000 $125,000 Feb 250,000 $160,000 Mar 100,000 $80,000 Apr 220,000 $145,000 May 140,000 $110,000 Jun 300,000 $200,000 Required: 1. Estimate the variable cost per unit and total fixed costs using the high-low method. 2. Predict total costs at future volumes of a) 200,000 units b) 280,000 units

Brookline Manufacturing provided the following monthly data for the last year. The management wants to estimate variable cost per unit and total fixed costs using the high-low method and then predict future costs at given activity levels. Month Units Sold Total Cost Jan 180,000 $125,000 Feb 250,000 $160,000 Mar 100,000 $80,000 Apr 220,000 $145,000 May 140,000 $110,000 Jun 300,000 $200,000 Required: 1. Estimate the variable cost per unit and total fixed costs using the high-low method. 2. Predict total costs at future volumes of a) 200,000 units b) 280,000 units

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter5: Activity-based Costing And Management

Section: Chapter Questions

Problem 16MCQ: Suppose that a company is spending 60,000 per year for inspecting, 30,000 for purchasing, and 40,000...

See similar textbooks

Similar questions

Suppose that a company is spending 60,000 per year for inspecting, 30,000 for purchasing, and 40,000 for reworking products. A good estimate of nonvalue-added costs would be a. 70,000. b. 130,000. c. 40,000. d. 90,000. e. 100,000.
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?
Suppose a company finds that shipping cost is 3,560 each month plus 6.70 per package shipped. What is the cost formula for monthly shipping cost? Identify the independent variable, the dependent variable, the fixed cost per month, and the variable rate.
Cadre, Inc., sells a single product with a selling price of $120 and variable costs per unit of $90. The companys monthly fixed expenses are $180,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of October when they will sell 10,000 units. How many units will Cadre need to sell in order to realize a target profit of $300,000? What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Construct a contribution margin income statement for the month of August that reflects $2,400,000 in sales revenue for Cadre, Inc.
Wellington, Inc., reports the following contribution margin income statement for the month of May. The company has the opportunity to purchase new machinery that will reduce its variable cost per unit by $10 but will increase fixed costs by 20%. Prepare a projected contribution margin income statement for Wellington, Inc., assuming it purchases the new equipment. Assume sales level remains unchanged.
Klamath Company produces a single product. The projected income statement for the coming year is as follows: Required: 1. Compute the unit contribution margin and the units that must be sold to break even. 2. Suppose 10,000 units are sold above break-even. What is the operating income? 3. Compute the contribution margin ratio. Use the contribution margin ratio to compute the break-even point in sales revenue. (Note: Round the contribution margin ratio to four decimal places, and round the sales revenue to the nearest dollar.) Suppose that revenues are 200,000 more than expected for the coming year. What would the total operating income be?
Schylar Pharmaceuticals, Inc., plans to sell 130,000 units of antibiotic at an average price of 22 each in the coming year. Total variable costs equal 1,086,800. Total fixed costs equal 8,000,000. (Round all ratios to four significant digits, and round all dollar amounts to the nearest dollar.) Required: 1. What is the contribution margin per unit? What is the contribution margin ratio? 2. Calculate the sales revenue needed to break even. 3. Calculate the sales revenue needed to achieve a target profit of 245,000. 4. What if the average price per unit increased to 23.50? Recalculate: a. Contribution margin per unit b. Contribution margin ratio (rounded to four decimal places) c. Sales revenue needed to break even d. Sales revenue needed to achieve a target profit of 245,000
Maple Enterprises sells a single product with a selling price of $75 and variable costs per unit of $30. The companys monthly fixed expenses are $22,500. What is the companys break-even point in units? What is the companys break-even point in dollars? Construct a contribution margin income statement for the month of September when they will sell 900 units. How many units will Maple need to sell in order to reach a target profit of $45,000? What dollar sales will Maple need in order to reach a target profit of $45,000? Construct a contribution margin income statement for Maple that reflects $150,000 in sales volume.
Kerr Manufacturing sells a single product with a selling price of $600 with variable costs per unit of $360. The companys monthly fixed expenses are $72,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of January when they will sell 500 units. How many units will Kerr need to sell in order to realize a target profit of $120,000? What dollar sales will Kerr need to generate in order to realize a target profit of $120,000? Construct a contribution margin income statement for the month of June that reflects $600,000 in sales revenue for Kerr Manufacturing.
Variable Cost Ratio, Contribution Margin Ratio Chillmax Company plans to sell 3,500 pairs of shoes at 60 each in the coming year. Unit variable cost is 21 (includes direct materials, direct labor, variable factory overhead, and variable selling expense). Fixed factory overhead is 30,000 and fixed selling and administrative expense is 48,000. Required: 1. Calculate the variable cost ratio. 2. Calculate the contribution margin ratio. 3. Prepare a contribution margin income statement based on the budgeted figures for next year. In a column next to the income statement, show the percentages based on sales for sales, total variable cost, and total contribution margin.
A company has prepared the following statistics regarding its production and sales at different capacity levels. Total costs: 1. At what point is break-even reached in sales dollars? In units? (Hint: Use the capacity level to determine the number of units.) 2. If the company is operating at 60% capacity, should it accept an offer from a customer to buy 10,000 units at 3 per unit?
The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.