Discuss how the various stages and their costs impact the ability of Crosswell as anexporter in being competitive on the pricing of its products in penetrating the
Brazilian market.
Pricing Croswill - Sosa - Microsoft Excel (Product Activation Failed) X File Home Insert Page Layout Formulas Data Review View % Cut Wrap Text General E AutoSum * Calibri 11 A En Copy Fill Paste Format Painter BIU . BY . A 3 Merge & Center $ - Conditional Format Cell Insert Delete Format 2 Clear Sort & Find & Formatting * as Table * Styles Filter Select Clipboard Font Alignment Number Styles Cells Editing E8 A B C D E F G H J K L Export Costs and Pricing to Brazil Per case Retails & Calculations Value Price per container $4180 FAS price per case, Miami $34.00 Case per container 968 Freight, loading and documentation 4.32 CFR price per case, Brazilian Port $38.32 Currency Fluctuation? 2.50 Real / US$ 2.5 Export Insurance 0.86 285X O/CY 2.25% 2.75 Real / US$ (Depreciation of Real to U! 2.75 IF to Brazilian port (USD) $39.18 2.25 Real / US$ (Appreciation of Real to U 2.25 CIF ort (Real, BRL 137.13 250 FEE/1USD 3.5 Brazilian Importation Costs Price / Case from Mian Expected $34.00 Import Duties BRL 2.74 EX OfCFF 2%% Options 1 $33.00 10 Merchant Marine Renovation fee BRL 3.78 25 of hangin 25% Options 2 $32.00 11 Port Storage fees BRL 1.78 180/CFF 1.30% 12 Port Handling fees BRL 0.01 Ade percontainer 12 Cost of financing Expected 7%% 13 Additional Handling fees BRL 0.36 20 ofstorage and handing 20% Options 1 6% 14 Customs Brokerage Fees BRL 2.74 EX O/CW 2% Options 2 5% 15 Import license fee BRL 0.05 F50percontainer 50 16 Local Transportation charges BRL 2.06 15X 3/CFF 1.50% Distributors Margin Expected 20% 17 Total cost to distributor (Re BRL 150.66 Options 1 15% 18 Distributors costs and Pricing Options 2 10% 19 Storage Cost BRL 2.06 15::9/OFF xmonths 1.50% 20 Cost of financing diaper inventory BRL 9.60 Mefolkmonths 7% Retailers Markup Expected 30% 21 Distributors margin BRL 32.46 207 of cost + storage + Minand 20% Options 1 27% 22 Price to retailer (Real) BRL 194.78 Options 2 24% 23 Brazilian Retailer Costs and Pricing 24 Industrial product tax (IPT) BRL 29.22 15: ofprice to retailer 15% Price/Diaper "Precious" 25 Mercantile circulation services tax (I BRL 40.32 15 0/price + /F7 18% 0.70 26 Retailer costs and markup BRL 79.30 302: ofpres + PT + NICS 30% 0.96 27 Price to consumer (Real) BRL 343.62 1.28 28 29 Diaper Price to Consumers Diapers Per Case Price/Diaper "Precious rice/Diaper "Monica Plustrice/Diaper "Sempre Secaprice/Diaper "Pampers uni 30 Small Size 352 BRL 0.98 BRL 0.68 BRL 0.65 BRL 0.65 31 Medium Size 256 BRL 1.34 BRL 0.85 BRL 0.80 BRL 0.80 32 Large Size 192 BRL 1.79 BRL 1.18 BRL 1.08 BRL 1.08 14 Sheet1 Sheet2 Sheet3 IIII Ready 0 80% + 7:23 PM O Type here to search X 19-May-19