Solved

Exhibit 3.1 The Following Questions Are Based on This Problem and Accompanying

Question 36

Multiple Choice

Exhibit 3.1
The following questions are based on this problem and accompanying Excel windows.
Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced. Exhibit 3.1 The following questions are based on this problem and accompanying Excel windows. Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced. The LP model for the problem is -Refer to Exhibit 3.1. What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of carpentry used? A) =B4*B5+C4*C5 B) =SUMPRODUCT(B8:C8,$B$4:$C$4) C) =SUM(B5:C5) D) =SUM(E8:E10) The LP model for the problem is Exhibit 3.1 The following questions are based on this problem and accompanying Excel windows. Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced. The LP model for the problem is -Refer to Exhibit 3.1. What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of carpentry used? A) =B4*B5+C4*C5 B) =SUMPRODUCT(B8:C8,$B$4:$C$4) C) =SUM(B5:C5) D) =SUM(E8:E10) Exhibit 3.1 The following questions are based on this problem and accompanying Excel windows. Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced. The LP model for the problem is -Refer to Exhibit 3.1. What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of carpentry used? A) =B4*B5+C4*C5 B) =SUMPRODUCT(B8:C8,$B$4:$C$4) C) =SUM(B5:C5) D) =SUM(E8:E10)
-Refer to Exhibit 3.1. What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of carpentry used?


A) =B4*B5+C4*C5
B) =SUMPRODUCT(B8:C8,$B$4:$C$4)
C) =SUM(B5:C5)
D) =SUM(E8:E10)

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q31: Exhibit 3.1
The following questions are based on

Q32: How many decision variables are there in

Q33: Exhibit 3.4
The following questions are based on

Q34: Which type of spreadsheet cell represents the

Q35: Scaling problems
A) can cause Analytic Solver Platform

Q37: Exhibit 3.2
The following questions are based on

Q38: What is the significance of an absolute

Q39: Exhibit 3.2
The following questions are based on

Q40: Exhibit 3.2
The following questions are based on

Q41: Which tab in the Analytic Solver Platform

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents