Homework Help is Here – Start Your Trial Now!
Math
Advanced Math
A small cheese maker spSIalisES, 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 ljtres of milk and 12000 grams of salt is made available each week. Once produced and sold, the Brie packet returns a £5 profit and £4 profit for the Gouda cheese. Required: 1. Enter the information on the table below into 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. Packet Brie Gouda Quantity Total Profit Insert Unit 5 4 profit (£) formula Used Symbol Мах Milk 120 Insert number Insert number Insert formula (Litres) Salt 12000 Insert number Insert number Insert formula (grams) 2. Find the solution of the linear programming problem (using Excel Solver) 3. State the production of each type of cheese that yield maximum profit.

A small cheese maker spSIalisES, 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 ljtres of milk and 12000 grams of salt is made available each week. Once produced and sold, the Brie packet returns a £5 profit and £4 profit for the Gouda cheese. Required: 1. Enter the information on the table below into 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. Packet Brie Gouda Quantity Total Profit Insert Unit 5 4 profit (£) formula Used Symbol Мах Milk 120 Insert number Insert number Insert formula (Litres) Salt 12000 Insert number Insert number Insert formula (grams) 2. Find the solution of the linear programming problem (using Excel Solver) 3. State the production of each type of cheese that yield maximum profit.

College Algebra
College Algebra
7th Edition
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:James Stewart, Lothar Redlin, Saleem Watson
Chapter5: Systems Of Equations And Inequalities
Section: Chapter Questions
Problem 11P
See similar textbooks
icon
Related questions
Question
5. 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 £5 profit and £4 profit for the Gouda cheese. Required: 1. Enter the information on the table below into 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. Packet Brie Gouda Quantity Total Profit Insert Unit 5 4 profit (£) formula Used Symbol Мах Milk Insert number Insert Insert 120 (litres) number formula Salt Insert number Insert Insert formula 12000 (grams) number 2. Find the solution of the linear programming problem (using Excel Solver) 3. State the production of each type of cheese that yield maximum profit.
Transcribed Image Text:5. 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 £5 profit and £4 profit for the Gouda cheese. Required: 1. Enter the information on the table below into 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. Packet Brie Gouda Quantity Total Profit Insert Unit 5 4 profit (£) formula Used Symbol Мах Milk Insert number Insert Insert 120 (litres) number formula Salt Insert number Insert Insert formula 12000 (grams) number 2. Find the solution of the linear programming problem (using Excel Solver) 3. State the production of each type of cheese that yield maximum profit.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Matrix Factorization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS