Question: What formula would you enter in objective function cell in this excel model? A B C D E F G H J K L M

What formula would you enter in "objective function cell" in this excel model?

A B C D E F G H J K L M Unit Net Supply/ 3 X Flow from Node Yield Flow into Node Cost Nodes Flow Demand Crude A 0.90 3 Refinery 1 15 1 Crude A 120 Crude A 0.85 4 Refinery 2 13 2 Crude B 60 2 Crude B 0.80 3 Refinery 1 9 3 Refinery 1 0 2 Crude B 0.85 4 Refinery 2 11 4 Refinery 2 0 3 Refinery 1 0.95 5 Lube Oil 4 5 Lube Oil 75 3 Refinery 1 0.90 6 Gasoline 7 6 Gasoline 50 10 3 Refinery 1 0.90 7 Diesel 8 7 Diesel 25 11 4 Refinery 2 0.90 5 Lube Oil 3 12 4 Refinery 2 0.95 6 Gasoline 9 13 4 Refinery 2 0.95 7 Diesel 6 14 15 Total costIll. What formula would you enter in "objective function cell" in this Excel model? BI a. SUMPRODUCT(D4:D15,A4:A15) b. SUMPRODUCT(H4:H13,A4:A13) c. SUMPRODUCT(H6:H15,A6:A15) d. SUMPRODUCT(H6:H15,A6:A15)

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 Mathematics Questions!

In the table below is the data on shipping costs per unit for a transportationproblem for O'Neill Company. A and B are the sources. 1, 2, and 3 are the destinations. Destination Supply 1 2 3 Source A...

Below is the data for a cost - benefit problem for Eleko company. 1 , 2 , 3 , and 4 are different activities the company can undertake. X , Y , and Z are benefits the company gets from the...

M4 Group Assignment Instructions Complete the Assignment, name it as GroupXX_Assign4.xls (where XX is your Group Name), and upload and submit to the instructor through Folio Dropbox. Do not enter...

PUAD 630 - A NALYTICAL T ECHNIQUES U NIVERSITY OF B ALTIMORE , C OLLEGE OF P UBLIC A FFAIRS S EZGIN AYABAKAN , P H D Assignment 5 Individual or in Pairs Due Date: Dec 07, 2015 at 10:00AM There are...

M4 Group Assignment Instructions Complete the Assignment, name it as GroupXX_Assign4.xls (where XX is your Group Name), and upload and submit to the instructor through Folio Dropbox. Do not enter...

Product-Mix Problem of BlubberMaid, Inc., Revisited Recall that BlubberMaid, Inc., manufactures three rubber-based products: Airtex, Extendex, and Resistex. The number of ounces of each ingredient...

Here is a L.P model of a manufactaring grocess concernod with the production of four variants of the same product, A, B, C, and D, each of which will yield a certain profit per unit sold, and each...

1 Part a Max Profit Grader X1 Sofa X2 Table X3 Chair Grader Dec Vars Part b Profit Coefficients Part c Constraint Coefficients Wood Upholstery Labor Warehouse Capacity Solver Solution X1 Sofa X2...

Problem 1 : ( Page 4 5 0 Problem 1 ) Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the...

2 / 2 100% + Excerca Sensitivity Analysis Practice Exercise Directions: 16. Make sure that you downloaded the incomestatement file from Blackboard 17. Upload it to Office 360 and open it with...

You have the following information for Crystal Inc. for the month ended May 31, 2014. Crystal uses a periodic method for inventory. Instructions (a) Calculate (i) ending inventory , (ii) cost of...

Scientists commonly compare species trees with gene trees. The (a) species phylogeny of marine and freshwater stickleback fish populations and (b) the low-plate Edu gene phylogeny are shown. Which of...

Which of the following is not a source of funds to grow a business? Existing cash generated by the operation of the business Retalned earnings Loans Additional equity investment

In the context of business analytics, which method reviews past events, analyzes the data, and reports on what happened in a given period? a. Descriptive analytics b. Prescriptive analytics c....

4. Give an example of how the consistency principle can be used to influence others.

6. Give an example of how the liking principle can be used to influence others.

5. Give an example of how the consensus principle can be used to influence others.