• TABLE OF CONTENTS
HIDE
 Front Cover
 Introduction
 Main
 Back Cover






Group Title: Computer series
Title: Abbreviated profit and loss statement for Florida milking operations
CITATION THUMBNAILS PAGE IMAGE ZOOMABLE
Full Citation
STANDARD VIEW MARC VIEW
Permanent Link: http://ufdc.ufl.edu/UF00095224/00002
 Material Information
Title: Abbreviated profit and loss statement for Florida milking operations a microcomputer program
Series Title: CComputer series - Florida Cooperative Extension Service ; 610
Physical Description: 1 computer disk + : ;
Language: English
Creator: Webb, Dan W ( Daniel Warren ), 1944-
Phillips, Susan, 1958-
Publisher: Florida Cooperative Extension Service, Institute of Food and Agricultural Sciences, University of Florida
Place of Publication: Gainesville, Fla.
Publication Date: 1984
Copyright Date: 1984
 Subjects
Subject: Dairy farming -- Finance -- Computer programs   ( lcsh )
Milking -- Finance -- Computer programs   ( lcsh )
Genre: government publication (state, provincial, terriorial, dependent)   ( marcgt )
non-fiction   ( marcgt )
 Notes
General Note: Cover title.
General Note: "December 1984."
Statement of Responsibility: Dan W. Webb and Susan Phillips.
 Record Information
Bibliographic ID: UF00095224
Volume ID: VID00002
Source Institution: University of Florida
Holding Location: University of Florida
Rights Management: All rights reserved by the source institution and holding location.
Resource Identifier: oclc - 15204993

Table of Contents
    Front Cover
        Page i
        Page ii
    Introduction
        Page 1
    Main
        Page 2
        Page 3
        Page 4
        Page 5
        Page 6
        Page 7
        Page 8
        Page 9
        Page 10
        Page 11
        Page 12
    Back Cover
        Page 13
        Page 14
Full Text
10(
6 0 Floppy disc included with this
cembr1984 item has been shelved separately. Circular 610
ecembr Consult LUIS or ask circulation
staff for assistance.


Abbreviated Profit and Loss Statement
For Florida Milking Operations:

A Microcomputer Program


COMPUTER SERIES


Dan W. Webb and Susan Phillips

























7F operative Extension Service / Institute of Food and Agricultural Sciences / University of Florida / John T. Woeste, Dean
101
F636c
610
guide




































ABBREVIATED INCOME STATEMENT

START-UP INSTRUCTIONS FOR IBM-PC & COMPATIBLES


1. Boot System
2. Insert Disk
3. Type ==> INCOME












ABBREVIATED PROFIT & LOSS STATEMENT FOR FLORIDA MILKING OPERATIONS:
A MICROCOMPUTER PROGRAM

by
Dan W. Webb and Susan Phillips*




INTRODUCTION

Sound financial management is important to the success of a dairy
business. Financial management involves the control and utilization of
limited financial resources to achieve desired goals. Practicing good
financial management includes keeping accurate and up-to-date financial
records, including balance sheets, profit and loss statements and cashflows.
Knowledge of operating costs, financial position and efficiency ratios are
necessary when establishing goals, preparing budgets and making good business
decisions.

A microcomputer program is presented here that generates, in abbreviated
form, a profit and loss statement for the milking operation of a Florida
dairy. Because of its condensed form, this statement is not suitable for
reporting income for tax purposes or for obtaining a loan. However, this
program can be used for identifying trouble areas and for planning changes in
the milking operation.

Operating the program is not difficult and results are available
quickly. Screen instructions provide initial help and inputs are organized in
table format for readability and ease of use.

Throughout this paper, angle brackets, < >, identify responses that you
enter from the keyboard. For most entries you type each number or letter
enclosed in the brackets. In the case of you press the key marked
ENTER rather then typing the letters E-N-T-E-R.

While this program has been designed to be accurate and reliable, the
authors accept no responsibility for any action which you may take based on
the results of any given run of the program. You are completely responsible
for any decision made using the information generated by this computer
program.



NOTE: For start-up information and minimum system requirements, refer to
Appendix A, page 12.


*Professor Extension Dairyman, former Computer Programmer; respectively, Dairy Science Department, IFAS, University of Florida,
Gainesville 32611


UtliVdR11 Uf W.us.uA LuiiARIES





INPUT DESCRIPTION


You may elect to change 31 input items. These items are listed and
briefly described below. Note that all values are for the milking operation
only. If you raise your own replacements, where applicable, remove any costs
associated with the replacement-raising operation.

1) NO. OF COWS: The total number of cows on your dairy for the time
period you are analyzing (includes dry cows).

