Formulate this problem as an LP (đo not solve. Just ABC company produces and sells wooden desks. The demand is forecasted for each month of the next year. The company currently has 20 employees and each employee can produce 30 desks in a month. The monthly salary of each employee is $110. Since raw material cost change at each month, the production costs are different for each month of the year. Excessive amount produced in a month can be stored in the inventory for use in the following months. However, the storage space has a capacity of 300 desks in total. The inventory holding costs are also different at each month. In order to satisfy excessive demand in a month, the company may use its inventories, may implement overtime working hours, or hire additional workers. The total overtime production for each worker at each month can be at most 10% of the regular time production. Also the overtime production cost is different than the regular time production cost. Furthermore, the maximum number of workers who can work in the company at the same time is 25. It is also possible to fire the workers but the workforce cannot be less than 15. Hiring and firing costs differ each month. The objective function is to minimize the total cost.
Formulate this problem as an LP (đo not solve. Just ABC company produces and sells wooden desks. The demand is forecasted for each month of the next year. The company currently has 20 employees and each employee can produce 30 desks in a month. The monthly salary of each employee is $110. Since raw material cost change at each month, the production costs are different for each month of the year. Excessive amount produced in a month can be stored in the inventory for use in the following months. However, the storage space has a capacity of 300 desks in total. The inventory holding costs are also different at each month. In order to satisfy excessive demand in a month, the company may use its inventories, may implement overtime working hours, or hire additional workers. The total overtime production for each worker at each month can be at most 10% of the regular time production. Also the overtime production cost is different than the regular time production cost. Furthermore, the maximum number of workers who can work in the company at the same time is 25. It is also possible to fire the workers but the workforce cannot be less than 15. Hiring and firing costs differ each month. The objective function is to minimize the total cost.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
Related questions
Question
100%
Please formulate this problem as an LP. (Just formulation).
![Formulate this problem as an Lp (do not solve. Just formulate)
ABC company produces and sells wooden desks. The demand is forecasted for each month of the next
year. The company currently has 20 employees and each employee can produce 30 desks in a month.
The monthly salary of each employee is $110. Since raw material cost change at each month, the
production costs are different for each month of the year. Excessive amount produced in a month can
be stored in the inventory for use in the following months. However, the storage space has a capacity of
300 desks in total. The inventory holding costs are also different at each month. In order to satisfy
excessive demand in a month, the company may use its inventories, may implement overtime working
hours, or hire additional workers. The total overtime production for each worker at each month can be
at most 10% of the regular time production. Also the overtime production cost is different than the
regular time production cost. Furthermore, the maximum number of workers who can work in the
company at the same time is 25. It is also possible to fire the workers but the workforce cannot be less
than 15. Hiring and firing costs differ each month. The objective function is to minimize the total cost.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fcf1f71e2-ebb9-49cf-b056-0adf477c4a7d%2F28920ab4-83f2-44cc-89a5-fef7907dcb84%2Fqv78hlb_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Formulate this problem as an Lp (do not solve. Just formulate)
ABC company produces and sells wooden desks. The demand is forecasted for each month of the next
year. The company currently has 20 employees and each employee can produce 30 desks in a month.
The monthly salary of each employee is $110. Since raw material cost change at each month, the
production costs are different for each month of the year. Excessive amount produced in a month can
be stored in the inventory for use in the following months. However, the storage space has a capacity of
300 desks in total. The inventory holding costs are also different at each month. In order to satisfy
excessive demand in a month, the company may use its inventories, may implement overtime working
hours, or hire additional workers. The total overtime production for each worker at each month can be
at most 10% of the regular time production. Also the overtime production cost is different than the
regular time production cost. Furthermore, the maximum number of workers who can work in the
company at the same time is 25. It is also possible to fire the workers but the workforce cannot be less
than 15. Hiring and firing costs differ each month. The objective function is to minimize the total cost.
![Current
Production
Max.
Storage
Сарacity
Employe
Number of Min Number Salary of
Workers
per
es
Employee
of Workers employees
20
30
300
25
15
110
Inventory
Holding
Cost
Overtime
Production
Production
Firing
Hiring Cost
192
Month
Demand
Cost
Cost
Cost
1
520
8
1
9
312
850
7
8
294
276
670
4
5
300
342
710
2
4
3
282
306
520
6
3
7
276
222
660
8.
3
9
144
294
300
2
9
240
180
400
1
7
252
190
9
470
7
4
8
162
200
10
760
7
5
8
228
200
11
610
4
210
210
12
900
8.
1
9
192
240
43](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fcf1f71e2-ebb9-49cf-b056-0adf477c4a7d%2F28920ab4-83f2-44cc-89a5-fef7907dcb84%2Fr32djya_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Current
Production
Max.
Storage
Сарacity
Employe
Number of Min Number Salary of
Workers
per
es
Employee
of Workers employees
20
30
300
25
15
110
Inventory
Holding
Cost
Overtime
Production
Production
Firing
Hiring Cost
192
Month
Demand
Cost
Cost
Cost
1
520
8
1
9
312
850
7
8
294
276
670
4
5
300
342
710
2
4
3
282
306
520
6
3
7
276
222
660
8.
3
9
144
294
300
2
9
240
180
400
1
7
252
190
9
470
7
4
8
162
200
10
760
7
5
8
228
200
11
610
4
210
210
12
900
8.
1
9
192
240
43
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,