5. Which of the following statements will represent the constraint for just assembly hours? a. B4:C4 s B5:CS b. D9 S E9 C. D8:D10 s E8:E10 d. E8:E10 s D8:D10(continued from above] 2. What formula should be entered in cell DB to compute the amount of wiring used? a. =B4*B5+C4*CS b. =SUMPRODUCT(B8:CB,$B$4:$C$4) C. =SUM(B5:C5) d. =SUM(E8:E10) A solution to this question has been requested by another student. It will be ready shortly. 3. Which cells should be 'changing' cells (decision cells) in this problem? a. B4:C4 b. E5 C. D8:D10 d. E8:E10Record all answers on the exam, save, and upload as PDF. You may use the LP template attached and any of the class tools. The Byte Computer Company produces two models of computers, A and B. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly and inspection hours available in each month. The data for this problem is summarized in the following table. Maximum Assembly Inspection Computer Profit per demand for Wiring Hours Hours Hours Model Model (S) product Required Required Required A 30 4 40 90 Hours Available 50 50 22 Answer the multiple choice below using this spreadsheet model (below). You do not need to fill in any information on the sheet. Highlight your choice for each below. A B C D E Byte Computer Company 2 3 A B 4 Number to make: Total Profit: 5 Unit profit: 6 7 Constraints: Used Available Wiring 9 Assembly 10 Inspection 11 "A' Demand 12 "B' Demand