The Corresponding Linear Programming

Added on - 16 Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
Case Study5 The Diet ProblemThe Diet ProblemProblem DescriptionThe goal of the diet problem is to find the cheapest combination of foods that will satisfy allthe daily nutritional requirements of a person. This problem has often been used inOperations Research textbooks to illustrate the use of linear programming to solve real-lifetypes of problems. The corresponding linear programming minimizes the cost of food,subject to nutritional requirements. Below, we give the linear programming formulation ofthe problem. In this formulation we include constraints that regulate the number of caloriesand the amount of vitamins, minerals, fats, sodium, and cholesterol in the diet.Optimization ModelLetFoodandNutritionbe sets of foods and nutrition we consider in this problem. Assumethat there arefdifferent types of food inFoodandndifferent types ofNutrition. Thefollowing is a linear programming formulation of the problem:where:jcis the cost of foodj;jxis the amount of foodjconsumed;ijntis the amountof nutritioniin foodj;inlbis the minimum amount of nutritionirequired per day;inubis the maximum amount of nutritioniallowed to be consumed per day;jflbis theminimum amount of foodjdesired per day;jfubis the maximum amount of foodjdesired per day.Excel Spreadsheets1.Build a spreadsheet that presents the following data about different types of food:price, weight, calories, amount of cholesterol, and vitamin content per serving.2.Build a spreadsheet that presents data about the minimum and maximum amounts ofnutritionirequired per day for a healthy diet.3.Build a spreadsheet that presents historical data about the food consumed by theuser on daily bases: total amount of calories consumed and total amount of nutritiontaken by nutrition type.User Interface1.Build a welcome form.2.Build a form that allows the user to do the following:511::1,...,1,..., .fjjjfiijjijjjjMincxSubjecttonlbntxnubinflbxfubjf
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access