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: 66% (15 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
-
Create a frequency table, with percentages (rounded to one decimal place), for the following information. Can you make a bar chart for this information on graph paper or on a computer using either...
-
Kitch Corporation has 50,000 shares of \(\$ 5\) par value common stock outstanding and retained earnings of \(\$ 820,000\). The company declares a 100 percent stock dividend. The market price at the...
-
The following data are for the two products produced by Shakti Company. The companys direct labor rate is $ 20 per direct labor hour (DLH). Additional information follows. Required 1. Compute the...
-
36) What best characterizes the post Bretton Wood period? a. There were no capital flows. b.There were no exchange rates. c.Exchange rates were stable. d.Exchange rates became volatile....
-
4. Consider the table below, which shows seven potential customers who are interested in taking a 30-minute helicopter ride. The helicopter company is a profit-maximizing monopolist. The helicopter...
-
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,...
-
(a) When air resistance is ignored, does a pendulum clock run faster or slower at higher altitude? (b) Does your answer change if you don't ignore the effects of air resistance?
-
Provide your estimates for the "after-merger" valuations if Coolio issues debt with the market value- based target net debt/value ratio of 50%. The ratio is assumed to be maintained over time and all...
-
There are two consumers 1 and 2 in an endowment economy with a single good (cookies). Person 1's utility is u1 = c1 and person 2's utility is u2 = 2c2 where c1 and c2 are each person's cookie...
-
S X i. D II. C R F V G B H N U J 210 MAN Q3) Consider the following B+ tree: M SHIV NADAR THEVERGR Discipline: Computer Science and Engineering Course Name: Introduction to Databases Time: 3:00 pm -...
-
Assume your home is assessed at $230,000. You have a $221,000 loan for 25 years at 6 percent. Your property tax rate is 1.5 percent of the assessed value. In year one, you would pay $12,155 in...
-
Based on the "podcast "How China's Economic Policy & Global South Cooperation Boost Development in Africa" 1. How does preferential trade treatment affect exporting countries? 2. What are the...
-
What are the benefits of the proposed TTIP?
-
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...
-
A 1 6 - year, 8 % semiannual coupon bond with a face value of $ 1 , 0 0 0 has YTM of 7 . 2 % . The bond may be called in 5 years at a call price of $ 1 , 0 4 0 . Find bond's nominal yield to call. (...
-
An auto dealership is advertising that a new car with a sticker price of $ 3 4 , 8 4 8 is on sale for $ 2 5 , 9 9 5 if payment is made in full, or it can be financed at 0 % interest for 7 2 months...
-
A manufacturing company is considering upgrading an existing machine. The cost of the new machine is 950,000 TL and the installation cost is 50,000 dollars. The current machine is sold for $ 200,000...
Study smarter with the SolutionInn App