{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["AnnexG","AnnexH","Annex XXX - 2","AnnexI","Annex J","Annex K","HIDE Drop Downs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"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":"AnnexG","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,1],[4,0,5,1],[7,0,7,1],[9,0,9,1],[18,0,18,1],[27,0,27,1],[6,0,6,1]]}
["Annex G: Table of Ingredients, Materials, and Suppliers"]
[]
["Instructions:"]
["1. Manufacturers must list all excipients in descending order (by weight).  "]
["2. For each material, manufacturers must provide a) the name of the material supplier, b) the name of the plant from which the materials will be sourced, and c) the address of the plant from which the material will be sourced."]
[]
["3. Please complete one table per product (eg. Annex I for 200,000 IU 500 ct; Annex I for 100,000 IU 100 ct etc.)"]
["Type of Product (eg. 100,000 IU 100 count bottle):"]
["Material","Name of Supplier; Plant Name; Plant Address"]
["1) Capsule Shell (gelatin, colouring agent, etc.)"]
["  "]
[]
[]
[]
[]
[]
[]
[]
["2) Capsule Fill (type of oil, vitamin A/E, etc.)"]
[]
[]
[]
[]
[]
[]
[]
[]
["3) Primary Packaging (bottles, dessicant, etc.)"]
[]
[]
[]
[]
[]
[]
[]
[]
["4) Secondary Packaging (boxes, pallets etc.)"]

