Question: please help me with this problem Consider the sensitivity report below: 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 5 Cell Name Value Cost

please help me with this problem

Consider the sensitivity report below: 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 5 Cell Name Value Cost Coefficient Increase Decrease 9 SCS3 x1 50 0 13 0.333333333 2.333333333 10 SD$3 x2 25 0 16 3.5 0.4 1.1 SES3 x3 0 -1.666666667 17 1.666666667 1E+30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 SFSIO Wire Used 100 0 500 1E+30 400 17 SFS11 Nuts Used 700 0 700 1E+30 0 18 SFS12 Bolts Used 700 0.166666667 700 0 60 19 SF513 Motor Used 75 0 200 1E+30 125 20 SFS14 Blades Used 400 2.333333333 400 37.5 50 21 (a) Which constraints are binding? (b) Which constraints are non-binding? (c) What is the increase in the objective value if 10 blades are added? For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). B I y s Paragraph Arial V 10pt : X X > TT + ABC 1 19 12

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!

Which decision variable(s) are non-basic? 9 6 Variable Cells 7 Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4x1 0 - 10.2 12 10.2. 1E+30 10 $C$4x2...

Use the sensitivity report here to answer questions 1-4: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$5 Qty Doors 24 0 500 100 275 $D$5 Qty Windows

A company can decide how many additional labor hours to acquire for a given week. Subcontractors will only work a maximum of 20 hours a week. The company must produce at least 200 units of product A,...

8 9 Part 2: Industrial Designs has used a linear programming model to assign each of its three designers, Lisa, Sarah and David, hours for the LVW label design project. The model is used to minimize...

Devon's Baked Goods would like to maximize its profit from the production of its cookies. Devon produces two types of cookies, Chocolate Chip and Vanilla Sprinkle. Each production line at Devon's has...

76 It has sensitivity analysis below: R+32C900 Cutting and sewing 1/2R+ 3C 300 Finishing 1/8 R + C 100 Packaging and shipping R, C0 Variable Cells Model Final Reduced Objective Allowable Allowable...

The A-B-C department of a large company makes three products A B and C). To determine the best production schedule the manager has formulated the following linear programming model Decision variables...

There is a new product that they can start to produce. This product takes 5 hours at each machine, and requires a total of 10 hours of labour time. This product uses 20 units of raw material. What...

ase Home basics Home Basics is a company that manufactures furniture, such as tables, closets, and beds. The president and CEO of Home Basics, Joe Happylife, wants to establish a better foothold in...

Innis Investment manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client's needs. For a new client, Innis has been authorized to invest up to...

What is the purpose of bid-ask spreads in the interbank spot market? Why are bid-ask spreads in the forward market larger than in the spot market? As a foreign exchange trader, you observe the...

Consider the reaction 2POCl3(g) 2PCl3(g) + O2(g) a. Calculate Go for this reaction. The Gof values for POCl3(g) and PCl3(g) are 502 kJ/ mol and 270. kJ/ mol, respectively. b. Is this reaction...

The predetermined overhead rate is? Atlas Equipment Co., which applies manufacturing overhead on the basis of machine hours, has provided the following data for its most recent year of operations:...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...