Use Excel to solve the problem. Use the $ in formulas to solve the problems most efficiently.

Please show work and formulas.

Eastside Manufacturing spent $5000 on a worker training program that was supposed to increase worker productivity. The desired outcome of this program was that labor productivity would increase by 5%. The Director of Plant Operations is concerned about whether or not the program attains the desired results before she trains additional workers using the program. The Director wants to check the change in labor and material productivity to see if the program was really was beneficial. The Director has the following data to work with

	Last Year	Now
Production (Units)	7000	8,500
Labor (hours)	1400	1650
Capital Investment ($)	18,000	23,000
Energy (BTU)	15,000	17,250

Calculate the productivities. Include the Units (9 points)

	Last Year	Now
Labor Productivity
Capital Productivity
Energy Productivity

a) 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).

b) 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).

c) Was the training program worthwhile based on the goal to make the labor force 5% more efficient? Why or why not?