Question

In: Accounting

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 at $20 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.06 per unit. Direct labor is estimated at $0.05 per unit plus a 50 percent surcharge for benefits; indirect labor is estimated at $0.009 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 cost. The firm uses a cost of capital of 14 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.)

Difference in NPV $112,358.46

My answer of 112,358.46 is wrong and I have tried to solve this problem multiple ways. Can you please help me out?

Solutions

Expert Solution


Related Solutions

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 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...
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...
One of your suppliers has belatedly realized that about 10% of the batches of a particular...
One of your suppliers has belatedly realized that about 10% of the batches of a particular component recently supplied to you have a manufacturing fault that has reduced their reliability. There is no external or visual means of identifying these substandard components. Batch identity has, however, been maintained, so your problem is to sort batches that have this fault ('bad' batches) from the rest ('good' batches). An accelerated test has been devised such that components from good batches have a...
Your firm has a contract to purchase 1000 laptops from a Taiwanese company. The payment is...
Your firm has a contract to purchase 1000 laptops from a Taiwanese company. The payment is due on receipt of the shipment and must be delivered in Taiwan on June 31, 2020. In March 2020, when you are arranging the contract, the laptops are each priced at 20,000 NT$ (New Taiwan Dollar). The spot rate in March 2020 is $1 in exchange for 30 NT$. a) [5 points] What is the U.S. dollar price of one unit of laptop in...
Leverage Analysis:  Your employer has decided to purchase a new manufacturing line.  The new line will generate an...
Leverage Analysis:  Your employer has decided to purchase a new manufacturing line.  The new line will generate an additional $3,000,000 of operating income annually and will cost $50,000,000.  You are trying to decide if the line should be financed with debt or with equity.  The company currently has $60,000,000 of debt (borrowing rate is 8%) and $30,000,000 of equity.   (Part #1) Complete the income statement below (shaded region) including the two ratios at the bottom of the table. (Part #2) Recommend one of the...
A new client has been paying its suppliers late consistently; well in excess of the suppliers’...
A new client has been paying its suppliers late consistently; well in excess of the suppliers’ agreed credit terms. As a result, some suppliers have begun demanding cash on delivery from the client. You are also aware that a review of correspondence between the new client and its bank reveals that the new client has been experiencing cash flow problems for two years. Required Discuss THREE events or conditions described in the case that may cast significant doubt on the...
Grant Industries, a manufacturer of electronic parts, has recently received an invitation to bid on a...
Grant Industries, a manufacturer of electronic parts, has recently received an invitation to bid on a special order for 25,000 units of one of its most popular products. Grant currently manufactures 50,000 units of this product in its Loveland, Ohio, plant. The plant is operating at 50% capacity. There will be no marketing costs on the special order. The sales manager of Grant wants to set the bid at $14 because she is sure that Grant will get the business...
Q1. ABCD is going to purchase an auto parts component from one of two competing suppliers...
Q1. ABCD is going to purchase an auto parts component from one of two competing suppliers and it is going to base its decision, in part, on the supply chain performance of the two suppliers. The company has obtained the following data for average raw materials, work-in-process, and finished goods inventory value, as well as cost of goods sold for the suppliers. Assume each supplier operates 50 weeks per year. Supplier 1 Supplier 2 Cost of goods sold $8,500,000 $14,800,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT