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
Larry Edison is the director of the Computer Center for Buckley College. He now needs to
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.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images