Kirkman Brothers ice cream parlors sell three different flavors of Dairy Sweet ice milk:chocolate, vanilla, and banana. Due to extremely hot weather and a high demand for its products, Kirkman has run short of its supply of ingredients: milk, sugar, and cream. Hence, Kirkman will not be able to fill all the orders received from its retail outlets, the ice cream parlors. Due to these circumstances, Kirkman decided to make the most profitable amounts of the three flavors, given the constraints on supply of the basic ingredients. The company will then ration the ice milk to the retail outlets. Kirkman collected the following data on profitability of the various flavors, availability of supplies, and amounts required for each flavor. Flavor Chocolate Vanilla Banana Maximum available Profit/ Gallon 1.00 0.90 0.95 Material per Ton of paint Cream Milk (gallons) 0.45 0.50 0.40 200 Sugar (pounds) 0.5 0.40 0.40 150 (gallons) 0.10 0.15 0.20 60 Determine the optimal product mix for Kirkman Brothers using the excel solver and produce the answer report.

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question
Kirkman Brothers ice cream parlors sell three different flavors of Dairy
Sweet ice milk:chocolate, vanilla, and banana. Due to extremely hot
weather and a high demand for its products, Kirkman has run short of its
supply of ingredients: milk, sugar, and cream. Hence, Kirkman will not
be able to fill all the orders received from its retail outlets, the ice cream
parlors. Due to these circumstances, Kirkman decided to make the most
profitable amounts of the three flavors, given the constraints on supply
of the basic ingredients. The company will then ration the ice milk to
the retail outlets. Kirkman collected the following data on profitability of
the various flavors, availability of supplies, and amounts required for each
flavor.
Flavor
Chocolate
Vanilla
Banana
Maximum available
Profit/
Gallon
1.00
0.90
0.95
Material per Ton of paint
Cream
Milk
(gallons)
0.45
0.50
0.40
200
Sugar
(pounds)
0.5
0.40
0.40
150
(gallons)
0.10
0.15
0.20
60
Determine the optimal product mix for Kirkman Brothers using the excel
solver and produce the answer report.
Transcribed Image Text:Kirkman Brothers ice cream parlors sell three different flavors of Dairy Sweet ice milk:chocolate, vanilla, and banana. Due to extremely hot weather and a high demand for its products, Kirkman has run short of its supply of ingredients: milk, sugar, and cream. Hence, Kirkman will not be able to fill all the orders received from its retail outlets, the ice cream parlors. Due to these circumstances, Kirkman decided to make the most profitable amounts of the three flavors, given the constraints on supply of the basic ingredients. The company will then ration the ice milk to the retail outlets. Kirkman collected the following data on profitability of the various flavors, availability of supplies, and amounts required for each flavor. Flavor Chocolate Vanilla Banana Maximum available Profit/ Gallon 1.00 0.90 0.95 Material per Ton of paint Cream Milk (gallons) 0.45 0.50 0.40 200 Sugar (pounds) 0.5 0.40 0.40 150 (gallons) 0.10 0.15 0.20 60 Determine the optimal product mix for Kirkman Brothers using the excel solver and produce the answer report.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
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,