lOt
February 1987

Floppy disc included with this
item has been shelved separately.
Consult LUIS or ask circulation
staff for' assistance.

VEG-BUD

Fresh Vegetable

Budget Generator

COMPUTER SERIES

E. Belibasis, T. Stevens and J. VanSickle

Circular 739

Central Science
Library
JAN 30 1990
University of Florida

1~
mm

F636c o
739 \ive Extension Service / Institute of Food and Agricultural Sciences / University of Florida / John T. Woste, Dean
codebk

ABSTRACT

This manual explains the setup and use of VEG-BUD, a microcomputer budget generation
program for agriculture using Lotus 1-2-3. VEG-BUD aids in the preparation of enterprise
cost budgets and can create machinery, labor, inputs and sensitivity analysis tables.

Keywords: budgets, costs, vegetables, sensitivity analysis, microcomputers, Lotus 1-2-3.

ACKNOWLEDGMENTS

The Fresh Vegetable Budget Generator, VEG-BUD, was developed using a variety of
programming techniques some of which were adapted from UFBUD, another University of
Florida budget generator program for agriculture. The format of the vegetable budgets in
VEG-BUD was adapted from budgets in the study, "Florida and Mexico Competition for the
Winter Fresh Vegetable Market" by Buckley, K. C., et al.

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

TABLE OF CONTENTS

LIST OF FIGURES ..................

INTRODUCTION ...................
HARDWARE AND SOFTWARE REQUIREMENTS

BACKING UP VEG-BUD .

Dual Floppy Drive System
Hard Disk System ...
VEG-BUD SETUP ......
Dual Floppy Drive System
Hard Disk System ...

RUNNING VEG-BUD . . .
THE MAIN MENU . . .
(B)udgets . . . .
(M)ach/Comp . . .
(C)redits . . . .
(P)rint . . . . .
(E)xit . . . . .
BUDGETS ..........
(I)nput data . . . .
(V)iew budget . .
(G)enerate . . . .
(A)nalysis . . . .
(E)rase . . . . .
(P)rint . . . . .
(S)ave . . . . .
(Q)uit . . . . .
MACHINERY COMPLEMENT
(I)nput data . . . .
(G)enerate . . . .
(V)iew table . . .
(E)rase .. .. . .
(P)rint . . . . .
(S)ave . . . . .
(Q)uit . . . . .

QUICK REFERENCE..............

. . . . . . . . . . . 32

DEFINITION OF TERMS ...............................

REFERENCES . . . . . . . . . . . . . . . . . .

APPENDIX . . . . . . . . . . . . . . . . . . .

. . . . . . 1 1

. . . . . . . . 1
. . . . . . . . 1

. . . . . . . . 2
. . . . . . . . 2
. . . . . . . .. 4
. . . . . . ... 4
. . . . . . . . 4

35

39

.

. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .

LIST OF FIGURES

Figure 1. VEG-BUD Setup and Title Screen . . . . . . . . . . 6
Figure 2. Disk Replacement for Dual Floppy Drive Systems . . . . . . . 6
Figure 3. The Main Menu and Title Page. . . . . . . .. . . . . 8
Figure 4. The UF Disclaimer and Condition of Release or Sale . . . . . . 11
Figure 5. The VEG-BUD Developers and Ordering Screen. . . . . . . .. 11
Figure 6. The (B)udgets Submenu and the Budget Listing . . . . .. . ... 13
Figure 7. The Budget Menu and Title Screen . . . . . . . . . . 13
Figure 8. The Non-machinery Input Table . . . . . . . . . . . 15
Figure 9. Custom Work and Other Summary Input Section . . . . . . . 15
Figure 10. Harvest & Haul and Pack & Market Summary Input Section . . . . 16
Figure 11. Summary Table Non-Input Section . . . . . . . . . . 16
Figure 12. The Tractor Selection Form . . . . . . . . . . . . 17
Figure 13. The Machinery Selection and Data Input Form . . . . . . . 17
Figure 14. The Labor Input Table ........................... 19
Figure 15. The Miscellaneous Input Form . . . . . . . . . . . 19
Figure 16. The Budget Summary Table . . . . . . . . . . . . 22
Figure 17. The Budget Machinery Table . . . . . . . . . . . . 22
Figure 18. The Budget Labor Table .......................... 23
Figure 19. The Sensitivity Analysis Table . . . . . . . . . . . 23
Figure 20. The Machinery Complement Menu and the Title Screen . . . . . 28
Figure 21. The Machinery Complement Input Table . . . . . . . . . 28
Figure 22. The Parameter Entry Form . . . . . . . . . . . . 29
Figure 23. The Machinery Cost Table . . . . . . . . . . . . 30

FRESH VEGETABLE BUDGET GENERATOR

**VEG-BUD **

by

E. Belibasis, T. Stevens and J. VanSickle1

INTRODUCTION

The University of Florida Fresh Vegetable Budget Generator, "VEG-BUD", is a
microcomputer software template which runs under Lotus 1-2-3 and is used for creating
vegetable crop budgets.

VEG-BUD is intended for use primarily by fresh vegetable growers and extension and
research related personnel. Its budget format design makes it suitable for budgeting most
fresh vegetable crops.

The VEG-BUD microcomputer program can help you to: a) maintain crop enterprise costs
in a concise and organized fashion, b) reduce computational time and errors in creating
budgets and c) easily analyze different cost-price-yield scenarios.

HARDWARE AND SOFTWARE REQUIREMENTS

Running VEG-BUD requires Lotus 1-2-3 Release IA. Familiarity with Lotus 1-2-3 is
recommended but not required if you follow the instructions of this manual carefully. Your
computer must be able to run Lotus 1-2-3 and have a minimum of 256K of RAM memory. The
computer must have either two disk drives or, preferably, one disk drive and a hard disk.
VEG-BUD will not operate on single disk drive systems. Up to 42 budgets can be handled
with VEG-BUD and a maximum of five budget files can be stored in one 364 Kb disk.

BACKING UP VEG-BUD

Before you begin using VEG-BUD, it is important to make a duplicate copy of your disks.
You should always use a backup copy of VEG-BUD for day to day use. Hence, if your backup
copy is ever damaged you will still have the original copy to make another backup copy. The
VEG-BUD program disk comes with a write-protect tab to prevent accidental modification of
the program. However, you should not use a write-protect tab on the backup copy of
VEG-BUD you will be using since VEG-BUD often writes to that disk. VEG-BUD also comes

1Emil Belibasis is a Visiting Assistant Instructor, Tom Stevens is a graduate student and
John VanSickle is an Associate Professor, Food and Resource Economics Department, Institute
of Food and Agricultural Sciences, University of Florida.

with two additional disks containing budgets for a number of important Florida winter
vegetable. You may also want to make copies of these disks.

Follow these instructions to backup the VEG-BUD disks:

Dual Floppy Drive System

If you are familiar with MS-DOS, make backup copies of the VEG-BUD disks and proceed
to the VEG-BUD SETUP section to set up your VEG-BUD backup disk; otherwise follow these
instructions.

1. Take a blank disk (formatted or unformatted) and label it "VEG-BUD backup copy".

2. Insert your DOS disk in drive A and turn on your computer. At the A> prompt
type:

DISKCOPY A: B: [Return]

Note: As a convention throughout this manual, pressing the return key is symbolized
by [Return].

You will be prompted to insert the source disk in drive A and the target disk in
drive B. Now, replace the DOS disk in drive A with the VEG-BUD program disk
and insert the disk labeled VEG-BUD backup copy in drive B, and press anly key.

3. When copying is completed you will be prompted for another copy. If you wish to
make backup copies of the Budgets disks, press Y for yes at the DOS prompt and
follow the instructions. Otherwise, press N for no. Store the original VEG-BUD
and Budgets disks in a safe place after copying.

CAUTION: Do not use a write-protect tab on your working copy of the VEG-BUD
program disk.

After you have created a backup copy of the VEG-BUD program disk and optionally the
Budgets I and Budgets 2 disks, proceed to the VEG-BUD SETUP section to set up your
VEG-BUD backup disk.

Hard Disk System

When using a hard disk system, it is recommended that you create a new subdirectory on
your hard disk for the VEG-BUD program. This subdirectory should include the files in the
VEG-BUD program disk, the files in Budgets I and Budgets 2 disks, and six Lotus 1-2-3
System files. To create the subdirectory and copy the appropriate files, follow these
instructions:

1. Open the door of drive A and turn your computer on.

2. Type CD\ [Return] to make sure you are in the C: drive root directory. Now type:

MD VEGBUD [Return]
CD VEGBUD [Return]
DIR [Return]

You have now created a subdirectory named VEGBUD and the screen should show
that two files exist in the subdirectory.

3. You may also want to copy the Lotus files to the VEG-BUD subdirectory from
either your Lotus subdirectory or from the Lotus 1-2-3 System disk Use the
following instructions for copying Lotus files from a subdirectory in the C: drive.
If LOTUS is not the name of the subdirectory containing the Lotus 1-2-3 program
files then substitute the correct subdirectory name for the word LOTUS below.

Type the following commands sequentially:

COPY C:\LOTUS\123.EXE [Return]
COPY C:\LOTUS\123.CNF [Return]
COPY C:\LOTUS\TD.DRV [Return]
COPY C:\LOTUS\KB.DRV [Return]
COPY C:\LOTUS\PR.DRV [Return]
COPY C:\LOTUS\GD.DRV [Return]

If Lotus 1-2-3 is not installed on your hard disk insert the Lotus 1-2-3 System disk in
drive A and substitute A: for C:\LOTUS in the above commands to copy the files.

4. Type DIR [Return]. All six Lotus files and two files should be listed in the
VEGBUD subdirectory.

5. You now need to change the default directory Lotus searches for when it is loaded.
To do this place, the Lotus 1-2-3 System disk in drive A and load Lotus by typing
123 [Return]. Press [Return] again after the Lotus Copyright notice. When
the Lotus spreadsheet appears on the screen, enter the menu sequence
/WGDDC:\VEGBUD [Return]. This command sequence displays the menu, selects
(W)orksheet, (G)lobal, (D)efault, (D)irectory, and changes the default directory to
C:\VEGBUD. Then type U for (U)pdate to save the setting, followed by the
sequence Q/QY to exit out of Lotus.

6. Copy the VEG-BUD program to the VEGBUD subdirectory. To do so, insert the
VEG-BUD program disk in drive A and type COPY A:*.* C:\VEGBUD [Return]. The
files being copied should be displayed on the screen.

7. The two Budgets disks may be copied to the subdirectory in the same manner as the
VEG-BUD program disk was copied in step 6.

NOTE: If you did not copy Lotus to the VEGBUD subdirectory you will need to change
the default directory in Lotus to C:\VEGBUD every time you load the program in order
to access VEG-BUD. The file you need to retrieve in order to start VEG-BUD is called
AUTO123.

VEG-BUD SETUP

Many computer programs require the user to provide the name of the drive it will read
information from and write information to. The setup procedure that follows tells VEG-BUD
which drive (and subdirectory with hard disk systems) it will use to run the program and
which drive it will use to store budgets.

If you have already set up VEG-BUD, but wish to use it on a different computer configuration
read the Re-setup section under Quick Reference.

Dual Floppy Drive System

Once you have made a backup copy of VEG-BUD you are ready to set up VEG-BUD on
your backup copy.

1. Insert the Lotus 1-2-3 System disk in drive A and the backup copy of VEG-BUD in
drive B and type 123 [Return]. Press [Return] again after the Lotus Copyright
notice.

2. Lotus will automatically load VEG-BUD and you will hear a beep. The VEG-BUD
Title Screen will be displayed (Figure 1). The control panel in the upper left hand
corner of the screen will display a prompt asking you to type in the drive name
where the VEG-BUD disk will be located. Type A:\ [Return] for the A drive. You
will then be prompted to type in the drive name where the Budgets disk will be
located. Type B:\ [Return] for the B drive. If you do not enter this information
correctly you will hear a beep and an error message will appear prompting you to
try again.

3. After you have specified the drive setup, the screen displays instructions to replace
the Lotus System disk in drive A with the VEG-BUD program disk in drive B
(Figure 2). Do so and insert the Budgets 1 disk in drive B. Press [Return] to
continue.

4. You will also need to set up the same drive names on all the budgets that come
with VEG-BUD (budgets you create do not require the setup procedure). You must
select (B)udgets, (S)elect, (Y)es from the Main Menu. You will be prompted for a
budget number. Type the number of the budget you want to select from the Budget
Listing and press [Return]. You will then need to enter the same drive letters
entered in step 2 of this section.

To return to the Main Menu and set up another budget, select (Q)uit, (Y)es from
the Budget Menu.

5. VEG-BUD is set up and ready to run.

Hard Disk System

1. Insert the Lotus 1-2-3 System disk in drive A. At the C> prompt type CD VEGBUD
[Return] to make sure you are in the VEGBUD subdirectory. Now type 123 [Return]
to load Lotus 1-2-3. Press [Return] again after the Lotus Copyright notice.

2. You will hear a beep and the VEG-BUD Title Screen will be displayed (Figure 1).
The control panel in the upper left hand corner of the screen will display a prompt

asking you to type in the drive and subdirectory names where the VEG-BUD
program is located. Type C:\VEGBUD [Return] for the VEGBUD subdirectory in
drive C:. You will then be prompted to type the drive name where the budgets are
stored. Again type C:\VEGBUD [Return].

3. You will also need to set up the same drive names on all the budgets that come
with VEG-BUD (budgets you create do not require the setup procedure). You must
select (B)udgets, (S)elect, (Y)es from the Main Menu. You will be prompted for a
budget number. Type the number of the budget you want to select from the Budget
Listing and press [Return]. You will then need to enter the same drive letters
entered in step 2 of this section.

To return to the Main Menu and set up another budget select (Q)uit, (Y)es from the
Budget Menu.

4. VEG-BUD is set up and ready to run.

The setup procedure is necessary only the very first time you load VEG-BUD. The only
time you may need to set up VEG-BUD again is if you wish to run it on a computer with a
different drive configuration. The Re-setup of VEG-BUD section in the QUICK REFERENCE
section explains how to reset VEG-BUD.

117: CMD EDIT
Enter disk drive for VEG-BUD program

I J K LM N OP 0

Fresh Vegetables Budget Generator

<<>>

Developed by

E Betibasis, T Stevens & J VanSickle

Food & Resource Economics Department
Institute of Food and Agricultural
Sciences (IFAS)
University of Florida
Copyright (C) 1986, IFAS, UF
Release 1.0

IJ K LM N OP Q R
For 2-drive system type A:\ then B:\ when prompted. For harddisk system
type the fiLe path instead, e.g., C:\VEGBUD for program and/or budgets.

Figure 1. VEG-BUD Setup and Title Screen

CMD READY

H43: U

H I J K LM N OP

** REPLACE THE LOTUS 1-2-3 SYSTEM DISK **
** **
** IN DRIVE A WITH THE VEG-BUD DISK IN **
** **
** DRIVE B, THEN PLACE THE BUDGETS DISK **
** **
** IN DRIVE B AND PRESS [RETURN]. *
** **

I J K LM N OP Q R
19
20

Figure 2. Disk Replacement for Dual Floppy Drive Systems

RUNNING VEG-BUD

The VEG-BUD menus look and operate like Lotus 1-2-3 menus. You can either press the
first letter of the menu option you wish to select or use the right or left arrow keys to move
the cellpointer to the menu option desired and then press [Return].

With few exceptions (these are explained where appropriate), returning to a previous
menu can be done by pressing the Escape key [Esc]. In some cases you can only return to
the previous menu by selecting (Q)uit.

If you encounter Lotus 1-2-3 error messages displayed in the lower left corner of the
screen, you will need to press [Return] or [Esc] and then hold the [Ctrl] key down while
pressing the M key ([Ctrl]-M) to recover the Main Menu. This may happen in cases where,
for example, you want to retrieve a budget but it is not found on the disk you are using.

When in the VEG-BUD input areas you can move around using the arrow, [Home] and
[End] keys. The [Home] key takes you to the upper left corner of the input area. The [End]
key to the lower right corner. The [Pageup] and [Pagedown] keys do not function in
VEG-BUD.

When you have completed entering data in any of the input areas, you may proceed to
the next step (another input area or return to a menu) by pressing [Return] or [Esc]. In
other words, press the [Return] or [Esc] key without entering data.

VEG-BUD displays messages on the bottom portion of the screen at every step of the
program. These messages aid the user by showing how to use the menus, how to continue the
program execution, what data to input, or cautions on critical data input. Usually, the
messages colored green on color monitors or less bright on monochrome monitors are for
general guidance. Those colored white on color monitors or appearing brighter on
monochrome monitors warn you of important data to enter or how to recover the menu when
it is lost.

THE MAIN MENU

Before running VEG-BUD you must have gone through the setup procedure above. To
load VEG-BUD, follow step 1 in VEG-BUD SETUP on page 4, for the system you are using.

The Main Menu is contained in a file that also contains the names of all budgets created
with VEG-BUD. This file is used to retrieve other files that may be budgets or the machinery
complement file on the program disk.

The Main Menu in VEG-BUD is a list of options showing on the control panel above the
VEG-BUD Title Screen. It is the first menu that appears when you load VEG-BUD (Figure 3).
The options available are (B)udgets, (M)ach/Comp, (C)redits, (P)rint and (E)xit. A description
of the Main Menu options follows:

11: CMD MENU
Budgets Mach/Comp Print Credits Exit
Select, Create, Rename or DeLete a crop budget
IJ K LM N OP Q R

2
3 Fresh VegetabLes Budget Generator
4
5 <>>
6
7 DeveLoped by

9 E Belibasis, T Stevens & J VanSickle
10 II ________II
11 Food & Resource Economics Department
12 Institute of Food and AgriculturaL
13 Sciences (IFAS)
14 University of Florida
15 Copyright (C) 1986, IFAS, UF
16 ReLease 1.0
17 _____
IJ K LM N OP Q R
19
20

Figure 3. The Main Menu and Title Page

(B)udgets: There are five options under (B)udgets: They are (S)elect, (C)reate, (R)ename,
(D)elete, and (Q)uit. After selecting an option you can return to this menu by pressing [Esc]
or selecting (N)o. The options are:

(S)elect: Choose (B)udgets, (S)elect, (Y)es to view or alter an existing budget. Using this
option you can enter/modify input data, costs, machinery and labor requirements, print
tables and select machinery for a selected budget. For more detailed information of this
option see BUDGETS on page 12.

(C)reate: If you wish to create a new budget you can do so using the (B)udgets, (C)reate
option. You can either create a new budget from an (E)xisting budget or you can start
from scratch using a (B)lank budget.

(E)xisting: When you select (E)xisting you will be editing an existing budget and
saving it under a new name. You will then be prompted to enter the new budget
name. Although the budget name can be as long as desired, only the first 14
characters will be displayed on the screen. If you had already entered a name by
pressing [Return] once, you can edit the name by pressing the edit key [F2] and
deleting characters with the [Del] or [Backspace] keys. You will then be prompted
to enter the number of the budget to use in creating the new budget. On a hard
disk system, once you have made the selection, VEG-BUD creates a new file with
the new name and retrieves it for you.

If you have a dual floppy drive system, the budget name you selected will then be
displayed in the box in the upper left corner of the screen. At the same time a

message will appear on the control panel prompting you to check the Budgets disk
in drive B to make sure you have the budget you wish to use. Once this has been
done, press [Return] to continue. VEG-BUD will take you to the new budget.
Another message will appear prompting you to check the disk in drive B to make
certain there is enough space to save the new budget.

To return the Main Menu select (Q)uit, (Y)es.

(B)lank: Select (B)lank when you want to create a budget from scratch. You will be
prompted to enter the new budget name. On a hard disk system, once you have
entered the new name, VEG-BUD creates a new file with the new name. VEG-BUD
will then retrieve the new budget for you.

If you have a dual floppy drive system, another message will appear prompting you
to check the disk in drive B to make certain there is enough space to save the new
budget.

CAUTION: The maximum number of budgets that can be stored in one disk is five.
On a hard disk the number of budgets that can be stored is limited by the 48
maximum that VEG-BUD can handle and the storage availability of your hard disk.
If you use a dual floppy drive system always keep a list of the budgets included in
every disk.

To return the Main Menu select (Q)uit, (Y)es.

(R)ename: You can change the name you originally gave a budget with the (B)udgets,
(R)ename, (Y)es option. You can only rename a budget using the (B)udgets, (R)ename
option. On a hard disk system, after pressing the Y key you will be prompted to enter
the number of the budget you want to rename. You then enter the new name. VEG-
BUD will then retrieve the budget and rename it.

If you have a dual floppy drive system, the budget name you selected will then be
displayed in the box in the upper left corner of the screen. At the same time a message
will appear on the control panel prompting you to check the Budgets disk in drive B to
make sure you have the budget you wish to rename. Once this has been done press
[Return] to continue. VEG-BUD will then retrieve the budget and rename it.

To return the Main Menu select (Q)uit, (Y)es.

(D)elete: Use the (B)udgets, (D)elete, (Y)es option of the Main Menu to erase a budget
from disk storage. On a hard disk system, when you select this option the name of the
budget you want to delete will disappear from the Budget Listing.

If you have a dual floppy drive system, the budget name you selected will be displayed in
the box in the upper left corner of the screen, and at the same time a message will
appear on the control panel prompting you to check the Budgets disk in drive B to make
sure you have the budget you wish to delete. Once this has been done press [Return] to
continue.

CAUTION: Only one budget may be deleted at a time. Also, if the budget you want to
delete is not on the disk in drive B, the name will be deleted frofi the Budget Listing
but an error message will appear. Press [Return] and then [Alt]-M to recover the Main
Menu. You must then re-initiate the command sequence, specifying the same budget

number with the correct Budgets disk in drive B. Alternately, you may delete the
intended budget with the DOS DELETE command once out of VEG-BUD.

(Q)uit: It is required to select (Q)uit to return to the Main Menu. Pressing [Esc] will
not work.

CAUTION: Once you have selected (Y)es by pressing the Y key in either the (S)elect,
(R)ename or (D)elete options or either (E)xisting or (B)lank under (C)reate, VEG-BUD
will not let you escape back to the previous menu by pressing [Esc]. If you have made a
selection in any of these cases and do not wish to continue, you must break out of the
VEG-BUD macro by holding the [Ctrl] key down and pressing the [Break] key, and then
the [Return] key. The Main Menu can be recovered by pressing [Alt]-M.

(M)ach/Comp: The (M)ach/Comp Main Menu option takes you to the Machinery Complement
file where all machinery data is stored. The Machinery Complement file contains all the
machinery data you may need for creating budgets. You may add or revise data in this file
using this option. You can also generate a table of machinery hourly costs. Data on
machinery prices, expected life of machinery, maintenance and repair factors, horsepower, fuel
types, etc. are contained in the Machinery Complement file. In contrast, the machinery data
required in a budget include: time to perform an operation, the times over, and the type of
equipment used. This information is added in the budget input section. A detailed description
of the (M)ach/Comp option is presented in the MACHINERY COMPLEMENT section on page 27.

(C)redits: This command displays a screen with the University of Florida Disclaimer and
Condition of Release or Sale is displayed (Figure 4). Pressing any of the arrow or move keys
will display another screen with the names and addresses of the VEG-BUD developers and the
IFAS Software Distribution address ana phone number (Figure 5). Press C to select and view
the (C)redits.

Press [Return] or [Esc] to return the Main Menu.

(P)rint: The Main Menu (P)rint option gives you a printout of the VEG-BUD Title Page and
the Budget Listing. Make sure your printer is turned on and is in the ready or online mode
before selecting (P)rint.