{"sheet":"AnnexH","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,0,27,0],[0,0,0,5],[20,0,22,0],[10,0,14,0],[15,0,19,0],[4,0,5,5],[7,0,9,0],[7,1,9,1],[7,2,8,3],[7,4,9,4],[3,0,3,7]]}
["Annex H - Pricing Table + Lead Time"]
[]
["Instructions:"]
["1.Manufacturers must provide cost per bottle for capsules in CAD.  "]
["2. Should proponents determine that a number of bottles other than the ranges specified below in the \"Annual Quantity (Bottles)\" would result in a preferable pricing scheme, in addition to this table, proponents are welcome to submit a second table specifying these alternative ranges. "]
[]
["PRICING TABLE"]
["Product","Bottle Size (Capsules)","Range - Annual Quantity (Bottles)",null,"DAP\nLead Time (Weeks)","Unit Price per Bottle","Insurance Price per Bottle"]
[null,null,null,null,null,"1 Year","1 year","2 Year LTA"]
[null,null,"Lower Range","Upper Range",null,"CAD","CAD","CAD"]
["100,000 IU  Vitamin A OLP (USP) as Soft Gelatin Capsules","100 count",0,250000]
[null,null,{"$f":"D11","v":250000},500000]
[null,null,{"$f":"D12","v":500000},750000]
[null,null,{"$f":"D13","v":750000},1000000]
[null,null,"1,000,000+"]
["100,000 IU  Vitamin A OLP (USP) as Soft Gelatin Capsules","500 count",0,50000]
[null,null,{"$f":"D16","v":50000},100000]
[null,null,{"$f":"D17","v":100000},150000]
[null,null,{"$f":"D18","v":150000},200000]
[null,null,"200,000+"]
["200,000 IU Vitamin A OLP (USP) as Soft Gelatin Capsules","100 count",0,50000]
[null,null,{"$f":"D21","v":50000},"100,000+"]
[]
["200,000 IU Vitamin A OLP (USP) as Soft Gelatin Capsules","500 count",0,150000]
[null,null,{"$f":"D24","v":150000},300000]
[null,null,{"$f":"D25","v":300000},450000]
[null,null,{"$f":"D26","v":450000},600000]
[null,null,"600,000+"]
[]
[]
[null,null,"USD"]
[null,null,"EUR"]

{"sheet":"Annex XXX - 2","index":2,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":true,"merged":[[5,0,5,6],[6,2,6,4],[6,0,7,0],[6,1,7,1],[6,5,7,5],[6,6,7,6]]}
["Annex XXX-2: Delivery Schedule"]
[]
["Instructions:"]
[]
[]
["DELIVERY SCHEDULE"]
["Shipment #","Container #","Expected Quantity to be Shipped (Bottles)",null,null,"Expected Shipping Date from Manufacturer (DD/MM/YYYY)","Expected Arrival Date at DAP Point (DD/MM/YYYY)"]
[null,null,"100,000 iu","200,000 iu","50,000 iu"]
[1]
[{"$f":"A9+1","v":2}]
[{"$f":"A10+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[" "]

{"sheet":"AnnexI","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,8,6],[10,5,10,10],[10,0,10,4],[11,0,11,4],[11,5,11,10]]}
["Annex I: Delivery Schedule"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"\nJuly-Sept","\nOct-Dec","\nJan-Mar","\nApr-June"]
[null,null,null,null,null,null,null,"Q3","Q4","Q1","Q2"]
[null,null,null,null,null,"Proposed Delivery Schedule"]
["Expected Quantity to be Shipped (Bottles)"]
["Year ","100,000 IU","100,000 IU ","200,000 IU","200,000 IU","Shipment #","Container #"]
[null,"100 count bottle","500 count bottle","100 count bottle","500 count bottle"]
[1,"approx 0.8 M",null,null,"approx 0.7 M",1]
[null,null,null,null,null,{"$f":"F15+1","v":2}]
[null,null,null,null,null,3]
[null,null,null,null,null,4]
[null,null,null,null,null,5]
[null,null,null,null,null,6]
[null,null,null,null,null,7]
[null,null,null,null,null,8]
[]
[2]

{"sheet":"Annex J","index":4,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,2,5,2],[3,0,3,5],[4,0,5,0],[4,1,5,1],[4,3,4,5],[4,6,5,6]]}
["Annex J: Risk Assessment Register"]
["Instructions:"]
["Please complete this Risk Assessment Register to identify the risks associated with sourcing,manufacturing,supplying, and managing the Vitamin A Soft Gelatin Capsule product. Please identify as many risks as possible related to each category type."]
["RISK  REGISTER",null,null,null,null,null,"DATE LAST UPDATED: "]
["No.","RISK IDENTIFICATION","Risk Category","RISK RATING (P x I) ",null,null,"RISK IMPACT","RISK RESPONSE","RISK ACTION","RISK OWNER"]
[null,null,null,"Probability","Incidence","Score"]
[null,"(Identify as many risks as you can related to each category)","(Pick a category from the Dropdown Menu)","1-Least likely to happen\n5-Almost likely to happen","Incidence Threat :\n1 - Insignificant (Problem handled by day-to-day process)\n2 - Minor (Some disruption possible) \n3 - Moderate (Significant time, resources required) \n4 - Major (Operations severely affected) \n5 - Catastrophic Business survival is at risk ",null,null,null,"Agreed actions to minimize probability of risk from occurring or to minimize consequences should the risk occur","Risk owner is the individual who has the most impact over its result. Choosing the risk owner thus usually includes considering the source of risk and determining the individual/group who is best placed to comprehend and apply what needs to be done. \n\nRisk action plan owners are held responsible for managing the risk through the agreed plan and have the authority to make sure tasks are completed or take the action required.\n"]
[1,null,null,null,null,{"$f":"D8*E8","v":0}]
[2,null,null,null,null,0]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,{"$f":"D17*E17","v":0}]
[]
[null,null,null,"Categories of Risk"]
[]
[null,null,null,"Strategic/Commmercial Risk- This allows you to look at external risks, which may affect your organisation such as changes in the environment in which you operate.  It also lets you look at setting organisational objectives and ensuring you set the right ones and then meet them."]
[null,null,null,"Operational/Technical Risk - This looks at the risks, which arise from the services you deliver or the activities you carry out."]
[null,null,null,"Economic/Financial/Market Risk - This covers risks facing the organisation in terms of internal systems, planning, funding, org viability, etc."]
[null,null,null,"Organizational/management/human risk- Review risks associated with both the employment of staff, potential management liabilities, and the involvement of volunteers."]
[null,null,null,"Legal and regulatory risk - This category looks at the legislative framework within which your organisation operates."]

{"sheet":"Annex K","index":5,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[[11,1,11,3],[15,0,15,3],[16,1,16,3],[17,1,17,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[2,0,2,3],[33,1,33,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[26,0,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[18,1,18,3],[4,0,4,3],[5,1,5,3]]}
["Annex K: New Manufacturers Reference Format"]
[]
["Instructions: All new proponents not previously contracted by NI must submit references from at least 3\n clients within the last 2 years and with a minimum supply value of CAD $100,000 for each reference. \nSuch references do not have to be directly related to vitamin A commodities.  "]
[]
["Reference 1"]
["Client Name"]
["Client Address"]
["Client Focal Person"]
["Focal Person Email"]
["Focal Person Telephone"]
["Product supplied"]
["# of Years in Business with Client"]
["Contract Start Date (DD/MM/YYYY)",null,"Contract End Date (DD/MM/YYYY)"]
["Contract Value",null,"Currency"]
[]
["Reference 2"]
["Client Name"]
["Client Address"]
["Client Focal Person"]
["Focal Person Email"]
["Focal Person Telephone"]
["Product supplied"]
["# of Years in Business with Client"]
["Contract Start Date (DD/MM/YYYY)",null,"Contract End Date (DD/MM/YYYY)"]
["Contract Value",null,"Currency"]
[]
["Reference 3"]
["Client Name"]
["Client Address"]
["Client Focal Person"]
["Focal Person Email"]
["Focal Person Telephone"]
["Product supplied"]
["# of Years in Business with Client"]
["Contract Start Date (DD/MM/YYYY)",null,"Contract End Date (DD/MM/YYYY)"]
["Contract Value",null,"Currency"]

{"sheet":"HIDE Drop Downs","index":6,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["100,000 - 499,999"]
["500,000 - 999,999"]
[">1,000,000"]
[]
["2014-01-01"]
["2018-12-31"]