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

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

I am needing help on how to enter the following data

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.