#### Excel homework in industrial engineering and business

October 30, 2015 0 Comment

Order Instructions/Description

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.

• 100% Original Essays Guaranteed
• 8 Hrs Delivery Available
• Original and creative work
• Timely delivery guaranteed
• 100% confidentiality guarantee
• Variety of disciplines, topics, and deadlines
• Discounts offered on every custom-ordered paper
• Original papers written from scratch;
• 100% confidential;
• 100% plagiarism-free;
• Fast turn-around time;
• Direct communication with the writer;
• Instant email delivery;
• Free plagiarism reports;
• 24/7 customer support team.
• Choose your font
• 12 point font size
• Double-sized
• Over 275 words/page
• Text aligned left
• One inch margin

We Accept