Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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 400

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Methods For Business

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

11th Edition

978-0324651812, 324651813, 978-0324651751

More Books

Students also viewed these General Management questions