Question: Your task is to set up the problem in Excel and then solve it. Your submission is a submission of the solved mode USING SOLVERl.

Your task is to set up the problem in Excel and then solve it. Your submission is a submission of the solved mode USING SOLVERl.

Our goal here is to MAXIMIZE our profit. We have two products Prod 1 and Prod 2. The profit for Prod 1 is $35 and the profit for Prod 2 is $50

Prod 1 uses 1.5 hours per unit in DeptA, 2 in DeptB and .25 in DeptC

Prod 2 uses 3 hours per unit in DeptA, 1 in DeptB and .25 in DeptC

Dept A can only provide up to 410 hours, Dept B 325 hours, and Dept C 50 hours.

You MUST make at least 80 Prod 1 and 40 Prod 2

What is the best solution to maximize your profits?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

So, using solver is an important skill for Excel in my mind. But, the trick in all this is setting up your model. So, what I have done is take a problem from my Operations Management course (which I...

Q:

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Q:

Reference: FOSSUM.. Labor Relations, 10th Edition. McGraw-Hill Learning Solutions, 2008. VitalBook file. Page 429Chapter Thirteen Union-Management Cooperation Many labor relations practices are...

Q:

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee. 1...

Q:

answer the following questions: What are your moral obligations as professionals to prevent such things from happening? What guidance do the professional codes provide (cite specific code sections in...

Q:

answer the following questions: What are your moral obligations as professionals to prevent such things from happening? What guidance do the professional codes provide (cite specific code sections in...

Q:

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

Q:

Please read the question Question: Give an example from your own history as a student in which you a teacher helped you make meaning and transer your learning. What was meaningful about the...

Q:

JOURNAL OF BUSINESS AND MANAGEMENT Vol. 4, No. 7, 2015: 830-843 MANAGING STOCK IN WAREHOUSE: A CASE STUDY OF A RETAIL INDUSTRY IN JAKARTA Yericho Paul and Yuliani Dwi Lestari School of Business and...

Q:

You are asked to solve the following Linear Programming (LP) problem. Objective: Maximize 1.50A +3.00B, Subject to the following constraints: -\(3\mathrm{~A}+2\mathrm{~B}\leq...

Q:

Differentiate (9s- 5 Fnd y dx and

Q:

On January 1, Boston Enterprises issues bonds that have a $2,200,000 par value, mature in 20 years, and pay 9% interest semiannually on June 30 and December 31. The bonds are sold at par.. 1. How...

Q:

4 . ( 1 1 points ) The asking price for the property is $ 1 . 0 0 0 , 0 0 0 ; rents are estimated at $ 2 0 0 , 0 0 0 during the first year and are expected to grow at 5 percent per year. Vacancies...

Q:

What is an example of constructive feedback? provide reference