1. 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 srunmarized in the following table. Maximum Assembly Inspection Computer Profit per demand for Wiring Hours Hours Hours Model Model ($) product Required Required Required A 30 80 .4 .5 .2 B 40 90 .5 .4 .3 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. Byte Computer Company Number to make: Total Profit: Unit prot: Constraints: Available Wiring Assembly Inspection 'A' Demand 'B' Demand 0 H NH - E El El - 1. What formula should be entered in cell E5 to compute total profit? a. :B4*C4+B5*C5 b. :SUNIPRODUCT(B4:C4,B5:C5) c. =SUM(B5:C5) d. =SUM(E8:E10)