In this assignment, I need to determine 2 benchmarks in figuring out whether I should outsource three products. I need help in figuring out the net present value. To find this, I have to come up with a unit price based on a Table 1 Unit Production Chart (see attached files) and then utilize the (10) year sales forecast to come up with an annual aggregate production costs.

To come up with a unit price, would I add both labor and material cost then divide by the forecast?

Ex. Product B Year 1:

Forecast: 3500

Labor/Unit: $900

Matl,/Unit:$650

Unit Price: .44

X 445.66 Technology and Cost Management in the Supply Chain Summer 2015 Project We've discussed the decisions that companies make to maximize their competitive advantages. One of the strategies that companies follow is to determine what activities they will perform themselves and which will be performed by suppliers under contract to the company. Part of this decision making is a make or buy evaluation. During your Supply Chain career, you may find yourself engaged in supporting the decision making process as your company evaluates whether to make or buy products, assemblies, subassemblies or parts. You work for the Titan Braking Systems company (TBS). Management believes that it may be able to lower its costs by outsourcing some of its braking products. You've been tasked to quote suppliers for making three products. You've received proposals, but recognize the need to assess whether accepting any of these proposals is in TBS' best interests. It's not immediately clear if it's a better financial deal to continue making these products in-house or outsource them. You've compiled all available financial data and are ready to begin preparing an assessment. You have the following goals for your assessment: 1. You need to determine two benchmarks, against which you'd assess supplier quotes: (1) The net present value (NPV) at which TBS is indifferent on whether to outsource the three products or continue making them in-house. Finding this value requires you to come up with a unit price based on the Table 1 Unit Production Cost data and then utilize the (10) year sales forecast to come up with annual aggregate production costs. You would then calculate the net present value of these annual costs. Use a 10% discount rate. Tip 1: Remember that NPV tables are accessible through a link in our Module 3 folder. Tip 2: Coming up with an annual production cost for each product will require you to allocate overhead to production costs. Overhead can allocated based on labor costs; the sum of unit labor and material; or per unit. You may choose your allocation base. 1 X 445.66 Technology and Cost Management in the Supply Chain Summer 2015 Project (2) The NPV at which TBS will realize a 10% reduction in costs. This requires you to reduce the projected unit price by 10% in each year and then follow the same steps to develop an NPV, as outlined above. 2. If all three products are outsourced, it may also be possible for you to close the building housing the factory making these three products and sell the equipment used to produce them. Potential bidders include those suppliers competing to manufacture the parts for the potential outsource. Using company records, you've compiled the financial data shown in Table 2. Using this data, you should be able to determine what the book value for these assets, so that you know the minimum price you can charge the bidders for these assets. Please prepare and submit a summary of the results of your assessment. The summary should also: 1. Be submitted in Microsoft Word format. Excel files/formats may be pasted into the document as a spreadsheet or object; 2. Show the calculations used to generate the results; and 3. Be submitted by Sunday, 13 September 2015. Table 1 Sales Forecast and Unit Production Costs YEAR 2 $1.2M 3 $1.2M 4 $1.2M 5,000 Forecast Labor/Unit $800 Matl./Unit $500 6,000 $800 $500 6,500 $800 $500 5,500 $800 $500 3,500 Forecast Labor/Unit $900 Matl,/Unit $650 3,500 $900 $650 3,500 $900 $650 2,500 Forecast Labor/Unit $500 Matl,/Unit $250 2,500 $500 $250 3,000 $500 $250 Overhead 1 $1.2 M 5 $1.2M Product A 4,400 $800 $500 Product B 3,500 3,500 $900 $900 $650 $650 Product C 3,200 3,500 $500 $500 $250 $250 2 6 $1.2M 7 $1.2M 8 $1.2M 9 $1.2M 10 $1.2M 3,900 $900 $550 3,500 $900 $550 2,500 $900 $550 2,000 $900 $550 1,000 $900 $550 3,500 $900 $650 3,500 $900 $650 3,500 $900 $650 3,500 $900 $650 3,500 $900 $650 3,700 $500 $250 3,900 $500 $250 3,800 $500 $250 3,800 $500 $250 3,800 $500 $250 X 445.66 Technology and Cost Management in the Supply Chain Summer 2015 Project Table 2 Associated Plant and Equipment Purchase Price Salvage Value Useful Life Age Product A $ 2,500,000 Product B $5,000,000 Product C $4,000,000 General $5,000,000 $200,000 14 years 2 years $ 750,000 10 years New $ 250,000 15 years 4 years $ 1,200,000 17 years 5 years 3