Consider Figure 4.11, which shows the Sensitivity Report for the Flair Furniture Company example in Section 4.3.
Question:
Consider Figure 4.11, which shows the Sensitivity Report for the Flair Furniture Company example in Section 4.3. By examining this figure and the LP formulation, can you compute by hand the optimal product mix if carpentry hours increase by 200 units? If so, what is the answer?
Figure 4.11
Transcribed Image Text:
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Figure 4.9.xlsx]Flair Furniture The shadow prices ere valid for this range of change in Variable Cells Two components of the Sensitivity Report Cell SBS5 Number of units Tables 320,00 SCS5 Number of units Chairs Final Reduced Objective Allowable Allowable the RHS values. Value Coefficient Increase Decrease 7.00 5.00 Name Cost 0.00 3.00 360.00 3.25 1.50 0.00 4.33 Constraints Final Shadow Constraint Allowable Allowable Name SD$8 Carpentry hours SDS9 Painting hours SDS 10 Maximum chairs SDS11 Minimum tables R.H. Side Increase Decrease 225.00 600.00 Cell Value 2400.00 Price 0.60 2400.00 900.00 1000.00 2.60 1000.00 150.00 360.00 320.00 1E+30 220.00 0.00 450.00 90.00 1E+30 0.00 100.00 The shadow price for a nonbinding constraint is zero. Solver's way Each additional hour of painting time will increase profit by $2.60. of showing infinity
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 64% (14 reviews)
To compute the optimal product mix when carpentry hours increase by 200 units we need to analyze the sensitivity report and make adjustments based on ...View the full answer
Answered By
Salome Wambui
EDUCATION
Bachelor of Science in Applied Statistics, University of Maseno
TUTORING EXPERIENCE
• Tutored college-level students in introductory and advanced topics in Statistics, including probability, hypothesis testing, regression, and ANOVA
• Assisted elementary, middle, and high school students with math and science courses, including Algebra, Geometry, and Calculus
• Led guided review sessions to prepare students for exams in Statistics, Math, and Science
• Mentored students on problem-solving, study skills, and time-management strategies to help them succeed in their classes
0.00
0 Reviews
10+ Question Solved
Related Book For
Managerial Decision Modeling Business Analytics With Spreadsheet
ISBN: 9781501515101
4th Edition
Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson
Question Posted:
Students also viewed these Business questions
-
Consider Figure 4.16, which shows the Sensitivity Report for the Anderson Home Electronics example in Section 4.4. Use the Sensitivity Report to answer the following questions, if possible. Each...
-
Consider Figure 4.20, which shows the Sensitivity Report for the Burn-Off Diet Drink example in Section 4.7. For each of the situations described below, check to see if the 100% rule can be used to...
-
Refer to Figure 8.15, which shows the sensitivity report for Problem 7. a. How much would the return for U.S. Oil have to increase before it would be beneficial to increase the investment in this...
-
The rotating beacon of a parked police car is 12 m from a straight wall. (a) Sketch the graph of the length L of the light beam, where L = 12 sec t, for 0 t 2.0 s. (b) Which part(s) of the graph...
-
The equilibrium-constant expression for a reaction is What is the equilibrium-constant expression when the equation for this reaction is halved and then reversed? NO2O IN20512
-
Howard loaned $8,000 to Bud two years ago. The terms of the loan call for Bud to pay annual interest at 8%, with the principal amount due in three years. Until this year, Bud had been making the...
-
The dimensions of the rectangular loop of wire in Figure P29.34 are \(\ell=50 \mathrm{~mm}\) and \(w=40 \mathrm{~mm}\). The loop moves at speed \(v=30 \mathrm{~mm} / \mathrm{s}\) through the magnetic...
-
Assume you performed sampling for an accounts receivable population with a recorded population amount of $2,000,000. Tolerable misstatement is set at $100,000 for the test, and there are no...
-
which muscle were use to extend and splay your finger outward?
-
Consider the first-order decomposition of cyclobutane at 438 C at constant volume: C 4 H 8 (g) 2C 2 H 4 (g). a. Express the rate of the reaction in terms of the change in total pressure as a...
-
Consider the Flair Furniture example from Sections 4.2 and 4.3. Suppose that the company is considering the option of making stools in addition to its tables and chairs. Stools take 1 hour of...
-
The Good-to-Go Suitcase Company makes three kinds of suitcases: (1) Standard, (2) Deluxe, (3) Luxury styles. Each suitcase goes through four production stages: (1) Cutting and coloring, (2) Assembly,...
-
What will be the effects (increase, decrease, or no effect) on total assets, total liabilities, and total stockholders equity in each of the following situations? When shareholders equity changes,...
-
The U.S. Government Accountability Office indicated that agencies spent over $300 billion on contracts, which includes award fees. While many agencies use award fee contracts, over 95 percent of the...
-
INTERNATIONAL ENVIRONMENAL LAW Research for an International Environmental Law Treaty that address any of the areas ofTrans Boundary Harm. Discuss briefly
-
1)How effective do think our environmental laws are in both preventing environmental contamination and also in instigating clean-up efforts? 2) Are our laws and regulations doing too little or too...
-
The text states "Selecting an RMO is, to the extent the RMO establishes a residual risk level, equivalent to choosing an TLR, although there may be instances where a TLR is determined first and then...
-
Do you live in an area that is noticeably influenced by environmental laws or international agreements? Which laws or agreements most impact the area where you live?
-
Consider the matrices Compute the indicated combinations where possible. (a) 3A- B (b) A B (c) BA (d) (A + B)C (e) A + BC (f) A + 2CB (g) BC B -I (h) A2-3A + 1 (i) (B-I)(C+ I) 326 140 113 B-(-6 2-3 1...
-
Cable Corporation is 60% owned by Anna and 40% owned by Jim, who are unrelated. It has noncash assets, which it sells to an unrelated purchaser for $100,000 in cash and $900,000 in installment...
-
In the current year, Pelican, Inc., incurs $10,000 of meals and entertainment expenses that it deducts in computing net income per the corporations financial statements. All of the meals and...
-
In the current year, Juanita and Joseph form a two-member LLC and do not file Form 8832 (Entity Classification Election). As a result, the LLC will be treated as a partnership for Federal tax...
-
A personal service corporation (PSC) generally is limited to the calendar year for reporting purposes. One exception to this rule is when the PSC can demonstrate a business purpose for a fiscal...
-
Question 1. For the beam and loading shown, (a) find the bending moment as a function of x using the coordinate system shown; (b) find the bending moment as a function of x if the origin is at A...
-
Figure B D 12 kip E 4 ft 4ft 4 ft- Part A Determine the axial forces in members BC, CD, and CE of the truss. (Figure 1) Enter your answers numerically separated by commas. vec FBC, FCD, FCE = 1 of 1...
-
x + 2y + 5z = 20 5x + 3y - z = 7 -x+4y+2z = 13 Find x, y, and z using the following methods: a. By hand using Cramer's rule. (30 pts) b. Write a C program to solve the above using Gauss-Jordan...
Codes Curves And Signals Common Threads In Communications 1st Edition - ISBN: 1461373301 - Free Book
Study smarter with the SolutionInn App