|
 Marketing Plan Calculator |
Producer Name
|
Phone
|
Crop Year
|
Farm Number
|
| Projected Crop Data |
Commodity |
|
| |
Acres |
|
|
| |
Cost Per Acre |
|
|
Loan Rate |
|
| |
Expected Yield |
|
|
Current New Crop Bid |
|
| |
Expected Production |
- |
|
Storage Cap. (Farm and Condo) |
|
| Break Even Matrix |
| |
Yield Scenarios |
Production |
Break Even Price Per Bushel |
Return Per Acre Above Cost
(at Loan) |
Return Per Acre Above Cost
(at New Crop Bid) |
| |
|
- |
- |
- |
- |
| |
|
- |
- |
- |
- |
| |
- |
- |
- |
- |
- |
| |
|
- |
- |
- |
- |
| Sales Log |
| |
- |
Total Production |
| |
Bushels Sold |
Delivery Time |
Contract # |
Price Per Bushel |
Storage Costs |
Net Price Per Bushel |
Revenue |
| 1 |
|
|
|
|
|
- |
- |
| 2 |
|
|
|
|
|
- |
- |
| 3 |
|
|
|
|
|
- |
- |
| 4 |
|
|
|
|
|
- |
- |
| |
- |
Bushels Sold |
| |
- |
Bushels Left to Market |
| |
Total Revenue |
- |
| |
Average Return Per Acre Above Costs on Sold Bushels |
- |
Average Price of Sold Bushels |
- |
| Current Plan |
| |
|
| |
Implementation and/or Open Orders |
| |
Bushels |
Delivery Time |
Target # |
Target Price |
Exp. Date |
Comments |
| 1 |
|
|
|
|
|
|
| 2 |
|
|
|
|
|
|
| 3 |
|
|
|
|
|
|
* Input marketing data in the yellow cells in the following areas: Projected Crop Data, Break Even Matrix, Sales Log, and Current Plan.
* Green cells have preset formulas calculating data entered in yellow cells from the break even matrix.
* Lime green cells have preset formulas calculating data from yellow cells in the projected crop data area. |
|