Hello please help solve this in parts and share code

ALL AutoSave OH ON H2 nutrients O Search File Home Insert Draw Page Layout Formulas Data Review View Help X AutoSum Calibri 11 ' ' A A ab Wrap Text General 4 X 09 Fill Paste Cell BIU Conditional Format as - -- A Insert Delete Format $ % 898 Merge & Center 98 Clear Formatting Table Styles Clipboard is Font Alignment Number Styles Cells EL POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (csv) format. To preserve these features, save it in an Excel file format Don't show again Save M12 Ix 26 A A B C D F F G H 1 J K L M . N O energy protein total fat carbohydr dietary calcium magnesiu phosphor potassiu 1 ndb id description water (8) (kcal) 8 (6) (8) ash (8) ate(s) fiber (e) sugar (B) (mg) 6 iron (mg) m (mg) us (mg) m (mg) 2 1001 BUTTER, WITH SALT 15.87 717 0.85 81.11 2.11 0.06 0 0.06 24 0.02 2 24 24 3 1002 BUTTER,WHIPPED,W/ SALT W/ 16.72 718 0.49 78,3 1.62 2.87 0 0.06 23 0.05 1 24 41 4 1003 BUTTER OIL,ANHYDROUS 0.24 876 0.28 99.48 0 0 0 0 0 4 0 0 3 5 5 1004 CHEESE,BLUE 42.41 353 21.4 28.74 5.11 2.34 0 0.5 528 0.31 23 387 25 6 6 1005 CHEESE,BRICK 41.11 371 23.24 29.68 3.18 2.79 0 0.51 674 0.43 24 451 136 7 1006 CHEESE,BRIE 48.42 334 20.75 27.68 2.7 0.45 0 0.45 184 0.5 20 188 152 8 1007 CHEESE, CAMEMBERT 51.8 300 19.8 24.26 3.68 0.46 0 0.46 388 0.33 20 347 187 9 1008 CHEESE,CARAWAY 39.28 376 25.18 29.2 3.28 3.06 0 673 0.64 22 490 92 10 1009 CHEESE, CHEDDAR 37.02 404 22.87 33.31 3.71 3.09 0 0.48 710 0.14 27 455 76 11 1010 CHEESE,CHESHIRE 37.65 387 23.37 30.6 3.6 4.78 0 643 0.21 21 464 95 12 1011 CHEESE,COLBY 38.2 394 23.76 32.11 3.36 2.57 0 0.52 685 0.76 26 457 127 13 1012 CHEESE, COTTAGE,CRMD,LRG OR SIV 79.79 98 11.12 4.3 1.41 3.38 0 o 2.67 83 0.07 8 159 104 14 1013 CHEESE, COTTAGE, CRMD,W/FRUIT 79.64 97 10.69 3.85 1.2 4.61 0.2 2.38 53 0.16 7 113 90 15 1014 CHEESE,COTTAGE,NONFAT,UNCRMI 81.01 72 10.34 0.29 1.71 6.66 0 1.85 86 0.15 11 190 137 16 1015 CHEESE,COTTAGE, LOWFAT,2% MILK 81.24 81 10.45 2.27 1.27 4.76 0 4 111 0.13 9 150 125 17 1016 CHEESE, COTTAGE, LOWFAT,1% MILK 82.48 72 12.39 1.02 1.39 2.72 0 2.72 61 0.14 5 134 86 18 1017 CHEESE, CREAM 52.62 350 6.15 34.44 1.27 5.52 0 3.76 97 0.11 9 107 132 19 1018 CHEESE, EDAM 41.56 357 24.99 27.8 4.22 1.43 0 1.43 731 0.44 30 536 188 20 1019 CHEESE,FETA 55.22 264 14.21 21.28 5.2 4.09 0 4.09 493 0.65 19 337 6Z 21 1020 CHEESE, FONTINA 37.92 389 25.6 31.14 3.79 1.55 0 1.55 550 0.23 14 346 64 22 1021 CHEESE, GJETOST 13.44 466 9.65 29.51 4.75 42.65 0 0 400 0.52 70 444 1409 23 1022 CHEESE, GOUDA 41.46 356 24.94 27.44 3.94 2.22 0 2.22 700 0.24 29 546 121 24 1023 CHEESE, GRUYERE 33.19 413 29.81 32.34 4.3 0.36 0 0.36 1011 0.17 36 605 81 25 1024 CHEESE, LIMBURGER 48.42 327 20.05 27.25 3.79 0.49 0 0.49 497 0.13 21 393 128 26 1025 CHEESE,MONTEREY 41.01 373 24.48 30.28 3.55 0.68 0 0.5 746 0.72 27 444 81 27 1026 CHEESE, MOZZARELLA, WHL MILK 50.01 300 22.17 22.35 3.28 2.19 0 1.03 505 0.44 20 354 76 28 1027 CHEESE,MOZZARELLA,WHL MILK,LO 48.38 318 21.6 24.64 2.91 2.47 0 1.01 575 0.2 21 412 75 29 1028 CHEESE, MOZZARELLA, PART SKIM M 53.78 254 24.26 15.92 3.27 2.77 0 1.13 782 0.22 23 463 84 lower_bou upper_bound 1700 2100 130 550 3500 10 0.9 38 1000 400 1800 2100 18 45 420 2.3 11 16 35 5 1250 4000 1.6 16 nutrient calcium (mg) carbohydrate (g) choline (mg) copper (mg) dietary fiber (8) dietary folate (yag) energy (kcal) iron (mg) magnesium (mg) manganese (mg) niacin (mg) pantothenic acid (mg) phosphorus (mg) polyunsaturated fatty acids (g) potassium (mg) protein (g) riboflavin (mg) selenium (yag) sodium (mg) thiamin (mg) total fat (g) vitamin a (yag) vitamin b12 (yag) vitamin bb (mg) vitamin c (mg) vitamin d (iu) vitamin e (mg) vitamin k (yag) zinc (mg) 4700 56 1.3 55 400 1500 2300 1.2 35 900 3000 2.4 1.7 100 90 2000 400 4000 15 1000 120 11 40 2. The Diet Problem In this problem we introduce a variation of the classic Stigler's diet problem named after economics Noble laureate George Stigler. We want to create a complete diet where each meal complies with all the necessary Dietary Reference Intakes. The food items are in nutrients.csv (values are per 100 grams), and the daily constraints in constraints.csv. A missing upper bound in constraints means that there is no upper bound restriction for that nutrient. a) Create two meals, lunch and dinner, such that lunch would provide 1500 Kcal and dinner 1000 Kcal energy. For each meal, randomly choose from one thousand non overlapping food items to create the optimal meal. Restrict the total amount of any chosen food item to no more than 500 grams. b) Consider recreating lunch and dinner as in (a) such that no more than 9% of the total calories came from fat