Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| كود الدورة | تاريخ التحضين | عدد الكتاكيت | الحالة | نسبة النفوق | الباقي في العنبر | إجمالي التكلفة | إيراد المبيعات | ربح الدورة | تكلفة الكيلو |
|---|---|---|---|---|---|---|---|---|---|
| C01 | 46183 | 5,000 | مغلقة | 1.9% | 0 | 509,000.00 | 703,490.00 | 194,490.00 | 53.89 |
| C02 | 46223 | 4,000 | مغلقة | 2.3% | 3 | 431,000.00 | 530,430.00 | 99,430.00 | 58.09 |
| C03 | 46290 | 5,000 | جارية | 1.7% | 4,915 | 402,500.00 | 0.00 | ||
| C04 | 46327 | 4,500 | جارية | 0.0% | 4,500 | 103,500.00 | 0.00 |
Example from the “الدورات” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- "الإعدادات" (Settings): Today's date (used to work out the age of a running cycle) and the mortality rate above which the sheet raises a warning.
- "الدورات" (Cycles): Cycle code, description, placement date, number of chicks, price per chick and closing date. The sheet calculates status, age, dead birds, mortality rate, birds sold, birds left in the house, feed quantity and cost, other expenses, chick cost, total cost, weight sold and sales revenue. For a closed cycle it adds cycle profit and cost per kg. It also shows average weight per bird sold, feed per kg sold, the latest average weight and warnings for head count and mortality. Room for 100 cycles.
- "الأعلاف" (Feed): Each feed delivery with its date, cycle code, type (starter, grower or finisher), quantity in kg and price per kg. The cost is calculated, and the sheet warns you about a cycle code that does not exist. Room for 1,000 entries.
- "النفوق" (Mortality): Each mortality record with its date, cycle code, number of birds and cause (heat, disease, accident or unknown). Room for 1,000 entries.
- "الأوزان" (Weights): Weight samples: the number of birds in the sample and their total weight. The sheet calculates average weight per bird and picks out the latest sample for each cycle. Room for 500 samples.
- "المبيعات" (Sales): Each batch you sell, with its date, cycle code, number of birds, total weight in kg and price per kg. The sheet calculates the amount. Room for 500 batches.
- "المصروفات" (Expenses): Expenses other than feed and chicks, with the date, cycle code, category (medicine and vaccines, labor, electricity and gas, bedding, transport or other) and amount. Room for 1,000 entries.
- "الملخص" (Summary): The number of closed and running cycles. For closed cycles: total cost, revenue, profit, average profit per cycle, highest and lowest profit, overall cost per kg, mortality rate and profit margin. For running cycles: cost to date and birds remaining. Plus two tables: feed by type and expenses by category.
- "ابدأ هنا" (Start here): How to use the sheet, what the colors mean and notes on the calculations.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
Open "الدورات" (Cycles) to see, for each cycle, what it cost you, what you put in, what you earned and what each kilo of chicken sold cost you. Compare a cycle with the previous one in the "الملخص" (Summary), and spot early any cycle whose mortality is rising or whose head counts do not add up.
How to use it
- In the "الإعدادات" (Settings) sheet, enter today's date (or =TODAY() so it updates itself) and the mortality rate at which you want a warning.
- In the "الدورات" (Cycles) sheet, enter each cycle's code, description, placement date, number of chicks and price per chick. When the cycle ends, enter the closing date.
- In the "الأعلاف" (Feed) sheet, record every feed delivery with its type and price per kg. In "النفوق" (Mortality), record each day on which birds died, with the cause.
- In "الأوزان" (Weights), record the weight samples you take during the cycle. In "المصروفات" (Expenses), record every expense other than feed and chicks.
- In "المبيعات" (Sales), record each batch you sell with the number of birds, total weight and price per kg.
- Open the "الدورات" (Cycles) sheet to see each cycle's cost, revenue, profit and cost per kg, and the "الملخص" (Summary) sheet to compare closed cycles, feed and expenses.
Before you start:
- Profit and cost per kg are calculated for closed cycles only, meaning those with a closing date. A running cycle shows its cost to date but no profit.
- Total cost = chick cost (number x price) + feed cost + other expenses. Profit = sales revenue - total cost.
- Cost per kg = total cost / weight sold. Feed consumption = feed quantity / weight sold.
- Birds left in the house = number of chicks - dead - sold. If the remainder is not zero in a closed cycle, or is negative, the message "راجع الأعداد" (check the counts) appears.
- Average bird weight in "الأوزان" (Weights) = sample weight / number of birds in the sample. The "الدورات" (Cycles) sheet shows the average of the latest sample recorded.
- The sheet has room for 100 cycles, 1,000 entries each in feed, mortality and expenses, and 500 each in weights and sales.
Free cheat sheet for this field
Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
How is cycle profit calculated?
Cycle profit = sales revenue - total cost, and total cost = chick cost (number x price) + feed cost + other expenses. Profit is shown only for a closed cycle, meaning one with a closing date entered.
How is cost per kg calculated?
Cost per kg = the cycle's total cost / weight sold in kg. It appears for a closed cycle that has sales recorded. Feed per kg sold is the feed quantity / weight sold.
What does the "راجع الأعداد" (check the counts) message mean?
Birds left in the house = number of chicks - dead - sold. If a cycle is closed and the difference is not zero, or the remaining count goes negative in any cycle, the warning appears so you can review the mortality and sales counts.
Can I change the mortality warning rate?
Yes. Change the rate in the "الإعدادات" (Settings) sheet, and the message "نفوق مرتفع" (high mortality) appears for every cycle whose mortality rate is above it.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Farming
More free templates
- Crop season expenses and revenue tracker (Excel)
- Racing pigeon loft sheet
- Livestock and dairy farm sheet
- Complete farm management sheet in Excel: plots, workers, crops and sales
- Agricultural waste management sheet: rice straw, residues, compost and recycling
- Wedding and event budget planner (Excel)
- Car rental fleet tracker (Excel)
- Fleet fuel and maintenance tracker (Excel)
- Car showroom accounts sheet
- Freelancer projects, hours and invoices tracker
- Supplier purchase orders and payables tracker
- Charity donations and disbursements tracker
- Travel agency bookings tracker