You are in charge of hiring for the sales department of Nature’s Own chemical company

You are in charge of hiring for the sales department of Nature’s Own chemical company. You are choosing between two workers, a “safe” worker who will produce 250 thousand dollars in sales (net of variable costs) in each of the next four years. The “risky” worker produces 500 thousand dollars in annual sales with probability p, and will cost the company 250 thousand dollars in sales with probability (1-p). Both workers will stay with Nature’s Own for one year for sure, and will leave after four years for sure. There is, however, a 50 percent chance that either type of worker will quit between the end of the first and the start of the second period. If they don’t quit at that moment then they will stay for sure till the end of year 4. (Note to the wise: this is a crude way of modeling a declining quit rate over the worker’s career; it is different from the constant quit rate we modeled in class). If hired, the salary of each type of worker will be $100,000 per year. The discount rate is zero. A risky worker’s “type” (good or bad; i.e. high or low sales) becomes known after the end of his/her first year with Nature’s Own.a.) Set up a spreadsheet to calculate the firm’s expected present value of hiring each type of worker. Allow for “inputable” values of all the parameters above (the productivities of both worker types in both years, the probability the risky worker is the “good” type, and the probability that workers quit after the first year.b.) If p = 0.5, which worker should you hire? Is this the worker with the highest expected value of sales in the first year?c.) Now raise the “riskiness” of the risky worker by raising her sales if she is “good” to 700 thousand, and increasing her net losses if she is “bad” from 250 to 450 thousand dollars. What does this do to her expected value of sales in the first year? Does this change your recommendation on which worker to hire? Why or why not?d.) Keeping workers’ productivities at the levels in part c above, raise the probability that workers of either type quit after year 1 from .5 to .75. Which worker would you hire now? Why?