The director of the Computer Center needs to schedule the staffing of the center. It is open from 8am until midnight. The director has monitored the usage of the center at various times of the day and determined that the following number of computer consultants are required:

The director of the Computer Center needs to schedule the staffing of the center. It is open from 8am until midnight. The director has monitored the usage of the center at various times of the day and determined that the following number of computer consultants are required:

Time of Day Minimum number of consultants

Don't use plagiarized sources. Get Your Custom Essay on
The director of the Computer Center needs to schedule the staffing of the center. It is open from 8am until midnight. The director has monitored the usage of the center at various times of the day and determined that the following number of computer consultants are required:
Just from $8 /Page 0r 300 words
Order Now

required to be on duty

8am-noon 12
Noon-4pm 18
4pm-8pm 24
8pm-midnight 12

The two types of computer consultants can be hired: full-time and part-time.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
  • The full-time consultants work for 8 consecutive hours in any of the following shifts: morning (8am-4pm), afternoon (noon-8pm), and evening (4pm-midnight). Full-time consultants are paid $60 per hour.
  • Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid $45 per hour.

An additional requirement is that during every time period, there needs to be at least two full-time consultants on duty for every part-time consultant on duty. The director wants to determine the number of full-time and part-time staff for each period so as to minimize the cost.

(Hints: the ratio of FT:PT ≥ 2:1 à FTPT21 à FT ≥ 2PT)

  1. Formulate the linear programming model for this problem.
  2. Solve the model using Excel Solver.

In: Computer Science

Looking for a similar assignment? Get help from our qualified experts!

Order Now