A BRIEF INTRODUCTION TO THE WUFFDA PROGRAM LECTURE

A BRIEF INTRODUCTION TO THE WUFFDA PROGRAM LECTURE AND TURORIAL FOR CHAPTER 25 FEED FORMULATION : MULTIBLENDING POULTRY NUTRITION FUNDAMENTALS

Chapter 25 Section I. INTRODUCTION

FORMULATION PROBLEM: HOW TO USE A LIMITED AMOUNT OF ONE INGREDIENT? 1. FORMULATE ALL POSSIBLE DIETS WITH THE INGREDIENT AND COMPARE COSTS? 2. MULTI-BLEND, ONE PROBLEM WITH ALL THE FEEDS, SOLVING FOR THE LEAST-COST SOLUTION?

Chapter 25 Section I I. CHOOSE THE FEEDS AND COSTS TO WORK WITH

CHOOSE TWO DIETS, PREFERABLY ONES NOT SIMILAR IN PROTEIN AND ENEGRY X X

CHOOSE A COST SERIES TO USE X

ENTER THE INGREDIENT COMPOSITION FOR YOUR FEEDS

ENTER THE NUTRIENT MINIMUMS AND MAXIMUMS FOR THE FEED

SOLVE THE PROBLEM

CHOOSE THE SENSITIVITY REPORT BEFORE CHOOSING “OK”

CALCULATE THE SHADOW PRICE OF POULTRY MEAL AS IN CHAPTER 24 =F 10 -H 10

PRINT THE “FEED SPEC” SPREADSHEET & WRITE DOWN THE SHADOW PRICE OF POULTRY MEAL

ENTER THE RESULTS IN THE C 25 GRAPHING. XLS SPREADSHEET

CONTINUE THE PARAMETRIC ANALYSIS AS IN CHAPTER 24, ENTERING DATA IN THE GRAPHING SPREADSHEET AS YOU GO

REPEAT THE ANALYSIS FOR THE OTHER FEED, WHEN FINISHED, YOUR CHART SHOULD BE SIMILAR TO THIS. PRINT IT.

Chapter 25 Section III. MULTI-BLENDING: ONE INGRERDIENT INTO TWO FEEDS

FOR THE MULTI-BLENDING PROBLEM, START WITH THE INGREDIENT MATRIX FROM ONE OF YOUR FEEDS & ADD ROWS AND COLUMNS FOR THE OTHER FEED

USE TABLE 25 -5 AS A GUIDE

GIVE DIFFERENT SUBSCRIPTS FOR EACH DIET. IN THIS EXAMPLE (B) WAS USED FOR THE BROILER DIET AND (L) FOR THE LAYER DIET

IN THE ‘WEIGHT COLUMN’ (FOR THE ENTIRE MIXTURE) ENTER ‘ 0. 5’ FOR EACH NUTRIENT

THE VALUE FOR WEIGHT (A) SHOULD BE ‘ 1’IN FEED (A) INGREDIENTS AND WEIGHT (B) SHOULD BE ‘ 1’IN FEED (B) INGREDIENTS

ADD A COLUMN NAMED ‘POULTRY MEAL ACTIVITY’ WITH VALUES OF ‘ 1’ FOR THE POULTRY MEALS, BUT ‘ 0’ FOR THE OTHER INGREDIENTS

ADD THE NUTRIENT RESTRICIONS FOR EACH FEED. ENTERING THESE LIMITS FOR POULTRY MEAL ACTIVITY FIXES IT AT A TOTAL OF 5% IN THE FEEDS

SOLVE THE PROBLEM & PRINT YOUR RESULTS

ALL THE POULTRY MEAL SHOULD APPEAR IN THE FEEDS, AND ADD UP TO 5%

ADD CALCULATIONS TO TOTAL THE COST OF EACH FEED IN ADDITION TO THE TOTAL FORMULA COST. =SUMPRODUCT(C 8: C 14, E 8: E 14)/100 =SUMPRODUCT(C 15: C 21, E 15: E 21)/100

NEXT, FORCE 5% POULTRY MEAL INTO THE FEED IT WAS NOT USED IN BEFORE, AND RESOLVE THE PROBLEM.

1. SOLVE THE PROBLEM 2. PRINT YOUR RESULTS 3. WRITE A SHORT EXPLAINATION OF YOUR RESULTS 4. ANSWER THE QUESTIONS IN THE LABORATORY EXERCISES SECTION

FEED FORMULATION : PARAMETRIC PROGRAMMING 1. WRITE A SHORT EXPLAINATION OF YOUR RESULTS AND TURN IT IN WITH YOUR PRINT OUTS. 2. ANSWER THE QUESTIONS IN THE LABORATORY EXERCISES SECTION.