Hot Oven daily requirements of 70 g of protein, 1 g calcium, 12 mg iron, and 3000 calories are needed for a balanced diet. The following foods are available for consumption with the cost and nutrients per 100 g as shown.
protien (g) | calories | calcium(g) | iron(mg) | cost (ghc) | |
brown bread | 12.0 | 246 | 0.1 | 3.2 | 0.5 |
cheese | 24.9 | 432 | 0.2 | 0.3 | 20 |
butter | 0.1 | 793 | 0.03 | 0.0 | 1.0 |
baked beans | 6.0 | 93 | 0.05 | 2.3 | 0.25 |
spinach | 3.0 | 26 | 0.1 | 2.0 | 0.25 |
The objective of the Hot Oven is to find a balanced diet with minimum cost.
a) Formulate a linear programming model for this problem.
b) Use solver to find optimal solution and sensitivity report.
c) Management have asked you to determine the optimal solution. Write your answer in a form of a report to be submitted to the management.
d) Advice the management about objective function value corresponding to your answer in (b)
