Uncle Ulysses operates a small business: he produces three types of houses to sell to people...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Uncle Ulysses operates a small business: he produces three types of houses to sell to people wanting to get back to nature. Based on your discussion with your uncle you construct the following table based on your understanding of his weekly availability of labor. Item Profit/Unit Fabrication Assembly Painting Crating Birdhouse $15 1 2.5 1 0.25 Doghouse $35 1.25 1.5 0.5 0.5 $58 1.75 4 2 0.75 Outhouse Capacity 30 hours 50 hours 20 hours 20 hours Based on the information in the table, you formulate the problem as a linear program. The labor needed for fabrication, assembly, painting, and crating is all dedicated solely to each function, i.e., none of the workers have been cross-trained. You solved the problem using Excel and generated the following sensitivity report. Variable Cells Final Cell Name Value $C$4 Birdhouse 0.00 $D$4 Doghouse 15.38 $E$4 Outhouse 6.15 Constraints Cell Name $F$5 Fabricate $F$6 Assemble $F$7 Paint $F$8 Crate Final Value 30.00 47.69 20.00 12.31 Reduced Cost -17.15 0.00 0.00 Shadow Price 25.23 0.00 6.92 0.00 Objective Allowable Allowable Coefficient Increase Decrease 17.15 1E+30 6.43 20.50 82.00 9.00 15.00 35.00 58.00 Constraint Allowable R.H. Side Increase 30 3.75 50 1E+30 20 1.58 20 1E+30 Allowable Decrease 12.50 2.31 8.00 7.69 After some market investigation, Uncle Ulysses decided to increase the price of Doghouse from $35 to $40. Will this change the current optimal production plan? If we refer to the four constraints as "Fabricate", "Assemble", "Paint" and "Crate". Which constraints are NOT binding? In a week, due to workers' vacation plan, Uncle Ulysses only has 15 painting hours. How would his profit of this week be affected and why? Uncle Ulysses operates a small business: he produces three types of houses to sell to people wanting to get back to nature. Based on your discussion with your uncle you construct the following table based on your understanding of his weekly availability of labor. Item Profit/Unit Fabrication Assembly Painting Crating Birdhouse $15 1 2.5 1 0.25 Doghouse $35 1.25 1.5 0.5 0.5 $58 1.75 4 2 0.75 Outhouse Capacity 30 hours 50 hours 20 hours 20 hours Based on the information in the table, you formulate the problem as a linear program. The labor needed for fabrication, assembly, painting, and crating is all dedicated solely to each function, i.e., none of the workers have been cross-trained. You solved the problem using Excel and generated the following sensitivity report. Variable Cells Final Cell Name Value $C$4 Birdhouse 0.00 $D$4 Doghouse 15.38 $E$4 Outhouse 6.15 Constraints Cell Name $F$5 Fabricate $F$6 Assemble $F$7 Paint $F$8 Crate Final Value 30.00 47.69 20.00 12.31 Reduced Cost -17.15 0.00 0.00 Shadow Price 25.23 0.00 6.92 0.00 Objective Allowable Allowable Coefficient Increase Decrease 17.15 1E+30 6.43 20.50 82.00 9.00 15.00 35.00 58.00 Constraint Allowable R.H. Side Increase 30 3.75 50 1E+30 20 1.58 20 1E+30 Allowable Decrease 12.50 2.31 8.00 7.69 After some market investigation, Uncle Ulysses decided to increase the price of Doghouse from $35 to $40. Will this change the current optimal production plan? If we refer to the four constraints as "Fabricate", "Assemble", "Paint" and "Crate". Which constraints are NOT binding? In a week, due to workers' vacation plan, Uncle Ulysses only has 15 painting hours. How would his profit of this week be affected and why?
Expert Answer:
Answer rating: 100% (QA)
To determine whether the change in the price of the Doghouse will affect the current optimal production plan we need to examine the sensitivity report ... View the full answer
Related Book For
Managerial Decision Modeling with Spreadsheets
ISBN: 978-0136115830
3rd edition
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair
Posted Date:
Students also viewed these general management questions
-
The Growall Fertilizer Company produces three types of fertilizerSupergro, Dynaplant, and Soilsaver. The company has the capacity to produce a maximum of 2,000 tons of fertilizer in a week. It costs...
-
A leading hardware company produces three types of computers: Pear computers, Apricot computers, and Orange computers. The relevant data are given in the file S14_91.xlsx. The equipment cost is a...
-
A photocopy machine company produces three types of laser printersthe Print Jet, the Print Desk, and the Print Prothe sale of which earn profits of $60, $90, and $73, respectively. The Print Jet...
-
How does the organization's mission, vision, values, and strategies shapes the organizational culture and develop culture for change?
-
Suppose that sugar imports are completely prohibited by the U.S. government in Figure. What will be the new equilibrium in the United States and RoW? Show the effect on consumer and producer surplus...
-
Madden Company was started on January 1, 2011, and experienced the following events during its first year of operation. 1. Acquired $30,000 cash from the issue of common stock. 2. Borrowed $40,000...
-
Which party is the bank which places the shares working for the issuer or the investor subscribing the shares?
-
Part 1 The framework created by Professor Sidney Gray in 1988 to explain the development of a country's accounting system is presented in the chapter in Exhibit 2.8. Gray theorized that culture has...
-
4 A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through 12, indicate whether the item should be added to or subtracted from the book or bank balance,...
-
Air containing 1.6 vol% sulfur dioxide is scrubbed with pure water in a packed column of 1.5-m2 cross-sectional area and 3.5-m height packed with no. 2 plastic Super Intalox saddles, at a pressure of...
-
A steel mill estimates that one of its furnaces will require maintenance 20,000 at the end of 2 years, 40,000 at the end of 4 years, and 80,000 at the end of 8 years. What uniform semi-annual amounts...
-
Reston Manufacturing Corporation produces a cosmetic product in three consecutive processes. The costs of Department | for May 2016 were as follows: Department | handled the following units during...
-
A \(0.08-\mathrm{m}^{3}\) rigid tank contains air at 3 bar and \(127^{\circ} \mathrm{C}\). The mass of the air in the tank is (a) \(0.209 \mathrm{~kg}\) (b) \(20,900 \mathrm{~atm}\) (c) \(21...
-
The following selected accounts appear in the Gloria Company's unadjusted trial balance as of December 31, the end of the fiscal year (all accounts have normal balances): Required Make the necessary...
-
Robert Company, a merchandising firm, reports the following data for the month ended January 31 : Prepare a multi-step income statement for Robert Company for the month of January. Operating...
-
A system is represented by equation \(\dot{\mathbf{x}}=\mathbf{A x}\) where \[A=\left[\begin{array}{ccc}0 & 1 & 0 \\0 & 0 & 1 \\-1 & -c & -2\end{array}ight]\] Find the range of \(c\) where the system...
-
You are given the following information for Sandhill Company for the month ended November 30, 2021: Unit Date Description Units Price Nov. 1 Beginning inventory 65 $52 9 Purchase 100 45 15 Sale (125)...
-
How do the principles of (a) Physical controls and (b) Documentation controls apply to cash disbursements?
-
A graphical approach was used to solve the following LP model in Problem 2-15: Maximize profit = $4X + $3T Subject to the constraints 3XY 27 X, Y >0
-
In Problem 5-37, all roads leading into and out of nodes 4 and 9 (see Figure 5.26) have been closed because of bridge repairs. What impact (if any) will this have on the shortest route between Port...
-
A gear manufacturer is planning next weeks production run for four types of gears. If necessary, it is possible to outsource any type of gear from another gear company located nearby. The following...
-
Around the Horn (B). Assume the following bid-ask quotes and calculate how the market trader can now make an intermarket arbitrage profit. Banks Spot Rates Citibank $1.6192-96/ National Westminster...
-
Great Pyramids. Inspired by his recent trip to the Great Pyramids, Citibank trader Ruminder Dhillon wonders if he can make an intermarket arbitrage profit using Libyan dinars (LYD) and Saudi riyals...
-
Bank for International Settlements. The Bank for International Settlements (BIS) publishes a wealth of effective exchange rate indices. Use its database and analyses to determine the degree to which...
Study smarter with the SolutionInn App