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
-
Describe the recognition of contaminants and the problems they can create, and the effects and likely symptoms of contamination in the system
-
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...
-
The Haines Corp. shows the following financial data for 20X1 and 20X2. For each year, compute the following and indicate whether it is increasing or decreasing profitability in 20X2 as indicated by...
-
Cosmo and Ellis began a partnership by investing $50,000 and $75,000, respectively. During its first year, the partnership earned $165,000. Prepare calculations showing how the $165,000 income should...
-
The loan department of Calgary Bank uses standard costs to determine the overhead cost of processing loan applications. During the current month, a fire occurred, and the accounting records for the...
-
Ms. Smyth, 78 years old, had lived in the same home for 30 years. Never married, she cared for her disabled mother for 15 years. After her mother died, she lived alone on a small pension. She...
-
Bowers Company plans to incur $190,000 of salaries expense and produce $320,000 of additional sales revenue if a capital project is implemented. Assuming a 30% tax rate, these two items collectively...
-
Calculate the company's weighted average cost of capital and discuss the views of the Chairman, the financial Controller and the Treasurer about what would be the appropriate cost of capital to use...
-
Business journalists frequently write that the financial markets expect that firms that possess market power (e.g., firms that have prominent brand names) will raise their prices on a regular (e.g.,...
-
Which of the following combinations of constraints has no feasible region? Please choose the option below that would best answer this question above. O x1-x2 400, x1 + x2 50, x1 0, and x2 > 0 O x1-x2...
-
MyFurn is a producer of customized furniture on order. The company's sales and cost figures for the months Jan-Mar 2015 are as follows: JAN FEB MAR Number of units sold 250 400 300 Sales 6,250 10,000...
-
PROBLEM A-SALES BUDGET Sales volume for the year 2017 has been estimated for Queennie Apparels as follows: Quarters Products Dresses Shirts Pants First 18,000 32,000 46,000 Second 21,000 35,000...
-
17 V Av V help, but having to seek out counseling for myself I let them know it helps. Counseling will give you a whole new outlook on life. Read the study Six Distinct Types of Social Change Agents....
-
Repeat the previous problem, but close the positions on September 20. Use the spreadsheet to find the profits for the possible stock prices on September 20. Generate a graph and use it to identify...
-
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...
-
A company acquires equipment on January 10, 2005, at a cost of $42,000. Straight-line depreciation is used with a five-year life and $7,000 salvage value. On June 27, 2006, the company sells this...
-
hsteban Co. owns a machine that costs $38,400 with accumulated depreciation of $20,400. Esteban exchanges the machine for a similar but newer model that has a market value of $48,000. Record the...
-
Eastman Company reports the following ($ millions): net sales of $13,557 for 2005 and $12,670 for 2004; end-of-year total assets of $14,968 for 2005 and $18,810 for 2004. Compute its total asset...
Retired But Forever A Computer Network Architect At Heart 1st Edition - ISBN: B08MSNHYMR - Free Book
Study smarter with the SolutionInn App