(E)xit: When you finish a work session with VEG-BUD select (E)xit, (Y)es from the Main Menu
to return you to the Lotus Access System or to the Disk Operating System.

Al: U CI4D READY

A B C D E F G H
1. DISCLAIMER
2 The University of Florida (UF), Institute of Food and Agricultural
3 Sciences (IFAS), and the Florida Cooperative Extension Service (FCES)
4 shall have no liability or responsibility to cooperator or any other
5 person or entity with respect to any liability, loss, or damage caused
6 or alleged to be caused directly or indirectly by programs released by
7 IFAS for sale or cooperative use including but not Limited to any
8 interruption of services, Loss of business, or anticipatory profits or
9 consequential damages resulting from use or operation. And in no event
10 shall FCES be liable for loss of profits, indirect, special, or
11 consequential damages arising out of any breach of the agreement or
12 obligation of this contract.
13
14 CONDITION OF RELEASE OR SALE
15 All computer software distributed by IFAS or FCES are on an "AS
16 IS" basis without warranty. Distribution or resale without written
17 permission of the department of origin is not permitted.
18
19
20

Figure 4. The UF Disclaimer and Condition of Release or Sale

A40: U CMD READY

A B C D E F G H
21 VEG-BUD Developers
22 ------------
23 Emil Belibasis
24 Visiting Assistant In Food and Resource Economics
25
26 Thomas J. Stevens
27 Graduate student in Food and Resource Economics
28
29 John J. VanSickle
30 Associate Professor in Food and Resource Economics
31
32 For more information about VEG-BUD call authors at (904) 392-2297,
33 IFAS Software at (904) 392-7853, or write to the following address:
34
35 IFAS Software Communication & Distribution
36 G022 McCarty Hall
37 University of Florida
38 Gainesville, FL 32611
39
40

Figure 5. The VEG-BUD Developers and Ordering Screen

Al: U

CMD READY

BUDGETS

Entering the (B)udgets option of the VEG-BUD Main Menu displays the Budget Listing
for the budgets already saved (Figure 6). The budgets listed on the screen include the 10
budgets that came with VEG-BUD. You must enter the (S)elect, (Y)es command to select a
budget. A message will then appear in the control panel prompting you to enter a number for
the desired budget. For example, type a 1 to select the Dade County Ground Tomatoes budget
(DadeGrdTom). With a dual floppy drive system, after a few seconds VEG-BUD will display
another message on the control panel prompting you to check the disk in drive B and make
sure you have the correct Budgets disk inserted. In this case you should have the Budgets 1
disk in drive B. Press [Return] to continue.

The Title Screen of the selected budget will appear displaying the name of the budget, the
name of person who prepared the budget and the season for which the budget was made
(Figure 7). The Budget Menu is displayed on the control panel. It shows the following
options: (V)iew budget, (I)nput data, (G)enerate, (A)nalysis, (E)rase, (P)rint, (S)ave and (Q)uit.
An explanation of each of these options follows:

(I)nput data: Press the I key to select this menu option. All data for creating a budget
are entered using this menu option with two exceptions: 1) The budget name which can
only be entered using the Main Menu (B)udgets, (C)reate or (R)ename options and 2) The
Machinery Complement data under the (M)ach/Comp, (I)nput data menu option. The
(I)nput data command has a submenu containing the following options: (N)on-machinery,
(M)achinery, (L)abor, (O)ther, and (T)itle. -

(N)on-machinery: Press the N key to select this option. The upper part of a table
like the one shown in Figure 8 will be displayed. The table is made up of five
columns: Column one contains the names of the cost items, column two contains the
units of measurement, column three contains the quantity of each item, column four
contains the price per unit and column five the cost of the item. There are five
sections in this table, four of which admit user input and one that does not. The
input sections are: Preharvest Material Inputs, Preharvest Custom Work & Other,
Harvest & Haul and Pack & Market. To view these sections use the arrow keys to
move one cell at a time or the [End] key to view the sections in the lower side of
the table. The [Home] key returns you to the upper side of the table. A brief
explanation of each section follows:

Preharvest Material Inputs: In this section enter all materials utilized in the
production process before harvesting, e.g., containerized transplants, formula
12-12-12 fertilizer, systemic insecticide, etc. You may separate these materials
into groups using group titles; for example, FERTILIZER, FUNGICIDES and
INSECTICIDES. You may use as many group titles as you need. There is also
no limit on the number of items you can have under each group title.

There are 31 rows and four columns for data input in this section. The
columns are: Item, Units, Quantity and Price. Always organize the input items
before you enter them. Enter the items in the order you want them to appear
in the output tables. Output tables are those tables which VEG-BUD generates
for viewing or printing purposes only (see also the (V)iew budget section on
page 20). The first row will accept only the production unit and yield
quantity. The name of the unit of production should end with an s.
Otherwise, when you (G)enerate the budget, the cost title which is expressed
in dollars per unit (located in the middle of this table) will be truncated and

G26: U
Select Create Rename DeLete Quit
Select a vegetable crop budget (view or modify)
G H I J K L M

CMD MENU

N OP Q

.................+ BUDGET LI ST I NG
---------------------------

30 1 DadeGrdTom 13 25 37
31 2 SouthwStkTom 14 26 38
32 3 Rus-PalStkTom 15 27 39
33 4 PBGrnPeppers 16 28 40
34 5 SouthwPeppers 17 29 41
35 6 DadeBushBeans 18 30 42
36 7 PBBushBeans 19 31 43
37 8 SouthwCukes 20 32 44
38 9 DadeSquash 21 33 45
39 10 PBEggplant 22 34 46
40 11 23 35 47
41 12 24 36 48
42
I J K L M N OP Q R
19
20

Figure 6. The (B)udgets Submenu and the Budget Listing

W108: (FO)
View budget Input data Generate Analysis Erase
View the existing budget
W X Y Z

CMD MENU

Print Save Quit

AA AB AC

Fresh Vegetables

BUDGET GENERATOR

<<<>

Budget name: DadeGrdTom
Prepared by: E. B.

Season: 1984-85

Y Z AA AB AC AD
a selection type the first letter of the desired menu option>
[Return] then [Alt]-M to recover the Budget Menu when Lost>

Figure 7. The Budget Menu and Title Screen

X

misspelled. The values in the cost column are the product of the quantity and
price columns. This column accepts no user input.

Preharvest Custom' Work & Other: This section is directly below Material
Inputs in the summary table (Figure 9). Press the down arrow key starting
from the Item column until you locate this section. You may enter items such
as land rent, custom operations like aerial spraying or plowing, crop insurance,
etc., for which either determining price and quantity is difficult or
inappropriate. There are eight rows and two columns for data input in this
section. The Units, Quantity and Price columns do not accept user input. You
may use subtitles in this section to group items.

Harvest & Haul: Press the [End] key to view this section (Figure 10).
Harvesting and hauling costs are entered in this section on a per unit of
production basis and not on a per acre basis. There are three rows and two
columns for data input. As with the previous section, the columns for units,
quantity and price do not accept user input.

Pack & Market: This is the last section of this table (Figure 10). Enter the
per unit cost for the major packing and marketing cost items here. There are
eight rows and as in the above case, only two columns for user input. You
may also use subtitles in this section.

The non-entry section of this table is directly above the Harvest & Haul
section (Figure 11). All the entries are colored white on color monitors or
appear brighter on monochrome monitors and cannot be modified. To locate
this section press the up arrow key from the Item column until this section
appears. The values displayed are based on data from other parts of this table
or from other (I)nput data sections.

Press [Return] or [Esc] to return the Input Menu.

(M)achinery: Select (M)achinery. You will see another menu displaying (N)o and
(Y)es. VEG-BUD provides this menu to give the user an additional step before
deciding to enter the (I)nput data, (M)achinery section since there is a time delay
before actually entering this section. Select (Y)es to continue. After several
seconds a new screen will be displayed as shown in Figure 12. This is called the
Tractor Selection Form. A list of tractor names appear on the left side of the
screen. You will find the same list in the Machinery Complement file when
selecting (M)ach/Comp, (I)nput data, (M)achinery from the Main Menu. To the left
of the tractor names is a column of ID numbers. The numbers that appear in the
middle of the screen are the ID numbers of the tractors already selected for this
budget. When creating your own budget, enter the ID number for a selected tractor
in the same row where the tractor name is located. An identical ID number list
appears on the right side of the screen to facilitate data entry.

Press [Return] to continue.

After the tractor selection screen, the Machinery Data Input and Tractor-Implement
Matching Form will appear (Figure 13). In this section, the user selects the
implements and/or machinery for the budget and enters the corresponding usage
values. There are three input columns in this section. They are: Tractor ID, Acres
per Hour and Times Over. In the Tractor ID column you will find the same tractor
ID numbers of the tractors selected in the previous screen which also appear on the

C8: U 'Cartons CI4D READY

A B C D E F

Item Units Quantity Price Cost

YIELD PER ACRE: Cartons 1,000 Total $/A=$5,733.04

PREHARVEST
Material Inputs
FERTILIZERS
13-0-44
2-30-4
6-12-12
Soil fumigant
Plastic mulch
Seed
Plug mix
HERBICIDES
Paraquat
X Y

LBS
LBS
LBS
LBS
ROLLS
0NZS
BAGS

200.00
375.00
2000.00
200.00
2.50
5.00
5.00

0.19
0.12
0.12
1.00
65.00
25.00
7.00

QRTS 1.00 11.25
Z AA AB AC
[Home], [End] & Arrow keys for moving>
n the blanks & press [Return] to continue>

Figure 8. The Non-machinery Input Table

839: (T) U CMD READY

A B C D E F
5 ....................................................................

Item

Units

Quantity Price Cost

7 ....................................................................
38 0.00
39 0.00
40 0.00
41 0.00
42 0.00
43 Custom Work & Other
44 Frost protection 104.03
45 Plow 50.00
46 Wells 15.00
47 Dump fee 4.00
48 Land rent 180.00
49 Gases 6.00

Y Z

AA AB AC
& Arrow keys for moving>
press [Return] to continue>

Figure 9. Custom Work and Other Summary Input Section

$/Acre

0.00
38.00
43.13
230.00
200.00
162.50
125.00
35.00
0.00
11.25
AD

C8: U 'Cartons

CMD READY

P77: (P2) U CMD READY

A B C D E F

Item Units Quantity Price Cost

HARVEST & HAUL
Harvesting 0.63
Hauling 0.07

Total harvest & haul ................................ 0.70
PACK & MARKET
Packing 1.74
Carton box 0.58
Selling 0.15

Y Z

AA AS AC
& Arrow keys for moving>
press [Return] to continue>

Figure 10.

851: (T) U

Harvest & Haul and Pack & Market Summary Input Section

CMD READY

A B C D E F

Item Units Quantity Price Cost
...o ....... o . o. ...oo.............. ........... o .o .oo .. o.

Tractor Labor
Other Labor
Machinery cost
Ownership
Operating
Supervision
Overhead cost
Interest cost
Total preharvest

HOURS
HOURS

12.02
60.33

5.19 62.32
4.09 246.57

146.30
138.54
153.94
105.89
104.07
.................................$2,563.04

62 $/Carton
63 Total preharvest ................................. $2.56
X Y Z AA AB AC AD
130
131

Figure 11. Summary Table Non-Input Section

CMD READY

F77: (F2) U

PA9: (FO) U 2 C14D READY

AF AG AA AB AC AD
5 Tractor Selection Form
6 Tractor
7 ID Item ID
8 1 TRACTORS 1
9 2 40 hp 2 <...--.....----.---............ 2
10 3 70 hp 3 <....................... 3
11 4 85 hp < ....................... 4
12 5 100 hp < ....................... 5
13 6 125 hp < ....................... 6
14 7 150 hp <---------------------....................... 7
15 8 160 hp 8 <..--------.----------..................----- 8
16 9 180 hp < ....................... 9
17 10 < ....................... 10
18 11 < ....................... 11
19 12 < ....................... 12
20 13 < ....................... 13
21 14 <....................... 14
X Y Z AA AB AC AD
136
137

Figure 12. The Tractor Selection Form

AA23: (FO) U 0CD READY

AG AA AB AC AD AE
5 Machinery Selection, Data Input and Tractor-Implement Matching Form
6 Tractor Acres Times
7 Item ID /Hour Over ID
22 IMPLEMENTS 1 1 TRACTORS
23 6-ft weed chopper 2 40 hp
24 1-row mower 3 5.00 1 3 70 hp
25 12-ft disk 85 hp
26 13-ft heavy disk 8 7.50 8 100 hp
27 16-ft disk 125 hp
28 14-ft leveler 150 hp
29 Row marker 8 160 hp
30 3-row shanks 3 10.00 1 180 hp
31 Ditch plow
32 V-ditcher
33 V-board
34 14-ft reverse plow
35 1-row middle buster
X Y Z AA AB AC AD
138 139 Hour and the Times Over>

Figure 13. The Machinery Selection and Data Input Form

AA9: (FO) U 2

CMD READY

right side of this screen. These numbers are located in the row of an implement
that has been selected for the budget and is pulled by the tractor that it identifies.
The value to the right of the ID numbers are the number of acres worked per hour
and the number of times the operation was performed, respectively. Only the Acres
per Hour and the Times Over columns can be used for the miscellaneous machinery
items since they are self-propelled and do not require a Tractor ID number.

CAUTION: A maximum of 26 machinery items can be selected in the two machinery
entry forms. Selecting more items will result in an error message appearing during
the (G)enerate option execution. You will have to delete items that are in
exceeding 26.

If you have rearranged the position of machinery items in the Machinery
Complement file, the display of those items in the (I)nput data, (M)achinery entry
form will also show the changes. Therefore, the data originally entered for the
items selected is no longer valid since they now appear beside other machinery
items. You will need to delete the data from the current locations and reenter
them in the same rows where the correct items are now located.

Press [Return] or [Esc] to return the Input Menu.

(L)abor Press the L key to select the (I)nput data, (L)abor option. The upper part
of a table will appear as shown in Figure 14. All labor requiring operations are
entered in this table except for tractor labor. Enter the name of the operation in
the first column. In the second column enter the amount of hours per acre
required for each operation. In the third column enter the number of times the
operation is repeated per acre; that is, the times over. There are 19 input rows in
this section. VEG-BUD will calculate the machinery labor requirements based on
the machinery usage. This is explained in a following section.

Press [Return] or [Esc] to return the Input Menu.

(O)ther: Press the 0 key to select this option. The Miscellaneous Input Form will
appear (Figure 15). There are two sections in this input table: the Preharvest Cost
Factors section and the Labor Factors section.

The four items in the preharvest cost section are:

Supervision: Enter the percent of the preharvest cost that best estimates the
supervision cost per acre. This is determined by taking all salaries and
benefits associated with the personnel supervising field operations; for example,
the farm manager, spray and irrigation captains, etc., dividing it by the
number of crop acres supervised by each supervisor, adding all salaries per
acre and the dividing it by the total preharvest cost of the budget. When
appropriate you may need to prorate each salary and benefits according to the
amount of time spent on each crop for more accuracy. A 7 percent for
supervision was used for the Dade County Ground Tomato budget and was
entered as a 7 and not .07.

Overhead: Enter the percent of the preharvest cost that best estimates the
overhead cost per acre. You should include the depreciation of buildings or
rental cost, office expenses, including salaries, supplies, utilities, insurance,

R9: U 'Haul plastic

0 R S T U V
4 .-...-.........-.. ...................... -.. -............- ........
5 Hours/Acre Times Total Cost per
6 Description /Operation Over Hrs/Acre Acre
7 ........-------- --------- -------------------------------------------
8 CULTURAL LABOR
9 Haul plastic 1.00 1 1.00 4.09
10 Lay plastic by side 6.25 1 6.25 25.54
11 Fumigate & Lay plastic 2.50 1 2.50 10.22
12 Prepare plug mix 0.50 1 0.50 2.04
13 Plant 2.00 1 2.00 8.17
14 Thin plants 6.25 1 6.25 25.54
15 Prune plants 25.00 1 25.00 102.18
16 Supplemental fertilizer 0.17 2 0.33 1.35
17 Other cultural 15.00 1 15.00 61.31
18 Frost protection 1.50 1 1.50 6.13
19 0.00 0.00
20 0.00 0.00
X Y Z AA AB AC AD
130
131

Figure 14. The Labor Input Table

L91: (F2) U 7 CMD READY

G H I J K L M N
86
87
88 Miscellaneous Input Form
89 ----------------
90 Preharvest Cost Factors
91 Supervision (%) 7.00
92 Overhead (X) 4.50
93 Loan Interest Rate (X) 12.00
94 Interest Payment Factor (X) 75.00
95 Loan Duration (months) 6.00
96
97 Labor Factors
98 Tractor Labor/Tractor Hour 1.25
99 Machinery Operator Wage ($) $5.19
100 Cultural & Other Wage ($) $4.09
101 I
102
X Y Z AA AB AC AD
134
135 CAUTION: Incorrect entries may seriously alter the budget costs.

Figure 15. The Miscellaneous Input Form

CMD READY

etc., required for preharvest operations. A. value of 5 percent was used for
the budget in this example.

Loan interest rate: Enter the interest rate the bank placed on your
production loan. Otherwise, enter the rate available to other farmers in your
area.

Interest Payment Factor: This is an interest cost adjustment factor. Enter the
factor that can best estimate the actual interest cost for the preharvest
operations. Entering 100 means that the actual interest cost for the
preharvest operations is equal to the interest rate times the total preharvest
cost, adjusted for the number of months of duration for the crop or loan.
Using 50 would make the interest cost half of that total. Since most loan
withdrawals are made as the crop grows according to cash flow needs, and
actual interest cost is calculated on each withdrawal amount and time
withdrawn, the actual interest cost for the preharvest operation is usually less
than the total calculated by multiplying the interest rate times the amount of
the loan for duration of the crop. The interest payment factor will adjust
that total.

Loan Duration: Enter the number of months between the first loan withdrawal
for the crop and the date of repayment.

The labor factors are:

Tractor Labor/Tractor Hour: Enter a value which, when multiplied by the hours
a tractor is used, will give the number of hours of tractor labor required to
operate the tractor. For example, a factor of 1.25 means that for every hour
of tractor use the number of hours of tractor labor required is 1.25.

Machinery Operator Wage: Enter the average wage plus benefits for machinery
operators, in dollars per hour.

Cultural & Other Wage: Enter the average wage plus benefits earned by field
workers in all activities other than tractor operators, in dollars per hour.

Press [Return] or [Esc] to return the Input Menu.

(T)itle: Enter the name of person preparing the budget and the season for which
the budget is made.

Press [Esc] to return the Budget Menu.

(V)iew budget: This option is selected to view the budget output tables. If you have just
created a new budget using (C)reate, (B)lank, before you select (V)iew budget you must
have selected (G)enerate in order to create the budget output tables. If you do not, you
will hear a beep, and, an error message will appear prompting you to (G)enerate before
you (V)iew. There is no need to do this for the budgets that come with VEG-BUD since
the output tables have already been created. It is not possible to make changes to the
output tables when selecting (V)iew budget (discussed later in this section). Changes to
the budget can only be made by selecting either (I)nput data or (E)rase from the Budget
Menu. Upon selecting the (V)iew budget option, another menu will appear showing the
budget tables available for viewing: (S)ummary table, (M)achinery table and (L)abor table.

(S)ummary table: Select the (S)ummary table option. The summary table will be
displayed on the screen as shown in Figure 16. The table displays all inputs and
the corresponding unit, quantity, price and cost entered using the (I)nput data
(N)on-machinery option, as well as the totals for machinery and labor costs entered
in the (I)nput data (M)achinery and (L)abor options of the Budget Menu. To view
the table use the arrow keys to move one cell at a time, or the [End] key to view
the lower side of the table. The [Home] key returns you to the upper side of the
table. This table may only be viewed and should not be confused with the input
table under the (I)nput data, (N)on-machinery menu option which is used for data
input and has a similar table format. When done viewing this table simply press
[Return] or [Esc].

(M)achinery table: Select the (M)achinery table option. A table will appear on the
screen as shown in Figure 17. The table shows the names of all the machinery
selected for this budget and the corresponding hours used per acre and fixed and
variable costs per hour and per acre. The items on this table were selected from
the Machinery Complement list using the (I)nput data, (M)achinery, (Y)es menu
option.

To view the table use the arrow keys to move one cell at a time or use the [End]
key to view the lower side of the table. The [Home] key returns you to the upper
side of the table. When done viewing this table press [Return] or [Esc].

(L)abor table: Select the (L)abor table option. As shown in Figure 18, this table
contains a list of all the cultural labor operations, the hours per acre required by
each operation and the number of times they were executed per acre (times over),
which were entered using the (I)nput data, (L)abor menu option. The cost per acre
is based on the total hours per acre of an operation times the wage rate entered
using the (I)nput data, (O)ther menu option. The total hours per acre for tractor
labor is based on the entries made in the (I)nput data, (M)achinery, (Y)es menu
option and the tractor-labor to tractor-hour factor entered using in the (I)nput
data, (O)ther menu option. The cost per acre for tractor labor is based on the
total hours of tractor labor per acre times the machinery operator wage entered
using the (I)nput data, (O)ther menu option.

To view the table use the arrow keys to move one cell at a time or the [End] key
to view the lower side of the table. The [Home] key returns you to the upper side
of the table. This table may only be viewed and should not be confused with the
input table under (I)nput data, (L)abor menu option which is used for data input
and has a similar table format. When done viewing this table press [Return] or
[Esc].

(G)enerate: Select this option every time you make changes in the input tables and wish
to revise and view the budget tables. When you select the (G)enerate option the
underlying spreadsheet is recalculated and the budget output tables are reconstructed.

(A)nalysis: Select this option by pressing the A key. A sensitivity analysis table like the
one in Figure 19 will be displayed which can be used to make what-if type analyses of
costs, yield, and prices. You may want to use this option before using the (G)enerate
option when testing yield, total preharvest costs or total harvesting, packing and
marketing costs.

There are four options in the (A)nalysis sub-menu: (P)rice, (A)djustments, (I)ncrement,
(C)alc and (Q)uit. A description of each option follows:

A89: U CI4D READY

E F

Item Units Quantity Price Cost

YIELD PER ACRE: Cartons 1,000 Total S/A=$5,733.04

PREHARVEST
Material Inputs
FERTILIZERS
13-0-44
2-30-4
6-12-12
Soil fumigant
Plastic mulch
Seed
Plug mix
HERBICIDES
Paraquat
X I

LBS
LBS
LBS
LBS
ROLLS
ONZS
BAGS

200.00
375.00
2000.00
200.00
2.50
5.00
5.00

ORTS 1.00
Y Z AA
e [Home], [End] & Arrow keys
After viewing press [Return]

0.19
0.12
0.12
1.00
65.00
25.00
7.00

11.25
AB AC
for moving>
for Menu>

Figure 16. The Budget Summary Table

H49: U CMD READY

H I J K L M N 0
/. .......... .............................................................

Hours Doltars/Hour

**** Dollars/Acre ----

Description /Acre Fixed Var. Fixed Var. Total
.......... ..... ........o...... .o......................... ......... .......

TRACTORS
40 hp
70 hp
160 hp
IMPLEMENTS
1-row mower
13-ft heavy disk
3-row shanks
3-row middle buster
3-row bedder
3-row fumigator
3-row fert. distrib.
Fertilizer tender
X Y

6.26 2.11 3.19
2.03 3.87 5.71
1.33 9.68 13.61

0.20
1.07
0.10
0.13
0.13
0.20
0.40
0.40
Z
ome], [End]

13.22
7.86
12.84

19.98
11.58
18.05

2.62 1.50 0.52 0.30
12.32 4.20 13.14 4.48
2.62 0.60 0.26 0.06
2.38 0.90 0.31 0.12
2.66 2.00 0.35 0.26
5.99 4.50 1.20 0.90
12.39 10.50 4.96 4.20
8.85 7.50 3.54 3.00
AA AB AC AD
& Arrow keys for moving>

33.20
19.44
30.90

0.82
17.62
0.32
0.43
0.61
2.10
9.16
6.54

133

Figure 17. The Budget Machinery Table

$/Acre

38.00
43.13
230.00
200.00
162.50
125.00
35.00

11.25
AD

CMD READY

A89: U

CMD READY

Q R S T U V
35 .........................------------------------.........-------..............----------........
36 Hours/Acre Times Total Cost per
37 Description /Operation Over Hrs/Acre Acre
38 ------------------..................---......--------------------..........................-------
39 CULTURAL LABOR
40 Haul plastic 1.00 1 1.00 4.09
41 Lay plastic by side 6.25 1 6.25 25.54
42 Fumigate & lay plastic 2.50 1 2.50 10.22
43 Prepare plug mix 0.50 1 0.50 2.04
44 Plant 2.00 1 2.00 8.17
45 Thin plants 6.25 1 6.25 25.54
46 Prune plants 25.00 1 25.00 102.18
47 Supplemental fertilizer 0.17 2 0.33 1.35
48 Other cultural 15.00 1 15.00 61.31
49 Frost protection 1.50 1 1.50 6.13
50
51 Total cultural Labor .................... 60.33 $246.57
X Y Z AA AB AC AD
132
133

Figure 18. The Budget Labor Table

AR4: (FO) CMD MENU
Price Adjustments Increment Catc Quit
Enter the unit price of commodity
ARAS AT AU AV AW AX AY AZ BA BB B
4 SENSITIVITY ANALYSIS TABLE
5
6 Table Yield change-> 0 Preh cost % chg -> 0
7 Increments Yield: 1,000 Cost/Ac: $5,733 HP&M cost % chg -> 0
8 Price +================= P R I C E ================+
9 -> 0.5 | $0.00 $0.00 $0.00 $10.00 $0.00 $0.00 $0.00 |
10 Yield +........................................ .......................----
11 -> 100 .................. Dollar Net Return Per Acre -----..........------..
12 Y ......+
13 0 0 0 0 0 0 0 0
14 1 0 0 0 0 0 0 0 0
15 0 0 0 0 0 0 0 0
16 E 0 0 0 0 0 0 0 0
17 0 0 0 0 0 0 0 0
18 L 0 0 0 0 0 0 0 0
19 0 0 0 0 0 0 0 0
20 D +-.....---...--.....................-----..........................-.+
X Y Z AA AB AC AD
144
145

Figure 19. The Sensitivity Analysis Table

039: U

(P)rice: Enter an expected price by selecting (P)rice. This price should be an
expected average selling price.

(A)djustments: There are three adjustments that can be made to the budget for
sensitivity analysis purposes They are:

1. Yield Change: You can change the yield to use for the analysis by entering an
amount (positive or negative) to add or subtract to the yield specified in the
budget. This yield can be seen in the top part of the sensitivity analysis
tablebeside "Yield:". To use the same yield as was specified in the budget,
enter a zero beside "Yield Change ->"

2. Preharvest Cost Percent Change: You can enter a percent amount to the right
of "Preharvest Cost % Chg ->" which will adjust the preharvest cost. Entering
a 100 will subtract the full preharvest cost (or 100 % of the preharvest cost)
from the analysis. Entering a 5 adds 5 percent of the preharvest cost to the
preharvest cost total.

3. Harvest, Pack and Market Cost Percent Change: This works similar to the
preharvest cost adjuster; for example, entering a 10 will increase harvesting,
packing and marketing cost by 10 percent.

The cost shown beside "Cost/Acre" is the current total cost in the budget.
This total will change with the changes you make to yield and costs.

NOTE: The changes made in the sensitivity analysis table do not alter the
actual budget tables.

(I)ncrement: Select (I)ncrement to adjust the sensitivity analysis table by specifying
the desired increment for yield and price. This feature makes it possible to adjust
the range of prices or yield you wish to consider in an analysis. Entering a 0.5
under "Price" will make the prices to the right of the inputed price (in green color
on color monitors and appearing in a darker shade on monochrome monitors)
increase by $0.50 per unit and those to the left of the inputed price decrease by
$0.50 per unit. Similarly, entering 100 under "Yield" will increase the numbers
below the green colored (or in a darker shade) number in the middle of the column
by 100 units and those above it will decrease by 100 units.

When you enter increment values no changes will be displayed on the screen. Only
when you (C)alc the table will you see the price and yield values change.

(C)alc: Select this option after making all the entries and you are ready to view the
results. The (C)alc option must be selected every time you make changes to the
table values.

(Q)ult This option is required to return to the Budget Menu. Pressing [Esc] will not
work.

NOTE: This table is not stored with the rest of the budget data. If you wish to
record the values of this table you need to print the table by selecting (P)rint,
(3)-Way table from the Budget Menu (see (P)rint section below).

(E)rase: With the (E)rase option you can delete data in blocks rather than one cell at a
time. There are six (E)rase options. They are:

(P)reharvest: Selecting this option you can erase 31 rows and four columns under
Material Inputs and eight rows and two columns under Custom Work & Other.

(H)arv-pack-mkt: Selecting this option you can erase all entries under Harvest &
Haul and Pack & Market.

(M)achinery: All the machinery selections and requirements are deleted.

(L)abor When you select this option all 19 rows and three columns for labor in the
input table are deleted.

(O)ther: All values entered in the Miscellaneous Input Form are deleted with this
option.

(G)Iobal: All the above options are executed with this option. In addition, the Title
Page entries are also deleted.

Press [Esc] to return the Budget Menu.

(P)rint You can print the budget tables and other by tables selecting this option.
Samples of the budget printouts are included in the Appendix. There are seven options
under (P)rint. They are:

(S)ummary: Selecting this option prints the budget summary table.

(M)achinery: Selecting this option prints the budget machinery table.

(L)abor Selecting this option prints the budget labor table.

(O)ther Selecting this option prints the miscellaneous input table.

(3)-Way table: Selecting this option prints the sensitivity analysis table.

(T)itle: Selecting this option prints the Title Page of the current budget.

(G)Iobal: Using this option you can print all the above tables and Title Page
simultaneously. Be sure you have created the summary, machinery, labor and
sensitivity analysis tables before selecting this option.

If you select (S)ummary, (M)achinery or (L)abor prior to having selected (G)enerate,
or select (3)-Way table before having selected (A)nalysis, you will hear a beep and
an error message will appear prompting you to select (G)enerate or (A)nalysis,
whichever the case may be, before printing.

(S)ave: Select this option to permanently store to disk changes made to the budget.
VEG-BUD provides a verification menu with a (Y)es or (N)o option to make sure you
make the right choice. As with the Lotus 1-2-3 program, VEG-BUD does not save the
changes that you make automatically.

CAUTION: Never attempt to save the budget using the actual Lotus 1-2-3 save menu
option. If you do, unwanted data will be stored, increasing the size of the file as well
as increasing the time it takes to load or save the file. This is more serious for dual

floppy drive systems since, normally, no more than five budget files can be stored in one
disk.

(Q)uit: Select this option to return the VEG-BUD Main Menu. VEG-BUD provides a
verification menu with a (Y)es or (N)o option to make sure you make the right choice.
Returning to the Main Menu usually takes a few seconds before it loads the Main Menu
file.

CAUTION: Any changes made to a budget will be lost if you select (Q)uit, (Y)es without
first having selected the (S)ave option.

MACHINERY COMPLEMENT

The Machinery Complement is a list of all the machinery needed to create budgets. It
contains information such as machinery prices, expected life, horse power, maintenance and
repair factors, fuel prices, etc. VEG-BUD already comes with a number of vegetable
machinery items included. Machinery can be added to or deleted from the Machinery
Complement.

You can retrieve the Machinery Complement file by pressing the M key for (M)ach/Comp
from the Main Menu. The Machinery Complement Menu contains the following options: (I)nput
data, (G)enerate, (V)iew table, (E)rase, (P)rint, (S)ave and (Q)uit (Figure 20). An explanation
of each of these menu options follows:

(I)nput data: This menu option lets you enter data in three sections. The definition of
the input items in the Machinery Complement are found in the DEFINITION OF TERMS
section. The menu options are: (M)achinery, (P)arameters and (T)itle. This section
should not be confused with the (I)nput data section of budgets explained on page 12.

(M)achinery: Selecting the (M)achinery option brings you to the Machinery
Complement list (Figure 21). There are six entry columns and 96 entry rows.
There are three categories of machinery: Tractors, Implements and Miscellaneous
machinery. There are 13 entry rows under Tractors, 64 under Implements, and 19
under Miscellaneous. Under Miscellaneous there are three sections according to fuel
type (Diesel: the eight first rows, Gasoline: the six following rows, and Other: the
three following rows) and one for electrically driven machinery, which uses the last
two rows. Extra attention should be paid when entering miscellaneous machinery
since no subdivision titles are displayed.

In the Description column enter the name of the machinery. Enter the purchase
price (or current market value) of the machinery in the price column. Enter the
years of life (or the remaining years of life) for the machinery in the Years of Life
column. Enter hours of life (or the remaining hours of life) for the machinery in
the Hours of Life column. In the Horsepower column, enter the horse power of
tractors or the consumption of fuel for the miscellaneous machinery in gallons per
hour. To calculate your own Maintenance & Repair Factor in the last column, take
the annual maintenance and repair cost for the machinery, multiply it by the years
of life (or remaining years of life) and divide the product by the purchase price
(current market value). Estimates for the M & R factor (as a percent of the
purchase price) and the expected hours of life for some machinery can be found in
the American Society of Agricultural Engineer's "ASAE Standards" (see
REFERENCES).

CAUTION: Rearranging the position of any machinery items in the Machinery
Complement list requires that you also rearrange the data entered within the
budgets already created under (D)ata Input, (M)achinery (See also BUDGETS, (I)nput
data, (M)achinery on page 14).

Press [Return] or [Esc] for the Input Data Menu.

(P)arameters. Enter the percentage number for salvage value, long term loan interest
rate and a percentage number for machinery taxes, housing and insurance (THI)for
all machinery items (Figure 22). The value for taxes, housing and insurance is the
percentage of the purchase price (or current value) of a machine that is used to

01:
Input data Generate View table Erase Print Save Quit
Input machinery and equipment values, parameters and make
0 P 0 R S

CMD MENU

title changes
T U

Fresh Vegetables

BUDGET GENERATOR

<<<>>>

Machinery Complement and Cost Tables

Prepared by: E. B.

Season: 1984-85

0 P Q R S T U V
21
22

Figure 20. The Machinery Complement Menu and the Title Screen

B9: (T) U 40.hp

CMD READY

Description

TRACTORS
40 hp
70 hp
85 hp
100 hp
125 hp
150 hp
160 hp
180 hp

C D E F G

Purchase Expected Life Horse- M & R
$ Price Years Hours power Factor
.... .. .......... o o ..oo oo...... ..... t.....

12,000
22,000
28,000
38,000
42,000
50,000
55,000
65,000

10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000

0 P Q R S T U
23 24 [Return] when done>

Figure 21. The Machinery Complement Input Table

calculate the yearly expenses for taxes, housing and insurance. Also enter the price
of gasoline, diesel and when applicable, one other fuel type in dollars per gallon.
Enter the cost of electricity in dollars per hour of operation. To compute an
average figure for electricity cost, divide the monthly electricity bill by the number
of Kilowatt-hours used for the month. The salvage value, interest rate and the
value for taxes, housing and insurance entered are used in VEG-BUD for all the
machinery. These values do not vary from one machinery item to another.

Press [Return] or [Esc] for the Input Data Menu.

(T)itle: Enter the name of a person associated with the Machinery Complement data
and the season for which the data is relevant.

