Question: *Please use Excel Solver tool and show equations. Exhibit 1 CONTRACTS AVAILABLE AND CONTRIBUTION PER CONTRACT (in US$) Exhibit 2 RESOURCES USED BY EACH CONTRACT


Exhibit 1 CONTRACTS AVAILABLE AND CONTRIBUTION PER CONTRACT (in US\$) Exhibit 2 RESOURCES USED BY EACH CONTRACT - Offshore jackets do not require Dock Days. Additional constraint - Viktor Lenac must produce at least zero of each of the contract types. Answer the following Questions: (no more than a couple of sentences for each): 1) What is the objective of the Viktor Lenac case? Is the objective to maximize or minimize? 2) Based on the sensitivity report, which constraint(s) has(ve) a shadow price and what is it, if so? 3) Explain what the shadow price means in wour own wonds? Explain how the Viktor Lenac objective changes based on the shadow price(s) of the constraint(s)? NOTE: Do not force answers to be integers Exhibit 1 CONTRACTS AVAILABLE AND CONTRIBUTION PER CONTRACT (in US\$) Exhibit 2 RESOURCES USED BY EACH CONTRACT - Offshore jackets do not require Dock Days. Additional constraint - Viktor Lenac must produce at least zero of each of the contract types. Answer the following Questions: (no more than a couple of sentences for each): 1) What is the objective of the Viktor Lenac case? Is the objective to maximize or minimize? 2) Based on the sensitivity report, which constraint(s) has(ve) a shadow price and what is it, if so? 3) Explain what the shadow price means in wour own wonds? Explain how the Viktor Lenac objective changes based on the shadow price(s) of the constraint(s)? NOTE: Do not force answers to be integers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
