Question

In: Accounting

Santana Inc. manufactures widgets.  The end product is produced in different departments within the plant.  One component, C1,...

Santana Inc. manufactures widgets.  The end product is produced in different departments within the plant.  One component, C1, is causing some concern.  The component is integral to the production of widgets, but is readily available in the marketplace.  The machine used to produce the component is nearing the end of its useful life and management is trying to decide whether to replace it or outsource the supply.

The current manufacturing costs of the C1 are as follows:

Direct materials

$20.25

per unit

Direct Labor

$16.00

per unit

Variable manufacturing overhead

$8.00

per unit

Variable general Administration

$7.00

per unit

Other costs related to C1 Department:

Supervision

$240,000

per year

Amortization

$360,000

per year

General Administration

$400,000

per year

The plant can produce 100,000 units per year.  It needs 65,000 units of C1 for widget production and sells 20,000 units externally at a price of $71.00. It incurs variable selling costs of $4.00 per unit when it sells C1 externally. Their policy is to fulfil internal requirements first, then sell C1 externally.

Pluto Corporation has approached Santana with a proposal to produce C1 for them.  The cost would be $69.00 per unit.  Pluto guarantees on-time delivery and has agreed to a penalty of 25% of revenue on any late shipments.  Pluto has further agreed to provide up to 90,000 units per year and has guaranteed the price of $69.00 for the entire five year contract.

Santana can purchase a new machine to replace the existing equipment used to produce C1 for $4,600,000.  It is anticipated the new machine will result in labour cost savings of 10%.  All other costs will remain the same.  The new machine’s useful life is expected to be 5 years and its residual value at that time will be $150,000.  It will be classified as a class 8 asset for tax purposes, with a CCA of 20%.  The capacity of this new machine will be 100,000 units per year.  The corporate tax rate is 40% and the company requires a 10% return, after tax, on this investment.

Management of Santana asked its marketing research group to determine the anticipated demand for widgets over the next 5 years.  Management also asked the group to determine whether the excess capacity could be used to produce C1 for external sales.

The marketing group reported the following information:

  1. Demand for widgets will be approximately 65,000 per year for the next three years, and will increase to 70,000 in years 4 and 5.
  2. The company expects external sales will be 18,000 units per year for the first three years and will increase to 25,000 units per year for the last two years.

                        

Management estimates that 40% of the supervisory costs and $100,000 of general administration expenses would be eliminated if the C1 were outsourced.  

Management also feels that there will need to be modifications to the design of the C1 in future years in order for the widget to remain competitive.  The machine’s manufacturer has assured Santana management that the changes will be possible at virtually no change in cost.  Pluto Corporation has indicated that any design changes would incur additional costs for Santana.

Required:

Assume that you have been hired by Santana Inc. to determine whether the company should buy the new machine or outsource production of C1.  Prepare a quantitative analysis, and evaluate any qualitative factors that will be relevant to the decision.  Provide a recommendation for management.

Solutions

Expert Solution

If the machinery is purchased.

Year 1 2 3 4 5
Direct materials 1680750 1680750 1680750 1923750 1923750
direct labour 1195200 1195200 1195200 1368000 1368000
Variable Manufacturing Over head 664000 664000 664000 760000 760000
Variable general Admin 581000 581000 581000 665000 665000
Suoervision 240000 240000 240000 240000 240000
General Admin 400000 400000 400000 400000 400000
Total expenses 4760950 4760950 4760950 5356750 5356750
Sales Externally(Net price 71-4) 1206000 1206000 1206000 1675000 1675000
Net Expenses 3554950 3554950 3554950 3681750 3681750
Amortization (allowed as per CCA) 460000 414000 372600 670680 536544
Total expenses as allowed for taxation Purposes 4014950 3968950 3927550 4352430 4218294
Additional Amortization For Financial reporting Purpose 430000 476000 517400 219320 353456
Total Expenses as per Financial Reporting 4444950 4444950 4444950 4571750 4571750

When outsourced.

C1 purchase Price 4485000 4485000 4485000 4830000 4830000
Supervision Expenses 144000 144000 144000 144000 144000
General Admin 300000 300000 300000 300000 300000
Total Expenses 4929000 4929000 4929000 5274000 5274000

It can be clearly seen that the material is outsourced the expenses occured are more even though the amortization as per the cca laws for taxation or expenses is as per financial reporting guidelines.

Other than this qualitative research let's see some qualitative factors also.

It can be clearly seen that the capacity of production in machinery is more than what is being produced. So if the sales forecast can exceed to what is being presented the machinery would be able to deliver even better.

Also if the C1 designed is to be altered for future purposes it can be done without incurringf any extra charges where in external outsourching redisgn will cost extra as per terms and conditions.