Press [Esc] twice for Machinery Complement Menu.

(G)enerate: Selecting the (G)enerate menu option recalculates the whole spreadsheet and
creates a machinery cost table using the latest data entered. This menu option is
required before making a printout of either the Machinery Complement table or the
Machinery Cost table and before selecting (V)iew table.

(V)iew table: this menu option allows you to view the Machinery Cost table (Figure 23).
To view the Machinery Cost table you must select (G)enerate either at the beginning of
the work session or after the most recent data are entered. If you have not selected
the (G)enerate option before you select the (V)iew table option, you will hear a beep and
an error message will appear on the control panel prompting you to (G)enerate before
you select (V)iew table. The Machinery Cost table contains fixed and variable costs per
hour for each item entered in the Machinery Complement input table.

039: (C2) U 1

CMD READY

P 0 R

S T U

Parameter Entry Form

Fuel Price ($/Unit) Fixed Cost X

Diesel $1.00 Salvage value 10.00 |
Gas $1.00 Loan interest rate 12.00 |
Other $0.75 Taxes+Housing+Insur 2.00 |
Electricity $0.00 I

0 P Q R S T U
29
30 CAUTION: Incorrect entries may seriously alter the true machinery cost.

Figure 22. The Parameter Entry Form

Press [Return] or [Esc] for Machinery Complement Menu.

(E)rase: With the (E)rase option you can delete data in blocks rather than one cell at a
time. There are six (E)rase options. They are:

(T)ractors: Selecting (E)rase, (T)ractors deletes 13 rows and the six columns under
Tractors from the Machinery Complement list.

(I)mplements: Select (E)rase, (I)mplements to delete all 50 rows and the six columns
under Implements from the Machinery Complement list.

(M)iscellaneous: You can delete all entries under Miscellaneous from the Machinery
Complement list with the (E)rase, (M)iscellaneous option.

(P)arameters: Delete all entries in the Parameter Entry Form selecting (E)rase,
(P)arameters.

(G)lobal: Delete all entries in the Machinery Complement, the Parameter Entry Form
and the Title Page.

NOTE: If you have erased data from the Machinery Complement and wish to recover
it you can do so by returning to the Main Menu and selecting (M)ach/Comp again.
This will only work if you have not saved the changes made using the (S)ave
option. You will, however, loose any data you had previously entered before the
(E)rase procedure.

M115: U

CHD READY

k B H I J K L M

DoLlar Cost Per Hour
Description Fixed M & R Fuel Variable Total

2.11
3.87
4.93
6.69
7.39
8.80
9.68
11.44

1.44
2.64
3.36
4.56
5.04
6.00
6.60
7.80

1.75
3.07
3.72
4.38
5.48
6.57
7.01
7.88

3.19
5.71
7.08
8.94
10.52
12.57
13.61
15.68

opper 3.01 1.73 1.73
2.62 1.50 1.50
8.80 3.00 3.00
P Q R S T

Figure 23. The Machinery Cost Table

TRACTORS
40 hp
70 hp
85 hp
100 hp
125 hp
150 hp
160 hp
180 hp
IMPLEMENTS
6-ft weed cho
1-row mower
12-ft disk
0

5.30
9.58
12.01
15.63
17.91
21.37
23.29
27.12

4.74
4.12
11.80
U

Press [Return] or [Esc] for the Machinery Complement Menu.

(P)rint: The (P)rint option lets you print the Machinery Complement table, the Machinery
Cost table, the Parameter Entry Form and the Title Page. To print any of these tables
select (P)rint, then (I)nput table, (C)ost table, (P)arameters or (T)itle, respectively.
Select (G)lobal to print all the tables and the Title Page. Samples of the Machinery
Complement printouts are included in the Appendix. With the exception of the Parameter
Entry Form and the Title Page, you can print any of the tables only after you select
(G)enerate. If you have not selected the (G)enerate option before you select a (P)rint
option, you will hear a beep and an error message will appear on the control panel
prompting you to (G)enerate before you (P)rint. Press [Esc] from the (P)rint Menu to
return to the Machinery Complement Menu.

(S)ave: Select (S)ave when you have entered data in the Machinery Complement section
which you wish to store permanently. To modify entries already saved, you need to
make the changes and re-save the entries selecting (S)ave again. Another menu will
appear with (Y)es or (N)o options after selecting (S)ave to make sure you make the
proper selection.

CAUTION: Never attempt to save the Machinery Complement using the actual Lotus 1-2-3
save menu option. If you do, unwanted data will be stored, increasing the size of the
file as well as increasing the time it takes to load or save the file.

(Q)uit: This option returns you to the Main Menu! VEG-BUD requires that you verify
the (Q)uit selection using a (Y)es or (N)o option. This protects you from erroneously
selecting (Q)uit without saving the contents of the Machinery Complement when desired
changes were made.

QUICK REFERENCE

This quick reference section is provided for looking up many of the common VEG-BUD
operations. The list is in alphabetical order.

(C)reate a budget: You can create a new budget in either of two ways: 1) from scratch or 2)
using data from an existing budget. To create a budget from scratch you need to select
(B)udgets, (C)reate, (B)lank from the Main Menu. If you want to use the data of an already
existing budget select (B)udgets, (C)reate, (E)xisting.

(D)elete a budget: When you have no more use for a budget and wish to delete it from
storage select (D)elete from the Main Menu. You may delete only one budget at a time.

Edit the contents of a cell: To edit the contents of the cell where the cellpointer is located,
press the F2 key (Edit key). Use the [Back space] key to delete characters to the left of the
cursor or the [Del] key to delete characters 'to the right of the cursor. Enter the desired
data or information and press [Return]. It is sometimes preferable to reenter the data or
information instead of editing when there are only a few characters in the cell.

