+ Reply to Thread
Results 1 to 4 of 4

Scenario's For Cattle Gain Cost Calculation = If()

  1. 01-01-2018, 04:24 PM #1
    Prof Sick is offline
    Forum Contributor
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    104

    Scenario's For Cattle Gain Cost Calculation = If()

    We're trying to figure out future cost of gain in cattle utilizing a table and current wt. With in the table there are two different cost stages per lot. The cost are differentiated by current size. Can do this on paper all day long but want to implement the math into a spreadsheet to streamline a bit. I have scenario detail within the attached spreadsheet.

    Thanks in advance.. Happy New Year..!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-01-2018, 05:09 PM #2
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Scenario's For Cattle Gain Cost Calculation = If()

    A
    B
    C
    D
    E
    F
    1
    Lot
    Wgt1
    Wgt2
    CoG1
    CoG2
    2
    		 W3BRD394
    850
    1450
    $ 0.75
    $ 1.05
    3
    		 WMQTR417
    700
    750
    $ 0.65
    $ 0.65
    4
    		 WMQTR317
    700
    900
    $ 0.75
    $ 0.80
    5
    6
    7
    Lot
    Row
    Curr Wgt
    TFC
    8
    		 W3BRD394
    2
    0
    $ 1,267.50
    9
    		 W3BRD394
    2
    850
    $ 630.00
    10
    		 W3BRD394
    2
    1000
    $ 472.50
    11
    		 W3BRD394
    2
    1425
    $ 26.25
    12
    		 W3BRD394
    2
    1450
    $ 0.00
    13
    		 WMQTR417
    3
    0
    $ 487.50
    14
    		 WMQTR417
    3
    700
    $ 32.50
    Attached Files Attached Files
    Last edited by shg; 01-01-2018 at 05:14 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 01-01-2018, 05:23 PM #3
    Prof Sick is offline
    Forum Contributor
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    104

    Re: Scenario's For Cattle Gain Cost Calculation = If()

    Thanks for your time and help on this shg. Works perfectly.!
    Reply With QuoteRegister To Reply
  4. 01-01-2018, 05:54 PM #4
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Scenario's For Cattle Gain Cost Calculation = If()

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need Help With Cost Calculation
    By mohdm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2015, 11:29 AM
  2. i need cost calculation on spreadsheet example for product cost from manufacturing unit
    By ajoy713341 in forum Excel General
    Replies: 1
    Last Post: 04-24-2015, 09:46 AM
  3. Cost Optimisation Calculation
    By yokong in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2012, 08:12 AM
  4. Backward calculation of tax: what if scenario
    By aj001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2010, 06:03 AM
  5. Calculation Gain Percentage
    By anilativy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-08-2010, 09:36 AM
  6. Cost Driver calculation - Looking for formula/macro to calculate manpower cost alloca
    By Swastik Banerje in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2009, 11:18 AM
  7. Spreadsheet to do annual investment gain$, % gain, for list
    By notaspreadsheetgenius in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-09-2005, 04:08 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1