Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need GAMS CODES Use GAMS to solve the following problem (If you cannot solve it completely, you can send the parts you can solve

I need GAMS CODES

image text in transcribed

Use GAMS to solve the following problem (If you cannot solve it completely, you can send the parts you can solve as an answer.) I need GAMS CODES not only answer Tata company produces parts for cars. Metal sub-industry parts are produced in a total of 3 Tata factories. For this production, the remaining 10.000.000 lb of iron raw material available to the company will be used. The company will either sell the iron as raw material, either as rebar or as part of the car. Unused iron raw materials will be sold for 700$ (thousand lb) as raw material, and for 850 dollars as rebar after being shaped. The cost of forming iron is $180 per thousand lb of iron. To meet the demand, a minimum of 500.000 lb of rebar must be sold, with 700.000 lb of raw material iron. Different production methods are used in each of these factories. As a result of these methods, each factory will produce 2 products with different quality and efficiency (Product1, Product2). The methods differ between the total costs of the products, their selling prices and how many lb of transactions they are obtained from. In Factory 1, 10 lb of iron is used for each kg of product. Factory 2 spends 12 lb, and Factory 3 spends 15 lb of iron per lb product. Each product has a minimum quantity that must be sold. These are: Product1120.000 units, Product21 20.000 units, Product12 15.000 units, Product22 15.000 units, Product13 10.000 units, Product23 10.000 units. The company's fixed annual costs are 200.000$. If the product production is 100.000 units or less, an additional 3-year total cost will be 350.000$. When the number of products is between 100.000 and 400.000, there will be a cost of 570.000$, and when more than 400.000 units 700.000$ will be incurred due to more factory activities. The sales prices of the products also vary according to the retail wholesale quantity (k: thousand units). Factory Product Product21 Costs If sales 13$ 14$ 8$ (0-2k) If sales 12$ 13$ 8$ (2-10k) Factory2 Product12 Product22 Costs If sales 14.5$ 15.5$ 9.5$ (0-2k) If sales 14$ 15$ 9.5$ (2-10k) Factory Producti3 Product23 Costs If sales 17.5$ 18$ 11$ (0-2k) If sales 16$ 16$ 11$ (2-10k) Tata wants to get rid of all iron within 3 years by subjecting the iron to these processes. 2 different logistics warehouses with equal capacity and cost rented for the products produced. As long as the Tata company has the product, these warehouses will be paid a monthly rent of 80$ per thousand lbs. Monthly demand amounts for products are shown in the table. For example, if the sales in the first year meet the demand for 3 years, only one month's rent will be paid. Stock table Demand of Product23 Cost Demand of Product11 20.000 60.000 100.00 Demand of Product21 20.000 60.000 100.000 Demand of Product12 15.000 50.000 75.000 Demand of Product22 15.000 50.000 75.000 Demand of Product 13 10.000 30.000 50.000 Year 1 Year 2 Year 3 10.000 30.000 50.000 How much of which product, raw material, rebar should the Tata company sell in order to maximize its income? Solve it in the Gams program

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

13th Edition Global Edition

1292263350, 978-1292263359

More Books

Students also viewed these Databases questions

Question

What challenges does GE have to face in the HRM field today?

Answered: 1 week ago