Enter data in a cell: Place the cellpointer in desired cell, type in the data and press [Return].
When entering numbers with text in the same cell or when entering a number as text, first
enter an apostrophe (') and then the number.

(E)rase a block of data: This feature permits you to erase a group of data in one operation
rather than. cell by cell. This feature is available in both the budget files and in the
Machinery Complement file. To erase a block of data select (E)rase from the menu. A
submenu will appear with several choices of data to erase. Select the one you wish to erase.

Erase the contents of a cell: To erase the contents of a cell press the [Space-Bar] once and
then press [Return].

Leave input tables: To exit out of an input table simply press [Return] without entering any
input. This is called an empty or null [Return].

Move around data input tables: To move around any input table in VEG-BUD you can use any
of the four arrow keys, the [Home] key and the [End] key. The [Home] key takes you to the
upper left corner of the table and the [End] key to the lower right corner. The [Page Up]
and [Page Down] key do not work; if they are pressed you will hear a beep.

Move around menus: To move within a menu you can use the right [->] and left [<-] arrow
keys, the [Home] key and the [End] key. The up and down arrow keys as well as the [Page
Up] and [Page Down] keys will not work. To move from one menu to another press [Return]
at any menu option or press the first letter of the option. To return to the previous menu
you can either select (Q)uit or [Esc]. When no (Q)uit option is available in a menu pressing
[Esc] will return you to the previous menu. If the (Q)uit option is shown, you are required to
select (Q)uit to return to the previous menu. Pressing [Esc] will not work.

(R)ename a budget: To rename an existing budget select (R)ename from the Main Menu.

CAUTION: Do not attempt to edit a budget name either from the Budget Listing in the Main
Menu or from the Title Page of a budget file when you break out of the program macro. If
these two names are not identical VEG-BUD will use the name from the Budget Listing and
save the budget.

Re-setup of VEG-BUD: If you are changing computers, from a dual floppy drive system to a
hard disk system or vise versa, and want to run VEG-BUD, you will have to set up the
VEG-BUD program and budget files again. .

Dual floppy drive to hard disk system:

When changing from a dual floppy drive system to a hard disk system, you will have to
copy both the VEG-BUD program disk and all the Budgets disks to a subdirectory on the
computer's hard disk. Follow the instruction on backing up VEG-BUD on a hard disk in
this manual. When you reach step 7 of that section, copy the Budgets disks included
with VEG-BUD as well as all other Budgets disks you now have. Insert any one of the
Budget disks (not the VEG-BUD program disk) in drive A and follow the instruction in
the VEG-BUD setup section of this manual. After step 1, the VEG-BUD Main Menu will
appear. At this point hold down the [Ctrl] key and press the [Break] key and then press
[Return]. Now hold down the [Alt] key and press the S key to call the setup program.
Continue with step 2. To set up the budgets continue with step 3. To call the setup
program in the budget file, hold down the [Ctrl] key and press the [Break] key and press
[Return]. Hold the [Alt] key and press the S key. This must be done on every budget
in the Budget Listing to complete the re-setup procedure.

Hard disk to dual floppy drive system:

Follow the instructions in the VEG-BUD setup for dual floppy drive systems in this
manual. After completing step 1. and before you continue with step 2, hold down the
[Ctrl] key and press the [Break] key and then press [Return]. Then hold down the [Alt]
key and press the S key to call the setup program. Before you continue with step 4 for
each budget in the Budget Listing you must also call the setup program using the [Alt]-S
keys as described above.

Returning the Menu: VEG-BUD was programmed using Lotus macros. It is possible to "break
out" of the macros in certain situations. To recover the Main Menu you must press [Return],
and then hold down the [Alt] key and press the M key. Some of the cases where you can
break out of the program macro are as follows:

1. On dual floppy drive systems, electing a budget not stored on the Budgets (work)
disk when using the Main Menu (S)elect, (C)reate, (R)ename and (D)elete options.
To avoid this, always write down the names of the budgets in the disk on the disk
label.

2. In some computers printing a table with the printer turned off.

3. Improper program setup. The drive or subdirectory you specified in the initial setup
is incorrect and VEG-BUD is searching for a file in the wrong drive or
subdirectory.

4. Pressing the [Esc] key when VEG-BUD prompts you to enter a file path in the
setup procedure.

5. Entering more than 26 machinery items in the two machinery entry forms in budget
files.

6. Pressing the [Ctrl] [Break] key.

CAUTION: Do not try to use the Lotus Help facility if you have broken out of a macro.
That is when the menu does not appear on the control panel in the upper part of the
screen and the Lotus window on the upper right hand corner of the screen reads READY.
If you press the key that activates the Lotus help facility [Fl], VEG-BUD will "bomb"
and any data entered after you last saved the file will be lost.

(S)ave a budget: To save the input and output data of a budget select (S)ave, (Y)es from the
Budget Menu of the budget file you are currently in.

DEFINITION OF TERMS

This section is divided into Machinery Complement and Budget terms and are given in
alphabetical order.

In budget files:

Cultural and Other Wage: It is the average wage plus benefits per hour earned by field
workers in all other activities other than for tractor operators.

Harvest and Haul: Is the cost of harvesting and hauling on a per unit basis. A third row is
available to enter some other cost involved with these operations.

Interest Payment Factor: This is an interest cost adjustment factor. It is the factor that can
best estimate the actual interest cost for the preharvest operations.

Machinery Operator Wage: The average wage plus benefits per hour for machinery operators.

Loan Duration: It is the number of months between the first and loan withdrawal for the crop
and the loan payment.

Loan Interest Rate: This is the interest rate on a production loan used for estimating
preharvest interest cost.

Overhead: It is the percent of the preharvest cost that best estimates the overhead cost per
acre.

Pack and Market Enter all packing and marketing costs on a per unit basis. You should
include items such as containers, overhead, depreciation of buildings and equipment, selling
costs, transportation costs, all on a per unit basis. There are nine rows available in this
section.

Preharvest Custom Work & Other: Enter all preharvest costs here that were not included in
the Material Inputs section. These cost items include custom work, land rent, insurance, etc.,
and all material inputs for which only the total cost per acre is available.

Preharvest Material Inputs: All materials used in the production process before harvest are
entered in this section. Up to six subtitles may be entered; for example, INSECTICIDES,
FERTILIZER, HERBICIDES, etc. To do this enter the title in the Item column and leave the
Units, Quantity and Price columns blank. For each item entered under Item, enter the
corresponding units, quantity used and the price per unit. The cost column will not adjust
automatically as you enter the values. Only when you (G)enerate will they be updated.

Supervision: This is the percent of the preharvest cost that best estimates the supervision cost
per acre.

Times Over: The times over is equivalent to the number of times an activity is repeated. This
applies to machinery as well as labor operations.

Tractor ID: The tractor identification number makes it easy to identify and select tractors for
a budget. The user must first choose the tractors to be included in the budget by selecting
the corresponding tractor ID numbers in the Tractor Selection Form. Then, by entering a

tractor ID number next to an implement in the Machinery Data Input and Tractor-Implement
Matching Form the user matches tractors with implements.

Tractor Labor/Tractor Hour Factor: The value which when multiplied by the hours a tractor is
used will give the number of hours of tractor labor required to operate the tractor.

Yield per acre: The unit to use is entered under the Units column. All units used should be
entered in plural with an s ending; for example, Cartons, Crates, Bushels. Enter the yield
amount under the Quantity column.

In the Machinery Complement:

Expected Life Hours: The expected hours of life of a machine is the number of hours the
machine is technically expected to be in use. Many manufacturers of farm machinery provide
technical information on their machinery including the expected hours of life.

Expected Life Years: The expected years of life of a machine is the number of years the
machine is expected to be in use. Use this definition when using the amount spent for
purchase price. If you use the remaining value for purchase price, use the expected remaining
years of life of the machine. If you know the number of hours the machinery is used
annually you can calculate the expected years of life by dividing the expected hours of life by
the hours of use annually.

Fixed Cost per Hour: The fixed cost per hour for machinery is computed. using the following
formula:

FC/h = Expd. Life Hours Pur. Price*(1 Salvage V.%) Loan R.* 1.10*(Pur. Price) Pur. Price*(THI)
FC/h = + Loan Int. R.%* + Pur. Price*(THI%)
Expd. Life Years Expd. Life Years 2

where FC/h = Fixed Cost per hour
and THI = Taxes + Housing + Insurance

Fuel Cost per Hour: The fuel cost per hour is determined by multiplying the tractor PTO
horse power times the price of the fuel in dollars per gallon times 0.06 times a fuel factor.
The fuel factor is 0.73 for diesel and 1.0 for gasoline.

Horse Power: Only for tractors. Use the PTO horse power.

Loan Interest Rate: This is the interest rate that most banks will charge on loans for
purchases of machinery classified as investment loans. If you do not have any finance costs
it is recommended that you still enter a value that reflects the opportunity cost of your
money; for example, the interest rate on a certificate of deposit.

M & R Cost per Hour: The maintenance and repair cost per hour is computed by multiplying
the Purchase Price (or remaining value) of an item by the M & R Factor for that item and
then dividing by Expected Life in hours.

M & R Factor: The maintenance and repair factor is used to compute the maintenance and
repair cost component of variable costs. This factor is sometimes referred to in engineering
publications, such as ASAE Standards, as RF1 or the "total life repairs" expressed as a percent
of list price. A more accurate estimation of actual costs can be made by taking the total
annual maintenance and repair cost of a machine, multiplying it by the expected years of life

(or remaining years of life) and dividing the product by the purchase price (or remaining
value).

Purchase Price: The purchase price is the actual dollar amount paid for a machine. You may
want to use the list price when you do not have the purchase price. You may also want to
use the remaining values of a machine when possible. This will provide a more accurate
picture of machinery costs.

Salvage Value: The salvage value is the remaining value of the machine when it is discarded
from the farm and is sold. Usually it is calculated using some percentage of the purchase
price. If you want to exclude salvage value from the machinery cost analysis enter a zero for
salvage value. The value you enter should be an average since it will apply for all the
machinery in the Machinery Complement.

Taxes + Housing + Insurance (THI): VEG-BUD accounts for machinery expenditures on taxes,
housing and insurance using a percent of the purchase price; that is, entering a 2 for T+H+I is
equivalent to an annual cost of 2 percent of the purchase price. The value you enter should
be an average from all the farm machinery since it will apply for all the machinery in the
Machinery Complement.

Total Cost per Hour The total cost of machinery per hour is the sum of the fixed cost per
hour plus the variable cost per hour.

Variable Cost per Hour: The variable cost per hour for machinery is the sum of the fuel cost
per hour plus the M & R cost per hour.

REFERENCES

ASAE Standards 1984. American Society of Agricultural Engineers. St. Joseph, Michigan.
May, 1984.

Buckley, K. C., et al. Florida and Mexico Competition for the Winter Fresh Winter Vegetable
Market. U.S. Department of Agriculture, Economic Research Service, Ag. Econ. Rep. No. 556.
June, 1986.

Phillips, S. and R. Alderman. "UFBUD, University of Florida Agricultural Budget Generator".
Circular 664. Food and Resource Economics Department, University of Florida. Gainesville,
Florida. August 1985.

APPENDIX:

VEG-BUD Printouts

Fresh Vegetables Budget Generator

<<>>

Developed by

E Belibasis, T Stevens & J VanSickle

Food & Resource Economics Department
Institute of Food and Agricultural
Sciences (IFAS)
University of Florida
Copyright (C) 1986, IFAS, UF
Release 1.0
-- -------------------------------------

-----------------+ BUDGET L I ST I NG

1 DadeGrdTom 13 25 37
2 SouthwStkTom 14 26 38
3 Rus-PalStkTom 15 :27 39
4 PBGrnPeppers 16 28 40
5 SouthwPeppers 17 29 41
6 DadeBushBeans 18 30 42
7 PBBushBeans 19 31 43
8 SouthwCukes 20 32 44
9 DadeSquash 21 33 45
10 PBEggplant 22 34 46
11 23 35 47
12 24 36 48

Fresh Vegetables

BUDGET GENERATOR

<<<>>>

Budget name: DadeGrdTom
Prepared by: E. B.

Season: 1984-85

-----------------------------------------------------

31-Jul-86

Budget name: DadeGrdTom
Prepared by: E. B.

Season: 1984-85

Item Units Quantity Price Cost

YIELD PER ACRE:

PREHARVEST
Material Inputs
FERTILIZERS
13-0-44
2-30-4
6-12-12
Soil fumigant
Plastic mulch
Seed
Plug mix
HERBICIDES
Paraquat
Sencor
INSECTICIDES
Monitor
Ambush
Lannate
Azadrin
FUNGICIDES
Maneb
Copper
Bravo
Benlate
BACTERICIDES
Strephtomycin
Sticker
Custom Work & Other
Frost protection
Plow
Wells
Dump fee
Land rent
Gases
Tractor labor
Other labor
Machinery cost
Ownership
Operating
Supervision
Overhead cost
Interest cost

Cartons

LBS
LBS
LBS
LBS
ROLLS
ONZS
BAGS

QRTS
FL ONZS

GALS
PINTS
GALS
QRTS

LBS
LBS
ORTS
LBS

ONZS
GALS

HOURS
HOURS

1,000 Total $/A=$5,733.04

200.00
375.00
2000.00
200.00
2.50
5.00
5.00

1.00
20.00

2.50
5.00
1.25
2.00

33.00
36.00
2.00
2.00

8.00
1.00

12.02
60.33

0.19
0.12
0.12
1.00
65.00
25.00
7.00

11.25
0.35

43.00
13.13
27.00
9.25

1.90
1.40
6.00
11.00

0.50
18.00

5.19
4.09

38.00
43.13
230.00
200.00.
162.50
125.00
35.00

11.25
7.03

107.50
65.63
33.75
18.50

62.70
50.40
12.00
22.00

4.00
18.00

104.03
50.00
15.00
4.00
180.00
6.00
62.32
246.57

146.30
138.54
153.94
105.89
104.07

Continues...

Continued...

Budget name: DadeGrdTom
Prepared by: E. B.

Season: 1984-85

Item Units Quantity Price Cost

Total preharvest .................................$2,563.04

$/Carton
Total preharvest ................................... 2.56
HARVEST & HAUL
Harvesting 0.63
Hauling 0.07
Total harvest & haul .... ............................. 0.70
PACK & MARKET
Packing 1.74
Carton box 0.58
Selling 0.15
Total pack & market ............................... 2.47
Total cost ................................ $5.73

Page 2 a+ 2

Budget name: DadeGrdTom
Prepared by: E. B.

Season: 1984-85

Hours Dollars/Hour -- Dollars/Acre ----
Description /Acre Fixed Var. Fixed Var. Total

TRACTORS
40 hp 6.26 2.11 3.19 13.22 19.98 33.20
70 hp 2.03 3.87 5.71 7.86 11.58 19.44
160 hp 1.33 9.68 13.61 12.84 18.05 30.90
IMPLEMENTS
1-row mower 0.20 2.62 1.50 0.52 0.30 0.82
13-ft heavy disk 1.07 12.32 4.20 13.14 4.48 17.62
3-row shanks 0.10 2.62 0.60 0.26 0.06 0.32
3-row middle buster 0.13 2.38 0.90 0.31 0.12 0.43
3-row bedder 0.13 2.66 2.00 0.35 0.26 0.61
3-row fumigator 0.20 5.99 4.50 1.20 0.90 2.10
3-row fert. distrib. 0.40 12.39 10.50 4.96 4.20 9.16
Fertilizer tender 0.40 8.85 7.50 3.54 3.00 6.54
Side hole puncher 0.20 1.99 0.75 0.40 0.15 0.55
3-row tomato planter 0.80 15.52 .9.33 12.41 7.47 19.88
2-row herb. sprayer 1.20 2.66 1.40 3.19 1.68 4.87
Sprayer 4.26 12.41 6.53 52.86 27.82 80.69
3-row scrapper 0.20 1.32 0.75 0.26 0.15 0.41
1-row plastic cutter 0.20 0.38 0.03 0.08 0.01 0.08
Baler 0.13 15.72 4.80 2.04 0.62 2.67
MISCELLANEOUS
Mixer 0.13 4.96 25.25 0.64 3.28 3.93
Truck mtd. 117-hp pump 4.22 3.52 7.52 14.86 31.75 46.61
2-ton truck 0.20 6.75 13.40 1.35 2.68 4.03

Total machinery cost ................. $146.30 $138.54 $284.84

Budget name: DadeGrdTom
Prepared by: E. B.

Season: 1984-85

Hours/Acre Times Total Cost per
Description /Operation Over Hrs/Acre Acre

CULTURAL LABOR
Haul plastic 1.00 1 1.00 $4.09
Lay plastic by side 6.25 1 6.25 25.54
Fumigate & lay plastic 2.50 1 2.50 10.22
Prepare plug mix 0.50 1 0.50 2.04
Plant 2.00 1 2.00 8.17
Thin plants 6.25 1 6.25 25.54
Prune plants 25.00 1 25.00 102.18
Supplemental fertilizer 0.17 2 0.33 1.35
Other cultural 15.00 1 15.00 61.31
Frost protection 1.50 1 1.50 6.13

Total cultural labor ..................... 60.33 $246.57
Tractor labor total ..................... 12.02 $62.32

Budget name: DadeGrdTom
Prepared by: E. B. Season: 1984-85

Miscellaneous Input Form

Preharvest Cost Factors
Supervision (%) 7.00
Overhead (%) 4.50
Loan Interest Rate (%) 12.00
Interest Payment Factor (%) 75.00
Loan Duration (months) 6.00

Labor Factors
Tractor Labor/Tractor Hour 1.25
Machinery Operator Wage ($) $5.19
Cultural & Other Wage ($) $4.09
- - - - - - - - - - -. - - - - - -. - - - - - -

Budget name:
Prepared by:

DadeGrdTom
E. B.

SENSITIVITY

Season: 1984-85

ANALY S IS

TABLE

Table Yield change-> 0 Preh cost % chg -> 0
rements Yield: 1,000 Cost/Ac: $5,733 HP&M cost % chg -> 0
Price +====================== P R I C E .=.===============
0.5 1 $5.50 $6.00 $6.50 $7.00 $7.50 $8.00 $8.50

Yield +
-> 100 I
Y +-------

1 700
I i 800
1 900
E 11,000
1,100
L 11,200
1,300
D +-----

Dollar Net Return Per Acre -------------

(932)
(699)
(466)
(233)
(0)
233
466

(582)
(299)
(16)
267
550
833
1,116

(232)
101
434
767
1,100
1,433
1,766

118
501
884
1,267
1,650
2,033
2,416

468
901
1,334
1,767
2,200
2,633
3,066

818
1,301
1,784
2,267
2,750
3,2337
3,716

1, 168
1,701
2,234
2,767
3,300
3,833
4,366

Inc

-'

-----------------------------------------------------------

------------------------------------------------------------

------------------

Fresh Vegetables

BUDGET GENERATOR

<<<>>>

Machinery Complement and Cost Tables

Prepared -by E.B. Season 194-85--------

--- -----------------------------------------------

31-Jul-86

Machinery Complement Table
Prepared by: E. B. Season: 1984-85

Purchase Expected Life Horse M & R
Description $ Price Years Hours Power Factor

TRACTORS
40 hp 12,000 10.0 10,000 40 1.20
70 hp 22,000 10.0 10,000 70 1.20
85 hp 28,000 10.0 10,000 85 1.20
100 hp 38,000 10.0 10,000 100 1.20
125 hp 42,000 10.0 10,000 125 1.20
150 hp 50,000 10.0 10,000 150 1.20
160 hp 55,000 10.0 10,000 160 1.20
180 hp 65,000 10.0 10,000 180 1.20
IMPLEMENTS
6-ft weed chopper 2,300 20.0 2,000 1'.50
1-row mower 2,000 20.0 2,000 1.50
12-ft disk 10,000 10.0 2,000 0.60
13-ft heavy disk 14,000 10.0 2,000 0.60
16-ft disk 12,000 10.0 2,000 0.60
14-ft leveler 3,500 20.0 2,500 0.80
Row marker 1,000 20.0 2,000 0.10
3-row shanks 2,000 20.0 2,000 0.60
Ditch plow. 1,100 10.0 2,000 0.60
V-ditcher 4,000 6.0 2,000 0.60
V-board 1,000 20.0 2,000 0.60
14-ft reverse plow 2,400 10.0 2,000 0.60
1-row middle buster 1,200 20.0 2,000 0.60
3-row middle buster 3,000 8.0 2,000 0.60
2-row hiller 2,000 20.0 2,000 0.60
1-row bedder 1,700 10.0 2,500 1.00
3-row bedder fert. 10,900 5.0 2,500 1.00
1-row bed presser 750 5.0 2,500 1.00
3-row bedder 5,000 5.0 2,500 1.00
1-row fumigator 2,000 5.0 1,000 1.00
3-row fumigator 4,500 5.0 1,000 1.00
1-row fert. distrib. 6,700 6.0 1,200 1.20
1-row fert. distrib. 7,700 6.0 1,200 1.20
3-row fert. distrib. 10,500 6.0 1,200 1.20
4-row fert. applic. 1,900 12.0 1,200 1.20
Fertilizer tender 7,500 6.0 1,200 1.20
1-row cross ditcher 1,700 5.0 1,000 0.60
3-row cross ditcher 3,800 5.0 1,000 0.60
1-row plactic layer 3,000 8.0 1,200 1.00
3-row plastic layer 7,300 5.0 1,200 1.00
1-row hole puncher 450 8.0 1,200 0.60
Side hole puncher 1,500 8.0 1,200 0.60
1-row plant setter 1,300 6.0 1,500 0.40
3-row plant setter 2,800 6.0 1,500 0.40

Continues...

Continued...

Prepared by: E.

Page 2 of 2

Machinery Complement Table

Season: 1984-85

Purchase Expected Life Horse M & R
Description $ Price Years Hours Power Factor

2-row bean planter
3-row tomato planter
4-row planter
2-row herb. sprayer
3-row herb. sprayer
6-row herb. sprayer
Sprayer
2-row cultivator
4-row cultivator
3-row scrapper
4-row stake drivers
6-row stake drivers
3-row stake puller
2-row gas burner
3-row gas burner
I-row plastic cutter
1-row plastic lifter
Baler
Stake wagon
MISCELLANEOUS
20-hp diesel eng. pump
100-hp diesel eng. pump
Mixer
Truck mtd. 117-hp pump
1-ton truck
2-ton truck
25-ft movable shed
Pepper mule train
Eggplant mule train
30-hp electr. pump

5,000
14,000
8,000
3,000
4,000
6,000
14,000
1,500
2,600
1,500
10,700
11,200
20,000
5,300
6,000
500
4,400
12,000
1,200

5,000
25,000
3,500
24,000
12,000
17,000
10,000
100,000
200,000
8,000

5.0
5.0
5.0
5.0
5.0
5.0
5.0
10.0
10.0
10.0
8.0
10.0
5.0
6.0
6.0
7.0
10.0
20.0
20.0

10.0
10.0
6.0
10.0
8.0
8.0
12.0
20.0
20.0
10.0

1,200
1,200
1,200
1,500
1,500
1,500
1,500
2,000
2,000
2,000
2,000
2,000
2,000
1,500
1,500
2,000
2,000
2,000
3,000

12,000
12,000
1,000
12,000
4,000
4,000
12,000
12,000
12,000
12,000

Sals/hour
0.88
4.38
20.00
5.12
3.00
10.00
0.38
1.00
3.33

0.80
0.80
0.80
0.70
0.70
0.70
0.70
1.00
1.00
1.00
0.80
0.80
0.80
1.00
1.00
0.10
0.60
0.80
0.80

1.20
1.20
1.50
1.20
0.80
0.80
0.60
1.20
1.20
0.40

------------------------------------------------------------------

31-Jul-86

Machinery Cost Table
Prepared by: E. B. Season: 1984-85

Dollar Cost Per Hour
Description Fixed M & R Fuel Variable Total
-----------------------------------------------------------------
TRACTORS
40 hp 2.11 1.44 1.75 3.19 5.30
70 hp 3.87 2.64 3.07 5.71 9.58
85 hp 4.93 3.36 3.72 7.08 12.01
100 hp 6.69 4.56 4.38 8.94 15.63
125 hp 7.39 5.04 5.48 10.52 17.91
150 hp 8.80 6.00 6.57 12.57 21.37
160 hp 9.68 6.60 7.01 13.61 23.29
180 hp 11.44 7.80 7.88 15.68 27.12
IMPLEMENTS
6-ft weed chopper 3.01 1.73 1.73 4.74
1-row mower 2.62 1.50 1.50 4.12
12-ft disk 8.80 3.00 3.00 11.80
13-ft heavy disk 12.32 4.20 4.20 16.52
16-ft disk 10.56 3.60 3.60 14.16
14-ft leveler 3.67 1.12 1.12 4.79
Row marker 1.31 0.05 0.05 1.36
3-row shanks 2.62 0.60 0.60 3.22
Ditch plow 0.97 0.33 0.33 1.30
V-ditcher 2.83 1.20 1.20 4.03
V-board 1.31 0.30 0.30 1.61
14-ft reverse plow 2.11 0.72 0.72 2.83
I-row middle buster 1.57 0.36 0.36 1.93
3-row middle buster 2.38 0.90 0.90 3.28
2-row hiller 2.62 0.60 0.60 3.22
1-row bedder 1.20 0.68 0.68 1.88
3-row bedder fert. 5.80 4.36 4.36 10.16
1-row bed presser 0.40 0.30 0.30 0.70
3-row bedder 2.66 2.00 2.00 4.66
1-row fumigator 2.66 2.00 2.00 4.66
3-row fumigator 5.99 4.50 4.50 10.49
1-row fert. distrib. 7.91 6.70 6.70 14.61
1-row fert. distrib. 9.09 7.70 7.70 16.79
3-row fert. distrib. 12.39 10.50 10.50 22.89
4-row fert. applic. 3.06 1.90 1.90 4.96
Fertilizer tender 8.85 7.50 7.50 16.35
1-row cross ditcher 2.26 1.02 1.02 3.28
3-row cross ditcher 5.05 2.28 2.28 7.33
1-row plactic layer 3.97 2.50 2.50 6.47
3-row plastic layer 8.09 6.08 6.08 14.17
1-row hole puncher 0.60 0.23 0.23 0.82
Side hole puncher 1.99 0.75 0.75 2.74
1-row plant setter 1.23 0.35 0.35 1.57
3-row plant setter 2.64 0.75 0.75 3.39

Continues...

Continued...
Page 2 of 2

Machinery Cost Table
Prepared by: E. B. Season: 1984-85

Dollar Cost Per Hour
Description Fixed M & R Fuel Variable Total

2-row bean planter 5.54 3.33 3.33 8.88
3-row tomato planter 15.52 9.33 9.33 24.85
4-row planter 8.87 5.33 5.33 14.20
2-row herb. sprayer 2.66 1.40 1.40 4.06
3-row herb. sprayer 3.55 1.87 1.87 5.41
6-row herb. sprayer 5.32 2.80 2.80 8.12
Sprayer 12.41 6.53 6.53 18.95
2-row cultivator 1.32 0.75 0.75 2.07
4-row cultivator 2.29 1.30 1.30 3.59
3-row scrapper 1.32 0.75 0.75 2.07
4-row stake drivers 8.50 4.28 4.28 12.78
6-row stake drivers 9.86 4.48 4.48 14.34
3-row stake puller 13.30 8.00 8.00 21.30
2-row gas burner 5.00 3.53 3.53 8.54
3-row gas burner 5.66 4.00 4.00 9.66
1-row plastic cutter 0.38 0.03 0.03 0.40
1-row plastic lifter 3.87 1.32 1.32 5.19
Baler 15.72 4.80 4.80 20.52
Stake wagon 1.05 0.32 0.32 1.37
MISCELLANEOUS
20-hp diesel eng. pump 0.73 0.50 0.88 1.38 2.11
100-hp diesel eng. pump 3.67 2.50 4.38 6.88 10.55
Mixer 4.96 5.25 20.00 25.25 30.21
Truck mtd. 117-hp pump 3.52 2.40 5.12 7.52 11.04
1-ton truck 4.76 2.40 3.00 5.40 10.16
2-ton truck 6.75 3.40 10.-00 13.40 20.15
25-ft movable shed 1.61 0.50 0.38 0.88 2.49
Pepper mule train 21.83 10.00 0.75 10.75 32.58
Eggplant mule train 43.67 20.00 2.50 22.50 66.16
30-hp electr. pump 1.17 0.27 0.00 0.27 1.44

Prepared by: E. B. Season: 1984-85

a Parameter Entry Form

Fuel Price ($/Unit) Fixed Cost %

Diesel $1.00 Salvage value 10.00
Gas $1.00 Loan interest rate 12.00
Other $0.75 Taxes+Housing+Insur 2.00
Electricity $0.00
- - - - - - - - - - - - - - - -

This publication was produced at a cost of $790.11, or $3.16 per copy to assist in the preparation and recording of
vegetable crop budgets and in production decisions. 2-250-87

COOPERATIVE EXTENSION SERVICE, UNIVERSITY OF FLORIDA, INSTITUTE OF FOOD AND AGRICULTURAL SCIENCES, K.R. Tefertiller,
director, in cooperation with the United States Department of Agriculture, publishes this information to further the purpose of the May 8 and
June 30,1914 Acts of Congress; and is authorized to provide research, educational information and other services only to individuals and institu-
tions that function without regard to race, color, sex or national origin. Single copies of Extension publications (excluding 4-H and Youth publica- .
tons) are available free to Florida residents from County Extension Offices. Information on bulk rates or copies for out-of-state purchasers is I
available from C.M. Hinton, Publications Distribution Center, IFAS Building 664, University of Florida, Gainesville, Florida 32611. Before publicizing this publication,
editors should contact this address to determine availability.