Reducing Cafe Costs Essay Example

  • Category:
    Business
  • Document type:
    Assignment
  • Level:
    Undergraduate
  • Page:
    1
  • Words:
    187

The linear programming model has been formulated as shown in the excel spreadsheet. There are five constraints for this LP model that relate to the use of Protein, Iron, Vitamin C in the Casserole, the weight of potatoes to the green beans and the minimum casseroles to produce. In order to minimize the total costs of buying potatoes and green beans, Jane should purchase 15.52 kg of potatoes and 12.93 kg of green beans.

Based on the new nutritional requirements, Jane should purchase 31.04 kg of potatoes and 25.87 kg of green beans.

Based on the new high price of green beans Jane should purchase 15.52 kg of potatoes and 12.93 kg of green beans.

Based on the nutritional requirements of part b and high price of part c, Jane should purchase 31.04 kg of potatoes and 25.87 kg of green beans.

Based on part d, if the amount of the Vitamin C and Iron were to be changed then it would not affect the cost because the amount of potatoes and green beans to be purchased remains same as in part b of the case.