"Question $5(5+10+5=20$ points$)$

Develop and solve the Excel model for this problem, in a worksheet titled $$Nutrition$.$

Consider four food choices, with their unit cost $[$$$],$ nutrient contribution $[$milligrams per unit of food$],$ and

the monthly nutritional requirements of an average adult $[$milligramsper nutrient$]$ shown in the table below.

The data shown are purely illustrative.

Nutrient Contents Per Unit Food

Food $1$ Food $2$ Food $3$ Food $4$ Nutrients Required Per Month $[$mg$]$

Nutrient $1[$mg$]4511121200$

Nutrient $2[$mg$]3458800$

Nutrient $3[$mg$]75891000$

Nutrient $4[$mg$]10812182200$

Unit Cost $[$$$]2\mathrm{.}753\mathrm{.}253\mathrm{.}905\mathrm{.}70$

a$)$ For simplicity, first we assume that the nutritional requirements of the entire considered $($adult$)$

population are deterministic as indicated by the table. We also assume that the food types considered can

be delivered in arbitrary continuous amounts. Using a spreadsheet model, find the dietary plan that meets

all given average monthly nutritional requirements at minimum cost."