Use a spreadsheet to solve a diet plan which is designed for one week (from a chosen restaurant). the person must meet the dietary requirements listed and spend as little money as possible. The goal is to find the cheapest combination of foods that will satisfy nutritional requirements of a person. It involves an objective function that minimizes cost and constraints which require the nutritional needs to be satisfied. See attachment for the menu items from the restaurant, as well as the nutritional data for each menu item and the Recommended daily Value from FDA, as well as price of each menu item. Solution should determine total quantities of each food for the entire week.
Need model written in WORD or handwritten as well as the program in excel.
The solution provides a detailed and step-by-step explanation (incl. Excel algorithm) for the problem.