Problem 16-11 (Algo) One of your Taiwanese suppliers has bid on a new line of molded...

Problem 16-11 (Algo)

One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 100,000 parts in year 1; 400,000 in year 2; and 600,000 in year 3. Shipping and handling of parts from the supplier’s factory is estimated at $0.01 per unit. Additional inventory handling charges should amount to $0.003 per unit. Finally, administrative costs are estimated at $30 per month.

Although your plant is able to continue producing the part, the plant would need to invest in another molding machine, which would cost $10,000. Direct materials can be purchased for $0.04 per unit. Direct labor is estimated at $0.03 per unit for wages plus a 50 percent surcharge for benefits and, indirect labor is estimated at $0.011 per unit plus 50 percent benefits. Up-front engineering and design costs will amount to $40,000. Finally, management has insisted that overhead be allocated if the parts are made in-house at a rate of 100 percent of direct labor wage costs. The firm uses a cost of capital of 15 percent per year.

a. Calculate the difference in NPVs between the Make and Buy options. Express all costs as positive values in your calculations. It is suggested to use the NPV function in Excel. (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Solutions

Expert Solution

lets consolidate the various cost associated with Buy option

we got the Per unit variable cost and Fixed Cost p.a.

Lets see for Make option

The direct labour to include an surcharge of 50% of its cost toward benefits .(0.03*50%=0.015). so total cost 0.045 (0.03+0.015) per unit

similar surcharge applicable for indirect labour . so total indirect labour cost is 0.011+ 0.0055 =0.01650 per unit

overhead is 100% of Direct labour cost . so OH = 0.045 ( assumed including surcharge)

Thus the total cost per unit for making is 0.14650 per unit

it also involves an initial cash outflow of 50000 in year 0 as mentioned above..

lets construct a cash flow table for each option to evaluate

the excel formulas are

npv formula in excel is used, rate is taken as 0.15 (15% cost of capital)

the difference between the NPV of Buy and Make option is $75,439.58

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Problem 13-11 One of your Taiwanese suppliers has bid on a new line of molded plastic...

Problem 13-11 One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 200,000 parts in year 1; 300,000 in year 2; and 500,000 in year 3. Shipping and handling of parts from the supplier’s factory is estimated at $0.01 per unit. Additional inventory handling charges should amount to $0.005 per unit. Finally, administrative costs...

One of your Taiwanese suppliers has bid on a new line of molded plastic parts that...

One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 100,000 parts in year 1; 400,000 in year 2; and 700,000 in year 3. Shipping and handling of parts from the supplier’s factory is estimated at $0.02 per unit. Additional inventory handling charges should amount to $0.006 per unit. Finally, administrative costs are estimated...

One of your Taiwanese suppliers has bid on a new line of molded plastic parts that...

One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 100,000 parts in year 1; 300,000 in year 2; and 400,000 in year 3. Shipping and handling of parts from the supplier’s factory is estimated at $0.01 per unit. Additional inventory handling charges should amount to $0.006 per unit. Finally, administrative costs are estimated...

One of your Taiwanese suppliers has bid on a new line of molded plastic parts that...

One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 200,000 parts in year 1; 400,000 in year 2; and 500,000 in year 3. Shipping and handling of parts from the supplier’s factory is estimated at $0.03 per unit. Additional inventory handling charges should amount to $0.005 per unit. Finally, administrative costs are estimated...

Problem 11-9 (Algo) Straight-line depreciation; disposal; partial period; change in estimate [LO11-2, 11-5] The property, plant,...

Problem 11-9 (Algo) Straight-line depreciation; disposal; partial period; change in estimate [LO11-2, 11-5] The property, plant, and equipment section of the Jasper Company’s December 31, 2020, balance sheet contained the following: Property, plant, and equipment: Land $ 118,000 Building $ 798,000 Less: Accumulated depreciation (190,000 ) 608,000 Equipment 174,450 Less: Accumulated depreciation ? ? Total property, plant, and equipment ? The land and building were purchased at the beginning of 2016. Straight-line depreciation is used and a residual value of...

Problem 8-34 Calculating a Bid Price Your company has been approached to bid on a contract...

Problem 8-34 Calculating a Bid Price Your company has been approached to bid on a contract to sell 3,900 voice recognition (VR) computer keyboards a year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $3.5 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $92,000...

Problem 11-22 Sensitivity Analysis [LO1] McGilla Golf has decided to sell a new line of golf...

Problem 11-22 Sensitivity Analysis [LO1] McGilla Golf has decided to sell a new line of golf clubs. The company would like to know the sensitivity of NPV to changes in the price of the new clubs and the quantity of new clubs sold. The clubs will sell for $795 per set and have a variable cost of $355 per set. The company has spent $200,000 for a marketing study that determined the company will sell 65,000 sets per year for...

Problem 11-22 Sensitivity Analysis [LO1] McGilla Golf has decided to sell a new line of golf...

Problem 11-22 Sensitivity Analysis [LO1] McGilla Golf has decided to sell a new line of golf clubs. The company would like to know the sensitivity of NPV to changes in the price of the new clubs and the quantity of new clubs sold. The clubs will sell for $830 per set and have a variable cost of $430 per set. The company has spent $153,000 for a marketing study that determined the company will sell 57,000 sets per year for...

Problem 16-3 (Algo)Suppose that a monopoly firm finds that its MR is $64 for the...

Problem 16-3 (Algo)Suppose that a monopoly firm finds that its MR is $64 for the first unit sold each day, $63 for the second unit sold each day, $62 for the third unit sold each day, and so on. Further suppose that the first worker hired produces 5 units per day, the second 4 units per day, the third 3 units per day, and so on.a. What is the firm’s MRP for each of the first five workers?Instructions: Enter your...

Problem 11-16 Using CAPM A stock has a beta of 1.05 and an expected return of...

Problem 11-16 Using CAPM A stock has a beta of 1.05 and an expected return of 11 percent. A risk-free asset currently earns 2.4 percent. a. What is the expected return on a portfolio that is equally invested in the two assets? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Expected return % b. If a portfolio of the two assets has a beta of .63, what are...

Subjects