{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Getting Started","What Certification offers","Assessment","Suitability","Decision Finder","Relevant Resources","Business Plan","Currency Conversion "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Getting Started","index":0,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Getting Started"]
[]
[null,"Explaination of the Assesment Tool and how it works"]
[null,"This tool has been set up to assist Pacific producers to work through the process of choosing which of the certification schemes is best for them. The assessment works by looking at what your business looks like now and what it could look like under a certification scheme. This will guide you towards the appropriate certification scheme."]
[]
[null,"The Process"]
[null,"Become familiar with what advantages you can gain from becoming certified"]
[]
[null,"Gain an understanding of the range of certification schemes that are availabe for Pacific producers."]
[]
[null,"Enter data on what your production system is like now and what you plan it to be."]
[]
[null,"This may require you to carry out some business planning."]
[]
[null,"Assess which of the schemes is the most suitable for your system."]
[]
[null,"This may require that you go back through your production system and alter the way that you intend to carry out production."]
[]
[null,"Make a decision on which is the most suitable system for you."]
[]
[null,"Contact a certifying agency to discuss in more detail what process you have to go through to become certified."]
[]
[]
[null,"How To Guide "]
[]
[null,"Step 1: Read through the \"What Certification Offers\" Tab to get an understanding of each of the certification types"]
[null,"Step 2: Fill out the blue squares in the \"Assessment\" Tab under the headings \"What your business looks like now\" and \"What your business would look like with certification\" (these are predominantly drop down boxes)"]
[null,"Step 3: Go to the Suitability Tab. The results of your assessments for what your business looks like now and under a certification scheme are displayed and then are assessed against the certification schemes. If your result  reads \"suitable\" this means your operation meets the basic suitability test for that certification. If it says \"Not Completely Suitable\" refer to the red boxes for guidance on where your business is not suitable with the certification. At the bottom of the assessment  this you will see the expected revenue with the particular certification and the net benefit of gaining certification"]
[null,"Step 4: Go to the \"Decision Finder\" Tab. This will show the qualitative suitability of each of the certification types and the potential financial return. It will then identify which certification types are both suitable and financially beneficial."]
[]
[]
[null,"Glossary of Terms"]
[]
[null,"Current Profit: Profit is the money you have left after paying for business expenses"]
[null,"Premium with Certification : The additional money you will receive with a certification. This is expressed as a percentage in the calculation; to work this out divide the price you would receive with certification by the price you receive before certification minus 1. If you are unsure of the premium you would receive take a look at Table B for guidance."]
[null,"Example: price with certification - $6.50, price without certification $5"]
[null,"Premium can be calculated by (6.50/5)-100 = 0.3 or 30%"]
[]
[null,"Change in Volume Produced: This is the difference between the quantity produced currently and the quantity you would be producing with certification. This is expressed as a percentage in the calculation; to work this out divide the volume you would produce with certification by the volume you produce now minus 1."]
[null,"Example: Quantity Produced Now: 10,000 tonnes Quantity Produced with Certification: 15,000"]
[null,"Change in volume can be calculated  by (15,000/10,00)-1 = 0.5 or 50%"]
[]
[null,"Estimated Cost of Certification: This is the cost that is associated with each individual certification, if you are unsure of the costs you may face around the certification you can use Table A as a guide."]
[]
[null,"Estimated Profit with Certification: This outlines the amount of money you are likely to make with the specific certification"]
[]
[null,"Estimated Profit Gain from Certification: This is the benefit of gaining certification compared to your current situation."]
[]
[null,"Social Good: Social good is defined as an action that provides some sort of benefit to the general public."]
[]
[null,"Sole Grower: This means you are an individual grower that is a sole operator."]
[]
[null,"Processor: This means that you take raw materials and process them into a product beyond the raw material"]
[]
[null,"Grower Group: This means that you are operating with multiple other producers/processors under an internal control system"]
[]
[null,"PGS: Stands for Participatory Guarantee System"]

{"sheet":"What Certification offers","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[15,1,15,2],[14,1,14,2],[18,1,18,2],[20,1,22,1],[20,2,22,2],[16,1,16,2],[3,1,3,2],[4,1,4,2],[1,1,1,2],[13,1,13,2],[5,1,5,2],[6,1,6,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[7,1,7,2],[20,3,22,3],[20,7,22,7],[20,8,22,8],[20,6,22,6],[20,5,22,5],[20,4,22,4]]}
[]
[null,"What Certification Offers"]
[]
[null,"This section explains is what is involved in certification is a formal recognition and acknowledgement that the practices which are being carried out by the growers meet the requirements of the developers of the standards and can be regularly verified as meeting those standards by the certificating body."]
[null,"We surveyed Pacific growers and stakeholders who gained market or quality certification for their farms or production systems. Here are some benefits they shared: "]
[null,"ü  Enables access to higher value markets."]
[null,"ü  Provides assurance in relation to the safety of food that we produce."]
[null,"ü  Improves the image / branding of our farms business."]
[null,"ü  Results in improved production efficiency and profitability for my farm / business. "]
[null,"ü  Enables our business to identify and manage risks."]
[null,"ü  Provides assurance that our business is operating sustainability."]
[null,"ü  Obtains information to help make business decisions and develop strategies."]
[null,"What we can take from the survey results are that all of the options had a high recognition as to their benefits from the respondents and so were significant. \n\nWe note that any move towards certification should be market driven, align with market demand and be representative of consumer preferences"]
[null,"The Elements of Certification"]
[null,"ü  The broad elements of certification of growers systems fall into two broad categories"]
[null,"ü  Provides assurance on the safety or quality of a product."]
[null,"ü  Providing that the grower practics being carried out are sustainable be it the environment, social or economic sustainability"]
[]
[null," Explanation of the Certification schemes available. "]
[]
[null,null,"Organic Participatory Guarantee System","Organic 3rd Party Certification Individual","Organic 3rd Party Certification Grower Group ","Fair Trade","Food Safety","Rain Forest Alliance","Sustainable Fisheries"]
[]
[]
[null,"Description","PGS systems are locally focused organic assurance systems. This guarantee provides farmers with recognition in local markets without the same compliance requirements as an ICS system or the costs associated with it. This system suits farmers who wish to sell locally but wish to be able to label their products as organic. ","3rd Party Organic Certification by an independent accredited Certification Body [CB] to an Organic Standard is more complicated than PGS certification but it is necessary to access Regulated Organic Markets.","Group certification is an approach that facilitates access for small operators wishing to gain organic certification and access to organic markets. This allows the smaller operators to access third-party certification. Due to there being multiple farmers involved the amount of administration required in this process is larger however the certification costs for group members are lower than on an individual basis.","Fairtrade changes the way trade works through better prices, decent working conditions and a fairer deal for farmers and workers in developing countries. A product with the FAIRTRADE Mark means producers and businesses have met internationally agreed standards which have been independently certified.","There area wide range of food safety programs available. They range from the simple HACCP schemes through to the complicated GlobalGAP schemes. ","The Rainforest Alliance is a sustainable agriculture certification. Rainforest certification looks at sustainability based on three pillars of economic, social and environmental[1]. Third-party auditors critically assess farmers against their requirements in these three areas before awarding certification.","The blue fish tick and fishery certification program is designed to contribute to the health of the world’s oceans by recognising and rewarding sustainable fishing practices, influencing the choices people make when buying seafood and working with partners to transform the seafood market to a sustainable basis."]
[null,"Commodities Covered","The commodities available under organics are abundant and include most whole fresh produce, alcohol, coffee, tea, edible flowers, wild crops, grains, meat, aquaculture and more",null,null,"A wide range of products from consumables.","All food ","A wide range of products from consumables.","Seafood"]
[null,"Barriers to entry","Low","High","Moderate","High","Range from low to High  ","High","High"]
[null,"Scope"]
[null,"Food safety",null,null,null,null,"ü"]
[null,"Sustainability",null,"ü","ü","ü",null,"ü","ü"]
[null,"Production / Process","ü","ü","ü","ü"]
[null,"Employment/Social",null,null,null,"ü",null,"ü"]
[null,"Benefits"]
[null,"Additional market Access","ü","ü","ü","ü","ü","ü"]
[null,"Premium Prices","ü","ü","ü","ü","ü","ü","ü"]
[null,"Upskilling Business Operation Capability","ü","ü",null,null,"ü","ü","ü"]

{"sheet":"Assessment","index":2,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,3,11,3],[6,3,8,3],[34,1,34,2],[18,1,18,2]]}
[]
[null,"Assessment"]
[]
[null,"What Does Your Business Look Like"]
[null,null,"Fill In Below "]
[null,"Country ","Fiji"]
[null,"Crops/Enterprises","Fruit & Vegetables","Note: If your crop type is not included in the list this does not mean your product is not suitable. Select a similar crop for the purposes of the tool"]
[null,"Classify your operation.","Grower Group"]
[null,"How long have you been operating (years)","2-5"]
[null,"Number of staff/workers","2-5"]
[null,"Do you have a business plan.","Yes",{"$f":"IF(C11=\"No\",\"We would advice you to develop a business plan using the Business Plan Tab\",\"\")","v":""}]
[null,"Is your business growing.","Slowly"]
[null,"Do you have advice on running your business.","No"]
[null,"Do you have a relationship with a processor / exporter.","No"]
[null,{"$f":"IF(OR(C6=\"Cook islands\",C6=\"Niue\",C6=\"Samoa\"),\"What is your current revenue ($NZD)\",IF(OR(C6=\"Federated States of Micronesia\",C6=\"Palau\",C6=\"Republic of Marshall Islands\",C6=\"Timor Leste\"),\"What is your current revenue ($USD)\",IF(C6=\"Fiji\",\"What is your current revenue ($FJD)\",IF(OR(C6=\"Nauru\",C6=\"Kiribati\",C6=\"Tuvalu\"),\"What is your current revenue ($AUSD)\",IF(C6=\"Papua New Guinea\",\"What is your current revenue ($PGK)\",IF(C6=\"Solomon Islands\",\"What is your current revenue ($SBD)\",IF(C6=\"Tonga\",\"What is your current revenue ($TOP)\",IF(C6=\"Vanuatu\",\"What is your current revenue ($VUV)\",IF(OR(C6=\"French Polynesia\",C6=\"New Caledonia\"),\"What is your current revenue ($F)\")))))))))","v":"What is your current revenue ($FJD)"},40000]
[null,"What proportion of your revenue is profit. ( %)",0.4]
[null,{"$f":"IF(OR(C8=\"Grower Group\",C8=\"Grower Group, Processor\",C8=\"Grower Group, Retailer\", C8=\"Grower Group, Exporter\", C8= \"Grower Group, Processor, Retailer\", C8=\"Grower Group, Processor, Retailer, Exporter\",C8=\"Grower Group, Processor, Exporter\", C8=\"Grower Group, Retailer, Exporter\"),\"How many farmers are part of your grower group?\", \"\")","v":"How many farmers are part of your grower group?"},30]
[]
[null,"What Your Business Looks Like Under a Certification Scheme"]
[null,null,"Fill In Below "]
[null,"Markets","Local Market"]
[null,"Chemical use","No"]
[null,"Employment practices","Formal Contracts"]
[null,"Does Your Operation Contribute To Sustainability/Social Good?","Yes"]
[null,"Are Potential Consumers Demanding Food Safety Requirements?","No"]
[null,"What premium are you expecting if certified (Food Saftey - HACCP) (%)","N/A"]
[null,"What premium are you expecting if certified (Food Saftey - Global Gap) (%)",0.3]
[null,"What premium are you expecting if certified (Rainforest Alliance) (%)",0.3]
[null,"What premium are you expecting if certified (Organic PGS) (%)",0.6]
[null,"What premium are you expecting if certified (Organic 3rd Party) (%)",0.5]
[null,"What premium are you expecting if certified (Sustainable Fisheries) (%)",0.1]
[null,"What premium are you expecting if certified (Fair Trade) (%)",0.5]
[null,"What change in production are you expecting? (%)",0.1]
[]
[null,"If you are unsure of the premium you might receive, the below can be used as a guide"]
[null,"Certification ","Premium Indication"]
[null,"Organic PGS","5-10%"]
[null,"Organic Individual","20-40%"]
[null,"Organic Grower Group","20-40%"]
[null,"Fair Trade","15-30%"]
[null,"Food Saftey (GlobalGAP)","15-30%"]
[null,"Food Safety (HACCP)","10-20%"]
[null,"Rainforest Alliance","15-30%"]
[null,"Sustainable Fisheries","20-40%"]

