Best Efforts Contract by bsz14056

VIEWS: 5 PAGES: 4

More Info
									Economic Transparency Guide Excel Sheet


The following spread sheet can help your organization calculate and organize economic transparencies.
Fill in colored cells. Cells in white will calculate automatically based on their underlying formulas
Please be aware of units of measure. Feel free to adjust this spread sheet to better address your supply chain.


Required Support documents for Transparency: These documents are the absolute minimum we request.
Provide Support documents for Transparency: we would appreciate your best efforts on these documents. If no documents are available do provide the figures.


Contract                  1500000
                                                                                                                   Price per Lb
Bags                         4000                                   Lbs                                    608,480 FOB                                      1.15

Quantity Cherry
Delivered Units,                                                                      Price Paid for Cherry per
Quintales                           Kgs per Unit of Cherry                            Quintal in US $                              Price Paid per Kg of Cherry




              3300                                            46                                                  14                              0.304347826

                                                                                      Quantity Cherry Delivered                    Price Paid for Cherry
                                                                                      (converted to Lbs)                           (converted to Lbs)

WET MILL                                                                                                   334,662                                         0.138

                                    Cherry Loss in % (Quality
                                    Separation / Receiving                            Equivalent Quantity of                       Price Equivalent Paid for
                                    Tank)                                             Cherry to Process                            Cherry

                                                         1.00%                                             331,315                                         0.139

                                    Yield of Cherry to
                                    Parchment                                         Quantity of Parchment                        Price equivalent Parchment

                                                              4.8                                              69,024                                      0.669



                                                                                                                                   Price Equivalent Paid for
                                    Cherry to Parchment                                                                            Parchment including
                                    Processing Costs $ / lb                                                                        Processing Costs


                                                             0.02                                              69,024                                      0.689



                                    Parchment Loss Sorting
                                    in % (SBUX vs Non                                 Quantity of Pachment for                     Price Equivalent Paid for
                                    SBUX)                                             SBUX                                         Parchment SBUX

                                                         1.00%                                                 68,334                                      0.696

                                                                                                                                   Price Equivalent Paid for
                                                                                                                                   Parchment SBUX including
                                    Cost of Sorting $ / Lb                                                                         cost of sorting

                                                             0.01                                              68,334                                      0.706


                                    Transport Costs $ / Lb

                                                             0.02                                              68,334                                      0.726


                                    Administrative Costs $ / lb

                                                             0.01                                              68,334                                      0.736


                                                                                                                                   Price Equivalent Paid for
                                                                                                                                   Parchment SBUX including
                                    Wet Mill Commision                                                                             Wet Mill Commision

                                                             0.02                                              68,334                                      0.756



                                                                                      Quantity Parchment                           Price Paid for Parchment in
                                                                                      Delivered in Lbs                             lbs


DRY MILL /
SHIPPER                                                                        2-A                         720,000           2-B                            0.75




                                                                                                                   Weighted
                                                                          1-A + 2-A                        788,334 Average Price                  0.750545776
                                    Parchment Loss Sorting
                                    in % (SBUX vs Non                                 Quantity of Pachment for                     Price Equivalent Paid for
                                    SBUX)                                             SBUX                                         Parchment SBUX


                                                         2.00%                                             772,567                                0.765863037

                                    Yield of Parchment to                                                                          Price Equivalent Paid for
                                    Green                                             Quantity of Green                            Green


                                                             1.28                                          603,568                                         0.980
                                          Price Equivalent Paid for
Dry Processing Costs $ /                  Parchment SBUX including
lb                                        Dry Processing Costs

                         0.01   603,568                       0.990

Financing Costs $ / lb

                         0.02   603,568                       1.010

Export Costs,
Transportation,
Administrative $ / lb

                         0.03   603,568                       1.040


Commision to Intemediary
/ Agent / Supplier if
applicable $ /lb                          FOB Price equivalent Green

                         0.02   603,568                       1.060
Premium to Producer $
/lb



                         0.02   603,568                       1.080
are available do provide the figures.




                    Required Support documents
                    for Transparency




                    Provide Support documents for
                    Transparency




                    Provide Support documents for
                    Transparency




                    Provide Support documents for
                    Transparency




                    Provide Support documents for
                    Transparency




                    Provide Support documents for
                    Transparency




                    Provide Support documents for
                    Transparency



                    Provide Support documents for
                    Transparency



                    Provide Support documents for
                    Transparency




                    Provide Support documents for
                    Transparency




                    Required Support documents
                    for Transparency




                    Provide Support documents for
                    Transparency




                    Provide Support documents for
                    Transparency
Provide Support documents for
Transparency



Provide Support documents for
Transparency




Provide Support documents for
Transparency




Provide Support documents for
Transparency




Required Support documents
for Transparency

								
To top