Captain Stubing runs the LP model associated with the scenario and reads the following about the variable cells in the Excel sensitivity report. Provide an interpretation

Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$2 Bar 12 0 1500 1560 1E+30
$C$2 Food 12 0 5000 1660 1E+30
$D$2 Excursion 24.24 0 17000 1E+30 3458.33333


Answer: There should be 12 different bar setups and cuisine types and 24.24 excursions. The Bar decision variable has an allowable increase of $1,560, so if the profit on a bar setup increased by that amount over the current value, i.e., all the way up to $3,060, the bar setups would remain the same at 12. The food types can increase by up to $1,660 per type, or up to $6,660 while remaining at 12 as the best number. Excursion profit can drop by up to $3,458 from the current value of $17,000 without changing from the recommended 24.24 value. The actual profit earned would of course change if these parameters stayed within their allowable increases and decreases, but the number of food, bar, and excursion types would remain at 12, 12 and 24 (and some change).

Business

You might also like to view...

When a firm's product delivers unique value because of an actual or perceived uniqueness in a broad market, it is said to have a cost-leadership advantage

Indicate whether the statement is true or false

Business

If a seller wishes to be relieved of the responsibility for implied warranties, the sales contract must clearly provide that the parties did not intend the implied warranties to become part of the contract.

Answer the following statement true (T) or false (F)

Business

After the systems analysis phase of the System Development Life Cycle (SDLC) is complete, the company will have a formal systems analysis report on

a. the conceptual design of the new system b. an evaluation of the new system c. users' needs and requirements for the new system d. a comparison of alternative implementation procedures for the new system

Business

Making more sales to current customers without changing a firm's products is known as ________

A) market segmentation B) market penetration C) product diversification D) product development E) prospecting

Business