READ ONLY - This is an older file format. To make changes, make a copy of the file in the new format Upgrade a copy Dismiss 2) (30 points) Suppose you are the physical plant manager for a new hotel with many light fixtures. You need to decide if you should use 15 watt LED bulb or a 70 watt A19 halogen bulbs, each giving equivalent amount of lumens of light. The LED bulb costs $3.37 and the A19 halogen blub costs $1.06. The LED lasts 10 years and the A19 halogen bulb last roughly one year, so it will need to be purchased 10 times. (note that the last (10) halogen bulb will be purchased at the end of year 9 and will be used for Jan. 1 to Dec. 31 of year 10) Assume that each bulb is used 3 hours per day in your house. Search the city of Denton's website (or use some search engine) to find the cost per KWh charged by Denton Municipal Electric for the summer months of 2020 and assume that this will be the charge year round for the next 10 years. (Hint: the costs per kWh will be between 5 cents and 10 cents.) Calculate the present value (use a 4% discount rate) of the lifetime cost of each bulb. You can use this table as a template. It will be easiest to do this in Excel. interest rate 4.00% Cash Outlay for Investing in Lighting Year 0 1 2 3 4 5 6 7 8 9 10 Total Option A. LED 15 watt Present Value 3.37 ? ? ? ? ? 2 ? ? ? ? ? I ? ? ? ? ? ? ? ? ? ? ? ? 1.06 ? ? ? ? ? ? B. Halogen 70 watt Present Value ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 5:58 PM 9/18/2020