Please can you answer questions from 5 to 9?

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 140 hours of technician time is available over the monthly planning period. To satisfy cash flow requirements, at least $1200 in revenue (per technician) must be generated during the month. Technician time for regular customers generates $16 per hour. However, technician time for new customers only generates $9 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 40% of the total technician time spent. 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 month. Technicians require an average of 30 minutes for each regular customer contact and 40 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).

4. The time required to interview a regular customer can be reduced to 25 minutes eliminating some questions. How would this change the optimal time allocation? And the total number of customers interviewed.

5. How many more customers could be interviewed if we increased the total technician time by one hour? How do we call this in Linear programming?

6. Using the value you got in the previous question, how many more customers could be interviewed if we doubled the amount of technician time? Do you see any (mathematical) limitation to how many more hours we can increase the technician so that this increase in a number of customers per hour is applicable?

7. Due to an unpredicted increase in costs, HTS would like to increase the revenue obtained with these interviews to a minimum of $1600. How does this new requirement change the optimal allocation of time and the number of customers interviewed?

8. HTS wants to start a campaign to get new customers and has decided that the number of new customers interviewed has to be at least as large as the number of regular customers. Write the new constraint and do a new Excel spreadsheet (same file, different tab) to obtain the new optimal solution. What happened with the number of interviewed customers? Submit the Excel that you did for questions 2 and 8 in Blackboard