Reference no: EM132392822
Answer the following Questions
Question 1. A textile manufacturer has received fifteen orders for one of its main products. These orders have to be fulfilled in the next 13 weeks. Orders can be fulfilled by production on either Machine A or Machine B, or by outsourcing the production. Due to some special requirements, the first four orders cannot be produced on Machine B. The company owns 15 machines type A and 80 machines type B. The machines operate 24 hours per day and 7 days per week.
Each machine is down for regular maintenance 2 hours per week. Assume that orders may be split between machines and any fraction may be outsourced. Company policies dictate that no more than half of an order may be outsourced. For instance, for an order of 10,000 yards, no more than 5,000 yards may be outsourced. The following table shows the order size (in yards), the number of yards that each machine can produce per hour, the cost per yard for each machine and for the outsourcing option.
Order
|
Size (yds)
|
Machine A Yds/hr Cost/yd
|
Machine B Yds/hr Cost/yd
|
Outsourcing Cost/yd
|
1
|
14000
|
4.510
|
$2.66
|
|
|
$2.77
|
2
|
52000
|
4.796
|
$2.55
|
|
|
$2.73
|
3
|
44000
|
4.629
|
$2.64
|
|
|
$2.85
|
4
|
20000
|
4.256
|
52.56
|
|
|
$2.73
|
5
|
77500
|
5.145
|
51.61
|
5.428
|
$1.60
|
$1.76
|
6
|
109500
|
3.806
|
$1.62
|
3.935
|
$1.61
|
$1.76
|
7
|
120000
|
4.168
|
$1.64
|
4.316
|
$1.61
|
$1.76
|
8
|
60000
|
5.251
|
$1.48
|
5.356
|
$1.47
|
$1.59
|
9
|
7500
|
5.223
|
51.50
|
5.277
|
$1.50
|
51.71
|
10
|
69500
|
5.216
|
$1.44
|
5.419
|
$1.42
|
$1.63
|
11
|
68500
|
3.744
|
$1.64
|
3.835
|
$1.64
|
$1.80
|
12
|
83000
|
4.157
|
$1.57
|
4.291
|
$1.56
|
$1.78
|
13
|
10000
|
4.422
|
$1.49
|
4.558
|
$1.48
|
$1.63
|
14
|
381000
|
5.281
|
$1.31
|
5.353
|
$1.30
|
$1.44
|
15
|
64000
|
4.222
|
$1.51
|
4.288
|
$1.50
|
$1.69
|
a. Formulate a linear programming model for this problem. What is the optimal production plan and associated cost?
Answer the following questions using information from the Sensitivity Report. Show the calculations associated with your answers.
b. How would the total cost change if one of the machines type A broke down and could not be used for 5 weeks to fulfill these orders?
c. How would the total cost change if an additional machine type B would be available for one week to work on these orders?
d. If the outsource policy is not applied to order 13 (i.e., if more than half of order 13 could be outsourced), would the optimal production/outsourcing plan change? Why?
e. If the company is able to negotiate a 5% discount on the outsource cost for order 10, would the optimal production/outsourcing plan change? Why?
f. The customer that placed order 5 would like to increase the order size to 80,000 yards. What would be the cost associated with the additional yards?
Question 2. A university administrator believes that some academic departments might be overstaffed and perhaps over budget. She would like to identify some potential budget, faculty, and staff reductions.
The administrator has collected data from last academic year for 26 academic departments, for which she considers the main inputs to be their annual budget (in thousands), the number of faculty, and the size of the administrative staff. She thinks that the main outputs are the number of publications per year and the size of the graduating class.
Dept.
|
Budget
|
Faculty
|
Staff
|
Pubs
|
Grads
|
A
|
9127
|
74
|
32
|
48
|
346
|
B
|
4221
|
32
|
20
|
155
|
142
|
C
|
22514
|
181
|
94
|
121
|
1453
|
D
|
759
|
3
|
10
|
S
|
41
|
E
|
2272
|
19
|
8
|
18
|
36
|
F
|
2907
|
13
|
31
|
24
|
285
|
G
|
12391
|
112
|
24
|
236
|
201
|
H
|
44981
|
366
|
175
|
503
|
790
|
|
1471
|
6
|
18
|
1
|
45
|
J
|
16154
|
137
|
52
|
S
|
184
|
IC
|
12169
|
97
|
49
|
98
|
1326
|
L
|
25876
|
207
|
97
|
257
|
1826
|
M
|
1479
|
S
|
18
|
6
|
126
|
N
|
851
|
4
|
9
|
2
|
105
|
0
|
4472
|
30
|
27
|
48
|
71
|
|
10291
|
90
|
25
|
109
|
179
|
0
|
2215
|
12
|
22
|
142
|
226
|
R
|
5345
|
42
|
21
|
10
|
260
|
|
10384
|
91
|
25
|
90
|
215
|
T
|
4166
|
33
|
18
|
155
|
74
|
U
|
3490
|
17
|
33
|
46
|
71
|
V
|
104130
|
963
|
149
|
1457
|
143
|
|
9754
|
74
|
47
|
45
|
110
|
X
|
9119
|
78
|
28
|
96
|
135
|
|
4076
|
30
|
20
|
104
|
84
|
|
5782
|
44
|
28
|
46
|
135
|
Use data envelopment analysis to determine whether there is any reason to believe that Department L is overstaffed and over budget.
a. Is this department relatively efficient?
b. What is this department reference set?
c. According to the DEA model, at what budget, faculty, and administrative staff levels should this department have to operate in order to be efficient compared to the other departments at this university?