3.A company is considering opening warehouses in four cities: New York, Los Angeles, Chicago, andAtlanta. Each warehouse can ship 100 units per week. The weekly fixed cost of keeping each warehouseopen is $400 for New York, $500 for Los Angeles, $300 for Chicago, and $150 for Atlanta. Region 1 ofthe country requires 80 units per week, region 2 requires 70 units per week, and region 3 requires 40units per week. The costs (including production and shipping costs) of sending one unit from a plantto a region are shown in Table 3. We want to meet weekly demands at minimum cost, subject to thepreceding information and the following restrictions:1.If the New York warehouse is opened, then the Los Angeles warehouse must be opened.2.At most two warehouses can be opened.3.Either the Atlanta or the Los Angeles warehouse must be opened.Formulate an IP that can be used to minimize the weekly costs of meeting demand.Table 3To ($)FromRegion 1Region 2Region 3New York204050Los Angeles481526Chicago263518Atlanta245035

Answered: Image /qna-images/answer/08c33697-5953-43f3-ab80-04aaec2b7b93.jpg

80 units per week, region 2 requires 70 units per week, and region 3 req costs (including production and shipping costs) of sending one unit from in Table 3. We want to meet weekly demands at minimum cost, subjec n and the following restrictions: w York warehouse is opened, then the Los Angeles warehouse must be two warehouses can be opened. e Atlanta or the Los Angeles warehouse must be opened. can be used to minimize the weekly costs of meeting demand.

80 units per week, region 2 requires 70 units per week, and region 3 req costs (including production and shipping costs) of sending one unit from in Table 3. We want to meet weekly demands at minimum cost, subjec n and the following restrictions: w York warehouse is opened, then the Los Angeles warehouse must be two warehouses can be opened. e Atlanta or the Los Angeles warehouse must be opened. can be used to minimize the weekly costs of meeting demand.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Consider the following maximum-claim reusable resource system with processes ahd three resource…

A: We are given maximum allocation matrix and current allocation matrix. We are going to find out if…

Q: There are 5 cities in a network named A, B,C, D, E and the possible direct flights (legs) between…

A: Actually, given information is 5cities named A,B,C,D,E,

Q: After the San Onofre Nuclear Generating Station (SONGS) closed in 2012, the Diablo Canyon Power…

A: 1. Diablo canyon have two nuclear reactor which are capable of producing 1100 MW each. The average…

Q: Problem#4 21. Ready for College? The ACT is a college entrance exam. In NW addition to administering…

A: To analyze the data using the p-value approach and determine if there is evidence that students who…

Q: For the next four months, the following demands are expected: 500, 650, 1000 and 700 units. Unit…

A: Steps to be followed: 1. Arrange the data in tabulated form: Month 1 2 3 4…

Q: Which of the following constraints correctly describe this requirement: The management also requires…

A: Given The answer is given below.

Q: Consider the classical assignment problem: n jobs should be assigned to 12 people, one job per…

A: Solution to task Assignment Problem : Person 'a' do Job2: 3 Person 'b' do Job1: 6 Person 'c' do…

Q: Will the solution be different if we use <= for the first three constraints? MIN: 21X14+ 50X15+…

A: The problem is based on the basics of optimisation problems in computer science.

Q: Three refineries with daily capacities of 6, 5, and 8 million gallons, respectively, supplythree…

A: a. Transportation Model:Z= 18x11+ 18x12+ 30x21+ 80x22+ 90x23+ 22x31+ 20x32 + 12x33 Subject to x11+…

Q: For the next four months, the following demands are expected: 500, 650, 1000 and 700 units. Unit…

A: Step a. Consider the production plan of a manufacturing unit to meet customers’ demands with minimum…

Q: Question A .A mortgage pass-through security (PT) has a par value of $100,000, a 4% coupon paid…

A: In this scenario, you are dealing with a mortgage pass-through security (PT) with specific…

Q: You need to buy a new cell phone now, and are trying to minimize your cell phone costs for the next…

A: The solution is discussed in the below step

Q: National Disc Corp. produces the discs used in producing Xbox and PlayStation discs. Their local…

A: Answer is in next step.

Q: PROBLEM 2 Professor Weejohs teaches two sections of business analytics, which combined will result…

