Question

In: Accounting

Problem 1-23A High-Low Method; Contribution Format Income Statement [LO1-5, LO1-6] Milden Company has an exclusive franchise...

Problem 1-23A High-Low Method; Contribution Format Income Statement [LO1-5, LO1-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: Cost Cost Formula Cost of good sold $30 per unit sold Advertising expense $180,000 per quarter Sales commissions 7% of sales Shipping expense ? Administrative salaries $90,000 per quarter Insurance expense $10,000 per quarter Depreciation expense $60,000 per quarter 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: Quarter Units Sold Shipping Expense Year 1: First 26,000 $ 170,000 Second 28,000 $ 185,000 Third 33,000 $ 227,000 Fourth 29,000 $ 190,000 Year 2: First 27,000 $ 180,000 Second 30,000 $ 195,000 Third 40,400 $ 242,000 Fourth 37,400 $ 218,000 Milden Company’s president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter. Required: 1. Using the high-low method, estimate a cost formula for shipping expense based on the data for the last eight quarters above. 2. In the first quarter of Year 3, the company plans to sell 35,000 units at a selling price of $60 per unit. Prepare a contribution format income statement for the quarter. (Do not round your intermediate calculations.)

Solutions

Expert Solution


Related Solutions

Problem 1-25 Traditional and Contribution Format Income Statements [LO1-6] Milden Company is a merchandiser that plans...
Problem 1-25 Traditional and Contribution Format Income Statements [LO1-6] Milden Company is a merchandiser that plans to sell 31,000 units during the next quarter at a selling price of $55 per unit. The company also gathered the following cost estimates for the next quarter: Cost Cost Formula Cost of good sold $25 per unit sold Advertising expense $175,000 per quarter Sales commissions 6% of sales Shipping expense $60,000 per quarter + $5.00 per unit sold Administrative salaries $85,000 per quarter...
Problem 1-25 Traditional and Contribution Format Income Statements [LO1-6] Milden Company is a merchandiser that plans...
Problem 1-25 Traditional and Contribution Format Income Statements [LO1-6] Milden Company is a merchandiser that plans to sell 31,000 units during the next quarter at a selling price of $58 per unit. The company also gathered the following cost estimates for the next quarter: Cost Cost Formula Cost of good sold $28 per unit sold Advertising expense $178,000 per quarter Sales commissions 5% of sales Shipping expense $48,000 per quarter + $5.00 per unit sold Administrative salaries $88,000 per quarter...
Problem 1-25 Traditional and Contribution Format Income Statements [LO1-6] Milden Company is a merchandiser that plans...
Problem 1-25 Traditional and Contribution Format Income Statements [LO1-6] Milden Company is a merchandiser that plans to sell 31,000 units during the next quarter at a selling price of $58 per unit. The company also gathered the following cost estimates for the next quarter: Cost Cost Formula Cost of good sold $28 per unit sold Advertising expense $178,000 per quarter Sales commissions 5% of sales Shipping expense $48,000 per quarter + $5.00 per unit sold Administrative salaries $88,000 per quarter...
1. Milden Company is a distributor who wants to start using a contribution format income statement...
1. Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas: Cost Cost Formula Cost of good sold $25 per unit sold Advertising expense $175,000 per quarter Sales commissions 7% of sales Shipping expense ? Administrative salaries $85,000 per quarter Insurance expense $9,500 per quarter Depreciation expense $55,000 per quarter Because shipping expense is a mixed cost, the company needs...
Problem 1-19 Traditional and Contribution Format Income Statements [LO1-6] Todrick Company is a merchandiser that reported...
Problem 1-19 Traditional and Contribution Format Income Statements [LO1-6] Todrick Company is a merchandiser that reported the following information based on 1,000 units sold: Sales $ 285,000 Beginning merchandise inventory $ 19,000 Purchases $ 190,000 Ending merchandise inventory $ 9,500 Fixed selling expense $ ? Fixed administrative expense $ 11,400 Variable selling expense $ 14,250 Variable administrative expense $ ? Contribution margin $ 57,000 Net operating income $ 17,100 Required: 1. Prepare a contribution format income statement. 2. Prepare a...
Problem 1-19 Traditional and Contribution Format Income Statements [LO1-6] Todrick Company is a merchandiser that reported...
Problem 1-19 Traditional and Contribution Format Income Statements [LO1-6] Todrick Company is a merchandiser that reported the following information based on 1,000 units sold: Sales $ 285,000 Beginning merchandise inventory $ 19,000 Purchases $ 190,000 Ending merchandise inventory $ 9,500 Fixed selling expense $ ? Fixed administrative expense $ 11,400 Variable selling expense $ 14,250 Variable administrative expense $ ? Contribution margin $ 57,000 Net operating income $ 17,100 Required: 1. Prepare a contribution format income statement. 2. Prepare a...
Question 6: Milden Company has an exclusive franchise to purchase a product from the manufacturer and...
Question 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:   Cost Cost Formula   Cost of good sold    $27 per unit sold   Advertising expense    $184,000 per quarter   Sales commissions    7% of...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 5,500 6,000 6,500 Sales $ 577,500 $ 630,000 $ 682,500 Cost of goods...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 6,000 6,500 7,000 Sales $ 570,000 $ 617,500 $ 665,000 Cost of goods...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 8,500 9,000 9,500 Sales $ 850,000 $ 900,000 $ 950,000 Cost of goods...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT