380 likes | 630 Views
A BRIEF INTRODUCTION TO THE WUFFDA PROGRAM. LECTURE AND TURORIAL FOR CHAPTER 23. FEED FORMULATION : SPECIFYING PROPORTIONS. POULTRY NUTRITION FUNDAMENTALS. Chapter 23. Section I. INTRODUCTION. FORMULATION PROGRAM ADVANCED CAPABILITIES.
E N D
A BRIEF INTRODUCTION TO THEWUFFDAPROGRAM LECTURE AND TURORIAL FOR CHAPTER 23 FEED FORMULATION : SPECIFYING PROPORTIONS POULTRY NUTRITION FUNDAMENTALS
Chapter 23 Section I. INTRODUCTION
FORMULATION PROGRAM ADVANCED CAPABILITIES • RATIOS BETWEEN NUTRIENTS & RATIOS BETWEEN INGREDIENTS • HOW TO SPECIFY AMINO ACIDS AS A PERCENTAGE OF PROTEIN, THE ENERGY TO PROTEIN RATIO, OR THE CALCIUM TO PHOSPHORUS RATIO? • HOW TO SPECIFY INGREDIENT RATIOS, LIKE OYSTER SHELL TO LIMESTONE, OR CONCENTRATE TO FORAGE?
Chapter 23 Section I I. PROPORTIONS BETWEEN NUTRIENT MINIMUMS
OPEN THE WUFFDA ENGLISH.XLS WORKBOOK OR THE LAST WORKBOOK FROM CHAPTER 22
ADD FISH MEAL, FEATHER MEAL, OYSTER SHELL, METHIONINE, THREONINE AND TRYPTOPHAN TO THE LAST PROBLEM IN CHAPTER 22.
REMEMBER TO ENTER MAXIMUMS SO THE PROGRAM DOESN’T ASSUME ZERO’S
ENERGY, PROTEIN, CA, P, LYS AND TSAA ARE ALL AT THEIR REQUIREMENT LEVELS
NUTRIENT LEVELS APPEAR THE SAME, INGREDIENT LEVELS ARE CHANGED SLIGHTLY
CHANGE THE PROTEIN MINIMUM TO 20% WITHOUT CHANGING AMINO ACID REQUIREMENTS
AMINO ACID REQUIREMENTS AND AMOUNTS SUPPLIED SHOULD CHANGE AUTOMATICALLY WITH PROTEIN LEVEL
Chapter 23 Section III. EXACT PROPORTIONS BETWEEN NUTRIENTS
TYPE IN: “Ca:P” IN CELL P2, “2” IN CELL P3 (FOR A 2:1 RATIO), “=I5-($P$3*J5)” IN CELL P5. COPY CELL P5 DOWN COLUMN P
INGREDIENTS WITH MORE CA THAN P SHOULD HAVE A POSITIVE NUMBER, LESS A NEGATIVE NUMBER IN COLUMN P
SET THE MINIMUM AND MAXIMUM FOR Ca:P BOTH TO 0 (ZERO), AND REMOVE THE MINIMUM ON AVAIL. PHOS.
AVAIL. PHOS. SHOULD STILL BE AT 0.45 % DESPITE THERE BEING NO REQUIREMENT SPECIFIED EXCEPT ON THE INGREDIENTS WORKSHEET
CHANGE THE CALCIUM MINIMUM, SOLVE THE PROBLEM AND OBSERVE WHAT HAPPENS TO THE AVAIL. PHOS. LEVEL IN THE SOLUTION
Chapter 23 Section IV. SPECIFYING INGREDIENT CLASS MINIMUMS
ADD A COLUMN FOR “ANIMAL PRODUCTS” GIVE EACH ONE A VALUE OF 100 (EXCEPT POULTRY GREASE AND OYSTER SHELL)
SOLVE THE PROBLEM WITH 3, 5 AND 7 % ANIMAL PRODUCTS AND NOTE THE INFLUENCE ON FORMULA COST
Chapter 23 Section IV. SPECIFYING INGREDIENT CLASS MINIMUMS
THE SOLUTION HAS ALL LIMESTONE & NO OYSTER SHELL BASED ON COST
ADD COLUMNS FOR PULVERIZED AND COURSE Ca SOURCES ADD “=R5-($T$3*S5)” IN CELL T5. COPY CELL T5 DOWN COLUMN T
FEED FORMULATION : PROPORTIONS PROGRAMMING • ANSWER THE QUESTIONS ON PAGE 23-7 • TURN IN YOUR • PRINTOUTS • ANSWERS ON PAGE 23-7