Chapter3_problems x mi Chapter2_problems x Q learning center elize X The Learning Cente X Homework Help - C X ch1-3 basiclp & fou X Solving Linear Prog x + X G https://www.studocu.com/tw/document/71 =/management-science/ch1-3-basicip-foundationip-homework/20976322/download/ch1-3-basicip-founda... & to . . . =| | Y Draw 2 | | Read aloud + ( x] 2 of 4 | 2 1 ED 1. The Learning Center runs a day camp for 6-10 year olds during the summer. Its manager, Elizabeth Reed, is trying to reduce the center's operating costs to avoid having to raise the tuition fee. Elizabeth is currently planning what to feed the children for lunch. She would like to keep costs to a minimum, but also wants to make sure she is meeting the nutritional requirements of the children. She has + already decided to go with peanut butter and jelly sandwiches, and some combination of apples, milk, and/ or cranberry juice. The nutritional content of each food choice and its cost are given in the table that accompanies this problem. The nutritional requirements are as follows. Each child should receive between 300 and 500 calories, but no more than 30 percent of these calories should come from fat. Each child should receive at least 60 milligrams (mg) of vitamin C and at least 10 grams (g) of fiber. To ensure tasty sandwiches, Elizabeth wants each child to have a minimum of 2 slices of bread, 1 tablespoon (tbsp) of pea- nut butter, and 1 tbsp of jelly, along with at least 1 cup of liquid (milk and/or cranberry juice). Elizabeth would like to select the food choices that would minimize cost while meeting all these requirements. Food Item Calories Total Vitamin C Fiber(g) Cost from Fat Calories (mg Bread 15 80 4 6 (1 slice) Peanut 30 100 0 butter (1 tbsp) Jelly 70 4 w 8 (1 tbsp) Apple 90 6 10 35 Milk(1cup) 120 N O 20 Cranberry 110 80 40 Juice (1 cup) a. Formulate and solve a linear programming model for this problem on a spreadsheet. 72OF Clear Q Search ENG 3:03 AM IN 4/4/2023