CSL is a chain of computer service stores. The number of hours of skilled repair time that CSL requires during the next 5 months is as follows:
Month 1 (January): 6000 hours
Month 2 (February): 7000 hours
Month 3 (March): 8000 hours
Month 4 (April): 9500 hours
Month 5 (May): 11000 hours
At the beginning of January, 50 skilled technicians work for CSL. Each skilled technician can work up to 160 hours per month. To meet future demands, new technicians must be trained. It takes 1 month to train a new technician. During the month of training, a trainee must be supervised for 50 hours by an experienced technician. Each experienced technician is paid $2000 a month (even if he or she does not work the full 160 hours). During the month of training, a trainee is paid $1,000 a month. At the end of each month, 5% of CSL's experienced techicians quit to join Plum Computers. Solve (minimize the labor cost incurred in meeting the service requirements for the next 5 months) this linear program problem in Excel using solver.