Your Federal Quarterly Tax Payments are due April 15th

Mcs Market Hog Production Cost - Excel by rtv19587

VIEWS: 0 PAGES: 4

Mcs Market Hog Production Cost document sample

• pg 1
```									                     HOG MARKET CALCULATOR

ENTER TODAY'S DATE ====>      MONTH(1-12)               DAY              YEAR(i.e 84)
1                    1                   91
Enter the number of pigs you intend to sell at each weight.
Enter the expected average daily gain and feed efficiency
if different than the values predicted by the program.

201 TO 210                     0          1.79        3.95
211 TO 220                    10          1.88        4.01
221 TO 230                    20          1.94        4.10
231 TO 240                    10          1.99        4.22
241 TO 250                     0          2.01        4.36
251 TO 260                     0          1.97        4.52
261 TO 270                     0          1.90        4.71
271 TO 280                     0          1.86        4.90

FEED COST WORKSHEET

Enter the pounds of each feedstuff required per ton of finishing
raion and the current value of each feedstuff below.

FEEDSTUFF                            LBS.                 COST /UNIT

CORN                         1675                           2.25   /BUSHEL
SOYBEAN MEAL                   250                        220.00   /TON
SUPPLEMENT                       0                        340.00   /TON
PREMIX                          70                          0.22   /LBS.
MISC. INGREDIENTS                5                          1.00   /LBS.
MISC. COSTS (GRINDING, MIXING, ETC.)                       10.00   /TON
TOTAL                        2000

PRODUCTION WORKSHEET

The following inputs will be used to calculate your
weekly cost of labor and opportunity cost on hog value.

DESCRIBE YOUR FINISHING FACILITY                       ======>           2
(Dirt Lot-1, Open Front-2, Confinement-3)

ENTER YOUR WAGE RATE (\$/HOUR)                          ======>           6

CURRENT INTEREST RATE (XX%)                            ======>          10
CURRENT MARKET AND PRICE DISCOUNT SCHEDULE

Enter the current market and price discounts for three packers
CURRENT PRICE (\$/CWT):                         51.75      51.50    50.00

WEIGHT RANGE (LBS.)                                    DISCOUNTS
201 TO 210                                 -1.00      -1.00    -2.00
211 TO 220                                  0.00       0.00     0.00
221 TO 230                                  0.00       0.00     0.00
231 TO 240                                  0.00       0.00     0.00
241 TO 250                                 -0.25      -0.25     0.00
251 TO 260                                 -0.75      -0.50    -0.25
261 TO 270                                 -1.25      -1.00    -0.50
271 TO 280                                 -2.00      -1.50    -0.75
281 TO 290                                 -2.75      -2.50    -1.50
291 TO 300                                 -4.00      -3.50    -2.25
301 TO 310                                 -5.00      -4.50    -3.00

MARKET FORECAST

This section allows you to enter other forecasts of
hog market. Enter the expected price change below.

PREDICTED PRICE CHANGE ONE WEEK FROM TODAY ======>                       0.50

PREDICTED PRICE CHANGE TWO WEEKS FROM TODAY======>                       1.00
HOG MARKET CALCULATOR

Expected average daily gain for week 1                      ======>      1.94

Expected average daily gain for week 2                      ======>      1.98

Expected average feed efficiency for week 1                 ======>      4.11

Expected average feed efficiency for week 2                 ======>      4.23

Current interest rate                                       ======>       10

Wage rates (\$/Hour)                                         ======>      6.00

Feed costs (\$/Lb.)                                          ======>    0.0626

Feed costs (\$/Ton)                                          ======>    125.20

Expected price change one week from today                   ======>      0.16

Expected price change two weeks from today                  ======>      1.14

Predicted price change one week from today                  ======>      0.50

Predicted price change two weeks from today                 ======>      1.00

CURRENT OUTLOOK

Today's Date                             ======>            1/1/1991

Average hog wt.                          ======>                225

PACKER
(A)       (B)       (C)

Current price (\$/cwt.):                             51.75     51.50     50.00

Price (+ or - premiums and discounts):              51.75     51.50     50.00

Current value of market hog (\$/head):              116.44    115.88    112.50
HOG MARKET FORECAST

OUTLOOK FOR        8-Jan

Average hog weight                                 ======>     238

Weekly opportunity and lobor cost                  ======>     0.52

Estimated production cost (\$/Hd./Week)             ======>     3.57

Expected discount price (\$/cwt.):                    51.84    51.59    50.15

Estimated value of market how (\$/Head):             123.39   122.79   119.36

Expected change in income if hogs are
marketed 1 week from today (\$/Head):                  2.86     2.83     2.77

Predicted discount price (\$/cwt.):                   52.19    51.93    50.48

Predicted value of market hog (\$/Head):             124.20   123.60   120.15

Predicted change in income if hogs are
marketed 1 week from today (\$/head):                  3.68     3.64     3.56

OUTLOOK FOR       15-Jan

Average hog weight                                 ======>     252

Weekly opportunity and lobor cost                  ======>     1.04

Estimated production cost (\$/Hd./Week)             ======>     7.24

Expected discount price (\$/cwt.):                    52.12    52.06    50.84

Estimated value of market how (\$/Head):             131.35   131.19   128.13

Expected change in income if hogs are
marketed 2 weeks from today (\$/head):                 6.63     7.04     7.35

Predicted discount price (\$/cwt.):                   51.99    51.92    50.71

Predicted value of market hog (\$/Head):             131.00   130.84   127.79

Predicted change in income if hogs are
marketed 2 weeks from today (\$/head):                 6.29     6.69     7.02

```
To top