lp-2010 - Farm Plan Whole-Farm Planning (LP) LP Example for...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Farm Plan Whole-Farm Planning (LP)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
LP Example for Farm Plan You have 7 possible enterprises on the farm: cotton, peanuts, corn, soybeans, winter stockers, summer stockers, and cow-calf. Enterprise budgets are available on my class site.
Background image of page 2
Restrictions come from your data cropland: how much cropland? pasture: how much pasture? labor: how many hours of labor per month from permanent employees (operators' labor plus year-round hired labor)?
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
LAND I have 720 acres of cropland, 380 acres of pasture. Cropland can be used in summer for crops. Some crops (peanuts, soybeans) can be followed by winter grazing. Land Use units acres pasture ** 380 corn bu 200 cotton lbs 200 soybeans bu 320 farmstead/waste 40 total cropland 720
Background image of page 4
Labor Available Labor Operators 2.5 Full-time Hired 0 Your data set contains this information. Add the total FTEs. I have 2.5 FTEs. You may have a different number.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Labor Hours Available Each Month FTEsX4.33X 60 = hours available About 4.33 weeks in a month About 60 hours worked per FTE per week My sample farm: 2.5 X4.33X60 = 649.5 hours per month
Background image of page 6
SEASONS If you plant soybeans or peanuts over the summer, you can follow those crops with winter grazing. For the most part, you can't do that with cotton or corn. (Some people do, but it is more complicated.) So corn and cotton take up land all year. Soybeans or peanuts leave land available for winter grazing.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Putting together the tableau use the enterprise budgets the information on resource limits that you obtain from your data use the labor requirements by month spreadsheet
Background image of page 8
Workbook Make a workbook page for each enterprise budget (7 new pages) Make a workbook page for the labor requirements for crops and one for livestock (2 new pages) Make a workbook page for the basic LP You now have a total of 13 workbook pages (data, balance sheet, income statement, LP page, labor requirements (2 pages), enterprise budgets (7 pages).
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
LP Objective function Maximize returns above variable costs Using Excel functions, get the returns above variable costs for each acre of crops and each head of livestock . The correct cell in each Enterprise Budget is shaded in yellow.
Background image of page 10
Enterprise Budget For Corn Entry for OBJ 120.00 4.00 480.00 1. VARIABLE COSTS SEED 1000K 28.00 2.65 74.20 TECH FEE RR ACRE 1.00 20.00 0.00 FERTILIZER NITROGEN UNITS 160.00 0.50 80.00 PHOSPHATE UNITS 60.00 0.35 21.00 POTASH UNITS 60.00 0.42 25.20 MICRONUTRIENTS ACRE 1.00 8.00 8.00 LIME (PRORATED) TONS 0.33 30.00 9.90 HERBICIDES ACRE 1.00 27.00 27.00 INSECTICIDES ACRE 1.00 10.00 10.00 FUNGICIDES ACRE 1.00 0.00 0.00 NEMATICIDES ACRE 1.00 0.00 0.00 CONSULTANT ACRE 0.00 5.00 0.00 DRYING BU. 120.00
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 39

lp-2010 - Farm Plan Whole-Farm Planning (LP) LP Example for...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online