WUFFDA Basics. WUFFDA requires the MicroSoft Excel spreadsheet program with the Solver Option installed. Basic knowledge of spreadsheet usage is all that is required to use the program. WUFFDA can solve a problem with 25 ingredients and 34 nutrients. First Step in the Formulation Process.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Click on the “38” to highlight the Canola line, then press the right mouse button to pull down the edit menu, and click “Copy”.
Click on the “15” to highlight the Alfalfa line, then press the right mouse button to pull down the edit menu, and click “Paste”.
Alfalfa Data Replaced by Canola Data press the right mouse button to pull down the edit menu, and click “Paste”.
Highlight the data to be copied by holding down the left mouse button while dragging the mouse across the block.
Press the right mouse button and click on “Copy”. mouse button while dragging the mouse across the block.
Place the cursor on cell C4 at the upper left corner of the Current Specification Box and choose “Paste” from the pull-down edit menu.
And the Broiler Grower Feed becomes the “Current Specification”.
By Copying and Pasting, the Original Data Remains Unchanged. A New Nutrient Specification Can Always Be Copied and Stored for Future Use.
A new column to set the Calcium to Phosphorous Ratio equal to 2.0000 is created by inserting an equation in the new column:
When the equation is copied to all the cells in the column, values for ingredients with higher Ca:P ratios are more positive :
The Value for the Ca:P ratio should be fixed at zero, so the positive and negative coefficients balance each other out.
The Available Phosphorous in the solution is exactly half the Calcium level when the Ca:P=2 coefficients total to zero.
If only the minimum requirement for Calcium is changed, the amounts of Calcium and Available Phosphorous in the solution changes.
Or You Can Get Excel to Formulate the Least-Cost Feed By Choosing “Solver…” From the Tools Menu.
Constraints have all been set in the Solver Dialogue Box, so just click on the “Solve” Button.
Hopefully Solver will find a solution and you can just click on the “OK” Button to see what it is.
The Amount of Each Ingredient in the Formula and the Nutrients the Diet Supplies Will Be Displayed.
“Print Preview” of a Feed Specification. Nutrients the Diet Supplies Will Be Displayed.
Scroll to See Both Graphs Nutrients the Diet Supplies Will Be Displayed.
Choose “Sensitivity” from the list of possible Reports in the Solver Results Dialogue Box.
This feed should contain 52.09 % Corn unless the price increases by $0.989, or decreases by $0.129. Corn’s current value is $5.25 per 100 pounds.
This formulation would begin to use barley if it’s price decreases by $2.0989.
The cost of the feed is expected to change by $0.4201 if the level of protein specified were to change by 1 unit up or down.