spreadsheet modeling and decision analysis related question

FIBA OM32II] - DECISION MooELs 1- (7 Marks) Fodders Inc located in Lahore has been experimenting with various diets that can be used at dairy farms. Currently company is experimenting on a diet called Fx3. The feed components available for the diet are Tech 1 feed product, a vitamin enriched oat product and a new vitamin and mineral feed additive. These components consist of three ingredients. Following table shows the amount of each ingredient to be used in 1 kilogram of feed and the minimum requirements regarding these ingredients. FaedGomponent nkllogram) Minimum Daily mom 1 d We Oat IngredientA 0.3 0.2 has.\" Ingredients Perm m as? Along with the daily requirements it is also required that B Each packing of "F13 feed\" should be 5 kilograms. B At least 20% of diet should constitute of Additive component. B Enriched Oat cannot be more than 40% ofthe diet. Formulate the LP model for this problem in order to decide how much of each of the three components should be added so as to minimize the cost while satisfying the diet requirements