Business, 22.02.2021 19:40 arielgonzalez809

A company is developing its weekly production plan. The company produces two products, A and B, which are processed in two departments. Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80. Each unit of A generates a profit of $17 while a unit of B earns a profit of $21. The company can sell all the units it produces. The data for the problem are summarized below. Hours required by
Operation A B Hours
Cutting 3 4 48
Welding 2 1 36
The decision variables are defined as:
xi = the amount of product i produced
yi = 1 if xi > 0 and 0 if xi = 0
A spreadsheet implementation of the problem is shown below.
Q1. What is the objective function for this problem?
a. Maximize: 17x1 + 21x2 - 60y1 - 80y2
b. Minimize: 60y1 + 80y2
c. Minimize: 17x1 + 21x2 - 60y1 - 80y2
d. d. Maximize: 17x1 + 21x2
Q2. What is the appropriate formula to use in cell E8 of the Excel implementation of the ILP model for this problem?
a. =SUMPRODUCT(B8:C8,B14:C14) - SUMPRODUCT(B5:C5,B7:C7)
b. =SUMPRODUCT(B5:C5,B7:C7) - SUMPRODUCT(B8:C8,B14:C14)
c. =SUMPRODUCT(B5:C5,B7:C7) - SUMPRODUCT(B8:C8,B15:C15)
d. =SUMPRODUCT(B5:C5,B7:C7) - B8:C8
Q3. Which of the following algebraic constraints creates the link between setting up to produce A's and making some A's for this problem?
a. x1 - 18 y1 > 0
b. x1 - y1 = 0
c. = if(x1 > 0, y1 = 1, y1 = 0)
d. x1 < 16y1

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 13:50

Ateam of engineers has decided to design a new shoe for people suffering from a painful foot condition. what should the engineers do during the planning stage of their project? a. look at the trial's results to see how the design can be improved. b. build a variety of shoe models. c. have patients wear the new shoe in an experimental trial to see if symptoms improve. d. estimate how much potential consumers would be willing to pay for this new shoe.

Answers: 1

Answer

Business, 22.06.2019 08:10

Bakery has bought 250 pounds of muffin dough. they want to make waffles or muffins in half-dozen packs out of it. half a dozen of muffins requires 1 lb of dough and a pack of waffles uses 3/4 lb of dough. it take bakers 6 minutes to make a half-dozen of waffles and 3 minutes to make a half-dozen of muffins. their profit will be $1.50 on each pack of waffles and $2.00 on each pack of muffins. how many of each should they make to maximize profit, if they have just 20 hours to do everything?

Answers: 3

Answer

Business, 22.06.2019 11:00

What is the advantage of developing criteria for assessing the effectiveness of business products and processes? a. assessment criteria are answers. b.assessment criteria are inexpensive. c.assessment criteria provide you with a list of relevant things to measure. d.assessment criteria provide you with a list of people to contact to learn more about process mentoring.

Answers: 3

Answer

Business, 22.06.2019 21:50

Abus pass costs $5 per week. which of the following equations shows the total cost in dollars, t, of the bus pass for a certain number of weeks, w? t = 5w w = 5t t = 5 + w w = 5 + t

Answers: 3

Answer

You know the right answer?

A company is developing its weekly production plan. The company produces two products, A and B, whic...

Questions