Question

In: Accounting

Agnew Manufacturing produces and sells three models of a single product, Standard, Superior, and DeLuxe, in...

Agnew Manufacturing produces and sells three models of a single product, Standard, Superior, and DeLuxe, in a local market and in a regional market. At the end of the first quarter of the current year, the following income statement (in thousands of dollars) has been prepared.

Total Local Regional
Sales revenue $ 15,300 $ 11,790 $ 3,510
Cost of goods sold 12,105 9,315 2,790
Gross margin $ 3,195 $ 2,475 $ 720
Marketing costs 1,230 705 525
Administrative costs 606 465 141
Total marketing and administrative $ 1,836 $ 1,170 $ 666
Operating profits $ 1,359 $ 1,305 $ 54

Management has expressed special concern with the regional market because of the extremely poor return on sales. This market was entered a year ago because of excess capacity. It was originally believed that the return on sales would improve with time, but after a year, no noticeable improvement can be seen from the results as reported in the preceding quarterly statement.

In attempting to decide whether to eliminate the regional market, the following information has been gathered.

Products
Standard Superior DeLuxe
Sales revenue $ 5,900 $ 4,700 $ 4,700
Variable manufacturing costs as a percentage of sales revenue 60 % 70 % 60 %
Variable marketing costs as a percentage of sales revenue 2 2 2
Product Sales by Markets Local Regional
Standard $ 4,730 $ 1,170
Superior 3,530 1,170
DeLuxe 3,530 1,170

All administrative costs and fixed manufacturing costs would not be affected by eliminating the regional market. Marketing costs that are not listed as variable are fixed for the period and separable by market. Fixed marketing costs assigned to the regional market would be saved if that market were eliminated.

Required:

a. Assuming there are no alternative uses for Agnew's present capacity, would you recommend dropping the regional market?

b. Prepare the quarterly income statement showing contribution margins by products. Do not allocate fixed costs to products.

c. It is believed that a new model can be ready for sale next year if Agnew decides to go ahead with continued research. The new product would replace DeLuxe and can be produced by simply converting equipment presently used in producing the DeLuxe model. This conversion will increase fixed costs by $117,000 per quarter. What must be the minimum contribution margin per quarter for the new model to make the changeover financially feasible?

Solutions

Expert Solution

a.No, Should not be dropped as it is providing positive margin. Since allocated fixed cost is not avoidable, dropping the market will lead to higher loss of profits

Income Statement

Standard

Superior

Deluxe

Total

Sales Revenue

       5,900

       4,700

       4,700

       15,300

Less: Variable costs

Manufacturing

       3,540

       3,290

       2,820

          9,650

Marketing

           118

             94

             94

             306

Total variable costs

       3,658

       3,384

       2,914

          9,956

Contribution margin

       2,242

       1,316

       1,786

          5,344

c.Minimum Contribution margin from new product = Contribution margin from Deluxe + Increase in fixed costs

=1786,000+117,000

i.e. $1,903,000


Related Solutions

