Financial & Operating Forecast Model Development Consultant
2025-07-18T12:18:32+00:00
Biyinzika Poultry International
https://cdn.ugashare.com/jsjobsdata/data/employer/comp_793/logo/biyizika.jpg
https://www.ugashare.com/jobs/
FULL_TIME
kampala
Kampala
00256
Uganda
Agriculture, Food, and Natural Resources
Accounting & Finance
2025-07-28T17:00:00+00:00
Uganda
8
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)
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
JOB-687a3b9884b09
Vacancy title:
Financial & Operating Forecast Model Development Consultant
Jobs at:
Biyinzika Poultry International
Deadline of this Job:
Monday, July 28 2025
Duty Station:
kampala | Kampala | Uganda
Summary
Date Posted: Friday, July 18 2025, Base Salary: Not Disclosed
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)
Work Hours: 8
Experience in Months: 36
Level of Education: bachelor degree
Job application procedure
Interested in applying for this job? biyinzika.co.ug&form%5Bvalid-to%5D=Monday,%20July%2028%202025">Click here to submit your application now.