Project Fish

1. Project Fish A TOTALLY INTEGRATED SEAFOOD MANAGEMENT SOLUTION Teresa Borrell June 2006

2. Project Fish • Overview of Sanford Limited and existing systems • Design and implementation of our Marel/WiseFish/Navision solution • Integration of this system with internal and external systems • Benefits Sanford have achieved from this investment • Changes in the way we work • Questions

3. Sanford Limited • Vertically integrated, NZ wide, fishing and aquaculture company • 100 years old, public company • 7 shore based processing plants, 2 cold storage facilities, 5 factory freezer vessels and a large inshore fleet • Produce 51,000 tonnes finished seafood products pa for export • 1500 staff NZ wide • 140,000 tonnes of quota and 300 species in the QMS • Sales in 2005 of $365 million

4. Before Company Accounts Customers Head Office accountants prepared company accounts Mof NZ Doc’s Manual Marketing/sales .xls .xls stock .xls Quota Manager fishing returns SI CBA NI CBA CBA stock TMS System .xls Ted Howard System .xls /sheets, .mdb databases: production, yields, stocks etc

5. Now Navision Corporate finance & accounting • Via internet customers interact for information • on the status of their orders $$/cc NZ Food Safety Authority Electronic data available for external use WiseFish On Line Partner Access NZ Doc’s kgs/cartons Ministry of Fisheries S (standard) O (operating) A (application) P (protocol) Kaeo Tauranga Havelock Bluff Timaru Auckland Coromandel Cold stores Freezer Vessels Marel MPS (Marine Packing System)

6. An all-encompassing system • The new system covers our inshore fishing (processed on land), deepwater fishing (processed at sea) and aquaculture farming and processing, New Zealand wide. • The system encompasses: • catching • harvesting • landing • processing • storage and inter-branch transfers • marketing • sales and export of all our product

7. Weigh in of raw materials • Fish arriving at the factory is weighed in on Marel scale • Vessel, date landed, species, state, no of bins and net weight is recorded • Bin (or stack of bins) is labelled and put in chiller

8. Allocating raw materials to production • The factory can view raw material stocks in Marel and plan production • Fish is allocated to production lots for processing in the factory • The “cricket bat” label is scanned which issues the raw materials to their respective production lots

9. Production of finished goods • Fish fillets packed into cartons are weighed up on Marel weigh label stations • Stock code, species, state, grade, date packed, lot number, plant number etc captured

10. Production • Label displays full details as well as individual serial number for that carton • Serial numbers give very fast track and trace and enable a large quantity of data to be held on this carton • Serial numbers are only maintained in Marel

11. Pallet cards • Once palletised cartons are then managed as a pallet unit • The pallet card contains all the detail including all packing dates and lot numbers

12. Export load out of stock • Pallet cards are scanned into containers on load out and a container load out report produced • This data is sent to WiseFish and the file imported into the Trade Agreement from which the commercial invoice, export documentation, health certification and sales invoice are created

13. Detail NAVISION G/L; Debtors, Creditors, Fixed Assets etc = Corporate Accounts WISEFISH Trade Agreements Sales Inventory Fishing Trip Processing Pays Fishermen Factory purchases fish Fish shows in chillers Quota adjusted Info on lots immediately available Yields, productivity calculated Cartons traceable Centralised & detailed factory performance data available FG available for sale Location real-time Group view of stocks Allocation to orders Fast accurate load out data Data to NZDocs Data to NZSFA E-cert OPA for customers S O A P S O A P S O A P S O A P MAREL scan FG scanned onto pallets and enter cold store FG scanned into containers and loaded out to customers scan scan Fish weighed and bar-coded on arrival or at sea data sent by sat link Finished goods production weighed and labelled with bar code

14. Fishing and Quota • All fish landing files are passed to WiseFish and they appear in “Fishing Trips” which, when landed, adjust quota and pay fishermen • WF has been customised to meet NZ quota management requirements • Easy search and reporting gives us quota positions by vessel or permit holder at any time

15. Integration with Mof • End of month LFR, MHR and Ace Transfers are easy • Compile report, convert to txt file and the submit to Fish Serve web site

16. Auction Fish Market (AFM) Integration • Fish to be sold on the auction market is weighed in directly on Marel scale at AFM and an AFM label created • Each bin has its own serial number for fast easy tracking

