Question

Question: Current situation Patterson has remained profitable, but its return on investment has been declining. The...

Question:

Current situation

Patterson has remained profitable, but its return on investment has been declining. The number of new products introduced has fallen as has the number of improvements to existing products. Whereas the firm once manufactured over two hundred products classified into six product categories, the firm now manufactures less than one hundred products in four categories. Only twelve of the products have current annual sales volumes exceeding $1 million. Further, many of the firm's once unique products now face substantial competition. However, the firm still has excellent relations with its employees. Although the union is strong, its primary focus has been on maintaining the firm's attractive wages and benefits. The union has been very flexible in allowing changes in duties and work rules to accommodate changing market needs. This flexibility has been one of the reasons Patterson has manufactured all of its products locally.

Columbia's CEO recently asked Patterson Manufacturing to seek ways to improve Patterson's profitability. Patterson's manager, in turn, appointed a multi-disciplinary task force to explore the possibilities. The task force was instructed to consider the widest possible set of options: expansion, acquisitions, down sizing, diversification, implementing manufacturing efficiencies, relocating production ... "Whatever it takes!"

After several meetings the task force focussed on outsourcing Patterson's largest selling product. Sales of this product benefit from Patterson's reputation for high quality, but the team is aware that several competitors offer a similar product at a lower price. This competition has resulted in a slow, but steady decline in market share for nearly a decade. However this single product still accounts for nearly 30% of Patterson's total production volume and sales.

The task force believes that a reduction in the cost to produce the product, coupled with a lowered selling price would quickly recapture market share leading to increased profitability. They have sent a recommendation to Patterson's manager that this product be acquired at a lower cost from an off-shore firm.

Patterson's manager has some misgivings with the recommendation and has asked you to prepare an analysis of the viability of the task force's recommendation. You have just recently been hired by the company and are keen to make a good impression from your first significant task. You obtained last year's summary income statement given in Exhibit 1. The human resources department provided the summary given in Exhibit 2. It provides the number of employees working in each of several categories along with their average compensation.

A detailed study of the product under scrutiny reveals that sales of the product amounted to $27 million last year. The direct material costs associated with the product came to $14.3 million while overhead costs of $4.5 million were allocated to the product. In answer to a question, an accounting colleague indicated that only $2.9 million of the overhead would be avoided if the firm stops manufacturing the product. The remaining overhead costs are nearly all fixed and not subject to reduction in the near future. Direct selling costs for the product consist of an 8% commission paid to our sales representatives. In addition there is a $2 million advertising allowance devoted to promoting the product in trade magazines.

You have determined that if the product is outsourced, Patterson will reduce the number of administrative managers by three and administrative support staff by eight. In addition, 10 supervisors and 128 general production personnel will be let go. The firm will incur a one-time charge of $2.5 million for severance pay, pension contributions and the construction of receiving facilities for the outsourced product.

Several potential suppliers were asked to submit proposals for supplying the product. The proposals are all very similar and reflect only minor savings in material costs but they all envisage major savings in labour costs. The preferred supplier's proposal is given in Exhibit 3. It details the proposed price for supplying the product in the quantity sold last year. The supplier indicates that $2 million of the overhead and all of the "other" costs in the proposal are fixed costs. If Patterson changes the quantity of product it acquires, a new unit price will be calculated based on a 10% mark-up over total cost. In addition to the quoted selling price there will also be a cost to transport the product from the point of manufacture to Patterson's receiving facility. This cost will vary directly with the volume of products shipped. At last year's volume the transportation cost is expected to be $0.6 million.

As you gathered the information for your analysis, you discovered that the marketing manager is a vocal critic of the task force's recommendation. She is related to the Patterson family and has lived her entire life in the local community. "This proposed action would be a devastating blow to the community. Patterson Manufacturing has never reduced employment except by attrition. Wesley Patterson would not have approved this action. He loved this town and devoted his life to it. We must abandon this plan and turn our attention to alternate means of increasing profitability."

Exhibit 1: Summary Income Statement for Patterson Manufacturing

                                                                                                           $ (millions)

                                            Sales                                                   90.2

                                            Cost of Goods Sold                         74.3

                                            Gross Margin                                    15.9

                                            Administrative Costs                         1.2

                                            Selling Costs                                       9.2

                                             Operating Income                           5.5

All figures are in millions of dollars. Interest expenses and income taxes are only shown on Columbia's consolidated financial statements.

Exhibit 2: Current Distribution of Employees by Job Title

                Number                                                                                                    Average

                      Of                                                                                               Compensation

              Employees                                  Job Title                                       Per Employee

                                                                                                                                          $

                      10                Administrative Manager                              45,000

                      24                Administrative Staff                                                     32,000

                      30 Production Supervisor                                                 50,000

                    430               General Production Personnel                                 37,000

Exhibit 3: Off-Shore Supplier's Proposal

                                                                                                            $ (millions)

                                            Material Costs                                  12.7

                                            Labour Cost                                        1.8

                                            Overhead Costs                                2.7

                                            Other Costs                                         1.5

                                            Total Cost                                         18.7

                                            Profit Mark-Up (10%)                       1.9

                                             Invoice Price                                     20.6

All figures are in millions of dollars. The invoice price is quoted based on supplying last year's production volumes. The quoted price is FOB the manufacturing plant.

Required

1.     If the product is outsourced the task force recommends decreasing the product's selling price by 5% with the anticipation that unit sales volume will increase by 15%. Prepare an analysis which determines whether this outsourcing plan is financially viable.

15 Marks

Homework Answers

Answer #1



