A company decided to develop low-cost photo-voltaic solar-energy cells. It decided on two development choices: a fully automatic line for $800,000 capable of producing 200,000 cells/year for a profit of $1/cell, or a semi-automatic line for $500,000 capable of producing 120,000 cells/year for a profit $1/cell. It is estimated that both lines will last for five years and will have a book value at the end of the five years of 10 percent. Assume both lines will be working to 100 percent capacity. You are the PM for development. Please make all calculations with or without taxes.

f. Show fixed and variable profit (including operating costs) breakeven point based on yearly volume for the first five years for both machines. Assuming i = 5%, 10 cents/cell cost to operate the automatic and 40 cents/cell to operate the semi-automatic machine. Selling price for both is $1/unit. Please make a plot of the breakeven sales point.

g. Assuming an interest rate of 5% and life of n = 5 years with no tax consequences or book value remaining, show probability analysis for PV for $500,000 semi-automatic @ 120,000 cells/year machine assuming two probabilities of profit per cell and useful number of years (n) for the machine. P (profit = $0.80) is 0.8 and P (profit = $1) is .20; and P (n = 5) is 0.4 and P (n = 4) is 0.6

h. Assuming an interest rate of 5% and life of n = 5 years with no tax consequences or book value remaining, show sensitivity analysis for PV for semi-automatic machine @ 120,000 cells sold/year @ $1 profit per cell machine, assuming 20% variations in the profit per cell and useful life. Plot the PV results versus the profit and useful life 20% variations.