Annex B – Aquaculture Development Source tables

The table on this page is for your information only. To submit a copy of the document, please download the xlsx version and return it to us. Submission instructions are in the application guide.
Depending on your browser settings, you may need to right click on the document link and select a ‘save’ option.

Table 1

Table 1. Production plan

Due to the diverse nature of aquaculture, it is impractical to provide a production plan template that fits most scenarios. If you already have an Excel-based production plan, paste it here and in your ADS Business Case template. If you already have a production plans that is not Excel-based, paste it directly in the ADS Business Case template. Ensure that your production plan includes the following elements:

  1. Timeline
  2. Initial and final biomass, accounting for mortality and other losses.
  3. Feeding schedule (finfish)
  4. Number of farming units where biomass is distributed (cages, bags, netpens, tanks, rafts, etc.)
  5. Cohorts
  6. Clear description of the incremental production to be achieved if this project is intended to increase the farm's output.

If you don't have a production plan and need assistance developing one, contact the BDT's Aquaculture Advisor: Jackson Matschke jmatschke@skeenafisheries.ca.

Example of a typical shellfish production plan:

2019/20 Stock
Oyster stock Oysters/bag average Cages total # bags total Oysters total Loss 4%/year Live oysters Sales Sales in $
Markets 2014 250 20 117 29,318 1,173 28,146 28,146 10,695
Markets 2015 250 26 155 38,861 1,554 37,306 31,710 12,050
Blue 2016 250 595 3,567 891,814 35,673 856,141 428,071 162,667
Yellow 2017 400 286 1,717 686,776 27,471 659,305 - -
Red 2018 1,400 80 480 672,000 26,880 645,120 - -
Purple 2019 2,500 47 280 700,000 28,000 672,000 - -
Totals:   1,007 6,044 2,950,590 118,024 2,832,567 428,071 $174,716.81
2018/19 Stock
Oyster stock Oysters/bag average Cages total # bags total Oysters total Loss 4%/year Live oysters Sales Sales in $
Markets 2014 208 163 973 195,456 - 195,456 166,138 58,148
Blue 2015 250 65 389 97,152 3,886 97,152 48,576 17,002
Yellow 2016 400 430 2,580 1,032,192 41,288 990,904 - -
Red 2017 1,400 85 511 715,392 28,616 686,776 - -
Purple 2018 2,500 47 280 700,000 28,000 672,000 - -
Totals:   790 4,733 2,740,192 101,789 2,642,289 214,714 $75,149.76
Table 2

Table 2. Capacity and training

Use one row per person when capturing the information. In Training history, include all courses/training previously undertaken by the person. If none, please note this. In Training needs, capture what training is required, when it is expected to be provided (e.g. month, year) and identify the provider (e.g. name of institution/mentor/consultant) and method of delivery. If training will be provided by a mentor/consultant, add as Appendix the proposal/quote.

  Training history Training needs
Employee's position Course Date taken Provider Certificate (y/n) Course Date to be taken Provider Certificate (y/n)
Farm/site manager                
Crew member                
Administrative (describe)                
Other                
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
Table 3

Table 3. Costs and budget

List all capital and operating costs that are directly related to the proposed project. Identify any other funding sources besides ADS that will support the project, if applicable. Add columns if more than one additional funding source.
Operating costs are not eligible under ADS funding but capturing them here provides a detailed understanding of project costs.

  Financing
Item description Unit cost Quantity Total cost ADS Own Other**
             
Capital costs*            
             
Equipment and materials (describe all applicable)            
Vehicles (truck, work skiff, other)     $0.00      
Fishing vessels     $0.00      
Farming gear (buoys, lines, anchors, nets, cages, bags, rafts, etc)     $0.00      
Auxiliary gear (boots, gloves, PFDs, waders, knifes, etc.)     $0.00      
Office equipment (laptop, printer, cell phone, etc.)     $0.00      
Laboratory equipment     $0.00      
Machinery (power washers, forklifts, FLUPSY, sorters, etc.)     $0.00      
Shipping and logistics     $0.00      
Installation/construction costs     $0.00      
Buildings (including heating, cooling, electrical systems, etc.)     $0.00      
Machinery, equipment and tools (worth over $500)     $0.00      
Computers and systems software     $0.00      
Other computer software     $0.00      
Tools (worth less than $500)     $0.00      
             
Total capital costs $0.00   $0.00 $0.00 $0.00 $0.00
             
Operating costs            
             
