CASE #3 - Introduction to Sensitivity Analysis Print the following page(s) and answer all questions on it(them) Management of High Tech Services (HTS) wants to develop a model that will help allocate its technicians time between service calls to regular contract customers and new customers. A maximum of 80 hours of technician time is available over the two-week planning period. To satisfy cash flow requirements, at least $800 in revenue (per technician) must be generated during the two-week period. Technician time for regular customers generates $20 per hour. However, technician time for new customers only generates $8 per hour because in many cases a new customer contact does not provide billable services. To ensure that new customer contacts are being maintained, the technician time spent on new customer contacts must be at least 60% of the time spent on regular costumer contacts. For the revenue policy and requirements stated, HTS would like to determine how to allocate technician time between regular customers and new customers to maximize the number of customers contacted during the two-week period. Technicians require an average of 40 minutes for each regular customer contact and 50 minutes for each new customer contact

1. Develop a linear programming model that will enable HTS to allocate technician time between regular and new customers.

2. Introduce this model in the EXCEL Solver and find the optimal allocation of time. Keep in mind that you might be sharing this EXCEL with others, make it legible, the format of the Excel is even more important than the solution itself!

3. Write a short report with the solution (include all the information that you consider relevant).