Suppose that an operations manager is trying to determine the number of labor hours required to produce the ith unit of a certain product. Consider the data provided in the file P10_32.xlsx. For example, the second unit produced required 517 labor hours, and the 600th unit required 34 labor hours.
a. Use the given data to estimate a relationship between the total number of units produced and the labor hours required producing the last unit in the total set. Interpret your findings.
b. Use your estimated relationship to predict the number of labor hours that will be needed to produce the 800th unit.