Agnew Manufacturing produces and sells three models of a single product, Standard, Superior, and DeLuxe, in...
Agnew Manufacturing produces and sells three models of a single product, Standard, Superior, and DeLuxe, in a local market and in a regional market. At the end of the first quarter of the current year, the following income statement (in thousands of dollars) has been prepared: Total Local Regional Sales revenue $ 7,800 $ 6,000 $ 1,800 Cost of goods sold 6,060 4,650 1,410 Gross margin $ 1,740 $ 1,350 $ 390 Marketing costs 630 360 270 Administrative costs 312...
Dunphy Inc. produces three models of a certain product: Standard, Deluxe, and Super. Relevant data: Standard...
Dunphy Inc. produces three models of a certain product: Standard, Deluxe, and Super. Relevant data: Standard Deluxe Super Sales in units 12,000 5,000 3,000 Price per unit 85 120 166 Variable cost per unit 34 45 84 Fixed costs are $1,000,000. a) Compute Dunphy's breakeven point in sales dollars with the current sales mix. b) Compute Dunphy's current margin of safety. c) What is forecast net income at sales of $2,400,000 given the current sales mix? d) Marketing Department has...
Dillon Inc. produces three models of a certain product: Standard, Deluxe, and Super. Relevant data: Standard...
Dillon Inc. produces three models of a certain product: Standard, Deluxe, and Super. Relevant data: Standard Deluxe Super Sales in units 12,000 5,000 3,000 Price per unit 85 120 166 Variable cost per unit 34 45 84 Fixed costs are $1,000,000. a) Compute Dillon Inc. breakeven point in sales dollars with the current sales mix. b) Compute Dillon Inc. current margin of safety. c) What is forecast net income at sales of $2,400,000 given the current sales mix? d) Marketing...
Katy Company manufactures three product models, Standard, Premium, and Deluxe. The following is the data for...
Katy Company manufactures three product models, Standard, Premium, and Deluxe. The following is the data for each product per week. Standard Premium Deluxe Total Maximum weekly demand (in units) 300 250 200 750 units Current weekly production (in units) 200 200 200 600 units Contribution margin per unit $40 $45 $60 Number of machine hours required 2 3 5 Maximum Machine hours per week 2,000 hours Required) a) What is the contribution margin per machine hour for each model? (10...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The company’s revenues and expenses for the last four months are given below. Central Valley Company Comparative Monthly Income Statements March April May June Sales in units 6,800 6,300 7,050 7,300 Sales revenue $ 829,600 $ 768,600 $ 860,100 $ 890,600 Less: Cost of goods sold 418,500 393,000 426,250 444,000 Gross margin 411,100 375,600 433,850 446,600 Less: Operating expenses Shipping expense 76,000 71,000 79,250 80,000...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The company’s revenues and expenses for the last four months are given below. Central Valley Company Comparative Income Statement March April May June   Sales in units 5,800 5,300 6,450 7,600   Sales revenue $ 742,400 $ 678,400 $ 825,600 $ 972,800 Less: Cost of goods sold 392,200 366,336 429,312 496,128 Gross margin $ 350,200 $ 312,064 $ 396,288 $ 476,672 Less: Operating Expenses            Shipping expense...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The company’s revenues and expenses for the last four months are given below. Central Valley Company Comparative Income Statement March April May June Sales in units 6,900 6,400 8,100 9,800 Sales revenue $ 793,500 $ 736,000 $ 931,500 $ 1,127,000 Less: Cost of goods sold 421,350 397,440 484,380 574,770 Gross margin $ 372,150 $ 338,560 $ 447,120 $ 552,230 Less: Operating Expenses Shipping expense $...
Rundle Manufacturing Company produces a single product. The following data apply to the standard cost of...
Rundle Manufacturing Company produces a single product. The following data apply to the standard cost of materials and labor associated with making the product: Materials quantity per unit 1 pound Materials price $ 6.10 per pound Labor quantity per unit 2 hours Labor price $ 10.10 per hour During the year, the company made 2,020 units of product. At the end of the year, the following variances had been calculated. Materials usage variance $ 1,159 Favorable Materials price variance $...
Genco Inc. makes a single product that sells for P50. The standard variable manufacturing cost is...
Genco Inc. makes a single product that sells for P50. The standard variable manufacturing cost is P32.50 and the standard fixed manufacturing cost is P7.50, based on producing 20,000 units. During the year Genco produced 22,000 units and sold 21,000 units. Actual fixed manufacturing costs were P157,000; actual variable manufacturing costs were P735,000. Selling and administrative expenses, all fixed, were P75,000. There were no beginning inventories.    a. What is the net income under the standard absorption costing income statement?...
Taylor Corporation produces two models of their leather brief cases: deluxe and standard. The four activities...
Taylor Corporation produces two models of their leather brief cases: deluxe and standard. The four activities and four drivers are as follows: Hours Activities: Cost Driver Deluxe Standard Total Cutting $ 96,000 Cutting hours 2,200 1,300 3,500 Assembling 42,000 Assembly hours 1,150 980 2,130 Inspecting 15,000 Inspection hours 800 500 1,300 Reworking 8,000 Rework hours 20 35 55 Required: Calculate the consumption ratios for the four drivers, rounding to 2 decimal places. Calculate the activity rates that would be used...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT