PLEASE USE EXCEL TO COMPLETE THE QUESTION. QUESTION CAN NOT BE COMPLETED WITHOUT EXCEL**** THANK YOU SO MUCH

RefCo is a heater manufacturer that currently makes its heaters in Ohio. The manufacturing cost at the Ohio plant is 5600 per heater RefCo sells the heaters for $8000 Its current yearly demand is 1000 heaters RefCo estimates that each year demand has a 50 percent chance of increasing 10 percent from the year before and a 50 percent chance of remaining the same as the year before The Ohto facility has a capacity of 1000 units RefCo is considering two options. The first option is to build a new facility in Michigan. The new facility will have a capacity of 500 and Refco will incur a one time cost of $1,000,000. The manufacturing cost at the new facility will be $5000 per unit because of updated manufacturing processes. The second option is to buy pre-assembled heaters from Heatco when demand goes over 1000. The current cost of preassembled heaters from Hestco is $3000 per unit RefCo expects Heatco to increase its prices each year. Reto estimates that each year there is a 50% chance that the price will increase by 10% or there is 1:50. chance that the price will increase by Use a decision tree to determine which option RefCo should use: Consider the expected profit from the current year and the next to eats in your decision making process Assumea discount factor of lover the next two vent RefCo is a heater manufacturer that currently makes its heaters in Ohio. The manufacturing cost at the Ohio plant is 5600 per heater RefCo sells the heaters for $8000 Its current yearly demand is 1000 heaters RefCo estimates that each year demand has a 50 percent chance of increasing 10 percent from the year before and a 50 percent chance of remaining the same as the year before The Ohto facility has a capacity of 1000 units RefCo is considering two options. The first option is to build a new facility in Michigan. The new facility will have a capacity of 500 and Refco will incur a one time cost of $1,000,000. The manufacturing cost at the new facility will be $5000 per unit because of updated manufacturing processes. The second option is to buy pre-assembled heaters from Heatco when demand goes over 1000. The current cost of preassembled heaters from Hestco is $3000 per unit RefCo expects Heatco to increase its prices each year. Reto estimates that each year there is a 50% chance that the price will increase by 10% or there is 1:50. chance that the price will increase by Use a decision tree to determine which option RefCo should use: Consider the expected profit from the current year and the next to eats in your decision making process Assumea discount factor of lover the next two vent