JOB DETAILS:

Overview:

BIYINZIKA Poultry International Limited (BPIL) is a vertically integrated poultry company operating across the full value chain — from breeder parent stock, hatcheries, broiler farms, and feed milling to processing and the sale of fresh/frozen chicken. With BPIL entering a new growth phase and deeper international engagement, a robust, accurate, and user-friendly forecast model is essential.

Objective:

To design and build a driver-based financial & operational forecast model, supporting:

• Strategic decision-making
• Scenario planning
• Cash forecasting
• Multi-currency reporting (UGX & USD)

Scope of Work

The consultant will design and deliver a fully functional, modular Excel-based financial and operational forecast model with the following key components:

Model Structure:

Index Sheet

A central navigation hub with hyperlinks to all model sections, clearly categorized for ease of use.

Input Sheet

A centralized assumptions page with editable, color-coded inputs, covering:

• Product pricing (feeds, day-old chicks, dressed chicken)
• Operational volumes and placement schedules
• Biological and technical assumptions (FCR, mortality, hatchability, yield)
• Inflation, FX rates, VAT, and general economic parameters

Business Unit Working Sheets

Dedicated sheets for each major operational area, enabling calculation of production volumes, costs, and KPIs:

• Feed Production
• Breeder Parent Stock Placement & Egg Production
• Hatchery – Day-Old Chick Production
• Own Farm Broiler Production
• Contract Grower Operations
• Abattoir – Chicken Processing
• Commercial Sales – Local & Export (all product categories)

Financial Logic & Tax Computation Sheets

Integrated calculations to derive:

• Revenue, cost of goods sold (COGS), gross profit
• Operating expenses (Opex), EBITDA, depreciation
• Tax liability (including deferred tax, loss carry-forwards)

Output Sheets

Automated generation of monthly and annual financial statements:

• Income Statement (P&L)
• Balance Sheet
• Cash Flow Statement (direct and indirect methods)

Graphs & KPI Dashboards

Dynamic visual summaries of key performance indicators (KPIs), financial trends, and operational metrics — designed for management and Board-level presentations.

Capital Expenditure (Capex) & Funding Modules

• Project-specific Capex planning and asset depreciation tracking
• Loan assumptions, interest schedules, repayment planning
• Covenant testing and debt service obligations

Scenario & Sensitivity Analysis Modules

Toggle between multiple pre-set scenarios (Base, Upside, Downside)

Sensitivity tables to analyze impacts of key variables (e.g. feed price, FCR, hatch rates)

USD Conversion Logic

• Supports dual-currency reporting (UGX & USD)
• Applies monthly average FX rates to P&L items and closing rates to balance sheet positions
• Enables side-by-side or toggled USD financial views

Forecast Horizon: Monthly forecast over 3–5 years

Deliverables:

• Draft model architecture for approval
• Fully functional Excel model
• Walkthrough & training session
• User manual / “How-To” tab
• Final editable and locked Board version

Proposed Timeline: ~6 Weeks

• Consultant Appointment
• Model Design Approval
• Draft & Feedback
• Final Model + Training
• Exact dates to be aligned during onboarding.

Expertise Required:

• Proven financial modeling in agribusiness/manufacturing
• Experience with poultry operations (added advantage)
• Multi-currency reporting and cash flow forecasting
• Strong Excel skills (minimize use of macros)
• Ability to train non-technical finance users

Estimated Consultant Fee: USD 10,000 (Over a 6-week project period)

Week 1:

• Project Scoping, Kickoff & Model Framework — USD 1,000

Weeks 1–2:

• Input Sheet & Master Assumptions — USD 1,000

Weeks 2–3:

• Business Unit Working Sheets (7 units) — USD 2,500

Week 3:

• Calculation Sheet (Financial Logic Integration) — USD 1,000
• Tax Computation Sheet — USD 500

Week 4:

• Output Sheet (P&L, Balance Sheet, Cash Flow) — USD 750
• Graphs & Dashboard Sheet — USD 750
• Capital Expenditure (Capex) Sheet — USD 500

Week 5:

• Funding Modules (Input & Output Sheets) – USD 750
• Scenario & Sensitivity Sheets – USD 500
• USD Conversion Sheet – USD 500

Week 6:

• Review, Testing & Debugging – USD 500
• Final User Manual, Handover & Team Training – USD 750

Total Fixed Project Cost: USD 10,000

Post-delivery support (if needed) can be billed separately or under a retainer.

Notes:

• Weekly check-ins + 1 revision cycle
• Editable & Board-version model
• Post-handover support billed separately (optional)