Mark has a company that produces tables and chairs, both having two different models. The product models and related information are given in the following table. Wood costs 3000 $ per cubic meter and 200 m3 of wood are available for the upcoming month. The cost of labor is 40 $/hour and there are 6000 hours of labor available in a month. Mark sells his products to a big chain retail company. The company purchases all products whatever Mark produces. Mark formulates an LP as follows to determine the optimal monthly production plan such that he maximizes the total profit. Decision Variables: X1 : number of basic tables to be produced. X2 : number of elegant tables to be produced. X3 : number of basic chairs to be produced. X4 :number of elegant chairs to be produced. Max Z = 140 X1 + 345 X2 + 120 X3 + 260 X4 ( maximize total profit) Subject to 0.11 X1 + 0.13 X2 + 0.06 X3 + 0.07 X4 ≤ 200 (constraint on the available amount of wood) 2 X1 + 4.5 X2 + 1.5 X3 + 4 X4 ≤ 6000 (constraint on the available amount of labor hours) Mark has run that model and found the optimal solution of the problem as follows. a) Another customer requests to buy 250 elegant chairs with the price of 660 $ each. Notice that the current selling price of elegant chair is 630 $ each. Should Mark accept or decline the offer? Why? Explain your answer by referring the terms in standard and sensitivity analysis, i.e. dual price, reduced cost, allowable increase/decrease etc. Assume that the available amounts of labor hours and wood remains constant and the retail company does not object to that deal if Mark accepts. b) Mark considers to hire one or two more employees to increase his production and hence his profit. However he doesn’t want to change the current production plan (doesn’t want to change the basis) One additional employee adds 40 hours/month to the labor resource. Should Mark hire new employee(s)? If not, why? If yes, how many and why? Explain your answer by referring the terms in standard and sensitivity analysis, i.e. dual price, reduced cost, allowable increase/decrease etc. c) Because of the sickness and some other reasons, some days, employees arrive late to the factory or don’t show up that day. Therefore some loss in labor resource is observed. How much total loss should Mark tolerate in labor hours without changing the current production plan (without changing the basis)? Explain your answer by referring the terms in standard and sensitivity analysis, i.e. dual price, reduced cost, allowable increase/decrease etc.
Mark has a company that produces tables and chairs, both having two different models. The product models and related information are given in the following table.
Wood costs 3000 $ per cubic meter and 200 m3 of wood are available for the upcoming month. The cost of labor is 40 $/hour and there are 6000 hours of labor available in a month. Mark sells his products to a big chain retail company. The company purchases all products whatever Mark produces.
Mark formulates an LP as follows to determine the optimal monthly production plan such that he maximizes the total profit.
Decision Variables:
X1 : number of basic tables to be produced.
X2 : number of elegant tables to be produced.
X3 : number of basic chairs to be produced.
X4 :number of elegant chairs to be produced.
Max Z = 140 X1 + 345 X2 + 120 X3 + 260 X4 ( maximize total profit)
Subject to
0.11 X1 + 0.13 X2 + 0.06 X3 + 0.07 X4 ≤ 200 (constraint on the available amount of wood)
2 X1 + 4.5 X2 + 1.5 X3 + 4 X4 ≤ 6000 (constraint on the available amount of labor hours)
Mark has run that model and found the optimal solution of the problem as follows.
a) Another customer requests to buy 250 elegant chairs with the price of 660 $ each. Notice that the current selling price of elegant chair is 630 $ each.
Should Mark accept or decline the offer? Why? Explain your answer by referring the terms in standard and sensitivity analysis, i.e. dual price, reduced cost, allowable increase/decrease etc.
Assume that the available amounts of labor hours and wood remains constant and the retail company does not object to that deal if Mark accepts.
b) Mark considers to hire one or two more employees to increase his production and hence his profit. However he doesn’t want to change the current production plan (doesn’t want to change the basis) One additional employee adds 40 hours/month to the labor resource.
Should Mark hire new employee(s)? If not, why? If yes, how many and why?
Explain your answer by referring the terms in standard and sensitivity analysis, i.e. dual price, reduced cost, allowable increase/decrease etc.
c) Because of the sickness and some other reasons, some days, employees arrive late to the factory or don’t show up that day. Therefore some loss in labor resource is observed.
How much total loss should Mark tolerate in labor hours without changing the current production plan (without changing the basis)?
Explain your answer by referring the terms in standard and sensitivity analysis, i.e. dual price, reduced cost, allowable increase/decrease etc.
![Required Amount of Wood Required Amount
of Labor (hours)
Product &
Selling Price
Model
(m³ )
XI
X2
X3
X4
Basic Table
0.11
550
The revenue
550
915
360
630
Elegant Table
0.13
4.5
915
Cost of Wood
3000 * 0.11 = 330
3000 * 0.13 = 390
3000 *0.06 = 180
3000 * 0.07 = 210
Cost of Labor
40 * 2= 80
40 * 4.5= 180
40 * 1.5= 60
40 * 4= 160
Basic Chair
0.06
1.5
360
Profit
140
345
120
260
Elegant Chair
0.07
4
630](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffb650c15-3f19-49fb-84da-aee351321c46%2Fbd99450e-869d-45a7-a803-6623e851b7a8%2Ffzeexsh_processed.jpeg&w=3840&q=75)
![Global optimal solution found.
Objective value:
468000.0
Objective Coefficient Ranges:
Variable
Value
Reduced Cost
X1
0.000000
29.00000
Current
Allowable
Allowable
0.000000
0.000000
X2
800.0000
Variable
Coefficient
Increase
Decrease
1600.000
0.000000
X3
X1
140.0000
29.00000
INFINITY
X4
33.00000
X2
345.0000
15.00000
18.33333
Slack or Surplus
468000.0
Row
Dual Price
X3
120.0000
12.07317
5.000000
1
1.000000
0.000000
0.000000
2
300.0000
X4
260.0000
33.00000
INFINITY
3
68.00000
Righthand Side Ranges:
Current
Allowable
Allowable
Row
RHS
Increase
Decrease
2
200.0000
40.00000
26.66667
3
6000.000
923.0769
1000.000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffb650c15-3f19-49fb-84da-aee351321c46%2Fbd99450e-869d-45a7-a803-6623e851b7a8%2Fkzzxv8v_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)