$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!
Students Who Viewed This Also Studied
STAT 2112 Quantitative Methods for Business
Task
Anne Chang is the dietician for women’s soccer team, and she is attempting to determine a nutritious lunch menu for the team. She has set the following nutritional guidelines for each lunch serving.
- Between 1500 and 2000 calories
- At least 5 mg of iron
- At least 20 but no more than 60 g of fat
- At least 30 g of protein
- At least 40 g of carbohydrates
- No more than 30 mg of cholesterol
She selects the menu from seven basic food items as follows, with the nutritional contribution per pound and the cost as given.
|
Calories (per lb) |
Iron (mg/lb) |
Protein (g/lb) |
Carbohydrates (g/lb) |
Fat (g/lb) |
Cholesterol (mg/lb) |
$/lb |
|
|
Chicken |
520 |
4.4 |
17 |
30 |
180 |
3.44 |
|
|
Fish |
500 |
3.3 |
85 |
5 |
90 |
3.99 |
|
|
Ground beef |
860 |
0.3 |
82 |
75 |
350 |
4.99 |
|
|
Dried beans |
600 |
3.4 |
10 |
30 |
3 |
1.10 |
|
|
Lettuce |
50 |
0.5 |
6 |
0.90 |
|||
|
Potatoes |
460 |
2.2 |
10 |
70 |
0.59 |
||
|
Milk (2%) |
240 |
0.2 |
16 |
22 |
10 |
20 |
0.83 |
Anne wants to select a menu to meet the nutritional guidelines while minimizing the total cost per serving. Please help Anne to formulate a linear programming model and solve it using Excel Solver and answer the following questions.
- What is the cost per meal for the “optimal” plan?
- What is the weight of the “optimal” meal?
- Is it a well-balanced diet?
The complete detailed mathematical LP model including the description of the decision variables. This part can be typed or (neatly) handwritten and then scanned.
Make sure to include the title page. Excel Solver solution printout with the optimal solution. Answer Report generated by Excel Solver. Sensitivity Report generated by Solver Answers to all the questions included in the problem statement.
STAT 2112 Quantitative Methods for Business
Answer in Detail
Solved by qualified expert
Get Access to This Answer
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
17 More Pages to Come in This Document. Get access to the complete answer.
MyAssignmenthelp.com is the best assignment help service provider in the world. By best, we mean that our online assignment help is of top class quality. Be it custom essay help, dissertation writing services or homework help, we have proved our might in the writing service industry. Our highly qualified team of 3000+ writers can work on any academic assignment for you. Students from Australia, UK or USA can contact us for availing academic assignment help through 24×7 live chat support. We have talented customer support staff that can address any of your assignment-related queries. Be assured that our staff will get back to you with the solutions on time.
More STAT2112 STAT 2112 Quantitative Methods for Business: Questions & Answers
SITHCCC020 Work Effectively as a Cook
Questions:
Q1. List 8 pieces of information you need to include on a standard recipe card
Q2. List three advantages of having a standard recipe card.
Q3. A recipe for a Pork Terrine makes 15 serves of terrine and costs $32 to make (food cost).
What is the cost per serve of pork terrine?
If …
View Answer
MAN308 Customer Benefit Packages and Value Chains
Task Details
Identify two organisations in an industry of your choice. These organisations must have different value chain designs and structures. One of these organisations should be based around a purely physical product or products (a Good) and the other around an intangible product or prod …
View Answer
Business Organisation
Lean Operations and Scheduling 14: Critical Thinking Lean Operations (130 points) Due date May 9, 2017 All organizations, regardless of industry, can implement lean operations. In the organization where you currently work, an organization where you worked previously, or one with which you are famili …
View Answer
BSBMGT517 Manage Operational Plan
Questions Each organisation will have a series of plans that should reflect the core activities of the organisation and be designed to meet established organisational goals. It is important that the section you manage has its plans aligned with the requirements of organisation plans and goals. Are y …
View Answer
Content Removal Request
If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the
content removal request.
Choose Our Best Expert to Help You
Hood Albert
Ph.D. in Accounts from the University of Connecticut
800 – Completed Orders
Hire Me
Amari Beltran
I have acquired my Master’s degree in Literature from the University of Glasgow
380 – Completed Orders
Hire Me
Joshua Rose
PhD in Physics with specialization in Molecular Physics
201 – Completed Orders
Hire Me