lot
uG(G
August 1985
Disk(s) under separate cover
Circular 664
UFBUD
University of Florida
Agricultural Budget Generator
COMPUTER SERIES
Susan Phillips and Rom Alderman
01 oorativ Extnsion Service Institute of Food and Agricultural Scienm / Univerity of Florida / Jotn T. Wowte, Dean
g664
guide
ABSTRACT
This user's manual explains the use of UFBUD, a micro-
computer program to facilitate the development and analysis of
agricultural crop enterprise budgets.
Keywords: Budgets, Sensitivity Analysis, Microcomputers
ACKNOWLEDGMENTS
Many thanks are due to Timothy Hewitt, Dr. R.L. Degner and Paul
Willis for reviewing and commenting on UFBUD. Thanks also go to
Charlie Pierce, student employee of FARM Lab, who helped develop
parts of the UFBUD program.
TABLE OF CONTENTS
Page #
Introduction........................................ ....... .. 5
Program Description....................................... 5
Program Specifications ................................... 5
General Budgeting Concepts..................................... 7
Defining a Budget ....................................... 7
Using a Budget............................................ 7
Considerations for Developing a Budget................... 8
Program Start-Up.............................................. 9
Making Back-Up Copies ..................................... 9
Lotus Basics.............................................. 10
Starting UFBUD............................................. 10
Crop Select/Create/Modify.................................... 12
Select ................................................. 12
Create.. ... ..... .. ....... ... .. ............... . .. ... 12
Modify......................... .....*...................... ... 15
Mach/Comp................................................. 15
Print ..................................................... 15
Program Overview ................................................ 16
Entering Data............................................. 16
Generating Output .............. ......................... 17
Saving Your Work .......................................... 17
Disk Storage Space........................................ 17
Main Menu Selection Production............................... 18
Main Menu Selection Inputs................................... 20
Main Menu Selection Machinery Use............................ 22
Main Menu Selection Budget ................................... 26
Main Menu Selection Cost/Mach ................................ 30
Main Menu Selection Print .................................... 33
Main Menu Selection Other .................................... 34
Advanced Techniques ............................................ 36
Changing the Print Code................................... 36
Ordering Information..;..................................... 36
References .......... ........................................ 37
Appendix A. Lotus Compatible Computers......................... 39
Appendix B. Sample Printouts.................................. 43
Appendix C. Machinery Complement List Coefficient Description. 53
UNIVERSITY OF FLORIDA LIBRARIES
LIST OF FIGURES
Page #
FIGURE 1. Sample UFBUD Title Page and
Crop Select/Create/Modify Menu..................... 11
FIGURE 2. Crop Identification Catalog......................... 13
FIGURE 3. Instruction for Creating the Budget File........... 13
FIGURE 4. Main Menu........................................... 16
FIGURE 5. Sample PRODUCTION Screen............................ 19
FIGURE 6. Sample PRODUCTION Screen (cont'd)................... 19
FIGURE 7. Sample INPUTS Screen .............................. 21
FIGURE 8. Sample INPUTS Screen (cont'd)...................... 21
FIGURE 9. Sample Machinery Complement List.................... 24
FIGURE 10. Sample Machinery Complement List (cont'd)........... 24
FIGURE 11. Sample Timeover Machinery Requirements.............. 25
FIGURE 12. Sample Timeover Machinery Requirements (cont'd)..... 25
FIGURE 13. Sample Budget Solution.............................. 28
FIGURE 14. Sample Budget Solution (cont'd)..................... 28
FIGURE 15. Sample Budget Solution (cont'd)..................... 29
FIGURE 16. Sample Machinery Subset List....................... 30
FIGURE 17. Sample Machinery Subset List (cont'd)............... 31
FIGURE 18. Sample Machinery Subset List (cont'd)............... 31
FIGURE 19. Sample Machinery Subset List (cont'd)............... 32
FIGURE 20. Sample Print Menu Screen.......................... 33
FIGURE 21. Sample OTHER Submenu Screen......................... 35
FIGURE 22. Sample Parameter Values............................. 35
UFBUD
University of Florida Agricultural Budget Generator
by
Susan Phillips
Rom Alderman
INTRODUCTION
Program Description
UFBUD (University of Florida Agricultural Budget Generator)
is a microcomputer program designed to facilitate the development
and analysis of agricultural crop enterprise budgets. The pro-
gram is modeled after the Oklahoma State University Budget Gene-
rator that was acquired for mainframe use in 1979. UFBUD follows
the Oklahoma input/output format.
Farmers can use UFBUD as an aid in the decision making pro-
cess, while agricultural lenders and management consultants will
find UFBUD helpful for analyzing clientele business situations.
This program is easy to use, yet maintains the high level of
sophistication necessary for complete budget analysis.
Program Specifications
UFBUD operates with MS-DOS using Lotus 1-2-3 version 1.A
integrated software and requires a minimum of 256K memory. Hard
drive users will find budget file maintenance easier than single
or double drive users. Therefore, a hard drive is recommended,
but not required. A printer is required to get hard copy output.
The program will run on any MS-DOS/Lotus 1-2-3 compatible com-
puter (see Appendix A for a list of Lotus compatible computers).
Susan Phillips is an Economic Analyst and senior author of the
documentation; Rom Alderman is an Economic Analyst and senior
program author. Food and Resource Economics Department,
Institute of Food and Agricultural Sciences, University of
Florida, Gainesville.
Lotus 1-2-3 is a spreadsheet software package written by
Lotus Development Corporation which combines graphics and infor-
mation management capabilities with a highly advanced electronic
spreadsheet. Little or no programming knowledge is required to
use 1-2-3.
UFBUD requires no previous experience with microcomputers or
special programming skills. A basic understanding of Lotus mec-
hanics is helpful. The user should at least feel comfortable
with moving the cursor around the screen, selecting menu choices
with the cursor and entering numbers and labels into cells.
Lotus 1-2-3 was chosen as the programming environment be-
cause of its recognition as a quality software package and for
its potential usefulness to farmers, lenders and consultants as a
powerful spreadsheet for developing custom applications.
GENERAL BUDGETING CONCEPTS
Defining a Budget
A budget is an orderly and complete listing of all revenue
and expenses related to the production of a commodity. Three
basic types of budgets exist: whole farm, enterprise and
partial.
The whole, farm budget considers all enterprises on the farm
in one collective budget. The enterprise budget is concerned
only with one enterprise, such as growing corn, and is usually
presented on a per acre basis. Each enterprise budget is deve-
loped for one production cycle and for a single set of production
practices. Finally, the partial budget, as the name implies, is
a partial listing of revenue and cost factors that are likely to
change given a change in the production process. UFBUD develops
crop enterprise budgets.
Using a Budget
Budgets are an invaluable planning aid. Complete farm plan-
ning is difficult without the use of budgets. Budgets are useful
for selecting profitable enterprises, for testing changes and for
identifying the return to management and risk. Enterprise bud-
gets allocate capital and fixed costs, such as machinery expen-
ses. Knowing operating and fixed costs on a per acre basis helps
the farmer to determine which crop to plant and how many acres to
produce.
Farm managers or planners can use budgets for sensitivity
analysis. This type of analysis indicates how sensitive the
budget solution (return to management and risk) is to a change in
a single revenue or cost factor. For example, you may want to
find out how sensitive your returns are to an increase in the
price of fertilizer. Specifically, will a 10% increase in the
price of fertilizer decrease the returns to management by more or
less than 10%?
Another type of sensitivity analysis is known as break-even
analysis. With break-even analysis the farm manager can deter-
mine the effect that total costs and output prices have on the
break-even yield and the effect that total costs and expected
yield have on the break-even price. The result is that the
manager is able to develop price and yield expectations and use
this information to estimate the probability of achieving a
particular outcome.
Considerations for Developing a Budget
Several considerations go into developing any budget, but
one is worth emphasizing and that is, do not "fool" yourself by
making false assumptions. A budget is only as accurate as the
data used to generate the budget. One of the primary purposes of
an enterprise budget is to determine the potential profitability
of an enterprise. Making false assumptions may lead to a false
conclusion regarding enterprise profit capabilities.
Two items are commonly overestimated and therefore should
get special consideration. First, managers tend to assume that
all acres planted will be harvested when actually only 85% to 95%
may be harvested. Second, yield estimations are often based on
last year's performance rather than on a historical average for
the individual farm.
The key to developing a useful budget is to estimate all
revenue and expenses as accurately as possible.
PROGRAM START-UP
Making Back-Up Copies
Before starting your first UFBUD session protect the UFBUD
program disk by making a back-up copy of it. Making this back-up
is important for two reasons. One, your original distribution
disk will give you a write protect error if you try to save work
on it. Two, if your disk develops an error, such as a bad
sector, you will always have the original disk. Store the
original UFBUD program disk in a safe location and never use it
for day-to-day work.
Making a back-up copy is easy, following these simple
instructions:
1. Put the 1-2-3 Utility Disk in drive A and turn the power
on. If the power is already on follow your computer's
instructions for a cold-boot.
2. Label a blank disk as "UFBUD PROGRAM DISK--Working Copy"
and put this disk in drive B. For single drive owners
Lotus will prompt you to switch source and destination
disks.
3. Use the arrow keys to select the Disk Manager option and
press
.
4. Use the arrow keys again to select the Disk Copy option
and press .
5. When prompted, remove the Utility Disk from drive A,
insert your original UFBUD program disk and press the
key.
6. When the copy is complete remove the original UFBUD disk
from drive A and put it in a safe location.
7. Use your new copy of UFBUD as the daily working copy.
Lotus Basics
Understanding a few basic Lotus operating mechanics will be
helpful in running UFBUD. Moving around the spreadsheet is
accomplished by using one of the four arrow keys located on the
number pad of the IBM-PC keyboard. The right and left arrow keys
are used to select menu choices from any menu that is displayed
at the top of the screen. To select a menu choice press the
appropriate arrow key until your selection is highlighted and
then press the key.
UFBUD is completely menu driven which means that you direct
the activity of the program by the choices that you select.
UFBUD menus work in the same manner as Lotus command menus. Each
menu is designed to give you a brief explanation of the selection
that is highlighted. By moving the cursor to each of the keywords
on the top of the menu you can read each explanation on the
second line of the menu.
UFBUD uses the Lotus "range input" facility extensively.
This facility only allows the user to enter data into high inten-
sity green cells. High intensity cells, as the name implies,
appear brighter than low or normal intensity cells. The differ-
ence in intensities is easily distinguishable on the monitor
display.
To make minor changes to values entered in the worksheet
simply type over the existing value. To erase a single cell move
the cursor to the cell location to be erased, press the space bar
once then press the return key. Making other major changes will
be explained later in this users guide under the section for the
main menu OTHER selection.
Starting UFBUD
To start the UFBUD program follow these 4 easy steps:
1. Put the 1-2-3 disk in drive A and turn the power on. If
the power is already on follow your computer's instruc-
tions for a cold-boot.
2. Put your UFBUD working copy in drive B. Single drive
or hard drive users should consult the Lotus manual.
3. Press the key to select the 1-2-3 option.
4. When the program is loaded the Title Page and Crop
Select/Create/Modify menu will appear on the screen
(Figure 1). You are now ready to begin using UFBUD.
FIGURE 1. Sample UFBUD Title Page and
Crop Select/Create/Modify Menu
SELECT CREATE MODIFY MACH/COMP PRINT Quit
Select a crop (Make sure the file exists and/or the correct disk is present).
A B C D E
1
2
3 UFBUD
4 U.F. Agricultural Budget Generator
5
6 with output in the
7
8 Oklahoma State University format.
9
10
11 *** *******************************************--*--*****,* *** *****
12 Developed by FARM Lab,
13 ** Food and Resource Economics Department
14 (C) IFAS, University of Florida, 1985 **
15 *****************n****** *****************
16
17
18
19
20
CROP SELECT/CREATE/MODIFY
Each time you start UFBUD the Crop Select/Create/Modify menu
appears on the monitor (Figure 1). The program disk (the disk
that contains the following files: AUTO123.WKS, MACHCOMP.WKS,
BLANK.WKS, 1.WKS and 2.WKS) catalogs up to 45 budget names.
Because of disk storage space limitations, typically 320K, only
two budgets can be stored on the program disk. Three budgets can
be stored on each additional floppy disk. You can make as many
data disks as you require, but you must always start your UFBUD
session with the program disk. If you have a hard disk, all the
files can be stored under one sub-directory. Using a hard drive
will be the easiest way to access your files.
Old budgets that you no longer actively use, but do not want
to erase can be archived with the Lotus File Manager utility on
historical data disks. This will free up name cataloging
space to add new names. To view your archived budgets use the
1-2-3 /File Retrieve command function.
Select
To analyze or make changes to a budget that already exists
use the SELECT option. Choose the desired budget by entering its
catalog number and pressing the enter key. See Figure 2 for a
sample Crop Identification catalog. It is important that the
correct disk is present before pressing the enter key. If 1-
2-3 can not find the selected budget on the current disk it
will beep and give you a file read error. To recover, press the
key and then press the keys simultaneously. These
key sequences will return you to the Select/Create/Modify menu.
Create
To create a new budget and add its name to the crop identi-
fication catalog use the CREATE option. When the create option
is selected you are asked which budget number to create. Enter
the number for the next available budget name and then when the
cursor moves to that location enter the desired name. If your
new budget name, for some reason, begins with a number start the
entry with an apostrophe (') otherwise Lotus will interpret your
entry as a numercial value entered incorrectly.
After the new budget name is entered the information is
saved on the program disk and a screen of instruction appears
(Figure 3). Use the UFBUD PRINT option to get a hard copy of the
crop identification catalog for future reference. Up to this
point you have only created a new budget name in the crop identi-
fication catalog, now you must create a new file.
FIGURE 2. Crop Identification Catalog
ENTER THE CROP NUMBER 7
CROP IDENT I F ICAT ION
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
(Press (Esc) then
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
CALt)M) for menu in case of error)
FIGURE 3. Instruction for Creating the Budget
1 Corn
2
3
4
5
6
7
8
9
10
11
12
13
14
15
File
r -
A 3 C D E
41
42
43 Instruction for Creating the Budget File
44
45 1) Choose the PRINT option to get a Listing of budgets.
46
47 2) Select the QUIT option.
48
49 3) Select the FILE-MANAGER option from the Lotus main menu.
50
51 4) Copy the source budget number to the new (destination) budget
52 number. Choose the filename "BLANK" as the source file to create a
53 blank budget.
54
55
56 ** FILE-MANAGER can also be used to rename, erase, and backup files.
57
58
59 **** (Press Return to continue) ******
60
i ii i__ ir i i I ------------- i i---i
__
Each budget file is given a special name that Lotus can
recognize. These names are BLANK.WKS, 1.WKS and 2.WKS on the
program disk and 3.WKS, 4.WKS, 5.WKS, etc., on subsequent
data disks. Understanding the file naming system is impor-
tant for creating the budget files that will be stored on data
disks.
The actual disk file name for any budget is its catalog
number followed by the extension .WKS. For example, the repre-
sentative corn budget that came on the original distribution
disk is the first budget on the crop identification catalog
and thus has a Lotus file name of 1.WKS. If you want to create a
budget for soybeans and have entered the name for the second
budget on the catalog its Lotus file name would be 2.WKS.
The original 2.WKS file is just a blank budget form. The
BLANK.WKS file will always remain a blank, or empty budget file.
You will use this file to create new files on data disks.
When you want to.create budget files on data disks you
will need to use the File Manager function on the Lotus Utility
disk. If you want to create a budget that is similar to an
existing budget it might be easier to make changes to the exis-
ting budget than to start from scratch.
For example, let's say that the file 2.WKS is a soybean
budget and that you want to create another soybean budget that
uses a different seeding and fertilizer rate. Lets also assume
that you have already entered a new name, ALTERNATIVE-SOYBN, as
budget three on the crop identification catalog. Since the
changes are minor data changes use File Manager to copy the file
2.WKS from the program disk to 2.WKS on a data disk.
Then use the RENAME function to change the new file name to
3.WKS.
When you return to UFBUD and select the ALTERNATIVE-SOYBN
budget the information for the old soybean budget appears. Now
you can make modifications without retyping all the data and save
the new budget using one of the save options (see page 34).
To create a budget file that is totally different from any
existing budget copy the file BLANK.WKS from the program disk
to a data disk and use the RENAME function to give it an
appropriate file name. With File Manager you can copy files from
the UFBUD program disk to a UFBUD data disk and from data
disks to data disks. For more information on how to use
the File Manager function see the Lotus owner's manual.
Hard drive users will find that file manipulation is easier
for them than for single or dual drive owners. If you plan on
actively using several different budgets a hard drive is
recommended.
Modify
The modify option lets you modify crop names that already
exist on the crop identification catalog. When you choose this
option you are free to move the cursor to any of the 45 name
locations. To make changes simply type in the new name and press
the enter key. Remember that if your name should start with a
number you must precede it with an apostrophe (').
To erase a budget name from the catalog just move the cursor
to the desired location, press the space bar once, then press the
enter key.
Any changes you make using the MODIFY option only affect the
crop identification catalog and do not affect the actual budget
file. For example, if you use the space bar to erase the name
for, say, budget number five, the actual disk file 5.WKS
still exists. To erase 5.WKS you can use the File Manager
function in Lotus to either erase it from the disk completely, or
change it by copying a new budget file over it.
Mach/Comp
If you want to make global changes to the machinery comple-
ment list use the MACH/COMP option. The machinery complement
list is a list of machinery and implements, like tractors, plows,
disks, etc., that you use in the production process. Each piece
of machinery has several technical variables associated with it
that allow UFBUD to calculate machinery costs and repairs for the
budget. The MACH/COMP option lets you make changes to the list
and have those changes available for use in any budget by select-
ing the RESET/MACH option from the Main Menu (see pages 34 and
35). The machinery complement list is explained in detail on
pages 22-25.
Print
As mentioned earlier, this option prints a copy of the crop
identification catlaog for future reference.
PROGRAM OVERVIEW
When a crop name is selected from the crop identification
catalog UFBUD will load that budget into memory and display the
main menu for that particular crop (Figure 4). A brief
overview of each menu option immediately follows. The remainder
of this user's manual will more fully explain each option.
FIGURE 4. MAIN MENU
Entering Data
Three menu selections are used for data input: PRODUCTION,
INPUTS and MACH USE. PRODUCTION records the type, amount and
timing of production. INPUTS records the type of operating
inputs used, the amount used, the price paid per unit, and when
the input was used. MACH USE is a machinery complement list used
to identify the machinery used in the production process and the
level of use.
Description:
Production Inputs Machinery Use Budget Cost/Mach Print Other
Enter production items, timing of quantities, and prices
I J K L M N 0 P
221 Description:
222 Corn Grain North Florida
223
224
225
226
227 U.F. Agricultural Budget Generator
228
229 with output in the
230
231 Oklahoma State University format.
232
233
234
235
236 Developed by FARM Lab,
237 Food and Resource Economics Department
238 Institute of Food and Agricultural Sciences
239 University Of Florida
240
j .i ; i i 'i ,
Generating Output
The next three menu selections on the MAIN MENU offer some
type of output. When the BUDGET option is selected the actual
budget is calculated and displayed on the monitor.The COST/MACH
menu selection is simply a summary of machinery use as recorded
in the MACH USE selection. The PRINT option offers you the
choice of printing the budget, the machinery use summary or the
complete machinery complement list.
Saving Your Work
The last menu selection, OTHER, lets you save your work for
future use. You may also choose to exit from the program without
saving any of your work. From the OTHER selection you can also
change the crop description, alter the default parameters used
in generating the budget and erase large blocks of data to
prepare for new data entry.
Disk Storage Space
UFBUD allows you to create and store up to 3 enterprise
budgets on a single data disk. To analyze more than 3
budgets format additional data disks and copy the appropriate
budget files as discussed under the CREATE option.
MAIN MENU SELECTION PRODUCTION
The PRODUCTION option records information pertaining to
revenue expected from production. Figures 5 and 6 show a sample
production input for a corn budget.
UFBUD first requires that you enter all production names in
the left hand column. Ten lines are provided. These lines are
for single crops that may produce more than one form of a sale-
able commodity, corn grain and corn forage for example. When all
the product names are entered press a "null return" to move the
cursor to the next section. A null return is obtained by pres-
sing the return key with no data input.
For each product listed in the first column enter the
quantity of product to be sold for the appropriate month. For
example, if you expect to harvest 75 bushels of corn in August
you would enter "75" under the column marked "AUG". Budgets are
easier to understand if they are prepared using a small produc-
tion unit, usually one acre. Therefore, even if you are planting
200 acres of corn you would analyze a budget based on one acre.
The price you expect to receive for your output is recorded
in the column labeled "PRICE". This is the dollar value per unit
sold. If you expect the local cash price for corn to be $2.40 in
September you would enter "2.40" in the PRICE column. Note that
the price must be in the same units used to record the quantity
of product sold. If you record corn production by the bushel
then you must price corn by the bushel.
The column labeled "UNIT CODE" is used to identify the name
of the units you have decided to use. For our corn example, we
have recorded the quantity and price in bushels so the entry for
the UNIT CODE column will be BU. You are free to decide on what
to enter for the unit code, provided that the number of charac-
ters entered does not exceed the column width, which is 9. For
example, bushels can be entered as "BU" or "BUSHEL".
The very last column "ITEM CODE" is for future versions of
UFBUD and can be ignored.
When all entries are made press a null return to go back to
the main menu.
FIGURE 5. Sample PRODUCTION Screen
A B C H I J K L
118
119
120
121 PRODUCTION, INPUTS,AND MACHINERY REQUIREMENTS
122 .............................................
123 # of Units
124 PRODUCTION MAY JUN. JUL. AUG. SEP.
125 ..................................................................
126 1 Corn 75.0
127 2
128 3
129 4
130 5
131 6
.132 7
133 8
134 9
135 10
136 ..................................................................
137 Rate/Unit
FIGURE 6. Sample PRODUCTION Screen (cont'd)
MAIN MENU SELECTION INPUTS
The INPUTS option records all the operating inputs needed to
produce the selected crop. Data entry for INPUTS is similar to
the PRODUCTION section. There are 27 lines available for identi-
fying operating inputs, these lines are numbered 11-37 (recall
that production names occupied lines 1-10). See Figures 7 and 8
for sample INPUTS screens.
As with the PRODUCTION section, you must enter all operating
input names into the left column before you can enter any other
information. If any of your operating input names begin with a
number start typing the entry with an apostrophe ('). The apos-
trophe indicates to 1-2-3 that you are entering a label name and
not an actual number. when all the names are entered press a
null return to continue.
Enter the amount of each input used in the appropriate month
column. For example, if you plant corn in April at the rate of
12 pounds per acre you would enter "12" under the column marked
"APR".
The price that you pay for each input is recorded in the
column labeled "PRICE". If you paid $0.75 per pound for corn
seed you would enter ".75" in the PRICE column. The price per
unit must be consistent with the rate per unit entered in the
month column. That is, if you measure corn seed by the pound
then you must also price it by the pound.
The units of measure are recorded in the "UNIT CODE" column.
This item is entered exactly as in the PRODUCTION section.
When you have made all your entries press a null return to
go back to the main menu.
FIGURE 7. Sample INPUTS Screen
FIGURE 8. Sample INPUTS Screen (cont'd)
A 8 C D E F G H
137 Rate/Unit
138 OPERATING INPUTS JAN. FEB. MAR. APR. MAY
139 ..... ...... .......... ................. ........* *
140 11 Seed 12
141 12 N-P-K 5.5
142 13 N 125
143 14 Lime 0.33
144 15 Insecticide 15
145 16 Herbicide 4
146 17
147 18
148 19
149 20
150 21
151 22
152 23
153 24
154 25
155 26
156 27
A B C M H 0 P 0
137 UNIT
138 OPERATING INPUTS OCT. NOV. DEC. PRICE CODE
139 .................................................-...........****
140 11 Seed 0.75 Lbs.
141 12 N-P-K 5.00 Cwt.
142 13 M 0.09 Lbs.
143 14 Lime 16.70 Tons
144 15 Insecticide 2.75 Lbs.
145 16 Herbicide 1.95 Lbs.
146 17
147 18
148 19
149 20
150 21
151 22
152 23
153 24
154 25
155 26
156 27
r
I
MAIN MENU SELECTION MACHINERY USE
The MACHINERY USE menu selection is a very detailed list of
79 pieces of machinery that can be used in the production pro-
cess. The user can add up to 21 additional pieces of machinery
for a total of 100. A sample printout of the complete machinery
complement list is located in Appendix B.
Lines 1-12 of the machinery complement list are reserved for
self-propelled machines such as tractors and trucks. These
machines will later be used as "power units". A power unit is
simply a machine that is used to pull an implement. Machines
listed in lines 1-12 have their use recorded in actual hours.
Lines 13-29 are reserved for self-propelled machines that
are not commonly used as power units. That is, they generally do
not pull implements, although it is possible. Combines and
harvesters fall into this category. Machines listed in these
lines have their use recorded as times over per acre as opposed
to actual hours used. All fuel consuming machines must be listed
in lines 1-29.
All implements that do not fall into the categories des-
cribed above belong in lines 30-100. These implements are "pull-
type", do not consume fuel and have their use recorded as
times over per acre.
As you look through the machinery complement list, place an
asterisk in the "FLAG" column as a reminder to yourself that this
piece of machinery is to be included in the budget. To erase an
unwanted asterisk locate the cursor at the desired position,
press the space bar once and then press the enter key. There are
15 columns associated with each machinery item. Each coefficient
is described in Appendix C.
When you have flagged each piece of machinery press a null
return to move the cursor into the coefficient section of the
complement list. If you want to change any of the default values
just move the cursor to the desired location and type in the
desired value. To save your changes for future use you must use
one of the save options provided under the OTHER main menu selec-
tion. Refer to Kletke for a detailed discussion of the machinery
complement coefficients.
As you check the coefficient values pay special attention to
five machinery coefficients. They are the initial list price,
hours used annually, years owned, purchase price and hours of
life. Value errors for these coefficients have an important
impact on the final budget results.
The initial list price is the suggested retail price for
that particular machine, NOT the purchase price, regardless if
the machine was purchased new or used. The hours used annually
is for machine use for the ENTIRE farm, not just a single enter-
prise. The years owned is the number of years that you EXPECT to
own this piece of machinery from the time of purchase, not how
many years you have owned it. The purchase price is the actual
price that youpaid for the machine, new or used. Finally, the
hours of life is the estimated life hours remaining when the item
was acquired.
The hours used and the hours of life are very important for
accurately calculating the budget. These numbers should be
double checked, especially if the budget solution is considerably
different from what was expected.
When the machinery complement list is completed to your
satisfaction press a null return to continue. The next section
records the timing and actual times over use of each piece of
"flagged" machinery.
There are thirteen lines available to list the names of all
the machinery you plan on using in the production process. Type
in the names of all the items that you marked with an asterisk in
the previous section. When all the names are listed press a null
return to begin entering the amount of use and timing for each
item.
Items from lines 1-12 of the machinery complement list have
their use recorded in actual hours used per acre NOT pulling an
implement. This is important since additional use will be allo-
cated for the implement. Items from lines 13-100 will have their
use recorded in actual number of times over per acre. All values
are entered for the month in which the use occurred.
The POWER UNIT column is only used for pull-type implements
and corresponds to the tractor (or, possibly truck) that is
pulling the particular implement. The value for the power unit
is simply the number in parentheses immediately following the
machinery name in the machinery complement list.
If an implement is being pulled by power unit #3 for exam-
ple, then tractor(3) must be included in the times over list even
if it is never used by itself. If tractor(3) is sometimes used
alone then that use would be recorded in actual hours on the
tractor(3) line. Record the times over per acre when pulling an
implement on the corresponding line for that implement.
The very last column is the ITEM CODE which you must type in
accurately. This code comes directly from the machinery comple-
ment list.
When all machinery use has been recorded press a null return
to go back to the main menu. See Figures 9-12 for a sample
partial machinery complement list and timeover machinery require-
ment list.
FIGURE 9. Sample Machinery Complement List
A B C D E F G H
MACHINERY COMPLEMENT
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Asterisk Width
Flag "** (feet)
55.0
* 83.0
100.0
125.0
150.0
175.0
0.0
0.0
0.0
* 2.0
* 0.5
0.0
16.0
20.0
0.0
* 14.0
Initial
List
Price
9200
13000
16750
19500
23750
27000
0
0
0
10800
4800
0
21250
23500
0
16000
Speed
(MPH)
4.5
4.5
4.5
4.5
4.5
4.5
0.0
0.0
0.0
20.0
20.0
0.0
3.0
3.0
0.0
3.0
Field
Efficiency
0.88
0.88
0.88
0.88
0.88
0.88
0.00
0.00
0.00
0.88
0.88
0.00
0.67
0.67
0.00
0.67
FIGURE 10. Sample Machinery Complement List (cont'd)
A B C D
MACHINERY COMPLEMENT
Code Name of
# Machine
27
28
29
30 MB Plow 4
31 MB Plow 6
32 MB Plow 5
33 MB Plow 7
34
35 Tandem Disk
36 Offset Disk
37 Offset Disk
38
39 Oneway
40 Sweep
41 Sweep
42 Chisel
Asterisk Width
Flag "*" (feet)
0.0
0.0
0.0
5.3
8.0
6.6
9.3
0.0
14.0
14.0
12.0
0.0
12.0
12.0
24.0
14.0
E F G H
Initial
List
Price
0
0
0
1200
3000
2550
3500
0
1300
3800
3600
0
1265
1300
3475
1400
Speed Field
(MPH) Efficency
0.0 0.00
0.0 0.00
0.0 0.00
4.5 0.80
4.1 0.80
4.5 0.80
4.5 0.80
0.0 0.00
4.8 0.83
4.8 0.83
4.8 0.83
0.0 0.00
4.8 1.00
3.8 0.76
4.5 0.76
4.1 0.80
Code Name of
# Machine
1 Tractor(1)
2 Tractor(2)
3 Tractor(3)
4 Tractor(4)
5 Tractor(5)
6 Tractor(6)
7
8
9
10 Truck
11 Pickup
12
13 SP Combine-Grain
14 SP Combine-Grain
15
16 SP Combine
FIGURE 11.
Sample Timeover Machinery Requirements
FIGURE 12.
Sample Timeover Machinery Requirements (cont'd)
A B C D E F G H
167 .................................. ....... --*.........-
168 TIMEOVER MACHINERY (times over)
169 REQUIREMENT JAN. FEB. MAR. APR. MAY
170 ............................ ..............................."
171 38 Tractor(2)
172 39 TRUCK
173 40 PICKUP 0.25 0.1 0.1
174 41 COMBINE
175 42 PLOW 1
176 43 DISK 3
177 44 CULTIVATOR 2
178 45 PLANTER 1
179 46 SPRAYER 1
180 47
181 48
182 49
183 50
184 zIz-azzIa UuI=uu us =ZZnZfuIuU UlUinUBinzinuuluzPu ilUU.
185
186
A B C N 0 P Q R
167 ............---------------------------...........................................
168 TIMEOVER MACHINERY Power Unit
169 REQUIREMENT NOV. DEC. / Labor CODE
170 ............................-......................... #
171 38 Tractor(2) 2
172 39 TRUCK 10
173 40 PICKUP 11
174 41 COMBINE 16
175 42 PLOW 2 31
176 43 DISK 2 35
177 44 CULTIVATOR 2 45
178 45 PLANTER 2 65
179 46 SPRAYER 2 74
180 47
181 48
182 49
183 50
184 UIII... ,....IIII .I ..1 .1lH l li ..
185
186
I_____________
MAIN MENU SELECTION BUDGET
The BUDGET option of the main menu calculates the actual
budget. This option must be chosen before you print the budget
or use the COST/MACH option to make sure that you are getting the
most current version of your budget. As we discuss the budget
solution refer to Figures 13-15 for a sample budget output.
The budget takes several seconds to calculate during which
time you will see what appears to be "garbage" flickering on the
monitor screen. This is normal activity and soon the first
screen of the budget will appear (Figure 13).
There are 5 columns to the budget. The first column,
Category, separates revenue items from expense and return items
as well as identifying specific items in each category. The
second column, Units, identifies the unit of measure (eg. bus-
hels, pounds, acre). The Price column is the price received or
paid per unit for an item. The Quantity column is the amount of
production or level of use for an input. The last column, Value,
is the revenue or expense for an item per one unit of production,
usually one acre. The Value is calculated at by multiplying the
Price column by the Quantity column.
The number of rows in a budget will vary depending on the
number of production and operating items you entered in the
PRODUCTION and INPUTS sections. Our example corn budget only has
one production item, corn. The units, price and quantity were
obtained from the PRODUCTION information. Since we only have one
product the total receipts equal the value of the corn produc-
tion. If we had several products the total receipts would be the
sum of all the product values.
All the operating inputs are listed in the next budget
category. The first items listed are the inputs that you entered
in the INPUTS section. The units, price and quantity all corres-
pond to information entered previously. The quantity is a sum
over all months. The value of the input is calculated by multi-
plying the price by the quantity.
Four additional operating inputs are generated from the
timeover machinery list. They are fuel and lubrication expenses
for tractors and equipment and repair cQsts for tractors and
equipment.
The total operating cost is the sum of the values for each
individual input. When we subtract the total operating costs
from total receipts we arrive at the returns to land, labor,
capital, machinery, overhead, risk and management. This is also
sometimes referred to as the return above variable costs. Or, in
other words, the revenue that remains after paying all the opera-
ting inputs goes to fixed costs and management.
For the equations needed to calculate the following techni-
cal costs refer to Kletke.
Three items comprise the capital cost category. The annual
operating capital is the cost of borrowing money to pay for
inputs. This value is calculated using an algorithm that
basically assumes a normal distribution of operating expenses
around the fourth month before harvest. That is, on average
inputs are purchased within a four month period prior to harvest.
The tractor investment and equipment investment are gene-
rated using technical equations based on the information supplied
in the machinery complement list. These two values attempt to
accurately estimate the true value of the interest-investment in
tractors and equipment.
The total interest charge is the sum of the three capital
costs. When we subtract the interest charge from the previous
return value we arrive at the returns to land, labor, machinery,
overhead, risk and management.
The cost of ownership (depreciation, taxes, insurance) is
the next cost to be subtracted from the returns value. The cost
of ownership for tractors and equipment relate to the actual
dollar value of owning the asset and NOT the value for income tax
purposes. Therefore, the depreciation is calculated based on
estimates for useful life, repairs and anticipated level of use
and not on the IRS accelerated cost recovery system.
Once the ownership costs are subtracted we can subtract the
cost of labor. This value is based on the hours of machinery use
and hourly wages. After this value is calculated and subtracted
we have the final budget solution--the return to land, overhead,
risk and management. This value is what the manager is paid for
his managerial skills, plus a payment for land ownership, over-
head for operating the business and responsibility for assuming
the risk associated with the production of a commodity.
If the budget solution is considerably different than what
you expected, check the values that you entered in the
PRODUCTION, INPUTS and MACHINERY USE sections. Verify that the
numbers used are the ones you meant to use and that all produc-
tion and input items have been recorded. As mentioned earlier,
also check the hours used annually for each piece of machinery
used.
Keep in mind that a budget does not have to have positive
returns to be useful. You are better knowing prior to planting
that a crop may lose money, when you have time to do something
about it, than after harvest, when it is too late.
FIGURE 13. Sample Budget Solution
A B C D E F G H
186
187 CATEGORY UNITS PRICE QUANTITY VALUE
188 .......................... ....................................
189 PRODUCTION:
190 Corn BU. 2.40 75.00 180.00
191 TOTAL RECEIPTS 180.00
192 ......--........................................................
193 OPERATING INPUTS:
194 Seed Lbs. 0.75 12.00 9.00
195 N-P-K Cwt. 5.00 5.50 27.50
196 N Lbs. 0.09 125.00 11.25
197 Lime Tons 16.70 0.33 5.51
198 Insecticide Lbs. 2.75 15.00 41.25
199 Herbicide Lbs. 1.95 4.00 7.80
200 Tractor, Fuel & Lub. Acre 8.07
201 Tractor repair cost Acre 1.64
202 Equip. FueL & Lub. Acre 4.36
203 Equip. Repair Cost Acre 1.81
204 TOTAL OPERATING COSTS 118.20
205 ..................................................................
FIGURE 14. Sample Budget Solution (cont'd)
A B C D E F G H
186
187 CATEGORY UNITS PRICE QUANTITY VALUE
188 ................. .....................****** **** ****** **--
206 RETURNS TO LAND, LABOR, CAPITAL, MACHINERY,
207 OVERHEAD, RISK AND MANAGEMENT 61.80
208 ----.....-........................................................
209 CAPITAL COST:
210 Annual Operating Capital 0.10 39.40 3.94
211 Tractor Investment 0.10 26.88 2.69
212 Equipment Investment 0.10 47.96 4.80
213 TOTAL INTEREST CHARGE 11.42
214 ..................................................................
215 RETURNS TO LAND, LABOR, MACHINERY
216 OVERHEAD, RISK AND MANAGEMENT 50.38
217 ..................................................................
218 OWNERSHIP COST: (DEPRECIATION,
219 TAXES, INSURANCE)
220 Tractor Hr. 4.00
221 Equipment Hr. 8.29
222 TOTAL OWNERSHIP COST 12.28
i i i _____ii_,, _i, ______,________,
FIGURE 15. Sample Budget Solution (cont'd)
A B C D E F G H
186
187 CATEGORY UNITS PRICE QUANTITY VALUE
188 .........-........................................................
224 RETURNS TO LAND,LABOR,OVERHEAD,
225 RISK AND MANAGEMENT 38.10
226 ------------........................................................
227 LABOR COST:
228 Machinery Labor Hr. 3.25 3.76 12.22
229 Other Labor Hr. 0.00 0.00 0.00
230 TOTAL LABOR COST 12.22
231 .............................e..........................
232 RETURNS TO LAND, OVERHEAD,
233 RISK AND MANAGEMENT 25.88
234 ..................................................................
235
236
237
238
239
240
00
MAIN MENU SELECTION COST/MACH
The COST/MACH option is a subset of the machinery complement
list that includes all the machinery entered in the machinery
requirements section. The purpose of this list is to provide you
with a quick reference of the machinery used in the production
process and to show the itemized cost per hour and acre.
Since the BUDGET option updates the machinery subset list
you must chose the BUDGET option prior to the COST/MACH option to
get a current list of machinery used in the production process.
You can use this machinery subset list to check your coeffi-
cient values for accuracy. If you want to make changes to any of
the coefficients you must return to the MACHINERY USE option to
make your changes.
See Figures 16-19 for a partial printout of a machinery
subset list.
FIGURE 16. Sample Machinery Subset List
FIGURE 17. Sample Machinery Subset List (cont'd)
I I
Y Z
AG AH A! AJ AK AL
Machinery Subset
Code Nam of
# Machine
2 Tractor(2)
10 Truck
11 Pickup
16 SP Combine
31 MB Plow 6
35 Tandem Disk
45 Row Cultivator
65 Planter
74 Sprayer
RC1 RC2
1.20 0.000631
0.80 0.000631
0.60 0.000631
0.33 0.000251
2.00 0.000251
0.65 0.000251
1.00 0.000251
0.80 0.000631
0.65 0.000251
Hours
Used
RC3 Annually
1.60 600
1.40 500
1.40 500
1.80 100
1.30 167
1.80 100
1.80 100
1.60 60
1.80 50
FIGURE 18.
Y Z
Sample Machinery Subset List (cont'd)
AM AN AO AP AQ AR
Machinery Subset
Code Name of
# Machine
2 Tractor(2)
10 Truck
11 Pickup
16 SP Combine
31 MB Plow 6
35 Tandem Disk
45 Row Cultivator
65 Planter
74 Sprayer
Purchase
RFV2 Price
0.920 13000
0.860 10800
0.885 4400
0.895 13750
0.885 3000
0.885 1200
0.885 1200
0.885 2200
0.885 255
Fuel Hours of
Type Life
3 12000
1 4000
1 4000
3 1500
0 2000
0 2000
0 2000
0 1200
0 1000
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Years
Owned
0.680
0.670
0.600
0.635
0.600
0.600
0.600
0.600
0.600
4
:5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Fue
Gas
0.068
4.000
2.500
4.390
Horse
Power
83
1
1
1
0
0
0
0
0
L
FIGURE 19.
Sample Machinery Subset List (cont'd)
Y Z AS AT AU AV AW AX
1
2 Machinery Subset
3 Total
4 Code Name of Depre- Insur- Fixed
5 # Machine LPG Diesel citation ance Tax Costs
6 2 Tractor(2) 0.080 0.048 1.53 0.13 0.43 2.09
7 10 Truck 4.710 2.780 2.16 0.12 0.43 2.71
8 11 Pickup 2.940 1.740 0.83 0.05 0.18 1.05
9 16 SP Combine 5.160 3.050 10.40 0.77 2.75 13.92
10 31 MB Plow 6 1.08 0.09 0.36 1.53
11 35 Tandem Disk 0.97 0.06 0.24 1.27
12 45 Row Cultivator 0.99 0.06 0.24 1.29
13 65 Planter 3.02 0.19 0.73 3.95
14 74 Sprayer 0.40 0.03 0.10 0.53
15 0.00 0.00 0.00 0.00
16 0.00 0.00 0.00 0.00
17 0.00 0.00 0.00 0.00
18 0.00 0.00 0.00 0.00
19 0.00 0.00 0.00 0.00
20
MAIN MENU SELECTION PRINT
The PRINT option on the main menu allows you to print a
hard copy of your budget results, the machinery complement list
and the machinery subset list. See Figure 20 for a sample of the
print menu screen. Sample printouts appear in Appendix B.
Before printing be sure that your printer is on and that the
paper is at the top of a form. If your printer is not turned on
Lotus will pretend that it is printing then return you to the
main menu.
The print routine has been established for IBM printers and
Epson printers using decimal 015 as the code for compressed
print. If your printer normally prints 80 characters and uses
another decimal value for compressed print refer to the section
on advanced techniques for information on modifying the program.
FIGURE 20. Sample Print Menu Screen
Description:
Budget Machines Used Machinery Complement List Return
Print the commodity budget on a per acre basis
I J K L M N 0 P
221 Description:
222 Corn Grain North Florida
223
224
225
226
227 U.F. Agricultural Budget Generator
228
229 with output in the
230
231 Oklahoma State University format.
232
233
234
35
236 Developed by FARM Lab,
237 Food and Resource Economics Department
238 Institute of Food and Agricultural Sciences
239 University Of Florida
240
i i i iii i i
MAIN MENU SELECTION OTHER
The OTHER option has a submenu with several additional menu
choices. See Figure 21 for a submenu screen. This option allows
you to save your work and continue (SAVE ONLY), save your work
and exit UFBUD (SAVE & EXIT) or, exit UFBUD without saving your
work (EXIT ONLY).
In addition the OTHER option lets you change the crop
description that appears at the top of the budget title page
(DESCRIBE), change the default parameters (PARAMETERS), clear
out large sections of the PRODUCTION, INPUTS and Timeover
Machinery Requirements sections for creating new budgets (CLEAR)
and select your customized machinery complement list for use in
the current budget (RESET/MACH).
The default parameters are shown in Figure 22 These
figures are used to calculate several values in the final budget.
To change any of these values just choose the PARAMETERS option,
move the cursor to the value you want to change and type in the
new value. This value will return to the default value unless
you save your work using one of the two save options provided in
this section.
Use the CLEAR option when you want to erase entries made in
the PRODUCTION, INPUTS and Timeover Machinery Requirements sec-
tions. This option is useful when you have budget information
that you no longer need and want to create a new budget that is
substantially different from the old one. (You could also use
the Lotus File Manager to copy a blank budget form over the
existing budget.) Sometimes if you only want to make minor
changes it is better to just type over individual entries since
the CLEAR option will essentially leave you with a blank work-
sheet.
Use the RESET/MACH option if you have made changes to the
global machinery complement list using the MACH/COMP option on the
SELECT/CREATE/MODIFY Menu and want to use those changes in your
current budget worksheet. If you do not use the RESET/MACH option
the machinery complement list will use the current default values.
You may of course change these values as discussed earlier, see
pages 22-25. However, if you make several changes that you want to
use in all of your budgets, the MACH/COMP and RESET/MACH options
will save you time.
FIGURE 21. Sample OTHER Submenu Screen
Description:
Return Describe Parameters Reset/Mach Clear Save Save/Exit Exit Only
Return to the Main menu
I J K L M N 0 P.
221 Description:
222 Corn Grain North Florida
223
224
225
226
227 U.F. Agricultural Budget Generator
228
229 with output in the
230
231 Oklahoma State University format.
232
233
234
235
236 Developed by FARM Lab,
237 Food and Resource Economics Department
238 Institute of Food and Agricultural Sciences
239 University Of Florida
240
i .i i i i i i
FIGURE 22. Sample Parameter Values
METERS
******
Price per Gallon of Gasoline
Price per Gallon of L. P. Gas
Price per Gallon of Diesel
Price per Kilowatt Hour of Electricity
Price for first 1000 cu. ft.
of Natural Gas
Interest Rate
Insurance Rate(price/S of Average
Investment Insured)
Tax Rate (price/$ of Purchase Value)
Price of Machinery Labor/Hours
Price of Other Labor/Hours
0.95
0.70
0.92
0.055
2.65
0.10
0.009
0.02
3.25
3.00
R S T U V U X
230
231 PARA
232 ....
233 1.
234 2.
235 3.
236 4.
237 5.
238
239 6.
240 7.
241
242 8.
243 9.
244 10.
245
246
247
248
249
r 1
a
ADVANCED TECHNIQUES
Changing the Print Code
Before attempting to make any changes to the program code be
sure that you are working with a back-up copy. Each budget will
need to be altered in the same way. If you have a printer that
normally prints 132 characters across these changes are not
necessary unless you wish your output to be on standard size
paper.
From the main menu page press the key
sequence. Control is now at the Lotus command level. Move the
cursor to cell J214. This can be done using the arrow keys or
the "goto" command. Edit this cell and change the 015 to the
decimal value that will make your printer turn on compressed
print. Now move the cursor to cell K214 and make the same
change. Be sure that you only change the 015 segment and nothing
else.
When you have made these two changes press the <0> key
sequence. (This is the letter "o" not the number zero.) Select
the OTHER option and use one of the two save options to save
these changes permanently. Now when you print your results using
the PRINT option your printer will switch to compressed print
mode when appropriate. Other commands in the UFBUD program
code will turn compressed print off regardless of your printer
type.
It must be stressed here that you should only go to the two
cell addresses identified. Do not attempt to change any of the
other macros unless you are an experienced Lotus user and are
working with a back-up program copy.
The authors advise against changing any of the calculations
or macro commands unless you are an experienced Lotus user and
experienced in creating farm budgets.
ORDERING INFORMATION
For more information on this and other IFAS microcomputer
software contact your county extension agent or write to:
IFAS Software Communication and Distribution
G022 McCarty Hall
University of Florida
Gainesville, FL 32611
REFERENCES
Kay, Ronald D. Farm Management Planning, Control, and
Implementation. New York: McGraw-Hill Book Company, 1981.
Kletke, Darrel. "Oklahoma State University Budget Generator
User's Guide". Department of Agricultural Economics, Oklahoma
State University, Stillwater, Oklahoma. 1979.
Melton, Bryan E. "A Users Manual for the FARM Systems Lab
Crop Budget Generator". Economic Information Report 126. Food and
Resource Economics Department, Institute of Food and Agricultural
Sciences, University of Florida, Gainesville, Florida. February
1980.
Osburn, Donald D. and Schneeberger, Kenneth C. Modern
Agriculture Management. Reston, Virginia: Reston Publishing
Company, Inc., 1978.
APPENDIX A.
Lotus Compatible Computers
The following is a listing of the computers with which LOTUS 1-2-3 is compatible.
IBM PC
IBM XT
COMPAQ
TEXAS INSTRUMENTS PC
ZENITH Z-100
BYTEC HYPERION
DEC RAINBOW 100
DEC RAINBOW 100+
WANG PC
GRID COMPASS
HEWLETT PACKARD 150
IBM 3270 PC
TANDY MODEL 2000
*By using a HERCULES
monochrome display.
**The only printers supported
are DEC LA50 and DEC LA100.
with DEC is the HP 7470A.
Immediately*
Immediately*
Immediately
Immediately
Immediately (Zenith produces and supports
this version of 1-2-3. For further informa-
tion call Zenith at 800-447-4700).
Immediately (Call Bytec at 613-226-7013
for nearest dealer).
Immediately**
Immediately**
Immediately
Immediately
Immediately (HP produces and supports
this version of 1-2-3. Call HO at
800/FOR-HPPC for nearest dealer).
Immediately
Mid-1984
GRAPHICS CARD you may obtain graphics on an IBM
for the RAINBOW for either text on an IBM
The only plotter supported for graphics
The following peripherals are supported for graphics in LOTUS 1-2-3.
HEWLETT PACKARD HP 7470A PLOTTER
EPSON MX 80 AND MX 100 WITH GRAFTAX PLUS
IDS PRISM 80 AND 132 COLOR PRINTERS
OKIDATA MICROLINE SERIES (82A, 83A, 84 (STEP 2), 92, 93) PRINTERS
ANADEX 9620A SILENT SCRIBE PRINTER
NEC 8023 PRINTER
STROBE M100 and M200 COLOR PLOTTERS
ENTER SWEET P COLOR PLOTTER
IBM GRAPHICS PRINTER
EPSON FX80 PRINTER
In addition, the following peripherals are supported in a new PrintGraph Printer
Library, which is currently available for the IBM PC and XT, COMPAQ, TEXAS INSTRU_
MENTS PC, and WANG PC from you local 1-2-3 dealer:
AMDEX AMPLOT II 6-PEN PLOTTER
C. ITOH 8510 SERIES PRINTER
CALCOMP MODEL 84 8-PEN PLOTTER
CANON A-1210 COLOR INKJET PRINTER
DEC LA100 PRINTER
DIABLO MODEL C COLOR INKJET PRINTER
EPSON FX100 PRINTER
GE/FENICOM 3000 COLOR AND B&W PRINTERS
HEWLETT PACKARD HP 7475A 6-PEN PLOTTER
HOUSTON INSTRUMENTS DMP-29 8-PEN PLOTTER
IBM XY/749 8-PEN PLOTTER
INFORUNNER RITEMAN PRINTER
INFOSCOPE 1200 COLOR PRINTER
MPI PRINTMATE 150 PRINTER
PRINTEX 920 PRINTER
PRINTRONIK MVP 150B PRINTER
TEXAS INSTRUMENTS TI850 PRINTER
TOSHIBA P1350 PRINTER
TRANSTAR T315 COLOR PRINTER
An integrated LOTUS product for the APPLE-MACINTOSH computer will be available
in the fourth quarter of 1984.
LOTUS SYMPHONY, an open-ended integrated software package, which combines
word-processing, communications, spreadsheet, database, graphics, command
language, and window management, will be available for the IBM PC and IBM
XT in July of 1984.
*The above information was provided by LOTUS Corporation.
APPENDIX B.
Sample Printouts
Corn Grain North Florida
CATEGORY UNITS PRICE QUANTITY VALUE
------------------------------------------------------
PRODUCTION:
Corn BU. 2.40 75.00 180.00
TOTAL RECEIPTS 180.00
--------------------------------------------------------------------
OPERATING INPUTS:
Seed Lbs. 0.75 12.00 9.00
N-P-K Cwt. 5.00 5.50 27.50
N Lbs. 0.09 125.00 11.25
Lime Tons 16.70 0.33 5.51
Insecticide Lbs. 2.75 15.00 41.25
Herbicide Lbs. 1.95 4.00 7.80
Tractor, Fuel & Lub. Acre 8.07
Tractor repair cost Acre 1.64
Equip. Fuel & Lub. Acre 4.36
Equip. Repair Cost Acre 1.81
TOTAL OPERATING COSTS 118.20
--------------------------------------------------------------------
RETURNS TO LAND, LABOR, CAPITAL, MACHINERY,
OVERHEAD, RISK AND MANAGEMENT 61.80
----------------------------- -------------------------------------
CAPITAL COST:
Annual Operating Capital 0.10 39.40 3.94
Tractor Investment 0.10 26.88 2.69
Equipment Investment 0.10 47.96 4.80
TOTAL INTEREST CHARGE 11.42
--------------------------------------------------------------------
RETURNS TO LAND, LABOR, MACHINERY
OVERHEAD, RISK AND MANAGEMENT 50.38
--------------------------------------------------------------------
OWNERSHIP COST: (DEPRECIATION,
TAXES, INSURANCE)
Tractor Hr. 4.00
Equipment Hr. 8.29
TOTAL OWNERSHIP COST 12.28
--------------------------------------------------------------------
RETURNS TO LAND,LABOR,OVERHEAD,
RISK AND MANAGEMENT 38.10
--------------------------------------------------------------------
LABOR COST:
Machinery Labor Hr. 3.25 3.76 12.22
Other Labor Hr. 0.00 0.00 0.00
TOTAL LABOR COST 12.22
--------------------- -------------------------------------------------
RETURNS TO LAND, OVERHEAD,
RISK AND MANAGEMENT 25.88
------------------------------- -----------------------------------
Machinery Subset
Code Name of
# Machine
2 Tractor(2)
10 Truck
11 Pickup
16 SP Combine
31 MB Plow 6
35 Tandem Disk
45 Row Cultivator
65 Planter
74 Sprayer
Initial Hours
Asterisk Width List Speed Field Used Years
Flag "*" (feet) Price (MPH) Efficency RC1 RC2 RC3 AnnualLy Owned RFV1
* 83.0 13000 4.5 0.88 1.20 0.000631 1.60 600 10.0 0.680
* 2.0 10800 20.0 0.88 0.80 0.000631 1.40 500 8.0 0.670
* 0.5 4800 20.0 0.88 0.60 0.000631 1.40 500 8.0 0.600
* 14.0 16000 3.0 0.67 0.33 0.000251 1.80 100 10.0 0.635
* 8.0 3000 4.1 0.80. 2.00 0.000251 1.30 167 15.0 0.600
* 14.0 1300 4.8 0.83 0.65 0.000251 1.80 100 10.0 0.600
* 12.0 1200 3.8 0.76 1.00 0.000251 1.80 100 10.0 0.600
* 12.0 2200 5.0 0.67 0.80 0.000631 1.60 60 10.0 0.600
* 12.0 300 3.8 0.60 0.65 0.000251 1.80 50 10.0 0.600
Machinery Subset
Fuel Consumption | Total
Code Name of Purchase Fuel Hours of Horse Multipliers j Depre- Insur- Fixed
# Machine RFV2 Price Type Life Power Gas LPG Diesel ciation ance Tax Costs
2 Tractor(2) 0.920 13000 3 12000 83 0.068 0.080 0.048 1.53 0.13 0.43 2.09
10 Truck 0.860 10800 1 4000 1 4.000 4.710 2.780 2.16 0.12 0.43 2.71
11 Pickup 0.885 4400 1 4000 1 2.500 2.940 1.740 0.83 0.05 0.18 1.05
16 SP Combine 0.895 13750 3 1500 1 4.390 5.160 3.050 10.40 0.77 2.75 13.92
31 MB Plow 6 0.885 3000 0 2000 0 1.08 0.09 0.36 1.53
35 Tandem Disk 0.885 1200 0 2000 0 0.97 0.06 0.24 1.27
45 Row Cultivator 0.885 1200 0 2000 0 0.99 0.06 0.24 1.29
65 Planter 0.885 2200 0 1200 0 3.02 0.19 0.73 3.95
74 Sprayer 0.885 255 0 1000 0 0.40 0.03 0.10 0.53
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
Machinery Subset
Total
Code Name of Variable
# Machine Repair Fuel Lub. Costs Interest Hr./Time
2 Tractor(2) 0.86 3.67 0.55 5.07 1.40 1.00
10 Truck 0.86 3.80 0.57 5.23 1.30 1.00
11 Pickup 0.29 2.38 0.36 3.02 0.55 1.00
16 SP Combine 2.54 2.81 0.42 5.77 8.55 0.29
31 MB Plow 6 0.32 0.00 0.00 0.32 0.98 0.31
35 Tandem Disk 0.24 0.00 0.00 0.24 0.71 0.15
45 Row'Cultivator 0.34 0.00 0.00 0.34 0.71 0.24
65 Planter 0.97 0.00 0.00 0.97 2.16 0.21
74 Sprayer 0.11 0.00 0.00 0.11 0.31 0.30
0.00 0.00 0.00 0.00 0.00 1.00
0.00 0.00 0.00 0.00 0.00 1.00
0.00 0.00 0.00 0.00 0.00 1.00
0.00 0.00 0.00 0.00 0.00 1.00
0.00 0.00 0.00 0.00 0.00 1.00
Fuel,Oft Fixed cost Tractor
Pow. Item Times Labor Machine Lub,Rep. (Int.Depr Fuel Invest- Owner-
Operation Unit Codes Over Hours Hours per Acre per Acre & Lub. Repairs ment ship
Tractor(2) 2 0.00 0.000 0.000 0.00 0.00 0.00 0.00 0.00 0.00
Truck 10 0.25 0.300 0.250 1.31 1.00 0.00 0.00 0.00 0.00
Pickup 11 0.85 1.020 0.850 2.57 1.36 0.00 0.00 0.00 0.00
SP Combine 16 1.00 0.352 0.293 1.69 6.59 0.00 0.00 0.00 0.00
MB Plow 6 2 31 1.00 0.377 0.314 1.86 2.00 1.46 0.30 0.49 0.72
Tandem Disk 2 35 3.00 0.532 0.444 2.58 2.59 2.06 0.42 0.68 1.02
Row Cultivator 2 45 2.00 0.571 0.476 2.82 2.78 2.21 0.45 0.73 1.09
Planter 2 65 1.00 0.246 0.205 1.34 2.04 0.95 0.19 0.32 0.47
Sprayer 2 74 1.00 0.362 0.302 1.72 1.41 1.40 0.28 0.47 0.69
0.00 0.000 0.000 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.000 0.000 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.000 0.000 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.000 0.000 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.000 0.000 0.00 0.00 0.00 0.00 0.00 0.00
3.761 3.134 15.884 19.765 8.072 1.643 2.688 3.996
Machinery__
Pow. Item Times Labor Machine Fuel Invest- Owner-
Operation Unit Codes Over Hours Hours & Lub. Repairs ment ship
Tractor(2) 2 0.00 0.000 0.000 0.00 0.00 0.00 0.00
Truck 10 0.25 0.300 0.250 1.09 0.21 0.32 0.68
Pickup 11 0.85 1.020 0.850 2.32 0.24 0.47 0.90
SP Combine 16 1.00 0.352 0.293 0.95 0.75 2.51 4.08
MB Plow 6 2 31 1.00 0.377 0.314 0.00 0.10 0.31 0.48
Tandem Disk 2 35 3.00 0.532 0.444 0.00 0.11 0.32 0.57
Row Cultivator 2 45 2.00 0.571 0.476 0.00 0.16 0.34 0.61
Planter 2 65 1.00 0.246 0.205 0.00 0.20 0.44 0.81
Sprayer 2 74 1.00 0.362 0.302 0.00 0.03 0.09 0.16
0.00 0.000 0.000 0.00 0.00 0.00 0.00
0.00 0.000 0.000 0.00 0.00 0.00 0.00
0.00 0.000 0.000 0.00 0.00 0.00 0.00
0.00 0.000 0.000 0.00 0.00 0.00 0.00
0.00 0.000 0.000 0.00 0.00 0.00 0.00
3.761 3.134 4.360 1.809 4.796 8.286
MACHINERY COMPLEMENT
Code Name of
# Machine
1 Tractor(1)
Initial
Asterisk Width List Speed Field
Flag "*" (feet) Price (MPH) Efficency RC1
2 Tractor(2) *
3 Tractor(3)
4 Tractor(4)
5 Tractor(5)
6 Tractor(6)
7
8
9
10 Truck *
11 Pickup *
12
13 SP Combine-Grain
14 SP Combine-Grain
15
16 SP Combine *
17
18 SP Swather
19 SP Swather
20 SP Baler
21 SP Bale Wagon
22 Forage Harvestor
23
24 Cotton Stripper
25
26 Cotton Picker
27
28
29
30 MB Plow 4
31 MB Pow 6 *
32 MB Plow 5
33 MB Plow 7
34
35 Tandem Disk *
36 Offset Disk
37 Offset Disk
38
39 Oneway
40 Sweep
41 Sweep
42 Chisel
43 Offset Disk
44 Roll. Cultivator
45 Row Cultivator *
46 Field Cultivator
47
48 Lister
49
50 Hiller
51 Cultibedder Till
55.0 9200
83.0 13000
100.0 16750
125.0 19500
150.0 23750
175.0 27000
0.0 0
0.0 0
0.0 0
2.0 10800
0.5 4800
0.0 0
16.0 21250
20.0 23500
0.0 0
14.0 16000
0.0 0
14.0 10300
16.0 11300
12.0 4500
24.0 15430
6.0 6000
0.0 0
12.0 19500
0.0 0
6.0 19500
0.0 0
0.0 0
0.0 0
5.3 1200
8.0 3000
6.6 2550
9.3 3500
0.0 0
14.0 1300
14.0 3800
12.0 3600
0.0 0
12.0 1265
12.0 1300
24.0 3475
14.0 1400
16.0 4300
12.0 1380
12.0 1200
24.0 1400
0.0 0
12.0 737
0.0 0
12.0 900
18.0 1895
0.0 0
Hours
Used Years
RC2 RC3 Annually Owned RFV1 RFV2
4.5 0.88 1.20 0.000631
4.5 0.88 1.20 0.000631
4.5 0.88 1.20 0.000631
4.5 0.88 1.20 0.000631
4.5 0.88 1.20 0.000631
4.5 0.88 1.20 0.000631
0.0 0.00 0.00 0.000000
0.0 0.00 0.00 0.000000
0.0 0.00 0.00 0.000000
20.0 0.88 0.80 0.000631
20.0 0.88 0.60 0.000631
0.0 0.00 0.00 0.000000
3.0 0.67 0.33 0.000251
3.0 0.67 0.33 0.000251
0.0 0.00 0.00 0.000000
3.0 0.67 0.33 0.000251
0.0 0.00 0.00 0.000000
5.4 0.77 1.00 0.002510
5.0 0.77 1.00 0.000251
3.0 0.74 0.85 0.002510
11.5 0.40 1.00 0.000251
4.0 0.60 1.20 0.002510
0.0 0.00 0.00 0.000000
3.0 0.60 0.75 0.000251
0.0 0.00 0.00 0.000000
3.0 0.63 0.75 0.000251
0.0 0.00 0.00 0.000000
0.0 0.00 0.00 0.000000
0.0 0.00 0.00 0.000000
4.5 0.80 2.00 0.002510
4.1 0.80 2.00 0.000251
4.5 0.80 2.00 0.000251
4.5 0.80 2.00 0.000251
0.0 0.00 0.00 0.000000
4.8 0.83 0.65 0.000251
4.8 0.83 0.65 0.000251
4.8 0.83 0.65 0.000251
0.0 0.00 0.00 0.000000
4.8 1.00 0.65 0.000251
3.8 0.76 1.00 0.000251
4.5 0.76 1.00 0.000251
4.1 0.80 0.65 0.000251
4.8 0.83 0.65 0.000251
4.5 0.76 1.00 0.000251
3.8 0.76 1.00 0.000251
3.8 0.76 1.00 0.000251
0.0 0.00 0.00 0.000000
4.0 0.67 0.80 0.000631
0.0 0.00 0.00 0.000000
4.0 0.67 0.80 0.000631
5.0 0.80 1.00 0.000251
0.0 0.00 0.00 0.000000
1.60
1.60
1.60
1.60
1.60
1.60
0.00
0.00
0.00
1.40
1.40
0.00
1.80
1.80
0.00
1.80
0.00
1.30
1.30
1.30
1.40
1.30
0.00
1.80
0.00
1.80
0.00
0.00
0.00
1.30
1.30
1.30
1.30
0.00
1.80
1.80
1.80
0.00
1.80
1.80
1.80
1.80
1.80
1.80
1.80
1.80
0.00
1.60
0.00
1.60
1.80
0.00
10.0 0.680 0.920
10.0 0.680 0.920
10.0 0.680 0.920
10.0 0.680 0.920
10.0 0.680 0.920
10.0 0.680 0.920
0.0 0.000 0.000
0.0 0.000 0.000
0.0 0.000 0.000
8.0 0.670 0.860
8.0 0.600 0.885
0.0 0.000 0.000
10.0 0.635 0.895
10.0 0.635 0.895
0.0 0.000 0.000
10.0 0.635 0.895
0.0 0.000 0.000
8.0 0.660 0.880
8.0 0.660 0.880
10.0 0.560 0.885
10.0 0.560 0.885
10.0 0.560 0.885
0.0 0.000 0.000
10.0 0.585 0.875
0.0 0.000 0.000
15.0 0.585 0.875
0.0 0.000 0.000
0.0 0.000 0.000
0.0 0.000 0.000
10.0 0.600 0.885
15.0 0.600 0.885
10.0 0.600 0.885
6.0 0.600 0.885
0.0 0.000 0.000
10.0 0.600 0.885
10.0 0.600 0.885
10.0 0.600 0.885
0.0 0.000 0.000
10.0 0.600 0.885
20.0 0.600 0.885
10.0 0.600 0.885
10.0 0.600 0.885
10.0 0.600 0.885
8.0 0.600 0.885
10.0 0.600 0.885
10.0 0.600 0.885
0.0 0.000 0.000
10.0 0.600 0.885
0.0 0.000 0.000
10.0 0.600 0.885
10.0 0.600 0.885
0.0 0.000 0.000
MACHINERY COMPLEMENT
Code Name of
# Machine
1 Tractor(l)
2 Tractor(2)
3 Tractor(3)
4 Tractor(4)
5 Tractor(S)
6 Tractor(6)
7
-8
9
10 Truck
11 Pickup
12
13 SP Combine*Grain
14 SP Combine-Grain
15
16 SP Combine
17
18 SP Swather
19 SP Swather
20 SP Bater
21 SP Bate Wagon
22 Forage Harvestor
23
24 Cotton Stripper
25
26 Cotton Picker
27
28
29
30 MB Plow 4
31 MB Plow 6
32 MB Plow 5
33 MB Plow 7
34
35 Tandem Disk
36 Offset Disk
37 Offset Disk
38
39 Oneway
40 Sweep
41 Sweep
42 Chiset
43 Offset Disk
44 RoLL. Cultivator
45 Row Cultivator
46 Field Cultivator
47
48 Lister
49
50 Hitter
51 Cultibedder Till
Purchase ue Hours of Hor
Purchase Fuel Hours of Horse I
Price Type
9200
13000
16750
19500
23750
27000
0
0
0
10800
4400
0
21250
23500
0
13750
0
10300
11300
4500
14500
5100
0
19250
0
16575
0
0
0
1200
3000
2550
3500
0
1200
3800
3600
0
1200
1300
3475
1400
4300
1150
1200
1400
0
650
0
765
0
0
Fuel Consumption I
Muttiptiers (HP)
Life Power Gas LPG Diesel
12000
12000
12000
12000'
12000
12000
0
0
0
4000
4000
0
2000
2000
0
1500
0
1500
1500
2000
2500
1500
0
2500
0
2500
0
0
0
2000
2000
2000
2000
0
2000
2000
2000
0
2000
2000
2000
2000
2000
2000
2000
2000
0
1200
0
1200
2000
0
55 0.068 0.080 0.048
83 0.068 0.080 0.048
100 0.068 0.080 0.048
125 0.068 0.080 0.048
150 0.068 0.080 0.048
175 0.000 0.000 0.000
0 0.000 0.000 0.000
0 0.000 0.000 0.000
0 0.000 0.000 0.000
1 4.000 4.710 2.780
1 2.500 2.940 1.740
0 0.000 0.000 0.000
1 7.310 8.600 5.090
1 0.000 0.000 0.000
0 0.000 0.000 0.000
1 4.390 5.160 3.050
0 0.000 0.000 0.000
1 2.720 3.200 1.890
1 2.960 3.520 2.090
0 3.100 3.600 2.200
0 4.000 4.710 2.780
0. 7.000 8.300 4.800
0 0.000 0.000 0.000
0 0.068 0.080 0.048
0 0.000 0.000 0.000
0 4.000 4.710 2.780
0 0.000 0.000 0.000
0 0.000 0.000 0.000
0 0.000 0.000 0.000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
MACHINERY COMPLEMENT
Code Name of
# Machine
53 Springtooth
54 Springtooth
55 Springtooth
56 Spike Harrow
57 Rotary Hoe
58 Chicken Picker
59 Rod Weeder
60
61 DriLl WO/Fert
62 DriLL W/Fert
63 Hoe Drill w/o Fer
64 Hoe Drill w/ Pert
65 Planter
66
67 Cultibedder Pint
68 Peanut Planter
69 DriLL w/o Fert
70 Drill w/ Fert
71 Dry Fert Spread
72
73 Anhydrous Applic
74 Sprayer
75
76 Stack Wagon
77 Land Plane
78 Float
79 Bed Shaper
80 Mulch Treader
81 Stack Shredder
82 Stack Mover
83 Pull Combine
84 Silage Cutter
85 Corn Picker
86 Stripper
87 Peanut Combine
88 Shaker-Digger
89 Digger-Inverter
90
91 Sickle Mower
92 Rotary Mower
93 Crimper
94 Rake
95 Windrower
96 PTO Baler
97 Bale Loader
98 Bale Wagon Pull
99 Trailer
***ID Fert Sprd
Asterisk Width
Flag "*" (feet)
20.0
27.0
33.0
20.0
14.0
24.0
22.0
0.0
13.3
13.3
t 11.6
11.6
12.0
0.0
18.0
12.0
10.6
10.6
25.0
0.0
12.0
12.0
0.0
14.0
12.0
10.0
12.0
15.0
12.0
14.0
8.0
3.0
6.0
6.0
5.0
6.0
6.0
0.0
7.0
6.0
7.0
8.0
12.0
6.0
14.0
24.0
3.0
500.0
Initial
List
Price
1450
2200
2450
875
850
890
1150
0
2700
3450
2400
3000
2200
0
1465
2350
2300
3000
500
0
500
300
0
8800
4000
575
2000
1500
575
2000
2300
2000
3500
8500
7000
1100
1675
0
585
575
980
1025
3843
4300
500
5071
800
5
Speed Field
(MPH) Efficency
5.3 0.70
5.3 0.70
5.3 0.70
5.3 0.70
5.0 0.76
4.5 0.76
4.8 0.83
0.0 0.00
4.0 0.72
4.0 0.72
4.0 0.60
4.0 0.72
5.0 0.67
0.0 0.00
4.5 0.67
5.0 0.67
4.0 0.72
4.0 0.72
5.3 0.67
0.0 0.00
4.0 0.67
3.8 0.60
0.0 0.00
5.0 0.60
3.5 0.42
3.0 0.83
3.0 0.70
5.0 0.83
4.8 0.81
5.0 0.12
3.0 0.67
4.0 0.60
3.0 0.63
3.0 0.63
3.0 0.67
3.0 0.76
3.0 0.76
0.0 0.00
4.3 0.81
4.8 0.81
4.3 0.77
5.4 0.75
5.4 0.77
3.0 0.67
5.0 0.40
5.0 0.40
20.0 0.90
0.7 1.00
Hours
Used
RC2 RC3 Annually
0.65 0.000251
0.65 0.000251
0.65 0.000251
0.65 0.000251
1.00 0.000251
1.00 0.000251
0.65 0.000251
0.00 0.000000
0.65 0.000251
0.65 0.000251
0.65 0.000251
0.65 0.000251
0.80 0.000631
0.00 0.000000
0.80 0.000631
0.80 0.000631
0.65 0.000251
0.65 0.000251
1.00 0.000251
0.00 0.000000
1.00 0.000631
0.65 0.000251
0.00 0.000000
0.85 0.002510
1.00 0.000251
0.60 0.000251
0.80 0.000631
1.00 0.000251
0.65 0.002510
0.85 0.002510
0.33 0.000251
1.20 0.002510
0.50 0.000631
0.50 0.000631
0.80 0.000631
1.00 0.002510
1.00 0.002510
0.00 0.000000
1.80 0.002510
0.65 0.002510
1.00 0.002510
1.00 0.002510
1.00 0.002510
0.85 0.002510
1.00 0.002510
1.00 0.002510
1.00 0.002510
0.00 1.799999
1.80
1.80
1.80
1.80
1.80
1.80
1.80
0.00
1.80
1.80
1.80
1.80
1.60
0.00
1.60
1.60
1.80
1.80
1.80
0.00
1.60
1.80
0.00
1.80
1.80
1.30
1.60
1.80
1.30
1.30
1.80
1.30
1.60
1.60
1.60
1.80
1.60
0.00
1.30
1.30
1.30
1.30
1.30
1.30
1.30
1.40
1.30
1.30
Years
Owned
10.0
10.0
10.0
10.0
10.0
8.0
10.0
0.0
10.0
10.0
10.0
10.0
10.0
0.0
8.0
10.0
10.0
10.0
10.0
0.0
10.0
10.0
0.0
8.0
10.0
10.0
8.0
10.0
8.0
8.0
10.0
10.0
10.0
15.0
6.0
10.0
8.0
0.0
10.0
10.0
8.0
8.0
8.0
6.0
8.0
10.0
10.0
0.6
RFV1
0.600
0.600
0.600
0.600
0.600
0.600
0.600
0.000
0.600
0.600
0.600
0.600
0.600
0.000
0.600
0.600
0.600
0.600
0.560
0.000
0.600
0.600
0.000
0.560
0.600
0.600
0.600
0.600
0.560
0.560
0.635
0.560
0.600
0.600
0.660
0.600
0.600
0.000
0.600
0.560
0.560
0.600
0.560
0.560
0.600
0.560
0.635
0.885
RFV2
0.885
0.885
0.885
0.885
0.885
0.885
0.885
0.000
0.885
0.885
0.885
0.885
0.885
0.000
0.885
0.885
0.885
0.885
0.885
0.000
0.885
0.885
0.000
0.885
0.885
0.885
0.885
0.885
0.885
0.885
0.895
0.885
0.885
0.885
0.880
0.885
0.885
0.000
0.885
0.885
0.885
0.885
0.885
0.885
0.885
0.885
0.895
0.895
MACHINERY COMPLEMENT
Code Name of Purchase
# Machine Price
53 Springtooth 1450
54 Springtooth 2200
55 Springtooth 2450
56 Spike Harrow 875
57 Rotary Hoe 850
58 Chicken Picker 800
59 Rod Weeder 1000
60 0
61 Drill WO/Fert 2700
62 Drill W/Fert 3450
63 Hoe DriLL w/o Fert 2400
64 Hoe Drill w/ Fert 3000
65 Planter 2200
66 0
67 Cultibedder Ptnt 1319
68 Peanut Planter 2350
69 Drill w/o Pert 2300
70 Drill w/ Pert 3000
71 Dry Pert Spread 425
72 0
73 Anhydrous Applic 425
74 Sprayer 255
75 0
76 Stack Wagon 8800
77 Land Plane 1350
78 Float 500
79 Bed Shaper 1706
80 Mulch Treader 1800
81 Stack Shredder 500
82 Stack Mover 1800
83 Pull Combine 2000
84 Silage Cutter 1700
85 Corn Picker 2975
86 Stripper 8500
87 Peanut Combine 6000
88 Shaker-Oigger 1100
89 Digger-Inverter 1675
90 0
91 Sickle Mower 550
92 Rotary Mower 500
93 Crimper 850
94 Rake 1025
95 Windrower 3600
96 PTO Baler 4300
97 Bale Loader 450
98 Bale Wagon Pull 5000
99 Trailer 600
***ID Pert Sprd 0
I
Fuel Hours of Horse I
Type
Life
2000
2000
2000
2000
2000
2000
2000
0
1000
1000
1000
1000
1200
0
1200
1200
1000
1000
1000
0
1000
1000
0
2000
2000
2000
2000
2000
1000
2000
2000
1500
1500
2500
2500
1500
1500
0
1000
1000
1000
1000
1500
2000
1000
2000
1000
0
Fuel Consumption
Multipliers (HP)
Power Gas LPG Diesel
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
APPENDIX C.
Machinery Complement List Coefficient Description
APPENDIX C.
The information contained in this appendix is quoted direc-
tly from the Oklahoma Budget Generator User's Guide, pages 78-81.
Some of the original material that is not applicable to UFBUD has
been removed. The essence of the description, however, remains
unchanged.
WIDTH the swath in feet that the machine covers, except for
tractors in which case width indicates the horsepower and trucks
in which case width indicates tons.
INITIAL LIST PRICE the factory recommended selling price in
dollars, not the purchase price of the machine. Reference:
Official Used Car Guide, Tractor and Farm Equipment Guide,
Tractor and Implement Blue Book.
SPEED the average speed the machine travels in the field when
performing its task, expressed in miles per hour. Reference:
Agricultural Engineers Yearbook.
FIELD EFFICIENCY the ratio of the actual effectiveness of a
machine to its theoretical effectiveness, expressed as a decimal
fraction. Reference: Agricultural Engineers Yearbook.
RC1 (Repair Cost Factor 1) a repair cost variable which is the
ratio of total accumulated repair costs to the initial list price
for the entire life of the machine. Reference: Agricultural
Engineers Yearbook.
RC2 (Repair Cost Factor 2) a variable that helps determine the
shape of the repair rate curve for a specific machine.
Reference: Agricultural Engineers Yearbook.
RC3 (Repair Cost Factor 3) an exponent variable which, in
conjunction with RC2 determines the shape for the repair curve for
a specific machine. Reference: Agricultural Engineers Yearbook.
HOURS USED ANNUALLY the average number of hours a machine is
used each year. This item varies from farm to farm and region to
region.
YEARS OWNED the average number of years a machine is owned
before it is traded or sold. This item also varies from farm to
farm.
RFVl (Remaining Value 1) the percentage of original value that
remains after the first year depreciation occurs, expressed as a
decimal fraction. Reference: Agricultural Engineers Yearbook.
RFV2 (Remaining Value 2) a component of the standard double
declining balance equation. Reference: Agricultural Engineers
Yearbook.
PURCHASE PRICE the actual dollar value paid for the machine.
Purchase price may be different than the initial list price.
FUEL TYPE indicates the type of fuel, gasoline, L.P. gas, or
diesel. The numbers that should be entered are 1.0 for gasoline,
2.0 for L.P. gas, and 3.0 for diesel.
HOURS OF LIFE the hours of expected mechanical life.
Reference: Agricultural Engineers Yearbook.
HORSE POWER for self-propelled machines.
3 12b2 0437b850 2
/ ()
(~9 (
~
LSCR rIC
LIB RA l y
COOPERATIVE EXTENSION SERVICE. UNIVERSITY OF FLORIDA, INSTITUTE OF FOOD AND AGRICULTURAL
SCIENCES, K. R. Tefertlller, director, In cooperation with the United States Department of Agriculture, publishes this Infor-
matlon to further the purpose of the May 8 and June 30, 1914 Acts of Congress; and s authorized to provide research, educa-
tlonal Information and other services only to Individuals and institutions that function without regard to race, color, sex or
national origin. Single copies of Extension publlcatlons (excluding 4-H and Youth Publicatlons) are available free to Florida
residents from County Extension Offices. Information n bulk rates or copies for out-of-state purchasers Is available from
C. M. Hinton, Publications Distribution Center, IFAS Building 664, University of Florida, Gainewllle, Florida 32611. Before publicizing this
Publication, editors should contact this address to determine availability.
