Question: Source 1 2 Supply 1 5 6 100 2 4 2 200 3 3 6 150 4 9 7 50 Demand 250 250 Find the

Source	1	2	Supply
1	5	6	100
2	4	2	200
3	3	6	150
4	9	7	50
Demand	250	250

Find the solution to this problem using QM or Excel. Set up a table and show how many units from each source should be shipped to demand to minimize total cost. What is total cost? How many supply-side and demand-side constraints are there?And list all constraints. If the optimal solution includes x11=100 x22=200 determine the remaining shipments that will result in a minimum cost of $1700.

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 Mathematics Questions!

Solve Problem 1 with MS EXCEL as Quadratic Assignment Problem Six cells(20' x 20') are to be located in a 2 x 3 (rectangular) facility, as shown in the figure 1 below. The material flow matrix is...

Problem 1: A company operates trucks that sell food. There are 100 trucks in total. There are eight routes that can be used, each starting at s and ending at t. To each route, a certain per-truck...

Given the data provided for product structure, component AC101, and the planned orders of parent AB500 below, use the matrix for AC101 at the bottom to compute gross requirements, projected on hand,...

IIT Madras - CSE Department - CS5800 ADSA - 2021 Instructions 1. Even if one of the following items below is not followed, your answer sheet may not be evaluated 2. On the first page write your name...

Dear Dr Fids, Can you please help these questions? It is about MBS cash flow. R Generating MBS cash flows can be messy so we are going to write some functions in R that allows us to generate the cash...

I need assistance with all problems attached except 4.1 Can you assist? Case Problem 4.1 Coates's Decision On January 1, 2017, Dave Coates, a 23-year-old mathematics teacher at Xavier High School,...

Over the past decade or so, several economic trends have accelerated, affecting the Canadian economy. The 2008-09 global financial crisis and the COVID-19 pandemic have had significant impacts on the...

10 350 Shown below is a partially completed MPS record for ball bearings. a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not...

You are a member of the investment committee for a large manufacturing company that two years ago licensed a new technology from a small start-up firm. Based largely on that technology, engineers in...

Question 1 Merlion Holiday Pte Ltd (Merlion Holiday) is an outbound tour agency that focuses on tours in the United States, Europe and Australia. Business had been good in the last 5 years until the...

How does user specify block to be fetched in direct access?

The working stresses for the circular bar AB are = 120 MPa and Tw MPa. Determine the smallest radius of the bar that can carry the 2-kN load. Neglect the stress due to the transverse shear force.

Management of March and Carla Vista lic. has estimated that the firm's new TV dinner propect must generate $ 1 1 3 0 0 in FCF during each of the next six years to have an NPV of $ 0 . Management...

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.