Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 . Solve the problem using the MS Excel Solver to find the optimal solution and optimal objective function value. (assume and are continuous

image text in transcribedimage text in transcribed

Question 1. Solve the problem using the MS Excel Solver to find the optimal solution and optimal objective function value. (assume and are continuous decision variables.)

Question 2. Identify binding and non-binding constraints. For each non-binding constraint, what is the value of the slack (or surplus)?

Submission requirement: Note: do NOT specify the decision variables as integer in the Solver.

Problem 2. (Product mix.) The Seasaw Company produces two principal product lines: a portable circular saw and a precision table saw. There are two crucial operations: fabrication and assembly. The amount of time needed to fabricate and assemble a saw is shown in the following table. Maximum market demand next year is 5500 saws per month for both products together. The average contribution to profits and overhead is $600 for each circular saw and $450 for each table saw. The fabrication and assembly departments have limited operation hours per month, given in the following table. Problem 2. Recall the "Product mix" in Homework \#1. The problem's formulation is provided as follows: Decision Variables: C is the number of Circular Saws to be produced; T is the number of Table Saws to be produced maxs.t.600C+450T3C+1T40001.5C+2.5T5000C+T5500C0,andT0 (fabrication time) (assembly time) (demand)

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

Management Fundamentals

Authors: Robert N. Lussier

9th Edition

154438419X, 978-1544384191

More Books

Students also viewed these General Management questions

Question

6. Identify characteristics of whiteness.

Answered: 1 week ago

Question

9. Explain the relationship between identity and communication.

Answered: 1 week ago