A minimum cost flow problem will have feasible solutions as long as there is a balance between the total supply from the supply nodes and the totaldemand at the demand nodes.True or FalseTrueFalse

To determine the most affordable way to send a specific amount of flow through a flow network, one…

Answered: A minimum cost flow problem will have…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

PLEASE SHOW HOW TO DO THIS WITH EXCEL. Construct and solve a linear optimization model that defies the supply chain strategy that meets the demand of each retail outlet at minimum total shipping cost.
The accompanying table shows a bookstore's estimated demand for a new calendar. The bookstore needs to decide whether to order100, 200, or 300 calendars for the start of the year. Each calendar costs the store$5 to purchase and can be sold for $13. The store can sell any unsold calendars back to its supplier for $3 each. Determine the number of calendars the bookstore should order to maximize its expected monetary value. Demand Probability 100 0.35 200 0.25 300 0.40 The bookstore should order---------calendars in order to have the maximum expected monetary value of $----- (Type a whole number.)
Mark has a company that produces tables and chairs, both having two different models. The product models and related information are given in the following table. Wood costs 3000 $ per cubic meter and 200 m3 of wood are available for the upcoming month. The cost of labor is 40 $/hour and there are 6000 hours of labor available in a month. Mark sells his products to a big chain retail company. The company purchases all products whatever Mark produces. Mark formulates an LP as follows to determine the optimal monthly production plan such that he maximizes the total profit. Decision Variables: X1 : number of basic tables to be produced. X2 : number of elegant tables to be produced. X3 : number of basic chairs to be produced. X4 :number of elegant chairs to be produced. Max Z = 140 X1 + 345 X2 + 120 X3 + 260 X4 ( maximize total profit) Subject to 0.11 X1 + 0.13 X2 + 0.06 X3 + 0.07 X4 ≤ 200 (constraint on the available amount of wood) 2 X1 + 4.5 X2 + 1.5 X3 + 4 X4 ≤ 6000…
A store is offering a discount on 800 pairs of basketball shoes in Singapore. Theamount of the discount varies and is not revealed to the customer until checkout. Thefollowing table shows the potential areas for home delivery service covered by eachstore. (Refer to the attached picture below) Formulate an integer programming model that could be used to find the minimumnumber of stores to open in order to cover customers of all areas for the homedelivery service.
Electrolux, a French company is planning to move the assembly of its refrigerators from France to Mexico. It takes 3 hours of labor to assemble a refrigerator, both in France and Mexico. Hourly labor rate in France is $ 25. Hourly labor rate in Mexico is $ 5. Holding cost in France per refrigerator per week is $ 2. In Mexico this is $ 1.5. In France orders are placed with factory weekly with lead time of 3 weeks. In Mexico orders are placed with factory weekly with lead time of 15 weeks. Weekly demand is 400 refrigerators with standard deviation of 100. It operates with in stock probability of 0.99 ( z = 2.33) What would be the change in total holding and labor cost per refrigerator by moving assembly from France to Mexico ? Show all formulas used, 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…
for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands) depends on demand as follows. DEMAND STAFFING OPTIONS HIGH MEDIUM LOW Own Staff 650 650 600 Outside Vendor 900 600 300 Combination 800 650 500 Based on decision analysis under uncertainty, determine the best decision each of the model. Then compare all the model decision to make it overall conclusion.
Refer to the Factory-to-Six-Customers problem and start with the original information. Each customer increases demand by 1000 units. This increased demand has to be met. Re-calculate the optimal solution. At the new solution, which of the following statements is true? A. The total shipping costs are $252,900 B. Quantity shipped from Factory 1 to Customer 1 declines by 6000 units C. Both A and B D. Neither A nor
ABC enterprises supply a single product from its two warehouses to three of its customers. The supplies at the warehouses are 120 and 150 units, respectively. The customer demands are 70, 80, and 100 units respectively. The cost of shipping one unit from warehouse i to customer j is as per the following price schedule. Quantity Price Per Unit 0 -25 10$ 25-50 8$ Above 50 6$ For example: If 60 units are being shipped on a particular route, the first 25 units will be charged at the rate of 10 per unit. Similarly, the next 25 units will be charged $8 per unit and the rest at $6 per unit. Develop a linear integer programming model to determine the optimal shipment plan.
1. At the beginning of each semester, BOOKY can order 60, 80, or 100 copies of the book from the publisher, each with differing discounts per book. The ordering costs are listed in the following table. Number of Books Ordered 60 80 100 Ordering Costs 6100 7700 9100 2. BOOKY can either sell the book at the retail price ($130 per copy) or offer a 10% discount ($117 per copy). The demand distributions under different selling prices are listed in the following tables. The demand distribution for the textbook when the selling price is $130 per copy. Demand Probability 70 0.6 90 0.4 The demand distribution for the textbook when the selling price is $117 per copy. Demand Probability 80 0.15 100 0.85 3. Any unmet demand for the textbook will be irrecoverable There are two decision variables in this decision problem: the ordering quantity and the selling price of the textbook. a) If BOOKY is allowed to return unsold textbooks to the publisher for a refund of…
Box Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost = $24,975 Material cost per unit = $0.17 Labor cost per unit = $0.12 Revenue per unit = $0.66 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Box Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Maximization of Profit (Graphical Method) The Mariposa Furniture makes two products: tables and chairs, which must be processed through assembly and finishing departments. Assembly department is available for 60 hours in every production period, while the finishing department is available for 48 hours of work. Manufacturing one table requires 4 hours in the assembly and 2 hours in the finishing. Each chair requires 2 hours in the assembly and 4 hours in the finishing. One table contributes P180 to profit, while a chair contributes P100. The problem is to determine the number of tables and chairs to make per production period in order to maximize the profit. What is the profit? Minimization of Profit (Graphical Method) An animal food producer mixes two types of animal food: x and y. each unit of x costs P100 and contains 40 grams of fat, 20 grams of protein and 1,600 calories. Each unit of y cost P80 and contains 60 grams of fat, 60 grams of protein and 1,200 calories. Suppose…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

A minimum cost flow problem will have feasible solutions as long as there is a balance between the total supply from the supply nodes and the total demand at the demand nodes. True or False True False