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

Other questions on the subject: Business

Business, 22.06.2019 08:30, rajenkins79

Kiona co. set up a petty cash fund for payments of small amounts. the following transactions involving the petty cash fund occurred in may (the last month of the company's fiscal year). may 1 prepared a company check for $350 to establish the petty cash fund. 15 prepared a company check to replenish the fund for the following expenditures made since may 1. a. paid $109.20 for janitorial services. b. paid $89.15 for miscellaneous expenses. c. paid postage expenses of $60.90. d. paid $80.01 to the county gazette (the local newspaper) for an advertisement. e. counted $26.84 remaining in the petty cashbox. 16 prepared a company check for $200 to increase the fund to $550. 31 the petty cashier reports that $380.27 cash remains in the fund. a company check is drawn to replenish the fund for the following expenditures made since may 15. f. paid postage expenses of $59.10. g. reimbursed the office manager for business mileage, $47.05. h. paid $48.58 to deliver merchandise to a customer, terms fob destination. 31 the company decides that the may 16 increase in the fund was too large. it reduces the fund by $50, leaving a total of $500.

Answers: 1

continue

Business, 22.06.2019 11:00, neash19

Why does an organization prepare a balance sheet? a. to reveal what the organization owns and owes at a point in time b. to reveal how well the company utilizes its cash c. to calculate retained earnings for a given accounting period d. to calculate gross profit for a given accounting period

Answers: 3

continue

Business, 22.06.2019 11:50, Paytonsmommy09

Which of the following does not offer an opportunity for timely content? evergreen content news alerts content that suits seasonal consumption patterns content that matches a situational trigger content that addresses urgent pain points

Answers: 2

continue

Business, 22.06.2019 12:30, dtrdtrdtrdtrdrt1325

Suppose a holiday inn hotel has annual fixed costs applicable to its rooms of $1.2 million for its 300-room hotel, average daily room rents of $50, and average variable costs of $10 for each room rented. it operates 365 days per year. the amount of operating income on rooms, assuming an occupancy* rate of 80% for the year, that will be generated for the entire year is *occupancy = % of rooms rented

Answers: 1

continue

You know the right answer?

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