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.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

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
Transcribed Image Text: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
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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.