dolution
dolution.
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 |
What is the appropriate formula to use in cell E8 of the following Excel implementation of the ILP model for this problem?
A | B | C | D | E | |
1 | Fixed charge problem | ||||
2 | |||||
3 | |||||
4 | Product A | Product B | |||
5 | Number to produce | ||||
6 | |||||
7 | Unit profit | 17 | 21 | Total profit: | |
8 | Fixed cost | 60 | 80 | ||
9 | |||||
10 | Resources | Hours required | Used | Available | |
11 | Cutting | 3 | 4 | 48 | |
12 | Welding | 2 | 1 | 36 | |
13 | |||||
14 | Binary variables | ||||
15 | Linking constraints |
Which answer is correct?
-
=SUMPRODUCT(B5:C5,B7:C7) – SUMPRODUCT(B8:C8,B14:C14)
-
=SUMPRODUCT(B5:C5,B7:C7) – SUMPRODUCT(B8:C8,B15:C15)
-
=SUMPRODUCT(B8:C8,B14:C14) – SUMPRODUCT(B5:C5,B7:C7)
-
=SUMPRODUCT(B5:C5,B7:C7) – B8:C8
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
