Problem #2 18 points Use Excel or show Calculations O'Neills, a local bakery, is worried about increased costs, particularly energy. Last year's records can provide a fairly good estimate of the parameters for this year. Ashley O'Neil, the owner, does not believe things have changed much, but she did invest an additional $5,000 for modifications to the bakery's ovens to make them more energy efficient. The modifications were supposed to make the ovens at least 15% more efficient. Ms. O'Neill has asked you to check the new ovens' energy savings and look over other measures of the bakery's productivity to see if the modifications were beneficial. You have the following data to work with: Last Year Now 3,500 4,000 620 650 Production (dozen) Labor (hours) Capital Investment ($) Energy (BTU) 18,000 23,000 3,300 3,500 Calculate the productivities. Include the Units (9 points) Last Year Now Labor Productivity Capital Productivity Energy Productivity (3 points) What is the energy productivity increase or decrease (enter your response as a percentage rounded to two decimal places and include a minus sign if necessary). (3 points) What is the labor productivity increase or decrease (enter your response as a percentage rounded to two decimal places and include a minus sign if necessary). (3 points) Was the investment worthwhile based on the goal to make the ovens at least 15% more efficient? Why or why not