Please formulate the LP model, and create a spreadsheet model in Excel to solve for the optimal solution and optimal value

12. A nutritionist recommends his patient take a daily supplement containing four vitamins. The patient may purchase two different supplements and add them to a drink to meet the minimum vitamin recommendation. The vitamin content per ounce in each supplement is as follows: VITAMIN SUPPLEMENT X SUPPLEMENTY A 100 units 100 units B 250 units 100 units 350 units 200 units D 50 units 250 units Supplement X costs $3 per ounce and supplement Y costs $4 per ounce. The daily requirement is a minimum of 125 units of Vitamin D, 500 units of Vitamin B, 400 units of Vitamin A, and 900 units of Vitamin C. a. How many ounces of each should the patient use to minimize the cost per day? Formulate the LP model