Question

In: Math

Helena Lorimer runs a set of ice cream cafes that sell mainly three flavors of ice...

Helena Lorimer runs a set of ice cream cafes that sell mainly three flavors of ice cream: vanilla, chocolate, and strawberry. Hot weather and high demand have caused her to run short of the main ingredients: milk, sugar, and cream. She has decided to make the best assortment of ice cream quantities in these three flavors and ration out the deliveries to the cafes.

She has collected data on the profitability of the various flavors, availability of supplies, and the amounts of ingredients required for each flavor.

Flavor

Profit per

Gallon

Usage/Gallon

Milk (gal.)

Sugar (lbs.)

Cream (gal.)

Chocolate

$1.00

0.45

0.50

0.10

Vanilla

$0.90

0.50

0.40

0.15

Strawberry

$0.95

0.40

0.40

0.20

Max available

200

150

60

She wants to determine the optimal product mix for the Lorimer ice cream.

Let       x1 = the # of gallons of Chocolate ice cream made

            x2 = the # of gallons of Vanilla ice cream made

            x3 = the # of gallons of Strawberry ice cream made

Max Z =    $1.00x1 + $0.90x2 + $0.95x3   

Subject To:

0.45x1 + 0.50x2 + 0.40x3

≤ 200 gal

Milk Supply Constraint

0.50x1 + 0.40x2 + 0.40x3

≤ 150 lbs

Sugar Supply Constraint

0.10x1 + 0.15x2 + 0.20x3

≤ 60 gal

Cream Supply Constraint

       x1    

≥ 0 gallons

x1 Non-negativity Constraint

                     x2    

≥ 0 gallons

x2 Non-negativity Constraint

                                    x3   

≥ 0 gallons

x3 Non-negativity Constraint

Use your Excel spreadsheet model to answer the following question. Select the answer that best fits what you got. The answer options are not in any particular order.

What is the value of the X2 decision variable at the optimal solution?

Select one:

a. X2 = 275 gallons

b. X2 = 220

c. X2 = 275

d. X2 = 220 gallons

e. X2 = 120

f. X2 = 300 gallons

g. X2 = 200

h. X2 = 300

i. X2 = 200 gallons

j. X2 = 120 gallons

Solutions

Expert Solution

Prepare the following sheet in Excel

get this

set up the solver using data--->solver

get this

the value of the X2 decision variable at the optimal solution is

ans:  f. X2 = 300 gallons


Related Solutions

Helena Lorimer runs a set of ice cream cafes that sell mainly three flavors of ice...
Helena Lorimer runs a set of ice cream cafes that sell mainly three flavors of ice cream: vanilla, chocolate, and strawberry. Hot weather and high demand have caused her to run short of the main ingredients: milk, sugar, and cream. She has decided to make the best assortment of ice cream quantities in these three flavors and ration out the deliveries to the cafes. She has collected data on the profitability of the various flavors, availability of supplies, and the...
Graeter’s is thinking about expanding its ice cream flavors. They have created three new flavors of...
Graeter’s is thinking about expanding its ice cream flavors. They have created three new flavors of ice cream: (1) Lemon Merengue Pie, (2) Butterscotch, and (3) Banana Cream Pie. They recruit 18 people to participate in their study, and they assign each participant to taste-test one of their new ice cream flavors. After tasting the flavor, participants rate their likelihood of ordering that ice cream flavor on their next trip to Graeter’s, using a scale from 1 (I definitely wouldn’t...
At an ice cream store, there are 6 flavors of ice cream: banana, strawberry, vanilla, mint,...
At an ice cream store, there are 6 flavors of ice cream: banana, strawberry, vanilla, mint, chocolate and raspberry. How many different 2- flavor ice cream cones can be made? (5 points) Steve has 6 pants and 7 shirts in his closet. He wants to wear a different pant/shirt combination each day without buying new cloths for as long as he can. How many weeks can he do this for? (5 points)
An ice-cream shop serves 5 flavors ice-cream to its customers. The shop has seating capacity for...
An ice-cream shop serves 5 flavors ice-cream to its customers. The shop has seating capacity for 6 people. One fine Saturday morning, as the shop opens, 4 kids enter the shop for ice-cream. Please provide expanded formulas or expressions to answer following questions. You need not solve the final arithmetic. 1. What are the different ways in which the 4 kids can sit? 2. What are the different types of orders possible, if each kid orders exactly one serving of...
An ice cream shop sells five-scoop ice cream cones, allowing customers to pick which flavors they...
An ice cream shop sells five-scoop ice cream cones, allowing customers to pick which flavors they want stacked on their cone. The shop has the following ice cream flavors available: chocolate, vanilla, strawberry, mint & chocolate chip, rocky road, cookies & cream, cookie dough, cotton candy, butter pecan, birthday cake, and cherry. Note that customers can order a five-scoop cone with multiple scoops of the same flavor. a) How many five-scoop cones are possible if order of the ice cream...
The UDairy ice cream truck plans to sell ice cream at an upcoming alumni event in...
The UDairy ice cream truck plans to sell ice cream at an upcoming alumni event in Central Park (NYC). From past events, demand for ice cream is highly weather dependent. On rainy days, demand is normally distributed with a mean of 120 scoops and standard deviation of 35 scoops. On non-rainy days, demand is normally distributed with a mean of 200 scoops and standard deviation of 60 scoops. The ice cream truck will be loaded two days before the event...
The following class keeps track of how many flavors are at an ice-cream place, and the...
The following class keeps track of how many flavors are at an ice-cream place, and the number of calories of each flavor. The calories of each flavor ice-cream are positive values of type unsigned int and are stored as a dynamically allocated array. The first data member is a pointer that will point to the first element of the array. This array will be of an arbitrary size. The default size of the array shall be 25, but may be...
A researcher is examining preferences among four new flavors of ice cream. A sample of n...
A researcher is examining preferences among four new flavors of ice cream. A sample of n = 80 people is obtained. Each person tastes all four flavors and then picks his/her favorite. The distribution of preferences is as follows. Ice Cream Flavors A B C D 6 18 34 22 Do these data indicate any significant preferences among the four flavors? Test at the .05 level of significance and report your findings.
A retail store serves a variety of ice cream flavors. The owner would like to add...
A retail store serves a variety of ice cream flavors. The owner would like to add a flavor to the menu and needs to decide between Blueberry Cheesecake and Lemon Custard. To help her​ decide, she randomly selects 10 customers and asks them to taste each flavor and rate them on a scale of 1 to 20. A rating of 1 indicates the taster does not like the​ flavor, and a rating of 20 indicates that the taster likes it...
A researcher is examining preferences among four new flavors of ice cream. A sample of n...
A researcher is examining preferences among four new flavors of ice cream. A sample of n = 80 people is obtained. Each person tastes all four flavors and then picks his/her favorite. The distribution of preferences is as follows. Ice Cream Flavors A6 B18 C34 D22 Do these data indicate any significant preferences among the four flavors? Test at the .05 level of significance and report your findings.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT