Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this question is about a manufacturer produces two types of machines x1 and x2 For this solution I already solve it with excel .Can you
this question is about a manufacturer produces two types of machines x1 and x2
For this solution I already solve it with excel .Can you please interpret the (4)report shown from the excel below with at least a page
Example1015, limits Report 1, sensitivity report 1,
Answer report 1.
K A B D E F G H Microsoft Excel 16.0 Limits Report Worksheet: [SolverData.xIsx]Example1015 Report Created: 7/8/2023 8:35:00 PM Objective Cell Name Value $B$2 Objective Cell 1360 Variable Lower Objective Upper Objective Cell Name Value Limit Result Limit Result $B$4 Decision Variables 24 0 400 24 1360 $C$4 Decision Variables 8 0 960 8 1360 32 33 Answer Report 1 Sensitivity Report 1 Ready Limits Report 1 Accessibility: Good to go Example1015Objective Cell 90 X1, X2 >=0 Decision Variables 1 Machine X1 X2 Total Labor hrs/unit 10 20 30 400 Capital ($/unit) 40 30 70 1200 Profit ($) 40 50 90B D F G I A C E Microsoft Excel 16.0 Sensitivity Report Worksheet: [SolverData.xIsx]Example1015 Report Created: 7/8/2023 8:35:00 PM Variable Cells Final Reduced Objective Allowable Allowable. Cell Name Value Cost Coefficient Increase Decrease $B$4 Decision Variables 24 0 40 26.66666667 15 $C$4 Decision Variables 8 0 50 30 20 O 12 Constraints W Final Shadow Constraint Allowable Allowable 14 Cell Name Value Price R.H. Side Increase Decrease 15 $D$7 Labor hrs/unit Total 400 1.6 400 400 100 16 SD$8 Capital ($/unit) Total 1200 0.6 1200 400 600 17 18 19 20 31 32 33 Answer Report 1 Sensitivity Report 1 Ready Limits Report 1 Example1015 Accessibility: Good to goA B C D E F G H Microsoft Excel 16.0 Answer Report Worksheet: [SolverData.xIsx]Example1015 Report Created: 7/8/2023 8:35:00 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.015 Seconds. Iterations: 2 Subproblems: 0 9 Solver Options 10 Max Time Unlimited, Iterations Unlimited, Precision 0.000001 11 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative 12 13 14 Objective Cell (Max) 15 Cell Name Original Value Final Value 16 $B$2 Objective Cell 1360 1360 17 18 19 Variable Cells 20 Cell Name Original Value Final Value Integer 21 $B$4 Decision Variables 24 24 Contin 22 $C$4 Decision Variables 8 8 Contin 23 24 25 Constraints 26 Cell Name Cell Value Formula Status Slack 27 $D$7 Labor hrs/unit Total 400 $D$7=0 Decision Variables 24 8 Machine X1 X2 Total Labor hrs/unit 10 20 400Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started