• 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,
• 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...
Related questions
Question
Question in the attached screenshot, please and thank you!

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.