The following is the Excel Solver output of Linear Programming Problem. Objective Allowable Reduced Cost Coefficient...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following is the Excel Solver output of Linear Programming Problem. Objective Allowable Reduced Cost Coefficient Increase 1800000 120000 1600000 1280000 Name Variable-S Variable- M Constraints: Name Year-1 Year-2 Year-3 Maximum of S Maximum of M Final Value Rs.: 0.608695652 0 0.869565217 0 Final Value 800000 669565.2174 500000 Constraint R.H. Side 2.782608696 800000 700000 500000 Shadow Price 0 0.52173913 0.608695652 0 0.869565217 0 1 1 Allowable Increase 22950.81967 1E+30 25000 1E+30 1E+30 Allowable Decrease 800000 100000 Allowable Decrease 60000 30434.78261 38888.88889 0.391304348 0.130434783 All questions are independent. a) The objective function value at the optimal solution is Rs. : b) The tight constrain are if any: c) If the Year-1 constrain is reduced from 800000 to 790000 the objective function value will be d) If Year-2 constrain are increased from 700000 to 710000, the net change in the objective function will be Rs.: e) If Year-3 constrain are increased from 500000 to 520000, the net change in the objective function will be Rs.: f) If the objective function coefficient for variable Variable-S is increased from Rs. 1800000 to Rs. 1900000, the objective function value will be Rs. : The following is the Excel Solver output of Linear Programming Problem. Objective Allowable Reduced Cost Coefficient Increase 1800000 120000 1600000 1280000 Name Variable-S Variable- M Constraints: Name Year-1 Year-2 Year-3 Maximum of S Maximum of M Final Value Rs.: 0.608695652 0 0.869565217 0 Final Value 800000 669565.2174 500000 Constraint R.H. Side 2.782608696 800000 700000 500000 Shadow Price 0 0.52173913 0.608695652 0 0.869565217 0 1 1 Allowable Increase 22950.81967 1E+30 25000 1E+30 1E+30 Allowable Decrease 800000 100000 Allowable Decrease 60000 30434.78261 38888.88889 0.391304348 0.130434783 All questions are independent. a) The objective function value at the optimal solution is Rs. : b) The tight constrain are if any: c) If the Year-1 constrain is reduced from 800000 to 790000 the objective function value will be d) If Year-2 constrain are increased from 700000 to 710000, the net change in the objective function will be Rs.: e) If Year-3 constrain are increased from 500000 to 520000, the net change in the objective function will be Rs.: f) If the objective function coefficient for variable Variable-S is increased from Rs. 1800000 to Rs. 1900000, the objective function value will be Rs. :
Expert Answer:
Answer rating: 100% (QA)
The image seems to be the output of an Excel Solver for a Linear Programming problem Heres the solution to each independent question based on the data given a The objective function value at the optim... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these mathematics questions
-
Reconsider the Profit & Gambit Co. advertising-mix problem presented in Section 2.7. Recall that a major advertising campaign is being planned that will focus on three key products: a stain remover,...
-
Ken and Larry, Inc., supplies its ice cream parlors with three flavors of ice cream: chocolate, vanilla, and banana. Due to extremely hot weather and a high demand for its products, the company has...
-
Identify 3 ethical and 3 legal issues regarding Genomics ? with examples? Genomic services provided for gaining a better understanding of the interactions between genes and the environment but there...
-
Consider a derivative that pays off S n T at time T where S T is the stock price at that time. When the stock pays no dividends and its price follows geometric Brownian motion, it can be shown that...
-
Presented below are various account balances of K.D. Lang Inc. (a) Unamortized premium on bonds payable, of which $3,000 will be amortized during the next year. (b) Bank loans payable of a winery,...
-
Elaine Chan is a newly appointed director of Elite Sports Ltd, a listed company that organises major sporting events. Elaine has provided consultancy services to Elite Sports Ltd for the past 3...
-
Suppose dividend payments were made tax deductible in calculating corporate taxable income in the United States. Assume that if dividends are received from foreign subsidiaries and the U. S. parent...
-
What piece of hardware connects a peripheral device like a keyboard or mouse to the system bus? 1 point a device driver a device controller a semaphore a network port
-
Check my work mode: This shows Required Information [The following information applies to the questions displayed below.] Bearings & Brakes Corporation (B&B) was incorporated as a private company....
-
Management accounting literature is abundant with discussions and commentaries on the changing roles of management accountants. The advent of Johnson and Kaplan's, 'Relevance Lost,' has certainly...
-
Suppose you buy a $ 7 0 0 , 0 0 0 house with ' no money down' with a 3 0 year, fixed - rate 7 % mortgage paid month starting TODAY! After 3 0 years you've finally paid off your mortgage....YEAH How...
-
Tutorial: BASIC EPS & DILUTED EPS CASE A ABC Berhad has the following at the end of 31 December 2023: - Profit after tax for the year was RM200,000. 500,000 ordinary shares at RMI each - 7.2%,...
-
The students were given the task to obtain 10 g of Cu(OH)2 experimentally. In the laboratory, students had access to a 10% CuSO4 solution and a 20% NaOH solution. Calculate how many ml of CuSO4...
-
Investors were discussing on their investing strategies, argued their philosophies and sharing their stock investing experiences on dated January 31, 2019 as under: Investor First: It is right time...
-
f. What is the regular payback period for these two projects? Project A Intermediate calculation for payback Payback using intermediate calculations Project B WACC = Time period Cash flow Cumulative...
-
A fast-food restaurant averages 150 customers per hour. The average processing time per customer is 90 seconds. a. Determine how many cash registers the restaurant should have if it wishes to...
-
a. Mark first asks you to forecast daily demand for the next week using the data from the past 13 weeks. You should make the forecasts for all the days of the next week now (at the end of week 5),...
-
For each of the following statements about using the exponential distribution as the probability distribution of interarrival times, label the statement as true or false and then justify your answer...
-
The comptroller of the Macrosoft Corporation has $100 million of excess funds to invest. She has been instructed to invest the entire amount for one year in either stocks or bonds (but not both) and...
-
Do you believe that fraud in the United States is more or less prevalent than fraud in countries outside the United States? Why?
-
How would a fraudster conceal missing cash, especially amounts of this magnitude?
-
What makes channel stuffing illegal by comparison to a car dealership that runs mega end-of-year sales?
Study smarter with the SolutionInn App