{"sheet":"Suitability","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[27,1,27,2]]}
[]
[]
[null,"Suitability"]
[]
[null,"With Certification Suitability","Organic PGS","Organic Individual (3rd Party)","Organic Grower Group (3rd party)","Fair Trade ","Food Saftey (HACCP) ","Food Saftey (Global Gap)","Rainforest Alliance","Sustainable Fisheries Marine Stewardship Council"]
[null,"Crops/Enterprises",{"$f":"IF(OR(Assessment!C7=\"Coffee\",Assessment!C7=\"Fruit & Vegetables\",Assessment!C7=\"Cocoa\",Assessment!C7=\"Vanilla\",Assessment!C7=\"Kava\",Assessment!C7=\"Wood\",Assessment!C7=\"Beauty\", Assessment!C7=\"Livestock\",Assessment!C7=\"Fish\", Assessment!C7= \"Aquaculture\"),\"Suitable Produce\",\"Produce Not Suitable\")","v":"Suitable Produce"},{"$f":"IF(OR(Assessment!C7=\"Coffee\",Assessment!C7=\"Fruit & Vegetables\",Assessment!C7=\"Cocoa\",Assessment!C7=\"Vanilla\",Assessment!C7=\"Herbs & Spices\",Assessment!C7=\"Ginger\", Assessment!C7=\"Coconut\", Assessment!C7=\"Sugar\", Assessment!C7=\"Palm Oil\", Assessment!C7=\"Tea\", Assessment!C7= \"Nuts\", Assessment!C7=\"Beauty\", Assessment!C7=\"Livestock\",Assessment!C7=\"Fish\", Assessment!C7= \"Aquaculture\"),\"Suitable Produce\",\"Produce Not Suitable\")","v":"Suitable Produce"},{"$f":"IF(OR(Assessment!C7=\"Coffee\",Assessment!C7=\"Fruit & Vegetables\",Assessment!C7=\"Cocoa\",Assessment!C7=\"Vanilla\",Assessment!C7=\"Herbs & Spices\",Assessment!C7=\"Ginger\", Assessment!C7=\"Coconut\", Assessment!C7=\"Sugar\", Assessment!C7=\"Palm Oil\", Assessment!C7=\"Tea\", Assessment!C7= \"Nuts\", Assessment!C7=\"Beauty\", Assessment!C7=\"Livestock\",Assessment!C7=\"Fish\", Assessment!C7= \"Aquaculture\"),\"Suitable Produce\",\"Produce Not Suitable\")","v":"Suitable Produce"},{"$f":"IF(OR(Assessment!C7=\"Coffee\",Assessment!C7=\"Coconut\",Assessment!C7=\"Cocoa\",Assessment!C7=\"Vanilla\",Assessment!C7=\"Sugar\",Assessment!C7=\"Ginger\"),\"Suitable Produce\",\"Produce Not Suitable\")","v":"Produce Not Suitable"},{"$f":"IF(OR(Assessment!C7=\"Coffee\",Assessment!C7=\"Fruit & Vegetables\",Assessment!C7=\"Cocoa\",Assessment!C7=\"Vanilla\",Assessment!C7=\"Kava\",Assessment!C7=\"Wood\",Assessment!C7=\"Beauty\", Assessment!C7=\"Livestock\",Assessment!C7=\"Fish\", Assessment!C7= \"Aquaculture\", Assessment!C7=\"Herbs & Spices\", Assessment!C7= \"Ginger\", Assessment!C7=\"Coconut\", Assessment!C7= \"Sugar\", Assessment!C7=\"Palm Oil\", Assessment!C7=\"Tea\", Assessment!C7=\"Nuts\"),\"Suitable Produce\",\"Produce Not Suitable\")","v":"Suitable Produce"},{"$f":"IF(OR(Assessment!C7=\"Coffee\",Assessment!C7=\"Fruit & Vegetables\",Assessment!C7=\"Cocoa\",Assessment!C7=\"Vanilla\",Assessment!C7=\"Kava\",Assessment!C7=\"Wood\",Assessment!C7=\"Beauty\", Assessment!C7=\"Livestock\",Assessment!C7=\"Fish\", Assessment!C7= \"Aquaculture\", Assessment!C7=\"Herbs & Spices\", Assessment!C7= \"Ginger\", Assessment!C7=\"Coconut\", Assessment!C7= \"Sugar\", Assessment!C7=\"Palm Oil\", Assessment!C7=\"Tea\", Assessment!C7=\"Nuts\"),\"Suitable Produce\",\"Produce Not Suitable\")","v":"Suitable Produce"},{"$f":"IF(OR(Assessment!C7=\"Coffee\", Assessment!C7=\"Fruit & Vegetables\", Assessment!C7=\"Cocoa\", Assessment!C7=\"Herbs & Spices\", Assessment!C7=\"Nuts\", Assessment!C7=\"Palm Oil\", Assessment!C7=\"Tea\"),\"Suitable Produce\",\"Produce Not Suitable\")","v":"Suitable Produce"},{"$f":"IF(OR(Assessment!C7=\"aquaculture\",Assessment!C7=\"fish\", Assessment!C7= \"Open Sea Fisheries\"),\"Suitable Produce\", \"Produce Not Suitable\")","v":"Produce Not Suitable"}]
[null,"Classify Your Operation",{"$f":"IF(OR(Assessment!C8=\"Sole Grower\",Assessment!C8=\"Processor\",Assessment!C8=\"Retailer\",Assessment!C8=\"Exporter\", Assessment!C8=\"Sole Grower, Processor\", Assessment!C8= \"Sole Grower, Retailer\", Assessment!C8= \"Sole Grower, Exporter\", Assessment!C8= \"Sole Grower, Processor, Retailer\", Assessment!C8= \"Soler Grower, Processor, Exporter\", Assessment!C8= \"Sole Grower, Retailer, Exporter\", Assessment!C8= \"Soler Grower, Processor, Retailer, Exporter\", Assessment!C8= \"Processor, Retailer\", Assessment!C8= \"Retailer, Exporter\", Assessment!C8= \"Processor, Retailer, Exporter\"), \"Suitable Operation\", \"Operation Not Suitable\")","v":"Operation Not Suitable"},{"$f":"IF(OR(Assessment!C8=\"Sole Grower\",Assessment!C8=\"Processor\",Assessment!C8=\"Retailer\",Assessment!C8=\"Exporter\", Assessment!C8=\"Sole Grower, Processor\", Assessment!C8= \"Sole Grower, Retailer\", Assessment!C8= \"Sole Grower, Exporter\", Assessment!C8= \"Sole Grower, Processor, Retailer\", Assessment!C8= \"Soler Grower, Processor, Exporter\", Assessment!C8= \"Sole Grower, Retailer, Exporter\", Assessment!C8= \"Soler Grower, Processor, Retailer, Exporter\", Assessment!C8= \"Processor, Retailer\", Assessment!C8= \"Retailer, Exporter\", Assessment!C8= \"Processor, Retailer, Exporter\"), \"Suitable Operation\", \"Operation Not Suitable\")","v":"Operation Not Suitable"},{"$f":"IF(OR(Assessment!C8=\"Grower Group\", Assessment!C8=\"Grower Group, Processor\", Assessment!C8=\"Grower Group, Retailer\", Assessment!C8=\"Grower Group, Exporter\", Assessment!C8=\"Grower Group, Processor, Retailer\", Assessment!C8=\"Grower Group, Processor, Exporter\", Assessment!C8=\"Grower Group, Processor, Retailer, Exporter\"), \"Suitable Operation\", \"Operation Not Suitable\")","v":"Suitable Operation"},{"$f":"IF(OR(Assessment!C8=\"Sole Grower\",Assessment!C8=\"Processor\",Assessment!C8=\"Retailer\",Assessment!C8=\"Exporter\", Assessment!C8=\"Sole Grower, Processor\", Assessment!C8= \"Sole Grower, Retailer\", Assessment!C8= \"Sole Grower, Exporter\", Assessment!C8= \"Sole Grower, Processor, Retailer\", Assessment!C8= \"Soler Grower, Processor, Exporter\", Assessment!C8= \"Sole Grower, Retailer, Exporter\", Assessment!C8= \"Soler Grower, Processor, Retailer, Exporter\", Assessment!C8= \"Processor, Retailer\", Assessment!C8= \"Retailer, Exporter\", Assessment!C8= \"Processor, Retailer, Exporter\"), \"Suitable Operation\", \"Operation Not Suitable\")","v":"Operation Not Suitable"},{"$f":"IF(OR(Assessment!C8=\"Sole Grower\",Assessment!C8=\"Processor\",Assessment!C8=\"Retailer\",Assessment!C8=\"Exporter\", Assessment!C8=\"Sole Grower, Processor\", Assessment!C8= \"Sole Grower, Retailer\", Assessment!C8= \"Sole Grower, Exporter\", Assessment!C8= \"Sole Grower, Processor, Retailer\", Assessment!C8= \"Soler Grower, Processor, Exporter\", Assessment!C8= \"Sole Grower, Retailer, Exporter\", Assessment!C8= \"Soler Grower, Processor, Retailer, Exporter\", Assessment!C8= \"Processor, Retailer\", Assessment!C8= \"Retailer, Exporter\", Assessment!C8= \"Processor, Retailer, Exporter\", Assessment!C8=\"Grower Group\", Assessment!C8=\"Grower Group, Processor\", Assessment!C8=\"Grower Group, Retailer\", Assessment!C8=\"Grower Group, Exporter\", Assessment!C8=\"Grower Group, Processor, Retailer\", Assessment!C8=\"Grower Group, Processor, Exporter\", Assessment!C8=\"Grower Group, Processor, Retailer, Exporter\"), \"Suitable Operation\", \"Operation Not Suitable\")","v":"Suitable Operation"},{"$f":"IF(OR(Assessment!C8=\"Sole Grower\",Assessment!C8=\"Processor\",Assessment!C8=\"Retailer\",Assessment!C8=\"Exporter\", Assessment!C8=\"Sole Grower, Processor\", Assessment!C8= \"Sole Grower, Retailer\", Assessment!C8= \"Sole Grower, Exporter\", Assessment!C8= \"Sole Grower, Processor, Retailer\", Assessment!C8= \"Soler Grower, Processor, Exporter\", Assessment!C8= \"Sole Grower, Retailer, Exporter\", Assessment!C8= \"Soler Grower, Processor, Retailer, Exporter\", Assessment!C8= \"Processor, Retailer\", Assessment!C8= \"Retailer, Exporter\", Assessment!C8= \"Processor, Retailer, Exporter\", Assessment!C8=\"Grower Group\", Assessment!C8=\"Grower Group, Processor\", Assessment!C8=\"Grower Group, Retailer\", Assessment!C8=\"Grower Group, Exporter\", Assessment!C8=\"Grower Group, Processor, Retailer\", Assessment!C8=\"Grower Group, Processor, Exporter\", Assessment!C8=\"Grower Group, Processor, Retailer, Exporter\"), \"Suitable Operation\", \"Operation Not Suitable\")","v":"Suitable Operation"},{"$f":"IF(OR(Assessment!C8=\"Sole Grower\",Assessment!C8=\"Processor\",Assessment!C8=\"Retailer\",Assessment!C8=\"Exporter\", Assessment!C8=\"Sole Grower, Processor\", Assessment!C8= \"Sole Grower, Retailer\", Assessment!C8= \"Sole Grower, Exporter\", Assessment!C8= \"Sole Grower, Processor, Retailer\", Assessment!C8= \"Soler Grower, Processor, Exporter\", Assessment!C8= \"Sole Grower, Retailer, Exporter\", Assessment!C8= \"Soler Grower, Processor, Retailer, Exporter\", Assessment!C8= \"Processor, Retailer\", Assessment!C8= \"Retailer, Exporter\", Assessment!C8= \"Processor, Retailer, Exporter\", Assessment!C8=\"Grower Group\", Assessment!C8=\"Grower Group, Processor\", Assessment!C8=\"Grower Group, Retailer\", Assessment!C8=\"Grower Group, Exporter\", Assessment!C8=\"Grower Group, Processor, Retailer\", Assessment!C8=\"Grower Group, Processor, Exporter\", Assessment!C8=\"Grower Group, Processor, Retailer, Exporter\"), \"Suitable Operation\", \"Operation Not Suitable\")","v":"Suitable Operation"},{"$f":"IF(OR(Assessment!C8=\"Sole Grower\",Assessment!C8=\"Processor\",Assessment!C8=\"Retailer\",Assessment!C8=\"Exporter\", Assessment!C8=\"Sole Grower, Processor\", Assessment!C8= \"Sole Grower, Retailer\", Assessment!C8= \"Sole Grower, Exporter\", Assessment!C8= \"Sole Grower, Processor, Retailer\", Assessment!C8= \"Soler Grower, Processor, Exporter\", Assessment!C8= \"Sole Grower, Retailer, Exporter\", Assessment!C8= \"Soler Grower, Processor, Retailer, Exporter\", Assessment!C8= \"Processor, Retailer\", Assessment!C8= \"Retailer, Exporter\", Assessment!C8= \"Processor, Retailer, Exporter\"), \"Suitable Operation\", \"Operation Not Suitable\")","v":"Operation Not Suitable"}]
[null,"Markets",{"$f":"IF(OR(Assessment!C21=\"Local\", Assessment!C21=\"Pacific Region\",Assessment!C21=\"Local, Pacific Region\"),\"Suitable Certification For Market\", \"Certification Not Suitable For Market\")","v":"Certification Not Suitable For Market"},{"$f":"IF(OR(Assessment!C21=\"Exporter\",Assessment!C21=\"Local Market, Pacfic Region, Exporter\", Assessment!C21=\"Local Market, Exporter\",Assessment!C21=\"Pacific Region, Exporter\"), \"Suitable Certification For Market\",\"Certification Not Suitable For Market\")","v":"Certification Not Suitable For Market"},{"$f":"IF(OR(Assessment!C21=\"Exporter\",Assessment!C21=\"Local Market, Pacfic Region, Exporter\", Assessment!C21=\"Local Market, Exporter\",Assessment!C21=\"Pacific Region, Exporter\"), \"Suitable Certification For Market\",\"Certification Not Suitable For Market\")","v":"Certification Not Suitable For Market"},{"$f":"IF(OR(Assessment!C21=\"Exporter\",Assessment!C21=\"Local Market, Pacfic Region, Exporter\", Assessment!C21=\"Local Market, Exporter\",Assessment!C21=\"Pacific Region, Exporter\"), \"Suitable Certification For Market\",\"Certification Not Suitable For Market\")","v":"Certification Not Suitable For Market"},{"$f":"IF(OR(Assessment!C21=\"Exporter\", Assessment!C21=\"Pacific Region\", Assessment!C21= \"Local Market, Exporter\", Assessment!C21= \"Pacific Region, Exporter\", Assessment!C21= \"Local Market, Pacific Region, Exporter\", Assessment!C21= \"Local Market, Pacific Region\", Assessment!C21= \"Pacific Region, Exporter\"),\"Suitable Certification For Market\", \"Certification Not Suitable For Market\")","v":"Certification Not Suitable For Market"},{"$f":"IF(OR(Assessment!C21=\"Exporter\",Assessment!C21=\"Local Market, Pacfic Region, Exporter\", Assessment!C21=\"Local Market, Exporter\",Assessment!C21=\"Pacific Region, Exporter\"), \"Suitable Certification For Market\",\"Certification Not Suitable For Market\")","v":"Certification Not Suitable For Market"},{"$f":"IF(OR(Assessment!C21=\"Exporter\",Assessment!C21=\"Local Market, Pacfic Region, Exporter\", Assessment!C21=\"Local Market, Exporter\",Assessment!C21=\"Pacific Region, Exporter\"), \"Suitable Certification For Market\",\"Certification Not Suitable For Market\")","v":"Certification Not Suitable For Market"},{"$f":"IF(OR(Assessment!C21=\"Exporter\",Assessment!C21=\"Local Market, Pacfic Region, Exporter\", Assessment!C21=\"Local Market, Exporter\",Assessment!C21=\"Pacific Region, Exporter\"), \"Suitable Certification For Market\",\"Certification Not Suitable For Market\")","v":"Certification Not Suitable For Market"}]
[null,"Chemical Use  (Based on Whether Chemicals are Used or Not)",{"$f":"IF(Assessment!C22=\"No\", \"Suitable\", \"Not Suitable\")","v":"Suitable"},{"$f":"IF(Assessment!C22=\"No\", \"Suitable\", \"Not Suitable\")","v":"Suitable"},{"$f":"IF(Assessment!C22=\"No\", \"Suitable\", \"Not Suitable Due to Chemical Use\")","v":"Suitable"},"Suitable - No Requirement","Suitable - No Requirement","Suitable - No Requirement","Suitable - No Requirement","Suitable - No Requirement"]
[null,"Social Responsibility / Employment Practices","Suitable - No Requirement","Suitable - No Requirement","Suitable - No Requirement",{"$f":"IF(OR(Assessment!C23=\"Formal Contracts\",Assessment!C23=\"Unpaid Family\")*AND(Assessment!C24=\"Yes\"),\"Suitable\",\"Not Suitable\")","v":"Suitable"},"Suitable - No Requirement","Suitable - No Requirement",{"$f":"IF(AND(Assessment!C23=\"Formal Contracts\", Assessment!C24=\"Yes\"),\"Suitable\",\"Not Suitable\")","v":"Suitable"},{"$f":"IF(Assessment!C23=\"Formal Contracts\",\"Suitable\",\"Not Suitable \")","v":"Suitable"}]
[null,"Food Safety Requirements","Suitable - No Requirement","Suitable - No Requirement","Suitable - No Requirement","Suitable - No Requirement",{"$f":"IF(Assessment!C25=\"Yes\", \"Suitable\", \"Not Suitable\")","v":"Not Suitable"},{"$f":"IF(Assessment!C25=\"Yes\", \"Suitable\", \"Not Suitable\")","v":"Not Suitable"},"Suitable - No Requirement","Suitable - No Requirement"]
[null,"Operational Suitability",{"$f":"IF(AND(C6=\"Suitable Produce\",C7=\"Suitable Operation\",C8=\"Suitable Certification For Market\",C9=\"Suitable\"),\"Suitable\",\"Not Completely Suitable\")","v":"Not Completely Suitable"},{"$f":"IF(AND(D6=\"Suitable Produce\",D7=\"Suitable Operation\",D8=\"Suitable Certification For Market\",D9=\"Suitable\"),\"Suitable\",\"Not Completely Suitable\")","v":"Not Completely Suitable"},{"$f":"IF(AND(E6=\"Suitable Produce\",E7=\"Suitable Operation\",E8=\"Suitable Certification For Market\",E9=\"Suitable\"),\"Suitable\",\"Not Completely Suitable\")","v":"Not Completely Suitable"},{"$f":"IF(AND(F6=\"Suitable Produce\",F7=\"Suitable Operation\",F8=\"Suitable Certification For Market\",F10=\"Suitable\"),\"Suitable\",\"Not Completely Suitable\")","v":"Not Completely Suitable"},{"$f":"IF(AND(G6=\"Suitable Produce\",G7=\"Suitable Operation\",G8=\"Suitable Certification For Market\",G11=\"Suitable\"),\"Suitable\",\"Not Completely Suitable\")","v":"Not Completely Suitable"},{"$f":"IF(AND(H6=\"Suitable Produce\",H7=\"Suitable Operation\",H8=\"Suitable Certification For Market\",H11=\"Suitable\"),\"Suitable\",\"Not Completely Suitable\")","v":"Not Completely Suitable"},{"$f":"IF(AND(I6=\"Suitable Produce\",I7=\"Suitable Operation\",I8=\"Suitable Certification For Market\",I10=\"Suitable\"),\"Suitable\",\"Not Completely Suitable\")","v":"Not Completely Suitable"},{"$f":"IF(AND(J6=\"Suitable Produce\",J7=\"Suitable Operation\",J8=\"Suitable Certification For Market\"),\"Suitable\",\"Not Completely Suitable\")","v":"Not Completely Suitable"}]
[null,"Estimated Profit with Certification",{"$f":"IF(Assessment!C29=\"N/A\",\"0\",(1+Assessment!C33)*(Assessment!C15*Assessment!C16)*(Assessment!C29+1))","v":28160},{"$f":"IF(Assessment!C30=\"N/A\",\"0\",(1+Assessment!C33)*(Assessment!C15*Assessment!C16)*(Assessment!C30+1))","v":26400},{"$f":"IF(Assessment!C30=\"N/A\",\"0\",(1+Assessment!C33)*(Assessment!C15*Assessment!C16)*(Assessment!C30+1))","v":26400},{"$f":"IF(Assessment!C32=\"N/A\",\"0\",(1+Assessment!C33)*(Assessment!C15*Assessment!C16)*(Assessment!C32+1))","v":26400},{"$f":"IF(Assessment!C26=\"N/A\",\"0\",(1+Assessment!C33)*(Assessment!C15*Assessment!C16)*(Assessment!C26+1))","v":"0"},{"$f":"IF(Assessment!C26=\"N/A\",\"0\",(1+Assessment!C33)*(Assessment!C15*Assessment!C16)*(Assessment!C27+1))","v":"0"},{"$f":"IF(Assessment!C28=\"N/A\",\"0\",(1+Assessment!C33)*(Assessment!C15*Assessment!C16)*(Assessment!C28+1))","v":22880},{"$f":"IF(Assessment!C31=\"N/A\",\"0\",(1+Assessment!C33)*(Assessment!C15*Assessment!C16)*(Assessment!C31+1))","v":19360}]
[null,"Estimated Increased Return with Certification",{"$f":"IF(C13=\"0\",\"0\",C13-(Assessment!$C$15*Assessment!$C$16))","v":12160},{"$f":"IF(D13=\"0\",\"0\",D13-(Assessment!$C$15*Assessment!$C$16))","v":10400},{"$f":"IF(E13=\"0\",\"0\",E13-(Assessment!$C$15*Assessment!$C$16))","v":10400},{"$f":"IF(F13=\"0\",\"0\",F13-(Assessment!$C$15*Assessment!$C$16))","v":10400},{"$f":"IF(G13=\"0\",\"0\",G13-(Assessment!$C$15*Assessment!$C$16))","v":"0"},{"$f":"IF(H13=\"0\",\"0\",H13-(Assessment!$C$15*Assessment!$C$16))","v":"0"},{"$f":"IF(I13=\"0\",\"0\",I13-(Assessment!$C$15*Assessment!$C$16))","v":6880},{"$f":"IF(J13=\"0\",\"0\",J13-(Assessment!$C$15*Assessment!$C$16))","v":3360}]
[null,"Estimated Cost of Certification - (Does not include any internal costs around maintaining certification)",{"$f":"IF(Assessment!C6=\"Cook Islands\",('Currency Conversion '!B17*'Currency Conversion '!B11),IF(Assessment!C6=\"Federated State of Micronesia\",('Currency Conversion '!B17*'Currency Conversion '!B2),IF(Assessment!C6=\"Fiji\",('Currency Conversion '!B17*'Currency Conversion '!B3),IF(Assessment!C6=\"Kiribati\",('Currency Conversion '!B17*'Currency Conversion '!B5),IF(Assessment!C6=\"Nauru\",('Currency Conversion '!B17*'Currency Conversion '!B6),IF(Assessment!C6=\"Niue\",('Currency Conversion '!B17*'Currency Conversion '!B11),IF(Assessment!C6=\"Palau\",('Currency Conversion '!B17*'Currency Conversion '!B2),IF(Assessment!C6=\"Papua New Guinea\",('Currency Conversion '!B17*'Currency Conversion '!B7),IF(Assessment!C6=\"Republic of Marshall Islands\",('Currency Conversion '!B17*'Currency Conversion '!B2),IF(Assessment!C6=\"Vanuatu\",('Currency Conversion '!B17*'Currency Conversion '!B10),IF(Assessment!C6=\"Samoa\",('Currency Conversion '!B17*'Currency Conversion '!B11),IF(Assessment!C6=\"Solomon Islands\",('Currency Conversion '!B17*'Currency Conversion '!B4),IF(Assessment!C6=\"Timor Leste\",('Currency Conversion '!B17*'Currency Conversion '!B2),IF(Assessment!C6=\"Tonga\",('Currency Conversion '!B17*'Currency Conversion '!B8),IF(Assessment!C6=\"Tuvalu\",('Currency Conversion '!B17*'Currency Conversion '!B9),IF(Assessment!C6=\"French Polynesia\",('Currency Conversion '!B17*'Currency Conversion '!B12),IF(Assessment!C6=\"New Caledonia\",('Currency Conversion '!B17*'Currency Conversion '!B12))))))))))))))))))","v":0},{"$f":"IF(Assessment!C6=\"Cook Islands\",('Currency Conversion '!B18*'Currency Conversion '!B11),IF(Assessment!C6=\"Federated State of Micronesia\",('Currency Conversion '!B18*'Currency Conversion '!B2),IF(Assessment!C6=\"Fiji\",('Currency Conversion '!B18*'Currency Conversion '!B3),IF(Assessment!C6=\"Kiribati\",('Currency Conversion '!B18*'Currency Conversion '!B6),IF(Assessment!C6=\"Nauru\",('Currency Conversion '!B18*'Currency Conversion '!B6),IF(Assessment!C6=\"Niue\",('Currency Conversion '!B18*'Currency Conversion '!B11),IF(Assessment!C6=\"Palau\",('Currency Conversion '!B18*'Currency Conversion '!B2),IF(Assessment!C6=\"Papua New Guinea\",('Currency Conversion '!B18*'Currency Conversion '!B7),IF(Assessment!C6=\"Republic of Marshall Islands\",('Currency Conversion '!B18*'Currency Conversion '!B2),IF(Assessment!C6=\"Vanuatu\",('Currency Conversion '!B18*'Currency Conversion '!B10),IF(Assessment!C6=\"Samoa\",('Currency Conversion '!B18*'Currency Conversion '!B11),IF(Assessment!C6=\"Solomon Islands\",('Currency Conversion '!B18*'Currency Conversion '!B4),IF(Assessment!C6=\"Timor Leste\",('Currency Conversion '!B18*'Currency Conversion '!B2),IF(Assessment!C6=\"Tonga\",('Currency Conversion '!B18*'Currency Conversion '!B8),IF(Assessment!C6=\"Tuvalu\",('Currency Conversion '!B18*'Currency Conversion '!B6),IF(Assessment!C6=\"French Polynesia\",('Currency Conversion '!B18*'Currency Conversion '!B12),IF(Assessment!C6=\"New Caledonia\",('Currency Conversion '!B18*'Currency Conversion '!B12))))))))))))))))))","v":6800.0000000000009},{"$f":"E16*Assessment!C17","v":20114.400000000001},{"$f":"IF(Assessment!C6=\"Cook Islands\",('Currency Conversion '!B16*'Currency Conversion '!B11),IF(Assessment!C6=\"Federated State of Micronesia\",('Currency Conversion '!B16*'Currency Conversion '!B2),IF(Assessment!C6=\"Fiji\",('Currency Conversion '!B16*'Currency Conversion '!B3),IF(Assessment!C6=\"Kiribati\",('Currency Conversion '!B16*'Currency Conversion '!B6),IF(Assessment!C6=\"Nauru\",('Currency Conversion '!B16*'Currency Conversion '!B6),IF(Assessment!C6=\"Niue\",('Currency Conversion '!B16*'Currency Conversion '!B11),IF(Assessment!C6=\"Palau\",('Currency Conversion '!B16*'Currency Conversion '!B2),IF(Assessment!C6=\"Papua New Guinea\",('Currency Conversion '!B16*'Currency Conversion '!B7),IF(Assessment!C6=\"Republic of Marshall Islands\",('Currency Conversion '!B16*'Currency Conversion '!B2),IF(Assessment!C6=\"Vanuatu\",('Currency Conversion '!B16*'Currency Conversion '!B10),IF(Assessment!C6=\"Samoa\",('Currency Conversion '!B16*'Currency Conversion '!B11),IF(Assessment!C6=\"Solomon Islands\",('Currency Conversion '!B16*'Currency Conversion '!B4),IF(Assessment!C6=\"Timor Leste\",('Currency Conversion '!B16*'Currency Conversion '!B2),IF(Assessment!C6=\"Tonga\",('Currency Conversion '!B16*'Currency Conversion '!B8),IF(Assessment!C6=\"Tuvalu\",('Currency Conversion '!B16*'Currency Conversion '!B6),IF(Assessment!C6=\"French Polynesia\",('Currency Conversion '!B16*'Currency Conversion '!B12),IF(Assessment!C6=\"New Caledonia\",('Currency Conversion '!B16*'Currency Conversion '!B12))))))))))))))))))","v":4760},{"$f":"IF(Assessment!C6=\"Cook Islands\",('Currency Conversion '!B21*'Currency Conversion '!B11),IF(Assessment!C6=\"Federated State of Micronesia\",('Currency Conversion '!B21*'Currency Conversion '!B2),IF(Assessment!C6=\"Fiji\",('Currency Conversion '!B21*'Currency Conversion '!B3),IF(Assessment!C6=\"Kiribati\",('Currency Conversion '!B21*'Currency Conversion '!B6),IF(Assessment!C6=\"Nauru\",('Currency Conversion '!B21*'Currency Conversion '!B6),IF(Assessment!C6=\"Niue\",('Currency Conversion '!B21*'Currency Conversion '!B11),IF(Assessment!C6=\"Palau\",('Currency Conversion '!B21*'Currency Conversion '!B2),IF(Assessment!C6=\"Papua New Guinea\",('Currency Conversion '!B21*'Currency Conversion '!B7),IF(Assessment!C6=\"Republic of Marshall Islands\",('Currency Conversion '!B21*'Currency Conversion '!B2),IF(Assessment!C6=\"Vanuatu\",('Currency Conversion '!B21*'Currency Conversion '!B10),IF(Assessment!C6=\"Samoa\",('Currency Conversion '!B21*'Currency Conversion '!B11),IF(Assessment!C6=\"Solomon Islands\",('Currency Conversion '!B21*'Currency Conversion '!B4),IF(Assessment!C6=\"Timor Leste\",('Currency Conversion '!B21*'Currency Conversion '!B2),IF(Assessment!C6=\"Tonga\",('Currency Conversion '!B21*'Currency Conversion '!B8),IF(Assessment!C6=\"Tuvalu\",('Currency Conversion '!B21*'Currency Conversion '!B6),IF(Assessment!C6=\"French Polynesia\",('Currency Conversion '!B21*'Currency Conversion '!B12),IF(Assessment!C6=\"New Caledonia\",('Currency Conversion '!B21*'Currency Conversion '!B12))))))))))))))))))","v":1360},{"$f":"IF(Assessment!C6=\"Cook Islands\",('Currency Conversion '!B23*'Currency Conversion '!B11),IF(Assessment!C6=\"Federated State of Micronesia\",('Currency Conversion '!B23*'Currency Conversion '!B2),IF(Assessment!C6=\"Fiji\",('Currency Conversion '!B23*'Currency Conversion '!B3),IF(Assessment!C6=\"Kiribati\",('Currency Conversion '!B23*'Currency Conversion '!B6),IF(Assessment!C6=\"Nauru\",('Currency Conversion '!B23*'Currency Conversion '!B6),IF(Assessment!C6=\"Niue\",('Currency Conversion '!B23*'Currency Conversion '!B11),IF(Assessment!C6=\"Palau\",('Currency Conversion '!B23*'Currency Conversion '!B2),IF(Assessment!C6=\"Papua New Guinea\",('Currency Conversion '!B23*'Currency Conversion '!B7),IF(Assessment!C6=\"Republic of Marshall Islands\",('Currency Conversion '!B23*'Currency Conversion '!B2),IF(Assessment!C6=\"Vanuatu\",('Currency Conversion '!B23*'Currency Conversion '!B10),IF(Assessment!C6=\"Samoa\",('Currency Conversion '!B23*'Currency Conversion '!B11),IF(Assessment!C6=\"Solomon Islands\",('Currency Conversion '!B23*'Currency Conversion '!B4),IF(Assessment!C6=\"Timor Leste\",('Currency Conversion '!B23*'Currency Conversion '!B2),IF(Assessment!C6=\"Tonga\",('Currency Conversion '!B23*'Currency Conversion '!B8),IF(Assessment!C6=\"Tuvalu\",('Currency Conversion '!B23*'Currency Conversion '!B6),IF(Assessment!C6=\"French Polynesia\",('Currency Conversion '!B23*'Currency Conversion '!B12),IF(Assessment!C6=\"New Caledonia\",('Currency Conversion '!B23*'Currency Conversion '!B12))))))))))))))))))","v":5032},{"$f":"IF(Assessment!C6=\"Cook Islands\",('Currency Conversion '!B20*'Currency Conversion '!B11),IF(Assessment!C6=\"Federated State of Micronesia\",('Currency Conversion '!B20*'Currency Conversion '!B2),IF(Assessment!C6=\"Fiji\",('Currency Conversion '!B20*'Currency Conversion '!B3),IF(Assessment!C6=\"Kiribati\",('Currency Conversion '!B20*'Currency Conversion '!B6),IF(Assessment!C6=\"Nauru\",('Currency Conversion '!B20*'Currency Conversion '!B6),IF(Assessment!C6=\"Niue\",('Currency Conversion '!B20*'Currency Conversion '!B11),IF(Assessment!C6=\"Palau\",('Currency Conversion '!B20*'Currency Conversion '!B2),IF(Assessment!C6=\"Papua New Guinea\",('Currency Conversion '!B20*'Currency Conversion '!B7),IF(Assessment!C6=\"Republic of Marshall Islands\",('Currency Conversion '!B20*'Currency Conversion '!B2),IF(Assessment!C6=\"Vanuatu\",('Currency Conversion '!B20*'Currency Conversion '!B10),IF(Assessment!C6=\"Samoa\",('Currency Conversion '!B20*'Currency Conversion '!B11),IF(Assessment!C6=\"Solomon Islands\",('Currency Conversion '!B20*'Currency Conversion '!B4),IF(Assessment!C6=\"Timor Leste\",('Currency Conversion '!B20*'Currency Conversion '!B2),IF(Assessment!C6=\"Tonga\",('Currency Conversion '!B20*'Currency Conversion '!B8),IF(Assessment!C6=\"Tuvalu\",('Currency Conversion '!B20*'Currency Conversion '!B6),IF(Assessment!C6=\"French Polynesia\",('Currency Conversion '!B20*'Currency Conversion '!B12),IF(Assessment!C6=\"New Caledonia\",('Currency Conversion '!B20*'Currency Conversion '!B12))))))))))))))))))","v":8160.0000000000009},{"$f":"IF(Assessment!C6=\"Cook Islands\",('Currency Conversion '!B22*'Currency Conversion '!B11),IF(Assessment!C6=\"Federated State of Micronesia\",('Currency Conversion '!B22*'Currency Conversion '!B2),IF(Assessment!C6=\"Fiji\",('Currency Conversion '!B22*'Currency Conversion '!B3),IF(Assessment!C6=\"Kiribati\",('Currency Conversion '!B22*'Currency Conversion '!B6),IF(Assessment!C6=\"Nauru\",('Currency Conversion '!B22*'Currency Conversion '!B6),IF(Assessment!C6=\"Niue\",('Currency Conversion '!B22*'Currency Conversion '!B11),IF(Assessment!C6=\"Palau\",('Currency Conversion '!B22*'Currency Conversion '!B2),IF(Assessment!C6=\"Papua New Guinea\",('Currency Conversion '!B22*'Currency Conversion '!B7),IF(Assessment!C6=\"Republic of Marshall Islands\",('Currency Conversion '!B22*'Currency Conversion '!B2),IF(Assessment!C6=\"Vanuatu\",('Currency Conversion '!B22*'Currency Conversion '!B10),IF(Assessment!C6=\"Samoa\",('Currency Conversion '!B22*'Currency Conversion '!B11),IF(Assessment!C6=\"Solomon Islands\",('Currency Conversion '!B22*'Currency Conversion '!B4),IF(Assessment!C6=\"Timor Leste\",('Currency Conversion '!B22*'Currency Conversion '!B2),IF(Assessment!C6=\"Tonga\",('Currency Conversion '!B22*'Currency Conversion '!B8),IF(Assessment!C6=\"Tuvalu\",('Currency Conversion '!B22*'Currency Conversion '!B6),IF(Assessment!C6=\"French Polynesia\",('Currency Conversion '!B22*'Currency Conversion '!B12),IF(Assessment!C6=\"New Caledonia\",('Currency Conversion '!B22*'Currency Conversion '!B12))))))))))))))))))","v":35360}]
[null,"Estimated Cost Per Group Individual (Grower Group only)",null,null,{"$f":"IF(Assessment!C6=\"Cook Islands\",('Currency Conversion '!B19*'Currency Conversion '!B11),IF(Assessment!C6=\"Federated State of Micronesia\",('Currency Conversion '!B19*'Currency Conversion '!B2),IF(Assessment!C6=\"Fiji\",('Currency Conversion '!B19*'Currency Conversion '!B3),IF(Assessment!C6=\"Kiribati\",('Currency Conversion '!B19*'Currency Conversion '!B6),IF(Assessment!C6=\"Nauru\",('Currency Conversion '!B19*'Currency Conversion '!B6),IF(Assessment!C6=\"Niue\",('Currency Conversion '!B19*'Currency Conversion '!B11),IF(Assessment!C6=\"Palau\",('Currency Conversion '!B19*'Currency Conversion '!B2),IF(Assessment!C6=\"Papua New Guinea\",('Currency Conversion '!B19*'Currency Conversion '!B7),IF(Assessment!C6=\"Republic of Marshall Islands\",('Currency Conversion '!B19*'Currency Conversion '!B2),IF(Assessment!C6=\"Vanuatu\",('Currency Conversion '!B19*'Currency Conversion '!B10),IF(Assessment!C6=\"Samoa\",('Currency Conversion '!B19*'Currency Conversion '!B11),IF(Assessment!C6=\"Solomon Islands\",('Currency Conversion '!B19*'Currency Conversion '!B4),IF(Assessment!C6=\"Timor Leste\",('Currency Conversion '!B19*'Currency Conversion '!B2),IF(Assessment!C6=\"Tonga\",('Currency Conversion '!B19*'Currency Conversion '!B8),IF(Assessment!C6=\"Tuvalu\",('Currency Conversion '!B19*'Currency Conversion '!B6),IF(Assessment!C6=\"French Polynesia\",('Currency Conversion '!B19*'Currency Conversion '!B12),IF(Assessment!C6=\"New Caledonia\",('Currency Conversion '!B19*'Currency Conversion '!B12))))))))))))))))))","v":670.48},{"$f":"IF(Assessment!$B$17=\"How many farmers are part of your grower group?\",(Suitability!F15/Assessment!$C$17),\"\")","v":158.66666666666666},{"$f":"IF(Assessment!$B$17=\"How many farmers are part of your grower group?\",(Suitability!G15/Assessment!$C$17),\"\")","v":45.333333333333336},{"$f":"IF(Assessment!$B$17=\"How many farmers are part of your grower group?\",(Suitability!H15/Assessment!$C$17),\"\")","v":167.73333333333332},{"$f":"IF(Assessment!$B$17=\"How many farmers are part of your grower group?\",(Suitability!I15/Assessment!$C$17),\"\")","v":272.00000000000006}]
[null,"Estimated Profit Gain from Certification For Individual Farm",{"$f":"C14-C15","v":12160},{"$f":"D14-D15","v":3599.9999999999991},{"$f":"IF(E16=\"\",0,E14-E16)","v":9729.52},{"$f":"IF(F16=\"\",F14-F15,F14-F16)","v":10241.333333333334},{"$f":"IF(G16=\"\",G14-G15,G14-G16)","v":-45.333333333333336},{"$f":"IF(H16=\"\",H14-H15,H14-H16)","v":-167.73333333333332},{"$f":"IF(I16=\"\",I14-I15,I14-I16)","v":6608},{"$f":"J14-J15","v":-32000}]

{"sheet":"Decision Finder","index":4,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[13,1,13,2],[23,1,23,5],[3,5,4,5],[3,4,4,4]]}
[]
[null,"Decision Finder"]
[]
[null,"Operational Suitability",null,null,"Overall Assessment","The following certification can be deemed to be likely suitable for your business given the information provided:"]
[null,"Organic 3rd Party Individual ",{"$f":"Suitability!D12","v":"Not Completely Suitable"}]
[null,"Organic 3rd Party Group",{"$f":"Suitability!E12","v":"Not Completely Suitable"},null,"Organic 3rd Party Individual ",{"$f":"IF(AND(C5=\"Suitable\",C15>0),\"Suitable and Beneficial\",\"Not Suitable or Beneficial\")","v":"Not Suitable or Beneficial"}]
[null,"Organic PGS",{"$f":"Suitability!C12","v":"Not Completely Suitable"},null,"Organic 3rd Party Group","Not Suitable or Beneficial"]
[null,"Fair Trade ",{"$f":"Suitability!F12","v":"Not Completely Suitable"},null,"Organic PGS","Not Suitable or Beneficial"]
[null,"Rainforest Alliance",{"$f":"Suitability!I12","v":"Not Completely Suitable"},null,"Fair Trade","Not Suitable or Beneficial"]
[null,"Food Saftey (HACCP)",{"$f":"Suitability!G12","v":"Not Completely Suitable"},null,"Rainforest Alliance","Not Suitable or Beneficial"]
[null,"Food Saftey (GlobalGAP)",{"$f":"Suitability!H12","v":"Not Completely Suitable"},null,"Food Saftey (HACCP)","Not Suitable or Beneficial"]
[null,"Sustainable Fisheries",{"$f":"Suitability!J12","v":"Not Completely Suitable"},null,"Food Saftey (GlobalGAP)","Not Suitable or Beneficial"]
[null,null,null,null,"Sustainable Fisheries","Not Suitable or Beneficial"]
[null,"Estimated Profit Gain from Certification"]
[null,"Organic 3rd Party Individual ",{"$f":"Suitability!D17","v":3599.9999999999991}]
[null,"Organic 3rd Party Group",{"$f":"Suitability!E17","v":9729.52}]
[null,"Organic PGS",{"$f":"Suitability!C17","v":12160}]
[null,"Fair Trade ",{"$f":"Suitability!F17","v":10241.333333333334}]
[null,"Rainforest Alliance",{"$f":"Suitability!I17","v":6608}]
[null,"Food Saftey (HACCP)",{"$f":"Suitability!G17","v":-45.333333333333336}]
[null,"Food Saftey (GlobalGAP)",{"$f":"Suitability!H17","v":-167.73333333333332}]
[null,"Sustainable Fisheries",{"$f":"Suitability!J17","v":-32000}]
[]
[null,"***We note that this does not account for any internal costs of maintaining certification**** - A table that will allow you to calculate the internal cost is in the Business Planning Tab"]

