Question

In: Operations Management

Formulate the following problem as an LP problem. Glassco manufactures wine glasses, beer glasses, champagne glasses...

Formulate the following problem as an LP problem.

Glassco manufactures wine glasses, beer glasses, champagne glasses and whiskey glasses. Each type of glass uses time in the molding shop, time in the packaging shop and a certain amount of glass. The resources required to make one of each type of glass are given below.    At present, 600 minutes of molding time, 400 minutes of packaging time and 500 oz of glass are available per week. Glassco has a contract that must be met - to provide 20 beer glasses to a local bar.   Glassco wishes to maximize profit per week.

Wine

Beer

Whiskey

Champagne

Molding time (min)

4

9

7

10

Packaging time (min)

1

1

3

40

Glass (oz)

3

4

2

2.5

Profit $

6

10

9

20

Solutions

Expert Solution

Since the only formulation is required, we need not solve the formulated LPP.

Let No. of Wine glasses manufactured be W, Beer glasses be B, Champagne glasses be C and Whiskey glasses be H.

Total Profit = 6 * W + 10 * B + C * 9 + 20 * H

We have to maximize the profit. Hence, we get the objective function as:

Maximize Total Profit P = 6W + 10B + 9H + 20W

Total Molding time required = 4W + 9B + 7H + 10C

Molding time available = 600 minutes

Hence, we get constraint as 4W + 9B + 7H + 10C <= 600

Similarly, we get other constraints as:

1W + 1B + 3H + 40C <= 400.........Constraint for availability of Packaging time

3W + 4B + 2H + 2.5C <=500..........Constraint for availability of Glass

Hence, we get formulation as show below:

Maximize Total Profit P = 6W + 10B + 9H + 20W

4W + 9B + 7H + 10C <= 600

1W + 1B + 3H + 40C <= 400

3W + 4B + 2H + 2.5C <=500

W, B, H, C >= 0.........................Non-negativity constraints as No. of glasses cannot be negative.

_______________________________________________________________________________________

In case of any doubt, please ask through the comment section before Upvote/downvote.


Related Solutions

solve the following LP. Formulate and algebraically solve the problem. what is the new optimal z...
solve the following LP. Formulate and algebraically solve the problem. what is the new optimal z value show that the current basis is optimal max z=65x1+25x2+20x3 8x1+6x2+x3<=48 4x1+2x2+1.5x3<=20 2x1+1.5x2+0.5x3<=8 x2<=5 x1,x2,x3>=0
solve the following LP. Formulate and algebraically solve the problem. Show all steps. what is the...
solve the following LP. Formulate and algebraically solve the problem. Show all steps. what is the new optimal z value max z=65x1+35x2+20x3 8x1+6x2+x3<=48 4x1+2x2+1.5x3<=20 2x1+1x2+0.5x3<=8 x2<=5 x1,x2,x3>=0 interpret the meaning of the shadow prices
Required: Formulate and solve the LP Relaxation of the problem. Solve it graphically, and round down...
Required: Formulate and solve the LP Relaxation of the problem. Solve it graphically, and round down to find a feasible solution. Explain/show what excel parameters and cells should be entered into the excel to come up with the answer. Consider the following all-integer linear program: ??? 10?1 + 3?2 ?.?. 6?1 + 7?2 ≤ 40 3?1 + 1?2 ≤ 11 ?1,?2 ≥ 0 and integer
Wine Glass Inc. produces and sells wine glasses. Per the Standards, for the months of May,...
Wine Glass Inc. produces and sells wine glasses. Per the Standards, for the months of May, each wine glass takes 2 pounds of material at $2.50 per pound. For the Month of May, Wine Glass Inc. planned on producing and selling 200 wine glasses. They actually produced and sold 210 wine glasses, using 525 pounds of material costing $1,181.25 in actual total cost. What is the Materials Activity Variance for the Month of May: What is the Materials Spending Variance...
The neoclassical theory of consumption can be summarized as individuals having “Champagne tastes on beer budget”....
The neoclassical theory of consumption can be summarized as individuals having “Champagne tastes on beer budget”. Explain what this quote means in terms of preferences and budget constraints. How does this quote help us understand the neoclassical theory of how individuals make consumption choices?
Formulate the following problem. DO NOT SOLVE. The Lifang Wu Corporation manufactures two models of industrial...
Formulate the following problem. DO NOT SOLVE. The Lifang Wu Corporation manufactures two models of industrial robots, the Alpha 1 and the Beta 2. The firm employs 5 technicians, working 160 hours each per month, on its assembly line. Management insists that full employment (that is, all 160 hours of time) be maintained for each worker during next month’s operations. It requires 20 labor-hours to assemble each Alpha 1 robot and 25 labor-hours to assemble each Beta 2 model. Wu...
Consider the market for red wine. Medical research suggests that moderate red wine consumption (1-2 glasses...
Consider the market for red wine. Medical research suggests that moderate red wine consumption (1-2 glasses per day) reduces the risk of heart problems. Use our market and firm diagrams to trace out both the short run and the long run implications of this news on the market for red wine. Write a few sentences of analysis to go along with the graphs.
1. why is wine and beer complementary goods? explain. 2. is spirit and wine complementary goods...
1. why is wine and beer complementary goods? explain. 2. is spirit and wine complementary goods or substitutes? explain
Sandhill Bottle Shop has two divisions, Wine and Beer. The sales mix is 70% Wine and...
Sandhill Bottle Shop has two divisions, Wine and Beer. The sales mix is 70% Wine and 30% Beer. Sandhill’s annual fixed costs are estimated at $342000. The average selling price in the Wine division is $45 with a variable cost of $18. The average selling price in the Beer division is $18 with a variable cost of $9. What is Sandhill’s sales revenue at the break-even point? a. $194940 b. $600000 c. $942000 d. $342000
Consider the following transportation problem. Formulate this problem as a linear programming model and solve it...
Consider the following transportation problem. Formulate this problem as a linear programming model and solve it using the MS Excel Solver tool. Shipment Costs ($), Supply, and Demand: Destinations Sources 1 2 3 Supply A 6 9 100 130 B 12 3 5 70 C 4 8 11 100 Demand 80 110 60 (4 points) Volume Shipped from Source A __________ (4 points) Volume Shipped from Source B __________ (4 points) Volume Shipped from Source C __________ (3 points) Minimum...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT