A company has three warehouses that supply four stores with a given product. Each warehouse has 30 units of the product. Stores 1, 2, 3, and 4 require 20, 25, 30, and 35 units of the product, respectively. The per unit shipping costs from each warehouse to each store are given in the following table. (Let Xij represent the number of units that flow from warehouse i to store j for i = 1, 2, 3 and j = 1, 2, 3, 4.)   Store Warehouse 1 2 3 4 1 7 6 7 6 2 4 7 6 5 3 6 4 4 4 Solve the problem using Solver. Caution: You should note that the amount of supply at the warehouses is less than the amount of demand at the stores. You will need to address this when structuring the flow balance constraints. (Hint: You want to ship everything from the warehouses even though there will be a demand shortage at the stores). (X11, X12, X13, X14, X21, X22, X23, X24, X31, X32, X33, X34) = ( ??? ) What is the optimal solution to the modified problem? (X11, X12, X13, X14, X21, X22, X23, X24, X31, X32, X33, X34) = ( ??? )

Answer correctly using excel and show workings

Facility Location. A paper products manufacturer has enough capital to build and manage some additional manufacturing plants in the United States in order to meet increased demand in three cities: New York City, NY; Los Angeles, CA; and Topeka, KS. The company is considering building in Denver, CO; Seattle, WA; and St. Louis, MO. Max Operating Capacity 400 tons/day 700 tons/day Denver Seattle $10/ton $17/tor $5/ton $11/ton.... $18/ton.... $28/ton Los Angeles Topeka New York City Figure 1: Graphical representation of the given data = • The cost fi of building plants in these cities is fi $10,000,000 in Seattle. Unmet Demand 300 tons/day 100 tons/day 500 tons/day • Due to geographic constraints, plants in Denver and Seattle would have a maximum operating capacity kį of 400 tons/day and 700 tons/day respectively. $5,000,000 in Denver and f2 = • The cost cij per ton of transporting paper from city i to city j is outlined in Figure 1. • The unmet demand d, for Los Angeles, Topeka, and New…

Pete Morton is planning to go to graduate school in a program of study that will take three years. Pete wants to have $13,000 available each year for various school and living expenses. If he earns 8 percent on his money, how much must be deposited at the start of his studies to be able to withdraw $13,000 a year for three years? (Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D)

excel format and show steps

Sherwin Williams is one of the largest paint manufacturers in the world. They sell their interior house paint for residential consumers in their own stores as well as consumers can order them online for pickup at their local Sherwin Williams store. Benjamin Moore is another large paint manufacturer in North America and they sell their interior house paint for residential consumers through a network of over 7,500 independent paint and hardware stores. Sherwin Williams uses a/an while Benjamin Moore uses a/an O a. corporate vertical marketing system; conventional distribution channel O b. conventional distribution channel; corporate vertical marketing system C. corporate vertical marketing system; direct distribution channel O d. contractual vertical marketing system; conventional distribution channel O e. None of the above Clear my choice

NOTE: The answer of this question should be limited to ONE page of writing with reasonable size of fonts. The provincial government plans to distribute certain types of vaccines to the 3 major urban centers of the province covering a large portion of the provincial population. The 5 million doses of vaccines are expected to arrive in large batches at one of the major cargo airports by 2 military transporter airplanes in a single day. The vaccines will then be distributed to the 3 cities with the number of doses corresponding to the population sizes of the 3 cities. They will be further distributed to the 20 hospitals and about 200 local clinics in these 3 cities. Officials of the provincial health agency must plan for the upcoming vaccine distribution. Assume that you are asked to suggest several methods/tools in Industrial Engineering and Operations Research you have learned from this course. Present 3 such methods and for EACH of these methods, briefly explain: 6.1) For solving which…

As part of a campaign to promote its annual clearance sale, Excelsior Company decided to buy television advertising time on Station KAOS. Excelsior's television advertising budget is $111,000. Morning time costs $3000/min, afternoon time costs $1000/min, and evening (prime) time costs $12,000/min. Because of previous commitments, KAOS cannot offer Excelsior more than 6 min of prime time or more than a total of 25 min of advertising time over the 2 weeks in which the commercials are to be run. KAOS estimates that morning commercials are seen by 200,000 people, afternoon commercials are seen by 100,000 people, and evening commercials are seen by 600,000 people. How much morning, afternoon, and evening advertising time should Excelsior buy to maximize exposure of its commercials? morning      min afternoon      min evening      min

b) The Scott Tractor Company ships tractor parts from Omaha to St. Louis by railroad. However, a contract limits the number of railroad cars the company can secure on each branch/arc during a week. Given these limiting conditions, the company wants to know the maximum number of railroad cars containing tractor parts that can be shipped from Omaha to St. Louis during a week. Phoenix Des Moines 3 5 6. 6. 1. Dallas 2 Omaha St. Louis 7. 3 Denver 6. ActivateW O 31°C

The Metropolitan Bus Company (MBC) purchases diesel fuel from American Petroleum Supply. In addition to the fuel cost, American Petroleum Supply charges MBC $250 per order to cover the expenses of delivering and transferring the fuel to MBC’s storage tanks. The lead time for a new shipment from American Petroleum is 10 days; the cost of holding a gallon of fuel in the storage tanks is $0.04 per month, or $0.48 per year; and the annual fuel usage is 150,000 gallons. MBC buses operate 300 days a year.   a. What is the optimal order quantity for MBC? b. How frequently should MBC order to replenish the gasoline quantity? c. What is the reorder point?