only 3.26 (a) , (b) , (c)

for this problem on a spreadsheet. c. Summarize this formulation in algebraic form. .26. Joyce and Marvin run a day care for preschoolers. They are trying to decide what to feed the children fer lunches. They would like to keep their costs down, but they also need to meet the nutritional requirements of the children. They have already decided to go with peanut butter and jelly sandwiches, and some combination of graham crackers, milk, and orange juice. The nutritional content of each food choice and its cost are given in the table below. Calories Total Food Item from Fat Calories Bread (1 slice) 10 70 Peanut butter (1 tbsp.) 75 100 Strawberry jelly (1 tbsp.) O 50 Graham cracker (1 cracker) 20 60 Milk (1 cup) 70 150 Juice (1 cup) 0 100 The nutritional requirements are as follows. Each child should receive between 400 and 600 calories. No more than 30 percent of the total calories should come from fat. Each child should consume at least 60 milligrams (mg) of vitamin C and 12 grams (g) of protein. Furthermore, for practical reasons, each child needs exactly 2 slices of bread (to make the sandwich), at least twice as much peanut butter as jelly, and at least 1 cup of liquid (milk and/or juice). Joyce and Marvin would like to select the food choices for each child that minimize cost while meeting the above requirements. a. Identify the requirements that lead to resource con- straints, to benet constraints, and to xed-require- ment constraints. E* b. Formulate and solve a linear programming model for this problem on a spreadsheet. c. Express the model in algebraic form. 3.27. Read the referenced article that fully describes the man- agement science study summarized in the application vignette presented in Section 3.5. Briey describe how the model for the transportation problem was applied in this study. Then list the vari- ous nancial and nonnancial benefits that resulted from this study. month, respectively. Retail outlets l, 2, 3, E 20, 10, 10, and 20 shipments per month, re: The distribution manager, Randy Smith, mine the best plan for how many shipmen plant to the respective retail outlets each m tive is to minimize the total shipping cost. Formulate this problem as a transporl spreadsheet and then use Solver to obtain a E*3.29. The Childfair Company has thn child push chairs that are to be shipped Vitamin C Protein Cost (m9) (9) () 0 3 5 0 4 4 3 0 7 o 1 a 2 8 1 5 120 1 35 centers. Plants 1, 2, and 3 produce 12, 17, 2 month, respectively. Each distribution can 10 shipments per month. The distance frc respective distribution centers is given belo Distance to Distributic 1 2 Plant 1 800 1 .300 2 1 ,1 00 1 ,400 3 600 1 ,200 The freight cost for each shipment is $100 ] How much should be shipped from cars] distribution centers to minimize the total sh Formulate this problem as a transport spreadsheet and then use Solver to obtain a: E*3.30. The Onenote Co. produces a sin plants for four customers. The three plants and 40 units, respectively, during the next