Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Programming Language Expert

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.

Programming Language, Programming

  • Category:- Programming Language
  • Reference No.:- M9528602

Have any Question?


Related Questions in Programming Language

Overviewthis tasks provides you an opportunity to get

Overview This tasks provides you an opportunity to get feedback on your Learning Summary Report. The Learning Summary Report outlines how the work you have completed demonstrates that you have met all of the unit's learn ...

Background informationthis assignment tests your

Background Information This assignment tests your understanding of and ability to apply the programming concepts we have covered throughout the unit. The concepts covered in the second half of the unit build upon the fun ...

Php amp session managment assignment -this assignment looks

PHP & SESSION MANAGMENT ASSIGNMENT - This assignment looks at using PHP for creating cookies and session management. Class Exercise - Web Project: Member Registration/Login This exercise will cover adding data connectivi ...

Assignment - horse race meetingthe assignment will assess

Assignment - Horse Race Meeting The Assignment will assess competencies for ICTPRG524 Develop high level object-oriented class specifications. Summary The assignment is to design the classes that are necessary for the ad ...

Structs and enumsoverviewin this task you will create a

Structs and Enums Overview In this task you will create a knight database to help Camelot keep track of all of their knights. Instructions Lets get started. 1. What the topic 5 videos, these will guide you through buildi ...

Question 1 what is hadoop explaining hadoop 2 what is

Question: 1. What is Hadoop (Explaining Hadoop) ? 2. What is HDFS? 3. What is YARN (Yet Another Resource Negotiator)? The response must be typed, single spaced, must be in times new roman font (size 12) and must follow t ...

1 write a function named check that has three parameters

1. Write a function named check () that has three parameters. The first parameter should accept an integer number, andthe second and third parameters should accept a double-precision number. The function body should just ...

Assignment - horse race meetingthe assignment will assess

Assignment - Horse Race Meeting The Assignment will assess competencies for ICTPRG524 Develop high level object-oriented class specifications. Summary The assignment is to design the classes that are necessary for the ad ...

Assignment - proposal literature review research method1

Assignment - Proposal, Literature Review, Research Method 1. Abstract - Summary of the knowledge gap: problems of the existing research - Aim of the research, summary of what this project is to achieve - Summary of the a ...

Assignment task -q1 a the fibonacci numbers are the numbers

Assignment Task - Q1. (a) The Fibonacci numbers are the numbers in the following integer sequence, called the Fibonacci sequence, and are characterised by the fact that every number after the first two is the sum of the ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As