Question: Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 $ amount in MB ? -0.045 0.085 ? ? $C$11

Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$11 $ amount in MB ? -0.045 0.085 ? ?
$C$11 $ amount in CD 0 ? 0.05 0.015 1E+30
$D$11 $ amount in TB 38181.82 ? 0.065 0.065 0.015
$E$11 $ amount in GS 31818.18 0 0.13 1E+30 0.045
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$18 Fund LHS ? 0.094545 70000 1E+30 31500
$B$19 MB LHS ? 0 14000 ? 14000
$B$20 CD & others LHS -70000 ? 0 ? ?
$B$21 CD & TB LHS 38181.82 ? 21000 ? ?
$B$22 Ratio LHS ? -0.02955 0 70000 37800

For the constraints, find the following question marks with justification.

  1. Final value of FUND (constraint).

  1. Final value of MB (constraint).
  1. Allowable Increase of MB (constraint).

Shadow Price of CD& others (constraint).

  1. Allowable Increase of CD& others (constraint).

  1. Allowable Decrease of CD& others (constraint).
  2. Shadow price of CD& TB (constraint).
  1. Allowable Increase of CD& TB (constraint).

  1. Allowable Decrease of CD& TB (constraint).

  1. Final value of Ratio (constraint).

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 Accounting Questions!

Q:

Please help! Answer the following multiple choice based on the table 1) What is the Final Value of MB? A. 38181.12 B. 0 C. 38181.15 D. 0.045 2) What is Allowable Increase for MB? A.0 B.infinity...

Q:

1. What is the Reduced Cost for TB? 0 infinity 70000 0.015 2.What is the Reduced Cost for CD? A.0 B.0.015 C.-0.015 D.Infinity 3. What is Allowable Decrease for MB? A.Infinity B.0.045 C.0 D.-0.045 4....

Q:

Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 $ amount in MB ? -0.045 0.085 ? ? $C$11 $ amount in CD 0 ? 0.05 0.015 1E+30 $D$11...

Q:

Show in Excel Question 4: The sensitivity report for the investment problem in question 3 is in the worksheet named Investment 2 . Use the report to answer the following questions. 2 Points: In cell...

Q:

Question 18 Not yet answered Points out of 1.00 P Flag question The A-B-C department of a large company makes three products (A, B and C). To determine the best production schedule, the manager has...

Q:

Question 13 The Furniture City (FC) company makes 3 kinds of couches: (1) Standard, (2) Deluxe, and (3) Luxury styles. Each couch goes through 3 production departments: (1) Cutting and Coloring, (2)...

Q:

urgent!! A recycling company (Zerowaste) converts small bottles, large bottles, beer bottles, and wine bottles into materials for white glass, green glass, and red glass. The following table...

Q:

12. The Furniture City (FC) company makes 3 kinds of couches: (1) Standard, (2) Deluxe, and (3) Luxury styles. Each couch goes through 3 production departments: (1) Cutting and Coloring, (2)...

Q:

An investment company currently has $ 1 million dollar available for investment in five different stocks. The company wants to maximize the interest earned over the next year. The five investment...

Q:

0.0 1.5 3.0 $0.25 Harvest Farm is experimenting with a special diet for its racehorses. The feed components available for the diet are a standard horse feed product, an enriched oat product, and a...

Q:

The following AOV table was computed for the experimental design described in Exercise 15.31. What is missing from the table? Source MS F.Value Pr> F Main effects 75.51 624.22222 22.72 3.200.00000...

Q:

Alpha Pro Company is a marketing firm. The company's trial balance on July 31, 2011, appears below. During the month of August, the company completed the following transactions: Aug. 2 Paid rent for...

Q:

Which of the following are sources of revenue for credit card issuers: Interest paid by consumers on paid card balances Interchange fees Cardholder fees

Q:

a=2 b= 0 c= 2 d=0 e=0 f=9 g=3 5. Draw the Network diagram for the following project. Estimate the Earliest start time and Latest finish time for each activity. If every day it cost 200 rials for this...