Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show the proper calculation and tables in excel thankyou PROBLEM 1 Note that hg stands for hectogram = 100 grams. A canteen has to

please show the proper calculation and tables in excel thankyou image text in transcribed
PROBLEM 1 Note that hg stands for hectogram = 100 grams. A canteen has to plan the composition of the meals that it provides. A meal can be composed of the types of food indicated in the following table. Costs, in dollars per hg, and availability, in hk, are also indicated. Availability Food Bread Milk Cont 0.1 0.6 0.12 0.9 1.3 3 1 2 Meat Caloe A meal monest contain at least the following quantities per nutrient Nutrient Calories Proteins Calcium Minimal quantity 600 cal 50 $ 0.75 Each bag of each element contains to following amount of tourists Tood Calories (Gal Protein (6) Milk F. Meat Cake 30 50 150 180 400 5 16 30 90 70 Calcium) 0.02 0.16 0.05 0.09 0.01 A) Write the linear program for finding a diet of minimum total cost that satisfies the minimum nutrient requirements. B) Solve this linear program and interpret the results

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

Guide To Financial Instruments General Characteristics Of Bonds Chapter 1 General Characteristics Of Bonds

Authors: Professional Risk Managers' International Association (PRMIA)

1st Edition

0071731881, 9780071731881

More Books

Students also viewed these Finance questions