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...
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?
Toys is a large discount toy store in Valley Wood Mall. The store typically has slow...
Toys is a large discount toy store in Valley Wood Mall. The store typically has slow sales in the summer months that increase dramatically and rise to a peak at Christmas. During the summer and fall, the store must build up its inventory to have enough stock for the Christmas season. To purchase and build up its stock during the months when its revenues are low, the store borrows money. Following is the store’s projected revenue and liabilities schedule for...
A discount appliance store sells iPhones. The store purchases iPhones at a price of $95 per...
A discount appliance store sells iPhones. The store purchases iPhones at a price of $95 per unit. The following information applies to this product. Demand = 20 units/day Order cost = $56/order Annual holding cost = 25% of purchase price Desired cycle-service level = 90% (z=1.28) Lead time = 10 days Standard deviation of daily demand = 4 units Current on-hand inventory 220 units, with no open orders or back orders The store operates 52 weeks per year, 6 days...
A discount appliance store sells iPhones. The store purchases iPhones at a price of $95 per...
A discount appliance store sells iPhones. The store purchases iPhones at a price of $95 per unit. The following information applies to this product. Demand = 20 units/day Order cost = $56/order Annual holding cost = 25% of purchase price Desired cycle-service level = 90% Lead time = 10 days Standard deviation of daily demand = 4 units Current on-hand inventory 220 units, with no open orders or back orders The store operates 52 weeks per year, 6 days per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT