Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Mcs Market Hog Production Cost - Excel by rtv19587

VIEWS: 0 PAGES: 4

Mcs Market Hog Production Cost document sample

More Info
									                     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.

                 WEIGHT CLASS             NUMBER          ADG          FE
                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
     BUYER:                                            (A)       (B)      (C)
     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