With the company expanding into several new markets in the

With the company expanding into several new markets in the coming months, Cable & Moore was anticipating a large increase in sales revenue. The future looked bright for this provider of television, telephone, and Internet services. However, management of Cable & Moore was well aware of the importance of customer service in new markets. If the public had problems with new service and could not quickly and efficiently have their problems solved, demand would quickly erode and it might take years to recover from the bad publicity. Therefore, management was adamant that there would be enough well-trained customer service representatives to handle the calls from new customers and from potential customers. Based on experience in other markets, the anticipated number of phone calls to customer service was projected. Given the average call-length, the number of hours of customer-service time from April to August was projected and is shown below. 

Month April May June July August 

Hours needed 22,600 24,600 27,200 28,100 29,500

 Through experience, management knew that training a new employee well was essential. Each new employee was put through a 1-month training program, and was assigned to an existing employee for an entire month. Normally an existing employee would work 160 hours per month. However, when an employee was assigned to perform training of a new-hire, the productive work hours for that employee dropped to 80 hours per month. During the training period, the trainee was paid $2,000 for the month. At the end of that time, the monthly salary increases to the standard salary for a regular customer service representative which is $3,500 per month. In the past, the company lost about 5% of the trained customer service representatives per month due to attrition. While the company is looking to improve upon this, for the next several months it is anticipated that this will continue. There will be 170 trained employees at the beginning of April. Management of the company would like to develop a schedule of hiring new employees so that there are sufficient customer service representatives to meet the demand, but this is to be done at the lowest possible cost.

 Discussion Questions 

1.Develop a schedule for hiring new employees. What is the total cost of this schedule? 

2.Discuss any limitations that exist for this solution.

3.How would the schedule change if the attrition rate could be lowered to 3% per month instead of 5%? What would be the impact on the cost? Can you show step by step and if possible how to calculate in Excel QM.

How Our Website Works

1. FILL IN OUR SIMPLE ORDER FORM

It has never been easier to place your order. Fill in the initial requirements in the small order form located on the home page and press “continue” button to proceed to the main order form or press “order” button in the header menu. Starting from there let our system intuitively guide you through all steps of ordering process.

2. PROCEED WITH THE PAYMENT

All your payments are processed securely through PayPal. This enables us to guarantee a 100% security of your funds and process payments swiftly.

3. WRITER ASSIGNMENT

Next, we match up your order details with the most qualified freelance writer in your field.

4. WRITING PROCESS

Once we have found the most suitable writer for your assignment, they start working on a masterpiece just for you!

5. DELIVERY

Once finished, your final paper will be available for download through your personal dashboard. You will also receive an email notification with a copy of your paper attached to it. Sometimes, the writer may leave a note for you about the order in case there is any additional information that they need to give you.

Leave a Reply

Your email address will not be published.