Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Nutri-Jenny is a weight-management center. It produces a wide variety of frozen entres for consumption by its clients. The entres are strictly monitored for

image text in transcribed

Nutri-Jenny is a weight-management center. It produces a wide variety of frozen entres for consumption by its clients. The entres are strictly monitored for nutritional content to ensure that the clients are eating a balanced diet. One new entre 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 entre 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 entre are as follows: Beef Unit Cost (per ounce) $0.40 Gravy $0.35 $0.15 $0.18 Peas Carrots Roll $0.10 Nutritional Data (per ounce) Needed Maximum Calories 54 20 15 8 40 275 315 Fat Calories 19 15 0 0 10 Vitamin A (IU) 15 350 0 595 Vitamin C (mg) 0 1 3 1 0 5 Protein (9) 0 1 1 1 25 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. Beef Gravy Peas Carrots Roll b. Determine the total cost Note: Round your answer to 2 decimal places.. Total cost

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting

Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren

23rd Edition

978-0324662962

More Books

Students also viewed these Accounting questions

Question

1. Avoid long-winded statements or nagging.

Answered: 1 week ago

Question

What is the balance sheet identity? AppendixLO1

Answered: 1 week ago