Question: Question number 4 Using excel solver, solve the following LP problem. x1= number of tables to be made x2= number of chairs to be made

Question number 4 Using excel solver, solve the following LP problem. x1= number of tables to be made x2= number of chairs to be made x3= number of TV standsto be made Mincost(Z)=50x1+30x2+10x3 (currency used is in dollars) Subject to 2x1+4x2+5x390Maxwood5x1+2x2+2x380Minfiberx3=3demandforTV-standx27Mindemandforchairsx1,x2,x30(Non-negativityconstraint) Note that fractional values for the variables are acceptable. Use two decimal places to provide answers to questions 4 through 8 1. Generate Input Sheet 2. Answer report 3. Sensitivity report 5 marks 7.5 marks 7.5 marks 5420 marks Each of the following questions carries three marks 4. What are the critical resources? Of all resources, if given an option, which will you buy, how many units, and why? 5. What is the shadow price of the Min TV set constraint? What do you understand from this? 6. What is the new cost if we add 1 unit of fiber and if the min TV stand is 5? 7. What is the shadow price for the TV stand (demand)constraint? What does this price imply? Provide your reasons. 8. what is the reduced cost of tables? What do you understand from this? Show your logic with the help of calculation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question number 4 Using excel solver, solve the following LP problem. x1= number of tables to be made x2= number of chairs to be made x3= number of TV standsto be made Mincost(Z)=50x1+30x2+10x3...

Question number 1. Using excel solver, solve the following LP problem. xnumber of tables to be made x2 number of chairs to be made X3 number of TV stands to be made Maximize Profit (Z)=50x +30 x2...

Using excel solver, solve the following LP problem. x1= number of tables to be made x2= number of chairs to be made x3= number of TV-stands to be made Mincost(Z)=40x1+20x2+15x3 Subject to...

i already found 1 to 3 need your help from 4 to 8 thank you Using excel solver, solve the following LP problem. x1= number of tables to be made x2= number of chairs to be made x3= number of TV-stands...

Question number 1. Using excel solver, solve the following LP problem. x1= number of tables to be made x2= number of chairs to be made x3= number of TV stands to be made Maximize Revenue...

i did 1 to 3 need help with 4 to 8 Worksheet: [Book1]Sheet1 Report Created: 9/30/2022 3:50:37 PM Variable Cells Constraints Objective Cell (Min) Variable Cells 6 Constraints Using excel solver, solve...

solve 5 to 8 I dont need 1 to 5 as i have already done the excel sheet Question number 3 Using excel solver, solve the following LP problem. x1=number of Economy type fans to be made x2= number of...

Question number 3 Using excel solver , solve the following LP problem. =number of necklaces to be made = number of bracelets to be made = number of ear-studs to be made Maximize Profit (Z) = 70x1 +...

Using excel solver, solve the following LP problem. X number of tables to be made X= number of chairs to be made X3 number of TV stands to be made Min cost (Z) = 40 x +20 x +15 X3 (currency used is...

please answer question 8 Question number 1. Using excel solver, solve the following LP problern. x1-number of tables to be made x2= number of chairs to be made x3= number of TV stands to be made...

2. Suppose that o is bounded and continuous everywhere except for a jump discontinuity at a e R, i.e. the right- and left-sided limits (a+) and (a-) exist where $(x*) = lim (y) & (a) = lim o(y) ytx...

Answer true or false. If the statement is false, explain why or give a counterexample. a. A grade of 86% is always better than being in the 86th percentile. b. A mean is always greater than a median....

0 1 = 2 3 5 0 3 Tine Remalining Multiple Choice 3 . 5 points hich of the following is correct regarding a bond's YTM ? The YTM is higher than the coupon rate when the bond is trading below $ 1 . 0 0...

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...