Hence the management is recommended to go for and buy a machinery for present as well as future Purpose.


Related Solutions

A company manufactures and sells one product. At the end of the year, the managers were...
A company manufactures and sells one product. At the end of the year, the managers were disappointed that the profit had decreased. The details are:-                                                             BUDGET                                ACTUAL                                                                               £                                             £ Sales                                        1 200 units      36 000           1 000 units      40 000 Material (variable cost)              500 kg              3 000              500 kg             3 600 Labour (variable cost)             1 200 hours       12 000           1 100 hours      12 100 Fixed overheads                                                 9 000                                     7 000 Total costs                                                      ...
CloverSweet Inc. manufactures a product that goes through two departments prior to completion. The information shown...
CloverSweet Inc. manufactures a product that goes through two departments prior to completion. The information shown in the table below is available about work in the first department, the Mixing Department, during June: Percent Complete Units Materials Conversion   Work in process, beginning 51,700 75 % 30 %   Started into production 447,000   Completed and transferred out 397,000   Work in process, ending 101,700 60 % 40 % Materials Conversion   Work in process, beginning $ 47,200 $ 26,700   Cost added during June $...
CloverSweet Inc. manufactures a product that goes through two departments prior to completion. The information shown...
CloverSweet Inc. manufactures a product that goes through two departments prior to completion. The information shown in the table below is available about work in the first department, the Mixing Department, during June: Percent Complete Units Materials Conversion   Work in process, beginning 52,000 75 % 30 %   Started into production 450,000   Completed and transferred out 400,000   Work in process, ending 102,000 60 % 40 % Materials Conversion   Work in process, beginning $ 47,500 $ 27,000   Cost added during June $...
CloverSweet Inc. manufactures a product that goes through two departments prior to completion. The information shown...
CloverSweet Inc. manufactures a product that goes through two departments prior to completion. The information shown in the table below is available about work in the first department, the Mixing Department, during June: Percent Complete Units Materials Conversion   Work in process, beginning 50,000 75 % 30 %   Started into production 430,000   Completed and transferred out 380,000   Work in process, ending 100,000 60 % 40 % Materials Conversion   Work in process, beginning $ 45,500 $ 25,000   Cost added during June $...
BDB Company manufactures its one product by a process that requires two departments. The production starts...
BDB Company manufactures its one product by a process that requires two departments. The production starts in Department A and is completed in Department B. Direct materials are added at the beginning of the process in Department A. Additional direct materials are added when the process is 50% complete in Department B. Conversion costs are incurred proportionally throughout the production processes in both departments. On April 1, Department A had 500 units in Work-in-Process estimated to be 30% complete for...
Radford Inc. manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and...
Radford Inc. manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and Packing. Assume that records indicate that direct materials, direct labor, and applied factory overhead for the first department, Refining, were $388,000, $141,000, and $96,800, respectively. Also, work in process in the Refining Department at the beginning of the period totaled $29,800, and work in process at the end of the period totaled $30,000. Required: a. (1) On September 30, journalize the entry to record...
Firenze, Inc., manufactures a product that goes through two departments prior to completion—the Mixing Department followed...
Firenze, Inc., manufactures a product that goes through two departments prior to completion—the Mixing Department followed by the Packaging Department. The following information is available about work in the first department, the Mixing Department, during June. Percent Completed Units Materials Conversion   Work in process, beginning 60,000 70%    40%      Started into production 307,500   Completed and transferred out 297,500   Work in process, ending 70,000 75%    25%    Materials Conversion   Work in process, beginning $ 21,200 $ 7,200   Cost added...
Radford Inc. manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and...
Radford Inc. manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and Packing. Assume that records indicate that direct materials, direct labor, and applied factory overhead for the first department, Refining, were $388,000, $141,000, and $96,800, respectively. Also, work in process in the Refining Department at the beginning of the period totaled $29,800, and work in process at the end of the period totaled $30,000. Required: a. (1) On September 30, journalize the entry to record...
Sweeties, Inc., manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and...
Sweeties, Inc., manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and Packing. Assume that records indicate that direct materials, direct labor, and applied factory overhead for the first department, Refining, were $369,000, $146,000, and $97,600, respectively. Also, work in process in the Refining Department at the beginning of the period totaled $30,200, and work in process at the end of the period totaled $28,400. Required: a. (1) On September 30, journalize the entry to record...
Radford Inc. manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and...
Radford Inc. manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and Packing. Assume that records indicate that direct materials, direct labor, and applied factory overhead for the first department, Refining, were $360,000, $147,000, and $96,400, respectively. Also, work in process in the Refining Department at the beginning of the period totaled $32,000, and work in process at the end of the period totaled $28,200. Required: a. (1) On September 30, journalize the entry to record...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT