Develop a linear programming model and solve it with Excel. Your solution will r
ID: 3592514 • Letter: D
Question
Develop a linear programming model and solve it with Excel. Your solution will result in fractional values.
a. After the optimal is found, select the “Answer” report, so that your result is saved as a new tab. Answer the
following questions in a textbox on the new answer tab:
i. Assuming that a fraction of a gallon would actually take just as long to freeze as an entire gallon, could the PiPhi’s make the suggested optimal quantity?
ii. What are all the binding constraints and for each explain the importance of the binding constraints to the PiPhi’s
b. Force the answers to be integers and re2run the problem. Save that answer report as well.
_________________
The PiPhi's at Weiser State University hold an annual fund-raiser for which they make and sell Chocolate Gelato following one of their member's grandmother's recipes she brought back from Somma Vesuviana, Italy.
The three flavors require the following ingredients (in cups, except eggs are in units) to make a one-gallon batch:
Milk
Cream
White Sugar
Cocoa powder
Eggs
Vanilla
Coffee liquor
cioccolato amaro
7 1/2
1 1/3
2 1/4
6
13
1/3
1/3
cioccolato vero
4
3 3/4
2
412
17
14
14
cioccolato bacio
614
212
2 1/3
434
12
12
0
A local store has donated 50 gallons of Milk, 30 gallons of cream 200 pounds of sugar, 100 pounds of cocoa, 10 gross of eggs, 40 gallons of vanilla and 60 half-gallon jugs of coffee liquor.
Their production for the fundraiser is limited to 640 ice cream freezer hours. The freezer is dependent upon ingredients, not volume, although the freezer holds a gallon.
Amaro freezes for 6.5 hours
Vero freezes for 6 hours
Bacio freezes for 5.5 hours
Once the gallon batches are made, they are divided for packaging and sold for the following prices per quart:
Amaro: $9
Vero: $8
Bacio: $7.50
They already have pre-orders for 75 Amaro, 40 Vero, and 45 Baccio quarts. They would also like to make at least 10 additional quarts of each so that there's some selection of every item left for their kick-off sale.
How many gallons of each product should the PiPhi's make to maximize profits?
Hint: you're going to need to do a bunch of conversions. Be sure to find an accurate source.
Milk
Cream
White Sugar
Cocoa powder
Eggs
Vanilla
Coffee liquor
cioccolato amaro
7 1/2
1 1/3
2 1/4
6
13
1/3
1/3
cioccolato vero
4
3 3/4
2
412
17
14
14
cioccolato bacio
614
212
2 1/3
434
12
12
0
Explanation / Answer
given two array of elements representing the connection Nodes output the topology used?
Topology can be either Bus , circular or Star
input:
Number of nodes 3
Number of Connections : 2
{1,2}
{2,3}
Output Bus
Explanation
the topology formed would be 1->2->3 . hence Bus
input
number of nodes : 3
Number of connections : 3
{1,2,3}
{2,3,1}
Output: Circular
the topology formed is 1->2->3->1
hence circular
input:
number of nodes : 5
Number of connections : 5
2 3 4 5
1 1 1 1
Answer : StarTopology
Explanation : A star can be formed with this input
2 4
1
3 5
StarTopology
- ASimpleCoder October 15, 2017 in India | Report Duplicate | Flag
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.