2) LBS OF MILK/COW: The average total pounds of milk per cow per year
(total milk for dairy / total number of dairy cows = milk per cow).

3) CULL RATE: The percent of cows sold annually, entered as a whole
number rather than as a decimal. For example, if you cull 28% of
your cows, enter <28>, NOT <.28>. The cull rate excludes death
loss.

4) DEATH LOSS: The percent of cows that die each year, entered as a
whole number rather than as a decimal. For example, if 5% of your
cows die, enter <5>, NOT <.05>.

5) MILK PRICE($/CWT): The price you receive per hundred pounds of milk
after government assessment, promotion funds and other deductions,
but before hauling charges.

6) CULL VALUE($/HD): This is the amount you receive for your cull
cows.

7) CALF VALUE($/HD): The price you receive for newborn calves. If you
raise your own replacements you should still enter a value here
since this profit and loss statement is only for the milking
operation (that is, keep the milking operation and the
replacement-raising operation separate).

8) CONC FED(TONS/COW): The amount of concentrate or mixed ration you
feed each cow per year. Include feed fed to dry cows, but do not
include concentrate fed in the replacement-raising operation.

9) CONC PRICE($/TON): The average price paid for concentrate or mixed
ration per ton.

10) HAY FED(TONS/COW): The amount of hay you feed each cow per year.
Do not include hay fed in the replacement-raising operation.

11) HAY PRICE($/TON): The price you pay for hay per ton.

12) SIL FED(TONS/COW): The amount of silage you feed each cow per year.
Do not include silage fed in the replacement-raising operation.

13) SIL PRICE($/TON): The price you pay for silage per ton.





14) LABOR($/YR): The amount you pay for labor in the milking
operation per year (number of workers x hourly rate x hours
worked per wee x weeks worked per year). Exclude employment taxes
as they are calculated elsewhere.

15) UTILITIES($/YR); The amount you pay for utilities for the milking
operation per year.

16) VET&DRUGS($/COW): The amount you spend per cow per year for
veterinary services and drugs.

17) SUPPLIES($/YR): The amount you spend each year for supplies.

18) OTHER($/YR): T e amount you spend each year for miscellaneous items
that are not cl ssified elsewhere.

19) REPL COST($/HD)i The price you pay for replacements. If you raise
your own replacements, enter your rearing costs, plus initial value
(Item #7).

20) FUEL($/YR): The amount you spend each year for fuel.

21) REPAIRS($/YR): The amount spent each year on repairs for equipment
used to milk, m nage and feed the dairy herd.

22) BREEDING($/COW/ R): The amount spent for each cow on breeding
expenses per year.

23) MILKHAUL($/CWT): The price you pay for hauling per hundred pounds
of milk shipped.

24) AUTO&TRUCK($/YR): The amount you spend each year on autos and
trucks used on the highway and associated with the milking, managing
and feeding the dairy herd.

25) INSUR&TAX($/YR): The amount you spend each year on insurance and
taxes.

26) DEP-EQUIP($/YR): The amount of depreciation you will claim on
equipment used to milk, manage and feed the dairy herd.

27) DEP-BLDGS($/YR): The amount of depreciation you will claim on
buildings used to milk, manage and feed the dairy herd.

28) SHORT-TERM DEBT: The amount of money you owe which is due in less
than 2 years.

29) INT%-S: The interest rate that you are paying on the short-term
debt.

30) LONG-TERM DEBT: The amount of money you owe which is due in 2 years
or longer.

31) INT%-L: The interest rate that you are paying on the long-term
debt.






OPERATING INSTRUCTIONS


Running the Abbreviated Profit & Loss Statement program is simple. When
the program is selected, a screen is displayed identifying the program title,
version number, the authors and their address (see Figure 1). To see brief
program description and instructions, press and . Figure 2 shows
the user instructions. If you want to go directly to the program, press
and . If you choose to read the instructions, press to
continue to the next screen when you are ready.


FIGURE 1. PROGRAM TITLE PAGE


FIGURE 2. USER INSTRUCTIONS


ABBREVIATED PROFIT & LOSS STATEMENT
FOR FLORIDA MILKING OPERATIONS
TRS80 MODEL III VERSION 1.0
WRITTEN BY
DAN W WEBB & SUSAN PHILLIPS
DAIRY SOFTWARE CENTER
DAIRY SCIENCE DEPARTMENT IFAS
COPYRIGHT 1984 UNIVERSITY OF FLORIDA
DIRECT INQUIRIES TO: FARM COMPUTER SUPPORT GROUP
FLORIDA COOPERATIVE EXTENSION SERVICE

DO YOU WANT TO SEE INSTRUCTIONS (Y/N) "=>?


USER INSTRUCTIONS
1- You can choose to display default values or your own values.
Initially your values are set to the default until you
change them and save the new values to disk.
2- Input items are shown in table format. To change a value
enter the item number. The old value is shown and you enter
a new value. The input table is redisplayed with the change.
3- After making all changes enter a zero to calculate and
display the results.
4- At the end of the program you have the option of printing or
reviewing the results, rerunning the program, saving your
input values to disk or quitting.

PRESS TO CONTINUE ->?





At this point the computer will ask you which values you want to use,
the default values or your own (see Figure 3). Make your choice by entering
<1> or <2> and pressing . If you choose <1>, the default values, the
input variables will be displayed immediately, in table format, on the screen.
If you choose <2>, your own values, the disk activity light will come on as
the data is read from the disk file. When the information is read the input
table will be displayed. Option two values, your own, will be set to the
default values until you make changes to the input table and save these
changes to disk. (NOTE: The option to save changes to disk is provided as a
menu selection and will be explained in more detail later.) Figure 4 shows
the table using the default values.



DO YOU WANT TO START WITH:

<1> DEFAULT VALUES
<2> YOUR OWN VALUES
ENTER SELECTION # =->?




FIGURE 3. CHOOSING START-UP INPUT VALUES







1) NO. OF COWS 500.00 17) SUPPLIES($/YR) 10000.0"
2) LBS OF MILK/COW 14000.00 18) OTHER($/YR) 30000.00
3) CULL RATE(28%-28) 28.00 19) REPL COST($/HD) 1100.00
4) DEATH LOSS(5%-5) 5.00 20) FUEL($/YR) 6000.00
5) MILK PRICE($/CWT) 15.50 21) REPAIRS($/YR) 12500.00
6) CULL VALUE($/HD) 450.00 22) BREEDNG($/COW/YR) 15.00
7) CALF VALUE($/HD) 80.00 23) MILKHAUL($/CWT) 0.48
8) CONC FED(TONS/COW) 5.50 24) AUTO&TRUCK($/YR) 10000.00
9) CONC PRICE($/TON) 160.00 25) INSUR&TAX($/YR) 12000.00
10) HAY FED(TONS/COW) 1.00 26) DEP-EQUIP($/YR) 20000.00
11) HAY PRICE($/TON) 70.00 27) DEP-BLDGS($/YR) 12500.00
12) SIL FED(TONS/COW) 3.00 28) SHORT TERM DEBT 100000.00
13) SIL PRICE($/TONS) 35.00 29) INT%-S(13%-13) 13.00
14) LABOR($/YR) 114400.00 30) LONG TERM DEBT 550000.00
15) UTILITIES($/YR) 37500.00 31) INT%-L(10%=10) 10.00
16) VET&DRUGS($/COW) 20.00 # TO CHANGE OR 0 TO RUN?






