Linear Programming Solver Salespersons
Not what you're looking for?
A large department store operates 7 days a week. The manager estimates that the minimum number of salespersons required to provide prompt service is 12 for Monday, 18 for Tuesday, 20 for Wednesday, 28 for Thursday, 32 for Friday, and 40 for each of Saturday' and Sunday. Each salesperson works 5 days a week, with the two consecutive off-days staggered throughout the week. For example, if 10 salespersons start on Monday, two can take their off-days on Tuesday and Wednesday, five on Wednesday and Thursday, and three on Saturday and Sunday. How many salespersons should be contracted and how should their off-days be allocated?
Use SOLVER to solve it.
Purchase this Solution
Solution Summary
In the solution, for the given minimum number of salespersons per day, the total minimum number of sales persons are estimated.
Solution Preview
Please see attachment for images.
Minimum no. of sales persons = 42
Off-days #salespersons
Sat&Sun: 0
Fris&Sat: 2
Thu&Fri: 0
Wed&Thu: 14
Tue&Wed: 8
Mon&Tue: 16
Sun&Tue: 2
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Min# sales persons 12 18 20 28 32 40 ...
Education
- BEng, Allahabad University, India
- MSc , Pune University, India
- PhD (IP), Pune University, India
Recent Feedback
- " In question 2, you incorrectly add in the $3.00 dividend that was just paid to determine the value of the stock price using the dividend discount model. In question 4 response, it should have also been recognized that dividend discount models are not useful if any of the parameters used in the model are inaccurate. "
- "feedback: fail to recognize the operating cash flow will not begin until the end of year 3."
- "Answer was correct"
- "Great thanks"
- "Perfect solution..thank you"
Purchase this Solution
Free BrainMass Quizzes
Air Pollution Control - Environmental Science
Working principle of ESP
Architectural History
This quiz is intended to test the basics of History of Architecture- foundation for all architectural courses.