Document Preview:
Unit 5 [GB513| Business Analytics] 1 Assignment Case # 3 – Final Project The Bekaert Company of Belgium is a major supplier of bead wire for tire re-enforcement and other specialized wire processes in the USA and throughout the world. The company has always prided itself on its dedication to employee training and education. Recently they have increased production from 70,000 to 90,000 pounds per week during a time when it implemented a basic skills training program over an 18 month period. The following data date measures the number of total cumulative basic skills hours of training and the per week productivity figures taken once a month over this time period. Question – In Excel use the regression tool to analyze the data in a brief report (Power Point or Word Doc) to the CEO of Bekaert. Discuss the predictability of productivity from cumulative hours of training. Unit 5 [GB513| Business Analytics] 2 The Data Cumulative Hours of Training Productivity (lbs. /week) 0 70,000 100 70,350 250 70,500 375 72,600 525 74,000 750 76,500 875 77,000 1,100 77,400 1,300 77,900 1,450 77,200 1,660 78,900 1,900 81,000 2,300 82,500 2,600 84,000 2,850 86,500 3,150 87,000 3,500 88,600 4,000 90,000