Difference: WhiskasCatFoodProblem (47 vs. 48)

Revision 482008-03-11 - MichaelOSullivan

Line: 1 to 1
 
META TOPICPARENT name="SubmitCaseStudy"
<-- Ready to Review -->
Line: 93 to 93
 |*FORM FIELD Results*|Results|Running whiskas.run gives the following output:
ampl: include whiskas.run;
CPLEX 10.1.0: optimal solution; objective 0.52
2 dual simplex iterations (0 in phase I)
Amount [*] :=
   BEEF  60
CHICKEN   0
    GEL  40
 MUTTON   0
   RICE   0
  WHEAT   0
;

This solution indicates that the mix of ingredients for minimising the cost of a can of Whiskas cat food is to use 60g of beef and 40g of gel. The cost of the can will be 52c.

For the Whiskas Cat Food Problem we will not perform any post-optimal analysis. However, this is the example case study for SensitivityAnalysis and ParametricAnalysis.

Validation To validate our solution for the Whiskas Cat Food Problem, we can do a quick check that our solution makes sense. First, the amounts should add up to the weight of the can (e.g., 60g + 40g = 100g). If not, there is something wrong.

Next, we can do a quick check of the constraints to ensure none of them are violated. For large models you won't always be able to check the solution by hand. However, you can use AMPL expressions to quickly calculate quantities needed for validation.

ampl: display {r in REQUIREMENTS} sum {i in INGREDIENTS} Contributes[r, i] * Amo
unt[i];
sum{i in INGREDIENTS} Contributes[r,i]*Amount[i] [*] :=
    FAT    6
  FIBRE    0.3
 ONECAN  100
PROTEIN   12
   SALT    0.3
;

ampl: display Lower, Upper;
:           Lower       Upper       :=
FAT               6   Infinity
FIBRE     -Infinity          2
ONECAN          100        100
PROTEIN           8   Infinity
SALT      -Infinity          0.4
;

The final validation is to write up a management summary for your manager and/or client and see if they think your solution is a valid one. If they identify some (or all) of the solution that is not valid, then you should discuss with them the reasons why it is invalid and start a "feedback" loop in the Operations Research methodology. | |*FORM FIELD Conclusions*|Conclusions|The solution for the Whiskas Cat Food Problem is a simple one to summarise. Here is the management summary for the Whiskas Cat Food Problem.

Important When presenting your solution you must be careful about the number of decimal places you use. You should not use a greater accuracy than your data allows.

Implementation and Ongoing Monitoring The first step towards Implementation of a solution is a good management summary. You may also want to discuss any issues that may arise from the solution you have found with Uncle Ben's (e.g., if you solution can be implemented on their production line).

Ongoing Monitoring may take the form of:

  1. Updating your data files and resolving as the data changes (changing costs, nutritional requirements, etc);
  2. Resolving our model for new products (e.g., 200g cans);
  3. Looking for possible savings (e.g., analysing the cost of the ingredients to see if any price changes will affect the ingredient mix).|
FORM FIELD ExtraForExperts ExtraForExperts
Changed:
<
<
|*FORM FIELD StudentTasks*|StudentTasks|
1. Using whiskas.mod, whiskas.dat and whiskas.run, solve the Whiskas Cat Food Problem. Write a management summary for your solution.

What to hand in Your management summary.

2. Find the optimal mix of ingredients if the can weighs 150g and ham is available as an ingredient that costs $0.007 per g and each g of ham contributes 0.180g of protein, 0.110g of fat, 0.002g of fibre and 0.008g of salt. Write a management summary for your solution.

What to hand in Your new data file whiskas.dat and your management summary.

|
>
>
|*FORM FIELD StudentTasks*|StudentTasks|
1. Using whiskas.mod, whiskas.dat and whiskas.run, solve the Whiskas Cat Food Problem. Write a management summary for your solution.

What to hand in Your management summary.

2. Find the optimal mix of ingredients if the can weighs 150g and ham is available as an ingredient that costs $0.007 per g and each g of ham contributes 0.180g of protein, 0.110g of fat, 0.002g of fibre and 0.008g of salt. Note The nutritional requirements are expressed as percentages of the can weight so these will change. Write a management summary for your solution.

What to hand in Your new data file whiskas.dat and your management summary.

|
 
META FILEATTACHMENT attachment="whiskas_label.jpg" attr="h" comment="Whiskas Label" date="1201735603" name="whiskas_label.jpg" path="C:\Users\Lauren Jackson\Documents\Desktop\Twiki images\whiskas_label.jpg" size="14169" stream="C:\Users\Lauren Jackson\Documents\Desktop\Twiki images\whiskas_label.jpg" tmpFilename="" user="BaseUserMapping_333" version="1"
META FILEATTACHMENT attachment="whiskas_blend.jpg" attr="h" comment="Whiskas Blend" date="1201736009" name="whiskas_blend.jpg" path="C:\Users\Lauren Jackson\Documents\Desktop\Twiki images\whiskas_blend.jpg" size="32908" stream="C:\Users\Lauren Jackson\Documents\Desktop\Twiki images\whiskas_blend.jpg" tmpFilename="" user="BaseUserMapping_333" version="1"
META FILEATTACHMENT attachment="whiskas_ingredients.jpg" attr="h" comment="Whiskas Ingredients" date="1201736055" name="whiskas_ingredients.jpg" path="C:\Users\Lauren Jackson\Documents\Desktop\Twiki images\whiskas_ingredients.jpg" size="25507" stream="C:\Users\Lauren Jackson\Documents\Desktop\Twiki images\whiskas_ingredients.jpg" tmpFilename="" user="BaseUserMapping_333" version="1"
Line: 121 to 121
 
META FILEATTACHMENT attachment="latex559c1abfca06db5484a2f972e6305cd7.png" attr="h" comment="" date="1204361495" name="latex559c1abfca06db5484a2f972e6305cd7.png" stream="GLOB(0x9c4f82c)" tmpFilename="latex559c1abfca06db5484a2f972e6305cd7.png" user="BaseUserMapping_333" version="1"
META FILEATTACHMENT attachment="latexe46b6f2fc90389402611b659d93c70e0.png" attr="h" comment="" date="1204361495" name="latexe46b6f2fc90389402611b659d93c70e0.png" stream="GLOB(0x9c0d6d4)" tmpFilename="latexe46b6f2fc90389402611b659d93c70e0.png" user="BaseUserMapping_333" version="1"
META FILEATTACHMENT attachment="latex4b442b6bb67b6626dac1d9ba2f105fe2.png" attr="h" comment="" date="1204361495" name="latex4b442b6bb67b6626dac1d9ba2f105fe2.png" stream="GLOB(0x9c0d494)" tmpFilename="latex4b442b6bb67b6626dac1d9ba2f105fe2.png" user="BaseUserMapping_333" version="1"
Changed:
<
<
META FILEATTACHMENT attachment="whiskas.doc" attr="" comment="" date="1204489414" name="whiskas.doc" path="whiskas.doc" size="37888" stream="whiskas.doc" tmpFilename="" user="MichaelOSullivan" version="1"
>
>
META FILEATTACHMENT attachment="whiskas.doc" attr="" comment="" date="1205269679" name="whiskas.doc" path="whiskas.doc" size="38912" stream="whiskas.doc" tmpFilename="" user="MichaelOSullivan" version="2"
 
META TOPICMOVED by="MichaelOSullivan" date="1203543335" from="OpsRes.ABlendingProblem" to="OpsRes.WhiskasCatFoodProblem"
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback