Question

A pencil-manufacturing company Sharpy Sharp wants to make its production more efficient, and it has hired Bain and Co. to assist in the decision making process. Several months later the consultants at Bain came up with the conclusion that it could be cheaper to make pencil tops [in-house] rather than buying them from an outside supplier, as direct production pre-tax costs are estimated to be only $1.50 a top. To produce the tops in house, the company will have to immediately buy new machinery that costs $150,000. This investment could be written off for tax purposes using straight-line depreciation over 3 years to a salvage value of zero. The company pays tax at a rate of 35 percent, the required rate of return is 15 percent, and the company needs to produce 200,000 pencil top units a year. The consultants estimate that operating the new machine will increase the company’s hydro bills by $1,000 a month (hydro bills are due at the end of each month). Finally, the company will have to invest $40,000 in net working capital right away but will be able to recover all of it at the end of year 3.

Currently the company buys pencil tops from an outside supplier at a price of $2 a lid. Sharpy Sharp anticipates that it will produce (or buy) the pencil tops for the foreseeable future, and all the costs/prices outlined in the question will remain unchanged.

In answering the question, assume that all the numbers are adjusted for inflation. Unless specified otherwise, all the cash flows arrive/are paid at the end of the specified period. Both the outsourced and the in-house production will lead to the same quality of the product and will not affect the pencil prices. To receive full credit, please show your calculations.

  1. What investment decision rule should you use to compare the two options?

  1. Which option is better? To receive full credit for the question, show the time line, the FCF, and all of your calculations. Answers in Excel are acceptable. If you choose to answer the question in Excel, please add the Excel file to your submission to ensure clarity and visibility of your calculations to the grader.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer;

GIVEN DATA

COST OF OUT SIDE SUPPLIERS=1.5

TOTAL NUMBER OF UNITS PRODUCED=200000

CAPEX REQUIRED=150000

NUMBER OF YEARS=3

INCREMENTAL HYDRO BILLS PER MONTH

TAX RATE=35%

REQUIRED RATE=15%

WORKING CAPITAL=40000

DESRIPTION YEAR 0 YEAR1 YEAR2 YEAR3
SALES NILL 300000 300000 300000
INCRIMENT BILLS NILL 12000 12000 12000
DEPRICATION NILL 50000 50000 50000
PPT NILL 238000 238000 238000
TAX@35% NILL 83300 83300 83300
TOTAL PAT NILL 154700 154700 154700

THE CASH FLOW TABLE IS GIVEN BELOW

PAT+DEPRICIATION NILL 204700 204700 204700
CAPEX -150000 - - -
WORKING CAPITAL -40000 - - 40000
TOTAL -190000 204700 204700 244700
NPV 264067

RESULT: THE COMPANY ASSUMED THAT PUT UP ON THE MACHINERY START PRODUCING THE PENCIL HIGGER THE EQUAL PRICE THE POSITIVE MAKING NPV THAT MAKE THE COMPANY PRODUCING IN HOUSE INSTEAD OF OUTSOURCING

