Labor cost incurred in meeting the service requirements

Assignment Help Financial Management

Reference no: EM13972087

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.

Reference no: EM13972087

Questions Cloud

How much money did they receive this morning : 3 years ago, Mr. Jones deposited $5,000 in Regional Bank’s money market account, which offers to pay 8 percent interest compounded annually. At the same time, Mrs. Jones deposited $5,000 in CBS Bank’s money market account, which pays interest of 7.9 ..

Write a compare and contrast paper on world civilization : Write a compare and contrast paper on World civilization.

Positively influence an organization’s shareholder wealth : What factors can positively influence an organization’s shareholder wealth? Which of these factors are the most significant? Explain your choice.

Compute the ending inventory which is the amount destroyed : Compute the ending inventory, which is the amount destroyed by the fire, for any of the products that you can. You may not be able to compute ending inventory for all products. If you cannot compute the ending inventory, state what additional informa..

Labor cost incurred in meeting the service requirements : CSL is a chain of computer service stores. 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 trai..

What are some ways in which you are effective in your career : Perform a self-evaluation of your current professional position. What are some of the ways in which you are effective in your career? What are some of the areas you could improve on

Black elks account helps us better understand : Students must discuss how Black Elk's account helps us better understand the opening of the West from the perspective of Native Americans and what Black Elk contributes to our understanding of the conquest of west

How might the professor have gone about checking : For example, as a student you have certainly been given a test in class at some point. How might the professor have gone about checking for a type of validity? Choose at least two types of validity to discuss for your chosen assessment

User Account

All Pages