• Which cells contain the decision variable quantities? • Which cells contain the unit costs for each decision variable? • Which cells contain the constraints? • Which cells contain the objective value? • Is (Activity 1 = 25, Activity 2 = 50, and Activity 3 = 15) a feasible solution? B D Activity 2 $40 A ctivity 3 $30 1 Unit Profit Activ ity 1 $20 Resource Available Totals 400 100 200 4 Resource Used per Unit Produced 1 400 100 200 6. 1 1 1 7 1 2 8. Activity 2 50 Activity 1 50 A ctivity 3 Total Cost 10 Units Produced $3,000 4,

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Question in the attached screenshot, please and thank you!

### Transcription and Explanation for Educational Use

#### Questions:
- Which cells contain the decision variable quantities?
- Which cells contain the unit costs for each decision variable?
- Which cells contain the constraints?
- Which cells contain the objective value?
- Is (Activity 1 = 25, Activity 2 = 50, and Activity 3 = 15) a feasible solution?

#### Table Overview:

**Header Row:** 
- Columns B, C, and D list three activities: Activity 1, Activity 2, and Activity 3.

**Unit Profit Row:**
- Row 2 lists the unit profits for each activity:
  - Activity 1: $20 (Cell B2) 
  - Activity 2: $40 (Cell C2)
  - Activity 3: $30 (Cell D2)

**Resource Usage:**
- Rows 5 to 7 detail resources used per unit produced:
  - Resource 1: (Activity 1: 3, Activity 2: 5, Activity 3: 4)
  - Resource 2: (Activity 1: 1, Activity 2: 1, Activity 3: 1)
  - Resource 3: (Activity 1: 3, Activity 2: 3, Activity 3: 2)

**Constraints:**
- Column E lists total resource usage:
  - Row 5 to 7 show totals for resources (e.g., 400 for Resource 1).

- Column G lists available resources:
  - Resource 1: 400 units (Row 5)
  - Resource 2: 100 units (Row 6)
  - Resource 3: 200 units (Row 7)

**Units Produced:**
- Row 10 lists decision variable quantities:
  - Activity 1: 50 units (Cell B10)
  - Activity 2: 50 units (Cell C10)
  - Activity 3: 0 units (Cell D10)

**Objective Value (Total Cost):**
- Cell G10 shows the objective value as Total Cost: $3,000

#### Analysis:
- **Decision Variables:** 
  - Found in Cells B10, C10, D10
- **Unit Costs:** 
  - Cells B2, C2, D2
- **Constraints:** 
  - Constraints are in Column E (Cells E5 to E7)
- **
Transcribed Image Text:### Transcription and Explanation for Educational Use #### Questions: - Which cells contain the decision variable quantities? - Which cells contain the unit costs for each decision variable? - Which cells contain the constraints? - Which cells contain the objective value? - Is (Activity 1 = 25, Activity 2 = 50, and Activity 3 = 15) a feasible solution? #### Table Overview: **Header Row:** - Columns B, C, and D list three activities: Activity 1, Activity 2, and Activity 3. **Unit Profit Row:** - Row 2 lists the unit profits for each activity: - Activity 1: $20 (Cell B2) - Activity 2: $40 (Cell C2) - Activity 3: $30 (Cell D2) **Resource Usage:** - Rows 5 to 7 detail resources used per unit produced: - Resource 1: (Activity 1: 3, Activity 2: 5, Activity 3: 4) - Resource 2: (Activity 1: 1, Activity 2: 1, Activity 3: 1) - Resource 3: (Activity 1: 3, Activity 2: 3, Activity 3: 2) **Constraints:** - Column E lists total resource usage: - Row 5 to 7 show totals for resources (e.g., 400 for Resource 1). - Column G lists available resources: - Resource 1: 400 units (Row 5) - Resource 2: 100 units (Row 6) - Resource 3: 200 units (Row 7) **Units Produced:** - Row 10 lists decision variable quantities: - Activity 1: 50 units (Cell B10) - Activity 2: 50 units (Cell C10) - Activity 3: 0 units (Cell D10) **Objective Value (Total Cost):** - Cell G10 shows the objective value as Total Cost: $3,000 #### Analysis: - **Decision Variables:** - Found in Cells B10, C10, D10 - **Unit Costs:** - Cells B2, C2, D2 - **Constraints:** - Constraints are in Column E (Cells E5 to E7) - **
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.