Seed / smolts / fingerlings     $0.00      
Subtotal $0.00   $0.00 $0.00 $0.00 $0.00
Repairs and maintenance            
Vessels     $0.00      
Motors     $0.00      
Truck and trailers     $0.00      
Subtotal $0.00   $0.00 $0.00 $0.00 $0.00
Salaries per month            
Supervisor/Manager     $0.00      
Crew (X # of people)     $0.00      
MERCS     $0.00      
Subtotal $0.00   $0.00 $0.00 $0.00 $0.00
Professional fees            
Diving     $0.00      
Accounting/legal     $0.00      
Training     $0.00      
Consulting     $0.00      
Subtotal $0.00   $0.00 $0.00 $0.00 $0.00
Miscellaneous            
Telecommunications     $0.00      
Dues and fees (tenures, licenses, wharf, memberships, etc.)     $0.00      
Farm supplies     $0.00      
Fuel and oil     $0.00      
Insurance     $0.00      
Office supplies     $0.00      
Power     $0.00      
Rent/leasing (land facility, office, warehouse, vessels, trucks, etc.)     $0.00      
Water     $0.00      
Other consumables (sand, cement, etc.)     $0.00      
             
Subtotal $0.00   $0.00 $0.00 $0.00 $0.00
Total operating costs $0.00   $0.00 $0.00 $0.00 $0.00
             
Total investment $0.00   $0.00 $0.00 $0.00 $0.00
Financing %      
Table 3a

Table 3a. Straight line depreciation of assets

List all capital costs that are directly related to the proposed project. Items and total value should be the same as those listed in Table 3. Costs and Budget. This table is a support for calculating the depreciation of all assets using the straight line method, useful when the depreciation rate is unknown and the items have a long life. The columns F and G are automatically calculated when columns D and E are filled in.

Item* Total value* Useful life in years Residual value Annual depreciation expense Terminal value (after 10 years)
           
Capital costs          
           
Example: Nets $100,000.00 10 $20,000.00 $8,000.00 $20,000.00
           
Vehicles (truck, work skiff, other) $0.00       $0.00
Fishing vessels $0.00       $0.00
Farming gear (buoys, lines, anchors, nets, cages, bags, rafts, etc) $0.00       $0.00
Auxiliary gear (boots, gloves, PFDs, waders, knifes, etc.) $0.00       $0.00
Office equipment (laptop, printer, cell phone, etc.) $0.00       $0.00
Laboratory equipment $0.00       $0.00
Machinery (power washers, forklifts, FLUPSY, sorters, etc.) $0.00       $0.00
Shipping and logistics $0.00       $0.00
Installation/construction costs $0.00       $0.00
Buildings (including heating, cooling, electrical systems, etc.) $0.00       $0.00
Machinery, equipment and tools worth over $500 each, including for communications $0.00       $0.00
Computers and systems software $0.00       $0.00
Other computer software $0.00       $0.00
Tools worth less than $500 each $0.00       $0.00
           
           
           
Table 4

Table 4. Project estimates

Please provide an itemized breakdown of revenues and expenses generated by the project and list assumptions used to estimate revenues (e.g. volume of product sold, farmgate price) and expenses (e.g. tenure fee rate, rental/lease rate).

Include only revenues and expenses that are directly related to the proposed project.

Notes regarding the estimates (assumptions)

Revenues
1.
2.
3.
Expenses
1.
2.
3.
(add lines as needed)

Revenues: Please provide a detailed breakdown of assumptions used to estimate revenues (e.g. farmgate price, sales volume). *If future revenues are projected to increase by more than the rate of inflation, please provide an explanation regarding assumptions (e.g. price increase, scaling up production, other investment).

Expenses: The values for 2021-22 will be populated from its corresponding linked cells in Table 3. Please ensure that all expenses are accounted for in that Table.

Project estimates 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 2029-30 2030-31
Revenues
Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
 
Expenses
Seed / smolts / fingerlings $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Repairs and maintenance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Salaries per month $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Professional fees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Miscellaneous $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
 
Revenue inflation amount 2.00%  
Expense inflation amount 2.00%  
Table 5

Table 5. Project assessment (internal rate of return)

The purchase price and terminal value of the investment will be populated automatically based on the sum of all terminal values of equipment purchased for the project after ten years, calculated in Table 3a. Depreciation of assets.

Revenues, expenses and net income will be populated automatically based on calculations in Table 4. Project estimates.

If additional future investments are required to achieve financial viability of the project, please indicate the value(s) of the investment(s), the year in which they are expected and potential sources of funding in the assumptions.

Purchase price $0
Terminal value $0
  2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 2029-30 2030-31
Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
                     
                     
  2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 2029-30 2030-31
Investment $0                 $0
Net income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net profits $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
IRR                    
Table 6

Table 6. Jobs and employment

Use this table to summarize any employment by the project during the previous Fiscal Year (2020-21), if applicable, and any new jobs to be created by the proposed project in 2021 (indicated with *). Please use numbers, not symbols (e.g., X), to populate the table.

Type of employment Position Total # jobs Frequency of work Duration of work Number of jobs held by: #FTEs/job Total #FTEs Notes
(avg # days per week) (avg # months per year) Member FN Other FN Non-FN
Administrative Manager             0.00 0.00  
  Office             0.00 0.00  
  Other             0.00 0.00  
                0.00 0.00  
Farm Supervisor             0.00 0.00  
  Crew             0.00 0.00  
Other               0.00 0.00  
                0.00 0.00  
Totals                 0.00  
Table 7

Table 7. Project work plan

Task Target completetion due date Personnel Comment
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       

Related materials