Question: Refer to the spreadsheet below: table [ [ - 1 , A , B , C , D , E , F , G

Refer to the spreadsheet below:
\table[[-1,A,B,C,D,E,F,G,H,1,J,L,Supply/Demand],[12,,,,Coal Bank Hollow Recycling,],[3,,,,],[4,Flow From Node,],[5,Yield,Flow Into Node,Cost,,Node,],[6,0.0,11,Newspaper,0.90,0.0,,Process 1,$13,,1 Newspaper,Net Flow],[7,0.0,11,Newspaper,0.85,0.0,6,Process 2,$12,,2 Newspaper,0.0,-70],[8,0.0,21,Mixed Paper,0.80,0.0,5,Process 1,$11,,,0.0,-50],[9,0.0,21,Mixed Paper,0.85,0.0,6,Process 2,,,3 White Office,0.0,-30],[10,0.0,3V,White Office,0.95,0.0,5,Process 1,$13,,4 Cardboard,0.0,-40],[11,0.0,31,White Office,0.90,0.0,6,\table[[Process 1],[Process 2]],$9,,5 Process 1,0.0,0],[12,0.0,40,Cardboard,0.75,0.0,5,Process 2,$10,,6 Process 2,0.0,0],[13,0.0,4,Cardboard,0.85,0.0,6,\table[[Process 1],[Process 2]],$13,,7 Newprint,0.0,60],[14,0.0,5F,Process 1,0.95,0.0,7,Process 2,$14,,8 Packaging,0.0,40],[15,0.0,5,Process 1,0.90,0.0,,Newprint,$5,,9 Print Stock,0.0,50],[16,0.0,5,Process 1,0.90,0.0,\table[[8],[9]],Packaging,$6,,,,],[17,0.0,6F,Process 2,0.90,0.0,\table[[9],[7]],Print Stock,$8,,,,],[18,0.0,6P,Process 2,0.95,0.0,\table[[7],[8]],Newprint,$6,,,,],[19,0.0,6F,Process 2,0.95,0.0,\table[[8],[9]],Packaging,$8,,,,],[20,,,,,,,Print Stock,$7,,,,],[21,,,,,,,,,,,,],[22,,,,,,,Total Cost,$0,,,,],[,,,,,,,,,,,,]]
What formula should be used to determine the Flow Into Node value in cell E6(to be copied to E7:E19) in the spreadsheet above?
A**D6
D6* E6
A6*E6
IF )>(0,D6**E6,A6**D6
None of the above
 Refer to the spreadsheet below: \table[[-1,A,B,C,D,E,F,G,H,1,J,L,Supply/Demand],[12,,,,Coal Bank Hollow Recycling,],[3,,,,],[4,Flow From Node,],[5,Yield,Flow

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 General Management Questions!