Add a comment
Know the answer?
Add Answer to:
A pencil-manufacturing company Sharpy Sharp wants to make its production more efficient, and it has hired...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Question #7 (6 Marks) Escher Skateboards has been manufacturing its own wheels for its skateboards Variable...

    Question #7 (6 Marks) Escher Skateboards has been manufacturing its own wheels for its skateboards Variable manufacturing overhead is charged to production at the rate of 30% of direct labour cost. The direct materials per unit are $1.50 and direct labour $1.80. Normal production is 200,000 wheels per year. A supplier offers to make the wheels at a price of $4 each. If the skateboard company accepts this offer, all variable manufacturing costs will be eliminated, but fixed costs will...

  • Question #7 (6 Marks) Escher Skateboards has been manufacturing its own wheels for its skateboards Variable...

    Question #7 (6 Marks) Escher Skateboards has been manufacturing its own wheels for its skateboards Variable manufacturing overhead is charged to production at the rate of 30% of direct labour cost. The direct materials per unit are $1.50 and direct labour $1.80. Normal production is 200,000 wheels per year. A supplier offers to make the wheels at a price of $4 each. If the skateboard company accepts this offer, all variable manufacturing costs will be eliminated, but fixed costs will...

  • Each year Wright's Widgets buys 10,000 subcomponents that it needs in the production of its widgets...

    Each year Wright's Widgets buys 10,000 subcomponents that it needs in the production of its widgets from an outside supplier for $15 each. If Wright instead used its existing idle capacity to produce it in-house, the variable production costs would be $8 per unit and $3 of fixed production overhead would be allocated to each unit. Additionally, Wright would need to hire one quality control technician for $28,000 per year. The excess capacity that would be required is currently leased...

  • The Green Machine Manufacturing Company has the option to make or buy a component part for...

    The Green Machine Manufacturing Company has the option to make or buy a component part for one of its lawnmowers. The annual requirement is 25,000 units. A supplier is able to supply the parts for $12.25 per piece. Green Machine estimates that it will cost $700 to prepare the contract with the supplier. To make the parts in-house, Green Machine must invest $100,000 in capital equipment. They estimate it will cost $9.00 per piece to produce the part in-house. Carry...

  • The management of Xiao Manufacturing Company is trying to decide whether to continue manufacturing a part...

    The management of Xiao Manufacturing Company is trying to decide whether to continue manufacturing a part or to buy it from an outside supplier. The part, called BIZBE, is a component of the company's finished product The following information was collected from the accounting records and production data for the year ending December 31, 2012. 1. 6,000 units of BIZBE were produced in the Machining Department 2. Variable manufacturing costs applicable to the production of each BIZBE unit were: direct...

  • The management of Xiao Manufacturing Company is trying to decide whether to continue manufacturing a part...

    The management of Xiao Manufacturing Company is trying to decide whether to continue manufacturing a part or to buy it from an outside supplier. The part, called BIZBE, is a component of the company's finished product The following information was collected from the accounting records and production data for the year ending December 31, 2012. 1. 6,000 units of BIZBE were produced in the Machining Department 2. Variable manufacturing costs applicable to the production of each BIZBE unit were: direct...

  • The management of Concord Manufacturing Company is trying to decide whether to continue manufacturing a part...

    The management of Concord Manufacturing Company is trying to decide whether to continue manufacturing a part or to buy it from an outside supplier. The part, called CISCO, is a component of the company’s finished product. The following information was collected from the accounting records and production data for the year ending December 31, 2017. 1. 8,000 units of CISCO were produced in the Machining Department. 2. Variable manufacturing costs applicable to the production of each CISCO unit were:     direct...

  • The management of Borealis Manufacturing Company is trying to decide whether to continue manufacturing a part...

    The management of Borealis Manufacturing Company is trying to decide whether to continue manufacturing a part or to buy it from an outside supplier. The part, caled WISCO, component of the company's finished product The following information was collected from the accounting records and production data for the year ending December 31, 2020 1. The machining department produced 8,000 units of WISCO during the year 2. Variable manufacturing costs applicable to the production of each WISCO unit were direct materials...

  • The management of Shatner Manufacturing Company is trying to decide whetehr to continue manufacturing a part...

    The management of Shatner Manufacturing Company is trying to decide whetehr to continue manufacturing a part or to buy it from an outside supplier. The part, called CISCO. is a component of the company's finished product. The following information was collected from the accounting records and production data for the year ending December 31, 2020. 1. 8000 units of CISCO were produced in the Machining Department 2. Variable manufacturing costs applicable to the production of each CISCO unit were: direct...

  • The management of Concord Manufacturing Company is trying to decide whether to continue manufacturing a part...

    The management of Concord Manufacturing Company is trying to decide whether to continue manufacturing a part or to buy it from an outside supplier. The part, called CISCO, is a component of the company’s finished product. The following information was collected from the accounting records and production data for the year ending December 31, 2017. 1. 8,000 units of CISCO were produced in the Machining Department. 2. Variable manufacturing costs applicable to the production of each CISCO unit were:     direct...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT