Skip to content
Spryhand

Homestead & Chicken

Chicken Feed Cost Calculator

Work out what your flock actually costs to feed, what that makes each egg worth, and whether you are genuinely spending less than you would at the shop.

Delivery
Instant download
Purchase
One-time payment
Format
  • Google Sheets
  • Excel
Updated
August 2026
Sample preview — illustrative data

Monthly feed cost

$63.44

Saving per dozen

$2.71

ItemValue
  • Birds in the flock23
  • Birds actually laying12
  • Cost per dozen$2.78
  • Shop price per dozen$5.49

Sample data preview of the Chicken Feed Cost Calculator spreadsheet, shown for illustration only.

What this spreadsheet does

Feed cost changes with flock size and feed price, and without a calculation it's hard to know what your flock actually costs to feed each month.

What you can do with it

  • Work out whether your eggs cost less than the shop's
  • See what raising replacement chicks adds to the cost of every egg
  • Compare your estimated feed cost against what you actually spent

What's included

Sheet tabs

  • Instructions
  • Cost Summary
  • Flock & Feed
  • Purchase Log
  • Egg Log

Features

  • Flock entered by group — layers, pullets, chicks and roosters eat differently and only some lay
  • Blended feed price across as many feed types as you buy, weighted by share of the ration
  • Daily, weekly, monthly and annual feed cost
  • Cost per egg and cost per dozen, set directly against the shop price
  • A purchase log, so real spend can be checked against the estimate
  • An egg log giving your actual cost per dozen, month by month

How it works

  1. 1Enter your birds by group on Flock & Feed — chicks and roosters eat without laying
  2. 2Enter each feed with its bag price, weight and share of the ration (the sheet checks they total 100%)
  3. 3Read cost per dozen against the shop price on Cost Summary, then log real purchases and egg counts

Who it's for

Backyard chicken keepers and small homesteaders tracking feed budgets.

Frequently asked questions

Can I change the number of chickens?

Yes, and you enter them by group rather than as one number — laying hens, pullets, chicks and roosters each have their own count and feed rate. Only the groups you mark as laying count toward egg production, which is what makes the cost-per-egg figure honest.

Does it account for different feed types?

Yes. Layer pellets, scratch, chick starter and grit each get their own row with a bag price, bag weight and share of the daily ration, and the sheet blends them into one price per pound. It tells you if the shares don't add up to 100%.

Does it calculate cost per egg?

Cost per egg and cost per dozen, both set directly against a shop price you enter, with a plain-English verdict on which is cheaper. It also tells you the lay rate you'd need to match the shop.

What if my hens stop laying for a month?

That's the moult, and the Egg Log handles it — a month with zero eggs reads $0.00 rather than an error, and the feed you bought that month still counts toward your real cost per dozen across the year.