Find the total cost for each network in the excel file Transportation LP Example 2 (both sheets). Sheet one is the current network (network 1), sheet two is the proposed new network (network 2). Comparing the two networks and using the following information, should the company change their network to network number 2? Submit one excel file with your written statements in a text box. 20.00% Tax Rate Straight Line Depreciation 5 year useful life No Salvage Value 12.00% Discount Rate 1 year construction cycle 265,000 Initial Investment 24% Hurdle Rate Home Insert Draw Page Layout Formulas Data Calibri (Body) v 11 V ' ' 11.III Paste . I U v V A V = 115 fx B C D E F G H 1 From 2 3 Supply 25,000 Plant 1 Plant 2 DC 1 $11 $10 $12 To DC 2 DC 3 $8 $12 $11 $14 $8 $15 4 40,000 55,000 5 Plant 3 Demand 70,000 30,000 20,000 6 7 8 To From DC 1 DC 2 Shipped 9 10 11 0 0 Plant 1 Plant 2 Plant 3 DC 3 0 0 0 Supply 25,000 40,000 55,000 0 0|0|0 Oooo 0 12 0 0 0 13 Received 0 0 0 14 Demand 70,000 30,000 20,000 15 16 17 Total Cost From DC 1 DC 2 DC 3 18 19 0 0 0 20 Plant 1 Plant 2 Plant 3 0 0 0 21 0 0 0 Total Cost 0 Home Insert Draw Page Layout Formulas C X Times New Roman v 12 v A? Paste BI U v v Av D24 x fx o B C D E F Total Cost 18 19 To From 20 DC 1 DC 2 DC 3 0 21 22 0 0 0 Plant 1 Plant 2 Plant 3 Plant 4 0 0 0 0 23 0 Total Cost 0 0 0 0 0 24 25 26 27 28 29 30 Find the total cost for each network in the excel file Transportation LP Example 2 (both sheets). Sheet one is the current network (network 1), sheet two is the proposed new network (network 2). Comparing the two networks and using the following information, should the company change their network to network number 2? Submit one excel file with your written statements in a text box. 20.00% Tax Rate Straight Line Depreciation 5 year useful life No Salvage Value 12.00% Discount Rate 1 year construction cycle 265,000 Initial Investment 24% Hurdle Rate Home Insert Draw Page Layout Formulas Data Calibri (Body) v 11 V ' ' 11.III Paste . I U v V A V = 115 fx B C D E F G H 1 From 2 3 Supply 25,000 Plant 1 Plant 2 DC 1 $11 $10 $12 To DC 2 DC 3 $8 $12 $11 $14 $8 $15 4 40,000 55,000 5 Plant 3 Demand 70,000 30,000 20,000 6 7 8 To From DC 1 DC 2 Shipped 9 10 11 0 0 Plant 1 Plant 2 Plant 3 DC 3 0 0 0 Supply 25,000 40,000 55,000 0 0|0|0 Oooo 0 12 0 0 0 13 Received 0 0 0 14 Demand 70,000 30,000 20,000 15 16 17 Total Cost From DC 1 DC 2 DC 3 18 19 0 0 0 20 Plant 1 Plant 2 Plant 3 0 0 0 21 0 0 0 Total Cost 0 Home Insert Draw Page Layout Formulas C X Times New Roman v 12 v A? Paste BI U v v Av D24 x fx o B C D E F Total Cost 18 19 To From 20 DC 1 DC 2 DC 3 0 21 22 0 0 0 Plant 1 Plant 2 Plant 3 Plant 4 0 0 0 0 23 0 Total Cost 0 0 0 0 0 24 25 26 27 28 29 30
