pls do explain on this mattar gerading part 1 Q2 on the menu Break down and description.

Case Problem Set C LP Case Problem Nutri Fit is a health and fitness center headquartered in Kuala Lumpur. The center not only provides facilities such as gymnasium, swimming pool, and sauna, but also provide custom-made dietary programs for individuals or special-need groups. Clients enrolling into this dietary program will consult Nutri Fit' dietician with their nutritional need and health requirement, and based on that, the company will develop a list of suggested menu be taken by the client. Nutri Fit is approached by Silver Lining Care, an organization that provides elderly care services for senior citizen, Silver Lining want Nutri Fit to develop a breakfast menu for its client currently living in their premises. The breakfast menu must be high in calories, calcium, protein and fiber. which are important to senior citizen. In addition, it must be low in fat and cholesterol. Appendix 1 are nutritional information table and costs for one portion of food items used in breakfast. Based on discussion with Silver Lining, below are the nutritional requirement that Nutri Fit must follow in preparing the breakfast menu. 1. At least 420 calories 2. No more than 20 g of fat 3. Maximum of 30 mg of cholesterol 4. At least 5 mg of iron 5. Minimum of 400 mg of calcium 6. Minimum of 20 g of protein 7. At least 12 g of fiber Managerial Report Assuming that you are the dietician working with Nutri Fit, you need to prepare a breakfast menu proposal for Silver Lining. Other than nutritional requirement above, you know that each food item cannot be prepared in fraction of serving unit. For example, you cannot prepare a breakfast using 1.35 eggs, or 1.2 cup of milk. In addition, there are also limit on the amount of serving per intake. For example, there should not be more than 3 slices of bread per intake. This is to make sure that the client able to finish his or her meal , as well as to ease preparation process. Therefore, you have prepared several additional condition in preparing the breakfast menu. i. Total cereal (breakfast cereal and oat) must not be more than 1 cup There should be no more than 2 eggs. ii. iii. Total amount of drink must be 1 cup. iv. Maximum of 3 slices of bread per intake. Based on nutritional requirement and conditions above, you need to prepare a breakfast menu proposal for Silver Lining. Your proposal must include, but not limited to the followings. 1. Information showing the recommended menu and the total cost. 2. Detailed information about total nutrient and cost breakdown each food item used in the menu. 3. Mathematical model of Nutri Fit's problem (in Appendix) In addition to above, you know that some people may have certain allergies or religious belief that prevent them to consume certain type of food. To cater to these type of people, you also thinking about developing alternative breakfast menu for two type of people - lactose intolerant (can't consume milk), and vegetarian. Prepare alternative menu proposal similar to (1)-(3) above. You are given 5 minutes to present your proposal. Note: Use Integer Programming in the ExcelQM solver to solve. Not Linear Programming Case Problem Set C LP Case Problem Nutri Fit is a health and fitness center headquartered in Kuala Lumpur. The center not only provides facilities such as gymnasium, swimming pool, and sauna, but also provide custom-made dietary programs for individuals or special-need groups. Clients enrolling into this dietary program will consult Nutri Fit' dietician with their nutritional need and health requirement, and based on that, the company will develop a list of suggested menu be taken by the client. Nutri Fit is approached by Silver Lining Care, an organization that provides elderly care services for senior citizen, Silver Lining want Nutri Fit to develop a breakfast menu for its client currently living in their premises. The breakfast menu must be high in calories, calcium, protein and fiber. which are important to senior citizen. In addition, it must be low in fat and cholesterol. Appendix 1 are nutritional information table and costs for one portion of food items used in breakfast. Based on discussion with Silver Lining, below are the nutritional requirement that Nutri Fit must follow in preparing the breakfast menu. 1. At least 420 calories 2. No more than 20 g of fat 3. Maximum of 30 mg of cholesterol 4. At least 5 mg of iron 5. Minimum of 400 mg of calcium 6. Minimum of 20 g of protein 7. At least 12 g of fiber Managerial Report Assuming that you are the dietician working with Nutri Fit, you need to prepare a breakfast menu proposal for Silver Lining. Other than nutritional requirement above, you know that each food item cannot be prepared in fraction of serving unit. For example, you cannot prepare a breakfast using 1.35 eggs, or 1.2 cup of milk. In addition, there are also limit on the amount of serving per intake. For example, there should not be more than 3 slices of bread per intake. This is to make sure that the client able to finish his or her meal , as well as to ease preparation process. Therefore, you have prepared several additional condition in preparing the breakfast menu. i. Total cereal (breakfast cereal and oat) must not be more than 1 cup There should be no more than 2 eggs. ii. iii. Total amount of drink must be 1 cup. iv. Maximum of 3 slices of bread per intake. Based on nutritional requirement and conditions above, you need to prepare a breakfast menu proposal for Silver Lining. Your proposal must include, but not limited to the followings. 1. Information showing the recommended menu and the total cost. 2. Detailed information about total nutrient and cost breakdown each food item used in the menu. 3. Mathematical model of Nutri Fit's problem (in Appendix) In addition to above, you know that some people may have certain allergies or religious belief that prevent them to consume certain type of food. To cater to these type of people, you also thinking about developing alternative breakfast menu for two type of people - lactose intolerant (can't consume milk), and vegetarian. Prepare alternative menu proposal similar to (1)-(3) above. You are given 5 minutes to present your proposal. Note: Use Integer Programming in the ExcelQM solver to solve. Not Linear Programming