Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Part A-Patches' Cat Food Patches is a cat who eats cat food for breakfast. Patches requires a breakfast diet that includes at least 40g of protein, at least 90g of iron but no more than 144g of carbs a week. His two favourite brands are Kitty Kibble and Cat Snack. Kitty Kibble contains 1g of protein, 11g of iron and 6g of carbohydrates per box. Cat Snack contain 5g of protein, 5g of iron and 6g of carbs per box. Kitty Kibble costs $4 a box, Cat Snack costs $2 a box. Patches' owner wants to minimise how much money they spend on cereal while meeting Patches' dietary requirements. 1. Construct a table showing: ● ● 2. State the objective function and determine the constraints for each element. 3. Produce a labelled graph showing the feasible region. 4. Find the optimal solution by considering the feasible points. 5. Determine the wastage or oversupply of elements for the optimal solution. 6. Now investigate changes to the original scenario such as: ● the number of the elements required for each item the amount of each element available or the minimum requirements of each element. ● the impact on the optimal value when the objective function is changed the impact on the optimal value, and wastage and oversupply, when changes are made to the original constraints by: O changing the available amounts of minimal requirements O changing the number of elements or items required adding a further constraint (such as a time limit). 0 0

Part A-Patches' Cat Food Patches is a cat who eats cat food for breakfast. Patches requires a breakfast diet that includes at least 40g of protein, at least 90g of iron but no more than 144g of carbs a week. His two favourite brands are Kitty Kibble and Cat Snack. Kitty Kibble contains 1g of protein, 11g of iron and 6g of carbohydrates per box. Cat Snack contain 5g of protein, 5g of iron and 6g of carbs per box. Kitty Kibble costs $4 a box, Cat Snack costs $2 a box. Patches' owner wants to minimise how much money they spend on cereal while meeting Patches' dietary requirements. 1. Construct a table showing: ● ● 2. State the objective function and determine the constraints for each element. 3. Produce a labelled graph showing the feasible region. 4. Find the optimal solution by considering the feasible points. 5. Determine the wastage or oversupply of elements for the optimal solution. 6. Now investigate changes to the original scenario such as: ● the number of the elements required for each item the amount of each element available or the minimum requirements of each element. ● the impact on the optimal value when the objective function is changed the impact on the optimal value, and wastage and oversupply, when changes are made to the original constraints by: O changing the available amounts of minimal requirements O changing the number of elements or items required adding a further constraint (such as a time limit). 0 0

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question
Solve for question 5 and 6
EX Part A Patches' Cat Food Patches is a cat who eats cat food for breakfast. Patches requires a breakfast diet that includes at least 40g of protein, at least 90g of iron but no more than 144g of carbs a week. His two favourite brands are Kitty Kibble and Cat Snack. Kitty Kibble contains 1g of protein, 11g of iron and 6g of carbohydrates per box. Cat Snack contain 5g of protein, 5g of iron and 6g of carbs per box. Kitty Kibble costs $4 a box, Cat Snack costs $2 a box. Patches' owner wants to minimise how much money they spend on cereal while meeting Patches' dietary requirements. 1. Construct a table showing: 2. State the objective function and determine the constraints for each element. 3. Produce a labelled graph showing the feasible region. 4. Find the optimal solution by considering the feasible points. 5. Determine the wastage or oversupply of elements for the optimal solution. 6. Now investigate changes to the original scenario such as: English (Australia) the number of the elements required for each item the amount of each element available or the minimum requirements of each element. ● the impact on the optimal value when the objective function is changed the impact on the optimal value, and wastage and oversupply, when changes are made to the original constraints by: O O O changing the available amounts of minimal requirements changing the number of elements or items required adding a further constraint (such as a time limit). Accessibility: Investigate Focus F E
Transcribed Image Text:EX Part A Patches' Cat Food Patches is a cat who eats cat food for breakfast. Patches requires a breakfast diet that includes at least 40g of protein, at least 90g of iron but no more than 144g of carbs a week. His two favourite brands are Kitty Kibble and Cat Snack. Kitty Kibble contains 1g of protein, 11g of iron and 6g of carbohydrates per box. Cat Snack contain 5g of protein, 5g of iron and 6g of carbs per box. Kitty Kibble costs $4 a box, Cat Snack costs $2 a box. Patches' owner wants to minimise how much money they spend on cereal while meeting Patches' dietary requirements. 1. Construct a table showing: 2. State the objective function and determine the constraints for each element. 3. Produce a labelled graph showing the feasible region. 4. Find the optimal solution by considering the feasible points. 5. Determine the wastage or oversupply of elements for the optimal solution. 6. Now investigate changes to the original scenario such as: English (Australia) the number of the elements required for each item the amount of each element available or the minimum requirements of each element. ● the impact on the optimal value when the objective function is changed the impact on the optimal value, and wastage and oversupply, when changes are made to the original constraints by: O O O changing the available amounts of minimal requirements changing the number of elements or items required adding a further constraint (such as a time limit). Accessibility: Investigate Focus F E
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS