Joyce and Marvin run a day care for preschoolers. They are trying to decide what to feed the children for lunches. They would like to keep their costs down, but also need to meet the nutritional requirements of the children. They have already decided to go with peanut butter and jelly sandwiches, milk, and orange juice. The nutritional content of each food choice and its cost are given in the table below. Food Item Calories Total Vitamin C Protein Cost from fat calories (mg) (g) (C) Bread (1 slice) 10 70 3 15 Peanut butter (1 table 75 spoon) 100 14 14 Strawberry jelly (1 table 75 13 10 17 spoon) Milk (1 cup) 70 150 2. 15 Juice (1 cup) 100 120 1 35 The nutritional requirements are as follows: • Each child should receive between 500 and 600 calories. • No more than 30% of total calories should come from fat. • Each child should consume at least 60 mg of Vitamin C and 12g of protein. • Each child should receive exactly 2 slices of bread (to make the sandwich), at least twice as much peanut butter as jelly and at least 1 cup of liquid (milk and/or juice). What would be the minimum cost of a lunch per children? (You may consider using Excel solver or Lingo)
Joyce and Marvin run a day care for preschoolers. They are trying to decide what to feed the children for lunches. They would like to keep their costs down, but also need to meet the nutritional requirements of the children. They have already decided to go with peanut butter and jelly sandwiches, milk, and orange juice. The nutritional content of each food choice and its cost are given in the table below. Food Item Calories Total Vitamin C Protein Cost from fat calories (mg) (g) (C) Bread (1 slice) 10 70 3 15 Peanut butter (1 table 75 spoon) 100 14 14 Strawberry jelly (1 table 75 13 10 17 spoon) Milk (1 cup) 70 150 2. 15 Juice (1 cup) 100 120 1 35 The nutritional requirements are as follows: • Each child should receive between 500 and 600 calories. • No more than 30% of total calories should come from fat. • Each child should consume at least 60 mg of Vitamin C and 12g of protein. • Each child should receive exactly 2 slices of bread (to make the sandwich), at least twice as much peanut butter as jelly and at least 1 cup of liquid (milk and/or juice). What would be the minimum cost of a lunch per children? (You may consider using Excel solver or Lingo)
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Related questions
Question
you can solve on lingo or excel solver please paste code or comment
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 5 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON