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?
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now| 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!"
