Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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_2

Step: 3

blur-text-image_3

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

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

12th Edition

978-0073526706, 9780073526706

More Books

Students also viewed these Accounting questions

Question

Can all the evidence be verified? (151)

Answered: 1 week ago