Consider the Greenberg Motors example from section 3.8. Retrieve file Figure 3.14.xlsx, Sheet: Figure 3.14 from the
Question:
Consider the Greenberg Motors example from section 3.8. Retrieve file Figure 3.14.xlsx, Sheet: Figure 3.14 from the Companion Website. Rerun the model (seen in Figure 3.14) by making all decision variables integer. The solution will take a while to run, and you may need to answer “Continue” if you reach an iteration limit. How much worse is the new cost? Did the new decision variable values round as you would have expected?
Figure 3.14
Transcribed Image Text:
All entries in column R are computed using the SUMPRODUCT function. K P 1 Greenberg Motors Per GM3A GM3A GM3A GM3A GM3A GM3A GM3A GM3A GM3B GM38 GM38 GM38 GM38 GM3B GM38 GM3B Jan prod 1276.92 476.92. 1,138.46 915.38 842.31 757.89 792 31 450.00 1,000.00 0.00 1,200.00 0 00 1.400.00. 0.00 1,700.00 300.00 PAt las PA2 la2 PAS las PAM Ist Pe2 lez Pes les Pe4 3 Feb Feb Mar prod Apr prod Feb Feb Mar prod Jan Jan Mar Apr Jan Mar Apr Apr inv 14 prod inv prod inv inv inv inv prod inv inv prod S Number of Units 6 Cost 7 Constraints: 8 GM3A Jan balance 9 GM3B Jan balance 10 GM3A Feb balance 11 GM3B Feb balance 12 GM3A Mar balance 13 GM3B Mar balance 14 GM3A Apr balance 15 GM3B Apr balance $10.00 $0.18 $10.00 S0.18 $11.00 $0.18 $11.00 s0.18 $6.00 $0.13 $6.00 $0.13 $6.60 $0.13 $8.60 $0.13 S76.301.62 800 1000 700 1200 1000 1400 1100 1400 450 300 476.92 3300 3300 3300 750.00 ce 3300 2560 2560 2560 2560 2560.00 2240 2240 2355.00 2240 2240 Sign RHS -1 800.00 1000 00 1 -1 -1 700.00 1200.00 1000 00 -1 -1 -1 1400.00 1. -1 1100.00 -1 1400.00 16 GM3A Apr inventory 17 GM3B Apr Inventory 18 Jan storage cap 19 Feb storage cap 20 Mar storage cap 21 Apr storage cap 22 Jan labor max 23 Feb labor max 24 Mar labor max 25 Apr labor max 26 Jan labor min 27 Feb labor min 28 Mar labor min 29 Apr labor min 30 450.00 300.00 1. 915.38 1. 757 69 1. 1.3 0.9 2560.00 13 0.9 2560.00 1.3 0.9 2355.00 13 0.9 2560.00 1.3 0.9 13 0.9 2560.00 1.3 0.9 1.3 0.9 2560.00 LHS Solver Parameters Set Objective: SR$6 To: G MO Cyalue Of Solver includes three entries: One for each type of constraints s, 2, and -. Ey Changing Variable Cels: Subject to the Constrants: SRS18: SRS25 <= $STS18: STS25 SRS26: SR$29 >- $T$26:ST$29 SR$3: SR$17 - STS8:ST$17
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 66% (15 reviews)
Integer programming is a type of optimization problem where some or all of the decision variables ar...View the full answer
Answered By
Benard karuma
As a tutor, I have extensive hands-on experience in teaching students of all ages and backgrounds. I am proficient in developing and delivering tailored lesson plans and making use of a variety of teaching methods to ensure that all students can learn effectively. I am also experienced in helping students who have learning disabilities or needs, and I have a good understanding of how to meet the individual needs of my students. I am patient and understanding, and I am always willing to go the extra mile to help my students succeed.
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
-
Is the transportation model an example of decision making under certainty or decision making under uncertainty? Why?
-
How would you react to doing much worse on an exam than you expected? There is some evidence to suggest that most individuals believe that they can cope with this kind of problem better than their...
-
Imagine that you are a member of the brand and marketing team for an established low-cost airline. Your airline is set to announce the start of a new route to a new destination. (a) Describe the...
-
The population (in millions) of a country in 2015 and the expected continuous annual rate of change k of the population are given. (a) Find the exponential growth model P = Ce kt for the population...
-
At 25oC in a closed system, ammonium hydrogen sulfide exists as the following equilibrium: a. When a sample of pure NH4HS(s) is placed in an evacuated reaction vessel and allowed to come to...
-
\(\alpha=0.10\), d.f. \(_{\mathrm{N}}=20\), d.f. \(_{\mathrm{D}}=15\) Find the right- and left-tailed critical F-values for a two-tailed test using the level of significance \(\alpha\) and degrees of...
-
The stockholders' equity of Elsworth Corporation at January 1 is shown below: The following transactions, among others, occurred during the year: Apr. 1 Declared a 100 percent stock dividend on all...
-
ElectroWorld and Galaxy Appliance are competing retail stores that tacitly bargain with each other in deciding pricing policies. Each can either price high or price low. If both price high, payoffs...
-
Manufacturing equipment would be listed further down on the Balance Sheet than Marketable Securities because
-
Prepare journal entries for the following merchandising transactions of Powell Company assuming it uses a perpetual inventory system and the gross method. May 1. Powell purchased merchandise with a...
-
Indicate which of the following constraints are linear (or could be with the appropriate algebraic manipulation). In all cases, A, B, and C are continuous decision variables. (a) 5A + B/C 100 (b) 2B...
-
Dexter is taking 18 credit hours this semester, and he has 6 final exams on Monday. The first one starts at 8:00 a.m., and they run straight through until the last one is over at 8:00 p.m. It is 3:00...
-
Let x be the yearly proportional return for stock C, and let y be the yearly proportional return for stock D. If x =11, y =09, x =17, y =17, and 2xy =0412, find the mean and standard deviation of the...
-
A scuba diving school has been given the opportunity to purchase a sunken shipwreck for just $25,000, giving trainee scuba divers the opportunity to navigate through the ship as part of their...
-
Two charges of +8.0 * 10^-9 C and +4.0 * 10^-9 C are held a distance of 0.20 m A. Calculate the magnitude and direction of the electric field strength at the midpoint between the B. Calculate the...
-
Is linux and Ubuntu the same or is Ubuntu an distributor of linux ? Can I use Ubuntu just i would linux ?
-
If the initial angular velocity is - 3 . 1 rad / s , then what is the angular velocity, in radians per second, at time 2 3 . 7 5 s ? A detailed graph of angular acceleration versus time is shown....
-
After many years, Unilever displays the image of a company that works for good causes. Unilever's ideals are very simple, but have a clear vision, namely promoting sustainable living. Unilever...
-
Given what is happening in Russia today, what do you think will happen to foreign direct investment in Russia going forward? Is this a country where a Western enterprise would want to do business?
-
Complete the equations for the following equilibria and calculate Keq where the Keq expression includes [HO]. Be sure to enter Keq in proper scientific notation. (a) ammonia (acting as a base) reacts...
-
How do you think a furniture manufacturers buying habits and practices would be affected by the specific type of product to be purchased? Consider fabric for upholstered furniture, a lathe for the...
-
Discuss the importance of target marketing when analyzing organizational markets. How easy is it to isolate homogeneous market segments in these markets?
-
Explain how NAICS codes might be helpful in evaluating and understanding business ma r kets. Give an example.
-
Good day tutor, could you kindly assist in answering the questions (1-3 only) b elow. Please take note of the instruction and data set showns below. The first data set has salaries of recent...
-
If the future value of an ordinary, 6-year annuity is $5,600 and interest rates are 7.5 percent, what is the future value of the same annuity due
-
To operate practically as a substitute for cash or a credit device, a negotiable instrument must be Question 21 options: a) conditional without the risk of being collectable. b) qualified with a...
Study smarter with the SolutionInn App