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)

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question

you can solve on lingo or excel solver please paste code or comment 

2- 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
Peanut butter (1 table
75
100
4
spoon)
Strawberry jelly (1 table
75
spoon)
Milk (1 cup)
70
150
2.
8.
15
Juice (1 cup)
100
120
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 12 g 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)
3.
Transcribed Image Text:2- 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 Peanut butter (1 table 75 100 4 spoon) Strawberry jelly (1 table 75 spoon) Milk (1 cup) 70 150 2. 8. 15 Juice (1 cup) 100 120 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 12 g 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) 3.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 5 images

Blurred answer
Knowledge Booster
Organizational development
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.
Similar questions
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
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…
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)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON