Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Does anyone know the answer, I cant figure it out. Excel's Solver tool has been used in the spreadsheet below to solve a finear programming

Does anyone know the answer, I cant figure it out.
image text in transcribed
image text in transcribed
Excel's Solver tool has been used in the spreadsheet below to solve a finear programming problem with a mimization objective function and all z constraints. \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & & C & D & E & F \\ \hline 1 & Input Section & & & & & \\ \hline 2 & & \multicolumn{2}{|c|}{ Objective Function Coefficients } & & & \\ \hline 3 & & x & Y & & & \\ \hline 4 & & 8 & 7 & & & \\ \hline 5 & & & & & & \\ \hline 6 & & Constraints & & & Avail. & \\ \hline 7 & & 01 & 4 & 3 & 61 & \\ \hline & & *2 & 2 & 5 & 45 & \\ \hline 5 & & 43 & 9 & a & 145 & \\ \hline 10 & & & & & & \\ \hline 11 & Output Section & & & & & \\ \hline 12 & & & & & & \\ \hline 13 & & Variables & 106 & 62 & & \\ \hline 14. & & Profit & 648 & 434 & 1212 & \\ \hline 15 & & & & & & \\ \hline 16 & & Constraint & Usage & Siack & & \\ \hline 17 & & 1 & 61 & 0 & & \\ \hline 18 & & \#2 & 522 & -32 & & \\ \hline 19 & & #3 & 145 & 0 & & \\ \hline 20 & & & & & & \\ \hline \end{tabular} (a) Give the original linear programming problem. (Write your answer without slack or surplus variables.) Min s.t. Constraint \#1 Min s.t. Constraint \#1 Constraint #2 Constraint 23 x,y0 (b) What are the optimal values of X and Y given in the spreadsheet above. x=Y= What is the maximum value

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

Step: 3

blur-text-image

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

Management Information Systems Managing the Digital Firm

Authors: Kenneth C. Laudon, Jane P. Laudon, Mary Elizabeth Brabston

7th Canadian edition

133156842, 9780133577099 , 978-0133156843

More Books

Students also viewed these General Management questions