2.S1.
Back Savers
Production Problem
Group 1
OUR TEAM
Nguyễ n Công Tuấ n Anh Content
Nguyễ n Ngọc Minh Đoan Present, Excel, Clip
Bùi Hoàng Thảo My Slide
Dương Tố Quyên Slide
Huỳnh Bảo Trân Leader, Excel, Content
TABLE OF CONTENTS
I IDENTIFY SITUATION IV SOLUTIONS
II OBJECTIVES V CONCLUSION
III MODEL CONDUCT
I. IDENTIFY SITUATION
MINI COLLEGIATE
01
Back Savers company manufactures backpacks
for students and offers two product models: the
Collegiate and the Mini.
02 The company faces limited resources in
terms of nylon material and labor hours.
03 Each backpack model requires different
amounts of material and production time.
Therefore,
Back Savers needs to determine
the optimal weekly production
quantities of each backpack
model to use its available
resources efficiently.
How
II. OBJECTIVES
many
To determine the number of
Collegiate and Mini backpacks to
produce each week so as to
maximize total profit, while
satisfying constraints (material
availability, labor capacity, and
market demand.)
III. MODEL CONDUCT
Decisions
C: number of Collegiate backpacks produced per week
M: number of Mini backpacks produced per week
Z: total profit
Objective function
Each Collegiate backpack generates a profit of $32 and
each Mini backpack generates a profit of $24
Max Z = 32C + 24M
III. MODEL CONDUCT Constraints
Materials: Nylon 3C + 2M ≤ 5000
Back Savers receives 5,000 square feet of nylon each week. Each Collegiate backpack requires
3 square feet of nylon, and each Mini backpack requires 2 square feet.
Time 45C + 40M ≤ 84000
35 workers, each working 40 hours per week ⟶ 84,000 minutes of labor available per week.
Each Collegiate backpack requires 45 minutes of labor, while each Mini backpack requires 40
minutes.
Sales forecast 0 ≤ C ≤ 1000
Sales forecasts indicate that at most 1,000 Collegiate
backpacks and 1,200 Mini backpacks can be sold per week. 0 ≤ M ≤ 1200
IV. SOLUTIONS
The spreadsheet The algebraic The graphical
method method method
1) Consider point Cmax= 1000 and determine the
remaining variable: Maximize Profit:
45(1000) + 40M = 84,000 Z = 32C + 24M
⇒ M = 975 (3C + 2M = 4950 ≤ 5000)
⇒ Zmax = 55,400 Subject to:
3C + 2M ≤ 5000
2) Consider point Mmax = 1200 and determine the 45C + 40M ≤ 84,000
remaining variable: 0 ≤ C ≤ 10000
45C + 40 (1200) = 84,000 0 ≤ M ≤ 12000
⇒ C = 800 (3C + 2M = 4800 ≤ 5000)
⇒ Zmax = 54,400
In conclusion:
Zmax = 55,400 at Cmax= 1000 and M = 975
V. CONCLUSION
The optimal production plan is
1000
to produce 1000 Collegiate
backpacks and 975
975 Mini
backpacks per week. This
solution yields a maximum
$55,400
weekly profit of $55,400
V. CONCLUSION
The optimal solution occurs because:
Collegiate backpacks have higher profit per unit
→ produced at maximum level
Remaining labor capacity allocated to Mini
backpacks
This production mix maximizes total profit
All resource and market constraints are satisfied
V. CONCLUSION
Labor and Collegiate demand are binding
constraints, with all 84,000 labor minutes used
and 1,000 Collegiates produced.
The nylon constraint is non-binding: 4,950 sq ft
is used, leaving 50 sq ft unused, because
labor becomes limiting before the material
capacity is reached.
Thank you for
attentive listening!
Evaluator Criteria Tuấ n Anh Minh Đoan Thảo My Tố Quyên Bảo Trân
Participation attitude — 9 8.5 9 9
Tuấ n Anh Discussion skills — 8.5 9 9 8.5
Quality of comments — 8 8.3 8 9.5
Participation attitude 8 — 9 9.5 9
Minh Đoan Discussion skills 8.5 — 8.8 8.8 9
Quality of comments 8 — 8 8.5 9.5
Participation attitude 8.5 9 — 9 9
Thảo My Discussion skills 9 8.5 — 8.8 9
Quality of comments 8.5 8.8 — 8.5 8.8
Participation attitude 8 9 9 — 9
Tố Quyên Discussion skills 9.5 9 9.5 — 9.5
Quality of comments 8 8.5 8.5 — 9
Participation attitude 8.5 9 9 9 —
Bảo Trân Discussion skills 8.5 8.8 8.5 8.8 —
Quality of comments 8 9 8.5 8.5 —