Nutri$-$Jenny is a weight$-$management center. It produces a wide variety of frozen entr$$es for consumption by its clients. The entr$$es are strictly monitored for nutritional content to ensure that the clients are eating a balanced diet. One new entr$$e will be a beef sirloin tips dinner. It will consist of beef tips and gravy, plus some combination of peas, carrots, and a dinner roll. Nutri$-$Jenny would like to determine what quantity of each item to include in the entr$$e to meet the nutritional requirements, while costing as little as possible. The nutritional information for each item and its cost are given in the accompanying table. The nutritional requirements for the entr$$e are as follows:Click here for the Excel Data File

$(1)$ it must have between $275$ and $315$ calories,

$(2)$ calories from fat should be no more than $30$ percent of the total number of calories, and

$(3)$ it must have at least $595$ IUs of vitamin A$,5$ milligrams of vitamin C$,$ and $25$ grams of protein.

Furthermore, for practical reasons, it must include at least $2$ ounces of beef, and it must have at least half an ounce of gravy per ounce

of beef.

Formulate and solve a linear programming model for this problem on a spreadsheet by using the Excel Solver.

a$.$ Determine the quantity of each food item used.

Note: Round your answers to $2$ decimal places.

b$.$Determine the total cost. Please answer part A and B