Mathematical expression of linear programming problem, Programming Languages

Assignment Help:

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.


Related Discussions:- Mathematical expression of linear programming problem

Write a shell script to find the maximum of three numbers, W.A.S.S to find ...

W.A.S.S to find the maximum of three numbers Program # W.A.S.S to find the maximum of three numbers echo "Enter three No.:" read no1 read no2 read no3 if test $no1 -gt $n

Multiplication of matrices, The last matrix operation which we'll see is ma...

The last matrix operation which we'll see is matrix multiplication. Now there we will start along with two matrices, A nxp and B pxm . Remember hat A must have similar number of c

Lmc, Plan, design and dry run a program for the Little Man Computer (LMC) t...

Plan, design and dry run a program for the Little Man Computer (LMC) that produces the same result using a fixed number of 10 iterations.

CMIS 102, Calculate the total price based on several key parts required to ...

Calculate the total price based on several key parts required to build a state-of-the-art gaming computer. The user will have the option of selecting different parts.

How would you install a multiple layered security product, Problem: (i)...

Problem: (i) All Security authentication mechanism that run on the TRU64 Unix Operating system run under the Security Integration Architecture ( SIA ) layer. Explain with diag

Describe url and hostname part, Describe URL and hostname part? The hos...

Describe URL and hostname part? The hostname part of the URL should be a valid Internet hostname. It can also be an IP address like as 204.29.207.217 or 128.235.252.184. The

Perl program, Input to be in the form of a string of less than 256 characte...

Input to be in the form of a string of less than 256 characters. Assume that this character string (record) can only be of the form: Last Name, First Name, Box number, City, St

Kinect help, My kinect hand cursor only works for main menu but when it go...

My kinect hand cursor only works for main menu but when it goes to another page it wouldn''t work.. especially when there is for camera feed

Create hijara game application, Assignment is to create hijara game on any ...

Assignment is to create hijara game on any plate form, you can use any plate form you like or easy to you. For instance let's say you can use visual studio, game studio (Prefer to

Selfcare project - strut frame work, Selfcare Project:   Technology U...

Selfcare Project:   Technology Used Strut Frame work, WAS 5.1, WPS 6.0, DB2, AJAX, Eclipse, Rational Application Developer 6 and  DB2 Selfcare is a big umbrella under whic

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd