Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Homework #1 Tim loves pork and apples. Therefore, he has decided to go on a steady diet of only these two foods (plus some liquids,

image text in transcribed
Homework #1 Tim loves pork and apples. Therefore, he has decided to go on a steady diet of only these two foods (plus some liquids, vitamin and supplements) for all his meals. Tim realizes that this isn't the healthiest diet, so he wants to make sure that he eats the right quantities of the two foods to satisfy some key nutritional requirements. He has obtained the following nutritional requirement. Note: Please note that I do a plagiarism check via online Safe-Assign tool. It is extremely important for you to develop an analysis and answer using your original thoughts and ideas. Plagiarism can be identified easily (100% certainty). Grams of Ingredient per Serving Pork Apple Daily Requirement Carbohydrates 2 13 241 Protein 20 5 237 Fat 10 2 S 71 Cos per Serving $5 $8 Tim wishes to determine the number of daily servings (may be fractional) of pork and apples that will meet this requirement at a minimum cost. (a) Identify decision variables, objective function, and constraints and explain them in words, using at least 100 words (b) Formulate a mathematical linear programming model using equations. Make sure you provide the exact descriptions of each variable and mathematical notations shown in the assignment guideline ppt. Note that part b is NOT asking you to provide a mathematical formulation in the Excel Spreadsheet. You MUST provide a mathematical formulation of the linear programming model using specific equations in a word document. (c) Solve a linear programming model for this problem on a spreadsheet, and interpret the results ( meaning what is the optimal amount of daily serving for pork and apples, and what is the minimum cost at the optimal servings of pork and apples?), using at least 100 words. Please round up the numbers (optimal solution) to the nearest hundredth. Note that part C must provide the mathematical formulation of the linear programming model in the Excel Spreadsheet along with the optimal solution, and answer report. In other words, the Excel Spreadsheet must include two separate tabs - (1) sheet 1 (where you set up the linear programming model) and (2) answer report. Also, your interpretations must be included in a word document. Important Note: When you submit the Homework #1, it should include only two documents - (1) Excel Spreadsheet with two tabs and (2) ONE word document

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

Students also viewed these Accounting questions