please solve as written exam. do not use excel or something else.

1. My diet requires that all the food 1 eat come from one of the four basic focd groupe (chocolite eake, ice crerm, soda, and chesocnke). At present, the following four foods are available for consymption: brownivs, chocolate ice cream, cola, and pineapple cheesecaloe. Finch brownie costs 50 cents, each sooop of chocolate ice cream epsts 20 cents, each bottle of cola costs 30 cents, and each piece of pineapple cheesecake conts 80 cent s. Each day, I must ingest at least 500 calories, 6 oz of choeolate, 10 ou of sugar, und 8 oz of fat. The matritional content per unit of each food is showy in Table 1 . Formulate n linear lirogramming model that can be usod to satisfy my daily nutritional sequirements at ninimnm cost. Consider the diet problem given above. Use the Excel Solver output to answyr the following questions. Table 1: Nutritional valuey for diet a) If a Brownie costs 30 thes what would be the new optimal solution to the problem? b) If a bottle of cola cost 35 , then what would be the new optimal solution to the problem? c) If at least 8 oz of chocolate were required, then what would be the cost of the optimal diet? d) If at lenst 600 calories were required, then what would he the cost of the optimal diet? e) If at least 9 oz of sugar were required, then what would be the cost of the optimal diet? f) What would the price of pineapple cheesecake have to he bofore it would be optimal to eal cheesecake? g) What would the price of a brownie have to be before it would be optimal to eat a brownic