A contractor, Susan Meyer, has to haul gravel to three buildings.She can buy up to 18 tons from a quarry located to the north ofthe city and 14 tons from one to the south. She needs 10, 5 and10 tons in the respective constructions 1, 2 and 3. The purchaseprice per ton in each quarry and the haulage costs are as follows:QuarryNorthSouth$$1Cost per ton hauled2100 $180 $3Price per ton300$42090 $160110 $ 140 $Susan wants to determine how much to haul from each quarryto each construction so that the total cost of purchasing andhauling the gravel is minimized.Solve using Excel Solver step by step.

Linear programming (LP) is a mathematical optimization technique that helps solve problems where an…

Answered: Susan wants to determine how much to…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

please see images
The first station can process a unit in 10 minutes First Station capacity = 60/10 = 6 units per hour As the second station has 2 identical machines in parallel, each of which can process a unit in 12 minutes. Each unit needs to be processed on one of the two machines. Second Station Capacity = 60 x 2/12 = 10 units per hour The third station can process a unit in 8 minutes Third Station capacity = 60/8 = 7.5 units per hour What is the hourly capacity of this production line?
Zucchero Sugar, Inc. has six processing departments for refining sugar—Affination, Carbonation, Decolorization, Boiling, Recovery, and Packaging. Conversion costs are added evenly throughout each process. Data from the month of August for the Recovery Department are as follows: Metric Tons Beginning Work−in−Process Inventory 0 Transferred in 22,000 Ending Work−in−Process Inventory 6,000 Costs Beginning Work−in−Process Inventory $0 Costs added during August : Direct materials 530,000 Direct labor 250,000 Manufacturing overhead 105,000 Total costs added during August $885,000 The ending Work−in−Process Inventory is 100% and 95% complete with respect to direct materials and conversion costs, respectively. The weighted−average method is used. How many metric tons of sugar were refined and transferred to the Packaging Department in August? A. 6,000 metric tons B.…
Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 650 small cars, at least 500 medium cars, and at least 650 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? Fred Motors packages Admiral Motors packages Chrysalis packages What will be the total cost?$
Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 550 small cars, at least 500 medium cars, and at least 550 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? |packages | packages |packages Fred Motors Admiral Motors Chrysalis What will be the total cost? 2$
A linear programming computer package is needed. Kilgore's Deli is a small delicatessen located near a major university. Kilgore does a large walk-in carry-out lunch business. The deli offers two luncheon chili specials, Wimpy and Dial 911. At the beginning of the day, Kilgore needs to decide how much of each special to make (he always sells out of whatever he makes). The profit on one serving of Wimpy is $0.46, on one serving of Dial 911, $0.59. Each serving of Wimpy requires 0.25 pound of beef, 0.25 cup of onions, and 5 ounces of Kilgore's special sauce. Each serving of Dial 911 requires 0.25 pound of beef, 0.4 cup of onions, 2 ounces of Kilgore's special sauce, and 5 ounces of hot sauce. Today, Kilgore has 18 pounds of beef, 13 cups of onions, 86 ounces of Kilgore's special sauce, and 58 ounces of hot sauce on hand. (a) Develop an LP model that will tell Kilgore how many servings of Wimpy and Dial 911 to make in order to maximize his profit today. (Let W = the number of servings of…
A custom motor cycle shop is experiencing high demand from its customers for its services. The owner performs all tasks relating to customization. Assume each customer brings one motor cycle for customization. The owner needs to determine if he needs to add more help to meet customer demand. A week has 40 hours (maximum amount of time available for the owner to work) . The maximum number of customizations that can be done per week is 8 bikes ( if there is no wasted time ). The following is the data collected from observations for a typical week: Every Friday the shop is cleaned by the owner. This takes 5 hours 15 % of the customization needs rework which takes 75 % more time than regular customization 15 % of the customers will be called by the owner to reschedule completion by the owner. This takes 2 hours per customer. Determine OEE. How should the owner handle the business ? Show all formulas, calculations and results.
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…
Using Goal Seek for the following problem, how much is needed for John to deposit each year into an account to save $5,000 for his new Specialized Mountain bike. Assumes both deposit and withdrawal are at beg of each year Deposit = Interest= Yr 0 Yr 1 Yr 2 Beg Balance $0.00 $0.00 $0.00 Deposit $0.00 $0.00 -$5,000.00 Interest Earned 8% $0.00 $0.00 na End Balance $0.00 $0.00 -$5,000.00
Please do not give solution in image formate thanku.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Susan wants to determine how much to haul from each quarry to each construction so that the total cost of purchasing and hauling the gravel is minimized. Solve using Excel Solver step by step.