By setting up a well-documented spreadsheet solve the following abstract linear programming problem. Make sure that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
By setting up a well-documented spreadsheet solve the following abstract linear programming problem. Make sure that you use the Linear Solver (Tools / Solver / Options / Solver Engine / Lincar Solver). Maximize the objective expression: 44r, + 54r2 + 492a+ 44r4 +50rs under the constraints: +10r1 + 10r2 +9r3+11r4+11rs < 1202 +10r1 + 11r2 +9rg +7x4 +7rs < 957 +8r + 7x2+ 10r3+6r4 + 11rs 979 +81 + 13r2 + 10rs + 12r4 +1lrs < 1279 +821 + 13r2 + 11r3 + 8r4+ 10rs < 1132 1, 2, 73, 4, Is 2 0 Write down the values of the variables that maximize the objective expression, along with the maximum value of the objective expression and submit these values in pdf format, following the instructions on clickUP. Save your spreadsheet with filename "SupExLinProg" and submit the spreadsheet by following the instructions on clickUP. By setting up a well-documented spreadsheet solve the following abstract linear programming problem. Make sure that you use the Linear Solver (Tools / Solver / Options / Solver Engine / Lincar Solver). Maximize the objective expression: 44r, + 54r2 + 492a+ 44r4 +50rs under the constraints: +10r1 + 10r2 +9r3+11r4+11rs < 1202 +10r1 + 11r2 +9rg +7x4 +7rs < 957 +8r + 7x2+ 10r3+6r4 + 11rs 979 +81 + 13r2 + 10rs + 12r4 +1lrs < 1279 +821 + 13r2 + 11r3 + 8r4+ 10rs < 1132 1, 2, 73, 4, Is 2 0 Write down the values of the variables that maximize the objective expression, along with the maximum value of the objective expression and submit these values in pdf format, following the instructions on clickUP. Save your spreadsheet with filename "SupExLinProg" and submit the spreadsheet by following the instructions on clickUP.
Expert Answer:
Answer rating: 100% (QA)
objective function maximize z 44x 1 54x 2 49x 3 44x 4 50x 5 x 1 13 x 2 15 x 3 23 x 4 ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
It is very important to make sure that you align your pricing strategy with your target market and branding strategy. Below are various businesses and pricing strategies. Match each business with the...
-
rn Make sure that you explain in detail all your steps - thoughts. You may get extra points for an appropriate observation, you may lose some marks due to an obscure solution. 1. Your task is to...
-
Make sure that you Identify the master and servant and examine their relationship in the two stories."The white tiger" by Aravind and "breathin my name with a sigh" by Fred wah. Connect clearly using...
-
Choose a company or product that you have been noticing or admiring. Develop a plan to advertise this product that involves the United States and at least one other country, and three forms of media....
-
A company operates two retail outlets at different locations. The following table lists the customer satisfaction ratings on a scale of 110 for each location: Store 1 Store 2 7 . 8 4 . 7 6 . 10 3 . 8...
-
The Sunshine Oil Company buys crude vegetable oil. Refining this oil results in four products at the splitoff point: A, B, C, and D. Product C is fully processed by the splitoff point. Products A, B,...
-
The variance process in the Heston model satisfy a CIR process: \[d V_{t}=\kappa\left(\bar{V}-V_{t} ight)+\sigma \sqrt{V_{t}} d W_{t}\] Use Ito to calculate the dynamics of the volatility process...
-
(a) Under what conditions is the use of an accelerated depreciation method most appropriate? (b) Why is an accelerated depreciation method often used for income tax purposes? (c) What is the Modified...
-
Below are several amounts reported at the end of the year. Currency located at the company Supplies Short-term investments that mature within three months Accounts receivable Balance in savings...
-
Eta Corporation approaches Lily White, the CEO and sole shareholder of MuCo, regarding the acquisition of MuCo's cat toy division assets (worth $1.3 million). As selling the assets would create a...
-
Steve Jobs was known for his passion towards technology that transcended across his subordinates! Discuss, how can a leader use his passion for his role / job / field to inspire his employees.
-
_____________ is the tendency among members of highly cohesive groups to self-censor, suspend critical thinking, and make faulty decisions.
-
A(n) _____________ is a guide or an overview of the topics that will be covered during the meeting.
-
As of 2017, the majority of states have enacted smoking bans in public places such as workplaces, restaurants, and bars. What is the economic rationale behind these bans in public places? Would a...
-
_____________ is the act of choosing among a set of alternatives under conditions that necessitate choice.
-
_____________ are interested in demonstrating concern for others emotions and interests, finding common ground, and responding.
-
Assuming that the matrix dimensions agree, create, and test MATLAB functions to evaluate the following simple mathematical functions with multiple input vectors and a single output vector. 1. z(x, y)...
-
Refer to the situation described inBE 18-13, but assume a 2-for-1 stock split instead of the 5% stock dividend. Prepare the journal entry to record the stock split if it is to be effected in the form...
-
What techniques do we use to define a product?
-
Michael Carrigg, Inc., is disk manufacturer in need of an aggregate plan for July through December. The company has gathered the following data: Costs________________ Holding cost ...........
-
You have been asked to analyze the bids for 200 polished disks used in solar panels. These bids have been submitted by three suppliers: Thailand Polishing, India Shine, and Sacramento Glow. Thailand...
-
Kaplan gives several examples of the need to clearly explain the cafs purpose and goals. Identify specific assumptions or misconceptions that their audience may have. Why is managing or countering...
-
What organizations are you personally in contact with that rely on grants for all or part of their budget? Are you ever the in a position to make requests for funding? Do you ever receive those...
-
What incentives do digital tools provide to circulate more rather than fewer paper documents? What incentives do companies have to reduce their use of paper? What tradeoffs or conflicts between these...
Study smarter with the SolutionInn App