Question

A small cheese maker specialises in two types of cheese - Brie and Gouda that he makes and sells in packets of 400 grams. The cheese maker has estimated that

each packet of Brie uses 1.8 litres of special milk and 100 grams of special salt. For the Gouda cheese packet, the amounts of special milk and salt needed are 1.2 litre and 150 grams respectively. The cheese maker has a limited supply of special milk and salt and a maximum of only 120 litres of milk and 12000 grams of salt is made available each week. Once produced and sold, the Brie packet returns a £2.80 profit (£2 profit for the Gouda cheese). 1. Enter the information on the table below as an Excel file.You should also insert an appropriate formula for "Total profit" and quantity "Used" for each of the "milk" and "salt" resource in the cells as indicated below. 2. Find the solution of the linear programming problem. 3. Advise on the production of each type of cheese that yield maximum profit.

Question image 1Question image 2Question image 3Question image 4Question image 5Question image 6