The landlord ran the model in Excel and received the sensitivity report for the constraints as contained in the table. Which of the following statements is correct?
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$12 Total Time Weeks 4.00 13.64 4 1.1 3.1E-16
$E$10 Total Cost 3000.00 0.01 3000 550 3.1E-13
$I$4 wood floors Included? 1.00 67.27 1 1.27E-16 4.6E-01
$I$5 kitchen tile Included? 1.00 25.45 1 7.63E-17 2.8E-01
$I$6 back door Included? 0.00 0.00 1 1.00E+30 1.0E+00
$I$7 garage door opener Included? 1.00 11.82 1 5.09E-16 1.0E+00
A) If there are 2 more weeks available for work, it would be possible to increase rent by $27.28 per week
B) Given the scenario, it is evident that a constraint is missing.
C) If the landlord installed two garage doors, rent could be increased by $23.64.
D) Given the scenario, it is evident that the objective function is misstated.
Answer: B
You might also like to view...
If a report is urgently needed, some accuracy may have to be sacrificed in the interest of timeliness
Indicate whether the statement is true or false
Lulene makes the best lemon meringue pies in Mississippi. So Ellen, who owns Ellen's Old Fashion Cafe, contracts with Lulene to buy 50 pies per week at the price of $5.00 per pie. Although Lulene took a class in business law, she forgot to get her agreement with Ellen in writing. Lulene and Ellen agreed during a chat. Lulene said: "I will supply you with lemon meringue pies for however long you
want them at $5.00 per pie." Ellen said: "That's great, I'll take them." Both women were pleased. Soon Lulene had a problem. Between a hurricane in Florida and brush fires in California, the price of lemons increased by 200%. Now, instead of the $5.00 per pie price she intended to charge Ellen, she feels she must charge $7.00 per pie to make a little profit. Lulene calls Ellen with the bad news and Ellen has a fit. She tells Lulene that's too bad, but the deal is off. Lulene says, "That's what you think!" and goes to see Amanda, her attorney. Instead of meeting to discuss the deal, Lulene had sent Ellen a letter offering to sell her lemon pies for $5.00 per pie for as long as Ellen likes. Lulene says she must receive Ellen's answer by May 10 . On May 8 Ellen signs a letter accepting the offer and mails it. On May 9 Lulene calls to withdraw her offer. Ellen says it's too late, she has accepted. Who wins? a. Ellen wins, because it was effective when sent b. Ellen wins, based on the faulty communication rule c. Lulene wins, because she revoked before receipt d. Lulene wins, based on the precedent set in the Hixson case e. Lulene wins based on the UCC
What is a fixture?
A. personal property so closely associated with real property that it becomes part of the realty B. an intangible asset created within the parameters of certain real property C. a component of real property that is easily transferrable without substantial damage to the real property D. a tangible, physical item that cannot be classified as real property
Value engineering techniques are primarily applied to existing products and services
Indicate whether the statement is true or false