For the assignment: 1. EAS a. Pick a level of shrinkage decline that makes sense, and briefly explain your reasoning. Keep this assumption throughout your analyses. show me a table showing the NPV from each model keeping all the other default assumptions, only changing the level of shrinkage decline. b. Choose one other assumption to vary for EAS. Keeping your chosen level of shrinkage, change that other assumption in all models, and enter the new NPVs into your table. c. Evaluate the following scenario: The EAS system is highly effective, but publicity about your anti-theft efforts makes some shoppers concerned. The shrink rate without EAS grows 0.2% per year and reduction in shrink is 40%, but sales growth per year is 1% lower than the default assumption (that is, 5% for full-line stores and 8% for hardware stores). Leave all other assumptions at their default levels. Enter the new NPVs into your table. 2. Lighting a. Adjust the installation cost per store according to your perspective on such chain-wide rollouts. Do you think costs might be higher, perhaps because of trying to install new lighting in so many stores in a short period of time? Or do you think costs might be lower, perhaps because Murphy could buy the lighting fixtures in bulk? Briefly explain your reasoning. Keep this assumption throughout your analyses. Report the NPV from the lighting model keeping all the other default assumptions, only changing the cost of installation. b. Consider the possibility that new technologies and deregulation of the electricity industry could reduce costs per kwh. At what value of cost per kwh would the lighting project become negative NPV, given your assumptions in part (a)? Do you think this much reduction is realistic in the next 10 years? b. Consider regional differences in hardware stores. Suppose one-half of stores are in areas that use a high level of air conditioning (3000 hours per year per store) and one-half of stores are in areas that use a low level of air conditioning (1000 hours per year per store). Since the average hours per store are the same as in (a), the overall NPV will not change. But what does this suggest about the priority for new lighting in stores? What other information might you want on any assumption to make a better decision? Your submission should include the following elements in a short document: Reasoning for part 1a. Table of NPVs from parts 1a, 1b, and 1c Reasoning for part 2a. NPV for part 2a. Breakeven value of electricity cost assumption for part 2b. Declaration of any vital, new information on any assumption you would find helpful before having to make your recommendation. Recommendation for how to allocate $7M in 2007. Justify your recommendation by referring to the sensitivity analysis and scenario analysis. One or two paragraphs is sufficient.