Page 70 - DCAP208_Management Support Systems
P. 70
Unit 5: Modeling and Analysis
X = units of CC-8 Notes
2
The result variable:
Total profit = Z
The objective is to maximize:
Z = 8,000X +12,000X
1 2
The uncontrollable variables (constraints):
Labor constrain: 300X + 500X ≤ 200,000
1 2
Budget constrain: 10,000X +15,000X ≤ 8,000,000
1 2
Marketing requirement for CC-7: X ≥ 100
1
Marketing requirement for CC-8: X ≥ 200
2
The Mathematical Model is:
Figure 5.5: Mathematical Model
Source: http://www.cs.ubbcluj.ro/~per/Dss/Dss_10.pdf
The Excel Solver Solution is:
Figure 5.6: Excel Solver Solution
Source: http://www.cs.ubbcluj.ro/~per/Dss/Dss_10.pdf
LOVELY PROFESSIONAL UNIVERSITY 63
