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 as follows: The decision variables are defined as follows: Hours Required by B X = Amount of product i produced Y = 1 if X: > 0 and 0 if Xi = 0 A. Operation Cutting Welding What is the appropriate formula to use in cell E8 of the following Excel implementation of the ILP model for this problem? C. A 3 2 1 2 D. 5 Number to produce 6 8 9 10 11 12 13 Unit profit Fixed cost Resources Cutting Welding 4 1 14 Binary variables 15 Linking constraints B Product A 17 60 Hours 48 36 Hours required a Fixed charge problem Product B 21 80 =SUMPRODUCT(B5:C5_BZ.CZ) - SUMPRODUCT(B2:C8,B14-C14) Used SHMPRQRUSTB8:C8_B14-C14) - SUMERQDUST(B5:C5_B7-CZ =SUMPRQQUCT(B5:C5 B7:CZ) - B8:C8 =SUMPRQRUST(B5:C5 B7-CZ) - SHMPRQQUST(B8:C8_B15:C15) D E Total profit Available 48 36 ||

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 reguires $60 of labor, while setting up a batch of B costs $BD. Exch unit of A generates a profin of $17, while a unit of B earns a proEt of $21. The company can sell all the units it produces. The data for the problem are summarised as follows: The decision variables are defined as follows: XAmountofproductiproducedY1=1ifX>0and0ifX1=0 What is the appeopriate formula to use in cell ES of the following Excel implementation of the I.P model for this problem? A. c. D