|
|
| Citation |
- Permanent Link:
- http://ufdc.ufl.edu/UF00095265/00002
Material Information
- Title:
- Sugar cane budget generator
- Series Title:
- Computer series - Florida Cooperative Extension Service ; 687
- Added title page title:
- Sugarcane budget generator
- Creator:
- Rohrmann, Francisco
Alvarez, Jose, 1940-
Florida Cooperative Extension Service
- Place of Publication:
- Gainesville, Fla.
- Publisher:
- Florida Cooperative Extension Service, Institute of Food and Agricultural Sciences, University of Florida
- Publication Date:
- 1985
- Copyright Date:
- 1985
- Language:
- English
- Edition:
- Version 1.00.
- Physical Description:
- 1 computer disk : ; 5 1/4 in. +
Subjects
- Subjects / Keywords:
- Sugarcane -- Economic aspects ( lcsh )
City of Gainesville ( flgeo )
Plant canes ( jstor )
Fixed costs ( jstor )
Shoots ( jstor )
Notes
- Summary:
- This microcomputer program generates budgets for sugar cane and performs the calculations.
- System Details:
- System requirements: IBM PC or compatible; 192K RAM; 2 disk drives; monitor; Lotus 1-2-3 version 1 or 1A; printer.
- General Note:
- Description based on: documentation dated September 1985.
- Statement of Responsibility:
- Francisco Rohrmann and Jose Alvarez.
Record Information
- Source Institution:
- University of Florida
- Holding Location:
- University of Florida
- Rights Management:
- All applicable rights reserved by the source institution and holding location.
- Resource Identifier:
- 20780039 ( OCLC )
|
| Downloads |
This item has the following downloads:
|
| Full Text |
10o
September 1985
September 1985
Disk(s) under separate cover
Circular 687
ar Ca G ra
Sugar Cane Budget Generator
COMPUTER SERIES
Francisco Rohrmann and Jose Alvarez
Central Science
Library
JAN 30 1990
Un'vefsty of Florida
'-I
mm
101 active Extension Service / Institute of Food and Agricultural Sciences / University of Florida / John T. Woest, Dean
F636c
687
guide
Trade names are used liberally in this document. Their mention is for illustrative purposes only and does not reflect any
preference, support, or relationship by or to the authors, The University of Florida, and The Cooperative Extension
Service, in any explicit or implicit manner.
SUGAR CANE BUDGET GENERATOR
Francisco Rohrmann and Jose Alvarez
(c), 1985, IAS, UF
FOOD AND RESOURCE ECONOMICS DEPARTMENT
FLORIDA COOPERATIVE EXTENSION SERVICE
INSTITUTE OF FOOD AND AGRICULTURAL SCIENCES
UNIVERSITY OF FLORIDA
UNtIWRSITY OF FLORIDA LU-
ABSTRACT
This. manual explains how to use the "Sugar Cane Budget
Generator" microcomputer program. With the input figures provided
by the user, the program estimates costs and returns associated
with a sugar cane operation. A special feature allows the user to
change input values and assess their impact by directly going to
the returns outcome section. Although developed for a large group
of Florida producers, the program can be modified and used in
other producing areas.
Keywords: Sugarcane, budget, costs, returns, microcomputer.
ACKNOWLEDGMENTS
The authors thank Rom Alderman, Robert Emerson, Karen
Mettling and Susan Phillips for their useful comments and
suggestions on the program and the documentation. Our gratitude
to the many sugar cane growers in south Florida who made valuable
contributions during the development and testing stages of this
package.
IBM PC is a trademark of International Business Machines Corp.
Lotus 1-2-3 is a trademark of Lotus Development Corporation.
TABLE OF CONTENTS
INTRODUCTION . . . . . . .
HARDWARE AND SOFTWARE REQUIREMENTS .
GETTING STARTED. . . . . . .
BUDGET DESCRIPTION . . . .
The Screen Access Menu. . . .
Methodology . . . . . .
USING THE PROGRAM. . . . . .
Land Use and Yields . . .
General Costs . . . . .
Annual Machinery Ownership Cost
Sugar Cane Operations . . .
Production Costs. . . . .
Revenues and Costs. . . . .
Returns to Factors of Production.
Saving and Printing the Worksheet
ORDERING INFORMATION . . . . .
REFERENCES . . . . . . ..
. . . .
S . S
. S S S S
* *
SUGAR CANE BUDGET GENERATOR
Francisco Rohrmann and Jose Alvarez
(C), 1985, IFAS, UF
INTRODUCTION
An enterprise budget is a systematic listing of income,
expenses, capital, labor and machinery requirements for a given
crop. Preparing enterprise budgets, especially for complex crops
such as sugar cane, is a tedious and time consuming task. This
manual presents a microcbmputer program that generates budgets
for sugar cane. Although the use of computerized budgets does
not reduce the data requirements, the calculations can be
performed in a faster and more accurate manner than when they are
developed by hand. Furthermore, they also provide fast answers to
"what if" questions.
The "Sugar Cane Budget Generator" presented in this manual
was developed for a large group of Florida producers. The numbers
in the example run pertain to a 640-acre farm and were mainly
taken from Lopez et al. (1979) for demonstration purposes. Readers
interested in recent estimates may consult Alvarez and Rohrmann
(1985). The budget can be used for smaller or larger farms by
entering the appropriate data.
*Former Graduate Research Assistant and Area Economist, Department of Food and Resource Economics, IFAS,
University of Florida; Gainesville and Belle Glade, respectively.
1
HARDWARE AND SOFTWARE REQUIREMENTS
The "Sugar Cane Budget Generator" program comes with the
User's Manual and the Distribution Disk. The program works on IBM
PC microcomputers, or compatibles, with a minimum configuration of
192K memory and two disk drives. If printed reports are desired,
a printer is also required.
The distribution disk works in conjunction with Lotus 1-2-3.
Either version of this package (1 or 1A) can be used. With
version 1A,
most numbers that
must be entered by the
user are
highlighted while the other numbers are calculated by the
program. This version supports a hard disk. In version 1, none of
the figures are highlighted. As a general rule, the numbers
within boxes in the Tables are input figures provided by the user
(unprotected cells) while the rest are calculated by the program
(protected cells). The only exception is the block of four
columns in Table 4 where fixed costs (repairs, taxes and
insurance, interest, and depreciation) are calculated. These
numbers, although highlighted, are not protected. If a number is
typed into a protected cell, a beep will alert the user of this
fact, after pressing the key, and the message "Protected
cell" will appear on the left of the last row of the screen.
Pressing the ESCAPE {Esc) key will allow the user to continue.
The user should become familiar with Lotus 1-2-3 before using
this program by working at least the first four lessons of the
1-2-3 Tutorial Disk. After learning how to move the cell pointer
and enter words and numbers into the spreadsheet, using this
program should be relatively easy since other operating
2
instructions are provided in this manual.
GETTING STARTED
Before running the program for the first time, a back-up
copy of the distribution disk should be made and stored in a safe
place. The instructions for duplicating diskettes can be found in
the IBM user's manual.
To start a session, place the Lotus 1-2-3 disk in drive A
and the distribution disk in drive B. Turn the computer on and
answer the date and time prompts. Then press for the
1-2-3 Lotus Access System and, finally, when requested, any key to
continue. If version 1A is used, the Screen Access Menu will
appear on the screen. With version 1, the keys must be
pressed to reach this Menu.
BUDGET DESCRIPTION
Ihet_Sreen Access Menu
This screen is like a table of contents which lists the
major sections of the program along with some operating
instructions (Table 1). Its main purpose is to show the budget in
short, logical sections and take the user to the desired location
in the worksheet.
The first 10 numbers of the menu contain input and output
sections of the sugar cane budget. Some sections occupy more than
one screen while one screen may contain more than one section.
Sections 1 and 2 are on the same screen. Section 3 includes the
original screen plus some information to the right and some more
3
one page down. Section 4 has additional information one page
down. Section 5 occupies one screen while 6 and 7 are on the same
screen. These seven sections require input figures. The $ may or
may not be entered but it will always show in the proper places.
However, the program will not accept commas when entering
thousands although these will also appear on the screen.
Section 8 has only one screen. Section 9 contains more
information one page down. Finally, section 10 occupies one
screen only. It is recommended to go back to the Screen Access
Menu by pressing every time one section of the budget is
finished before moving to another section. However, and
regardless of the 1-2-3 version being used, an alternative way
to move around the budget is by using the Page Up (PgUp} and
Page Down (PgDn) keys.
Section 11 prints parts of the worksheet or the entire
budget. A menu is displayed for the user to make the desired
selection.
Sections 12 and 13 give the user flexibility in the
recalculation process. These two numbers set the recalculation
command to manual or automatic, respectively. When number 12 is
selected, recalculation occurs every time the CALC (F9} key is
pressed in the READY mode. In this case, the CALC indicator
appears at the bottom of the screen whenever a cell value has
changed since the last recalculation, and reminds the user to
press the (F9) key to recalculate the worksheet. When Automatic
(#13) is selected, the worksheet is always up-to-date. Which one
to use depends on the user's preferences and the type of work to
4
be done during a session. Remember that, when Automatic is
selected, one must wait until the entire worksheet is
recalculated every time a number is changed. Manual, on the other
hand, is best when the user wishes to change several values
before looking at the final results.
Section 14 takes the user to the Help Screen (Table 2). This
screen contains a brief explanation of the special commands
specific to this program.
Before continuing with the program, the user should be aware
of the methodology used for calculating some of the cost and
return figures and the built-in constants in the program.
Emphasis is placed on the computations that do not appear
obvious:
(a) Standard tons per acre are calculated with the formula
(Net Tons)*(((%Sucrose 11.57)/10) + 0.9079), developed from the
relationships appearing in Alvarez and Rohrmann (1984).
(b) Machinery fixed costs are computed following standard
farm management procedures: repairs are estimated at 3% of new
cost; taxes and insurance are assumed to be 1% of new cost;
interest is the average value of new cost plus salvage value,
divided by two, and multiplied by the interest rate; salvage
value is estimated at 10% of new cost; finally, straight line
depreciation is used as the difference between new cost and
salvage value divided by the "useful life of the machinery or
equipment.
(c) Molasses payments are calculated by multiplying total
5
net tons by 6.2 (the average molasses yield assumed per net
ton), and by the price in cents per gallon, divided by 100.
USING THE PROGRAM
After following the instructions in "Getting Started," the
user is asked, at the bottom of the Screen Access Menu, to enter
the number of a section. For example, typing the number 1 and
pressing the key will take the user to the Land Use and
Yields section.
LandyUeand Yiel ds
This section is shown in the upper part of Table 3. As stated
above, the numbers within boxes are input figures provided by the
user while the rest are calculated by the program.
The first set of numbers to enter relate to the acreage
distribution of the farm. Type the first number and move the
cell pointer down to the next one until finishing this column.
The percentage figures to the right of this column are calculated
by the program with respect to the total acreage. Then the gross
tonnages are entered followed by the corresponding trash
contents. The program calculates net tons per acre. After
entering the percent sucrose in normal juice figures, standard
tons per acre are computed.
GnerCalCosts
This section appears at the bottom of the previous screen.
All figures need to be entered and most of them are
self-explanatory. Remember to include fringe benefits in the wage
rates for labor and equipment operators. Land taxes must include
annual land and drainage taxes per acre. The land charge is an
6
estimate based on one of the following methods: (a) an interest
opportunity cost based on the current value of the land; (b) the
owner's rental income from a typical crop share lease; or (c) a
typical cash rent charge. The work and machinery hours per day
represent the number of hours in operation during a typical day.
Annual MachineCvOwnQerhi_ Cost
Entering the number <3> from the Screen Access Menu
takes the user to this section (Table 4). The first column to be
filled with figures is the number of units of each piece of
machinery or equipment owned by the producer. The next columns
contain the new cost or purchase price, the expected life and
the fuel consumption per hour. The rest of the figures are
calculated by the program. The space provided at the bottom of
the list allows entering other pieces of machinery or equipment.
Remember that this section occupies some space to the right
and one page down from the original screen. The user may want to
change any of the fixed cost figures (calculated with the
formulas described in the Methodology section) but the formula
will be erased from the worksheet.
Suaar CaneeQerafi onS
Sugar cane operations are divided into four sections: plant
cane, stubble cane, harvesting and overhead activities. These
sections correspond to numbers 4 through 7 on the Screen Access
Menu.
Plant cane operations occupy two screens subdivided into
land preparation, planting and cultivation (Table 5). The user is
required to enter the following information: (a) the number of
7
times a particular operation is performed; (b) the labor and
machinery used; (c) their efficiency in terms of acres per day;
(d) the crew size, if any, excluding the operator; (e) the cost
of fertilizer and chemical applications per acre if they were, or
will be, custom hired; and (f) other inputs, such as fertilizers
and chemicals, in terms of dollars per acre.
When the first part of this section appears on the screen,
the cell pointer will be located below the first specific activity
(heavy disking) and to the right of Times Over. The example run
in Table 5 shows the number 4, meaning that heavy disking will be
done four times during land preparation to the 144 acres
designated as plant cane in the Land Use and Yields section.
After entering the corresponding figure, the cell pointer should
be moved down in the same column to enter machinery and labor
efficiencies. In this example, 45 acres per day can be done with
tractor 3 and the operator. Only machinery that cosumes fuel is
considered. The row plow, for example, is taking into account at
the time of calculating equipment ownership costs.
The rest of this section is completed in the same manner. In
cases where a specific activity is done on only half of the
acreage (like chiseling and mole draining), enter 0.5 in the
Times Over row below that activity.
Below the two sections describing cultural practices
performed by machinery, the user should enter the custom hired
activities and the cost of inputs. For example, ditch cleaning
shows the number 1 in the Times Over row and a cost of $6.07 per
acre in the Custom Hired row. In such cases, all the
8
corresponding efficiency cells should be equal to zero,
reflecting the fact that no owned resource is being employed. The
cost of inputs must be entered in terms of dollars per acre.
Examples include $80 for seed, $13.20 for insecticide, etc.
Once the two screens of the Plant Cane Operations section
have been completed, must be pressed to return to the
Screen Access Menu. Typing <5> will take the user to the
next section of the budget.
The Stubble Cane Operations section is shown in Table 6. This
section occupies one screen and the basic operation is
cultivation. To fill this section, follow the same procedure
described in the Plant Cane Operations section.
The Harvesting section, corresponding to number 7 in the
Screen Access Menu is shown in Table 7, along with the Overhead
Activities section. Both occupy the same screen.
The user is not required to enter any data in the Harvesting
section, except for the mill quota, if any, in order to estimate
the expected deficit or surplus for the production year being
considered. The cell pointer will stop at this cell and will not
move until a figure, which can be zero, is entered. The tonnage
to be harvested and the corresponding costs are calculated by the
program.
The Overhead Activities section includes expenses that can
not be charged to a particular stage of production because they
are required for the entire operation. Absolute figures for the
whole operation should be entered. The program calculates the
total cost of these activities.
9
No more data are required beyond this point. The following
sections describe the output generated by the program with the
data entered by the user in the previous sections.
Productionotss
Pressing <8> on the Screen Access Menu will show this
section (Table 8), which is a summary of the production costs by
activity expressed as total dollars and dollars per acre. The
results shown are related to the production practices, inputs
used, input prices, efficiency measures, etc.
ReYn3ues and Cgst2
This section is reached by selecting number 9 on the Screen
Access Menu. It is composed of four parts on two screens.
The first screen contains a summary of total revenues and
total variable costs, expressed in dollars per acre, dollars per
standard ton and total dollars. Each item also shows a
corresponding percentage figure, which allows comparisons of the
relative contribution of revenues and costs at each stage of the
production process. For example, the contribution of plant cane
to total revenue is 44%, which means that any variation in plant
cane yield might have a strong impact on revenues. By the same
token, harvesting costs represent 42.7% of total costs. Reducing
these costs, if possible, would represent an increase in net
revenues.
The second screen (one page down from the previous one)
presents the summary of total fixed costs and a projection of
revenues and costs. The percentage figures in this section are
different than those shown in the previous one. This difference
10
is due to the fact that in the upper section the percentage
figures represent the proportion of either revenues or costs
(e.g., plant cane's contribution to total revenue is 44% and
total variable costs represent 65.8% of total costs, which are
considered as 100% in this case). In the lower section, all
percentage figures are calculated with respect to total revenue,
which is considered as 100%. Thus, the 67.7% in the variable
costs row means that, for each dollar of revenue generated, 67
cents go to the costs that vary with production.
ReturnDs o_EacSorsag_ Production
Table 10 shows the total returns to factors of production per
gross acre. This is the bottom line of the budget and is shown by
entering <10> on the Screen Access Menu.
This section is designed to test the economic profitability
of the sugar cane farm as an economic unit. A special feature of
this program allows the user to check the impact of changes made
in factor or output prices, cultural practices, etc., by pressing
after making any change. This command will take the user
directly to this last section. Be aware of the CALC mode on which
the program is being operated since results need to be
recalculated after new values are entered.
saEn and Priniting the Workssheet
To save the worksheet, the user has to operate from a section
other than the Screen Access Menu. Press the usual 1-2-3 command
(/ Fill, Save) and the name AUT0123 of the distribution disk will
shw mon the screen. The user can replace the old file with the
same name or can cancel the command. If the user has any
11
questions, the Lotus 1-2-3 user's manual should be consulted.
There are two alternative ways to print the worksheet. Any
screen of information displayed on the screen can be copied to a
printer by pressing the SHIFT }) and {PrtSc) keys on the IBM
keyboard.
The print menu offers an alternative way for printing some
sections or the entire worksheet. By selecting <11> from
the Screen Access Menu (or from any other section of the
worksheet) the user reaches the print menu. The choices include
printing the returns to factors of production, the costs and
revenues summary, the production costs or the entire worksheet.
The user only needs to move the cell pointer through the print
menu and press when the desired option is reached. Do not
forget to turn the printer on.
ORDERING INFORMATION
For more information on this and other IFAS microcomputer
programs contact your county extension office or write to:
IFAS Software Communication and Distribution
6022 McCarty Hall
University of Florida
Gainesville, FL 32611
REFERENCES
Alvarez, Jose and Francisco Rohrmann. "Costs and Returns for
Sugarcane Production on Muck Soils in Florida, 1983-84," Economic
Information Report 204, Food and Resource Economics Department,
University of Florida, Gainesville, Florida, January 1985.
Alvarez, Jose and Francisco Rohrmann. "Relationships Among
Various Measures of Sugar Quality," Belle Glade EREC Research
Report EV-1984-10, Everglades Research and Education Center,
University of Florida, Belle Glade, Florida, September 1984.
Lopez, Rigoberto A., Jose Alvarez and Gerald Kidder.
"Enterprise Budget for Sugarcane Production in South Florida,
1978-79," Economic Information Report 119, Food and Resource
Economics Department, University of Florida, Gainesville,
Florida, September 1979.
I
Table 1.-Screen access menu.
* SUGAR CANE BUDGET GENERATOR *
* Version 1.00 $
* *
* Developed by: $
t Food and Resource Economics Department *
K (C) IFAS, University of Florida, 1985 *
Funding provided in part by a grant from
International Business Machines Corporation
SCREEN ACCESS MENU
1 Land Use and Yields 8 Production Costs Summary
2 General Costs 9 Revenues and Costs Summary
3 Machinery Ownership Cost 10 Returns to Factors of Production
4 Plant Cane Operations 11 Print Menu
5 Stubble Cane Operations 12 Set CALC to Manual
6 Harvesting 13 Set CALC to Automatic
7 Overhead Activities 14 HELP SCREEN
Press number corresponding to the section you wish:==> 11 <==
Table 2.- Help screen.
Help Menu
==> Prints different sections of the worksheet.
==> Allows the user to see the impact of changes by directly
going to the returns outcome section.
==> Help Menu.
==> Takes the user to the Screen Access Menu to select any
of the sections listed and then go directly to it.
==> Views the IFAS Disclaimer message and condition of release
or sale statement.
Table 3.- Land use and yields and general costs sections.
GENERAL INFORMATION
and Yields Section
# acres
144
144
144
144
0
0
64
640
2. General Costs Section
Labor ($/Hr)
Equip. Operator ($/Hr)
Fuel Cost ($/Gal)
Int. Rate -Oper. Loans
Int. Rate -Mach. Loans
Harvest Cost/Gross ton
(%)
22.5
22.5
22.5
22.5
0.0
0.0
10.0
100.0
$3.60
$3.60
$1.25
12.5
10.0
$8.50
Gross
Tons/A
50.0
38.0
30.0
0.0
0.0
0.0
% Net %
Trash Tons/A Sucrose
3.0
3.0
3.0
3.0
0.0
0.0
0.0
48.50
36.86
29.10
0.00
0.00
0.00
14.50
13.50
13.00
0.00
0.00
0.00
Price ($/Std ton)
Molasses Price (cts/gal)
Land Taxes ($/A)
Admin. Ovhd. ($/Yr)
Land Charge ($/A/Yr)
Work Hours/Day
Mach. Hours/Day
1. Land Use
Fallow
Plant Cane
1st Ratoon
2nd Ratoon
3rd Ratoon
4th Ratoon
Other
Total
------------------------------
Stand.
Tons/A
0.00
58.24
40.58
30.58
0.00
0.00
$17.22
7.39
$16.75
30000
$90.00
10
9
Table 4.- Annual machinery ownership costs.
3. Annual Machinery Ownership Costs Section
Ites t units New Cost Life Fuel/Hr Repairs Tax+Ins Interest Depreciation
p
Tractor(1),150-200HP
Tractor(2),1-15-1OHP
Tractor(3),110-11SHP
Tractor(4),60HP
Disk,offset
Disk,harroM
Chisel plow
Land Leveler
Hole Drain
FurroN Plow
Covering Rig
Scratcher
Rolling Cultivator
Rotary sower
Disks
Pick-up truck
Puep & Pipes
Harvester
Subsoiler
0 s0 10
0 $0 10
1 $20,250 10
2 $11,250 10
1 $5,400 10
I $4,680 10
I $1,440 10
1 $4,410 10
1 $1,395 10
1 $1,350 10
1 $2,250 10
1 $1,800 10
I $1,350 10
1 $1,530 10
1 $2,232 10
1 $7,020 10
1 $15,300 10
$0 10
s0 10
$0 0
$0 0
$0 0
s0 0
$0 0
$0
$0
$608
$675
$162
$140
$43
$132
$42
$41
$68
$54
$41
$46
$67
$211
$459
SO
$0
O0
$0
$0
$0
s0
(0
s0 $0 s0
0 50 SO
$203 $1,114 $1,823
$225 $1,238 $2,025
$54 $297 $486
$47 $257 $421
$14 $79 $130
$44 $243 $397
$14 $77 $126
$14 $74 $122
$23 $124 $203
$18 $99 $162
$14 $74 $122
$15 $84 $138
$22 $123 $201
$70 $386 $632
$153 $842 $1,377
s0 s0 0O
0 0 $0
$0 0 SO
SO $0 $0
0 0 SO
$0 $0 s0
$0 $0 $0
Machinery Ownership Cost Totals:
Interest
Depreciation
Taxes & Ins.
Repairs
Total $
$5,110
$8,362
$930
$2,788
17,190
Table 5,- Plant cane operations.
4. Plant Cane Operations Section
Times Over
Operator
Tractor 1
Tractor 2
Tractor 3
Tractor 4
Labor
Crew Size(#)
Custom Hired
Fertilizer
Land Preparation
Heavy Light Chisel- Ditch Mole Fertil-
Disking Disking ing Clean. Leveling Draining ization
4 10 .5 i 2 U.. *
1 7 .5 I M.d
. ... a ............. Mc / .. . ..... .. .... ...........
45 75 40 0 45 36 75
0 0 0 0 0 0 0
0 0 0 0 0 0 0
45 75 40 0 45 36 75
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
... ... ......... ($/Acre) ......................... ......
0.00 0.00 0.00 6.07 0.00 0.00 1.75
0.00 0.00 0.00 0.00 0.00 0.00 27.50
Plant Cane (cont'd)
Times Over
Operator
Tractor 1
Tractor 2
Tractor 3
Tractor 4
Labor
Crew Size (#
Custom Hired
Seed
Insecticide
Seed Transp.
Herbicide
Herb.Applic.
Planting
Plant Cane Cultivation
+++++++++++++++++++++++++++++++++========================
Cutting Loading, Seed Scratch- Mechan. Herbicide
Furrowing Cane Hauling Cover. ing Cult. Applic.
I 1 1 1 1 14 8 1
50 0 0 25 60 50 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
50 0 0 25 0 0 0
0 0 0 0 60 50 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
O.. .O 1 ..2.0T O.re> ..O0 O ..O. 0 ..... ............
0.00 19.20 0.00 0.00 0 0.0 0
0.00 80.00 0.00 0.00 0.00 0.00 0
0.00 0.00 0.00 13.20 0.00 0.00 0
0.00 0.00 87.50 0.00 0.00 0.00 0
0.00 0.00 0.00 0.00 0.00 0.00 0
0.00 0.00 0.00 0.00 0.00 0.00 1.65
i i-J
* *
^
Table 6.- Stubble cane operations.
5. Stubble Cd
Times Over
Operator
Tractor 1
Tractor 2
Tractor 3
Tractor 4
Labor
Crew Size
Custom Hired
Fertilizer
Herbicide
Insecticide
Other
ane Section Cultivation
Spreading Disk Rolling Fertil.Herbicide
fodder Cult. Cult. Applic. Applic. Chiseling
S0.5 2 6 1 1 0.5
'a ^fd / I a a .
.. .. ........... . 1-W= ay ......................
36 36 36 0 0 40
0 0 0 0 0
0 0 0 0 0 0
0o O 0 0 0 40
36 36 36 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
.......... ..... ( /Acre) .................. ......
0.00 0.00 0.00 1.75 1.65 0.00
0.00 0.00 0.00 23.75 0.00 0.00
0.00 0.00 0.00 0.00 5.66 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
Table 7.- Harvesting and overhead activities.
6. Harvesting Section
Gross tons Net tons
Plant Cane
1st Ratoon
2nd Ratoon
3rd Ratoon
4th Ratoon
Other
Total
7,200
5,472
4,320
0
0
16,992
6,984
5,308
4,190
0
0
0
Std tons
8,387
5,843
4,404
0
0
0
16,482 18,634
160482 18v634
Harvest
Cost
$61,200
$46,512
$36,720
$0
$0
$0
144,432
Net
tons
Mill ---------
Quota 15,000
Expected
deficit
or >>
surplus
1,482
7. Overhead Activities Section
Edging $67
Rodent Control $1,728
Borer Control $2,557
Water Control $1,250
Total $5,602
.
...I
Table 8.- Production costs summary.
Production Costs
8. LAND PREPARATION
Heavy Disking
Light Disking
Chiseling
Ditch Cleaning
Leveling
Mole draining
Fertilization
($)
1,181
1,771
166
874
590
185
4,389
Subtotal 9,156
PLANTING
Furrowing 266
Cutting cane 14,285
Seed Cost & Transport. 12,600
Seed Cover. & Insect. 2,432
Subtotal 29,583
PLANT CANE CULTIVATING
Scratching 2,344
Mechanical Cult. 1,607
Herbicide appl. 238
Subtotal 4,188
(S/A)
8.20
12.30
1.15
6.07
4.10
1.28
30.48
63.58
1.85
99.20
87.50
16.89
205.44
16.28
11.16
1.65
29.09
STUBBLE CULTIVATING
Spread. fodder
Disk Cult.
Rolling Cult.
Fertilization
Herbicide appl.
Chiseling
Subtotal
HARVESTING
Plant Cane
1st Ratoon
2nd Ratoon
3rd Ratoon
4th Ratoon
Subtotal
OVERHEAD
Edging
Pest Ctrl.
Water Ctrl.
Subtotal
279
1,116
3,348
7,344
2,105
332
14,524
61,200
46,512
36,720
0
0
144,432
67
4,285
1,250
5,602
($/A)
0.97
3.88
11.63
25.50
7.31
1.15
50.43
425.00
323.00
255.00
0.00
0.00
334.33
0.10
6.70
1.95
8.75
Table 9.- Break-down and summary of projected revenues and costs.
Revenues and Costs
Total Revenues
Plant Cane
1st Ratoon
2nd Ratoon
3rd Ratoon
4th Ratoon
Molasses Payment
TOTAL
Total Variable Costs
Land Preparation
Planting
Plant Cane Cultiv.
Ratoon Cultiv.
Overhead Activities
Miscellaneous
SUBTOTAL
Interest
Harvesting
TOTAL
Total Fixed
$/Acre
1,003
699
527
0
0
12
513
14.3
46.2
6.5
22.7
8.8
9.9
108.4
13.5
225.7
347.6
Costs $/Acre
Machinery & Equip. 26.9
Land Charge 90.0
Taxes:Land&Drainage 16.8
Administrative Ovhd 46.9
TOTAL 180.5
$/Std ton
17.63
0.49
1.59
0.22
0.78
0.30
0.34
3.72
0.47
7.75
11.94
$/Std
0.92
3.09
0.58
1.61
6.20
ton
SUMMARY OF PROJECTED REVENUES AND COSTS
-------------------------------e-----*--
REVENUES
VARIABLE COSTS
GROSS MARGIN
FIXED COSTS
NET MARGIN
$/Acre
513.2
347.6
165.6
180.5
-14.9
$/Std ton
17.63
11.94
5.69
6.20
-0.51
Total $
328,432
222,461
105,972
115,510
.(9,538)
Total $
144,426
100,623
75,832
0
0
7552
328432
9,156
29,583
4,188
14,524
5,602
6,305
69,359
8,670
144,432
222,461
Total $
17,190
57,600
10,720
30,000
115,510
44.0
30.6
23.1
0.0
0.0
2.3
100.0
2.7
8.8
1.2
4.3
1.7
1.9
20.5
2.6
42.7
65.8
5.1
17.0
3.2
8.9
34.2
100.0
67.7
32.3
35.2
" -2.9
Table 10.- Total returns to factors of production per gross acre.
10. RETURNS PER GROSS ACRE TO FACTORS OF PRODUCTION SECTION
-------------------------------------------------------------------------
Item Charge Return
-------------------------------------- --------------------- -------------
Total Revenues $513
Variable Costs $348
Return to fixed costs, land, mgt. and risk $166
Fixed Costs (machinery, equip. and taxes) $44
Return to land, management and risk $122
Land Charge $90
Return to management and risk $32
MARSTON SCIENCE LIBRARY
Date Due
Due Returned Due Returned
AY& I a illl -AY 2 2m? &
I D O C U T f a
3 1262 04376842 2
/II
/0/
3 CZ
SCIENCE
LIBRARY
This publication was produced at a cost of $267.53, or $1.41 per copy, to provide information on a Sugar Cane Budget
Generator Microcomputer Program. 10-190-85 I
COOPERATIVE EXTENSION SERVICE, UNIVERSITY OF FLORIDA, INSTITUTE OF FOOD AND AGRICULTURAL
SCIENCES, K. R. Tefertlller, director, In cooperation with the United States Department of Agriculture, publlshesthls Infor-
mation to further the purpose of the May 8 and June 30, 1914 Acts of Congress; and Is authorized to provide research, educa-
tlonal informatlof, and other services only to Individuals and Institutions that function without regard to race, color, sex or
national origin. Single copies of Extension publications (excluding 4-H and Youth publications) are available free to Florida
residents from Couaty Extension Offices. Information on bulk rates or copies for out-of-state purchasers Is available from
C. M. Hiton, Publications Distribution Center, IFAS Building 664, University of Florida, Gainesvllle, Florida 32611. Before publicizing this
publlcaton, editor, should contact this address to determine availability.
|
|
