This case study focuses on a medium-sized enterprise operating in the textile industry, specifically in apparel manufacturing. The primary challenge identified in the manufacturing unit was the efficient utilization of resources. The study outlined constraints related to various resources, including threads, fabrics, human resources, overheads, stitching, cutting, and finishing time. Additionally, it examined the production requirements for five products, namely Polo T-shirts, round neck T-shirts, basic T- shirts, singlets, and v-neck T-shirts. The resources requirement for the products and their respective maximum held value are as shown in Table 1 and Table 2 respectively. The demand and profit of the products are tabulated in Table 3. Table 1. Resource allocation product-wise Fabrics Thread Labor Overhead Cutting meters RM (hours) .03 215 11 105 142 Products (T-shirts and pants) Polo T- shirt Basic T-shirt Round Neck T-shirt Singlets V neck T- shirt (a) (b) (c) gms 315 200 195 180 50 105 190 Demand 15000 Profit 4.5 5 6 Polo T-shirt 4.5 7 Cutting (HOURS) Sewing (HOURS) Finishing (HOURS) RM 31 19 20 15.5 37 Basic T-shirt 24000 3.8 Table 2. Resource utilization and maximum value held in stock Resource utilized Maximum held value Fabric(gram) 3,71,25,000 Thread(meter) 2,56,21,830 Labor(RM) 10,01,000 Overheads(RM) 50,00,000 5,775 44,500 6,200 Table 3. Demand and profit table 288888 .02 Formulate the LP model for the above case study. .03 .02 .04 Round neck T-shirt Singlets 12000 26000 3.5 3 Sewing (hours) 35 15 16 .09 31 V neck T-shirt 11000 6.5 Finishing Time (hours) 288881 .03 .02 .03 .02 .04 Convert the LP model in (a) into simplex algorithm by using slack/surplus/artificial variables. Recommend an optimal product mix that maximizes company profits through the application of the Linear Programming method using Excel (Solver) software. Provide SOLVER Answer Report, Sensitivity Report, and Excel Sheet of your analysis.
This case study focuses on a medium-sized enterprise operating in the textile industry, specifically in apparel manufacturing. The primary challenge identified in the manufacturing unit was the efficient utilization of resources. The study outlined constraints related to various resources, including threads, fabrics, human resources, overheads, stitching, cutting, and finishing time. Additionally, it examined the production requirements for five products, namely Polo T-shirts, round neck T-shirts, basic T- shirts, singlets, and v-neck T-shirts. The resources requirement for the products and their respective maximum held value are as shown in Table 1 and Table 2 respectively. The demand and profit of the products are tabulated in Table 3. Table 1. Resource allocation product-wise Fabrics Thread Labor Overhead Cutting meters RM (hours) .03 215 11 105 142 Products (T-shirts and pants) Polo T- shirt Basic T-shirt Round Neck T-shirt Singlets V neck T- shirt (a) (b) (c) gms 315 200 195 180 50 105 190 Demand 15000 Profit 4.5 5 6 Polo T-shirt 4.5 7 Cutting (HOURS) Sewing (HOURS) Finishing (HOURS) RM 31 19 20 15.5 37 Basic T-shirt 24000 3.8 Table 2. Resource utilization and maximum value held in stock Resource utilized Maximum held value Fabric(gram) 3,71,25,000 Thread(meter) 2,56,21,830 Labor(RM) 10,01,000 Overheads(RM) 50,00,000 5,775 44,500 6,200 Table 3. Demand and profit table 288888 .02 Formulate the LP model for the above case study. .03 .02 .04 Round neck T-shirt Singlets 12000 26000 3.5 3 Sewing (hours) 35 15 16 .09 31 V neck T-shirt 11000 6.5 Finishing Time (hours) 288881 .03 .02 .03 .02 .04 Convert the LP model in (a) into simplex algorithm by using slack/surplus/artificial variables. Recommend an optimal product mix that maximizes company profits through the application of the Linear Programming method using Excel (Solver) software. Provide SOLVER Answer Report, Sensitivity Report, and Excel Sheet of your analysis.
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...
Related questions
Question
Transcribed Image Text:(d)
The company has some extra funds and is trying to increase the company's profit by
increasing the resource(s) constraints capacity. BASED ON THE EXCEL SOLVER REPORTS in (c)
propose and justify which constraint(s) the company should invest in to increase its profit.
Transcribed Image Text:This case study focuses on a medium-sized enterprise operating in the textile industry, specifically in
apparel manufacturing. The primary challenge identified in the manufacturing unit was the efficient
utilization of resources. The study outlined constraints related to various resources, including threads,
fabrics, human resources, overheads, stitching, cutting, and finishing time. Additionally, it examined
the production requirements for five products, namely Polo T-shirts, round neck T-shirts, basic T-
shirts, singlets, and v-neck T-shirts. The resources requirement for the products and their respective
maximum held value are as shown in Table 1 and Table 2 respectively. The demand and profit of the
products are tabulated in Table 3.
Table 1. Resource allocation product-wise
Products (T- shirts and
pants)
Polo T-shirt
Basic T-shirt
Round Neck T-shirt
Singlets
V neck T-shirt
(a)
(b)
(c)
Fabrics
gms
315
200
195
180
50
Thread
meters
215
105
142
105
190
Demand
Profit
Labor
RM
11
5
6
4.5
7
Polo T-shirt
15000
4.5
Fabric(gram)
Thread(meter)
Labor(RM)
Overhead Cutting
(hours)
.03
.02
.03
.02
.04
Table 2. Resource utilization and maximum value held in stock
Resource utilized Maximum held value
3,71,25,000
2,56,21,830
10,01,000
Overheads(RM) 50,00,000
Cutting(HOURS) 5,775
Sewing(HOURS) 44,500
Finishing (HOURS) 6,200
RM
31
19
20
15.5
37
Table 3. Demand and
profit table
Basic T-shirt Round neck T-shirt
24000
3.8
12000
3.5
Formulate the LP model for the above case study.
Sewing
(hours)
35
.15
16
.09
31
Singlets Vneck T-shirt
26000
11000
3
6.5
Finishing Time
(hours)
.03
.02
.03
.02
.04
Convert the LP model in (a) into simplex algorithm by using slack/surplus/artificial variables.
Recommend an optimal product mix that maximizes company profits through the application
of the Linear Programming method using Excel (Solver) software. Provide SOLVER Answer
Report, Sensitivity Report, and Excel Sheet of your analysis.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.