A department store needs to hire holiday season sales staff for their store. To cover all the responsibilities, they know that they need to have at least 20 workers on Sundays, 15 on Mondays, 16 on Tuesdays, 16 on Wednesdays, 16 on Thursdays, 22 on Fridays, and 22 on Saturdays. Staff members are guaranteed two consecutive days off. At a minimum, how many staff members need to be hired in order to ensure that the store can remain fully staffed every day of the week? a. Formulate an Integer LP (ILP) for this problem in Excel. b. Solve your model for the optimal solution.

A department store needs to hire holiday season sales staff for their store. To cover all the responsibilities, they know that they need to have at least 20 workers on Sundays, 15 on Mondays, 16 on Tuesdays, 16 on Wednesdays, 16 on Thursdays, 22 on Fridays, and 22 on Saturdays. Staff members are guaranteed two consecutive days off. At a minimum, how many staff members need to be hired in order to ensure that the store can remain fully staffed every day of the week? a. Formulate an Integer LP (ILP) for this problem in Excel. b. Solve your model for the optimal solution.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Business and individuals are choosing online or electronic communications rather than face-to-face interactions. Are there significant advantages or disadvantages for a business or person to limit their communications in this way
In what ways can business networking come with drawbacks? Explain the problems and any solutions you can think of.
With the use of a suitable framework, examine the relationship between data, information,knowledge and wisdom. Provide examples to substantiate your answer
What are the advantages of monitoring social media sites?
Indicate the most appropriate communication technology for the following business situation. Situation: The Sales Manager wants to reach a sales man to inform him about the latest changes in the price while the sales man is travelling. d. Email Ob. Courier c. Face to Face meeting O d. Mobile Phone
Is a process that allows clients not to only realize their problems, but that also helping them to overcome them
Mangement What are the advantages of E-Business Mangement?
Unpaid posts on social media handles is a great way to acquire new customers, because: Algorithms for social media websites, like Facebook, prioritize posts from businesses over posts from friends Impressions for posts on social media websites is very high, since most customers have accounts on the websites, and log in almost everyday Social media posts can be shared. This increases impressions, and consequently helps acquire many new customers None of the other statements are correct. Unpaid posts on social media handles receive very limited impressions, and thus, are not a great way to acquire new customers.
In 5-10 sentences, describe an ideal customer.
Training for new users and providing assistance to existing customers are just two examples of the many facets of user support.
Which of the following do you feel is most important to you: allowing FIMC and other organizations who offer roadside assistance to provide services to clients through mobile applications or not allowing them to do so?
State the important reasons for listening to stakeholders.