A Company Is Developing Its Weekly Production Plan

question 12

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)

---

Definitions:

Lessons

Educational content and experiences designed to teach specific knowledge or skills.

Population

The complete set of individuals, items, or data from which a statistical sample is drawn for analysis.

Occurrences

Instances or events of something happening or being present.

Characteristics

Distinctive qualities or features that identify and differentiate individuals, groups, or things.