A BRIEF INTRODUCTION TO THE WUFFDA PROGRAM

1
A BRIEF INTRODUCTION TO THE WUFFDA PROGRAM

• LECTURE AND TURORIAL
• FOR CHAPTER 25

FEED FORMULATION MULTIBLENDING
POULTRY NUTRITION FUNDAMENTALS
2
Section I.
Chapter 25

• INTRODUCTION

3
FORMULATION PROBLEM HOW TO USE A LIMITED AMOUNT
OF ONE INGREDIENT?

• FORMULATE ALL POSSIBLE DIETS WITH THE INGREDIENT
  AND COMPARE COSTS?
• MULTI-BLEND, ONE PROBLEM WITH ALL THE FEEDS,
  SOLVING FOR THE LEAST-COST SOLUTION?

4
Section I I.
Chapter 25

• CHOOSE THE FEEDS AND COSTS TO WORK WITH

5
CHOOSE TWO DIETS, PREFERABLY ONES NOT SIMILAR IN
PROTEIN AND ENEGRY
X
X
6
CHOOSE A COST SERIES TO USE
X
7
ENTER THE INGREDIENT COMPOSITION FOR YOUR FEEDS
8
ENTER THE NUTRIENT MINIMUMS AND MAXIMUMS FOR THE
FEED
9
SOLVE THE PROBLEM
10
CHOOSE THE SENSITIVITY REPORT BEFORE CHOOSING OK
11
CALCULATE THE SHADOW PRICE OF POULTRY MEAL AS IN
CHAPTER 24
F10-H10
12
PRINT THE FEED SPEC SPREADSHEET WRITE DOWN
THE SHADOW PRICE OF POULTRY MEAL
13
ENTER THE RESULTS IN THE C25 GRAPHING.XLS
SPREADSHEET
14
CONTINUE THE PARAMETRIC ANALYSIS AS IN CHAPTER
24, ENTERING DATA IN THE GRAPHING SPREADSHEET AS
YOU GO
15
REPEAT THE ANALYSIS FOR THE OTHER FEED, WHEN
FINISHED, YOUR CHART SHOULD BE SIMILAR TO THIS.
PRINT IT.
16
Section III.
Chapter 25

• MULTI-BLENDING ONE INGRERDIENT INTO TWO FEEDS

17
FOR THE MULTI-BLENDING PROBLEM, START WITH THE
INGREDIENT MATRIX FROM ONE OF YOUR FEEDS ADD
ROWS AND COLUMNS FOR THE OTHER FEED
BROILER FEED
LAYER FEED
18
USE TABLE 25-5 AS A GUIDE
BROILER FEED
LAYER FEED
19
GIVE DIFFERENT SUBSCRIPTS FOR EACH DIET. IN THIS
EXAMPLE (B) WAS USED FOR THE BROILER DIET AND (L)
FOR THE LAYER DIET
20
IN THE WEIGHT COLUMN (FOR THE ENTIRE MIXTURE)
ENTER 0.5 FOR EACH NUTRIENT
21
THE VALUE FOR WEIGHT (A) SHOULD BE 1IN FEED (A)
INGREDIENTS AND WEIGHT (B) SHOULD BE 1IN FEED
(B) INGREDIENTS
22
ADD A COLUMN NAMED POULTRY MEAL ACTIVITY WITH
VALUES OF 1 FOR THE POULTRY MEALS, BUT 0 FOR
THE OTHER INGREDIENTS
23
ADD THE NUTRIENT RESTRICIONS FOR EACH FEED.
ENTERING THESE LIMITS FOR POULTRY MEAL ACTIVITY
FIXES IT AT A TOTAL OF 5 IN THE FEEDS
24
SOLVE THE PROBLEM PRINT YOUR RESULTS
25
ALL THE POULTRY MEAL SHOULD APPEAR IN THE FEEDS,
AND ADD UP TO 5
26
ADD CALCULATIONS TO TOTAL THE COST OF EACH FEED
IN ADDITION TO THE TOTAL FORMULA COST.
SUMPRODUCT(C8C14,E8E14)/100
SUMPRODUCT(C15C21,E15E21)/100
27
NEXT, FORCE 5 POULTRY MEAL INTO THE FEED IT WAS
NOT USED IN BEFORE, AND RESOLVE THE PROBLEM.
28

• SOLVE THE PROBLEM
• PRINT YOUR RESULTS
• WRITE A SHORT EXPLAINATION OF YOUR RESULTS
• ANSWER THE QUESTIONS IN THE LABORATORY EXERCISES
  SECTION

29
FEED FORMULATION PARAMETRIC PROGRAMMING

• WRITE A SHORT EXPLAINATION OF YOUR RESULTS AND
  TURN IT IN WITH YOUR PRINT OUTS.
• ANSWER THE QUESTIONS IN THE LABORATORY EXERCISES
  SECTION.