I am asking this question again. It was answered previously, however the answer
ID: 429740 • Letter: I
Question
I am asking this question again. It was answered previously, however the answer pertained to legality as opposed to a math answer which is what this question is asking. Hopefully someone can help me with the formula and the calculation of what the question is asking.
A small grocery store needs the following nummber of cashiers during each day of a normal week for day (8 am to 4 pm) and evening (4 pm - 12 am) shifts. The stre prefers to employ full-time cashiers who work eight hours a day, five days a week, with two consecutive days off. A part time cashier works four hours a day up to five days a week (with no requirement for consecutive days off). Note that for each unit of cashier requirement below, two part-time cashiers are needed because the periods are eight hours long. Determine the mix of full-time and part-time cashiers and schedule their work in order to minimize total number of cashiers employed but meet the cashier requirements below.
3
Cashiers needed Mon Tues Wed Thurs Fri Sat Sun 8 am - 4 pm 3 4 3 3 5 83
Explanation / Answer
The following question can be solved using the linear programming model on excel. This problem pertains to the minimization of cashiers (both full time and part time). The constraints (variables involved) in the above problem are the requirement of cashiers for each consecutiove day. The problem is set using the excel and can be solved using the solver technique in computer.
Let Xi = number of cashiers begin their 8 hour shift in period I (I = 1,2,3,4, …., 7) period 1 8:00 am to 4 P.m period 2 4:00 PM to 12:00 AM Cashiers required DV Full time Part time Period Full-time Part-time x1 3 0 1 0 >= 3 2 x2 4 0 2 0 >= 4 3 x3 3 0 3 0 >= 3 2 x4 3 0 4 0 >= 3 2 x5 5 0 5 0 >= 5 6 x6 8 0 6 0 >= 8 5 x7 3 0 7 0 >= 3 3 Objective Function 29Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.