REQUIRED:d. Formulate and solve a spreadsheet model for this problem.6. The Texago Corporation has four oil fields, four refineries, and four distribution centers. A majorstrike involving the transportation industries now has sharply curtailed Texago's capacity to shipoil from the oil fields to the refineries and to ship petroleum products from the refineries to thedistribution centers. Using units of thousands of barrels of crude oil (and its equivalent in refinedproducts), the following tables show the maximum number of units that can be shipped per dayfrom each oil field to each refinery and from each refinery to each distribution center.Oil FieldTexasCaliforniaAlaskaMiddle EastRefineryNew OrleansCharlestonSeattleSt. LouisNew Orleans11578Pittsburgh58412Charleston7439RefineryAtlanta97611Seattle28124Distribution CenterKansas City6979St. Louis87615San Francisco4587The Texago management now wants to determine a plan for how many units to ship from eachoil field to each refinery and from each refinery to each distribution center that will maximize thetotal number of units reaching the distribution centers.

Answered: Image /qna-images/answer/91196c18-3c73-4c2c-a3e9-7b28bcf297b2.jpg

Answered: REQUIRED: d. Formulate and solve a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section5.5: Shortest Path Models

Problem 32P

See similar textbooks

Similar questions

pls some assistance :((
Explain FIVE (5) examples of solving business problems using LinearProgramming (LP)
Ex 4.12 Formulate the linear programming model of the following problems. Titan Credit Card Marketing works for HSBC to verify and approve credit card application. TCCM receives P380 for every completed customer application. The company maintained three call agents targeting at P20,000 worth of approvals daily, altogether. In a regular working day, James can process as much as P3000 worth of applications. Mark can process twice as much as Tim. How many credit cards should each call agent process to achieve the target for the day. Formulate the LP model
Enabled: Chapter 3 Linear Program... Saved Help Sa In a transportation problem with 3 sources and 8 destinations, how many shipping lanes will exist? Shipping lanes Ne >
To finance a vacation in 4 years, Elsie saves $410 at the beginning of every six months in an account paying interest at 13% compounded semi dash annually. (a) What will be the balance in her account when she takes the vacation? (b) How much of the balance will be interest? (c) If she waits an additional year to start her vacation, and continues to save the same amount of money, how much more money does she have to spend? Question content area bottom Part 1 a) The balance in her account will be $ enter your response here. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.) Part 2 b) The amount of interest will be $ enter your response here. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.) Part 3 c) She will have an extra $ enter your response here to spend on her vacation. (Round the final answer to the nearest cent as needed. Round all…
Additional Question. The XYZ steel company must determine a policy for ordering coal to operate 15 converters. The ordering cost is $85/order and the cost of holding coal is 15% of the purchasing cost. The XYZ has a contract to obtain the coal for $14 per ton for the coming year. Each converter requires exactly 8 tons of coal per day to operate, and the firm operates 300 days per year. a. Determine the optimal quantity of coal to receive in each order. b. Determine the total inventory-related cost associated with the optimal ordering policy c. Optimal number of orders to place per year and number of operating days between orders, based on the optimal ordering. d. The XYZ is now considering to the following discount policy provided by supplier: Order Quantity (tons) 1,000 - 1,999 Price per ton $14 $12 $10 2,000 - 2,999 3000+ Please help the XYZ to determine the amount the firm should order.
Problem 16-12 (Algo) Your company assembles five different models of a motor scooter that is sold in specialty stores in the United States. The company uses the same engine for all five models. You have been given the assignment of choosing a supplier for these engines for the coming year. Due to the size of your warehouse and other administrative restrictions, you must order the engines in lot sizes of 1,350 units. Because of the unique characteristics of the engine, special tooling is needed during the manufacturing process for which you agree to reimburse the supplier. Your assistant has obtained quotes from two reliable engine suppliers and you need to decide which to use. The following data have been collected: Requirements (annual forecast) 16,200 units Weight per engine 25 pounds Order processing cost $ 150 per order Inventory carry cost 20 percent of the average value of inventory per year Note: Assume that half of lot size is in inventory on…
Problem 16-12 (Algo) Your company assembles five different models of a motor scooter that is sold in specialty stores in the United States. The company uses the same engine for all five models. You have been given the assignment of choosing a supplier for these engines for the coming year. Due to the size of your warehouse and other administrative restrictions, you must order the engines in lot sizes of 1,350 units. Because of the unique characteristics of the engine, special tooling is needed during the manufacturing process for which you agree to reimburse the supplier. Your assistant has obtained quotes from two reliable engine suppliers and you need to decide which to use. The following data have been collected: Requirements (annual forecast) 16,200 units Weight per engine 25 pounds Order processing cost $ 150 per order Inventory carry cost 20 percent of the average value of inventory per year Note: Assume that half of lot size is in inventory on…
13/ Do not solve it in excel, please.
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
Need help with sub question c, d and e.
Problem 16-12 (Algo) Your company assembles five different models of a motor scooter that is sold in specialty stores in the United States. The company uses the same engine for all five models. You have been given the assignment of choosing a supplier for these engines for the coming year. Due to the size of your warehouse and other administrative restrictions, you must order the engines In lot sizes of 700 units. Because of the unique characteristics of the engine, special tooling is needed during the manufacturing process for which you agree to reimburse the supplier. Your assistant has obtained quotes from two reliable engine suppliers and you need to decide which to use. The following data have been collected: Requirements (annual forecast) Weight per engine Order processing cost Inventory carry cost ORDER QUANTITY 1 to 1,499 units/order 1,500 to 2,999 units/order 3,000+ units/order Note: Assume that half of lot size is in Inventory on average (700/2=350 units). Two qualified…

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