Formulate LP to meet the demand and mileage requirements

Assignment Help Operation Management

Reference no: EM13954273

Formulate on a spreedsheet and solve using solver, Explain formulas used in cells.

During the next two months, General Cars must meet (on time) the following dema nd for trucks and cars: month 1 – 400 trucks, 800 cars; month 2 – 300 trucks, 300 cars. During each month, at most 1000 vehicles can be produced. Each truck uses 2 tons of steel, and each car uses 1 ton of steel. During month 1, steel cost $400 per ton; during month 2, steel costs $600 per ton. At most 1500 tons of steel may be purchased at each month (steel may only be used during the month in which it is purchased). At the beginning of month 1, 100 trucks and 200 cars are in inventory. At the end of each month, a holding cost of $150 per vehicle is assessed. Each car gets 20 mpg and each truck gets 10 mpg. During each month, the vehicles produced by the company must average at least 16 mpg. Formulate an LP to meet the demand and mileage requirements at minimum cost (include steel costs and holding costs).

Reference no: EM13954273

Questions Cloud

Formulate an integer programming model for this problem : The Heartland Distribution Company is a food warehouse and distributor that has a contract with a grocery store chain in several Midwest and Southeast cities. The company wants to construct new warehouses/distribution centers in some of the cities it..

Determining the pricing decision : Caroline's Candy Corner sells gourmet chocolates. The company buys chocolates in bulk for $5 per pound plus 5% sales tax. Credit terms are 2/10, n/25, and the company always pays promptly to take advantage of the discount. The chocolates are shipp..

What is the approximate mass number of a nucleus : Determine the kinetic energy available to products of alpha decay of 235U92. b) Also find the kinetic energy of the alpha particle. The observed masses are m(235U92) = 235.04392 u and m(231Th90) = 231.03630 u.

How many strings will contain at least 6 ba s : Consider strings of length 9 with elements being a, b or c. How many strings will contain at least 6 b a?

Formulate LP to meet the demand and mileage requirements : During the next two months, General Cars must meet (on time) the following dema nd for trucks and cars: month 1 – 400 trucks, 800 cars; month 2 – 300 trucks, 300 cars. During each month, at most 1000 vehicles can be produced. Each truck uses 2 tons o..

Gross profit for a merchandiser : Emblems For You sells specialty sweatshirts. The purchase price is $10 per unit plus 10% tax and a shipping cost of 50¢ per unit. When the units arrive, they must be labeled, at an additional cost of 75¢ per unit. Emblems purchased, received, and ..

Where is the far point for that person eyes : A sample of Barium isotope has a half-life of 2.5 min and an intial activity of 10 x 10^6 Bq. What is its activity after 25 min have elapsed?

What should the ideal setup cost and setup time be now : Krupp Refrigeration, Inc., is trying to reduce inventory and wants you to install a kanban system for compressors on one of its assembly lines. Determine the size of the kanban and the number of kanbans (containers) needed. What should the ideal setu..

Give the effect in terms of increase decrease or none : Give the effect in terms of increase, decrease, or none. Part a is done as an example below to show the format used.

User Account

All Pages