Reference no: EM13832198
A food distribution company ships fresh spinach from its four packing plants to large East-coast cities. The shipping costs per crate, the supply and demand are shown in the table at the bottom of this page.
(a) Formulate a model that will permit the company to meet its demand at the lowest possible cost.
(b) The company wishes to spread out the source for each of its markets to the maximum extent possible. To accomplish this, it will accept a 5 % increase in its total transportation cost from part (a). What is the new transportation cost, and what is the new cost?
Markets
Packing
Plants Atlanta Boston Charlestown Dover Supply
Eaglestown $6.00 $7.00 $7.50 $7.50 8,000
Farrier $5.50 $5.50 $4.00 $7.00 10,000
Guyton $6.00 $5.00 $6.50 $7.00 5,000
Hayesville $7.00 $7.50 $8.50 $6.50 9,000
Demand 8,000 9,000 10,000 5,000
5-26 A trauma center keeps ambulances at locations throughout the east side of a city in an attempt to minimize the response time in the event of an emergency. The times, in minutes, from the ambulance locations to the population centers are given in the table at the top of the next column.
POPULATION
AMBULANCE
LOCATIONS EAST NORTH-EAST SOUTH-EAST CENTRAL
SITE 1 12 8 9 13
SITE 2 10 9 11 10
SITE 3 11 12 14 11
SITE 4 13 11 12 9
Find the optimal assignment of ambulances to population centers that will minimize the total emergency response time.
5-30 The city of Six Mile, South Carolina, is considering making several of its streets one-way. What is the maximum number of cars per hour that can travel from east (node 1) to west (node 8)? The network is shown below.
Solve the given problem scenario to determine the maximum number of cars per hour that can travel from east (node 1) to west (node 8) by formulating and setting up the problem in Excel Solver.
Excel should provide clearly labeled values used for the decision variables, constraints, and objective function
|
Ultradense chips for android products
: 10. "IBM is investing $3 billion in a private-public partnership with New York State, GlobalFoundries, Samsung and equipment vendors," to create ultradense computer chips (John Markoff, New York Times, July 9, 2015). TOTALLY MADE-UP SCENARIO: Suppose..
|
|
Discuss where valid instruments come from
: Discuss where valid instruments come from. Part of your explorations must deal withchecking the validity of instruments and what the consequences of weak instruments are.
|
|
Characterize the buying behavior of a business
: Describe at least 3 things that characterize the buying behavior of a business or organization. State what type of business or organization you are discussing if you are focusing on some specific organization/company
|
|
Describe the different economic trade reforms
: Describe the different economic trade reforms developed and adopted in Colombia by the Gaviria and Santos administrations. What were the advantages and disadvantages of those reforms for each time period and what did those reforms ultimately do or no..
|
|
A food distribution company ships fresh spinach
: A food distribution company ships fresh spinach from its four packing plants to large East-coast cities. The shipping costs per crate, the supply and demand are shown in the table at the bottom of this page.
|
|
Draw an er diagram
: a. Draw an ER diagram. Make sure each entity type has at least one key attribute. Document any assumptions you make. Avoid diagrams with a single entity. b. If you think the description is incomplete, list other data the database should store. c. Adj..
|
|
Highlights the important elements
: You have just completed ten (10) weeks of an introduction to networking course. Imagine your organization has asked you to create a one-day training course that highlights the important elements of what you have just learned within the past ten (10) ..
|
|
Create a database using professional principles and standard
: Create a database using professional principles and standards. Use a relational database software application to develop a database implementing the logical design into a physical design. Using Oracle database to create the normalized physical databa..
|
|
Thermal expansion among polymers is lowest in thermosets
: Thermal expansion among polymers is lowest in thermosets. Why?
|