Linear Programming: Buckly College Computer Consultants
Not what you're looking for?
Larry Edison is the director of the Computer Center for Buckly College. He now needs to schedule the staffing of the center. It is open from 8 am 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 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 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, there must be at least two full-time consultants on duty for every part-time consultant on duty.
Larry would like to determine how many full-time and part-time consultants should work each shift to meet the above requirements at the minimum possible cost.
a.Which category of linear programming problem does this problem fit? Why?
b.Formulate and solve a linear programming model for this problem on a spreadsheet.
c. Summarize the model in algebraic form.
Purchase this Solution
Solution Summary
The solution provides detailed analysis of the Linear Programming Problem in EXCEL Solver.
Education
- MSc, Osmania University
- MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
- BSc, Banaras Hindu University
Recent Feedback
- "Very fast turnaround. Excellent communication! Much appreciated!"
- "excellent"
- "excellent"
- "excellent work"
- "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Motivation
This tests some key elements of major motivation theories.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Learning Lean
This quiz will help you understand the basic concepts of Lean.