Formulate an LP

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...
icon
Related questions
Question

A production department requires different numbers of full-time employees on different days of the week. The number of full-time employees required on each day is given (see Table). Union rules state that each full-time employee must work five consecutive days and then two days off. For example, if an employee works Monday to Friday, he/she will be off on Saturday and Sunday. Suppose that the production department wants to meet its daily requirements using only full-time employees. Formulate an LP that the production department can use to minimize the number of full time employees who must be hired. Day # of Full-Time Employees Required Monday 17 Tuesday 13 Wednesday 15 Thursday 19 Friday 14 Saturday 16 Sunday 11 a) Suppose that the number of workers needed on day i is di . Let wi be the actual number of workers on day i. Formulate an LP where the “cost” of having too many workers on day i is fi (wi – di). b) Suppose that the production department wants to minimize the maximum of the surpluses on each day (max (w1 – d1, w2 – d2,…, w7 – d7)). Formulate an LP. c) Suppose that the production department wants to ensure that at least 30% of the workers have Sunday off. Formulate a constraint for this case.

Sunday. Suppose that the production department wants to meet its daily requirements using only
full-time employees. Formulate an LP that the production department can use to minimize the
number of full time employees who must be hired.
# of Full-Time Employees Required
17
Day
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
13
15
19
14
16
11
Incorrect Formulation:
X;: the number of employees working on day i
Minimize Z=x1 + x2 + X3 + X4 + Xs + X6 + X7
17 ב s.t.x
X2 2 13
X3 2 15
X4 2 19
Xs 2 14
X6 2 16
X72 11
Xị 2 0, vi = 1,2,...,7
In this formulation, objective function is not the number of full-time employees. The current objective
function counts each employee five times, not once. For example, each employee who starts work on
Monday works Monday to Friday and is included in x1, x., x3, X4 and xs. The key to corectly
formulating this problem is to realize that the production department's primary decision is not how
many people are working each day but rather how many people begin work on each day of the week.
Correct Formulation:
Xị : the number of employees beginning work on day i
Minimize Z=x, +x, +x, +x, +X, +x, +X,
+*,+x, +*,
X, +
X, +x, +
X, +X, +x, +
X +x, +x, +x, +
*, + x, + x, + x, + x,
x, +x, +x, +X,+x,
X, + X, + X, + x, + x, 211
x 20, Vi = ,2,.,7
+X, +x, + x, +x,217
+ x, +x, + x,2 13
x+x,2 15
*X,2 19
2 14
s.t.
2 16
Transcribed Image Text:Sunday. Suppose that the production department wants to meet its daily requirements using only full-time employees. Formulate an LP that the production department can use to minimize the number of full time employees who must be hired. # of Full-Time Employees Required 17 Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday 13 15 19 14 16 11 Incorrect Formulation: X;: the number of employees working on day i Minimize Z=x1 + x2 + X3 + X4 + Xs + X6 + X7 17 ב s.t.x X2 2 13 X3 2 15 X4 2 19 Xs 2 14 X6 2 16 X72 11 Xị 2 0, vi = 1,2,...,7 In this formulation, objective function is not the number of full-time employees. The current objective function counts each employee five times, not once. For example, each employee who starts work on Monday works Monday to Friday and is included in x1, x., x3, X4 and xs. The key to corectly formulating this problem is to realize that the production department's primary decision is not how many people are working each day but rather how many people begin work on each day of the week. Correct Formulation: Xị : the number of employees beginning work on day i Minimize Z=x, +x, +x, +x, +X, +x, +X, +*,+x, +*, X, + X, +x, + X, +X, +x, + X +x, +x, +x, + *, + x, + x, + x, + x, x, +x, +x, +X,+x, X, + X, + X, + x, + x, 211 x 20, Vi = ,2,.,7 +X, +x, + x, +x,217 + x, +x, + x,2 13 x+x,2 15 *X,2 19 2 14 s.t. 2 16
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.