High-Low Method; Contribution Format Income Statement [LO 2-5, LO 2-6]
Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas.
Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow:
Milden Company’s president would like a cost formula derived for shipping expense so that a
Required:
- Using the high-low method, estimate a cost formula for shipping expense.
- In the first quarter of Year 3, the company plans to sell 12,000 units at a selling price of $100 per unit. Prepare a contribution format income statement for the quarter.
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
MANAGERIAL ACCT.F/MANAGERS>CUSTOM<
- Scarce resource; discontinued product lines; negative contribution marginThe officers of Bardwell Company are reviewing the profitability of the company’s four products and the potential effects of several proposals for varying the product mix. The following is an excerpt from the income statement and other data. Total Product P Product Q Product R Product S Sales $187,800 $30,000 $54,000 $37,800 $66,000 Cost of goods sold (132,822) (14,250) (21,168) (41,904) (55,500) Gross profit $54,978 $15,750 $32,832 $(4,104) $10,500 Operating expenses (36,012) (5,970) (8,904) (8,478) (12,660) Income before taxes 18,966 $9,780 $23,928 $(12,582) $(2,160) Units sold 3,000 3,600 5,400 6,000 Sales price per unit $10.00 $15.00 $7.00 $11.00 Variable cost of goods sold 2.50 3.00 6.50 6.00 Variable operating expenses 1.17 1.25 1.00 1.20 Each of the following proposals is to be considered independently of the other proposals. Consider only the product changes stated in…arrow_forwardScarce resource; discontinued product lines; negative contribution marginThe officers of Bardwell Company are reviewing the profitability of the company’s four products and the potential effects of several proposals for varying the product mix. The following is an excerpt from the income statement and other data. Total Product P Product Q Product R Product S Sales $187,800 $30,000 $54,000 $37,800 $66,000 Cost of goods sold (132,822) (14,250) (21,168) (41,904) (55,500) Gross profit $54,978 $15,750 $32,832 $(4,104) $10,500 Operating expenses (36,012) (5,970) (8,904) (8,478) (12,660) Income before taxes 18,966 $9,780 $23,928 $(12,582) $(2,160) Units sold 3,000 3,600 5,400 6,000 Sales price per unit $10.00 $15.00 $7.00 $11.00 Variable cost of goods sold 2.50 3.00 6.50 6.00 Variable operating expenses 1.17 1.25 1.00 1.20 Each of the following proposals is to be considered independently of the other proposals. Consider only the product changes stated in…arrow_forwardThe 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)arrow_forward
- Paty Ltd operating business of shipping it is contemplating two cost structures for its operations. A. The plan has high variable cost pu shipped with lower annual fixed costsB. The plan has lower variable cost with higher fixed cost.Details of Cost:Plan A:Per shipment revenue=100Variable cost per shipment delivered=85Contribution=15Annual fixed cost=1,200,000Plan B:Per shipment revenue=100Variable cost per shipment delivered=60Contribution=40Annual fixed cost=4,500,000Required:1.BEP (In volumes) for both the plans2.Under plan A to produce an operating income of 30,000, how many shipments to be made.3. Shipments to be made under plan A to produce an operating margin which is equal to 9% of sales revenue in total.arrow_forwardIdentify each cost below as variable (V), fixed (F), or mixed (M), relative to units sold. Explain your reasons Reason $ M Units Sold a. Total phone cost b. Materials cost per unit C. Manager's salary d. Depreciation cost per unit e. Total utility cost f. Total cost of goods sold 25 150 $ 35 3,000 60 400 3,125 50 200 $ 35 3,000 75 100V, F, or M 250 $ 300 35 35 3,000 3,000 2015 900 1,150 9,375 12,500 F 30 650 6,250 reasons 1. Does not change in total over wide ranges of volume/inversely proportional to the number of units produced while total cost remains constant. 2- It is directly proportional to the number of units produced. The total cost changes as volume changes and in direct proportion. 3-The total cost changes as volume changes, but not in direct proportion.arrow_forwardA tile manufacturer has supplied the following data: 1. What is the company's unit contribution margin? $0.86B. $2.35C. $4.10D. $1.75 2. The company's contribution margin ratio is closest to: 42.7%B. 57.3%C. 45.8%D. 21.0% 3. If the company increases its unit sales volume by 3% without increasing its fixed expenses, then total net operating income should be closest to: $459,380B. $453,667C. $13,380D. $482,660arrow_forward
- Question Content Area Sales Mix and Break-Even Analysis Olmstead Company has fixed costs of $2,170,920. The unit selling price, variable cost per unit, and contribution margin per unit for the company's two products follow: Product Selling Price Variable Cost per Unit Contribution Margin per Unit QQ $700 $380 $320 ZZ 940 760 180 The sales mix for Products QQ and ZZ is 35% and 65%, respectively. Determine the break-even point in units of QQ and ZZ. If required, round your answers to the nearest whole number. a. Product QQ fill in the blank 1 unitsb. Product ZZ fill in the blank 2 unitsarrow_forwardIdentification of variable, semi-variable, and fixed costs.*Provide total VC/unit, total FC, and Semi-VC here as well. q 1. Breakeven in units. q 2. Breakeven in Sales q 3. Units including Target profit q 4. Income statement as at Dec.31, 202x V&A Carpet cleaning (Finney Franchise) based on units from Q3 with target profitarrow_forwardVariable and Fixed Costs, Cost Formula, High-Low Method Li Ming Yuan and Tiffany Shaden are the department heads for the accounting department and human resources department, respectively, at a large textile firm in the southern United States. They have just returned from an executive meeting at which the necessity of cutting costs and gaining efficiency has been stressed. After talking with Tiffany and some of her staff members, as well as his own staff members, Li Ming discovered that there were a number of costs associated with the claims processing activity. These costs included the salaries of the two paralegals who worked full time on claims processing, the salary of the accountant who cut the checks, the cost of claims forms, checks, envelopes, and postage, and depreciation on the office equipment dedicated to the processing. Some of the paralegals time appears to vary with the routine processing of uncontested claims, but considerable time also appears to be spent on the claims that have incomplete documentation or are contested. The accountants time appears to vary with the number of claims processed. Li Ming was able to separate the costs of processing claims from the costs of running the departments of accounting and human resources. He gathered the data on claims processing cost and the number of claims processed per month for the past 6 months. These data are as follows: Required: 1. Classify the claims processing costs that Li Ming identified as variable and fixed. 2. What is the independent variable? The dependent variable? 3. Use the high-low method to find the fixed cost per month and the variable rate. What is the cost formula? 4. CONCEPTUAL CONNECTION Suppose that an outside company bids on the claims processing business. The bid price is 4.60 per claim. If Tiffany expects 75,600 claims next year, should she outsource the claims processing or continue to do it in-house?arrow_forward
- Sensitivity Cost-Volume-Profit Analysis and Production Versus Period Costs, Multiple-Product Setting If both the variable and fixed production costs (refer to your answer to Requirement 1) associated with the canoe product line increased by 5% (beyond the estimate from the high-low analysis), how many canoes and paddles would need to be sold in order to earn a target income of 96,000? Assume the same sales mix and additional fixed costs as in Requirement 3.arrow_forwardManufacturing builds and sells switch harnesses for glove boxes. The sales price and variable cost for each follows: Their sales mix is reflected in the ratio 4:4:1. What is the overall unit contribution margin for JJ Manufacturing with their current product mix?arrow_forwardEvaluating selling and administrative cost allocations Gordon Gecco Furniture Company has two major product lines with the following characteristics: Commercial office furniture: Few large orders, little advertising support, shipments in full truckloads, and low handling complexity Home office furniture: Many small orders, large advertising support, shipments in partial truckloads, and high handling complexity The company produced the following profitability report for management: The selling and administrative expenses are allocated to the products on the basis of relative sales dollars. Evaluate the accuracy of this report and recommend an alternative approach.arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College