Question: can someone check my work please. File Home Insert Page Layout Formulas Data Review View 21 A1 ZA From Access From Web From From Other

can someone check my work please.

can someone check my work please. File Homecan someone check my work please. File Homecan someone check my work please. File Homecan someone check my work please. File Home

File Home Insert Page Layout Formulas Data Review View 21 A1 ZA From Access From Web From From Other Text Sources Get External Data Existing Connections De Connections Properties Refresh All Go Edit Links Connections At Sort * Clear Reapply Filter Advanced Sort & Filter Text to Remove Dat Columns Duplicates Validat Data L14 fox A B C D E F G . J K SunNet NO CO oro From 1 1 -40 N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Flow 0.0 30.0 28.0 12.0 32.0 0.0 0.0 To 6 7 6 7 6 7 8 7 8 7 8 2 3 3 3 4 4 5 5 Cost $6.50 $7.50 $7.00 $8.00 $8.25 $7.25 $6.75 $7.75 $7.00 $7.50 $6.75 Node Net Flow Supply/Demand 1 -$30.00 -30 2 -$40.00 3 -$32.00 -25 4 -$35.00 -35 5 -$33.00 -33 6 $60.00 60 7 $70.00 70 8 $40.00 40 00 NO 0.0 35.0 28.0 5.0 on on OO 00 Total Cost $1,269.75 22 23 24 25 26 27 28 29 21 AZ At Sort O O ON 67 Prb5_9_empty File Home Insert Page Layout Formulas Data Review View Connections Clear | ZA Properties Reapply From From From From Other Existing Refresh Filter Text to Remove Data Consolidate What If Access Web Text Sources Connections All Edit Links Advanced Columns Duplicates Validation Analysis Get External Data Connections Sort & Filter Data Tools H6 fx =SUMIF($D$6:$D$16, G6,$B$6:$B$16)-SUMIF($C$6:$C$16, G6,$B$6:$B$16) A B D E F G . I J K L M N 1 2 SunNet 3 4 5 Flow From Cost Node Net Flow Supply/Demand 0.01 $6.50 1 -$30.00 -30 7 30.0 1 $7.50 2 -$40.00 -40 8 28.0 2 6 $7.00 3 $32.00 -25 9 12.0 2 7 $8.00 4 -$35.00 -35 10 32.0 3 6 $8.25 5 -$33.00 -33 11 0.0 3 7 $7.25 6 $60.00 60 0.0 3 8 $6.75 7 $70.00 70 13 0.0 4 7 $7.75 8 $40.00 40 14 35.0 4 8 $7.00 28.0 5 7 $7.50 16 5.0 5 8 $6.75 17 18 Total Cost $1,269.75 19 20 21 22 23 24 25 N . 12 N co 15 26 27 28 29 1212 o Inn At Sort Text to Remove Columns Duplicates Valid Dat J K CO File Home Insert Page Layout Formulas Data Review View Connections Clear Properties Reapply From From From From Other Existing Refresh Filter Access Web Text Sources Connections All Edit Links Advanced Get External Data Connections Sort & Filter E18 for =SUMPRODUCT(B6:B16, E6:516) A B D E F G H I 1 2 SunNet 3 4 5 Flow From Cost Node Net Flow Supply/Demand 0.0 1 $6.50 1 -$30.00 -30 7 30.0 1 $7.50 2 -$40.00 -40 8 28.0 2 $7.00 3 $32.00 -25 9 12.0 2 $8.00 4 -$35.00 -35 10 32.0 3 $8.25 5 -$33.00 -33 11 0.0 3 $7.25 6 $60.00 60 12 0.0 3 8 $6.75 7 $70.00 70 13 0.0 4 7 $7.75 8 $40.00 40 14 35.0 4 8 $7.00 15 28.0 5 7 $7.50 16 5.0 5 8 $6.75 17 18 Total Cost $1,269.75 19 20 21 22 23 wNN 1676767 3 N00 A on on Solver Parameters x Set Objective: SE$18 To: O Max O Min O Value of: 0 By Changing Variable Cells: $B$6:$B$16 Subject to the Constraints: $H$6: SH$13

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!