Question: B. Use the table below to answer the following questions. Table 1: Solver Output Variable Cells Name Trail = City scape = Sea sprite =

B. Use the table below to answer the following

B. Use the table below to answer the following questions. Table 1: Solver Output Variable Cells Name Trail = City scape = Sea sprite = Blazer = Final Reduced Value Cost 100 0 0 -13 175 0 0 -2 Objective Allowable Allowable Coefficient Increase Decrease 30 1E+30 2.5 25 13 1E+30 22 2 2 20 2 1E+30 Constraints Name Space Usage Assembly time Usage Order Usage Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 375 0 500 1E+30 125 1200 8 1200 125 100 275 -10 275 35 25 (1) If the profit on the Cityscape increases to $35, will any of the Cityscape bikes be ordered? (ii). Over what range of assembly hours is the shadow price applicable? (iii) If we require 5 more bikes in inventory, what will happen to the value of the optimal solution? (iv). Which resource should the company work to increase, inventory space or assembly time

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!