Question: solve in excel solver then show all formula used Sensitivity Analysis Given: Objective Function Min Z = 6A + 9B ($ cost) s.t. A +

solve in excel solver then show all formula used

Sensitivity Analysis Given: Objective Function Min Z = 6A + 9B ($ cost) s.t. A + 2B 2 A, B 2 0 1. What is the optimal solution including the optimal value of the objective function? 2. Suppose the unit cost of A is decreased to $4. Is the current solution still optimal? What is the value of the objective function when this unit cost is decreased to $4? 3. How much can the unit cost of B be decreased without concern for the optimal solution changing? 4. If simultaneously the cost of x1 was raised to $7.5 and the cost of x2 was reduced to $6, would the current solution remain optimal? What will be the optimal cost? 5. If the right-hand side of constraint 3 is increased by 1, what will be the effect on the optimal solution? 6. What is the maximum amount the company should pay for 20 extra units of resources 2? 7. Interpret the values of Shadow Prices 8. Interpret the values of the Ranges of the RHS of the Binding Constraints

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!

Given: Objective Function Min Z = 6A + 9B ($ cost) s.t. A + 2B

please show the complete manual solution SENSITIVITY ANALYSIS (40PTS) Given: Objective Function Min Z=6A + 9B ($ cost) s.t. A + 2B 30 (Available Resources 2) B> 2 (Available Resources 3) A, B > 0 1....

PLEASE only answer questions 7a and 7b at the TOP of this page, the rest of the information below is merely context. PLEASE ANSWER: 7a) Your client asked you to determine the capacity utilization...

You work as an operations consultant for a textile company. Your client has a well-established distribution system in the US market. The company has hundreds of stores and four distribution centers....

help please :((((( i will upvote your solution SENSITIVITY ANALYSIS 1. Given: Objective Function: Min z = 6x1 + 9x2 ($ cost) Subject to: X1 + 2X2 8 10X1 + 7.5X2 30 X2 2 X1, X2 0 a) Solve graphically...

Rename the Excel file in the following way: Lastname_firstname_AGEC 3413_Fall 22_HW 4" while submitting. For question # 2 you need to use a word file. The word file should be named in the following...

can you please assist in decision analysis area. I have attached the questions, answers and the spreadsheets needed, but not sure how to get the answers in the solver spreadsheet. thanks for your...

i need help on 4 and 5 4 and 5 xy = tons of raw material i used for i ER IGR Objective function and constraints. min , (total cost) s.t. Ex; = 100 (piece is 100 tons) Ex nyx forj EC (characteristic...

Hello I have an agricultural excel question and I am having trouble understanding the concept and steps to the problem. Below I have provided the actual question with instructions, a spare of notes,...

Refer to Problem 8.40 for data. In exercise Required: 1. Run a multiple regression equation using machine hours, number of setups, and number of purchase orders as independent variables. Prepare a...

A financial institution is advertising a new three-year investment certificate. The interest rate is 7.5% compounded quarterly the first year, 6.5% compounded monthly the second year, and 6%...

Jennifer Jones, a 3 8 - year - old employee at a metal fabricating plant, was injured in a work - related accident. She has not returned to work and her doctor states that she has permanent back...

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