Question: Please provide a screenshot for excel solver. Maximize Z = 18x1A + 20x1B +21x1C +17x1D subject to (.3x1A + .9x1B + .6x1C + .4x1D +

Please provide a screenshot for excel solver.

Maximize Z = 18x1A + 20x1B +21x1C +17x1D

subject to (.3x1A + .9x1B + .6x1C + .4x1D + .8x2A + .5x2B + 1.1x2C + .7x2D + 1.1x3A + 1.3x3B + .6x3C + .8x3D + 1.2x4A + .8x4B + .6x4C + .9x4D + 1.0x5A + .9x5B + 1.0x5C + 1.0x5D)/(18x1A + 20x1B + 21x1C + 17x1D + 19x2A + 15x2B + 22x2C + 18x2D + 20x3A + 20x3B + 17x3C + 19x3D + 24x4A + 21x4B + 16x4C + 23x4D + 22x5A + 19x5B + 21x5C + 21x5D) .04 x1A + x1B + x1C + x1D 1 x2A + x2B + x2C + x2D 1 x3A + x3B + x3C + x3D 1 x4A + x4B + x4C + x4D 1 x5A + x5B + x5C + x5D 1 x1A + x2A + x3A + x4A + x5A = 1 x1B + x2B + x3B + x4B + x5B = 1 x1C + x2C + x3C + x4C + x5C = 1 x1D + x2D + x3D + x4D + x5D = 1 xij = 0 or 1

What are the optimal-values?

What is the z-value?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

To answer this question, we are to look on analytics.google.com....

In linux I would like this completed in:::: Task 3 Create two text files name file1 and file2. file1 file 001 056 127 258 file2 file INFO 1111: Linux INFO-1111: LINUX 002 056 167 369 Provide a...

5.5) Please complete the following tasks (10 points) a) Please create the following data file on the server: $ last -wi | grep "ic3311" | grep "Apr 25" > loginfile4final $ cat loginfile4final ic3311...

A. The supply chain department would like a list of the currently sold products whose quantity on hand has dropped below the reorder point. Design a query that displays the product name, supplier and...

1. Open Wireshark in Windows 10 as well as the command prompt. 2. While at the command prompt identify the Mac address and Ip address for the gateway device that the client is connected to. 3. Your...

Need Help with Linux!! 5.2) Based on HW 5, please write a shell script with a for-loop, which displays all executable files but not directories under /etc directory. Your script should not display...

A. Marketing is planning a campaign to target top customers (measured in terms of 2016 and 2017 NET sales equal to or greater than $10,000). They want to know the combined 2016 and 2017 net sales...

Need help with Linux!! 5.4) Based on Lab 7, Handouts 7 (example 1), and HW 7, please create a file called myloginfile as shown below and then write an awk script called mylogincheck to check on file...

Assignment Details All the table schemas used in this assignment are listed here: clicks(display_id,ad_id,clicked) primary key (display_id, ad_id)...

Part II: Multiple Choices Choose the correct answer among the given alternatives and write the letter of your choice on the space provided. (1 pt. each) 1. Which of the following is a means of...

Allendale Enterprises is deciding whether to expand its production facilities. The management team has projected the following cash flows for the first three years (in millions of dollars): Revenue...

CAPM and Valuation You are considering acquiring a firm that you believe can generate expected free cash flows of 1 0 0 0 0 a year forever However you recognize that those cash flows are uncertain LO...

Additional Exercises: 12. Draw the product of the reaction of benzene with each of the following reagents. (a) H2SO4,HNO2 (b) Br2,FeBr3 (c) CH3CH2Cl,AlCl3 (d) Cl2,AlCl3 (e) CH3COCl,AlCl3

Give an example of a Composite Primary Key use in a HCM Payroll Table.

How are Third Normal Form rules disregarded in Dimensional Database Design?

Provide examples of Dimensional Tables.