Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Three seller offers three foods, which contain three different nutrients. We are given Table 3 with the nutritional content of a unit of each food,

Three seller offers three foods, which contain three different nutrients. We are given Table 3 with the nutritional content of a unit of each food, the minimum requirement of each nutrient, and the selling price for a unit of each food. I want to design a diet so as to satisfy the minimum requirement of the nutrients and minimize the total price to purchase the food in the diet. 


How do I solve this Linear Programming problem with excel AND obtain a sensitivity report?


Table 3: Food 

Carbohydrates Fat Protein Unit Price Burger Fried Rice 4 3 4 5 Pizza Minimum Requirement 3 3 2 4 4 Table 3: Food 3 2 3 12 8 20

Step by Step Solution

3.43 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

Decision Variables Let x number of burgers y number of fried rice z number of pizza Objective is to ... 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 Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

More Books

Students also viewed these General Management questions

Question

Implement the method contains() for HashST.

Answered: 1 week ago

Question

Distinguish between employee fraud and management fraud.

Answered: 1 week ago

Question

What is the meaning of the term attest services?

Answered: 1 week ago