Question: QUESTIONS 10 - 12 are based on the spreadsheet below. D E A B 1 Cool Dorm Design 2 Beds Desks Total Profit: 30 40

QUESTIONS 10 - 12 are based on the spreadsheet below. D E A B 1 Cool Dorm Design 2 Beds Desks Total Profit: 30 40 3 4 Number to make: 5 Unit profit: 6 7 Constraints: 8 Carpentry 9 Varnishing 10 Desk demand Used Available 36 6 4 8 40 4 8 1 10. Using cell references, what EXCEL formula should be entered in cell D8 to compute the number of hours of carpentry used? a. =SUMPRODUCT(B8:C8 S E8) b. =SUMPRODUCT(B8:C8, E8) C. ESUMPRODUCT($B$4:$C$4,38:08) d. None of the above 11. Using cell references, what EXCEL formula should be entered in cell D9 to compute the number of hours of varnishing used? a. =SUMPRODUCT(B4:04,09:09) b. =SUMPRODUCT($B$4:$C$4,19:09) C. SUMPRODUCT(B4:04,$B$9:$C$9) d. None of the above 12. In Solver, the carpentry and varnishing constraints cell references will read as a. $D$8:$D$9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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...

A D E B Cool Dorm Design 1 2 Beds Desks Total Profit: 30 40 3 4 Number to make: 5 unit profit: 6 7 Constraints: 8 Carpentry 9 Varnishing 10 Desk demand Used Available 36 6 4 4 40 8 1 8 Using cell...

what is the answer 3-1? 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...

QUESTIONS 10-12 are based on the spreadsheet below. A B C D E 1 Cool Dorm Design 2 3 Beds Desks 4 Number to make: Total Profit: 5 Unit profit: 30 40 6 7 Constraints: Used Available 8 Carpentry 36 9...

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...

Please use the given instructions to complete the tables this is all the data Henkel Industries produces its product in two sequential departments: Blending and Forming. The old controller, who has...

VIEW E TOOLS PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Module 4 Assignment Record the transactions listed...

Step 1 You work for Thunderduck Custom Tables Inc. This is the first month of operations. The company designs and manufactures specialty tables. Each table is specially customized for the customer....

Please show steps to get the information to answer the questions. Perform the following five descriptive analytics to help Management understand the business environment. Management is requested a...

use the total sales revenue from the budget tab to calculate the product cost method for questions 1&2 goes based on the budget chart D E G H We want to make sure we are charging the right amount for...

In the k server Erlang loss model, suppose that A 1 and E(S) = 4. Find L if Tk = 0.2.

The distance a vehicle travels can be calculated as follows: distance = speed * time For example, if a train travels 40 miles per hour for three hours, the distance traveled is 120 miles. Write a...

Problem 1 3 - 9 Spreadsheet Problem: Payback ( LG 1 3 - 2 ) Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of retum on projects of...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...