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.

Reviews

Write a Review

Operation Management Questions & Answers

  Describe your role as an employee of an organization

describe your role as an employee of an organization in the IS field. Give examples of what you need to know about information systems and how it can help with your job performance?

  Regarding the master production schedule

Which of the following statements is best regarding the master production schedule?

  Organization to purchase a new piece of technology

How would you react to a physician who wants the organization to purchase a new piece of technology that the competing hospital already has so he can bring his patients to your hospital rather than to the competition? What factors would you consider ..

  How samsung could benefit from the intensive strategies

describe in detail how Samsung could benefit from the intensive strategies it has not implemented. Include at least one advantage and one disadvantages of each strategy.

  The annual demand for a product has been projected

The annual demand for a product has been projected at 2,000 units. This demand is assumed to be constant throughout the year. The ordering cost is $20 per order

  Component procurement process

Discuss any issues you experienced (delays, availability, etc.) or recommendations you may have with the component procurement process.

  Difference between regional and global products

What are some examples of regional products? What are some examples of truly global products? Is there a fundamental difference between regional and global products?

  Unethical marketing practices of the employer

An employer fires an employee in an employment-at-will state. The employee knows that the termination was not discriminatory but is concerned that the termination might have had to do with his outspoken nature about what he deemed to be unethical mar..

  Which technology has improved emergency management

While it is easy to see the ways in which technology has improved emergency management, it has also introduced some challenges. What is one specific challenge you believe technology has posed for emergency management? How can that challenge be overco..

  Success of the new learning management system

Update the proposal to include the types of quantitative analysis that will be utilized to measure the success of the new learning management system. Cite at least one source where quantitative analysis was used in project management.

  Cooperation with the organization''s other disciplines

Human resources has been asked to put a plan together in cooperation with the organization's other disciplines (finance or accounting, administration, operations, customer service, marketing, and so on) for a four percent staff reduction.

  Planning and the types and models of training

Explain the Balance Scorecard and metrics drawn from this to create a metric for training. Explain the connection between staffing and human resource planning and the types and models of training that may be required.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd