In: Advanced Math
Mary has a limited food budget, but still wants to make sure her family members meet their daily nutritional requirements. Mary can buy two foods. Food 1 sells for $7 per pound, and each pound contains 3 units of vitamin A and 1 unit of vitamin C. Food 2 sells for $1 per pound, and each pound contains 1 unit of each vitamin. Each day, the family needs at least 12 units of vitamin A and 6 units of vitamin C. To minimize the total cost while satisfying the vitamin requirements, build a spreadsheet model to find out how much of each food Mary should buy. Answer the following questions (no need to present the model). (1) What is the optimal solution? (2) What is the minimum cost? (3) How is each vitamin requirement satisfied (exactly satisfied, or oversatisfied)?