Mathematical expression of linear programming problem, Programming Languages

A Consultant Dietician provides diet and nutritional advice to clients. A client's diet requires that all the food s/he eats come from one of the four "basic food groups" (chocolate cake, ice cream, soda, and cheese-cake). At present, the following four food types are available: brownies, chocolate ice cream (in scoops), cola (in bottles), and pineapple cheese-cake (in pieces). Each food type has a price per unit. Each day, s/he must intake a minimum required amount of calories and minimum required amounts of chocolate (gm.), sugar (gm.) and fat (gm.).

You are working as a business analyst for the Consultant Dietician. The linear programming model has been formulated and analysed. Your task is to examine the answer and sensitivity reports, interpret the values based on the questions 'a' to 'g' and write a report to the Consultant Dietician that can be used to satisfy the client's daily nutritional requirements at a minimum cost.

The output (answer report and sensitivity report), from Excel's Solver, are given in Table 3 and Table 4 respectively (see page 4). Using the output given on page 4, Answer all questions and comment your results.

a) Write the mathematical expression of the Linear Programming problem for the objective function and state the constraints with the minimum required daily intake.

b) What is the optimal solution, in terms of the client's daily intake, that satisfies the daily nutritional requirements at a minimum cost? Be specific and give your answer in the context of the problem?

c) Calculate the value of the objective function using the information provided in Table 3 and Table 4? Show your calculations and give your answer in the context of the problem?

d) Are all resources fully utilised? Identify the resource(s), if any, that was not fully utilised or surplus. Be specific and give your explanation in the context of the problem.

e) For any resource identified in part (d), what amount of this resource initially set as a minimum requirement? What amount of this resource has slack/surplus? Show your calculations and give your answer in the context of the problem.

f) What is the impact on the optimal solution and the value of the objective function if the unit price for Pineapple cheese-cake increases to £1.50? Give your answer in the context of the problem.

g) What is a shadow price? The shadow price for daily calorie intake is 0. Explain the significance of this value in the context of the problem.

h) Write a short business report (of 600 words) to advice the Consultant Dietician that satisfies the client's daily nutritional requirement at a minimum cost. You will discuss the decision variables, optimal solution, value of objective function, shadow prices, the slack/surplus variables and evaluate the impact of changes on the combination and amounts of food types that provide the required nutrition at the least total cost.

Posted Date: 3/14/2013 5:02:03 AM | Location : United States







Related Discussions:- Mathematical expression of linear programming problem, Assignment Help, Ask Question on Mathematical expression of linear programming problem, Get Answer, Expert's Help, Mathematical expression of linear programming problem Discussions

Write discussion on Mathematical expression of linear programming problem
Your posts are moderated
Related Questions
1. Modify your solution to #8 so that if an ellipse is touched by the mouse, it turns permanently green.Bonus (up to +5): a green ellipse stops moving, but recovers after 5 seconds

1. Implement a program where an ellipse follows the perimeter of the window. 2. Implement a program that can draw graphs, possibly following your plan from last week. Have it gr

I am working on a game project using C# XNA. I only have two weeks from the deadline. Would you help me to finish it up? Please let me know as soon as possible. Thanks, Sophi

Translate the following formula into a prefix form expression in Scheme: Question 2 Define a procedure that takes three numbers as arguments and returns the sum of the squ

How to make game in pascal language

i have to make a program that encrypt a text to numbers, i don''t know what is wrong in my code, the example of what i need: text: hi >> number: 17 23

This assignment will just focus on NookyKindle eBook orders.  That is, we'll be keeping track of the titles of eBooks and the number of orders for that particular eBook during a pa

2. TEST & AND TEST is like CMP, it is used for conditional statement, and doesn’t save the answer. AND is logical multiplication. 3. INS & IN IN is used for data transfer from I/O

We want a program that will allow us to print a "grade list" of the students in a class. The program should loop, asking for a name, midterm score, and final score. It should th

i have a database having field name title and comm. I want to search by name and get the all data remaining title and comm(comm is integer)