Need help finding the total landed costs for all 6 countries below
Cost Structure - Year O (1) .XLSX File Edit View Insert Format Data Tools Help Share Last edit was made yesterday at 5:13 PM by Jasmine Jackson 100% , $ % % . .00 123- Calibri 11 BISA EL-R - OY.. fx Cost Structure - Start A C D F H ! J K 1 1 Cost Structure - Start Cost Structure 2 3 4 5 Econ/Sm/Tube/Pst Econ/Md/Tube/Pst Econ/La/Tube/Pst Average Product Cost per Unit BELLA Argentina $0.34 $0.43 $0.51 $0.43 Home $0.43 $0.53 $0.63 $0.53 ASHLIN Brazil $0.34 $0.43 $0.52 $0.43 GROUP Chile $0.38 $0.47 $0.57 $0.47 GAB Colombia $0.32 $0.40 $0.48 $0.40 JAKE Mexico $0.36 $0.45 $0.55 $0.45 JASMINE Peru $0.33 $0.41 $0.49 $0.41 E Administrative costs and Fixed costs are in thousands. Cost Structure data is for the current year 7 Volume Assumption 10 11 1.00% 14 Administrative Costs Administrative (Percent Sales) Per SKU Per Channel Per Direct Outlet 1.00% $81 $254 $122 1.00% $107 $584 $146 1.00% $83 $252 $151 1.00% 574 $317 $116 $70 $248 $94 1.00% $71 $254 $97 15 16 17 18 19 20 21 Sales Force Expense Sales Representative Salary Average Expenses Per Unit $35,494 $12,169 $7,606 $36,969 $10,702 $ $6,324 $35,727 $12,077 $8,554 $21,853 $5,960 $5,463 $27,979 $8,447 $6,863 $22,347 $6,095 $5,587 22 24 25 26 Fixed Costs Distribution Center Manufacturing Plant (100mil/yr) $1,014 $9,495 $1,946 $9,495 $755 $9,495 $497 $9.495 $1,056 $9.495 $508 $9.495 27 28 29 Cost Structure Total per Unit 30 Cost Structure - Year (1) XLSX File Edit View Insert Format Data Tools Help E Last edit was made yesterday at 5:13 PM by Jasmine Jackson 100% - $ % 0.00 123 Calibri 11 - BISA B BI E- T- G FLY, sx Cost Structure - Start A B D E F G H J K 30 31 Tariffs Tariffs a a percent of CIF 32 33 Chile Plant Brazil Plant 0.0% 34 0.0% Colombia Plant 20.0% 17.0% Mexico Plant 20.0% 17.0% 35 0.0% 36 Home Plant Argentina Plant 21.05 21.09 0.0% 0.0% 0.0% 0.0% 12.0% 0.0% 15.096 12.0% 12.0% Peru Plant 20.0% 17.0% 0.0% 0.0% 0.0% Argentina Brazil Chile Colombia Mexico Peru 0.0% 0.0% 0.0% 0.0% 37 38 12.0% 15.0% 12.0% 0.0% 0.0% 0.0% 0.0% 0.0% 39 0.0% 40 41 Total Tariff % 54.0% 39.0% 39.0% 0.0% 37.096 37.0% 37.0% 42 43 44 Shipping Shipping cost per UNIT in $ 45 46 Argentina Brazil Chile Colombia Home Plant $0.060 $0.060 $0.060 $0.060 $0.020 $0.060 49 Argentina Plant $0.010 $0.020 $0.020 $0.020 $0.040 $0,020 Brazil Plant $0.020 $0.010 $0.020 $0.020 $0.040 $0.020 Chile Plant $0.020 $0.020 $0.010 $0.020 $0.030 $0.020 Colombia Plant $0.020 $0.020 $0.020 $0.010 $0.020 $0.020 Mexico Plant $0.040 $0.040 $0.030 Peru Plant $0.020 $0.020 $0.020 $0.020 $0.020 $0.010 50 51 $0.020 Mexico $0.010 $0.030 52 Peru 53 54 Total Shipping Cost $0.32 $0.13 $0.13 $0.12 $0.11 $0.17 $0.11 55 56 Total Landed Cost 57 58 Cost Structure - Year O (1) .XLSX File Edit View Insert Format Data Tools Help Share Last edit was made yesterday at 5:13 PM by Jasmine Jackson 100% , $ % % . .00 123- Calibri 11 BISA EL-R - OY.. fx Cost Structure - Start A C D F H ! J K 1 1 Cost Structure - Start Cost Structure 2 3 4 5 Econ/Sm/Tube/Pst Econ/Md/Tube/Pst Econ/La/Tube/Pst Average Product Cost per Unit BELLA Argentina $0.34 $0.43 $0.51 $0.43 Home $0.43 $0.53 $0.63 $0.53 ASHLIN Brazil $0.34 $0.43 $0.52 $0.43 GROUP Chile $0.38 $0.47 $0.57 $0.47 GAB Colombia $0.32 $0.40 $0.48 $0.40 JAKE Mexico $0.36 $0.45 $0.55 $0.45 JASMINE Peru $0.33 $0.41 $0.49 $0.41 E Administrative costs and Fixed costs are in thousands. Cost Structure data is for the current year 7 Volume Assumption 10 11 1.00% 14 Administrative Costs Administrative (Percent Sales) Per SKU Per Channel Per Direct Outlet 1.00% $81 $254 $122 1.00% $107 $584 $146 1.00% $83 $252 $151 1.00% 574 $317 $116 $70 $248 $94 1.00% $71 $254 $97 15 16 17 18 19 20 21 Sales Force Expense Sales Representative Salary Average Expenses Per Unit $35,494 $12,169 $7,606 $36,969 $10,702 $ $6,324 $35,727 $12,077 $8,554 $21,853 $5,960 $5,463 $27,979 $8,447 $6,863 $22,347 $6,095 $5,587 22 24 25 26 Fixed Costs Distribution Center Manufacturing Plant (100mil/yr) $1,014 $9,495 $1,946 $9,495 $755 $9,495 $497 $9.495 $1,056 $9.495 $508 $9.495 27 28 29 Cost Structure Total per Unit 30 Cost Structure - Year (1) XLSX File Edit View Insert Format Data Tools Help E Last edit was made yesterday at 5:13 PM by Jasmine Jackson 100% - $ % 0.00 123 Calibri 11 - BISA B BI E- T- G FLY, sx Cost Structure - Start A B D E F G H J K 30 31 Tariffs Tariffs a a percent of CIF 32 33 Chile Plant Brazil Plant 0.0% 34 0.0% Colombia Plant 20.0% 17.0% Mexico Plant 20.0% 17.0% 35 0.0% 36 Home Plant Argentina Plant 21.05 21.09 0.0% 0.0% 0.0% 0.0% 12.0% 0.0% 15.096 12.0% 12.0% Peru Plant 20.0% 17.0% 0.0% 0.0% 0.0% Argentina Brazil Chile Colombia Mexico Peru 0.0% 0.0% 0.0% 0.0% 37 38 12.0% 15.0% 12.0% 0.0% 0.0% 0.0% 0.0% 0.0% 39 0.0% 40 41 Total Tariff % 54.0% 39.0% 39.0% 0.0% 37.096 37.0% 37.0% 42 43 44 Shipping Shipping cost per UNIT in $ 45 46 Argentina Brazil Chile Colombia Home Plant $0.060 $0.060 $0.060 $0.060 $0.020 $0.060 49 Argentina Plant $0.010 $0.020 $0.020 $0.020 $0.040 $0,020 Brazil Plant $0.020 $0.010 $0.020 $0.020 $0.040 $0.020 Chile Plant $0.020 $0.020 $0.010 $0.020 $0.030 $0.020 Colombia Plant $0.020 $0.020 $0.020 $0.010 $0.020 $0.020 Mexico Plant $0.040 $0.040 $0.030 Peru Plant $0.020 $0.020 $0.020 $0.020 $0.020 $0.010 50 51 $0.020 Mexico $0.010 $0.030 52 Peru 53 54 Total Shipping Cost $0.32 $0.13 $0.13 $0.12 $0.11 $0.17 $0.11 55 56 Total Landed Cost 57 58
