Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1.4 Management of High Tech Services (HTS) would like to develop a model that will help allocate their technician's time between service calls to regular
1.4 Management of High Tech Services (HTS) would like to develop a model that will help allocate their technician's time between service calls to regular contract cus- tomers 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 reveme (per technician) must be generated during the two-week period. Technician time for regular customers generates $25 per hour. However, technician time for new customers only generates an average of $8 per hour. To ensure that new customer contracts are being maintained, the technician time spent on new customer contracts must be at least 60% of the time spent on regular customer contracts. Given these revenue and policy requirements, HTS would like to determine how to allocate tech- nician time between regular customers and new customers so that the total number of customers contracted during the two-week period will be maximized. Technicians require an average of 50 minutes for each regular customer contract and 1 hour for each new customer contract. a. Develop a linear programming model for the problem. b. Find the optimal solution via Excel. 1.4 Management of High Tech Services (HTS) would like to develop a model that will help allocate their technician's time between service calls to regular contract cus- tomers 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 reveme (per technician) must be generated during the two-week period. Technician time for regular customers generates $25 per hour. However, technician time for new customers only generates an average of $8 per hour. To ensure that new customer contracts are being maintained, the technician time spent on new customer contracts must be at least 60% of the time spent on regular customer contracts. Given these revenue and policy requirements, HTS would like to determine how to allocate tech- nician time between regular customers and new customers so that the total number of customers contracted during the two-week period will be maximized. Technicians require an average of 50 minutes for each regular customer contract and 1 hour for each new customer contract. a. Develop a linear programming model for the problem. b. Find the optimal solution via Excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started