{"sheet":"Relevant Resources","index":5,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,12],[9,1,9,12],[15,1,15,12],[21,1,21,12],[27,1,27,12],[3,1,3,12]]}
[]
[null,"Relevant Resources "]
[]
[null,"Food Safety"]
[null,"Regional framework for action on food safety in the Western Pacific (who.int)"]
[null,"https://phamaplus.com.au/media/food-safety-certification-a-prerequisite-for-trade/"]
[null,"https://www.globalgap.org/"]
[null,"What is HACCP? | Is It Required for Food Safety Programs? | AIFS"]
[]
[null,"Organic"]
[null,"https://ifoam.bio/"]
[null,"POETCOM"]
[null,"Pacific Organic Standard"]
[]
[]
[null,"Fair Trade"]
[null,"https://www.fairtrade.net/"]
[null,"FlowCert"]
[]
[]
[]
[null,"Rainforest Alliance"]
[null,"https://www.rainforest-alliance.org/why-certification/"]
[]
[]
[]
[]
[null,"Marine Stewardship Council"]
[null,"What is sustainable fishing | Marine Stewardship Council (msc.org)"]

{"sheet":"Business Plan","index":6,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,5,36,5],[35,6,36,6],[4,3,4,8],[1,3,1,8],[34,3,34,8],[2,3,2,8],[3,3,3,8],[33,3,33,8],[46,1,66,1],[5,1,14,1],[21,1,30,1],[33,1,43,1],[35,4,36,4]]}
[]
[null,"Business Plan"]
[]
[null," Mission Statement ",null,"Operating Budget"]
[null,"The mission statement can include: the purpose for which the company exists; what the company does; the company's goals; quality; its role in the community; ethical practices; profitability; customers; shareholders; the environment. It is extremely important because everything the business does in the future must be consistent and in compliance with its content.",null,"Having a budget for your operation is a great way to plan and track the financial performance of your business. By creating a budget, you’re also generating an accurate, real-world view of how your year will pan out financially. Of course, things can and will change, but it gives you some key markers to hit over the next period, as well as a checklist to measure your farm’s financial progress against.When used as part of the assessment tool creating an operating budget is invaluable to assist assessment of whether or how much profit will be made to justify te cost of certification which can drive the choice of which is the best certification scheme."]
[null,null,null,"An example of a simple five year budget is shown below."]
[null,null,null," "]
[null,null,null,"Description","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,null,"Revenue"]
[null,null,null,"Yield"]
[null,null,null,"Price"]
[null,null,null,"Gross Sales"]
[null,null,null,"Fixed Costs"]
[null,null,null,"Land/ rent"]
[null,null,null,"Buildings"]
[null,null,null,"Machinery"]
[null,"Business Goals",null,"Administration"]
[null,"Business goals should be broken down to reflect the important aspects of the short (the first or start up years)  medium ( year 3 – 5 ) and long term ( 5 years plus, where you want to get to) goals of the business to allow the owners to concentrate on the things that they must do to ensure that the business is successful in the long term. ",null,"Certification"]
[null,"Business goals should be Specific, Measurable, Achievable, Realistic and Time bound to be effective. An example: Lift the yield of coffee production to XX kg per tree by the end of 2025.",null,"Fixed Cost Total"]
[null,null,null,"Variable Costs"]
[null,"Short Term Goals",null,"Labour"]
[null,null,null,"Planting"]
[null,null,null,"Weed control"]
[null,null,null,"Fertiliser"]
[null,null,null,"Pest Control"]
[null,null,null,"Harvesting"]
[null,null,null,"Marketing"]
[null,null,null,"Quality Control"]
[null,null,null,"Variable Costs Total"]
[null,null,null,"Total Costs"]
[null,null,null,"Returns"]
[]
[null,"Medium Term Goals"]
[null,null,null,"Internal Costs of Certification"]
[null,null,null,"This should allow you to calculate the internal costs of certification based on estimating the amount of time spent on the corresponding tasks associated with certification"]
[null,null,null,null,"Time Spent (hours)","Hourly \nRate","Total \nCosts"]
[null,null,null,"Internal Costs"]
[null,null,null,"Preparation for Certification Registration "]
[null,null,null,"Internal Coordination with Standards"]
[null,null,null,"Internal Training "]
[null,null,null,"Audit Preparation"]
[null,null,null,"Audit Process"]
[null,null,null,"Maintaining Internal processes"]
[null,null,null,"Record Keeping and Administration "]
[null,null,null,"Other"]
[null,"Long Term Goals",null,"Total Internal Costs"]

{"sheet":"Currency Conversion ","index":7,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,"2 year average"]
["NZD to USD",0.62]
["NZD to FJD",1.36]
["NZD to SBD",5.14]
["NZD to KID"]
["NZD to AUSD",0.93]
["NZD to PGK",2.29]
["NZD to TOP",1.44]
["NZD to TVD",0.91]
["NZD to VUV",72.33]
["NZD to NZD ",1]
["NZD to FRANC",66.84]
[]
["Cost of Certifications"]
["Fair Trade Individual ",3500,null,"Calculated using FLO"]
["Fair Trade Certification (small scale organisation group)",3500,null,{"$f":"D15","v":"Calculated using FLO"}]
["Organic PGS",0,null,"No fee charged by POETCOM"]
["Organic Individual (3rd Party)",5000]
["Organic Grower Group (3rd party)",493,null,"Costs outline in https://orgprints.org/id/eprint/35159/7/fibl-2019-ics.pdf. Inflation was added and the figure adjusted slightly for additional smaller groups and inflation"]
["Rainforest Alliance",6000,null,"Based on a case study that outlined the cost was approximately $156 per ha plus audit costs which range from $1000-$5000 (https://www.coffeehabitat.com/2011/04/cost-of-eco-certification/)"]
["Food Saftey (HACCP)",1000,null,"Based on average costs for HACCP "]
["Sustainable Fisheries Marine Stewardship Council",26000,null,"Based on the range of costings assuming that the pacific organisations operations are low in complexity"]
["Food Saftey (Global Gap)",3700]