Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Here's the sensitivity report for the decision variables. Answer the following questions. Cell Name Final Value Reduce Cost 12 $B$2 $C$2 $D$2 Bar Cuisine

image text in transcribed

1. Here's the sensitivity report for the decision variables. Answer the following questions. Cell Name Final Value Reduce Cost 12 $B$2 $C$2 $D$2 Bar Cuisine Excursion Objective Allowable Coefficient Increase 1500 1560 5000 1660 17000W 1E+30 Allowable Decrease 1E+30 1E+30 3458.3333 12 24.24 a) What happens to the value of the excursion variable if we can increase the profit for this variable? What if the profit is increased to 50? [5 Marks) b) Interpret the reduced cost of 12 for the Bar variable. [5 Marks] c) Write the objective function for this problem. [5 Marks] d) What is the value of the objective function and variables? [5 Marks) 1. Here's the sensitivity report for the decision variables. Answer the following questions. Cell Name Final Value Reduce Cost 12 $B$2 $C$2 $D$2 Bar Cuisine Excursion Objective Allowable Coefficient Increase 1500 1560 5000 1660 17000W 1E+30 Allowable Decrease 1E+30 1E+30 3458.3333 12 24.24 a) What happens to the value of the excursion variable if we can increase the profit for this variable? What if the profit is increased to 50? [5 Marks) b) Interpret the reduced cost of 12 for the Bar variable. [5 Marks] c) Write the objective function for this problem. [5 Marks] d) What is the value of the objective function and variables? [5 Marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cloud Computing A Security And Privacy Guide

Authors: Ben Halpert

1st Edition

0470874740, 978-0470874745

More Books

Students also viewed these Accounting questions