Skip to main content
Calcimator

Marketing Plan Calculator

Percentage-based marketing plan across pricing methods.

Inputs

%
%
%
%

Results

Weighted avg price ($/bu)

5.61

Total revenue ($)$280,625.00
Total allocated (%)100
Unallocated bushels0
How to Use This Calculator
  1. Enter Total Bushels to market and allocate percentages across: harvest cash sales, forward contracts, storage, and hedges.
  2. Enter the price for each marketing method: harvest price, forward price, expected storage price, and hedged price.
  3. Review Weighted Average Price blended across all marketing channels.
  4. Check Total Allocated Percentage — it must reach 100% for a complete marketing plan.
  5. Use Unallocated Bushels to identify production not yet assigned to a marketing method.

How the result changes with % stored for later

% stored for laterWeighted avg price ($/bu)
104.43
355.91
657.68
909.15

What each input means

Total bushels
Total expected production.
% sold at harvest
Percentage sold at harvest cash price.
Harvest price ($/bu)
Expected harvest cash price.
% forward contracted
Percentage forward contracted pre-harvest.
Forward price ($/bu)
Locked-in forward contract price.
% stored for later
Percentage stored for later sale.
Expected storage price ($/bu)
Expected price when sold from storage.
% hedged with futures
Percentage hedged with futures/options.
Hedged price ($/bu)
Target net price from hedge position.

What each result means

Weighted avg price ($/bu)
Blended price across all marketing methods.
Total revenue ($)
Total expected revenue from all methods.
Total allocated (%)
Sum of all percentages (should equal 100%).
Unallocated bushels
Bushels not yet assigned to a marketing method.

How this is calculated

Worked example, using the default values

  1. Identify Input Parameters
    4 parameters
    Total bushels = 50000, % sold at harvest = 30, Harvest price ($/bu) = 5.2, % forward contracted = 25 = 9 input(s) provided
  2. Calculate Weighted avg price
    5.6125 = 5.6125
  3. Calculate Total revenue
    Total revenue = harvestRev + forwardRev + storageRev + hedgedRev
    280625 = $280,625
  4. Calculate Total allocated
    Total allocated = pctHarvest + pctForward + pctStorage + pctHedged
    100 = 100

The questions that sit next to this one — chosen by subject, including calculators filed under a different category.

More in Agriculture & Farming.