Excel homework in industrial engineering and business
A machining center in a local manufacturing company has five jobs to complete. The jobs are labeled 1, 2, 3, 4, and 5 based on the order they entered the shop. Your manager has asked you to compare two different job sequences to determine the best order for processing the jobs – First-In, First-Out (FIFO) and Shortest Processing Time (SPT). Compare the two sequences. Which sequence would you recommend and why? Be sure to include a variety of measures (average completion time, lateness, etc.) to compare the two sequencing rules. Include all calculations in your response.
You work for a healthcare insurance company as an industrial engineer. As part of the company’s customer service department, there is a call center that responds to customer questions by phone. Your manager has asked you to perform an analysis of some data that the call center has collected over the last two years in an effort to determine how many workers are needed. In particular your manager wants to find out if there is a relationship between how long it takes to answer a call (independent variable) and whether or not customers will hang up (dependent variable). Is there a linear relationship between these two variables? Include a graph and analysis to support your opinion. If the goal of the call center is to have fewer than 15% of calls abandoned, how quickly must the call center respond? Learning Outcome #2.
Data for Question 3
Average Answer Speed = Average number of seconds to answer an incoming call during the week
% abandoned = % of calls that are abandoned (hang up) before being answered during the week.