Q: Yuckdonald's is considering opening a series of restaurants along Quaint Valley Highway (QVH). The n…

A: The question asks for an efficient algorithm to determine the maximum total profit Yuckdonald's can…

Question

3.
A company is considering opening warehouses in four cities: New York, Los Angeles, Chicago, and
Atlanta. Each warehouse can ship 100 units per week. The weekly fixed cost of keeping each warehouse
open is $400 for New York, $500 for Los Angeles, $300 for Chicago, and $150 for Atlanta. Region 1 of
the country requires 80 units per week, region 2 requires 70 units per week, and region 3 requires 40
units per week. The costs (including production and shipping costs) of sending one unit from a plant
to a region are shown in Table 3. We want to meet weekly demands at minimum cost, subject to the
preceding information and the following restrictions:
1.
If the New York warehouse is opened, then the Los Angeles warehouse must be opened.
2.
At most two warehouses can be opened.
3.
Either the Atlanta or the Los Angeles warehouse must be opened.
Formulate an IP that can be used to minimize the weekly costs of meeting demand.
Table 3
To ($)
From
Region 1
Region 2
Region 3
New York
20
40
50
Los Angeles
48
15
26
Chicago
26
35
18
Atlanta
24
50
35

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Trending now

This is a popular solution!

Step by step

Solved in 6 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Problem 1. (Lee's Barber shop). Lee operates a barber shop. Today, five customers made reservation as below and they will arrive the barber shop sharply. Lee is the only barber, so if Lee is busy that customers will wait in the waiting area. First come first service policy will be observed. Customer Wayne Beckham Potter Rogers Owen Reservation Time 12:05PM 12:12PM 12:15PM 12:25PM 12:45PM Q1-1. Draw the number of customers in the waiting line over an hour (from 12PM to 1PM). Q1-2. Fill out the following 10 blanks. Customer Waiting Time Service Time (Duration) 15 mins 12 mins 8 mins 15 mins 5 mins Wayne Beckham Potter Rogers Owen Q1-3. What are the average waiting time and the average system time? Q1-4. What are the average queue length and Lee's utilization? 1 System Time
Solve it on excel
Ridgley Custom Metal Products (RCMP) must purchase a new tube bender. RCMP's MARR is 12 percent. RCMP can forecast demand for its products for only 4 years in advance. The salvage value after 4 years is $50,000 for model T, $85,000 for model A and $75,000 for model X. Using the study period method, which of the three alternatives is best? Salvage Value $50.000 Yearly Net Savings $55.000 $50.000 $65.000 Model First Cost Economic Life $100,000 $140,000 $190,000 4 years 4 years A $85,000 $75,000 4 years Click the icon to view the table of compound interest factors for discrete compounding periods when i= 12%. The present worth of Model T is $. The present worth of Model A is $ The present worth of Model X is $. Model V is the better choice to buy. (Round to the nearest cent as needed.)
Arthur Ross, Inc., must complete many corporate tax returns during the period February 15 to April 15. This year, the company must begin and complete the five jobs shown in the file P06_79.xlsx during this eight-week period. Arthur Ross employs four full-time accountants who normally work 40 hours per week. If necessary, however, they can work up to 20 hours of overtime per week for which they are paid $100 per hour. Determine how the company can minimize the overtime cost incurred in completing all jobs by April 15.
Suppose that each firm in a perfectly competitive market has a cost of TC = 75 + 500Q - 5Q2 + 0.5Q3 Determine if this is a short-run or long-run cost function (motivate):
Portfolio manager Max Gaines needs to develop an investment portfolio for his clients who are willing to accept a moderate amount of risk. His task is to determine the proportion of the portfolio to invest in each of the five mutual funds listed below so that the portfolio maximizes the expected return but provides an annual return of no less than 3%. for each of the following scenarios. Annual Returns (Planning Scenarios): mutual fund yr 1 yr 2 yr 3 yr 4 international stock 22.37 26.73 6.46 -3.19 low-cap blend 14.88 18.61 10.52 5.25 mid-cap blend 19.45 18.04 5.91 -1.94 small-cap blend 13.79 11.33 -2.07 6.85 intermediate bond 7.29 8.05 9.18 3.92 Formulate the appropriate linear program for this situation. (state the objective function, the decision variables, and the constraints)
2.