HW_3-W10

# HW_3-W10 - BUS 104 Homework #3 Due Date: Tuesday, February...

This preview shows pages 1–4. Sign up to view the full content.

BUS 104 Homework #3 Due Date: Tuesday, February 16, 2010 Student Name (print): ______________________ Section #: ______________________

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Name: ________________________ Class: ___________________ Date: __________ ID: A 1 HW#3 S09 Multiple Choice (1 point for each question) Identify the choice that best completes the statement or answers the question. ____ 1. Which type of spreadsheet cell represents the decision variables in an LP model? a. Target or set cell b. Changing variable cell c. Constraint cell d. Constant cell ____ 2. The constraints X 1 0 and X 2 0 are referred to as a. positivity constraints. b. optimality conditions. c. left hand sides. d. nonnegativity conditions. ____ 3. Spreadsheet modeling is an acquired skill because a. there is generally only one correct way to build a model. b. the spreadsheet is free form providing many modeling options. c. using Solver requires lots of experience. d. spreadsheets are not very easy to use. ____ 4. Numeric constants should be a. embedded in formulas. b. placed in individual cells c. placed in separate workbooks. d. entered manually every time a model is solved. ____ 5. The Guess button on the Solver Parameters box a. returns a heuristic solution to the problem. b. returns a guess as to the decision variable cells. c. determines the Target cell based on specified decision variable cells. d. always works correctly. ____ 6. What command is used to add the contents of cells A1, A2 and A3? a. =A1+A2+A3 b. =ADD(A1:A3) c. =TOTAL(A1:A3) d. =PRODUCT(A1:A3) ____ 7. What is the significance of an absolute cell reference in Excel? a. The cell reference will not change if the formula containing the reference is copied to another location b. The cell will always contain the absolute value of any number entered into it c. The cell reference changes if the formula containing the reference is copied to another location d. It is the only formula used to refer to a cell on another spreadsheet ____ 8. How many decision variables are there in a transportation problem which has 5 supply points and 4 demand points? a. 4 b. 5 c. 9 d. 20
Name: ________________________ ID: A 2 Scenario 3-1 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

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## HW_3-W10 - BUS 104 Homework #3 Due Date: Tuesday, February...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online