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.

Advanced Engineering Mathematics
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
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
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,
SEE MORE TEXTBOOKS