Bangs Leisure Chairs Linear solution Sling Chair: Adirondack Hammocks O 22,5806452 1,61290323 Data Product Quantity Produce Hours/unit Sling ChairsAdirondack Hammocks Limitation (hours) 0,5 0,75 Cutting Assembling Finishing Profit/unit 2 0,4 50 Total 2 3 50 Profit Contributio $2.403,23 1 1 1 50 $40,00 $100,00 $90,00 $3,23 Rounding would not yield the optimal integer solution. Profit decreased b Hours/month 120 Model Quantity Produced Cutting Assembling Finishing Sling ChairsAdirondack Hammocks 24,00 48,00 48,00 24,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 Hours Used 48,00 48,00 24,00 120,00 Total Total Profit Contribution $0,00 $2.400,00 $0,00 $2.400,00

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

3. How to get data results like the following (non-linear optimization integer analysis) 

Please solve fast and solve u can get  max 60 minutes and can send. Please no reject thank u

Bangs Leisure Chairs
Linear solution
Data
Sling Chair: Adirondack Hammocks
O 22,5806452 1,61290323
Product
Quantity Produce
Hours/unit
Cutting
Assembling
Finishing
Sling ChairsAdirondack Hammocks Limitation (hours)
0,5
0,75
2
0,4
50
Total
2
3
50
Profit Contributio $2.403,23
1
1
1
50
$40,00
$100,00
$90,00
$3,23
Rounding would not yield the optimal integer solution.
Profitlunit
Profit decreased b
Hours/month
120
Model
Quantity Produced
Cutting
Assembling
Finishing
Sling ChairsAdirondack Hammocks
24,00
48,00
48,00
24,00
Hours Used
0,00
0,00
0,00
0,00
0,00
0,00
0,00
0,00
48,00
48,00
24,00
120,00
Total
Total
Profit Contribution
$0,00 $2.400,00
$0,00
$2.400,00
Transcribed Image Text:Bangs Leisure Chairs Linear solution Data Sling Chair: Adirondack Hammocks O 22,5806452 1,61290323 Product Quantity Produce Hours/unit Cutting Assembling Finishing Sling ChairsAdirondack Hammocks Limitation (hours) 0,5 0,75 2 0,4 50 Total 2 3 50 Profit Contributio $2.403,23 1 1 1 50 $40,00 $100,00 $90,00 $3,23 Rounding would not yield the optimal integer solution. Profitlunit Profit decreased b Hours/month 120 Model Quantity Produced Cutting Assembling Finishing Sling ChairsAdirondack Hammocks 24,00 48,00 48,00 24,00 Hours Used 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 48,00 48,00 24,00 120,00 Total Total Profit Contribution $0,00 $2.400,00 $0,00 $2.400,00
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

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.