Responsible for scheduling the staffing of the center

Assignment Help Operation Management

Reference no: EM132214576

Write linear programming, and show on excel

You are the Director of the Computer Center for Gaillard College and responsible for scheduling the staffing of the center. It is open from 8 am until midnight. You have monitored the usage of the center at various times of the day and determined that the following numbers of computer consultants are required.

Time of day Minimum number of consultants required to be on duty

8 am-noon 4

Noon–4 pm 8

4 am–8 pm 10

8 am-midnight 6

Two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for eight consecutive hours in any of the following shifts: morning (8 am – 4 pm), afternoon (noon – 8 pm), and evening (4 pm-midnight). Full-time consultants are paid $14 per hour.

Part-time consultants can be hired to work in any of the four shifts listed in the table. Part-time consultants are paid $12 per hour. An additional requirement is that during every time period, at least one full-time consultant must be on duty for every part-time consultant on duty.

(a) Determine a minimum-cost staffing plan for the center. In your solution, how many consultants will be paid to work full time and how many will be paid to work part-time? What is the minimum cost?

Reference no: EM132214576

Questions Cloud

Produce two units of new cruise missile guidance control : United Research Associates (URA) had received a contract to produce two units of a new cruise missile guidance control.

Politicians can be strange : Politicians can be strange. They have been calling for the breakup of firms as diverse as energy companies and tech giants like Microsoft and Google

Describe ocbc unique approach to talent management : Describe OCBC's unique approach to talent management and development. Compare OCBC's approach to talent management and development to other organizations.

Explain the misuse of health care services : Baptist Health has a 4 star rating and UF Health has a 1 star rating. I was surprised that UF has such a low rating. They have a great trauma unit.

Responsible for scheduling the staffing of the center : You are the Director of the Computer Center for Gaillard College and responsible for scheduling the staffing of the center.

Unanticipated fluctuations from average demand is considered : Stock that a company holds to deal with unanticipated fluctuations from average demand is considered:

Calculate total payments received during a time period : Calculate total payments received during a time period, and reconcile this with total sales. Compute and record totals of transactions.

Analyze the theoretical aspects of research methods : Compile a PowerPoint presentation introducing the importance of research and the use of research methods within an organization. Think about how this applies.

Pepsico discovered consumer desire for healthier food option : After scanning the environment, PepsiCo discovered consumers’ desire for healthier food options.

User Account

All Pages