Complete Chapter 6 Exercise 3 by creating a decision tree on an Excel spreadsheet.

3. Alphacap, a manufacturer of electronic components, is trying to select a single supplier for the raw materials that go into its main product, the doublecap. This is a new capacitor that is used by cellular phone manufacturers to protect microprocessors from power spikes. Two companies can provide the necessary materials_MultiChem and Mixemat. MultiChem has a solid reputation for its products and charges a higher price on account of its reliability of supply and delivery. MultiChem dedicates plant capacity to each customer, and therefore supply is ensured. This allows MultiChem to charge $1.20 for the raw materials used in each doublecap. Mixemat is a small raw materials supplier that has limited capacity but charges only $0.90 for a unit's worth of raw materials. Its reliability of supply, however, is in question. Mixemat does not have enough capacity to supply all its customers all the time. This means that orders to Mixemat are not guaranteed. In a year of high demand for raw materials, Mixemat will have 90,000 units available for Alphacap. In lowdemand years, all product will be delivered. If Alphacap does not get raw materials from suppliers, it needs to buy them on the spot market to supply its customers. Alphacap relies on one major cell phone manufacturer for the majority of its business. Failing to deliver could lead to losing this contract, essentially putting the firm at risk. Therefore, Alphacap will buy raw material on the spot market to make up for any shortfall. Spot prices for single-lot purchases (such as Alphacap would need) are $2.00 when raw materials demand is low and $4.00 when demand is high. Demand in the raw materials market has a 75 percent chance of being high each of the next two years. Alphacap sold 100,000 doublecaps last year and expects to sell 110,000 this year. However, there is a 25 percent chance it will sell only 100,000. Next year, the demand has a 75 percent chance of rising 20 percent over this year and a 25 percent chance of falling 10 percent. Alphacap uses a discount rate of 20 percent. Assume all costs are incurred at the beginning of each year (Year 1 costs are incurred now and Year 2 costs are incurred in a year) and that Alphacap must make a decision with a two-year horizon. Only one supplier can be chosen, as these two suppliers refuse to supply someone who works with their competitor. 3. Alphacap, a manufacturer of electronic components, is trying to select a single supplier for the raw materials that go into its main product, the doublecap. This is a new capacitor that is used by cellular phone manufacturers to protect microprocessors from power spikes. Two companies can provide the necessary materials_MultiChem and Mixemat. MultiChem has a solid reputation for its products and charges a higher price on account of its reliability of supply and delivery. MultiChem dedicates plant capacity to each customer, and therefore supply is ensured. This allows MultiChem to charge $1.20 for the raw materials used in each doublecap. Mixemat is a small raw materials supplier that has limited capacity but charges only $0.90 for a unit's worth of raw materials. Its reliability of supply, however, is in question. Mixemat does not have enough capacity to supply all its customers all the time. This means that orders to Mixemat are not guaranteed. In a year of high demand for raw materials, Mixemat will have 90,000 units available for Alphacap. In lowdemand years, all product will be delivered. If Alphacap does not get raw materials from suppliers, it needs to buy them on the spot market to supply its customers. Alphacap relies on one major cell phone manufacturer for the majority of its business. Failing to deliver could lead to losing this contract, essentially putting the firm at risk. Therefore, Alphacap will buy raw material on the spot market to make up for any shortfall. Spot prices for single-lot purchases (such as Alphacap would need) are $2.00 when raw materials demand is low and $4.00 when demand is high. Demand in the raw materials market has a 75 percent chance of being high each of the next two years. Alphacap sold 100,000 doublecaps last year and expects to sell 110,000 this year. However, there is a 25 percent chance it will sell only 100,000. Next year, the demand has a 75 percent chance of rising 20 percent over this year and a 25 percent chance of falling 10 percent. Alphacap uses a discount rate of 20 percent. Assume all costs are incurred at the beginning of each year (Year 1 costs are incurred now and Year 2 costs are incurred in a year) and that Alphacap must make a decision with a two-year horizon. Only one supplier can be chosen, as these two suppliers refuse to supply someone who works with their competitor