# The Whiskas Cat Food Problem Management Summary

 Дата канвертавання 28.04.2016 Памер 11.04 Kb.

## Problem Summary

Uncle Ben’s want to produce their cat food products as cheaply as possible while ensuring they meet the stated nutritional analysis requirements shown on the cans. Thus they want to vary the quantities of each ingredient used (the main ingredients being chicken, beef, mutton, rice, wheat and gel) while still meeting their nutritional standards.
The stated nutritional analysis requirements are:

• The % of Crude Protein must be at least 8%.

• The % of Crude Fat must be at least 6%.

• The % of Crude Fibre must be at most 2%.

• The % of (Naturally Occurring) Salt must be at most 0.4%.

They are producing 100g cans, so the nutritional requirements correspond to:

• At least 8g of Protein.

• At least 6g of Fat.

• At most 2g of Fibre.

• At most 0.4g of (Naturally Occurring) Salt.

The cost for each ingredient is given in Table 1.

 Ingredient Cost (per g) Chicken \$0.013 Beef \$0.008 Mutton \$0.010 Rice \$0.002 Wheat \$0.005 Gel \$0.001

Table 1 Cost of the ingredients

## Solution Approach

To find the right mix of ingredients we formulated this problem as a linear programme in AMPL (see www.ampl.com for details) and solved it with the CPLEX (see www.cplex.com for details) solver.

## Results

With the current input data, the optimal solution is shown in Table 2. The time to find this solution was negligible.

 Ingredient Optimal amount (g) Chicken 0 Beef 60 Mutton 0 Rice 0 Wheat 0 Gel 40

Table 2 Optimal mix of ingredients

## Conclusions and Recommendations

To minimise the cost per 100g can of Whiskas cat food, Whiskas should use

The cost per can is \$0.52 or 52c.

База данных защищена авторским правом ©shkola.of.by 2016
звярнуцца да адміністрацыі