Larry Edison is the director of the Computer Center for Buckley College. He now needs to schedule the staffing of the center. It is open from 8 A.M. until midnight. Larry has monitored the usage of the center at various times of the day, and determined that the following number of computer consultants are required: Two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for 8 consecutive hours in any of the following shifts: morning (8 A.M.–4 P.M.), afternoon (noon–8 P.M.), and evening (4 P.M.–midnight). Full-time consultants are paid $4

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter5: Network Models
Section: Chapter Questions
Problem 1C
icon
Related questions
Question

Larry Edison is the director of the Computer Center for Buckley College. He now needs to schedule the staffing of the center. It is open from 8 A.M. until midnight. Larry has monitored the usage of the center at various times of the day, and determined that the following number of computer consultants are required:

Two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for 8 consecutive hours in any of the following shifts: morning (8 A.M.–4 P.M.), afternoon (noon–8 P.M.), and evening (4 P.M.–midnight). Full-time consultants are paid $400 per 8-hour shift. Part-time consultants can be hired to work any of the four shifts listed above. Part-time consultants are paid $150 per 4-hour shift. An additional requirement is that each part-time consultant must work two 4-hour shifts. These two shifts don’t have to be consecutive. Larry would like to determine how many full-time and how many part-time workers should work each shift to meet the above requirements at the minimum possible cost.

Solve using Excel Solver!!!

Please Show Screenshots of your Excel Sheet & Functions & As well as the Excel Solver Sheet

Note:-

  • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
  • Answer completely.
  • You will get up vote for sure.
Time of Day
8 A.M.-noon
Noon-4 P.M.
4 P.M.-8 P.M.
8 P.M.-midnight
Minimum Number of Consultants
Required to Be on Duty
4
8
10
6
Transcribed Image Text:Time of Day 8 A.M.-noon Noon-4 P.M. 4 P.M.-8 P.M. 8 P.M.-midnight Minimum Number of Consultants Required to Be on Duty 4 8 10 6
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,