Exhibit 8.1
The following questions pertain to the problem and spreadsheet below.
A company makes products A and B from 2 resources, labor and material. The company wants to determine the selling price which will maximize profits. A unit of A costs 25 to make and demand is estimated to be 20 − .10 * Price of A. A unit of B costs 18 to make and demand is estimated to be 30 − .07 * Price of B. The utilization of labor and materials and the available quantity of resources is shown in the table. A reasonable price for the products is between 100 and 200. Let X 1 = demand for As and X 2 = demand for Bs.
Let P 1 = price for As and P 2 = price for Bs
-Refer to Exhibit 8.1. What formula is used in cell D12 of the spreadsheet for this problem?
A) =SUMPRODUCT(B3:C3, B12:C12)
B) =SUMPRODUCT(B4:C4, B12:C12)
C) =SUMPRODUCT(B5:C5, B12:C12)
D) =SUMPRODUCT(B7:C7, B12:C12)

Question

Exhibit 8.1
The following questions pertain to the problem and spreadsheet below.
A company makes products A and B from 2 resources, labor and material. The company wants to determine the selling price which will maximize profits. A unit of A costs 25 to make and demand is estimated to be 20 − .10 * Price of A. A unit of B costs 18 to make and demand is estimated to be 30 − .07 * Price of B. The utilization of labor and materials and the available quantity of resources is shown in the table. A reasonable price for the products is between 100 and 200.  Let X 1 = demand for As and X 2 = demand for Bs.
Let P 1 = price for As and P 2 = price for Bs 
-Refer to Exhibit 8.1. What formula is used in cell D12 of the spreadsheet for this problem?
A) =SUMPRODUCT(B3:C3, B12:C12) 
B) =SUMPRODUCT(B4:C4, B12:C12) 
C) =SUMPRODUCT(B5:C5, B12:C12) 
D) =SUMPRODUCT(B7:C7, B12:C12)

Quizplus · Accepted Answer

The Answer of Exhibit 8.1
The following questions pertain to the problem and spreadsheet below.
A company makes products A and B from 2 resources, labor and material. The company wants to determine the selling price which will maximize profits. A unit of A costs 25 to make and demand is estimated to be 20 − .10 * Price of A. A unit of B costs 18 to make and demand is estimated to be 30 − .07 * Price of B. The utilization of labor and materials and the available quantity of resources is shown in the table. A reasonable price for the products is between 100 and 200.  Let X 1 = demand for As and X 2 = demand for Bs.
Let P 1 = price for As and P 2 = price for Bs 
-Refer to Exhibit 8.1. What formula is used in cell D12 of the spreadsheet for this problem?
A) =SUMPRODUCT(B3:C3, B12:C12) 
B) =SUMPRODUCT(B4:C4, B12:C12) 
C) =SUMPRODUCT(B5:C5, B12:C12) 
D) =SUMPRODUCT(B7:C7, B12:C12)

Exhibit 8.1 The Following Questions Pertain to the Problem and Spreadsheet Below