FIGURE 4. INPUT TABLE WITH DEFAULT SETTINGS




To change any item simply type the item's number and press .
Look at Figure 5 for an example of how to change the default pounds of milk
per cow from 14,000 to 13,000. Figure 5 indicates that when you request a
value change, the item is clearly identified, the old value is displayed and
you are prompted for a new value. If you selected this item accidentally or
if you have changed your mind, just enter the old value for the new value,
press and continue.


-5-













FIGURE 5. ENTERING A NEW VALUE FOR LBS OF MILK/COW


After each change you will notice that the input table is redisplayed
and reflects all your changes to date. When you are satisfied with all the
values, enter <0> (zero, not the letter 'oh') to run. Figures 6 10 show the
results as they are displayed on the screen, one screen at a time. To
continue to the next screen, press when prompted. Note that the
results are separated into two categories, income and expenses. Also note that
expenses are subdivided into variable costs and fixed costs.






ABBREVIATED PROFIT & LOSS STATEMENT
500 COWS @ 14000 LBS OF MILK
INCOME TOTAL S/COW $/CWT % OF INCOME
MILK 1085000 2170.00 15.50 92
CULL COWS 63000 126.00 0.90 5
CALVES 36000 72.00 0.51 3
TOTAL 1184000 2368.00 16.91 100
PRESS TO CONTINUE -=>?





FIGURE 6. SCREEN 1 OF RESULTS






ABBREVIATED PROFIT & LOSS STATEMENT
500 COWS @ 14000 LBS OF MILK
VARIABLE COSTS TOTAL S/COW $/CWT % OF INCOME
CONCENTRATE 440000 880.00 6.29 37
HAY 35000 70.00 0.50 3
SILAGE 52500 105.00 0.75 4
LABOR 114400 228.80 1.63 10
EMPLY TAX @ .12 13728 27.46 0.20 1
UTILITIES 37500 75.00 0.54 3
VET $ DRUGS 10000 20.00 0.14 1
SUPPLIES 10000 20.00 0.14 1
OTHER 30000 60.00 0.43 3
PRESS TO CONTINUE ->?


FIGURE 7. SCREEN 2 OF RESULTS














ABBREVIATED PROFIT & LOSS STATEMENT
500 COWS @ 14000 LBS OF MILK


VARIABLE COSTS

FUEL
BREEDING
MILK HAULING
AUTO/TRUCK
INTERESTS TERM
COW REPLACEMENT
SUBTOTAL


TOTAL

6000
7500
33600
10000
13000
181500
994728


$/cow

12.00
15.00
67.20
20.00
26.00
363.00
1989.46


$/CWT % OF INCOME

0.09 1
0.11 1
0.48 3
0.14 1
0.19 1
2.59 15
14.21 84


PRESS TO CONTINUE ==>?


FIGURE 8. SCREEN 3 OF RESULTS


ABBREVIATED PROFIT & LOSS STATEMENT
500 COWS @ 14000 LBS OF MILK

FIXED COSTS TOTAL $/COW $/CWT % OF INCOME

DEPRC-EQUIP 20000 40.00 0.29 2
DEPRC-BLDGS 12500 25.00 0.18 1
INTEREST/L TERM 55000 110.00 0.79 5
REPAIRS 12500 25.00 0.18 1
INSURANCE&TAXES 12000 24.00 0.17 1
SUBTOTAL 112000 224.00 1.60 9


TOTAL COSTS
RETURN


PRESS TO CONTINUE ==>?


1106730 2213.46 15.81
77272 154.54 1.10


FIGURE 9. SCREEN 4 OF RESULTS


FIGURE 10. SCREEN 5 OF RESULTS


ABBREVIATED PROFIT & LOSS STATEMENT
500 COWS @ 14000 LBS OF MILK
.......... ..... ..... ..... .. ........ .........................
TOTAL $/COW $/CWT % OF INCOME
----------------------------------
REVENUE 1184000 2368.00 16.91 100

EXPENSE 1106730 2213.46 15.81 93

RETURN TO RISK,
MGT & EQUITY 77272 154.54 1.10 7

PRESS TO CONTINUE ==>?


1


J


__ __








After displaying the results you will have the option of printing the
results, reviewing the results (all screens), rerunning the program (return to
the input table with the values that you last entered), saving your input
values to disk, or quitting (see Figure 11). Simply select the number of the
option you desire and press . If you choose option four you will be
asked to verify the selection (see Figure 12). If you answer the old data
will be erased and the new data stored on disk. This information is written
to a disk file named INCDATA. INCDATA must always be on the disk with the
program file (INCOME) and must always be in drive 0. If a write protect tab
is on the disk remove it before selecting option four.


FIGURE 11. ENDING OPTIONS


FIGURE 12. VERIFY SELECTION


Figures 13 and 14 show the actual printed output that you would receive,
for this example, if you requested the print option mentioned above. The
first page of output gives the program title, version number and other
information and a list of the input values used to calculate the results. The
second page of output prints the abbreviated income statement listing each
item by total value, dollar per cow, dollar per hundred weight milk, and
percent of income. After the results are printed you will return to the
option menu and may select another option.


OPTIONS
<1> PRINT RESULTS
<2> REVIEW RESULTS
<3> RERUN PROGRAM
<4> SAVE YOUR INPUT VALUES
<5> QUIT
ENTER SELECTION # =->?


























ABBREVIATED PROFIT & LOSS STATEMENT FOR FLORIDA MILKING OPERATIONS
TRS80 MODEL III VERSION 1.0

WRITTEN BY
DAN W WEBB & SUSAN PHILLIPS

DAIRY SOFTWARE CENTER
DAIRY SCIENCE DEPARTMENT IFAS
COPYRIGHT 1984 UNIVERSITY OF FLORIDA

DIRECT INQUIRIES TO: FARM COMPUTER SUPPORT GROUP
FLORIDA COOPERATIVE EXTENSION SERVICE







==> INPUT VALUES <==


NO. OF COWS 500.00
LBS OF MILK/COW 14000.00
CULL RATE(28%=28) 28.00
DEATH LOSS(5%=5) 5.00
MILK PRICE($/CWT) 15.50
CULL VALUE($/HD) 450.00
CALF VALUE($/HD) 80.00
CONC FED(TONS/COW) 5.50
CONC PRICE($/TON) 160.00
HAY FED(TONS/COW) 1.00
HAY PRICE($/TON) 70.00
SIL FED(TONS/COW) 3.00
SSIL PRICE($/TONS) 35.00
) LABOR($/YR) 114400.00
) UTILITIES($/YR) 37500.00
VET&DRUGS($/COW) 20.00


FIGURE 13.


SUPPLIES($/YR) 10000.00
OTHER($/YR) 30000.00
REPL COST($/HD) 1100.00
FUEL($/YR) 6000.00
REPAIRS($/YR) 12500.00
BREEDNG($/COW/YR) 15.00
MILKHAUL($/CWT) 0.48
AUTO&TRUCK($/YR) 10000.00
INSUR&TAX($/YR) 12000.00
DEP-EQUIP($/YR) 20000.00
DEP-BLDGS($/YR) 12500.00
SHORT TERM DEBT 100000.00
INT%-S(13%=13) 13.00
LONG TERM DEBT 550000.00
INT%-L(10%=10) 10.00


PAGE 1 OF ACTUAL PRINTOUT


-9-
















ABBREVIATED PROFIT & LOSS STATEMENT FOR FLORIDA MILKING OPERATIONS
500 COWS @ 14000 LBS OF MILK



ITEM TOTAL $/COW $/CWT % OF INCOME



INCOME:
MILK 1085000 2170.00 15.50 92
CULL COWS 63000 126.00 0.90 5
CALVES 36000 72.00 0.51 3
TOTAL 1184000 2368.00 16.91 100

VARIABLE COSTS:
CONCENTRATE 440000 880.00 6.29 37
HAY 35000 70.00 0.50 3
SILAGE 52500 105.00 0.75 4
LABOR 114400 228.80 1.63 10
EMPLY TAX @ .12 13728 27.46 0.20 1
UTILITIES 37500 75.00 0.54 3
VET $ DRUGS 10000 20.00 0.14 1
SUPPLIES 10000 20.00 0.14 1
OTHER 30000 60.00 0.43 3
FUEL 6000 12.00 0.09 1
BREEDING 7500 15.00 0.11 1
MILK HAULING 33600 67.20 0.48 3
AUTO/TRUCK 10000 20.00 0.14 1
INTEREST/S TERM 13000 26.00 0.19 1
COW REPLACEMENT 181500 363.00 2.59 15
SUBTOTAL 994728 1989.46 14.21 84

FIXED COSTS:
DEPRC-EQUIP 20000 40.00 0.29 2
DEPRC-BLDGS 12500 25.00 0.18 1
INTEREST/L TERM 55000 110.00 0.79 5
REPAIRS 12500 25.00 0.18 1
INSURANCE&TAXES 12000 24.00 0.17 1
SUBTOTAL 112000 224.00 1.60 9

TOTAL COSTS 1106730 2213.46 15.81 93

RETURN TO RISK,
MGT & EQUITY 77272 154.54 1.10 7


PRINTED ON . 03/08/84











FIGURE 14. PAGE 2 OF ACTUAL PRINTOUT


-10-





THEORY OF CALCULATION


The formulas used to arrive at the results are located in lines 1000
through 1280 of the program code. Note that there are two fixed values used
in the calculations. These are calf crop (CC) set at .90 (90%) and the
employment tax rate (ET) set at .12 (12%). The calf crop is the percent of
live calves per cow.

The complete program listing can be obtained by listing the program from
BASIC on your computer.



SUMMARY

In conclusion, the Abbreviated Profit & Loss Statement for Florida
Milking Operations, microcomputer program can be run quickly and easily. The
results organize major income and expense items in an easy-to-read table that
will aid the dairymen in identifying problem areas related to income and
expenses for the milking operation.



IFAS SOFTWARE ORDERING PROCEDURE

The Abbreviated Profit & Loss Statement for Florida Dairies,
microcomputer program is currently available on floppy disks for several types
of microcomputers. To obtain an order form for this and other IFAS programs,
or for more information, write to:



Farm Computer Support Group
c/o Dean John T. Woeste
Florida Cooperative Extension Service
1038 McCarty Hall
University of Florida
Gainesville, FL 32611





Special thanks to John Holt, Extension Economist, Food and Resource Economics
Department, for his input concerning accuracy and terminology.


-11-





APPENDIX A. START-UP AND MINIMUM SYSTEM REQUIREMENTS INFORMATION


MINIMUM SYSTEM REQUIREMENTS: 48K Memory, 1 Disk Drive
OPTIONAL: Printer



RADIO SHACK START-UP INFORMATION (1 OR 2 DRIVES)

Cold Start
1. Turn the computer on.
2. Put the program disk in Drive 0.
3. Press the reset button.
4. Enter the date. Enter the time (optional).

Warm Start
1. For Models other than III, reboot the system.
2. From TRSDOS READY, prompt type .
(The program disk must be in Drive 0.)
3. From BASIC, type .
(The program disk must be in Drive 0.)
4. Press ENTER



APPLE II+ START-UP INFORMATION (1 OR 2 DRIVES)

Cold Start
1. Put the program disk in Drive 1.
2. Turn the computer on.

Warm Start
1. Type .
(The program disk must be in Drive 1.)
2. Press RETURN

NOTE: APPLE uses a key marked "RETURN" instead of ENTER.


-12-






3lll ll2 l 04376ll 1
3 12b2 04376885 1


Date Due r_
. i R_


Due

-MAY 22LI


I 4------


Due


Returned


Notes


Return ed
Wf-w










































































This public document was promulgated at a cost of $680.50 or 91 cents per copy, as documentation for the accompany-
ing microcomputer program. 12-750-84



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




University of Florida Home Page
© 2004 - 2010 University of Florida George A. Smathers Libraries.
All rights reserved.

Acceptable Use, Copyright, and Disclaimer Statement
Last updated October 10, 2010 - - mvs