Here it is advisble for the company to outsource the product because it is beneficial more than the manufacturing itself. Here there is a additional cost of $2.5 million which will impact its benefit in first year but this is one time cost means the benefit will company acheive is for longer period. Hence the outsourcing of product is advisable.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Tony Hawk Inc. (Hawk) is a wholesale distributor supplying moderately priced sporting equipment to large chain...
Tony Hawk Inc. (Hawk) is a wholesale distributor supplying moderately priced sporting equipment to large chain stores. Hawk manufacturers and sells 20,000 tackle boxes annually, making full use of its direct labour capacity at available workstations. Following are the selling price and costs associated with Hawk’s tackle boxes: Selling price per box $86.00 Costs per box:    Direct material $17.00    Direct labour 18.75    Fixed manufacturing overhead:       Depreciation on equipment ($65,000 / 20,000) 3.25       Production supervisor’s salary ($185,000 /...
Company XYZ is considering outsourcing their Product A. Facts: 1) Product A makes up 30% of...
Company XYZ is considering outsourcing their Product A. Facts: 1) Product A makes up 30% of a companies sales revenue and production volume 2) By reducing sales price 5%, can increase unit sales volume by 15% 3) Product A sales were $27 million last year 4) Direct material costs for Product A were $14.3 million and overhead costs were $4.2 million 5) If product is outsourced, only $2.9 million overhead will be avoided 6) Direct selling costs are 8% commission...
1: Gabuat Corporation, which has only one product, has provided the following data concerning its most...
1: Gabuat Corporation, which has only one product, has provided the following data concerning its most recent month of operations: Selling price $ 138 Units in beginning inventory 0 Units produced 2,600 Units sold 2,310 Units in ending inventory 290 Variable costs per unit: Direct materials $ 49 Direct labor $ 27 Variable manufacturing overhead $ 6 Variable selling and administrative expense $ 6 Fixed costs: Fixed manufacturing overhead $36,400 Fixed selling and administrative expense $13,860 The total gross margin...
Grover Company has the following data for the production and sale of 2,600 units.    Sales...
Grover Company has the following data for the production and sale of 2,600 units.    Sales price per unit $ 800 per unit Fixed costs: Marketing and administrative $ 390,000 per period Manufacturing overhead $ 325,000 per period Variable costs: Marketing and administrative $ 45 per unit Manufacturing overhead $ 75 per unit Direct labor $ 115 per unit Direct materials $ 260 per unit What is the full cost per unit of making and selling the product? Multiple Choice...
Krazy Inc manufactures industrial components. One of its products, Double Krazy, has the following production data:...
Krazy Inc manufactures industrial components. One of its products, Double Krazy, has the following production data: Per Unit Selling price $180 Direct materials $29 Direct labor $5 Variable manufacturing overhead $4 Fixed manufacturing overhead $21 Variable selling expense $2 Fixed selling and administrative expense $17 The above per unit data are based on annual production of 4,000 units of Double Krazy. 16. The company has received a special, one-time-only order for 500 units. There would be no variable selling expense...
1. Lenart Corporation has provided the following data for its two most recent years of operation:...
1. Lenart Corporation has provided the following data for its two most recent years of operation: Manufacturing costs: Variable manufacturing cost per unit produced: Direct materials $ 13 Direct labor $ 6 Variable manufacturing overhead $ 4 Fixed manufacturing overhead per year $ 70,000 Selling and administrative expenses: Variable selling and administrative expense per unit sold $ 6 Fixed selling and administrative expense per year $ 83,000 Year 1 Year 2 Units in beginning inventory 0 1,000 Units produced during...
QUESTION 18 Aaron Corporation, which has only one product, has provided the following data concerning its...
QUESTION 18 Aaron Corporation, which has only one product, has provided the following data concerning its most recent month of operations: Selling price $ 90 Units in beginning inventory 0 Units produced 3,400 Units sold 3,000 Units in ending inventory 400 Variable costs per unit: Direct materials $ 21 Direct labor $ 38 Variable manufacturing overhead $ 6 Variable selling and administrative expense $ 4 Fixed costs: Fixed manufacturing overhead $ 54,400 Fixed selling and administrative expense $ 3,000 What...
. Lee Corporation, which has only one product, has provided the following data concerning its most...
. Lee Corporation, which has only one product, has provided the following data concerning its most recent month of operations: Selling price $95 Units in beginning inventory 100 IJnits produced 6,200 Units sold 5,900 Units in ending inventory 400 Variable costs per unit: Direct materials $42 Direct labor $28 Variable manufacturing overhead $1 Variable selling and administrative $5 Fixed costs: Fixéd manufacturing overhead $62,000 Fixed selling and administrative $35,400 The company produces the same number of units every month, although...
which has only one product, has provided the following data concerning its most recent month of...
which has only one product, has provided the following data concerning its most recent month of operations: Selling price $118 Units in beginning inventory 400 Units produced 2,100 Units sold 2,300 Units in ending inventory 200 Variable costs per unit: Direct materials $37 Direct labor $23 Variable manufacturing overhead $3 Variable selling and administrative expense $5 Fixed costs: Fixed manufacturing overhead $73,500 Fixed selling and administrative expense $29,900 The company produces the same number of units every month, although the...
2. Given the following data:   Return on investment 36%   Turnover 2.7   Margin 10%   Sales $270,000   Average...
2. Given the following data:   Return on investment 36%   Turnover 2.7   Margin 10%   Sales $270,000   Average operating assets $75,000   Minimum required rate of return 19% The residual income would be: $12,750 $0 $19,500 $24,300 4. The West Division of Frede Corporation had average operating assets of $658,000 and net operating income of $147,000 in December. The minimum required rate of return for performance evaluation purposes is 23%. What was the West Division's minimum required return in December? $147,000 $151,340 $33,810...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT