Or1hand written solution no to excel. Thank you AssignmentFind the initial solution of the given transportation problem using the 3 methods.Suppose a manufacturing company owns three factories (sources) and distribute hisproducts to five different retail agencies (destinations). The following table showsthe capacities of the three factories, the quantity of products required by the variousretail agencies and the cost of shipping one unit of the product from each of thethree factories to each of the five retail agencies.Factories1231 21 924 121433Requirement 100 60Retail Agency313161504 535 5020 123 2650 40Capacity50100150300

Transportation problem is a special kind of linear programming problem in which goods are…

Answered: Find the initial solution of the given…

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter2: Systems Of Linear Equations

Section2.4: Applications

Problem 23EQ: 23. Consider a simple economy with just two industries: farming and manufacturing. Farming consumes...

See similar textbooks

Similar questions

23. Consider a simple economy with just two industries: farming and manufacturing. Farming consumes 1/2 of the food and 1/3 of the manufactured goods. Manufacturing consumes 1/2 of the food and 2/3 of the manufactured goods. Assuming the economy is closed and in equilibrium, find the relative outputs of the farming and manufacturing industries.
From the data given compute the sales price for each product T and O. From the data given compute variable cost per unit for each product T and O. Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 50,000 units of each product. Sales and costs for each product follow.
Cars produces cars in Atlanta (5,000 cars), Boston (5,500 cars) and Chicago (4,000 cars). These cars are shipped to Memphis, Milwaukee, and N.Y. Demand is given as 6,000 in Memphis, 4,000 in Milwaukee and 4,000 in Chicago. The transportation costs for shipping a car from city i to city j are given below. To From Atlanta Boston Memphis 371 Milwaukee 761 N.Y. 861 206 1,296 530 1,050 87 Chicago 802 a) Formulate a balanced transportation problem that can be used to minimize Cars' transportation costs. b) Find a basic feasible solution to the problem.
A factory uses ingredients A, B, C, D and E to produce products I, II, III, IV, and V. The following table shows the amounts of each ingredient in stock (in kg) as well as the amount (in kg) necessary to produce 1 tonne (=1000 kg) of each type of product. How many tonnes of each type of ingredient should they make to use up all the ingredients completely? (Note: There may be other basic ingredients, such as water, that are not relevant in the equations.) Hint: Suppose they need to make x1 equation for each of the ingredients A, B, C etc. Solve this system of equations to find your answers. tonnes of product I, x2 tonnes of product II, etc. Then set up one Hoeveelheid in voorraad (kg) Amount in stock (kg) Soort Produk I II III IV V Type of product→ Ingredient A 27 114 21 9 2780.4 B 7.5 105 6 4.5 1929.3 C 12 11.2 6.4 4.8 616.64 D 25 20 50 25 2260 E 7 5 17 7 526.3
A farmer has recently acquired a 110 hectares piece of land. He has decided to grow Wheat and barley on that land. Due to the quality of the sun and the region's excellent climate, the entire production of Wheat and Barley can be sold. He wants to know how to plant each variety in the 110 hectares, given the costs, net profits and labor requirements according to the data shown below: Variety Cost (Price/Hec) Net Profit (Price/Hec) Man-days/Hec Wheat 100 50 10 Barley 200 120 30 The farmer has a budget of US$10,000 and an availability of 1,200 man-days during the planning horizon. In addition, the farmer would like to get a profit of at least $3000. Generate the mathematical model for the optimal usage of land area to produce wheat and barley. Using graphical method to optimize land usage, how many hectares are to be used for wheat and barley.
Cars are shipped from three distribution centres to five dealers. The shipping cost is based on the mileage between the sources and the destinations and is independent of whether the truck makes the trip with partial or full loads. Table Q1 summarizes the mileage between the distribution centres and the dealers together with the monthly supply and demand figures given in number of cars. A full truckload includes 18 cars. The transportation cost per truck mile is $25. Table Q1: The mileage between distribution centres Dealer Supply Centre Demand 12345 1 100 150 200 140 35 400 2 50 70 60 65 80 200 3 40 90 100 150 130 150 100 200 150 160 140 (a) Formulate the associated transportation model. (b) Determine the optimal shipping schedule.
A supplier for the automobile industry manufactures car and truck frames at two different plants. How many hours should each plant be scheduled to operate to exactly fill each of the orders in the right table? The production rates (in Frames per hour) for each plant are given in the left table. Plant A B Car Frames 2 3 Complete the table below. Number of hours for plant A Number of hours for plant B Truck Frames 4 7 1 Car frames Truck frames ... Orders 2 1 634 1454 3 Orders 2 751 1635 3 848 1846
There are three factories located at AR, IN, and TX respectively. From these locations, a certain commodity is to be delivered to each of the two warehouses situated at A and B. The revenue per commodity item is $10. The weekly demand of the warehouse A and B are respectively 50 and 35 units of the commodity while the production capacity of the factories at AR, IN, and TX are respectively 28, 22, and 35 units. The cost of transportation per unit is given as belows. Cost Warehouse A Warehouse B AR 5 3 IN 6 6 TX 2 4 To maintain a good relationship with all the factories, warehouse B requires that it receives at least 40% of its product from factory in TX. Realize that it is making good profit in warehouse A, AR requires that at least 35% of its product shipped to warehouse A. Formulate (without solving) a linear programming problem to maximize the profit.
A chemical manufacturing plant can produce z units of chemical Z given p units of chemical P and r units of chemical R, where: z = Units of chemical R, r = Chemical P costs $500 a unit and chemical R costs $4,500 a unit. The company wants to produce as many units of chemical Z as possible with a total budget of $843,750. p0.84 0.16 A) How many units each chemical (P and R) should be "purchased" to maximize production of chemical Z subject to the budgetary constraint? Units of chemical P, p = Max production, z= 90p⁰ B) What is the maximum number of units of chemical Z under the given budgetary conditions? (Round your answer to the nearest whole unit.) units
A bakery produces cakes, doughnuts and muffins. Each cake requires 30 kg of flour, 21 kg of sugar and 12 kg of butter. Each doughnut requires 14, 12 and 6 kilograms of three ingredients, respectively. Finally, each muffin requires 8, 6 and 4 kilograms of these ingredients, respectively. Putting this information into table form, we get: Q10 Flour Sugar Butter Cakes 30 21 12 Doughnuts 14 12 Muffins 4 Supplies of these ingredients vary from day to day, so the bakery needs to determine a different production run each day. If 480 kg of flour, 360 kg of sugar and 200 kg of butter are available, find the number of cakes, doughnuts and muffins to be baked that day using all suitable numerical methods. You have to explain the chosen of the method and why the other method cannot be used. Check your exact answer using scientific calculator or inverse matrix method In Microsoft Excel.
. Nutrition The following table gives the calories,fat, and carbohydrates per ounce for three brands ofcereal, as well as the total amount of calories, fat, andcarbohydrates required for a special diet. To find the number of ounces of each brand thatshould be combined to give the required totals ofcalories, fat, and carbohydrates, let x represent thenumber of ounces of All Bran, y represent thenumber of ounces of Sugar Frosted Flakes, and z represent the number of ounces of Natural Mixed Grain.a. Use the information in the table to write a systemof three equations.b. Solve the system to find the amount of each brandof cereal that will give the necessary nutrition.
E A famine relief effort is being mounted and there are three types of food bundles that can be flown out during each delivery. Bundle 1 has 4 kg. of flour, 4 kg. of sugar and 12 litres of water. Bundle 2 has 12 kg. of flour, 4 kg. of sugar and 4 litres of water and Bundle 3 has 8 kg. of flour, 8 kg. of sugar and 8 litres of water. The relief agency has 5200 kg. of flour, 3800 kg. of sugar and 6000 litres of water for each shipment. Bundle 1 can provide for 10 people between deliveries, Bundle 2 for 8 people and Bundle 3 for 11 people. How many bundles of each type should the relief agency send on each flight in order to maximize the number of people being fed. Do this problem by setting up a linear programming problem and determining the vertices of the feasibility set. Enter the number of bundles of types 1. 2, and 3 (in that order) into the answer box below, separated with commias.

SEE MORE QUESTIONS

Recommended textbooks for you

Linear Algebra: A Modern Introduction

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

Algebra for College Students

Algebra

ISBN:

9781285195780

Author:

Jerome E. Kaufmann, Karen L. Schwitters

Publisher:

Cengage Learning

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

Linear Algebra: A Modern Introduction

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

Algebra for College Students

Algebra

ISBN:

9781285195780

Author:

Jerome E. Kaufmann, Karen L. Schwitters

Publisher:

Cengage Learning

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

SEE MORE TEXTBOOKS