Given below is an LP for a furniture manufacturing company. Maximize Z= 5 x, + 6 x, (profit, RM) 2 x, +x, < 120 (labour, hr) 2 x, + 3 x, < 240 (wood, meter) Subject to: X, x, > 0 Based on the sensitivity analysis results obtained using Excel Solver for the above LP model, answer questions (a) to (c). Variable Cells Final Reduced Objective Allowable Allowable Cll Name Value Cost Coefficient Increase Decrease $B$10 X1 = 30 5 7 1 $B$11 X2 = 60 1.5 3.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$6 Constraint 1 Usage 120 0.75 120 120 40 $E$7 Constraint 2 Usage 240 1.75 240 120 120 a) At the optimal solution, how much labour hours was utilized? b) Suppose that the available wood is increased by 50%, what will happen to the optimal solution? c) Suppose that the manager receives an offer from a supplier to get 5 meter of wood at the cost of RM2.50 per meter, should he/she take the offer? Justify your answer.

Given below is an LP for a furniture manufacturing company. Maximize Z= 5 x, + 6 x, (profit, RM) 2 x, +x, < 120 (labour, hr) 2 x, + 3 x, < 240 (wood, meter) Subject to: X, x, > 0 Based on the sensitivity analysis results obtained using Excel Solver for the above LP model, answer questions (a) to (c). Variable Cells Final Reduced Objective Allowable Allowable Cll Name Value Cost Coefficient Increase Decrease $B$10 X1 = 30 5 7 1 $B$11 X2 = 60 1.5 3.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$6 Constraint 1 Usage 120 0.75 120 120 40 $E$7 Constraint 2 Usage 240 1.75 240 120 120 a) At the optimal solution, how much labour hours was utilized? b) Suppose that the available wood is increased by 50%, what will happen to the optimal solution? c) Suppose that the manager receives an offer from a supplier to get 5 meter of wood at the cost of RM2.50 per meter, should he/she take the offer? Justify your answer.

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...

See similar textbooks

Similar questions

A10
Don't use Ai
Using back-substitution, show that an ARMA(1, 1) model may be written as eitheran AR or an MA model.
For the next 6 numbers: Refer to the Management Scientist output of a maximization LP problem. The constraints are defined as follows: Constraint 1: advertising budget ( ) Constraint 2: sales force availability ( ) Constraint 3: production level (=) Constraint 4: retail stores requirement ( ) Optimal Solution Objective Function Value - Variable. Constraint X1 X2 X1 X2 X3 X4 X3 X4 1 2 Variable 1 2 3 3 4 OBJECTIVE COEFFICIENT RANGES 4 Constraint RIGHT HAND SIDE RANGES Value Slack/Surplus Lover Limit 25.000 425.000 150.000 0.000 84.000 50.000 No Lover Linit No Lover Linit Lover Limit 48450.000 0.000 25.000 0.000 0.000 4950.000 1775.000 515.000 0.000 Reduced Costs Dual Prices Current Value 90.000 84.000 70.000 60.000 Current Value 0.000 0.000 0.000 45.000 5000.000 1800.000 600.000 150.000 3.000 0.000 60.000 -17.000 Upper Limit No Upper Linit 90.000 87.000 105.000 Upper Linit 5850.000 No Upper Limit 603.571 200.000
Don't use chatgpt...
One of the assumptions made in simple regression is that ______________. a. the error terms are exponentially distributed b. the error terms have unequal variances c. the model is linear d. the error terms are dependent e. the model is nonlinear
1. 524 plz help w/ anything. a) is correct, need help with B
Show that Jσ_(ij)D_(ij)=T_(iL)F_(iL˙)=S(AB)E_(AB˙) [Hints: (a) to prove the first equation, use the relationship between F_(iL)˙ and L_(ij), and expand L_(ij) into symmetric and antisymmetric parts. Note the symmetry of σ_(ij). (b) To prove the second equation, first express E_(AB)˙ using F_(iL), then take the time derivative. Substitute into the definition of S_(AB )in index form and simplify.]
A and b please
Use the following theorem. = If F(s) L{f(t)} and n = 1,2,3, dots, n n then L{i" f(1)} = (- 1)" d² _F(s). ds n Evaluate the given Laplace transform. (Write your answer as a function of s .) L{4t cos(t)}
typing clear urjent
Yearly Sales data for a product is given in Table SS Table SS (Yearly Sales) Sales (S) P(S) 120 0.12 140 0.25 160 0.17 180 0.25 200 0.09 220 0.12 Using the data in Table SS and the random numbers, 0.06, 0.10, 0.87, 0.14, 0.86, 0.32 the correct simulation of sales for 6 years is given by which of the following: IV 120 140 200 II II 120 120 120 200 120 120 120 200 200 140 180 180 140 200 140 140 180 180 140 140 140 Select one: O a. l O b. II Oc. II O d. IV 10:47 AM Ca D) ENG 12/16/2021 29°C