LinearProgramming1_solved (2)

xlsx

School

Northeastern University *

*We aren’t endorsed by this school

Course

6215

Subject

Business

Date

Apr 3, 2024

Type

xlsx

Pages

7

Uploaded by AgentMorningOwl40

Report
Modeling for Business Analytics Acadia Coffee Roasters Daybreak (x) Early Bird (y) Pounds to produce Constraints Used Guatemalan beans ≤ Costa Rican beans ≤ Mexican beans ≤ Total Profit Profit Objectiv enter fo function to the d objectiv Decision variables (C6:D6) leave these cells blank; Exc solve for the optimal value
Available ve function cell (E14): ormula for the profit n using cell references decision variables and ve function coefficients ): cel will es Constraint formula cells (E9:E11): enter formulas that represent the lefthand side of each constraint (using cell references to decision variables); often use SUMPRODUCT function Constraint RHS cells (G9:G11): enter the numerical values that appears on the righthand side of the constraint expressions, after moving all variables to the left
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Modeling for Business Analytics Acadia Coffee Roasters Daybreak (x) Early Bird (y) Pounds to produce 89.80 306.12 Constraints Used Guatemalan beans 0.7 0.35 170 ≤ Costa Rican beans 0.3 0.5 180 ≤ Mexican beans 0 0.15 45.9183673469 ≤ Total Profit Profit 5.25 6.5 $2,461.22
Available 170 180 50
Microsoft Excel 16.70 Sensitivity Report Worksheet: [LinearProgramming1_solved.xlsx]Coffee Solved Report Created: 2/27/23 2:29:09 PM Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $C$6 Pounds to produce Daybreak (x) 89.795918367 0 5.25 7.75 $D$6 Pounds to produce Early Bird (y) 306.12244898 0 6.5 2.25 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $E$9 Guatemalan beans Used 170 2.7551020408 170 250 $E$10 Costa Rican beans Used 180 11.071428571 180 9.5238095238 $E$11 Mexican beans Used 45.918367347 0 50 1E+030
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Allowable Decrease 1.35 3.875 Allowable Decrease 22.222222222 107.14285714 4.0816326531

Related Documents

Marketing Management assignment #4 bm350-1.docx
STARBUCKS VS TIM HORTONS.docx
EDLD_5301_Week02_Assignment.doc
Consulting Report CSR Role Model - Sample Template1.docx
EDLD_5301_Week03_Assignment.doc
ch10 Homework.xlsx
HW#5-1.dotx
Functional Analysis Graphing Assignment.docx
White Paper copy.pdf
Henkel Iberica Report.docx
CSR344 Exercise 7 KNIGHT ENGINES Reflection.docx
CSR344 Exercise 15 Island Cruise Plan.docx
Recommended textbooks for you
Text book image
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Text book image
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Text book image
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Text book image
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
Text book image
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Text book image
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Text book image
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Text book image
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Text book image
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
Text book image
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Text book image
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS