Multiple Choice
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
Correct Answer:
Verified
Q8: How are general integrality requirements indicated in
Q11: <br>The following questions pertain to the
Q13: A cellular phone company wants to locate
Q16: A company is developing its weekly production
Q25: Exhibit 6.1<br>The following questions pertain to the
Q26: The setup cost incurred in preparing a
Q28: How is an LP problem changed into
Q59: Exhibit 6.1<br>The following questions pertain to the
Q95: Exhibit 6.2<br>The following questions pertain to the
Q96: A company will be able to obtain