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
-
Select the correct response for each of the following. Under its established rate structure, Dodge Hospital would have earned patient service revenue of $5,000,000 for the year ended December 31,...
-
Revisit the chapters opening feature involving Michael Koch and his company Koch Entertainment LLC. Assume that Koch has decided to organize all future business endeavors with artists as general...
-
Start from the posted T-accounts and the adjusted trial balance that Davis Consulting prepared for the company at December 31. At December 31, the business gathers the following information for the...
-
48 b If a 11, solve for b and c. b=113 C=22 b=11 c=11/2 b=11 C = 22 b=5.5 C=11
-
Glo-Brite has been notified by the insurance company that there will be no premium charge for the month of December on the policy for Virginia Russell . Prepare the entry for the check made payable...
-
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,...
-
Comparative financial statements for the Rahul Corporation for the year ended December 31 are given below. A total of 500,000 shares of stock were outstanding. The market value of the companys stock...
-
Indicate the types of transactions that are recorded in the general journal when special journals are used.
-
You have assigned your assistant to the audit of the Bell Sales Company's fire insurance policies. All routine audit procedures with regard to the fire insurance register have been completed (i.e.,...
-
The processing operations of Gaylord Company, your client, require a basic raw material, colgum, which is imported and refined by domestic suppliers. Colgum is combined with other raw materials of...
-
Prior to the current year, CA had been the auditor of all the company's subsidiaries. However, during the current year, the company had acquired five new subsidiary companies whose accounts will be...
-
The consolidated profit of Y Ltd. and its subsidiaries for the year ended December 31, 19X6 is \($490,000.\) During the audit of X Ltd., one of the subsidiaries, CA notices that there is \($5,000\)...
-
Suppose that the supply schedule of Brazilian Coffee beans is as follows: Price of Brazilian Coffee beans (per pound) Quantity of Brazilian Coffee beans supplied (pounds) $4.00 6,000 $3.50 5,000...
-
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...
-
[2] (20pts) The AGGIE Industrial Engineering Entrepreneurs (AGGIE) manufacture customized business card holders (BCHs) using their several lines of additive manufacturing machines (aka 3-D printers)....
-
Nomis Ltd reported the following items on the balance sheet at December 31, 2020. Assets Current assets 23,400 Property, plant and equipment, net 65,400 Total assets 88,800 Liabilities Current...
-
Palm Inc. has a profit margin of 23% and an investment turnover of 5. Sales revenue is $804,000. What is the operating income? Multiple Choice $924,600 $184,920 $160,800 $36,984
Study smarter with the SolutionInn App