Question: Solve the integer programming model formulated in question4 by using Excel. 4. A manufacturer can sell product 1 at a profit of $2/unit and product

Solve the integer programming model formulated in question4 by using Excel.

4. A manufacturer can sell product 1 at a profit of $2/unit and product 2 at a profit of $5/unit. Three units of raw material are needed to manufacture 1 unit of product 1, and 6 units of raw material are needed to manufacture 1 unit of product 2. A total of 120 units of raw material are available. If any of product 1 is produced, a setup cost of $10 is incurred, and if any of product 2 is produced, a setup cost of $20 is incurred. Formlate an IP to maximize 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!

Solve the integer programming model formulated in Question 4 using Excel. 4. A manufacturer can sell product 1 at a profit of $2/unit and product 2 at a profit of $5/unit. Three units of raw material...

solve by using excel. 4. A manufacturer can sell product 1 at a profit of $2/unit and product 2 at a profit of $5/unit. Three units of raw material are needed to manufacture 1 unit of product 1, and...

2. Solve the integer programming model formulated in Question 4 of Problem set 8 document located in itslearning by using Excel. You can see the required IP model in the relevant solution document as...

Please use the data below to answer Problem 10 on pages 351 to 352 in the textbook Problems 351 the capital requirements, and the available capital funds over the next three years are sum; marized as...

MAT540 Homework Week 3 Page 1 of 3 MAT540 Week 3 Homework Chapter 14 1. The Hoylake Rescue Squad receives an emergency call every 1, 2, 3, 4, 5, or 6 hours, according to the following probability...

Include the excel file you generated (answer report, excel model) Include the excel file you generated (answer report, excel model) Include the excel file you generated (answer report, excel model)...

Based on Enclosure A and Enclosure B, we would like to know the optimal production quantity for each product (SC-A, SC-B, SC-C, SC-D, S-10, S-20, S- 30, S-40). The goal is to maximize the total...

20. The Terraco Motor Company has produced a lightweight, all-terrain vehicle code-named "399 Terra" for the military. The company is now planning to sell the Terra to the public. It has five plants...

1: Directions: 1) Read the entire selection below 2) Answer the questionssee additional notes below.... Selection: Bradley's Food Stand John Bradley is a senior at Tech, and he's investigating...

Machine Tool Production Planning. King City Inc. manufactures machine tools. The production Machine Tool Production Planning. King City Inc. manufactures machine tools. The production planner who...

The above exhibits present the recent income statement and balance sheet of NBC Corporation. In general, the cash needed for NBC's operations is about 3 percent of revenue. Revenues in 2014 = $967...

Q4. Show that each of the following function f is continuous at the given point (15) f(z) = z- 3Re(z) + i; zo = 3 2i. Re(z) f(z) = z + iz in 2z23; Zo = e7. %3D

Which one of these statements is FALSE about variance analysis? The primary goal of variance analysis is to assign blame for unfavorable results Variance analysis helps managers identify the factors...

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...