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. 
What is the appropriate formula to use in cell E8 of the following Excel implementation of the ILP model for this problem? 
A) =SUMPRODUCT(B5:C5,B7:C7) − SUMPRODUCT(B8:C8,B14:C14)
B) =SUMPRODUCT(B8:C8,B14:C14) − SUMPRODUCT(B5:C5,B7:C7)
C) =SUMPRODUCT(B5:C5,B7:C7) − B8:C8
D) =SUMPRODUCT(B5:C5,B7:C7) − SUMPRODUCT(B8:C8,B15:C15)
Correct Answer:
Verified
Q64: An investor has $500,000 to invest and
Q65: A city wants to locate 2 new
Q66: A company wants to build a new
Q67: Variables, which are not required to assume
Q68: A company wants to select no more
Q70: A company needs to hire workers to
Q71: A company will be able to obtain
Q72: Mixed IP formulation requires that:
A) all decision
Q73: A small town wants to build some
Q74: An investor has $500,000 to invest and
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents