Question

In: Statistics and Probability

MW is a large discount store that operates seven days per week. The store needs the...

MW is a large discount store that operates seven days per week. The store needs the following number of full-time employees working each day of the week. Sunday Monday Tuesday Wednesday Thursday Friday Saturday # of Employees 188 88 112 140 136 172 212 Each employee must work five consecutive days each week and then have two days off. For example, any employee who works Sunday through Thursday has Friday and Saturday off. The store currently has a total of 200 employees available to work. MW has developed the following set of prioritized goals for employee scheduling. The store would like to avoid hiring any additional employees. The most important day for the store to be fully staffed is Saturday, followed by Sunday, followed by Friday. The store would like to fully staff the remaining four days of the week Use preemptive goal programming to determine MW employee scheduling for the week. If each employee costs $800, each missing employee on Saturday costs $600, on Sunday $400, on Friday $300, and on Monday through Thursday $200 determine the new schedule which minimizes these costs (assuming there are no other priorities among the goals). "IN EXCEL"

Solutions

Expert Solution

So, forming an LP with decision variable as the day of starting their work on specific day as x1, x2 x3..x7 starting from Sunday respectively.

Attached one clearly indicates the formulation.Now forming the LP equation,

Now on solvinf the equation the answer is in green shade for daying working .


Related Solutions

A grocery store is open 24 hours a day, seven days a week. It has the...
A grocery store is open 24 hours a day, seven days a week. It has the following daily requirements for cashiers: Time                             Minimum # of cashiers 0100 – 0400                              7 0400 – 0700                              4 0700 – 1000                              9 1000 – 1300                              12 1300 – 1600                              15 1600 – 1900                              17 1900 – 2200 19 2200 – 0100                              13 A cashier may start work at the beginning of any one of the shifts and, having begun, works 9 consecutive hours. Each...
Sam's Cat Hotel operates 52 weeks per year, 7 days per week
Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.75 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. >Demand 95 bags/week >Order cost $56/order >Annual holding cost = 30 percent of cost >Desired cycle-service level = 99 percent >Lead time = 4 week(s) (28 working days) >Standard deviation of weekly demand = 20 bags >Current on-hand inventory is 325 bags, with no...
QUESTION 1 The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for...
QUESTION 1 The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for Eid-ul-Fitr and Eid- Ul -Adah (this gives 355 working days in a year). The shop pays SAR 600 for a particular bicycle purchased from the manufacturer. The annual holding cost per bicycle is estimated to be 25% of the SAR value of inventory. The shop sells an average of 25 bikes per week. Frequently, the dealer does not have a bike in stock when...
The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for Eid-ul-Fitr and...
The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for Eid-ul-Fitr and Eid- Ul -Adah (this gives 355 working days in a year). The shop pays SAR 600 for a particular bicycle purchased from the manufacturer. The annual holding cost per bicycle is estimated to be 25% of the SAR value of inventory. The shop sells an average of 25 bikes per week. Frequently, the dealer does not have a bike in stock when a customer...
Sam's Cat Hotel operates 52 weeks per? year, 5 days per? week, and uses a continuous...
Sam's Cat Hotel operates 52 weeks per? year, 5 days per? week, and uses a continuous review inventory system. It purchases kitty litter for ?$11.50 per bag. The following information is available about these bags. Refer to the standard normal table LOADING... for? z-values. Demand ?= 80 ?bags/week Order cost? = ?$58?/order Annual holding cost? = 30 percent of cost Desired ?cycle-service levelequals90 percent Lead time? = 2 ?week(s) ?(10 working? days) Standard deviation of weekly demand? = 16 bags...
Sam's Cat Hotel operates 5252 weeks per? year, 77 days per? week, and uses a continuous...
Sam's Cat Hotel operates 5252 weeks per? year, 77 days per? week, and uses a continuous review inventory system. It purchases kitty litter for ?$10.7510.75 per bag. The following information is available about these bags. Refer to the standard normal table LOADING... for? z-values. Demand = 100 bags/weeks Order cost = $56/order Annual Holding Cost = 30 percent of cost Desired cycle-service level =99 percent Lead time = 2 weeks (14 working days) Standard deviation of weekly demand = 10...
​Sam's Cat Hotel operates 52 weeks per​ year, 6 days per​ week, and uses a continuous...
​Sam's Cat Hotel operates 52 weeks per​ year, 6 days per​ week, and uses a continuous review inventory system. It purchases kitty litter for ​$11.00 per bag. The following information is available about these​ bags: Demand=80 ​bags/week Order cost=$55.00​/order Annual holding cost=40 percent of cost Desired ​cycle-service level=80 percent Lead time=5 weeks ​(30 working​ days) Standard deviation of weekly demand=15 bags Current ​on-hand inventory is 320 ​bags, with no open orders or backorders. a. Suppose that the weekly demand forecast...
Sam's Cat Hotel operates 52 weeks per​ year, 6 days per​ week, and uses a continuous...
Sam's Cat Hotel operates 52 weeks per​ year, 6 days per​ week, and uses a continuous review inventory system. It purchases kitty litter for ​$11.00 per bag. The following information is available about these​ bags: Demand=80 ​bags/week Order cost=$55.00​/order Annual holding cost=40 percent of cost Desired ​cycle-service level=80 percent Lead time=5 weeks ​(30 working​ days) Standard deviation of weekly demand=15 bags Current ​on-hand inventory is 320 ​bags, with no open orders or backorders. a. Suppose that the weekly demand forecast...
A process makes two products. A and B. and operates 5 days per week. 8 hours...
A process makes two products. A and B. and operates 5 days per week. 8 hours per day. Demand for the two products for the next week is as follows: Day 1: A: 20; B:26 Day 2: A: 10: B:15 Day 3: A: 20; B:19 Day 4: A: 18; B:20 Day 5: A: 12; B: 20   What is the takt time of the process? What would a level production schedule look like?
The HR manager of a large department store believes the number of resignations per week of...
The HR manager of a large department store believes the number of resignations per week of casual staff at the store can be approximated by a normal distribution with a mean of 42 resignations per week and variance 51.1 (resignations per week)2 . From a large amount of historical data available on the HR database regarding weekly resignations of casuals, a sample of 52 weeks was selected. What must the value of the sample mean be so that only 15%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT