How soon can this be done????
Applied Management Sciences
To: MVC Enterprises
From: Student Consulting Group
Subject: Optimum production plan
MVC Enterprises is a Computer Production company which can produce four different models with varying configurations. They are named as Student, Plus, Net and Pro. They have defined their configurations as per the table below:
|
|
Student |
Plus |
Net |
Pro |
|
Processor |
Celeron |
Pentium |
Celeron |
Pentium |
|
Hard Drive |
20 GB |
20 GB |
20 GB |
30 GB |
|
Floppy Drivers |
1 |
1 |
2 |
1 |
|
Zip Drive |
Yes |
Yes |
No |
Yes |
|
Audio/Video |
CD R/W |
DVD |
DVD + CD R/W |
DVD + CD R/W |
|
Monitor |
15” |
15” |
17” |
17” |
|
Case |
Tower |
Mini-tower |
Mini-tower |
Tower |
|
Production Time (in hrs.) |
.4 |
.5 |
.6 |
.8 |
|
Unit Profit |
$70 |
$80 |
$130 |
$150 |
Also, MVC must satisfy a contract of minimum 100 Net models per week. They have employed 25 workers with average 30 production hours for each worker per week.
Weekly Resource Availability:
|
Celeron |
700 |
CD R/W |
1600 |
|
Pentium |
550 |
DVD |
900 |
|
20 GB |
800 |
15” |
850 |
|
30 GB |
950 |
17” |
800 |
|
Floppy |
1600 |
Mini Tower |
1250 |
|
Zip |
1000 |
Tower |
750 |
Results:
a.
We can solve this problem linear programming problem of maximization of enterprise profit and we get weekly production schedule for each model for profit maximization.
|
Student |
325 |
|
Plus |
100 |
|
Net |
375 |
|
Pro |
425 |
|
Total Profit |
$143,250 |
It is the optimum quantity levels for each of the four models to maximize profit subject to given constraints.
b.
From the given constraints, it is much more advisable for MVC to produce Pro models in comparison to Plus models wherever possible due to their similar configuration and high difference in per unit profits. For profit maximization, MVC can produce 100 models of Plus models only. They should not produce more models which can hamper them opportunity cost in terms of lost sales for Pro models. But, for remaining unutilized resources, the minimum price for Plus products should be $70 as MVC can produce Student models for better utilization of their resources. If per unit profits for Plus model is lower than $70 then MVC should not produce Plus models.
c.
If MVC can purchase additional 17” monitors at $15 additional cost with other constraints remaining same, we remove 17” monitors constraints to get maximum possible demand for it. MVC can produce more models with 100 more monitors. This increases their overall costs by $1500 and we get new production plan as per below:
|
Student |
275 |
|
Plus |
0 |
|
Net |
425 |
|
Pro |
475 |
|
Total Profit |
$145,750 |
It gives total profits as $145750 with additional cost of $1500. We get Net Profit as $144250 which is higher than first case scenario and hence MVC should explore this opportunity of purchasing additional 17” monitors.
d.
Additional worker can be hired with additional wages of $1000 per week which gives total hours to be 775 instead of 750. But we observe that time is not the binding constraint for this case and additional worker will not increase the production quantity and hence MVC should not employ a new worker.
Recommendations:
MVC enterprises should produce advised quantities of the given models to earn maximum profits. They can explore the option of purchasing 17” monitors to increase their profits by few per cent. Also, in the case analysis, we observe that Celeron processor quantities, 20 GB hard drives, floppy drives, DVD and Tower cases are binding conditions for their production plan. They should explore other opportunities for increasing their resources for above mentioned categories to boost their profits.
References
Lawrence, J. A., & Pasternack, B. A. (2002). Applied management science. New York: Wiley.
Marakas, G. M. (2003). Decision support systems in the 21st century (Vol. 134). ^ eNew Jersey New Jersey: Prentice Hall.
Olson, D. L., & Courtney, J. F. (1992). Decision support models and expert systems. New York: Macmillan.
Stevenson, W. J., & Hojati, M. (2007). Operations management (Vol. 8). Boston: McGraw-Hill/Irwin.
2