17. Integration with Auckland Fish Market • Marel/WiseFish have been integrated with the Auxcis Fish Market system. • Marel electronically passes Auxcis a file containing bin serial number, vessel, species, weight etc so AFM scanners can access the data in our barcode. • When fish is sold Auxcis passes back to Marel the auction price by bin serial number.

18. Integration with NZ Doc’s and NZSFA • Container loading details are compiled into files for • NZDOC’s - to create the commercial invoice and export documentation • NZSFA for Electronic Health Certification (E-Certs)

19. OPA – Customer convenience • On-Line Partner Access enables our customers to view their contracts via a secure internet site • Search for all contracts and view by contract number, shipment date, ETA, etc • Contract status of new, booked, packed and shipped update in real time when the shipment voyage is booked, the container is packed and when it is shipped from NZ

20. OPA – links to shipping co.

21. Inventory Management • Measurable reduction in overall stock levels in just 6 months - $45M down to $39M • Selling down to lower levels on all stock items • Ability to easily see stock on board freezer vessel at sea • Easy view of committed stock and available stock • Real time stock picture • Easy and accurate view of all stocks in all cold stores throughout New Zealand, including independent cold stores.

22. Inventory

23. Increased business intelligence • Faster access to vital business information • From factory floor to head office we can better see the business • Real time processing of stock movements, sales invoices, cash receipts, purchase invoices and payments allows financial position of the company to be ascertained at any time with minimal delay • Detailed operational performance reporting – e.g. yield, productivity, costs enables fast in depth analyses • Easy comparisons between vessels, farms, plants, species, shifts etc enables internal benchmarking and comparisons • Costings, packaging usage, bill of materials information gives up to date detail on costs of processing • Orders, sales, average prices per kg/species gives marketing rapid feedback on what is happening within markets or with species across markets • Automated catch and reporting of quota balances makes managing our 300-odd quota species much easier • Faster decisions based on accurate information

24. Increased business intelligence • More automation, electronic certification and transmission of authorisations for product movements and exports • Improved tracking of production and sales • Improved coordination of multi-branch export load outs and domestic dispatches • Full product traceability – from the time that the fish is caught, through processing to storage and consignment, and all the way to the buyer

25. Changes the way we work • The new system is having a far-reaching impact on Sanford staff in two main areas: • Staff accountability • Staff communication

26. Changes to the way we work • Staff accountability • Using the new system has moved more accountability for accurate data collection to production staff as they have to ensure that information is recorded correctly in Marel to enable it to then flow through to WiseFish accurately. • In fact, the system, overall, places responsibility on all staff for data accuracy. • Because the system is integrated, data can be used and entered at all levels of the company and if it is not correct it will impact right through the system. • New motto “do to once – do it right”

27. Changes to the way we work • Staff communication • With the new emphasis on accurate and correct electronic data collection, we have found a positive spin-off being increased and improved inter-branch communication. • It’s is helping break-down branch ‘silo’ mentality. • Staff are beginning to see the company as one integrated whole rather than as a collection of self-contained units.

28. Project Fish - Implementation • 18 month implementation • Identified a core group of “Superusers” – backfilled their jobs to assist with time needed during early phases • WiseFish Vanilla was customised for NZ quota system • Marel and Maritech used SOAP and built interface between MPS and WiseFish • Built interfaces with NZ Docs, MoF, AFM, NZSFA • Data available on line for our customers • Synchronised all the Marel data bases • Fully integrated with vessels at sea and enables accurate discharge and stock immediate available after discharge. • IT team today is 1 database admin and 3 technicians running our network • Well supported by Marel in Iceland and now in NZ; by Maritech Iceland and by HP.

29. Project Fish a success – but not without its challenges • We are seeing strong benefits coming through in our use of the new system, but taking on Project Fish was not without its challenges. • The size and scope of the project, and hence the timeframe, was underestimated. • Although we were confident using the various systems as standalone systems and at single locations we underestimated the work required for the integration of all the systems across our entire group. • The commitment from the super users (one existing Sanford person from each part of our business) was much larger than contemplated and more backfilling of their roles was required.

30. Benefits of Project Fish • Reduced stock levels and improved stock rotation through improved inventory management • Significantly improved and faster access to vital business information. • Improved customer assurance through the extensive use of track & trace functionality. • Increased efficiency and improved business processes through the elimination of data re-keying. • Improved yield management through better operations management. • Improved financial reporting through company wide data integration. • Improved business partner integration through the use of the latest in web technologies.