Question: Set up in excel and find the optimal solution using Solver in Excel DEPARTMENT UNIT PROFIT PRODUCT WIRING DRILLING INSPECTION 3 XJ201 XM897 15 ASSEMBLY

Set up in excel and find the optimal solution using Solver in Excel

DEPARTMENT UNIT PROFIT PRODUCT WIRING DRILLING INSPECTION 3 XJ201 XM897 15 ASSEMBLY 2 4 .5 1.5 1 1.0 $ 9 $12 $15 $11 TR29 1.5 2 1 .5 BR788 1.0 3 2 .5 DEPARTMENT CAPACITY (HRS) PRODUCT MIN PRODUCTION LEVEL XJ201 150 XM897 100 Wiring Drilling Assembly Inspection 1,500 2,350 2,600 1,200 TR29 200 BR788 400 X1 = number of units of XJ201 produced X2 = number of units of XM897 produced X3 = number of units of TR29 produced X4 = number of units of BR788 produced Maximize profit = 9X, + 12X2 + 15X2 + 11X4 subject to + .5X, +1.5X, +1.5X2 +1X4 = 1,500 hours of wiring 3X, +1X2 +2X2 +3X4 5 2,350 hours of drilling 2X, +4X2 +1X2 +2X4 S 2,600 hours of assembly .5X, +1X, + .5X, +.5X, 150 units of XJ201 X, > 100 units of XM897 X2 > 200 units of TR29 X4 > 400 units of BR788 X1, X2,X3, X4 20

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!

ITM 501: Decision Analysis Homework Assignment 2 Instructions: - The assignment must be submitted through Blackboard. - Submit one spreadsheet file named according to the following format: _ #2.xls...

This assignment entails material on Linear Programming. Please work on the assignment individually. This is your opportunity to learn more about the material covered and get ready for the exam. You...

2 Binary mixed - integer linear program ( 7 0 points in total ) Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A , B , and C The per -...

Huse Soluer in excel to find the optimal sdutor Question LP Applications (1 of 8)A find the optimal solcetion, Production-Mix Example B. Briefly describe your solution. DEPARTMENT ASSEMBLY PRODUCT...

Check my work 1 A manufacturer has decided to locate a new factory in northwestern United States to serve growing demand in that market. They have narrowed the potential sites down to two finalists,...

Please provide detailed answers in an excel file, highlight answers and be as clear as you can. Many thanks!! The Global Plastic (GP) is a manufacturer of polyethylene plastic product around the...

Please provide a clear step by step solution. Thank you in advance!! The Global Plastic (GP) is a manufacturer of polyethylene plastic products around the U.S.. GP currently operates five...

C A. Draw the netwc x Chapter 7 Assign x {> Sample Problem ( X Zara Supplier LP / X Course Hero X C Post a new quest x C Zara stores in the X how to use corner x C...

Wagon trains in the 1800s took approximately 5 weeks to travel from Missouri to California. Although the direct distance is less, the actual mileage for the wagons was 2,000 miles. About what average...

Wade Company is doing significant work to revitalize its warehouses. It is not sure whether it should capitalize these costs or expense them. What are the implications for current-year net income and...

The circumference of a circular disc is 39 cm. Work out the diameter of the disc. Give your answer correct to the nearest millimetre. For questions, use the button on your calculator.

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...