An automobile manufacturer makes three types of vehicles: Cars, Trucks, and SUVs. Each Car produced requires...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An automobile manufacturer makes three types of vehicles: Cars, Trucks, and SUVs. Each Car produced requires 1 ton of steel and gets 20 miles per gallon (MPG). Each Truck requires 3 tons of steel and gets 12 mpg. Each SUV requires 2 tons of steel and gets 17 mpg. The manufacturer must determine a production plan for these three types of vehicles for each of the next three months. In Month 1, steel is expected to cost $700 per ton. In Month 2, steel is expected to cost $800. In Month 3, steel is expected to cost $850 per ton. Steel must be used in the month is is purchased. A maximum of 175 tons of steel is available for purchase each month. At the beginning of Month 1 there 15 Cars, 15 Trucks and O SUVs in inventory. In Month 1, there is a demand for 60 Cars, 20 Trucks and 40 SUVs. Any vehicles unsold in Month 1 may be used to meet demand in Month 2. Any vehicles remaining after meeting demand in Month 1 will be held in inventory at a cost of $200 per vehicle. In Month 2, there is a demand for 40 Cars, 30 Trucks, and 20 SUVs. Any vehicles remaining after meeting demand in Month 2 can be used to meet demand in Month 3, at an inventory cost of $200 per vehicle. In Month 3, there is a demand for 40 cars, 25 Trucks, and 45 SUVs. A maximum of 100 vehicles may be produced in a single month. Industry standards require that the average gas mileage of all vehicles produced in a given month should be at least 17 mpg. Only whole vehicles can be sold, so use a constraint to prevent fractional values in your solution. Build a linear programming model to determine how to minimize the total cost (production + inventory cost) while meeting demands, and staying within the requirements of available material (steel), production limits, and a gas mileage considerations. Cars Trucks SUVs Inventory Cars Trucks SUVs Max Production Steel Req'd per vehicle 1 3 2 Month 1 15 15 0 100 MPG 20 12 17 vehicles per month Demands Cars Trucks SUVs Month 1 60 20 40 Month 2 40 30 20 Month 3 40 25 45 An automobile manufacturer makes three types of vehicles: Cars, Trucks, and SUVs. Each Car produced requires 1 ton of steel and gets 20 miles per gallon (MPG). Each Truck requires 3 tons of steel and gets 12 mpg. Each SUV requires 2 tons of steel and gets 17 mpg. The manufacturer must determine a production plan for these three types of vehicles for each of the next three months. In Month 1, steel is expected to cost $700 per ton. In Month 2, steel is expected to cost $800. In Month 3, steel is expected to cost $850 per ton. Steel must be used in the month is is purchased. A maximum of 175 tons of steel is available for purchase each month. At the beginning of Month 1 there 15 Cars, 15 Trucks and O SUVs in inventory. In Month 1, there is a demand for 60 Cars, 20 Trucks and 40 SUVs. Any vehicles unsold in Month 1 may be used to meet demand in Month 2. Any vehicles remaining after meeting demand in Month 1 will be held in inventory at a cost of $200 per vehicle. In Month 2, there is a demand for 40 Cars, 30 Trucks, and 20 SUVs. Any vehicles remaining after meeting demand in Month 2 can be used to meet demand in Month 3, at an inventory cost of $200 per vehicle. In Month 3, there is a demand for 40 cars, 25 Trucks, and 45 SUVs. A maximum of 100 vehicles may be produced in a single month. Industry standards require that the average gas mileage of all vehicles produced in a given month should be at least 17 mpg. Only whole vehicles can be sold, so use a constraint to prevent fractional values in your solution. Build a linear programming model to determine how to minimize the total cost (production + inventory cost) while meeting demands, and staying within the requirements of available material (steel), production limits, and a gas mileage considerations. Cars Trucks SUVs Inventory Cars Trucks SUVs Max Production Steel Req'd per vehicle 1 3 2 Month 1 15 15 0 100 MPG 20 12 17 vehicles per month Demands Cars Trucks SUVs Month 1 60 20 40 Month 2 40 30 20 Month 3 40 25 45
Expert Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
The Janie Gioffre Drapery Company makes three types of draperies at two different locations. At location I, it can make 10 pairs of deluxe drapes, 20 pairs of better drapes, and 13 pairs of standard...
-
A small candy store makes three types of party mixes. The first type contains 40% nonpareils and 60% peanut clusters, while the second type contains 30% peanut clusters and 70% chocolate-covered...
-
A new manufacturing machine is expected to cost $286,000, have an eight-year life, and a $30,000 salvage value . The machine will yield an annual incremental after-tax income of $35,000 after...
-
Stanley, Inc. issues 15-year $1,000 bonds that pay $85 annually. The market price for the bonds is $960. Your required rate of return is 9 percent.
-
Determine the actual annual interest rate on a $40,000 line of credit with an annual percentage rate of 12% compounded monthly. The bank requires that a 10% compensating balance be placed in an...
-
The following is a draft set of simplified financial statements for Pear Limited for the year ended 30 September 2018: The following information is available: 1. Depreciation has not been charged on...
-
Early Start Bakery mass-produces bread using three sequential processing departments: Mixing, Baking, and Packaging. The following transactions occurred during February: Requirements: 1. Post each of...
-
Fresh orange juice contains 12.0 wt% solids and the balance water, and concentrated orange juice contains 42.0 wt% solids. Initially a single evaporation process was used for the concentration, but...
-
What piece of hardware connects a peripheral device like a keyboard or mouse to the system bus? 1 point a device driver a device controller a semaphore a network port
-
The box plot below shows the amount spent for books and supplies per year by students at four year public colleges. a. Estimate the median amount spent. b. Estimate the first and third quartiles for...
-
If you were working as a Probation Officer or Parole Officer, how would you handle the issue of controlled drug usage with your clients, keeping in mind that you are an agent of the provincial...
-
While helping an astronomy professor, you discover a binary star system in which the two stars are in circular orbits about the system's center of mass. From their color and brightness, you determine...
-
An attractive central force exerted on a particle of mass \(m\) causes the particle to travel in a bound orbit. The orbit is clliptical with semimajor axis \(a\), and the force has magnitude...
-
Which of the following statements is false? a. If an intangible asset has a finite life, it should be amortized. b. The amortization period of an intangible asset can exceed 20 years. c. Goodwill is...
-
A meteoroid passes through a position in space where its speed is very small relative to Earth's and it is at a perpendicular distance of 19 Earth radii above Earth's surface. The meteoroid is moving...
-
A space probe can be either launched at escape speed from Earth or transported to a "parking orbit" above Earth and then launched. (a) If the parking orbit is \(180 \mathrm{~km}\) above Earth's...
-
A manufacturing plant produces two types of widgets: standard model; deluxe model. Each unit requires the use of direct labor and the labor time per unit differs between models. Manufacturing is done...
-
Suppose the index goes to 18 percent in year 5. What is the effective cost of the unrestricted ARM?
-
Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using Solver Table and allowing the initial inventory to vary from 0...
-
Ford is going to produce a new vehicle, the Pioneer, and wants to determine the amount of annual capacity it should build. Fords goal is to maximize the profit from this vehicle over the next 10...
-
A sample of 15 quality control managers with more than 20 years experience have an average salary of $68,000 and a sample standard deviation of $19,000. a. You can be 95% confident that the mean...
-
Milj-Spe AS produces two joint products, cooking oil and soap oil, from a single vegetable oil refining process. In July 2022, the joint costs of this process were NOK 24 000 000. Separable...
-
Galinha-Esquina SA grows and processes chickens. Each chicken is disassembled into five main parts. Information pertaining to production in July 2022 is as follows: Joint costs of production in July...
-
Claude Deux-Bussy is the owner and operator of Boissons Barbe-Bleue Sarl, a bulk soft-drink producer. A single production process yields two bulk soft drinks, Pellas (the main product) and Mlisande...
Study smarter with the SolutionInn App